why

3XTR3M3 · September 6, 2007

";
$ip = ($_SERVER['HTTP_X_FORWARDED_FOR'])
? $_SERVER['HTTP_X_FORWARDED_FOR']
: $_SERVER['REMOTE_ADDR'];
if(file_exists('ipbans/'.$ip))
{
die("Your IP has been banned, there is no way around this.

-Matt- · September 6, 2007

Re: why

your sql is all right?

3XTR3M3 · September 6, 2007

Re: why

yep its just when i added that class

hamster01 · September 6, 2007

Re: why

There is a problem with your mysql insert query.

Please let me know what the column name for the 'class' is.

If it is 'class' use the following query;

INSERT INTO users (username, login_name, userpass, level, money, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, class, gender, signedup, email,  lastip) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm,  1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['class']}', '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}',  '$ip')

seanybob · September 6, 2007

Re: why

There is a problem with your mysql insert query.

Please let me know what the column name for the 'class' is.

If it is 'class' use the following query;

INSERT INTO users (username, login_name, userpass, level, money, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, class, gender, signedup, email,  lastip) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm,  1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['class']}', '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}',  '$ip')

good catch, I missed that when I went over it

3XTR3M3 · September 6, 2007

Re: why

INSERT INTO users (username, login_name, userpass, level, money, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, class, gender, signedup, email,  lastip) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm,  1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['class']}', '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}',  '$ip')

i get this now

Parse error: syntax error, unexpected T_STRING in /home/liam/public_html/register.php on line 60

-Matt- · September 6, 2007

Re: why

lol i would just restore the mccodes login page and start again ;)

3XTR3M3 · September 6, 2007

Re: why

were talking about a reg page mate now a login

-Matt- · September 6, 2007

Re: why

woops register page then

3XTR3M3 · September 6, 2007

Re: why

there is nothing wrong with it though as soon as i removed from after ip $c); i get that enclasped what ever``

hamster01 · September 6, 2007

Re: why

Ferdi spoon feeds the kitten(btw. I'm allergic to cats and dogs).

<?php
 session_start();
 print "<html>
<head>
<title>Deaths-City</title>
<style>
body { font-family:Verdana;font-size:9pt;color: black;
  background-color:#333333;
  scrollbar-base-color: #005B70;
  scrollbar-arrow-color: #F3960B;
  scrollbar-DarkShadow-Color: #000000; }
a:visited,a:active,a:hover,a:link { color: black;text-decoration: none; }
table,tr,td { font-size:9pt; }
img { border:none; }
</style>
</head>
<body>[img=mybanner.gif]
";
 $ip = ($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
 if (file_exists('ipbans/' . $ip)) {
     die("[b]<font color=red size=+1>Your IP has been banned, there is no way around this.</font>[/b]</body></html>");
 }
 require "mysql.php";
 global $c;
 if ($_POST['username']) {
     $sm = 100;
     if ($_POST['promo'] == "Your Promo Code Here") {
         $sm += 100;
     }
     $username = $_POST['username'];
     $username = str_replace(array("<", ">"), array("<", ">"), $username);
     $q = mysql_query("SELECT * FROM users WHERE username='{$username}'", $c);
     if (mysql_num_rows($q)) {
         print "Username already in use. Choose another.";
     } elseif ($_POST['password'] != $_POST['cpassword']) {
         print "The passwords did not match, go back and try again.";
     } else {
         $_POST['ref'] = abs((int)$_POST['ref']);
         $ip = ($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
         $q = mysql_query("SELECT * FROM users WHERE lastip='$ip' AND userid={$_POST['ref']}", $c);
         if (mysql_num_rows($q)) {
             die("No creating referral multies. Bad dog.");
         }
         if ($_POST['ref']) {
             $q = mysql_query("SELECT * FROM users WHERE userid={$_POST['ref']}", $c);
             $r = mysql_fetch_array($q);
         }
         mysql_query("INSERT INTO users (username, login_name, userpass, level, money, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, class, gender, signedup, email,  lastip) VALUES( '$username', '$username', md5('{$_POST['password']}'), 1, '$sm',  1, 12, 12, 100, 100, 5, 5, 100, 100, 1, '{$_POST['class']}', '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}',  '$ip')", $c);
         $i = mysql_insert_id($c);
         mysql_query("INSERT INTO userstats VALUES($i, 10, 10, 10, 10, 10)", $c);

         if ($_POST['ref']) {
             require "global_func.php";
             mysql_query("UPDATE users SET crystals=crystals+2 WHERE userid={$_POST['ref']}", $c);
             event_add($_POST['ref'], "For refering $username to the game, you have earnt 2 valuable crystals!", $c);
             mysql_query("INSERT INTO referals VALUES('', {$_POST['ref']}, $i, unix_timestamp(),'{$r['lastip']}','$ip')", $c);
         }
         print "You have signed up, enjoy the game.

> [url='login.php']Login[/url]";
     }
 } else {
     print "<h3>Deaths-City Registration</h3>";
     print "<form action=register.php method=post>Username: <input type=text name=username>

Password: <input type=password name=password>

Confirm Password: <input type=password name=cpassword>

Gender: <select type='dropdown' name='gender'><option value='male'>Male</option><option value='female'>Female</option></select>

Email: <input type=text name=email>

Class: <select name='class' type='dropdown'><option>Criminal</option><option>Mobster</option><option>Assasin</option><option>N/A</option></select>

Promo Code: <input type=text name=promo>

<input type=hidden name=ref value='";
     if ($_GET['REF']) {
         print $_GET['REF'];
     }
     print "'>
<input type=submit value=Submit></form>

> [url='login.php']Go Back[/url]";
 }
 print "</body></html>";
?>

3XTR3M3 · September 6, 2007

Re: why

works great thanks ferdi

-Matt- · September 6, 2007

Re: why

cough u could also thank seany for his help

3XTR3M3 · September 6, 2007

Re: why

yep thanks seany join now www.deaths-city.info

-Matt- · September 6, 2007

Re: why

thats better :D why .info

hamster01 · September 6, 2007

Re: why

thats better :D why .info

Because it is much cheaper.

-Matt- · September 6, 2007

Re: why

lol so .info is sad it like u got it free i want like a .com or .net or .co.uk or summit

hamster01 · September 6, 2007

Re: why

Do you know what the domain suffixes mean?

3XTR3M3 · September 8, 2007

Re: why

-Matt- · September 12, 2007

Re: why

?

Sign In

why

Recommended Posts

3XTR3M3

-Matt-

3XTR3M3

hamster01

seanybob

3XTR3M3

-Matt-

3XTR3M3

-Matt-

3XTR3M3

hamster01

3XTR3M3

-Matt-

3XTR3M3

-Matt-

hamster01

-Matt-

hamster01

3XTR3M3

-Matt-

Join the conversation

Browse

Activity

Hosting