alliance; $allianceinfo = $database->getAlliance($aid); echo "

".$allianceinfo['tag']." - ".$allianceinfo['name']."

"; include("alli_menu.tpl"); ?>

Military events

dblink,"SELECT * FROM ".TB_PREFIX."ndata WHERE ally = ".(int) $session->alliance." AND (ntype < 8 OR (ntype > 17 AND ntype < 22) OR (ntype = 22 AND ally = $session->alliance) OR (ntype = 23 AND ally != $session->alliance)) ORDER BY time DESC LIMIT 20"); $query = mysqli_num_rows($sql); $outputList = ''; $name = 1; if(!$query) $outputList .= "There are no reports available."; else { while($row = mysqli_fetch_array($sql)){ $dataarray = explode(",",$row['data']); $id = $row["id"]; $uid = $row["uid"]; $toWref = $row["toWref"]; $ally = $row["ally"]; $topic = $row["topic"]; $ntype = $row["ntype"]; $data = $row["data"]; $time = $row["time"]; $viewed = $row["viewed"]; $archive = $row["archive"]; $outputList .= ""; $outputList .= ""; if($ntype >= 4 && $ntype <= 7) $type2 = 32; else $type2 = 31; $outputList .= ""; $type = (isset($_GET['t']) && $_GET['t'] == 5)? $archive : $ntype; if($type == 23) $type = 22; if($type >= 18 && $type <= 22){ $outputList .= ""; }else{ $outputList .= ""; } $outputList .= ""; $outputList .= "
"; if($ntype >= 18 && $ntype <= 21) $nn = " scouts "; else $nn = " attacks "; $outputList .= $database->getUserField($dataarray[0], "username", 0); $outputList .= $nn; $outputList .= $database->getUserField($type != 22 ? $dataarray[28] : $dataarray[2], "username", 0); if($ntype == 0){ $isoasis = $database->isVillageOases($toWref); if($isoasis == 0){ if($toWref != $village->wid){ $getUser = $database->getVillageField($toWref, "owner"); }else{ $getUser = $database->getVillageField($dataarray[1], "owner"); } }else{ if($toWref != $village->wid){ $getUser = $database->getOasisField($toWref, "owner"); }else{ $getUser = $database->getOasisField($dataarray[1], "owner"); } } $getUserAlly = $database->getUserField($getUser, "alliance", 0); }else if($ntype == 1 || $ntype == 2 || $ntype == 3 || $ntype == 18 || $ntype == 19){ $getUserAlly = $database->getUserField($type != 22 ? $dataarray[28] : $dataarray[2], "alliance", 0); }else{ $getUserAlly = $database->getUserField($type != 22 ? $dataarray[28] : $dataarray[2], "alliance", 0); } $getAllyName = $database->getAllianceName($getUserAlly); if(!$getUserAlly) $allyName = "-"; else $allyName = "".$getAllyName.""; $outputList .= "".$allyName.""; $date = $generator->procMtime($time); $outputList .= "".$date[0]." ".date('H:i',$time).""; $outputList .= ""; $name++; } } ?>
Player Alliance Date