source: quests/ExportSql.php_ s prázdnymi texty@ 5

Last change on this file since 5 was 5, checked in by george, 18 years ago

import
File size: 4.5 KB
Line 
1<?php
2 session_start();
3
4 include 'DatabaseConection.php';
5 $Database = new Database('localhost','root','');
6 $Database->SelectDatabase('Quests');
7
8 function test_sql($teststring){
9 $teststring=StrTr($teststring, "áäèïéìëíòóöøšúùüýžÁÄÈÏÉÌËÍÒÓÖ؊ÚÙÜݎ", "aacdeeeinoorstuuuyzAACDEEEINOORSTUUUYZ");
10
11 return mysql_escape_string($teststring);
12 }
13
14
15 include 'panel.php';
16
17
18 if (@$_SESSION['Licence'] <> 1) {
19 die('Nemáte oprávnìní vztupovat zde!');
20 }
21
22if (array_key_exists('Export', $_GET)) {
23
24 Echo 'Vytváøím Export: ';
25 $Soubor = fopen('SQLCzQuests.sql', 'w');
26 fputs($Soubor,'
27/* File made by maron web aplikacion
28 =================================
29
30 WebProject: http://wow.zdechov.net/quests/
31 email: maron2@cetrum.cz
32 DateExport: '.date("m.d.y H:i").' */
33
34 USE `mangos`;
35
36 ');
37
38 $ID = $Database->SQLCommand("SELECT * FROM czquests WHERE state = '2'");
39 while ($Line = mysql_fetch_array($ID)) {
40 $entry = test_sql($Line['entry']);
41 $Title = test_sql($Line['Title']);
42 $Details = test_sql($Line['Details']);
43 $Objectives = test_sql($Line['Objectives']);
44 $OfferRewardText = test_sql($Line['OfferRewardText']);
45 $RequestItemsText = test_sql($Line['RequestItemsText']);
46 // echo $entry.$Details;
47 // UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
48 fputs($Soubor,"UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry';
49 ");
50 }
51 fclose($Soubor);
52
53 echo '<b>Hotovo</b><br />';
54
55}
56
57if (array_key_exists('game', $_GET)) {
58
59 echo 'Vytváøím zálohu mangos Q textù: ';
60
61 $Soubor = fopen('c:/zaloha/MangosQTexts/'.date("m-d-y H-i").'.sql', 'w');
62 fputs($Soubor,'
63/* File made by maron web aplikacion
64 =================================
65
66 resource Mangos texts
67
68 WebProject: http://wow.zdechov.net/quests/
69 email: maron2@cetrum.cz
70 DateExport: '.date("m.d.y H:i").' */
71
72 USE `mangos`;
73
74 ');
75
76 $Database->SelectDatabase('Mangos');
77 $ID = $Database->SQLCommand("SELECT * FROM quest_template");
78 while ($Line = mysql_fetch_array($ID)) {
79 $entry = test_sql($Line['entry']);
80 $Title = test_sql($Line['Title']);
81 $Details = test_sql($Line['Details']);
82 $Objectives = test_sql($Line['Objectives']);
83 $OfferRewardText = test_sql($Line['OfferRewardText']);
84 $RequestItemsText = test_sql($Line['RequestItemsText']);
85 // UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
86 fputs($Soubor,"UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry';
87 ");
88 }
89 fclose($Soubor);
90 echo '<b>Hotovo</b><br />';
91
92 Echo 'Importuju do Mangos Databáze: ';
93 $Database->SelectDatabase('Quests');
94 $ID = $Database->SQLCommand("SELECT * FROM czquests WHERE state = '2'");
95 $Database->SelectDatabase('Mangos');
96 while ($Line = mysql_fetch_array($ID)) {
97 $entry = test_sql($Line['entry']);
98 $Title = test_sql($Line['Title']);
99 $Details = test_sql($Line['Details']);
100 $Objectives = test_sql($Line['Objectives']);
101 $OfferRewardText = test_sql($Line['OfferRewardText']);
102 $RequestItemsText = test_sql($Line['RequestItemsText']);
103 // UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
104 $Database->SQLCommand("UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry'");
105 // echo "UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry'";
106 }
107
108 echo '<b>Hotovo</b><br />';
109}
110 // TODO:vkládat do mangos databáze
111
112?>
113 <a href="exportsql.php?Export">Export SQL</a><br />
114 <a href="exportsql.php?Game">Import do hry</a>
115
Note: See TracBrowser for help on using the repository browser.