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,
