SelectDatabase('Quests');
function test_sql($teststring){
$teststring=StrTr($teststring, "áäčďéěëíňóöřúůüýÁÄČĎÉĚËÍŇÓÖŘÚŮÜÝ", "aacdeeeinoorstuuuyzAACDEEEINOORSTUUUYZ");
return mysql_escape_string($teststring);
}
include 'panel.php';
if (@$_SESSION['Licence'] <> 1) {
die('Nemáte oprávnění vztupovat zde!');
}
if (array_key_exists('Export', $_GET)) {
Echo 'Vytvářím Export: ';
$Soubor = fopen('SQLCzQuests.sql', 'w');
fputs($Soubor,'
/* File made by maron web aplikacion
=================================
WebProject: http://wow.zdechov.net/quests/
email: maron2@cetrum.cz
DateExport: '.date("m.d.y H:i").' */
USE `mangos`;
');
$ID = $Database->SQLCommand("SELECT * FROM czquests WHERE state = '2'");
while ($Line = mysql_fetch_array($ID)) {
$entry = test_sql($Line['entry']);
$Title = test_sql($Line['Title']);
$Details = test_sql($Line['Details']);
$Objectives = test_sql($Line['Objectives']);
$OfferRewardText = test_sql($Line['OfferRewardText']);
$RequestItemsText = test_sql($Line['RequestItemsText']);
// echo $entry.$Details;
// UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
fputs($Soubor,"UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry';
");
}
fclose($Soubor);
echo 'Hotovo
';
}
if (array_key_exists('game', $_GET)) {
echo 'Vytvářím zálohu mangos Q textů: ';
$Soubor = fopen('c:/zaloha/MangosQTexts/'.date("m-d-y H-i").'.sql', 'w');
fputs($Soubor,'
/* File made by maron web aplikacion
=================================
resource Mangos texts
WebProject: http://wow.zdechov.net/quests/
email: maron2@cetrum.cz
DateExport: '.date("m.d.y H:i").' */
USE `mangos`;
');
$Database->SelectDatabase('Mangos');
$ID = $Database->SQLCommand("SELECT * FROM quest_template");
while ($Line = mysql_fetch_array($ID)) {
$entry = test_sql($Line['entry']);
$Title = test_sql($Line['Title']);
$Details = test_sql($Line['Details']);
$Objectives = test_sql($Line['Objectives']);
$OfferRewardText = test_sql($Line['OfferRewardText']);
$RequestItemsText = test_sql($Line['RequestItemsText']);
// UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
fputs($Soubor,"UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry';
");
}
fclose($Soubor);
echo 'Hotovo
';
Echo 'Importuju do Mangos Databáze: ';
$Database->SelectDatabase('Quests');
$ID = $Database->SQLCommand("SELECT * FROM czquests WHERE state = '2'");
$Database->SelectDatabase('Mangos');
while ($Line = mysql_fetch_array($ID)) {
$entry = test_sql($Line['entry']);
$Title = test_sql($Line['Title']);
$Details = test_sql($Line['Details']);
$Objectives = test_sql($Line['Objectives']);
$OfferRewardText = test_sql($Line['OfferRewardText']);
$RequestItemsText = test_sql($Line['RequestItemsText']);
// UPDATE SET Title = '', Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHWRE entry = '$entry'
$Database->SQLCommand("UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry'");
// echo "UPDATE quest_template SET Title = '$Title', Details = '$Details', Objectives = '$Objectives', OfferRewardText = '$OfferRewardText', RequestItemsText = '$RequestItemsText' WHERE entry = '$entry'";
}
echo 'Hotovo
';
}
// TODO:vkládat do mangos databáze
?>
Export SQL
Import do hry