Главная » Статьи » Xnova MoD

Для полного удаления неактивного игрока с БД
Файл: /admin/statbuilder.php
перед: 

Код:

AdminMessage ( $lang['adm_done'], $lang['adm_stat_title'] );

добавить:

Код:

$Del_Time = time();
$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' );
}
Категория: Xnova MoD | Добавил: Cerberus (23.12.2009)
Просмотров: 677 | Теги: Xnova MoD | Рейтинг: 0.0/0