Error
' . $errstr . '
Snowlight login/reg script'); } mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS) or err(mysql_error()); mysql_select_db(SQL_DB) or err(mysql_error()); ?> Snowlight Emulator 0 && strlen($_POST['pwd']) > 0) { $d = mysql_query('SELECT id FROM accounts WHERE username = "' . $usr . '" AND password = "' . $pwd . '" LIMIT 1') or err(mysql_error()); if (mysql_num_rows($d) > 0) { $data = mysql_fetch_assoc($d); mysql_query('UPDATE accounts SET session = "' . SESSION_ID() . '" WHERE id = "' . $data['id'] . '"'); $_SESSION['USER_S'] = true; $_SESSION['USER_I'] = $data['id']; header('Location: index.php'); exit; } echo '

Whoops! We didn\'t recognise your username or password. Please try again.

'; } } echo '
'; echo '
'; echo '

Snowlight Emulator

'; echo '

'; echo '

'; echo ''; echo '
'; echo '

Not registered yet? Click here to create an account.

'; echo '
'; } function outputRegister() { if (isset($_POST['usr']) && isset($_POST['pwd'])) { $usr = mysql_real_escape_string($_POST['usr']); $pwd = sha1($_POST['pwd'] . $usr); if (strlen($usr) > 0 && strlen($_POST['pwd']) > 0) { $q = mysql_query('SELECT null FROM accounts WHERE username = "' . $usr . '"') or die(mysql_error()); if (mysql_num_rows($q) != 0) { echo '

That name is taken, sorry.

'; } else { mysql_query('INSERT INTO accounts (username,password) VALUES ("' . $usr . '","' . $pwd . '")') or die(err(mysql_error())); echo '

Successfully registered, click here to login.

'; } } } echo '
'; echo '
'; echo '

Snowlight Emulator

'; echo '

'; echo '

'; echo ''; echo ''; echo '
'; echo '

Already registered? Back to the frontpage.

'; echo '
'; } function outputCreateCharacter() { if (isset($_POST['usr'])) { $usr = mysql_real_escape_string($_POST['usr']); if (strlen($usr) > 0) { $q = mysql_query('SELECT null FROM characters WHERE username = "' . $usr . '"') or die(mysql_error()); if (mysql_num_rows($q) != 0) { echo '

That name is taken, sorry.

'; } else { mysql_query('INSERT INTO characters (account_uid,username,moderation_muted_until_timestamp) VALUES ("' . $_SESSION['USER_I'] . '","' . $usr . '",0)') or die(err(mysql_error())); echo '

Successfully created, click here to go back.

'; } } } echo '
'; echo '
'; echo '

Snowlight Emulator

'; echo '

'; echo ''; echo '
'; echo '

Don\'t want to create a character? Back to the portal.

'; echo '
'; } function outputLogout() { mysql_query('UPDATE accounts SET session = "" WHERE id = "' . $_SESSION['USER_I'] . '" AND session = "' . SESSION_ID() . '"'); unset($_SESSION['USER_S']); unset($_SESSION['USER_I']); unset($_SESSION); session_unset(); echo '

You just logged out. Back to the frontpage.

'; } function outputPortal() { $div_height = mysql_num_rows(mysql_query('SELECT id FROM characters WHERE account_uid = "' . $_SESSION['USER_I'] . '"')) * 48 + 149; $frm_height = mysql_num_rows(mysql_query('SELECT id FROM characters WHERE account_uid = "' . $_SESSION['USER_I'] . '"')) * 48 + 140; $c = mysql_query('SELECT id, username FROM characters WHERE account_uid = "' . $_SESSION['USER_I'] . '"'); if(mysql_num_rows($c) == 0) { $div_height += 40; $frm_height += 40; } echo '
'; echo '
'; echo '

Snowlight Emulator

'; if (mysql_num_rows($c) > 0) { echo ''; while($character = mysql_fetch_assoc($c)) { echo ''; echo ''; echo ''; echo ''; } echo '
' . $character['username'] . '
'; } else { echo '

It seems you don\'t have any characters, yet.

'; } echo '
'; echo '
'; echo '
'; echo '

Done with everything? Click here to logout.

'; echo '
'; } function outputClient($character) { define('SSO_TICKET', sha1(rand(1000, 9999) . $_SESSION['USER_I'])); mysql_query('UPDATE characters SET auth_ticket = "' . SSO_TICKET . '" WHERE id = ' . $character . ' AND account_uid = ' . $_SESSION['USER_I'] . ' LIMIT 1') or err(mysql_error()); echo '
'; } ?>