source: quests/export.php@ 241

Last change on this file since 241 was 241, checked in by maron, 17 years ago

Export pouze od určitých uživatelů
File size: 9.5 KB
Line 
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', $_POST)) {
14 $Diacritical = @$_POST['Diacritical'];
15 if (array_key_exists('CZ', $_POST)) $CZ = $_POST['CZ'];
16 if (array_key_exists('SK', $_POST)) $SK = $_POST['SK'];
17 if (array_key_exists('OtherLanguage', $_POST)) $OtherLanguage = $_POST['OtherLanguage'];
18 if (array_key_exists('Use', $_POST)) $Use = $_POST['Use'];
19 $Type = $_POST['Type'];
20 $Export = $_POST['Export'];
21 $AddTitle = $_POST['AddTitle'];
22 $NumberVote = $_POST['NumberVote'];
23 $Vote = $_POST['Vote'];
24 $users = @$_POST['users'];
25
26
27 $AddDetails = @$_POST['AddDetails'];
28 $AddObjectives = @$_POST['AddObjectives'];
29 $AddOfferRewardText = @$_POST['AddOfferRewardText'];
30 $AddRequestItemsText = @$_POST['AddRequestItemsText'];
31 $AddEndText = @$_POST['AddEndText'];
32 $AddObjectiveText1 = @$_POST['AddObjectiveText1'];
33 $AddObjectiveText2 = @$_POST['AddObjectiveText2'];
34 $AddObjectiveText3 = @$_POST['AddObjectiveText3'];
35 $AddObjectiveText4 = @$_POST['AddObjectiveText4'];
36
37 if (($Export == 'Mangos') and (Licence(1) == False)) {die('Nemáte oprávnìní');}
38
39
40 $Buffer = '
41/* File made by maron web aplikacion
42 =================================
43
44 WebProject: http://wow.zdechov.net/quests/
45 email: maron2@cetrum.cz
46 DateExport: '.date("m.d.y H:i").' */
47
48 ';
49
50 if (isset($Use)) $Buffer .= 'USE `mangos`;
51
52 ';
53
54 $sql = "SELECT * FROM quests.quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
55 $WhereLang = '';
56 if (isset($CZ)) $WhereLang .= " Language = '1'";
57 if (isset($SK)) {
58 if ($WhereLang <> '')
59 $WhereLang .= " OR Language = '2'";
60 else
61 $WhereLang .= "Language = '2'";
62 }
63 if (isset($OtherLanguage)) {
64 if ($WhereLang <> '')
65 $WhereLang .= " OR Language = '3'";
66 else
67 $WhereLang .= "Language = '3'";
68 }
69
70 $WhereUsers = '';
71
72 for ($i=0; $i<Count($users); $i++):
73 if ($WhereUsers <> '')
74 $WhereUsers .= " OR User = ".$users[$i];
75 else
76 $WhereUsers .= " User = ".$users[$i];
77 endfor;
78
79 if ($WhereLang <> '') $sql .= " AND ($WhereLang)";
80 if ($WhereUsers <> '') $sql .= "AND ($WhereUsers)";
81
82 echo $sql;
83
84
85 $ID = $Database->SQLCommand($sql." ORDER BY vote");
86 while ($Line = mysql_fetch_array($ID)) {
87 $entry = $Line['entry'];
88 $Title = mysql_escape_string($Line['Title']);
89 $Details = mysql_escape_string($Line['Details']);
90 $Objectives = mysql_escape_string($Line['Objectives']);
91 $OfferRewardText = mysql_escape_string($Line['OfferRewardText']);
92 $RequestItemsText = mysql_escape_string($Line['RequestItemsText']);
93 $EndText = mysql_escape_string($Line['EndText']);
94 $ObjectiveText1 = mysql_escape_string($Line['ObjectiveText1']);
95 $ObjectiveText2 = mysql_escape_string($Line['ObjectiveText2']);
96 $ObjectiveText3 = mysql_escape_string($Line['ObjectiveText3']);
97 $ObjectiveText4 = mysql_escape_string($Line['ObjectiveText4']);
98
99 if ($AddTitle == 'Translate')
100 $Title = "Title = '$Title'";
101 else {
102 $IDtitle = $Database->SQLCommand("SELECT Title FROM quests.quests WHERE entry = '$entry' AND Language = '0'");
103 $Linetitle = mysql_fetch_array($IDtitle);
104
105 if ($AddTitle == 'EN') {
106 $Title = "Title = '".$Linetitle['Title']."'";
107 }
108 if ($AddTitle == 'Both') {
109 $Title = "Title = '$Title (".$Linetitle['Title'].")'";
110 }
111 }
112 if (($Details <> '') and ($AddDetails))
113 $Details = "Details = '$Details', ";
114 else $Details = '';
115 if ($Objectives <> '' and $AddObjectives)
116 $Objectives = 'Objectives = \''.$Objectives.'\', ';
117 else $Objectives= '';
118 if ($OfferRewardText <> '' and $AddOfferRewardText)
119 $OfferRewardText = 'OfferRewardText = \''.$OfferRewardText.'\', ';
120 else $OfferRewardText = '';
121 if ($RequestItemsText <> '' and $AddRequestItemsText)
122 $RequestItemsText = 'RequestItemsText = \''.$RequestItemsText.'\', ';
123 else $RequestItemsText = '';
124 // echo $entry.$Details;
125 // UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
126 $sql = "UPDATE quest_template SET $Details $Objectives $OfferRewardText $RequestItemsText $Title WHERE entry = '$entry';";
127 if ($Diacritical == False) $sql=WithOutDiacritical($sql);
128
129 if ($Export == 'Mangos') {
130 $Database->SelectDatabase($Config['Database']['DatabaseMangos']);
131 $Database->SQLCommand($sql);
132 }
133 $Buffer .= $sql."
134 ";
135
136 }
137
138 if ($Export == 'Display') {
139 echo '<textarea rows="30" cols="100">';
140 echo $Buffer;
141 echo '</textarea>';
142 }
143 if ($Export == 'Mangos') {
144 echo 'Hotovo';
145 }
146
147 if ($Export == 'Zip') {
148 if (@function_exists('gzcompress')) {
149 $save_filename = 'SqlTranslate.zip';
150 $SQL_filename = 'SqlTranslate.sql';
151
152 $zipfile = new zipfile();
153 $zipfile -> addFile($Buffer, $SQL_filename);
154 $Buffer = $zipfile -> file();
155
156 $file_handle = @fopen($save_filename, 'w');
157 $write_result = @fwrite($file_handle, $Buffer);
158 fclose($file_handle);
159 header("Location: ".$save_filename);
160
161 } echo 'vyskytla se chyba!';
162 }
163
164 WriteLog('Sta¾ení SQL souboru: Export: '.$Export.' Diakritika: '.$Diacritical, 2);
165
166
167} else {
168?>
169<div style=" border: 2px dotted black; padding: 0px 5px 5px 5px;">
170 <big><b><i>Pro server:</b></i></big><br>
171 <b>Export Questù:</b><br />
172 <form action="export.php" method="POST">
173 <table border="1" cellpadding="1" cellspacing="0">
174 <tr><th>Sql</th><th>Filtr</th><th>Jazyk</th><th>Texty</th></tr>
175 <tr><td>
176 <input type="radio" name="Export" value="Zip" checked="true"> Exportovat do zip<br>
177 <input type="radio" name="Export" value="Display"> Export zobrazit<br>
178<?php
179 if (Licence(1)) {
180 echo '<input type="radio" name="Export" value="Mangos"> Import na server<br>';
181 }
182?>
183 <br />
184 <input type="radio" name="Type" value="Insert"> Insert (zatím nefunguje)<br>
185 <input type="radio" name="Type" value="Update" checked="true"> Update <br>
186 <br />
187 <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br>
188 <br />
189 </td><td>
190 &nbsp;<input type="text" name="NumberVote" value="3" size="1"> Poèet nutných hlasù <br>
191 &nbsp;<input type="text" name="Vote" value="4" size="1"> Známka lep¹í nebo stejná jak <br>
192
193 &nbsp;<select name="users[]" size="7" multiple>
194
195<?php
196// multiple="multiple"
197 $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
198 while ($Line = mysql_fetch_array($ID))
199 echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
200
201?>
202
203 </select><br>&nbsp; Exportovat pouze od tìchto u¾ivatalù
204
205
206 </td><td>
207 <input type="checkbox" name="Diacritical" checked="true"> Vèetnì diakritiky <br>
208 <br />
209 <input type="checkbox" name="CZ" checked="true"> Èeský pøeklad <br>
210 <input type="checkbox" name="SK" checked="true"> Slovenský pøeklad <br>
211 <input type="checkbox" name="OtherLanguage"> Jiné jazyky <br>
212 </td><td>
213 <b>Title questu:</b><br>
214 <input type="radio" name="AddTitle" value="Translate" checked="true"> Pøelo¾ený název <br>
215 <input type="radio" name="AddTitle" value="EN"> Pùvodní název <br>
216 <input type="radio" name="AddTitle" value="Both"> Pøelo¾ený název (Anglický název) <br>
217 <br>
218<?php
219 foreach($Texts as $Index => $TextItem)
220 echo '<input type="checkbox" name="Add'.$TextItem[0].'" checked="true"> '.$TextItem[0].'<br>';
221?>
222 </td></tr>
223 </table>
224 <br><input type="submit" value="Generovat"> SQL soubor Questù (Sta¾ení)
225 </form>
226 <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />
227 - Stránky projektu: <a href="http://sourceforge.net/projects/mmfpm/">http://sourceforge.net/projects/mmfpm/</a><br>
228 - Pøeklad: <a href="http://wow.zdechov.net/minimanager/lang/csCZ.zip">Èe¹tina do minimanageru</a><br>
229 - Diskusní forum pro pøípadné pøipomínky k pøekladu: <a href="http://wow.zdechov.net/forum/viewtopic.php?p=5533">Forum</a>
230
231</div>
232<br>
233<div style=" border: 2px dotted black; padding: 0px 5px 5px 5px;">
234 <big><b><i>Pro klinta:</b></i></big><br>
235 <b>Diakritika ve World of Warcraft</b><br />
236 - 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 />
237</div>
238<?php
239}
240
241
242 ShowFooter();
243?>
Note: See TracBrowser for help on using the repository browser.