Takze tohle je prvni stranka. Neni to automaticke ale podle ACC se da zjistit panak ktereho lze nadobro smazat pomoci tohodle.
Funguje to tak ze se to ulozi jako napr.. mazani.php a a do adresy se napise http://localhost/mazani.php?guid=a cislo panaka ktereho chcem smazat.....
<?php
// Pripojeni k DB
$sDBServer = "localhost"; // Server
$sDBUser = "root"; // Uzivatelske jmeno
$sDBPassword = "root"; // Heslo k Databazi
$sDBDatabase = "mangos"; // Databaze
// Pripojime DB
mysql_connect($sDBServer, $sDBUser, $sDBPassword) or die("Nelze se prihlasit na MySQL: ". mysql_errno());
mysql_selectdb($sDBDatabase) or die("Neexistuje databaze '$sDBDatabase'!");
// Zkontrolujeme jestli byl predan parametr guid v GETu
if (isset($_GET["guid"]) && is_numeric($_GET["guid"]) && $_GET["guid"] > 0)
{
// Vypiseme jakou postavu mazeme
$sSQL = "SELECT name FROM `character` WHERE guid=$_GET[guid]";
$aRS = mysql_query($sSQL);
$aRow = mysql_fetch_assoc($aRS);
echo "Odstraneni postavy '$aRow[name]' z databaze.<br><br><br>\n";
// Pole s nazvama tabulek ktery obsahujou GUI jako ID polozku
$aTabulky1 = array("character", "character_action", "character_aura", "character_homebind",
"character_inventory", "character_kill", "character_pet", "character_queststatus",
"character_reputation", "character_social", "character_spell", "character_spell_cooldown",
"character_ticket", "guild_member");
// Prosvistime si tabulky a smazeme vsechny zaznamy s danym GUID
foreach($aTabulky1 as $sTabulka)
{
$sSQL = "DELETE FROM `$sTabulka` WHERE guid=$_GET[guid]";
echo "Mazu data z tabulky '$sTabulka'<br>\n";
mysql_query($sSQL);
}
// "character_stable"
$sSQL = "DELETE FROM `character_stable` WHERE owner=$_GET[guid]";
echo "Mazu data z tabulky 'character_stable'<br>\n";
mysql_query($sSQL);
// "mail"
$sSQL = "DELETE FROM `mail` WHERE sender=$_GET[guid]";
echo "Mazu data z tabulky 'mail'<br>\n";
mysql_query($sSQL);
$sSQL = "DELETE FROM `mail` WHERE reciver=$_GET[guid]";
echo "Mazu data z tabulky 'mail'<br>\n";
mysql_query($sSQL);
// "guild"
// Napred smazeme vsechny cleny jejimz je mazany leaderem
$sSQL = "DELETE FROM `guild_member` WHERE guildid IN (SELECT guildid FROM `guild` WHERE leaderguid=$_GET[guid])";
echo "Mazu cleny guildy ve ktere je postava Leaderem.<br>\n";
mysql_query($sSQL);
$sSQL = "DELETE FROM `guild` WHERE leaderguid=$_GET[guid]";
echo "Mazu data z tabulky 'guild'<br>\n";
mysql_query($sSQL);
// "guild_charter"
$sSQL = "DELETE FROM `guild_charter` WHERE ownerguid=$_GET[guid]";
echo "Mazu data z tabulky 'guild_charter'<br>\n";
mysql_query($sSQL);
// "guild_charter_sign"
$sSQL = "DELETE FROM `guild_charter_sign` WHERE ownerguid=$_GET[guid]";
echo "Mazu data z tabulky 'guild_charter_sign'<br>\n";
mysql_query($sSQL);
}
else
{
echo "Nespravny parametr predaneho ID!!";
}
?>
Good Luck
Upozorneni maze to i leadera guildy pokud ten koho mazem nepreda leadra jinemu tak se automaticky odstrani vsichni clenove guildy z members....