</script>
<?
echo('<br />'.function_lang('LANGUAGE_SELECT',$conf_lang,$db_pref).'<form action="change_language.php" method="post"><select name="Language">');
$sql_languages = 'SELECT `ID`,`Name` FROM `'.$db_pref.'langs` ORDER BY `Name` ASC';
$raw_languages = mysql_query($sql_languages);
$num_languages = mysql_num_rows($raw_languages);
for($a=0;$a<$num_languages;$a++) {
$dat_languages = mysql_fetch_array($raw_languages);
if($dat_languages['ID']==$conf_lang) {
echo('<option value="'.$dat_languages['ID'].'" selected="selected">'.$dat_languages['Name'].'</option>');
} else {
echo('<option value="'.$dat_languages['ID'].'">'.$dat_languages['Name'].'</option>');
}
}
echo('</select><input type="submit" value="'.function_lang('LANGUAGE_CHANGE',$conf_lang,$db_pref).'" />');
?>
</form>
</div>
<div id="bottomimg"><img src="images/footer.png" alt="" /></div>
<p>
<a href="http://validator.w3.org/check?uri=referer"><img
src="images/valid-xhtml10.png"
alt="Valid XHTML 1.0 Strict" height="31" width="88" /></a>
<a href="http://jigsaw.w3.org/css-validator/validator?uri=http://mnforumlist.com/style.css">
<img style="border:0;width:88px;height:31px"
src="images/valid-css.png"
alt="Valid CSS!" />
</a>
<?
include('header.php');
include('connect.php');
$conf_lang = $_POST['Language'];
$sql_updateman = 'UPDATE `'.$db_pref.'lang_ip` SET `Manual` = \'Y\' WHERE `IP` = \''.$_SERVER['REMOTE_ADDR'].'\'';
$raw_updateman = mysql_query($sql_updateman);
$sql_updatelan = 'UPDATE `'.$db_pref.'lang_ip` SET `Language` = \''.$_POST['Language'].'\' WHERE `IP` = \''.$_SERVER['REMOTE_ADDR'].'\'';
$raw_updatelan = mysql_query($sql_updatelan);
$sql_updatetime = 'UPDATE `'.$db_pref.'lang_ip` SET `Last_Change` = \''.gmmktime().'\' WHERE `IP` = \''.$_SERVER['REMOTE_ADDR'].'\'';
$raw_updatetime = mysql_query($sql_updatetime);
echo(function_lang('LANGUAGE_CHANGED',$conf_lang,$db_pref,array($_POST['Language'])));
include('footer.php');
?>
$raw_flags = mysql_query('SELECT `File_name`,`Type`,`Area`,`Description`,`Length_X`,`Length_Y` FROM `'.$db_pre.'flags` WHERE `NatID` = \''.$_GET['ID'].'\' AND `Type` != \'Thumbnail\' ORDER BY `Type`,`Area`');
$num_flags = mysql_num_rows($raw_flags);
for($a=1;$a<=$num_flags;$a++) {
$dat_flags = mysql_fetch_array($raw_flags);
if($dat_flags['Length_X']>300) {
$flag_X = 300;
$flag_Y = $dat_flags['Length_Y']/$dat_flags['Length_X']*$flag_X;
} else {
$flag_X = $dat_flags['Length_X'];
$flag_Y = $dat_flags['Length_Y'];
}
echo('
<tr>
<td><img src="'.$dat_flags['File_name'].'" alt="'.function_lang('FLAG_ALT',$conf_lang,$db_pref,array($dat_flags['Area'])).'" width="'.$flag_X.'" height="'.$flag_Y.'" /></td>
<td>'.$dat_flags['Type'].'</td>
<td>'.$dat_flags['Area'].'</td>
<td>'.$dat_flags['Description'].'</td>
</tr>');
}
echo('</table>');
include('footer.php');
?>
$address = explode('/',$_SERVER[SCRIPT_NAME]);
$bits = count($address);
if($address[($bits-1)]=="add_new3.php") {
echo('<meta http-equiv="refresh" content="2;url=index.php" />');
}
?>
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="shortcut icon" href="faviconF.ico" />
</head>
<body>
<div id="button"><a href="http://dr-spangle.com"><img src="http://dr-spangle.com/images/home.php" alt="Home" /></a></div>
<div id="main">
<?
echo('<a class="image" href="index.php"><img src="images/'.function_lang('BANNER_IMG',$conf_lang,$db_pref).'" alt="'.function_lang('TITLE_ALT',$conf_lang,$db_pref).'" /></a>');
if(1==0) {
echo('<script type="text/javascript"><!--
google_ad_client = "pub-5547405481417256";
/* ForumList */
google_ad_slot = "2848926708";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>');
}
echo('
mysql_query('INSERT INTO '.$db_pre.'culture (NatID,Date_uploaded,Comment,File_name,File_type,File_size)
VALUES (\''.$folder_num.'\',\''.mktime().'\',\''.$_POST['comments'].'\',\''.$_FILES['file']['name'].'\',
\''.$_FILES['file']['type'].'\',\''.$_FILES['file']['size'].'\')');
$natculture_items = mysql_num_rows(mysql_query('SELECT * FROM '.$db_pre.'culture WHERE NatID = \''.$folder_num.'\''));
mysql_query('UPDATE '.$db_pre.'data SET Culture_items = \''.$natculture_items.'\' WHERE NatID = \''.$folder_num.'\'');
function_email("Culture Uploaded",$_FILES,$nation_name['Name'],$folder_num);
function_rssadd("NewCulture",$db_pref,$_POST['NatID'],'http://mnforumlist.com/nation.php?ID='.$_POST['NatID'].'#Culture',' It is a '.$_FILES['file']['size'].'byte file called '.$_FILES['file']['name'].' the description is: "'.$_POST['comments'].'.');
//END YES PART
} else {
//START NO PART
echo(function_lang('UPLOAD_UNSAFE',$conf_lang,$db_pref,array($future_file_name)));
$nation_name = mysql_fetch_array(mysql_query('SELECT Name FROM '.$db_pre.'data WHERE NatID = \''.$folder_num.'\''));
function_email("Culture Upload Failed",$_FILES,$nation_name['Name'],$folder_num);
//END NO PART
}
echo('<br /><br />'.function_lang('UPLOAD_GOBACK',$conf_lang,$db_pref,array($_SERVER['HTTP_REFERER'])));
echo('</div>');
include('footer.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>');
include('footer.php');
?>
$name = mysql_fetch_array(mysql_query('SELECT Name FROM '.$db_pre.'data WHERE NatID = \''.$_GET['ID'].'\''));
echo('<h1>'.function_lang('FLAGUP_TITLE',$conf_lang,$db_pref,array($name['Name'])).'</h1>
<form action="upload_flag2.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="NatID" value="'.$_GET['ID'].'" />
<table border="1">
<tr>
<td><b>'.function_lang('INFO_COL_TYPE',$conf_lang,$db_pref).':</b></td>
<td><input type="radio" name="Type" value="Main" />'.function_lang('FLAGUP_TYPE_MAIN',$conf_lang,$db_pref).' - '.function_lang('FLAGUP_WARNING_MAIN',$conf_lang,$db_pref).'<br />
<input type="radio" name="Type" value="Provincial" />'.function_lang('FLAGUP_TYPE_PROVINCE',$conf_lang,$db_pref).'<br />
<input type="radio" name="Type" value="Historic" />'.function_lang('FLAGUP_TYPE_HISTORIC',$conf_lang,$db_pref).'</td>
</tr><tr>
<td><b>'.function_lang('INFO_COL_UPLOAD',$conf_lang,$db_pref).':</b></td>
<td><input type="file" name="Flag" id="Flag" /></td>
</tr><tr>
<td><b>'.function_lang('INFO_COL_AREA',$conf_lang,$db_pref).':</b></td>
<td><input type="text" name="Area" /></td>
</tr><tr>
<td><b>'.function_lang('INFO_COL_DESC',$conf_lang,$db_pref).':</b></td>
<td><textarea name="Description" rows="3" cols="50"></textarea></td>
</tr><tr>
<td colspan="2"><input type="submit" value="'.function_lang('FLAGUP_SUBMIT',$conf_lang,$db_pref).'" /></td>
</tr>
</table>
</form>');
include('footer.php');
?>
echo('<img src="'.$graph_URL.'" alt="'.function_lang('INFO_ACT_GRAPH_ALT',$conf_lang,$db_pref,array($dat_data['Name'])).'" />');
echo($table_code.'</table>');
}
echo('<div class="mod">'.function_lang('CHANGE_ACTIVITY',$conf_lang,$db_pref,array($_GET['ID'])).'</div>');
unset($raw_activity,$num_activity,$dat_activity,$new_time,$old_count,$post_change,$old_time,$time_change,$old_time,$PPD,$graph_days,$graph_URL,$graph_count,$table_code);
/////////////////////////////////////////////////OLD AND BROKEN CODE//////////////////////////////////////////////////
//$forums = mysql_num_rows(mysql_query("SELECT ID FROM ".$db_pre."forums WHERE NatID = '".$_GET['ID']."'"));
//$websites = mysql_num_rows(mysql_query("SELECT ID FROM ".$db_pre."websites WHERE NatID = '".$_GET['ID']."'"));
////$maps = mysql_num_rows(mysql_query("SELECT ID FROM ".$db_pre."maps WHERE NatID = '".$_GET['ID']."'"));
//$logs = mysql_num_rows(mysql_query("SELECT ID FROM ".$db_pre."activity WHERE NatID = '".$_GET['ID']."'"));
//$cultures = mysql_num_rows(mysql_query("SELECT ID FROM ".$db_pre."culture WHERE NatID = '".$_GET['ID']."'"));
//$raw_latesttotal = mysql_query('SELECT `Total` FROM `'.$db_pre.'ratings` WHERE `NatID` = \''.$_GET['ID'].'\' ORDER BY `Date` DESC LIMIT 0,1');
//$dat_latesttotal = mysql_fetch_array($raw_latesttotal);
//$latest_rating = $dat_latesttotal['Total'];
//echo('Forums: <a href="forums.php?ID='.$_GET[ID].'">'.$forums.'</a><br />
//Websites: <a href="websites.php?ID='.$_GET[ID].'">'.$websites.'</a><br />');
//echo('Maps: <a href="maps.php?ID='.$_GET[ID].'">'.$maps.'</a><br />');
//echo('Activity Logs: <a href="activity.php?ID='.$_GET[ID].'">'.$logs.'</a><br />
//Cultural items: <a href="cultures.php?ID='.$_GET[ID].'">'.$cultures.'</a><br />
//OMRC Rating: <a href="rating.php?ID='.$_GET['ID'].'">'.$latest_rating.'</a><br />
//<hr />');
echo('</div><br /><div id="visits">'.function_lang('NUM_VISITS',$conf_lang,$db_pref,array($visits)).'</div>');
include('footer.php');
?>
<td>'.function_lang('ADDFORM_NAME_SHORT',$conf_lang,$db_pref).'</td>
<td><input type="text" name="Name" /></td>
</tr><tr>
<td>'.function_lang('ADDFORM_NAME_LONG',$conf_lang,$db_pref).'</td>
<td><input type="text" size="60" name="Full_name" /></td>
</tr><tr>
<td>'.function_lang('ADDFORM_STATUS',$conf_lang,$db_pref).'</td>
<td><input type="radio" name="Status" value="Alive" />'.function_lang('ADDFORM_STATUS_ALIVE',$conf_lang,$db_pref).'<br />
<input type="radio" name="Status" value="Dead" />'.function_lang('ADDFORM_STATUS_DEAD',$conf_lang,$db_pref).'</td>
</tr><tr>
<td>'.function_lang('ADDFORM_FOUNDING_DATE',$conf_lang,$db_pref).'</td>
<td><input type="text" size="2" name="FAOF_D" />/<input type="text" size="2" name="FAOF_M" />/<input type="text" size="4" name="FAOF_Y" /> '.function_lang('ADDFORM_DATEFORMAT',$conf_lang,$db_pref).'</td>
</tr><tr>
<td>'.function_lang('ADDFORM_LANGUAGE',$conf_lang,$db_pref).'</td>
<td><input type="text" name="Language" /></td>
</tr><tr>
<td>'.function_lang('ADDFORM_NUM_FORUMS',$conf_lang,$db_pref).'</td>
<td><input type="text" size ="2" name="Num_fora" /></td>
</tr><tr>
<td>'.function_lang('ADDFORM_NUM_WEBSITES',$conf_lang,$db_pref).'</td>
<td><input type="text" size ="2" name="Num_sites" /></td>
</tr>
</table>
<input type="submit" value="'.function_lang('ADDFORM_PROCEED',$conf_lang,$db_pref).'" />
</form>');
include('footer.php');
?>
<td><input type="text" name="Website'.$a.'_address" /></td>
</tr><tr>
<td>'.function_lang('ADDFORM_WEBSITE_TYPE',$conf_lang,$db_pref).'</td>
<td><select name="Website'.$a.'_type">');
$raw_sitetypes = mysql_query('SELECT DISTINCT `Type` FROM `'.$db_pref.'websites` ORDER BY `Type`');
$num_sitetypes = mysql_num_rows($raw_sitetypes);
for($b=0;$b<$num_sitetypes;$b++) {
$dat_sitetypes = mysql_fetch_array($raw_sitetypes);
echo('<option value="'.$dat_sitetypes['Type'].'">'.$dat_sitetypes['Type'].'</option>');
}
echo('<option value="Other">Other</option>
</select></td>
</tr><tr>
<td>'.function_lang('ADDFORM_WEBSITE_STATUS',$conf_lang,$db_pref).'</td>
<td><input type="radio" name="Website'.$a.'_status" value="In use" />'.function_lang('ADDFORM_STATUS_INUSE',$conf_lang,$db_pref).'<br />
<input type="radio" name="Website'.$a.'_status" value="Dead" />'.function_lang('ADDFORM_STATUS_DEAD',$conf_lang,$db_pref).'</td>
</tr><tr>
<td>'.function_lang('ADDFORM_WEBSITE_LANGUAGE',$conf_lang,$db_pref).'</td>
<td><input type="text" name="Website'.$a.'_language" /></td>
</tr>');
if($a!=($_POST['Num_sites']-1)) {
echo('<tr><td colspan="2"></td></tr>');
}}
if($_POST['Num_sites']!=0) { echo('</table>'); }
echo('<input type="submit" value="'.function_lang('ADDFORM_SUBMIT',$conf_lang,$db_pref).'" />
</form>');
include('footer.php');?>
<?include('header.php');?>
<h1>The System is adding your nation to the list.</h1>
<br />
<?
include('connect.php');
if(!isset($_POST['Name']) || !isset($_POST['Status'])) {
echo('Required data has not been entered.');
include('footer.php');
die();
}
//email admin
function_email("New Nation",$_POST,0,0);
//convert non latin characters
$_POST['Name'] = function_nonlatinconv('orig','html',$_POST['Name']);
$_POST['Full_name'] = function_nonlatinconv('orig','html',$_POST['Full_name']);
include('admin/actions/function.addnation.php');
function_action_addnation($_POST,$db_pre);
echo('<meta http-equiv="refresh" content="2;url=index.php">');
echo('<br />'.function_lang('ADDFORM_ADDED',$conf_lang,$db_pref));
include('footer.php');
?>
require_once('recaptchalib.php');
$privatekey = "6Ldj_7sSAAAAAKiK3_8R6qxpdFjT-An0Hjbw2mt1";
$resp = recaptcha_check_answer ($privatekey,
$_SERVER["REMOTE_ADDR"],
$_POST["recaptcha_challenge_field"],
$_POST["recaptcha_response_field"]);
if (!$resp->is_valid) {
// What happens when the CAPTCHA was entered incorrectly
echo ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .
"(reCAPTCHA said: " . $resp->error . ")");
include('footer.php');
die();
} else {
// Your code here to handle a successful verification
mysql_query('INSERT INTO `'.$db_pref.'modifications` (`NatID`,`Type`,`Timestamp`,`Name`,`IP`,`Suggestion`)
VALUES (\''.$NatID.'\',\''.$Type.'\',\''.$Timestamp.'\',\''.$Name.'\',\''.$IP.'\',\''.$Desc.'\')');
$raw_name = mysql_query('SELECT `Name` FROM `'.$db_pref.'data` WHERE `NatID` = \''.$NatID.'\'');
$dat_name = mysql_fetch_array($raw_name);
function_email("Modification requested",$dat_name['Name'],$Type,$Desc);
echo(function_lang('REQUESTMOD_REQUESTED',$conf_lang,$db_pref,array($NatID)));
}
include('footer.php');
?>
