die('No Nation selected'); } $name = mysql_fetch_array(mysql_query("SELECT Name, NatID FROM ".$db_pre."data WHERE NatID = '".$_GET[ID]."'")); $forums = mysql_query("SELECT Forum, Forum_status, Type FROM ".$db_pre."forums WHERE NatID = '".$_GET[ID]."'"); $rows = mysql_num_rows($forums); echo('<h1>Forums of <a href="nation.php?ID='.$name[NatID].'">'.$name[Name].'</a>.</h1> <table border="1"> <tr> <td>Address</td><td>Status</td><td>Type</td> </tr>'); for($i=1;$i<=$rows;$i++) { $forum = mysql_fetch_array($forums); echo('<tr>'); echo('<td><a href="'.function_spamstop($forum[Forum]).'">'.function_spamstop($forum[Forum]).'</a></td>'); echo('<td>'.$forum[Forum_status].'</td>'); echo('<td><a href="forumtype.php?type='.$forum[Type].'">'.$forum[Type].'</a></td>'); echo('</tr>'); } echo('</table>'); include('footer.php'); ?>
include('connect.php'); //Check ID has been set. if(!isset($_GET['ID'])) { echo(function_lang('NO_NATID',$conf_lang,$db_pref)); include('footer.php'); die(); } $raw_forum = mysql_query('SELECT `NatID`, `Forum`,`Forum_status` FROM '.$db_pre.'forums WHERE `ID` = \''.$_GET['ID'].'\''); $dat_forum = mysql_fetch_array($raw_forum); $raw_nation = mysql_query('SELECT `Name` FROM '.$db_pre.'data WHERE `NatID` = \''.$dat_forum['NatID'].'\''); $dat_nation = mysql_fetch_array($raw_nation); echo('<h1>'.function_lang('FORUMLOGS_TITLE',$conf_lang,$db_pref,array($_GET['ID'])).'</h1> '.function_lang('FORUMLOGS_INFO',$conf_lang,$db_pref,array($dat_forum['NatID'],$dat_nation['Name'],$dat_forum['Forum_status'],function_spamstop($dat_forum['Forum'])))); $raw_logs = mysql_query('SELECT `Year`, `Month`, `Day`, `Post_count` FROM '.$db_pre.'activity_forums WHERE `ForumID` = \''.$_GET['ID'].'\' ORDER BY `Year`,`Month`,`Day`'); $num_logs = mysql_num_rows($raw_logs); echo('<table border="1"><tr> <td>'.function_lang('INFO_COL_DATE',$conf_lang,$db_pref).'</td> <td>'.function_lang('INFO_COL_POSTCOUNT',$conf_lang,$db_pref).'</td> </tr>'); for($a=0;$a<$num_logs;$a++) { $dat_logs = mysql_fetch_array($raw_logs); echo('<tr><td>'.str_pad($dat_logs['Day'],2,0,STR_PAD_LEFT).'/'.str_pad($dat_logs['Month'],2,0,STR_PAD_LEFT).'/'.$dat_logs['Year'].'</td><td>'.$dat_logs['Post_count'].'</td></tr>'); } echo('</table>');
<table border="1"> <tr> <td>Nation</td> <td>Address</td> <td>Status</td> </tr>'); $forum = mysql_query("SELECT NatID, Forum, Forum_status FROM ".$db_pre."forums WHERE Type = '".$_GET[type]."'"); $fora = mysql_num_rows($forum); for($i=1;$i<=$fora;$i++) { $forum_info = mysql_fetch_array($forum); $name = mysql_fetch_array(mysql_query("SELECT Name FROM ".$db_pre."data WHERE NatID = '".$forum_info[NatID]."'")); echo('<tr> <td><a href="nation.php?ID='.$forum_info[NatID].'">'.$name[Name].'</a></td> <td><a href="'.function_spamstop($forum_info[Forum]).'">'.function_spamstop($forum_info[Forum]).'</a></td> <td>'.$forum_info[Forum_status].'</td> </tr>'); } echo('</table>'); } else { echo('<a href="index.php">Back to list</a>'); echo('<h1>Forum type statistics</h1>'); echo('<table border="1"> <tr> <td>Type</td>
} if($num_wikis!=0) { echo('<table border="1"><tr> <td><b>'.function_lang('INFO_COL_TYPE',$conf_lang,$db_pref).'</b></td> <td><b>'.function_lang('INFO_COL_WIKI',$conf_lang,$db_pref).'</b></td> <td><b>'.function_lang('INFO_COL_URL',$conf_lang,$db_pref).'</b></td> <td><b>'.function_lang('INFO_COL_DESC',$conf_lang,$db_pref).'</b></td> </tr>'); for($a=0;$a<$num_wikis;$a++) { $dat_wikis = mysql_fetch_array($raw_wikis); $raw_wiki = mysql_query('SELECT `Name`,`Link` FROM `'.$db_pref.'wikis` WHERE `ID` = \''.$dat_wikis['WikiID'].'\''); $dat_wiki = mysql_fetch_array($raw_wiki); echo('<tr> <td>'.$dat_wikis['Type'].'</td> <td><a href="'.function_spamstop($dat_wiki['Link']).'">'.$dat_wiki['Name'].'</a></td> <td><a href="'.function_spamstop($dat_wikis['Link']).'">'.function_spamstop($dat_wikis['Link']).'</a></td> <td>'.$dat_wikis['Description'].'</td> </tr>'); } echo('</table><div class="mod">'.function_lang('CHANGE_WIKIS',$conf_lang,$db_pref,array($_GET['ID'])).'</div>'); } unset($raw_wikis,$num_wikis); /////////////////////////////////////////////////CULTURAL ITEMS TABLE////////////////////////////////////////////////// echo('<h3><a name="Culture">'.function_lang('INFO_CULTURE',$conf_lang,$db_pref).':</a></h3>'); $raw_cultural = mysql_query('SELECT `File_name`, `Comment`, `File_size`, `Date_uploaded` FROM `'.$db_pref.'culture` WHERE `NatID` = \''.$_GET['ID'].'\''); $num_cultural = mysql_num_rows($raw_cultural); if($num_cultural==1) {
<td>Nation</td> <td>Address</td> <td>Status</td> <td>Flash_required</td> <td>Language</td> </tr>'); $raw_websites = mysql_query("SELECT NatID, Address, Status, Flash_required, Language FROM ".$db_pre."websites WHERE Type = '".$_GET['type']."'"); $num_websites = mysql_num_rows($raw_websites); for($a=1;$a<=$num_websites;$a++) { $dat_websites = mysql_fetch_array($raw_websites); $name = mysql_fetch_array(mysql_query("SELECT Name FROM ".$db_pre."data WHERE NatID = '".$dat_websites['NatID']."'")); echo('<tr> <td><a href="nation.php?ID='.$dat_websites['NatID'].'">'.$name['Name'].'</a></td> <td><a href="'.spamstop($dat_websites['Address']).'">'.function_spamstop($dat_websites['Address']).'</a></td> <td>'.$dat_websites['Status'].'</td> <td>'.$dat_websites['Flash_required'].'</td> <td>'.$dat_websites['Language'].'</td> </tr>'); } echo('</table>'); } else { echo('<a href="index.php">Back to list</a> <h1>Website type statistics</h1> <table border="1">
$NatID = $_POST['NatID']; } else { echo(function_lang('NO_NATID',$conf_lang,$db_pref)); include('footer.php'); die(); } if(isset($_POST['Type'])) { $Type = $_POST['Type']; } else { echo(function_lang('REQUESTMOD_NODATA',$conf_lang,$db_pref)); include('footer.php'); die(); } if(isset($_POST['Desc'])) { $Desc = $_POST['Desc']; $Desc = function_spamstop($Desc); $Desc = str_replace("\n",'<br />',$Desc); } else { echo(function_lang('REQUESTMOD_NODESC',$conf_lang,$db_pref)); include('footer.php'); die(); } $Name = $_POST['Name']; $Timestamp = gmmktime(); $IP = $_SERVER['REMOTE_ADDR']; require_once('recaptchalib.php'); $privatekey = "6Ldj_7sSAAAAAKiK3_8R6qxpdFjT-An0Hjbw2mt1"; $resp = recaptcha_check_answer ($privatekey,