db_Select("event", "*", "(event_start>='$monthstart' AND event_start<= '$monthend') OR (event_rec_y='$current_month')");
$events = $sql -> db_Rows();
while($row = $sql -> db_Fetch()){
extract($row);
$evf = getdate($event_start);
$tmp = $evf['mday'];
$event_true[$tmp] = $event_category;
}
// -----------------------------------------------------------------------------------------------------------
// set up arrays for calender display ------------------------------------------------------------------
$week = Array(EC_LAN_25,EC_LAN_19,EC_LAN_20,EC_LAN_21,EC_LAN_22,EC_LAN_23,EC_LAN_24);
$months = Array(EC_LAN_0,EC_LAN_1,EC_LAN_2,EC_LAN_3,EC_LAN_4,EC_LAN_5,EC_LAN_6,EC_LAN_7,EC_LAN_8,EC_LAN_9,EC_LAN_10,EC_LAN_11);
$calendar_title = $months[$datearray[mon]-1]." ".$current_year;
// -----------------------------------------------------------------------------------------------------------
$text = "";
if($events){
$text .= EC_LAN_26 . ": ".$events;
}else{
$text .= EC_LAN_27;
}
$start = $monthstart;
$text .= "
";
foreach($week as $day){
$text .= "| ".$day." | ";
}
$text .= " ";
$thismonth = $datearray['mon'];
$thisday = $datearray['mday'];
for($c=0; $c<$firstdayarray['wday']; $c++){
$text .= "
| ";
}
$loop = $firstdayarray['wday'];
for($c=1; $c<=31; $c++){
$dayarray = getdate($start+($c*84460));
if($dayarray['mon'] == $thismonth){
if($thisday == $c){
$text .= "";
}else{
$text .=" | ";
}
if($event_true[($c)]){
$sql -> db_Select("event_cat", "*", "event_cat_id='".$event_true[($c)]."' ");
$icon = $sql -> db_Fetch();
extract($icon);
$img = "![](".$ec_dir."images/".$event_cat_icon.") ";
}else{
$img = "![](".$ec_dir."images/cal1.png) ";
}
$linkut = mktime(0 ,0 ,0 ,$dayarray['mon'], $c, $datearray['year']);
$text .="$img
$c";
if($thisday == $c){
}
$text .= " | \n";
$loop++;
if($loop == 7){
$loop = 0;
$text .= " ";
}
}
}
for($a=($loop+1); $a<=7; $a++){
$text .="| | ";
}
$text .= "
|
';
$text .= "The Ambassador Corp are the good faith ambassadors for the pilots of Dark Horizons: Lore Invasion.
If you have any questions or problems, these people are you first and best chance at getting an
immediate answer or resolution. They are also directly involved in helping letting the developers
know what players like, or don't like.";
$text .= '
';
$text .= 'They are also avid players of Dark Horizons: Lore Invasion, and there is generally one them around
playing on the servers, so keep your eyes out, that next death maybe at their hands.';
$text .= '
';
// Errors WILL NOT BE displayed on this page. Instead just nothing will be shown.
// First things first, lets grab the list of users and their pilots
$result = $GLOBALS['e107db']->sql_query('SELECT user_name,nick_id
FROM e107_user
left join e107_name_link on e107_name_link.user_id=e107_user.user_id
WHERE user_class LIKE "%9%"
AND user_admin <> 1
ORDER BY user_name');
if ($GLOBALS['e107db']->sql_numrows($result) > 0){ // we were successful
// TODO layout
while($array = $GLOBALS['e107db']->sql_fetchrow($result)){ // process those found
if ($array['user_name'] != $new){ // If this is a new user name show user data
if ($new){ $text .= ' |
'; unset($old); }
$new = $array['user_name'];
$text .= '| '.$array['user_name'].' | ';
// We are currently not supporting options here yet. As there is no USEROBJECT yet
$text .= ' | ';
}
// this is a pilot of this user, so only show pilot information
// The query only returns those who have valid pilots assigned to them
// Run query to get the info for this pilot
$pdata = $GLOBALS['services']->sql_autofetch('SELECT nick.nick, nick.url, onweb.squad_id, squad_name
FROM onweb
LEFT JOIN nick ON nick.nick_id = onweb.nick_id
left join squads on squads.squad_id=onweb.squad_id
where onweb.nick_id ='.$array['nick_id']);
// just make sure something was returned
if ($pdata['nick'] == ''){ // nothing returned, continue on to the next one
continue;
}
// Now that we have the data, dump it to the screen.
if (!$old){ // Need to keep First run seperate from the rest
$text .= '| Pilots: | ';
$old = 1;
} else { // Show a blank line for the others
$text .= ' | | ';
}
$text .= ''.$pdata['nick'];
if ($pdata['squad_id'] > 0){ $text .= ' ('.$pdata['squad_name'].')'; }
$text .= ' | ';
$text .= '[ STATS ] ';
$text .= ' | ';
}
$text .= '
';
}
// Display main Box
$ns->gen_tablerend($caption,$text);
?>
|
hasLinkedPilots()){
$ns->tablerender("Linked Pilots",$_SESSION['uobject']->displayPilots());
}
?>
|
