PHP网页游戏学习之Xnova(ogame)源码解读（十五）

 //检查是否有到达目的地的舰队 $_fleets = doquery("SELECT * FROM {{table}} WHERE 'fleet_start_time' <= '".time()."';", 'fleets'); // OR fleet_end_time <= ".time() //循环处理每个舰队 while ($row = mysql_fetch_array($_fleets)) { $array        = array(); $array['galaxy']   = $row['fleet_start_galaxy']; $array['system']   = $row['fleet_start_system']; $array['planet']   = $row['fleet_start_planet']; $array['planet_type'] = $row['fleet_start_type']; //舰队处理函数 $temp = FlyingFleetHandler ($array); } //检查是否有返回出发地的舰队 $_fleets = doquery("SELECT * FROM {{table}} WHERE 'fleet_end_time' <= '".time()."';", 'fleets'); // OR fleet_end_time <= ".time() //循环处理每个舰队 whi<p style="color:transparent">来源gao!%daima.com搞$代*!码网</p>le ($row = mysql_fetch_array($_fleets)) { $array        = array(); $array['galaxy']   = $row['fleet_end_galaxy']; $array['system']   = $row['fleet_end_system']; $array['planet']   = $row['fleet_end_planet']; $array['planet_type'] = $row['fleet_end_type']; //舰队处理函数 $temp = FlyingFleetHandler ($array); }

 //锁表，防止出现数据不同步等问题 doquery("LOCK TABLE {{table}}lunas WRITE, {{table}}rw WRITE, {{table}}errors WRITE, {{table}}messages WRITE, {{table}}fleets WRITE, {{table}}planets WRITE, {{table}}galaxy WRITE ,{{table}}users WRITE", ""); //这里一大段就是取得舰队数组，参数完全可以使用舰队ID，优化之 $QryFleet  = "SELECT * FROM {{table}} "; $QryFleet .= "WHERE ("; $QryFleet .= "( "; $QryFleet .= "`fleet_start_galaxy` = ". $planet['galaxy']   ." AND "; $QryFleet .= "`fleet_start_system` = ". $planet['system']   ." AND "; $QryFleet .= "`fleet_start_planet` = ". $planet['planet']   ." AND "; $QryFleet .= "`fleet_start_type` = ".  $planet['planet_type'] ." "; $QryFleet .= ") OR ( "; $QryFleet .= "`fleet_end_galaxy` = ".  $planet['galaxy']   ." AND "; $QryFleet .= "`fleet_end_system` = ".  $planet['system']   ." AND "; $QryFleet .= "`fleet_end_planet` = ".  $planet['planet']   ." ) AND "; $QryFleet .= "`fleet_end_type`= ".   $planet['planet_type'] ." ) AND "; $QryFleet .= "( `fleet_start_time` <'". time() ."' OR `fleet_end_time` <'". time() ."' );"; $fleetquery = doquery( $QryFleet, 'fleets' ); //根据舰队活动的目标不同，分别进入不同的函数处理 while ($CurrentFleet = mysql_fetch_array($fleetquery)) { switch ($CurrentFleet["fleet_mission"]) { case 1: // 普通攻击 MissionCaseAttack ( $CurrentFleet ); break; case 2: // 这里应该是ACS攻击或者是其他攻击，但是现在没有用 doquery ("DELETE FROM {{table}} WHERE `fleet_id` = '". $CurrentFleet['fleet_id'] ."';", 'fleets'); break; case 3: // 运输 MissionCaseTransport ( $CurrentFleet ); break; case 4: // 派遣 MissionCaseStay ( $CurrentFleet ); break; case 5: // 联合派遣，即ACS防御 MissionCaseStayAlly ( $CurrentFleet ); break; case 6: // 侦查 MissionCaseSpy ( $CurrentFleet ); break; case 7: // 殖民 MissionCaseColonisation ( $CurrentFleet ); break; case 8: // 回收 MissionCaseRecycling ( $CurrentFleet ); break; case 9: // 毁月，厉害了 MissionCaseDestruction ( $CurrentFleet ); break; case 10: // 保留 !! break; case 15: // 远征、探险 MissionCaseExpedition ( $CurrentFleet ); break; //其他情况删除舰队，这个是好习惯 default: { doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $CurrentFleet['fleet_id'] ."';", 'fleets'); } } } //解锁表 doquery("UNLOCK TABLES", "");