3c3 < * This file is part of XNova:Legacies --- > * Tis file is part of XNova:Legacies 8c8 < * Copyright (c) 2009-2010, XNova Support Team --- > * Copyright (c) 2009-Present, XNova Support Team 30a31,32 > define('INSIDE' , true); > define('INSTALL' , false); 32,33c34,35 < < require_once dirname(dirname(__FILE__)) .'/common.php'; --- > define('PHPEXT', require dirname(dirname(__FILE__)).'/extension.inc'); > require_once dirname(dirname(__FILE__)) .'/common.'.PHPEXT; 38a41,43 > $db = Legacies_Database::getInstance(); > > 42,44c47,49 < // Rotation des statistiques < doquery ( "DELETE FROM {{table}} WHERE `stat_code` = '2';" , 'statpoints'); < doquery ( "UPDATE {{table}} SET `stat_code` = `stat_code` + '1';" , 'statpoints'); --- > // Rotation des statistiques > $db->delete(Legacies_Database::getTable('deprecated/statpoints'), array ('stat_code =?' => 2)); > $db->update(Legacies_Database::getTable('deprecated/statpoints'), array ('stat_code' => 'stat_code' + 1)); 46d50 < $GameUsers = doquery("SELECT * FROM {{table}}", 'users'); 48c52,60 < while ($CurUser = mysql_fetch_assoc($GameUsers)) { --- > $GameUsers = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/users')) > ->query() > ->fetch() > ; > $statement = $db->fetchAssoc($GameUsers); > > foreach ($statement as $CurUser) { 50c62,69 < $OldStatRecord = doquery ("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `id_owner` = '".$CurUser['id']."';",'statpoints'); --- > $OldStatRecord = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', 1) > ->where('id_owner=?', $CurUser['id']) > ->query() > ->fetch() > ; 58c77 < doquery ("DELETE FROM {{table}} WHERE `stat_type` = '1' AND `id_owner` = '".$CurUser['id']."';",'statpoints'); --- > $db->delete(Legacies_Database::getTable('deprecated/statpoints'), array ('stat_type =?' => 1), array ('id_owner =?' => $CurUser['id'])); 81,82c100,109 < $UsrPlanets = doquery("SELECT * FROM {{table}} WHERE `id_owner` = '". $CurUser['id'] ."';", 'planets'); < while ($CurPlanet = mysql_fetch_assoc($UsrPlanets) ) { --- > $UsrPlanets = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/planets')) > ->where('id_owner=?', $CurUser['id']) > ->query() > ; > > $statement2 = $db->fetchAssoc($UsrPlanets); > > foreach ($statement2 as $CurPlanet) { 102,106c129,130 < $QryUpdatePlanet = "UPDATE {{table}} SET "; < $QryUpdatePlanet .= "`points` = '". $PlanetPoints ."' "; < $QryUpdatePlanet .= "WHERE "; < $QryUpdatePlanet .= "`id` = '". $CurPlanet['id'] ."';"; < doquery ( $QryUpdatePlanet , 'planets'); --- > $db->update(Legacies_Database::getTable('deprecated/planets'), array ('points' => $PlanetPoints), array ('id =?' => $CurPlanet['id'])); > 109,130c133,156 < $QryInsertStats = "INSERT INTO {{table}} SET "; < $QryInsertStats .= "`id_owner` = '". $CurUser['id'] ."', "; < $QryInsertStats .= "`id_ally` = '". $CurUser['ally_id'] ."', "; < $QryInsertStats .= "`stat_type` = '1', "; // 1 pour joueur , 2 pour alliance < $QryInsertStats .= "`stat_code` = '1', "; // de 1 a 2 mis a jour de maniere automatique < $QryInsertStats .= "`tech_points` = '". $TTechPoints ."', "; < $QryInsertStats .= "`tech_count` = '". $TTechCount ."', "; < $QryInsertStats .= "`tech_old_rank` = '". $OldTechRank ."', "; < $QryInsertStats .= "`build_points` = '". $TBuildPoints ."', "; < $QryInsertStats .= "`build_count` = '". $TBuildCount ."', "; < $QryInsertStats .= "`build_old_rank` = '". $OldBuildRank ."', "; < $QryInsertStats .= "`defs_points` = '". $TDefsPoints ."', "; < $QryInsertStats .= "`defs_count` = '". $TDefsCount ."', "; < $QryInsertStats .= "`defs_old_rank` = '". $OldDefsRank ."', "; < $QryInsertStats .= "`fleet_points` = '". $TFleetPoints ."', "; < $QryInsertStats .= "`fleet_count` = '". $TFleetCount ."', "; < $QryInsertStats .= "`fleet_old_rank` = '". $OldFleetRank ."', "; < $QryInsertStats .= "`total_points` = '". $GPoints ."', "; < $QryInsertStats .= "`total_count` = '". $GCount ."', "; < $QryInsertStats .= "`total_old_rank` = '". $OldTotalRank ."', "; < $QryInsertStats .= "`stat_date` = '". $StatDate ."';"; < doquery ( $QryInsertStats , 'statpoints'); --- > $StatData = array( > 'id_owner' => $CurUser['id'], > 'id_ally' => $CurUser['ally_id'], > 'stat_type' => '1', > 'stat_code' => '1', > 'tech_points' => $TTechPoints, > 'tech_count' => $TTechCount, > 'tech_old_rank' => $OldTechRank, > 'build_points' => $TBuildPoints, > 'build_count' => $TBuildCount, > 'build_old_rank' => $OldBuildRank, > 'defs_points' => $TDefsPoints, > 'defs_count' => $TDefsCount, > 'defs_old_rank' => $OldDefsRank, > 'fleet_points' => $TFleetPoints, > 'fleet_count' => $TFleetCount, > 'fleet_old_rank' => $OldFleetRank, > 'total_points' => $GPoints, > 'total_count' => $GCount, > 'total_old_rank' => $OldTotalRank, > 'stat_date' => new Zend_Db_Expr('UNIX_TIMESTAMP()') > ); > //@todo Suite indentation > $db->insert(Legacies_Database::getTable('deprecated/statpoints'), $StatData); 134,140c160,171 < $RankQry = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' ORDER BY `tech_points` DESC;", 'statpoints'); < while ($TheRank = mysql_fetch_assoc($RankQry) ) { < $QryUpdateStats = "UPDATE {{table}} SET "; < $QryUpdateStats .= "`tech_rank` = '". $Rank ."' "; < $QryUpdateStats .= "WHERE "; < $QryUpdateStats .= " `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $TheRank['id_owner'] ."';"; < doquery ( $QryUpdateStats , 'statpoints'); --- > $RankQry = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', '1') > ->where('stat_code=?', '1') > ->order('tech_points DESC') > ->query() > ; > $statement = $db->fetchAssoc($sql); > > foreach ($statement as $TheRank) { > $db->update(Legacies_Database::getTable('deprecated/statpoints'), array ('tech_rank' => $Rank), array ('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner'])); 145,151c176,187 < $RankQry = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' ORDER BY `build_points` DESC;", 'statpoints'); < while ($TheRank = mysql_fetch_assoc($RankQry) ) { < $QryUpdateStats = "UPDATE {{table}} SET "; < $QryUpdateStats .= "`build_rank` = '". $Rank ."' "; < $QryUpdateStats .= "WHERE "; < $QryUpdateStats .= " `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $TheRank['id_owner'] ."';"; < doquery ( $QryUpdateStats , 'statpoints'); --- > $RankQry = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', '1') > ->where('stat_code=?', '1') > ->order('build_points DESC') > ->query() > ; > $statement = $db->fetchAssoc($sql); > > foreach ($statement as $TheRank) { > $db->update(Legacies_Database::getTable('deprecated/statpoints'), array ('build_rank' => $Rank), array ('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner'])); 156,162c192,203 < $RankQry = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' ORDER BY `defs_points` DESC;", 'statpoints'); < while ($TheRank = mysql_fetch_assoc($RankQry) ) { < $QryUpdateStats = "UPDATE {{table}} SET "; < $QryUpdateStats .= "`defs_rank` = '". $Rank ."' "; < $QryUpdateStats .= "WHERE "; < $QryUpdateStats .= " `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $TheRank['id_owner'] ."';"; < doquery ( $QryUpdateStats , 'statpoints'); --- > $RankQry = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', '1') > ->where('stat_code=?', '1') > ->order('defs_points DESC') > ->query() > ; > $statement = $db->fetchAssoc($sql); > > foreach ($statement as $TheRank) { > $db->update(Legacies_Database::getTable('deprecated/statpoints'), array ('defs_rank' => $Rank), array ('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner'])); 167,173c208,219 < $RankQry = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' ORDER BY `fleet_points` DESC;", 'statpoints'); < while ($TheRank = mysql_fetch_assoc($RankQry) ) { < $QryUpdateStats = "UPDATE {{table}} SET "; < $QryUpdateStats .= "`fleet_rank` = '". $Rank ."' "; < $QryUpdateStats .= "WHERE "; < $QryUpdateStats .= " `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $TheRank['id_owner'] ."';"; < doquery ( $QryUpdateStats , 'statpoints'); --- > $RankQry = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', '1') > ->where('stat_code=?', '1') > ->order('fleet_points DESC') > ->query() > ; > $statement = $db->fetchAssoc($sql); > > foreach ($statement as $TheRank) { > $db->update(Legacies_Database::getTable('deprecated/statpoints'), array ('fleet_rank' => $Rank), array ('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner'])); 178,184c224,235 < $RankQry = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' ORDER BY `total_points` DESC;", 'statpoints'); < while ($TheRank = mysql_fetch_assoc($RankQry) ) { < $QryUpdateStats = "UPDATE {{table}} SET "; < $QryUpdateStats .= "`total_rank` = '". $Rank ."' "; < $QryUpdateStats .= "WHERE "; < $QryUpdateStats .= " `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $TheRank['id_owner'] ."';"; < doquery ( $QryUpdateStats , 'statpoints'); --- > $RankQry = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', '1') > ->where('stat_code=?', '1') > ->order('total_points DESC') > ->query() > ; > $statement = $db->fetchAssoc($sql); > > foreach ($statement as $TheRank) { > $db->update(Legacies_Database::getTable('deprecated/statpoints'), array ('total_rank' => $Rank), array ('stat_type =?' => '1', 'stat_code =?' => '1', 'id_owner =?' => $TheRank['id_owner'])); 189c240,245 < $GameAllys = doquery("SELECT * FROM {{table}}", 'alliance'); --- > $GameAllys = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/alliance')) > ->query() > ; > $statement = Legacies_Database::getInstance()->fetchAssoc($sql); 191c247 < while ($CurAlly = mysql_fetch_assoc($GameAllys)) { --- > foreach ($statement as $CurAlly) { 193c249,256 < $OldStatRecord = doquery ("SELECT * FROM {{table}} WHERE `stat_type` = '2' AND `id_owner` = '".$CurAlly['id']."';",'statpoints'); --- > $OldStatRecord = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints')) > ->where('stat_type=?', '2') > ->where('id_owner=?', $CurAlly['id']) > ->query() > ->fetch() > ; 201c264,265 < doquery ("DELETE FROM {{table}} WHERE `stat_type` = '2' AND `id_owner` = '".$CurAlly['id']."';",'statpoints'); --- > $db->delete(Legacies_Database::getTable('deprecated/statpoints'), array ('stat_code =?' => '2', 'id_owner =?' => $CurAlly['id'])); > 210,226c274,293 < // Total des unitées consommée pour la recherche < $QrySumSelect = "SELECT "; < $QrySumSelect .= "SUM(`tech_points`) as `TechPoint`, "; < $QrySumSelect .= "SUM(`tech_count`) as `TechCount`, "; < $QrySumSelect .= "SUM(`build_points`) as `BuildPoint`, "; < $QrySumSelect .= "SUM(`build_count`) as `BuildCount`, "; < $QrySumSelect .= "SUM(`defs_points`) as `DefsPoint`, "; < $QrySumSelect .= "SUM(`defs_count`) as `DefsCount`, "; < $QrySumSelect .= "SUM(`fleet_points`) as `FleetPoint`, "; < $QrySumSelect .= "SUM(`fleet_count`) as `FleetCount`, "; < $QrySumSelect .= "SUM(`total_points`) as `TotalPoint`, "; < $QrySumSelect .= "SUM(`total_count`) as `TotalCount` "; < $QrySumSelect .= "FROM {{table}} "; < $QrySumSelect .= "WHERE "; < $QrySumSelect .= "`stat_type` = '1' AND "; < $QrySumSelect .= "`id_ally` = '". $CurAlly['id'] ."';"; < $Points = doquery( $QrySumSelect, 'statpoints', true); --- > // Total des unitées consommée pour la recherche > $SUM_Array = array(new Zend_Db_Expr('SUM(`tech_points`) AS `TechPoint`'), > new Zend_Db_Expr('SUM(`tech_count`) AS `TechCount`'), > new Zend_Db_Expr('SUM(`build_points`) AS `BuildPoint`'), > new Zend_Db_Expr('SUM(`build_count`) AS `BuildCount`'), > new Zend_Db_Expr('SUM(`defs_points`) AS `DefsPoint`'), > new Zend_Db_Expr('SUM(`defs_count`) AS `DefsCount`'), > new Zend_Db_Expr('SUM(`fleet_points`) AS `FleetPoint`'), > new Zend_Db_Expr('SUM(`fleet_count`) AS `FleetCount`'), > new Zend_Db_Expr('SUM(`total_points`) AS `TotalPoint`'), > new Zend_Db_Expr('SUM(`total_count`) AS `TotalCount`')); > $Points = $db > ->select() > ->from(Legacies_Database::getTable('deprecated/statpoints'), $SUM_Array) > ->where('stat_type=?', '2') > ->where('id_ally=?', $CurAlly['id']) > ->query() > ->fetch() > ; > //array('thecolumn' => new Zend_Db_Expr('SUM(amount)')) 238,260c305,329 < < $QryInsertStats = "INSERT INTO {{table}} SET "; < $QryInsertStats .= "`id_owner` = '". $CurAlly['id'] ."', "; < $QryInsertStats .= "`id_ally` = '0', "; < $QryInsertStats .= "`stat_type` = '2', "; // 1 pour joueur , 2 pour alliance < $QryInsertStats .= "`stat_code` = '1', "; // de 1 a 5 mis a jour de maniere automatique < $QryInsertStats .= "`tech_points` = '". $TTechPoints ."', "; < $QryInsertStats .= "`tech_count` = '". $TTechCount ."', "; < $QryInsertStats .= "`tech_old_rank` = '". $OldTechRank ."', "; < $QryInsertStats .= "`build_points` = '". $TBuildPoints ."', "; < $QryInsertStats .= "`build_count` = '". $TBuildCount ."', "; < $QryInsertStats .= "`build_old_rank` = '". $OldBuildRank ."', "; < $QryInsertStats .= "`defs_points` = '". $TDefsPoints ."', "; < $QryInsertStats .= "`defs_count` = '". $TDefsCount ."', "; < $QryInsertStats .= "`defs_old_rank` = '". $OldDefsRank ."', "; < $QryInsertStats .= "`fleet_points` = '". $TFleetPoints ."', "; < $QryInsertStats .= "`fleet_count` = '". $TFleetCount ."', "; < $QryInsertStats .= "`fleet_old_rank` = '". $OldFleetRank ."', "; < $QryInsertStats .= "`total_points` = '". $GPoints ."', "; < $QryInsertStats .= "`total_count` = '". $GCount ."', "; < $QryInsertStats .= "`total_old_rank` = '". $OldTotalRank ."', "; < $QryInsertStats .= "`stat_date` = '". $StatDate ."';"; < doquery ( $QryInsertStats , 'statpoints'); --- > > $QryInsertStats = array( > 'id_owner' => $CurAlly['id'], > 'id_ally' => '0', > 'stat_type' => '2', > 'stat_code' => '1', > 'tech_points' => $TTechPoints, > 'tech_count' => $TTechCount, > 'tech_old_rank' => $OldTechRank, > 'build_points' => $TBuildPoints, > 'build_count' => $TBuildCount, > 'build_old_rank' => $OldBuildRank, > 'defs_points' => $TDefsPoints, > 'defs_count' => $TDefsCount, > 'defs_old_rank' => $OldDefsRank, > 'fleet_points' => $TFleetPoints, > 'fleet_count' => $TFleetCount, > 'fleet_old_rank' => $OldFleetRank, > 'total_points' => $GPoints, > 'total_count' => $GCount, > 'total_old_rank' => $OldTotalRank, > 'stat_date' => new Zend_Db_Expr('UNIX_TIMESTAMP()') > ); > //@todo Suite indentation > $db->insert(Legacies_Database::getTable('deprecated/statpoints'), $QryInsertStats);