All pastes #23017 Raw Edit

Unnamed

public text v1 · immutable
#23017 ·published 2005-09-15 20:13 UTC
rendered paste body
function DelAllOldAcc() {
  global $q, $db;
  $q1 = new DBQuery(&$db); $q1->ErrorPostfix='';
  $q2 = new DBQuery(&$db); $q2->ErrorPostfix='';
  $q->Select("accounts", "access_level=0");
  while ($rows=$q->Fetch_array()) {
    $time=time()*1000;
    if($time-$rows['lastactive']>1000*60*60*24*30) {
      $q1->Select("characters", "account_name='".$rows['login']."'");
      while($rows1=$q1->Fetch_array()) {
        $q2->Delete("character_quests", "char_id=".$rows1['obj_Id']);
        $q2->Delete("character_friends", "char_id=".$rows1['obj_Id']);
        $q2->Delete("character_hennas", "char_obj_id=".$rows1['obj_Id']);
        $q2->Delete("character_macroses", "char_obj_id=".$rows1['obj_Id']);
        $q2->Delete("character_recipebook", "char_id=".$rows1['obj_Id']);
        $q2->Delete("character_skills", "char_obj_id=".$rows1['obj_Id']);
        $q2->Delete("character_shortcuts", "char_obj_id=".$rows1['obj_Id']);
        $q2->Delete("seven_signs", "char_obj_id=".$rows1['obj_Id']);
        $q2->Delete("pets USING pets, items", "pets.item_obj_id=items.object_id AND items.owner_id=".$rows1['obj_Id']);
        $q2->Delete("items", "owner_id=".$rows1['obj_Id']);
        $q2->Update("characters, clan_data", "characters.clanid=0 AND characters.title=''", "characters.clanid=clan_data.clan_id AND clan_data.leader_id=".$rows1['obj_Id']);
        $q2->Delete("siege_clans USING siege_clans, clan_data", "siege_clans.clan_id=clan_data.clan_id AND clan_data.leader_id=".$rows1['obj_Id']);
        $q2->Delete("clan_wars USING clan_wars, clan_data", "clan_wars.clan1=clan_data.clan_id OR clan_wars.clan2=clan_data.clan_id AND clan_data.leader_id=".$rows1['obj_Id']);
        $q2->Delete("clan_data", "leader_id=".$rows1['obj_Id']);
        $q2->Delete("characters", "obj_Id=".$rows1['obj_Id']);
      }
      $q1->Delete("accounts", "login='".$rows['login']."'");
    }
  }
}