query("SELECT hlstats_Servers.serverId FROM hlstats_Servers JOIN hlstats_Games ON hlstats_Servers.game = hlstats_Games.code WHERE hlstats_Games.realgame = 'hl2mp' AND hlstats_Games.code != 'hl2ctf'"); while ($rowdata = $db->fetch_row($result)) { array_push($hl2mpserverids, $db->escape($rowdata[0])); } if(count($hl2mpserverids)>0) { $serverids = implode(",", $hl2mpserverids); $db->query("UPDATE IGNORE `hlstats_Servers_Config` SET `value` = '3' WHERE `parameter` = 'GameEngine' AND `serverId` in ($serverids);"); } $db->query("UPDATE IGNORE `hlstats_Games_Defaults` SET `value` = '3' WHERE `code` = 'hl2mp' AND `parameter` = 'GameEngine';"); $db->query("UPDATE hlstats_Options SET `value` = '$version' WHERE `keyname` = 'version'"); $db->query("UPDATE hlstats_Options SET `value` = '$dbversion' WHERE `keyname` = 'dbversion'"); ?>