1 | <?php
|
---|
2 |
|
---|
3 | include('includes/global.php');
|
---|
4 |
|
---|
5 | include 'includes/zip.lib.php';
|
---|
6 |
|
---|
7 | function WithOutDiacritical($teststring){
|
---|
8 | $teststring=StrTr($teststring, "áäèïéìëíòóöø»úùüý¾ÁÄÈÏÉÌËÍÒÓÖØ©«ÚÙÜÝ®", "aacdeeeinoorstuuuyzAACDEEEINOORSTUUUYZ");
|
---|
9 |
|
---|
10 | return $teststring;
|
---|
11 | }
|
---|
12 |
|
---|
13 | if (array_key_exists('Type', $_GET)) {
|
---|
14 | $Diacritical = @$_GET['Diacritical'];
|
---|
15 | if (array_key_exists('CZ', $_GET)) $CZ = $_GET['CZ'];
|
---|
16 | if (array_key_exists('SK', $_GET)) $SK = $_GET['SK'];
|
---|
17 | if (array_key_exists('OtherLanguage', $_GET)) $OtherLanguage = $_GET['OtherLanguage'];
|
---|
18 | if (array_key_exists('Use', $_GET)) $Use = $_GET['Use'];
|
---|
19 | $Type = $_GET['Type'];
|
---|
20 | $Export = $_GET['Export'];
|
---|
21 | $AddTitle = $_GET['AddTitle'];
|
---|
22 | $NumberVote = $_GET['NumberVote'];
|
---|
23 | $Vote = $_GET['Vote'];
|
---|
24 |
|
---|
25 | $AddDetails = @$_GET['AddDetails'];
|
---|
26 | $AddObjectives = @$_GET['AddObjectives'];
|
---|
27 | $AddOfferRewardText = @$_GET['AddOfferRewardText'];
|
---|
28 | $AddRequestItemsText = @$_GET['AddRequestItemsText'];
|
---|
29 | $AddEndText = @$_GET['AddEndText'];
|
---|
30 | $AddObjectiveText1 = @$_GET['AddObjectiveText1'];
|
---|
31 | $AddObjectiveText2 = @$_GET['AddObjectiveText2'];
|
---|
32 | $AddObjectiveText3 = @$_GET['AddObjectiveText3'];
|
---|
33 | $AddObjectiveText4 = @$_GET['AddObjectiveText4'];
|
---|
34 |
|
---|
35 | if (($Export == 'Mangos') and (Licence(1) == False)) {die('Nemáte oprávnìní');}
|
---|
36 |
|
---|
37 |
|
---|
38 | $Buffer = '
|
---|
39 | /* File made by maron web aplikacion
|
---|
40 | =================================
|
---|
41 |
|
---|
42 | WebProject: http://wow.zdechov.net/quests/
|
---|
43 | email: maron2@cetrum.cz
|
---|
44 | DateExport: '.date("m.d.y H:i").' */
|
---|
45 |
|
---|
46 | ';
|
---|
47 |
|
---|
48 | if (isset($Use)) $Buffer .= 'USE `mangos`;
|
---|
49 |
|
---|
50 | ';
|
---|
51 |
|
---|
52 | $sql = "SELECT * FROM quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
|
---|
53 | $Where = '';
|
---|
54 | if (isset($CZ)) $Where .= " Language = '1'";
|
---|
55 | if (isset($SK)) {
|
---|
56 | if ($Where <> '')
|
---|
57 | $Where .= " OR Language = '2'";
|
---|
58 | else
|
---|
59 | $Where .= "Language = '2'";
|
---|
60 | }
|
---|
61 | if (isset($OtherLanguage)) {
|
---|
62 | if ($Where <> '')
|
---|
63 | $Where .= " OR Language = '3'";
|
---|
64 | else
|
---|
65 | $Where .= "Language = '3'";
|
---|
66 | }
|
---|
67 | if ($Where <> "") $sql .= " AND ($Where)";
|
---|
68 |
|
---|
69 | $ID = $Database->SQLCommand($sql." ORDER BY vote");
|
---|
70 | while ($Line = mysql_fetch_array($ID)) {
|
---|
71 | $entry = $Line['entry'];
|
---|
72 | $Title = mysql_escape_string($Line['Title']);
|
---|
73 | $Details = mysql_escape_string($Line['Details']);
|
---|
74 | $Objectives = mysql_escape_string($Line['Objectives']);
|
---|
75 | $OfferRewardText = mysql_escape_string($Line['OfferRewardText']);
|
---|
76 | $RequestItemsText = mysql_escape_string($Line['RequestItemsText']);
|
---|
77 | $EndText = mysql_escape_string($Line['EndText']);
|
---|
78 | $ObjectiveText1 = mysql_escape_string($Line['ObjectiveText1']);
|
---|
79 | $ObjectiveText2 = mysql_escape_string($Line['ObjectiveText2']);
|
---|
80 | $ObjectiveText3 = mysql_escape_string($Line['ObjectiveText3']);
|
---|
81 | $ObjectiveText4 = mysql_escape_string($Line['ObjectiveText4']);
|
---|
82 |
|
---|
83 | if ($AddTitle == 'Translate')
|
---|
84 | $Title = "Title = '$Title'";
|
---|
85 | else {
|
---|
86 | $IDtitle = $Database->SQLCommand("SELECT Title FROM quests WHERE entry = '$entry' AND Language = '0'");
|
---|
87 | $Linetitle = mysql_fetch_array($IDtitle);
|
---|
88 |
|
---|
89 | if ($AddTitle == 'EN') {
|
---|
90 | $Title = "Title = '".$Linetitle['Title']."'";
|
---|
91 | }
|
---|
92 | if ($AddTitle == 'Both') {
|
---|
93 | $Title = "Title = '$Title (".$Linetitle['Title'].")'";
|
---|
94 | }
|
---|
95 | }
|
---|
96 | if (($Details <> '') and ($AddDetails))
|
---|
97 | $Details = "Details = '$Details', ";
|
---|
98 | else $Details = '';
|
---|
99 | if ($Objectives <> '' and $AddObjectives)
|
---|
100 | $Objectives = 'Objectives = \''.$Objectives.'\', ';
|
---|
101 | else $Objectives= '';
|
---|
102 | if ($OfferRewardText <> '' and $AddOfferRewardText)
|
---|
103 | $OfferRewardText = 'OfferRewardText = \''.$OfferRewardText.'\', ';
|
---|
104 | else $OfferRewardText = '';
|
---|
105 | if ($RequestItemsText <> '' and $AddRequestItemsText)
|
---|
106 | $RequestItemsText = 'RequestItemsText = \''.$RequestItemsText.'\', ';
|
---|
107 | else $RequestItemsText = '';
|
---|
108 | // echo $entry.$Details;
|
---|
109 | // UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
|
---|
110 | $sql = "UPDATE quest_template SET $Details $Objectives $OfferRewardText $RequestItemsText $Title WHERE entry = '$entry';";
|
---|
111 | if ($Diacritical == False) $sql=WithOutDiacritical($sql);
|
---|
112 |
|
---|
113 | $Database->SelectDatabase($Config['Database']['DatabaseMangos']);
|
---|
114 | if ($Export == 'Mangos')
|
---|
115 | $Database->SQLCommand($sql);
|
---|
116 |
|
---|
117 | $Buffer .= $sql."
|
---|
118 | ";
|
---|
119 |
|
---|
120 | }
|
---|
121 |
|
---|
122 | if ($Export == 'Display') {
|
---|
123 | echo '<textarea rows="30" cols="100">';
|
---|
124 | echo $Buffer;
|
---|
125 | echo '</textarea>';
|
---|
126 | }
|
---|
127 | if ($Export == 'Mangos') {
|
---|
128 | echo 'Hotovo';
|
---|
129 | }
|
---|
130 |
|
---|
131 | if ($Export == 'Zip') {
|
---|
132 | if (@function_exists('gzcompress')) {
|
---|
133 | $save_filename = 'SqlTranslate.zip';
|
---|
134 | $SQL_filename = 'SqlTranslate.sql';
|
---|
135 |
|
---|
136 | $zipfile = new zipfile();
|
---|
137 | $zipfile -> addFile($Buffer, $SQL_filename);
|
---|
138 | $Buffer = $zipfile -> file();
|
---|
139 |
|
---|
140 | $file_handle = @fopen($save_filename, 'w');
|
---|
141 | $write_result = @fwrite($file_handle, $Buffer);
|
---|
142 | fclose($file_handle);
|
---|
143 | header("Location: ".$save_filename);
|
---|
144 |
|
---|
145 | } echo 'vyskytla se chyba!';
|
---|
146 | }
|
---|
147 |
|
---|
148 | WriteLog('Sta¾ení SQL souboru: Export: '.$Export.' Diakritika: '.$Diacritical, 2);
|
---|
149 |
|
---|
150 |
|
---|
151 | } else {
|
---|
152 | ?>
|
---|
153 | <div style=" border: 2px dotted black; padding: 0px 5px 5px 5px;">
|
---|
154 | <big><b><i>Pro server:</b></i></big><br>
|
---|
155 | <b>Export Questù:</b><br />
|
---|
156 | <form action="export.php" method="get">
|
---|
157 | <table border="1">
|
---|
158 | <tr><th>Sql</th><th>Jazyk</th><th>Texty</th></tr>
|
---|
159 | <tr><td>
|
---|
160 | <input type="radio" name="Export" value="Zip" checked="true"> Exportovat do zip<br>
|
---|
161 | <input type="radio" name="Export" value="Display"> Export zobrazit<br>
|
---|
162 | <?php
|
---|
163 | if (Licence(1)) {
|
---|
164 | echo '<input type="radio" name="Export" value="Mangos"> Import na server<br>';
|
---|
165 | }
|
---|
166 | ?>
|
---|
167 | <br />
|
---|
168 | <input type="radio" name="Type" value="Insert"> Insert (zatím nefunguje)<br>
|
---|
169 | <input type="radio" name="Type" value="Update" checked="true"> Update <br>
|
---|
170 | <br />
|
---|
171 | <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br>
|
---|
172 | <br />
|
---|
173 | <b>Filtr:</b><br />
|
---|
174 | <input type="text" name="NumberVote" value="4" size="1"> Poèet nutných hlasù <br>
|
---|
175 | <input type="text" name="Vote" value="3" size="1"> Známka lep¹í jak
|
---|
176 | </td><td>
|
---|
177 | <input type="checkbox" name="Diacritical" checked="true"> Vèetnì diakritiky <br>
|
---|
178 | <br />
|
---|
179 | <input type="checkbox" name="CZ" checked="true"> Èeský pøeklad <br>
|
---|
180 | <input type="checkbox" name="SK" checked="true"> Slovenský pøeklad <br>
|
---|
181 | <input type="checkbox" name="OtherLanguage"> Jiné jazyky <br>
|
---|
182 | </td><td>
|
---|
183 | <b>Title questu:</b><br>
|
---|
184 | <input type="radio" name="AddTitle" value="Translate" checked="true"> Pøelo¾ený název <br>
|
---|
185 | <input type="radio" name="AddTitle" value="EN"> Pùvodní název <br>
|
---|
186 | <input type="radio" name="AddTitle" value="Both"> Pøelo¾ený název (Anglický název) <br>
|
---|
187 | <br>
|
---|
188 | <?php
|
---|
189 | foreach($Texts as $Index => $TextItem)
|
---|
190 | echo '<input type="checkbox" name="Add'.$TextItem[0].'" checked="true"> '.$TextItem[0].'<br>';
|
---|
191 | ?>
|
---|
192 | </td></tr>
|
---|
193 | </table>
|
---|
194 | <br><input type="submit" value="Generovat"> SQL soubor (Sta¾ení)
|
---|
195 | </form>
|
---|
196 | <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />
|
---|
197 | - Stránky projektu: <a href="http://sourceforge.net/projects/mmfpm/">http://sourceforge.net/projects/mmfpm/</a><br>
|
---|
198 | - Pøeklad: <a href="http://wow.zdechov.net/minimanager/lang/csCZ.zip">Èe¹tina do minimanageru</a><br>
|
---|
199 | - Diskusní forum pro pøípadné pøipomínky: <a href="http://wow.zdechov.net/forum/viewtopic.php?p=5533">Forum</a>
|
---|
200 |
|
---|
201 | </div>
|
---|
202 | <br>
|
---|
203 | <div style=" border: 2px dotted black; padding: 0px 5px 5px 5px;">
|
---|
204 | <big><b><i>Pro klinta:</b></i></big><br>
|
---|
205 | <b>Diakritika ve World of Warcraft</b><br />
|
---|
206 | - Pro správné zobrazování diakrity ve høe si stáhnìte <a href="http://wow.zdechov.net/download_soubory/ceske_fonty_do_wow.zip">Èeské fonty do hry</a><br />
|
---|
207 | </div>
|
---|
208 | <?php
|
---|
209 | }
|
---|
210 |
|
---|
211 |
|
---|
212 | ShowFooter();
|
---|
213 | ?>
|
---|