<?
include("config.php");
updatecookie();
include("languages/$lang");
$title = "Make";
include("header.php");
?><title>Credits</title>
<body background="images/bgoutspace1.gif" bgcolor="#000000" text="#FFFFFF">
<?
newplayer("*****@*****.**", "DANTE", "preko", "S.S.DemonHunter");
newplayer("*****@*****.**", "Virgil", "neblev", "Aeneid");
newplayer("*****@*****.**", "Augustus", "lontox", "Lavinia");
TEXT_GOTOMAIN();
echo "\n";
include("footer.php");
?>
header("Cache-control: private");
include "conntube.php";
//callvideoagent('*****@*****.**','*****@*****.**');
// g1_players, g2_gameadmin, g3_gamelog, g4_taboowords
$action = $_REQUEST['action'];
// These variables are sent from server to client on every Routine request.
$s_message = '';
$s_videoid = '';
$s_taboo = '';
$s_sessionscore = '';
$s_opponentstatus = '';
$s_entity = '';
switch ($action) {
case 'PLAY':
// a user wants to play
newplayer();
break;
case '2NDPLAYER':
// a user wants to play
_2ndplayer();
break;
//case 'OPPONENTFOUND': // from CA
// opponentfound();
// break;
//case 'VIDEOFOUND': // from VA
// videofound();
// break;
//case 'OPPONENTFOUND': // from CA
// opponentfound();
// break;
//case 'VIDEOFOUND': // from VA
$db->Execute("INSERT INTO $dbtables[medals] VALUES ('Medal of Light', 'This medal is awarded to the most saintly player of the previous game.', 5, 'light.gif')");
$db->Execute("INSERT INTO $dbtables[medals] VALUES ('Silver Medal', 'Runner-up in last game', 6, 'silver.gif')");
$db->Execute("INSERT INTO $dbtables[medals] VALUES ('Team Medal', 'Winning Alliance member from last game', 7, 'team.gif')");
$db->Execute("INSERT INTO $dbtables[medals] VALUES ('Best Newcomer', 'A medal for the best new player from the last game', 8, 'newbie.gif')");
$db->Execute("INSERT INTO $dbtables[medals] VALUES ('Furangee Quasher', 'An award for the player who for better or for worse destroys the most Furangee', 9, 'fur.gif')");
echo "Done<br>";
$password = substr($admin_mail, 0, $maxlen_password);
echo "Inserting Unowned user into players<br>";
$db->Execute("INSERT INTO $dbtables[players] SET character_name='Unowned'");
// Create a random email and password
$UnownedPassword = createRandomPassword();
$db->Execute("UPDATE `$dbtables[players]` SET `player_id` = '0', `cleared_defences` = NULL, `subscribed` = NULL, email = '$UnownedPassword', password = '******' WHERE `character_name` = 'Unowned' LIMIT 1");
echo "<BR><BR><center><B>Your admin login is: <BR>";
echo "<BR>Username: $admin_mail";
echo "<BR>Password: $password<BR></B></center>";
newplayer($admin_mail, "The Federation", $password, "The Orb");
$db->Execute("UPDATE $dbtables[players] SET player_id = '1', `cleared_defences` = NULL, `subscribed` = NULL WHERE `email` = '$admin_mail' LIMIT 1");
$db->Execute("UPDATE $dbtables[ships] SET player_id = '1' WHERE player_id=2 LIMIT 1");
PrintFlush("<BR><BR><center><BR><B>Congratulations! Universe created successfully.<BR>");
PrintFlush("Click <A HREF=login.php>here</A> to return to the login screen.</B></center>");
break;
// Pre-stage, What's the password?
default:
echo "<form action=create_universe.php method=post>";
echo "Password: <input type=password name=swordfish size=20 maxlength=20> ";
echo "<input type=submit value=Submit><input type=hidden name=step value=1>";
echo "<input type=reset value=Reset>";
echo "</form>";
break;
}
}
$stamp=date("Y-m-d H:i:s");
$query = $db->Execute("SELECT MAX(turns_used + turns) AS mturns FROM $dbtables[players] WHERE character_name NOT LIKE '%furangee%'");
$res = $query->fields;
$mturns = $res[mturns];
if($mturns > $max_turns)
$mturns = $max_turns;
$md5pass = md5($makepass);
//$db->Execute("LOCK TABLES forums.phpbb_users WRITE");
//$result3 = $db->Execute("SELECT MAX(user_id) AS total FROM forums.phpbb_users");
//$row=$result3->fields;
//$user_id=$row[total]+1;
//$result3 = $db->Execute("INSERT INTO forums.phpbb_users SET user_id=$user_id, username='******',user_email='$username',user_password='******',user_regdate=UNIX_TIMESTAMP(),user_sig='Captain of the ship $shipname',user_interests='Captain of the ship $shipname'");
$player_id=newplayer($username, $character, $makepass, $shipname);
if (!$player_id) {
echo $db->ErrorMsg() . "<br>";
} else {
$l_new_message = str_replace("[pass]", $makepass, $l_new_message);
mail("$username", "$l_new_topic", "$l_new_message\r\n\r\nhttp://www$gamedomain/skt","From: $admin_mail\r\nReply-To: $admin_mail\r\nX-Mailer: PHP/" . phpversion());
if($display_password)
{
echo "<b>".$l_new_pwis . " " . $makepass . "</b><BR><BR>";
}
echo "$l_new_pwsent<BR>";
echo "You now need to check your email and log in with the password sent to you.<br>If you do not log in within 1 hour, your account will automatically be deleted and you will have to re-register.<br>Thank you registering to play Starkick Traders!<br><br>";
echo "<img src=images/pictorial/leaving-earth.jpg><br>";
//echo "You have also been registered onto the forums as user $character with the same password.<br><br>";
// Set the cookies
//$userpass = $username."+".$makepass;
include "header.php";
### Connect to the database.
connectdb();
### Print Title on Page.
bigtitle();
if ($swordfish != $adminpass) {
echo "<FORM ACTION=copy_over.php METHOD=POST>";
echo "Password: <INPUT TYPE=PASSWORD NAME=swordfish SIZE=20 MAXLENGTH=20><BR><BR>";
echo "<INPUT TYPE=SUBMIT VALUE=Submit><INPUT TYPE=RESET VALUE=Reset>";
echo "</FORM>";
} else {
// Copy over and delete furangee
$res = $db->Execute("SELECT * FROM bak_players,bak_ships WHERE email NOT LIKE '%furangee' AND ship_id=currentship") or die(mysql_error());
while (!$res->EOF) {
$row = $res->fields;
$player_id = newplayer($row[email], $row[character_name], $row[password], $row[ship_name]);
echo "Player ID = {$player_id}<br>";
if ($player_id > 0) {
echo "Added {$row['character_name']}<br>";
$db->Execute("UPDATE {$dbtables['players']} SET ip_address='{$row['ip_address']}' WHERE email = '{$row['email']}'") or die(mysql_error());
// Profiles
$res2 = $db->Execute("SELECT * FROM bak_profile WHERE player_id={$row['player_id']}");
$profile = $res2->fields;
$profile[story] = addslashes($profile[story]);
$profile[pic_url] = addslashes($profile[pic_url]);
//echo "UPDATE $dbtables[profile] SET skill='$profile[skill]',alignment='$profile[alignment]',story='$profile[story]',pic_url='$profile[pic_url]' WHERE player_id=$player_id<br>";
$db->Execute("UPDATE {$dbtables['profile']} SET skill='{$profile['skill']}',alignment='{$profile['alignment']}',story='{$profile['story']}',pic_url='{$profile['pic_url']}' WHERE player_id={$player_id}") or die(mysql_error());
}
$res->MoveNext();
}
}
