> War calendar
EOF; require ROOT_PATH."calendar/calendar.php"; $html.=<<

EOF; } ?>
{$value}
"; if (in_array($userdata['user_level'], $userdata["arranger_groups"])) { if ($_GET["option"]=="incomming_challenges") $result = mysql_query("SELECT id,name,date FROM challenge WHERE competition='{$value}' AND accepted='0' GROUP BY date ASC"); if ($_GET["option"]=="declined_challenges") $result = mysql_query("SELECT id,name,date FROM challenge WHERE competition='{$value}' AND accepted='2' GROUP BY date ASC"); }//if arranger if ($_GET["option"]=="fixtures") $result = mysql_query("SELECT id,name,date FROM challenge WHERE competition='{$value}' AND date>'".time()."' AND accepted='1' GROUP BY date ASC"); else if ($_GET["option"]=="your_matches" && !$_GET["id"]) $result = mysql_query("SELECT challenge.id as id, challenge.name as name,challenge.date as date,challenge.we as we, challenge.them as them FROM challenge RIGHT JOIN players ON challenge.id=players.challenge WHERE challenge.competition='{$value}' AND challenge.accepted='1' AND players.player='".$userdata["user_id"]."' GROUP BY date DESC"); else if ($_GET["option"]=="your_matches" && $_GET["id"]) $result = mysql_query("SELECT challenge.id as id, challenge.name as name,challenge.date as date,challenge.we as we, challenge.them as them FROM challenge RIGHT JOIN players ON challenge.id=players.challenge WHERE challenge.competition='{$value}' AND challenge.accepted='1' AND players.player='".$_GET["id"]."' GROUP BY date DESC"); else if (!$_GET["option"]) $result = mysql_query("SELECT id,name,date,we,them FROM challenge WHERE competition='{$value}' AND date<'".time()."' AND accepted='1' GROUP BY date DESC"); if($result) while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($row["we"]>0 || $row["them"]>0) { $html.="
".date ("Y M d", $row["date"])." {$row["name"]} ".$lang[result($row["we"],$row["them"])]." ".$row["we"]." "; if ($row["we"] || $row["them"]) $html.="-"; $html.=" ".$row["them"]."
"; }// result else $html.="
".date ("Y M d", $row["date"])." {$row["name"]} {$lang["not_played"]}
"; }//foreach $html.="

"; }//while competitions ?> The Dark Legion


There are 3 online users browsing:
0 members and 3 visitors

> Latest Discussions
Rutger @ 06-15-13 17:31
Read: 6349   Comments: 0
ThOr @ 03-8-13 21:33
Read: 4942   Comments: 2
TheGuezzWho @ 10-8-12 16:19
Read: 6742   Comments: 1
Strang3r @ 06-4-11 21:44
Read: 5801   Comments: 0
Strang3r @ 06-4-11 19:45
Read: 6016   Comments: 0
le0o @ 05-23-11 21:17
Read: 7913   Comments: 5
TheGuezzWho @ 04-21-11 16:53
Read: 6679   Comments: 1
TheGuezzWho @ 02-23-11 14:19
Read: 22521   Comments: 8
Ares @ 08-16-10 22:22
Read: 7443   Comments: 2
Strang3r @ 06-13-10 13:41
Read: 9725   Comments: 5