source: quests/export.php@ 238

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

Přidání logu, oprava exportu

File size: 8.6 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', $_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?>
Note: See TracBrowser for help on using the repository browser.