Главная » Статьи » Xnova MoD |
Для полного удаления неактивного игрока с БД
Файл: /admin/statbuilder.php перед: Код: AdminMessage ( $lang['adm_done'], $lang['adm_stat_title'] ); добавить: Код: $Time_Online = time()-3024000; $Spr_Online = doquery("SELECT * FROM {{table}} WHERE `onlinetime`<'{$Time_Online}' AND `onlinetime`>'0' AND `urlaubs_modus`='0'","users"); while ($OnlineS = mysql_fetch_assoc($Spr_Online)){ doquery("UPDATE {{table}} SET `deltime` = '{$Del_Time}' WHERE `id` = '{$OnlineS['id']}'","users"); } $Spr_Del = doquery("SELECT * FROM {{table}} WHERE `deltime`<'{$Del_Time}' AND `deltime`>'0'","users"); $User_Spra = mysql_num_rows($Spr_Del); $Useru_Poza = $game_config['users_amount']-$User_Spra; while ($Del = mysql_fetch_assoc($Spr_Del)){ $UserID = $Del['id']; $TheUser = doquery ( "SELECT * FROM {{table}} WHERE `id` = '" . $UserID . "';", 'users', true ); if ( $TheUser['ally_id'] != 0 ) { $TheAlly = doquery ( "SELECT * FROM {{table}} WHERE `id` = '" . $TheUser['ally_id'] . "';", 'alliance', true ); $TheAlly['ally_members'] -= 1; if ( $TheAlly['ally_members'] > 0 ) { doquery ( "UPDATE {{table}} SET `ally_members` = '" . $TheAlly['ally_members'] . "' WHERE `id` = '" . $TheAlly['id'] . "';", 'alliance' ); } else { doquery ( "DELETE FROM {{table}} WHERE `id` = '" . $TheAlly['id'] . "';", 'alliance' ); doquery ( "DELETE FROM {{table}} WHERE `stat_type` = '2' AND `id_owner` = '" . $TheAlly['id'] . "';", 'statpoints' ); } } doquery ( "DELETE FROM {{table}} WHERE `stat_type` = '1' AND `id_owner` = '" . $UserID . "';", 'statpoints' ); $ThePlanets = doquery ( "SELECT * FROM {{table}} WHERE `id_owner` = '" . $UserID . "';", 'planets' ); while ( $OnePlanet = mysql_fetch_assoc ( $ThePlanets ) ) { if ( $OnePlanet['planet_type'] == 1 ) { doquery ( "DELETE FROM {{table}} WHERE `galaxy` = '" . $OnePlanet['galaxy'] . "' AND `system` = '" . $OnePlanet['system'] . "' AND `planet` = '" . $OnePlanet['planet'] . "';", 'galaxy' ); } elseif ( $OnePlanet['planet_type'] == 3 ) { doquery ( "DELETE FROM {{table}} WHERE `galaxy` = '" . $OnePlanet['galaxy'] . "' AND `system` = '" . $OnePlanet['system'] . "' AND `lunapos` = '" . $OnePlanet['planet'] . "';", 'lunas' ); } doquery ( "DELETE FROM {{table}} WHERE `id` = '" . $ThePlanets['id'] . "';", 'planets' ); } $zeit = time()-1209600; doquery ( "DELETE FROM {{table}} WHERE `message_sender` = '" . $UserID . "' OR `message_owner` = '" . $UserID . "' OR `message_time` < '".$zeit."';", 'messages' ); doquery ( "DELETE FROM {{table}} WHERE `owner` = '" . $UserID . "';", 'notes' ); doquery ( "DELETE FROM {{table}} WHERE `fleet_owner` = '" . $UserID . "';", 'fleets' ); doquery ( "DELETE FROM {{table}} WHERE `id_owner1` = '" . $UserID . "' OR `id_owner2` = '" . $UserID . "';", 'rw' ); doquery ( "DELETE FROM {{table}} WHERE `sender` = '" . $UserID . "';", 'buddy' ); doquery ( "DELETE FROM {{table}} WHERE `id_owner` = '0';", 'planets' ); doquery ( "DELETE FROM {{table}} WHERE `id_planet` = '0';", 'galaxy' ); doquery ( "DELETE FROM {{table}} WHERE `owner` = '" . $UserID . "';", 'buddy' ); doquery ( "DELETE FROM {{table}} WHERE `user` = '" . $UserID . "';", 'annonce' ); doquery ( "DELETE FROM {{table}} WHERE `id` = '" . $UserID . "';", 'users' ); } | |
Просмотров: 1014 | | |