</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'); ?>