function validate_request_checksum()
{
global $_USER;
// No formid found, means we don't have a form posted or getted
if (!isset($_REQUEST['frmid'])) {
return true;
}
// Grab the form id, either by get or by post.
$formid = decrypt_get_vars($_REQUEST['frmid']);
// Check if the result is already found, if so, we can't resend the form
$result = sql_query("SELECT * FROM perihelion.formid WHERE user_id = " . $_USER['id'] . " AND id LIKE '" . $formid . "'");
if (sql_countrows($result) == 1) {
sql_query("UPDATE perihelion.formid SET tries=tries+1 WHERE id='" . $formid . "'");
return false;
}
// Not found, so it's the first time we send this form, save it in the database...
sql_query("INSERT INTO perihelion.formid (id,tries,user_id,page) VALUES ('" . $formid . "', 0, " . $_USER['id'] . ", '" . $_SERVER['PHP_SELF'] . "')");
return true;
}
function validate_planet($value, $empty, &$params, &$formvars)
{
global $_CONFIG;
$result = sql_query("SELECT * FROM " . $_CONFIG['default_db'] . ".s_anomalies WHERE name LIKE '{$value}'");
if (sql_countrows($result) == 0) {
return true;
}
return false;
}
function validate_email_is_ours_or_does_not_exists($value, $empty, &$params, &$formvars)
{
$result = sql_query("SELECT * FROM perihelion.u_users WHERE email LIKE '{$value}'");
if (sql_countrows($result) == 0) {
return true;
}
// Check if it's ours, if so, then this one is allright..
$uid = decrypt_get_vars($formvars['uid']);
$row = sql_fetchrow($result);
if ($row['id'] == $uid) {
return true;
}
return false;
}
function sql_fetchrow($result, $override_row_check = false)
{
assert(!empty($result));
assert(is_bool($override_row_check));
if ($override_row_check == true && sql_countrows($result) == 0) {
perihelion_die("Empty Record Set", "Perihelion found an empty record set.");
}
return @mysql_fetch_array($result);
}
function vessel_in_traderoute($vessel_id)
{
assert(is_numeric($vessel_id));
$result = sql_query("SELECT id FROM a_trades WHERE vessel_id=" . $vessel_id);
if (sql_countrows($result) == 0) {
return false;
}
return true;
}
function user_showinfo($user_id, $extended_info = USER_SHOWINFO_NORMAL)
{
assert(is_numeric($user_id));
$user = user_get_user($user_id);
$px_user = user_get_perihelion_user($user_id);
$result = sql_query("SELECT * FROM perihelion.u_access WHERE user_id=" . $user_id . " ORDER BY login DESC LIMIT 1");
$access = sql_fetchrow($result);
sql_query("USE " . $px_user['galaxy_db']);
$result = sql_query("SELECT SUM(population) FROM s_anomalies WHERE user_id=" . $user_id);
$row = sql_fetchrow($result);
$people = $row['0'];
$result = sql_query("SELECT COUNT(*) FROM s_sectors WHERE user_id=" . $user_id);
$row = sql_fetchrow($result);
$sectors_owned = $row['0'];
$result = sql_query("SELECT COUNT(*) FROM s_anomalies WHERE user_id=" . $user_id);
$row = sql_fetchrow($result);
$planets_owned = $row['0'];
$result = sql_query("SELECT DISTINCT sector_id, COUNT(*) FROM s_anomalies WHERE user_id=" . $user_id . " GROUP BY sector_id");
$sector_count = sql_countrows($result);
$sector = sector_get_sector(user_get_home_sector($user_id));
$planet = anomaly_get_anomaly(user_get_home_planet($user_id));
$race = user_get_race($user_id);
$result = sql_query("SELECT * FROM g_alliance WHERE id=" . $user['alliance_id']);
$alliance = sql_fetchrow($result);
if ($user['alliance_id'] != 0) {
$result = sql_query("SELECT COUNT(*) AS count FROM g_users WHERE alliance_id = " . $alliance['id']);
$tmp = sql_fetchrow($result);
$alliance_size = $tmp['count'];
}
$status = "Unknown";
if (user_is_friend(user_ourself(), $user_id)) {
$status = "Single side friend";
}
if (user_is_mutual_friend(user_ourself(), $user_id)) {
$status = "Mutual friend";
}
if (user_is_neutral(user_ourself(), $user_id)) {
$status = "Neutral";
}
if (user_is_enemy(user_ourself(), $user_id)) {
$status = "Enemy";
}
if (user_ourself() == $user_id) {
$status = "";
}
echo "<table border=0 align=center width=60%>";
echo "<tr><th class=white colspan=2>" . $px_user['name'] . "</th><th> </th></tr>";
echo "<tr><th colspan=2><b>" . $px_user['tag'] . "</b></th></tr>";
echo "<tr valign=top>";
echo " <td width=120>";
echo " <img width=100 height=100 src='images/users/" . $px_user['avatar'] . "'><br>";
echo " <br>";
if ($user['alliance_id'] != 0) {
echo " <img width=100 height=100 src='images/users/" . $alliance['avatar'] . "'><br>";
}
echo " </td>";
echo " <td><table border=0 nowrap>";
echo " <tr class=bl><td> Full Name </td><td>:</td><td> " . $px_user['name'] . " </td></tr>";
echo " <tr class=bl><td> User ID </td><td>:</td><td> " . $px_user['id'] . " </td></tr>";
echo " <tr class=bl><td> City </td><td>:</td><td> " . $px_user['city'] . " </td></tr>";
echo " <tr class=bl><td> Country </td><td>:</td><td> " . $px_user['country'] . " </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
if ($status != "") {
echo " <tr class=bl><td> Diplomatic Status </td><td>:</td><td> " . $status . " </td></tr>";
}
echo " <tr class=bl><td> Race </td><td>:</td><td> " . $race . " </td></tr>";
echo " <tr class=bl><td> Home Planet </td><td>:</td><td> " . $planet['name'] . " </td></tr>";
echo " <tr class=bl><td> Home Sector </td><td>:</td><td> " . $sector['name'] . " </td></tr>";
echo " <tr class=bl><td> Population </td><td>:</td><td> " . $people . " </td></tr>";
echo " <tr class=bl><td> Sectors Owned </td><td>:</td><td> " . $sectors_owned . " </td></tr>";
echo " <tr class=bl><td> Planets Owned </td><td>:</td><td> " . $planets_owned . " planet(s) in " . $sector_count . " sector(s) </td></tr>";
if ($user['alliance_id'] != 0) {
echo " <tr class=bl><td> Alliance </td><td>:</td><td> <a href=alliance.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($alliance['id']) . ">" . $alliance['name'] . "</a> </td></tr>";
echo " <tr class=bl><td> Alliance Size </td><td>:</td><td> " . $alliance_size . " user(s) </td></tr>";
}
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Times logged in </td><td>:</td><td> " . $px_user['login_count'] . " </td></tr>";
echo " <tr class=bl><td> Last login </td><td>:</td><td> " . $access['login'] . " </td></tr>";
echo " <tr class=bl><td> Last action </td><td>:</td><td> " . $access['logout'] . " </td></tr>";
if ($extended_info == USER_SHOWINFO_EXTENDED) {
if ($px_user['gender'] == "M") {
$gender = "Male";
} else {
$gender = "Female";
}
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Email </td><td>:</td><td> " . $px_user['email'] . " </td></tr>";
echo " <tr class=bl><td> Login Name </td><td>:</td><td> " . $px_user['login_name'] . " </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> City </td><td>:</td><td> " . $px_user['city'] . " </td></tr>";
echo " <tr class=bl><td> Country </td><td>:</td><td> " . $px_user['country'] . " </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Birthday </td><td>:</td><td> " . $px_user['birthday'] . " </td></tr>";
echo " <tr class=bl><td> Gender </td><td>:</td><td> " . $gender . " </td></tr>";
}
if ($user_id != user_ourself()) {
echo "<tr><th colspan=3>";
echo "[ <a href=message.php?uid=" . encrypt_get_vars($user_id) . ">Send Message</a> ]";
echo "</th></tr>";
echo "<tr><th colspan=3>";
echo "[ <a href=user.php?cmd=" . encrypt_get_vars("relation") . "&uid=" . encrypt_get_vars($user_id) . "&wid=" . encrypt_get_vars(RELATION_FRIEND) . ">Set as friend</a> ] - ";
echo "[ <a href=user.php?cmd=" . encrypt_get_vars("relation") . "&uid=" . encrypt_get_vars($user_id) . "&wid=" . encrypt_get_vars(RELATION_NEUTRAL) . ">Set as neutral</a> ] - ";
echo "[ <a href=user.php?cmd=" . encrypt_get_vars("relation") . "&uid=" . encrypt_get_vars($user_id) . "&wid=" . encrypt_get_vars(RELATION_ENEMY) . ">Set as enemy</a> ]";
echo "</th></tr>";
}
echo " </table></td>";
echo "</tr>";
echo "</table>";
echo "<br><br>";
}
<?php
// Include Files
include "../includes.inc.php";
// Session Identification
session_identification("admin");
print_header();
print_title("Create Test users for scoring purposes...", "Make sure you have set the correct tables_priv rows for u_users and u_score in the database!");
$result = sql_query("SELECT * FROM perihelion.u_users WHERE id >= 1000");
if (sql_countrows($result) != 0) {
print_line("User Id 1000 or above already exists!");
print_footer();
exit;
}
// Create 1000 users....
for ($i = 1000; $i != 2000; $i++) {
sql_query("INSERT INTO perihelion.u_users (id, login_name, name) VALUES ({$i}, 'plyr{$i}', 'Player {$i}')");
sql_query("INSERT INTO perihelion.u_score (user_id, overall, resource, strategic, exploration) VALUES ({$i}, RAND()*1000, RAND()*1000, RAND()*1000, RAND()*1000)");
echo "Done with player {$i}<br>\n";
}
print_footer();
exit;
