AID = 253 user account delete Script

[rntpwn1212]

Too many are trying to clean up the account.

[MentaL]

[Vusion]

I guess you want to delete accounts with UGradeID = 253?

<?php
$q = mssql_query("SELECT AID,Name FROM Account WHERE UGradeID = 253");

while($fetch = mssql_fetch_array($q))
{
$cid_q = mssql_query("SELECT CID FROM Character WHERE AID = ".$fetch['AID']."");
$cid = mssql_result($q, 0, 'CID');
$delete = mssql_query("DELETE FROM CharacterItem WHERE CID = ".$cid."");
$delete2 = mssql_query("DELETE FROM ClanMember WHERE CID = ".$cid."");
$clid_q = mssql_query("SELECT CLID FROM Clan WHERE MasterCID = ".$cid."");
$clid = mssql_result($clid_q, 0, 'CLID');
$delete3 = mssql_query("DELETE FROM ClanMember WHERE CLID = ".$clid."");
$delete4 = mssql_query("DELETE FROM Clan WHERE MasterCID = ".$cid."");
$delete5 = mssql_query("DELETE FROM Character WHERE AID = ".$fetch['aid']."");
$delete6 = mssql_query("DELETE FROM AccountItem WHERE AID = ".$fetch['AID']."");
$delete7 = mssql_query("DELETE FROM Login WHERE AID = ".$fetch['AID']."");
$delete8 = mssql_query("DELETE FROM Account WHERE AID = ".$fetch['AID'."");
echo "Deleted UserID: ".$fetch['Name']."";
}
?>

For whoever knows PHP, I know this sucks.

[rntpwn1212]

I guess you want to delete accounts with UGradeID = 253?

<?php
$q = mssql_query("SELECT AID,Name FROM Account WHERE UGradeID = 253");

while($fetch = mssql_fetch_array($q))
{
$cid_q = mssql_query("SELECT CID FROM Character WHERE AID = ".$fetch['AID']."");
$cid = mssql_result($q, 0, 'CID');
$delete = mssql_query("DELETE FROM CharacterItem WHERE CID = ".$cid."");
$delete2 = mssql_query("DELETE FROM ClanMember WHERE CID = ".$cid."");
$clid_q = mssql_query("SELECT CLID FROM Clan WHERE MasterCID = ".$cid."");
$clid = mssql_result($clid_q, 0, 'CLID');
$delete3 = mssql_query("DELETE FROM ClanMember WHERE CLID = ".$clid."");
$delete4 = mssql_query("DELETE FROM Clan WHERE MasterCID = ".$cid."");
$delete5 = mssql_query("DELETE FROM Character WHERE AID = ".$fetch['aid']."");
$delete6 = mssql_query("DELETE FROM AccountItem WHERE AID = ".$fetch['AID']."");
$delete7 = mssql_query("DELETE FROM Login WHERE AID = ".$fetch['AID']."");
$delete8 = mssql_query("DELETE FROM Account WHERE AID = ".$fetch['AID'."");
echo "Deleted UserID: ".$fetch['Name']."";
}
?>

For whoever knows PHP, I know this sucks.

hmm...

Parse error: syntax error, unexpected ')', expecting ']' in C:\APM_Setup\htdocs\del\index.php on line 24

[Vusion]

<?php
$q = mssql_query("SELECT AID,Name FROM Account WHERE UGradeID = 253");

while($fetch = mssql_fetch_array($q))
{
	$cid_q = mssql_query("SELECT CID FROM Character WHERE AID = ".$fetch['AID']."");
	$cid = mssql_result($q, 0, 'CID');
	$delete = mssql_query("DELETE FROM CharacterItem WHERE CID = ".$cid."");
	$delete2 = mssql_query("DELETE FROM ClanMember WHERE CID = ".$cid."");
	$clid_q = mssql_query("SELECT CLID FROM Clan WHERE MasterCID = ".$cid."");
	$clid = mssql_result($clid_q, 0, 'CLID');
	$delete3 = mssql_query("DELETE FROM ClanMember WHERE CLID = ".$clid."");
	$delete4 = mssql_query("DELETE FROM Clan WHERE MasterCID = ".$cid."");
	$delete5 = mssql_query("DELETE FROM Character WHERE AID = ".$fetch['AID']."");
	$delete6 = mssql_query("DELETE FROM AccountItem WHERE AID = ".$fetch['AID']."");
	$delete7 = mssql_query("DELETE FROM Login WHERE AID = ".$fetch['AID']."");
	$delete8 = mssql_query("DELETE FROM Account WHERE AID = ".$fetch['AID']."");
	echo "Deleted UserID: ".$fetch['Name']."";
}
?>

[rntpwn1212]

Thank you very much.
I'll see