Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
Title: Duplicate entry '33329' for key 'PRIMARY`?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Exilo" data-source="post: 103690" data-attributes="member: 15964"><p>[code]<?php</p><p>/*=======================================================================</p><p>| UberWeb - Lightweight site system for Uber</p><p>| #######################################################################</p><p>| Copyright (c) 2009, Roy 'Meth0d'</p><p>| http://www.meth0d.org</p><p>| #######################################################################</p><p>| This program is free software: you can redistribute it and/or modify</p><p>| it under the terms of the GNU General Public License as published by</p><p>| the Free Software Foundation, either version 3 of the License, or</p><p>| (at your option) any later version.</p><p>| #######################################################################</p><p>| This program is distributed in the hope that it will be useful,</p><p>| but WITHOUT ANY WARRANTY; without even the implied warranty of</p><p>| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</p><p>| GNU General Public License for more details.</p><p>\======================================================================*/</p><p> </p><p>require_once "global.php";</p><p> </p><p>if (mysql_num_rows(mysql_query("SELECT * FROM users WHERE ip_last = '" . $_SERVER["REMOTE_ADDR"] . "'")) > 19)</p><p>{</p><p>die('<h1>Hold up!</h2><hr>You have way too many accounts. You are not allowed any more.');</p><p>}</p><p> </p><p>if (LOGGED_IN)</p><p>{</p><p>header("Location: " . WWW . "/me");</p><p>exit;</p><p>}</p><p> </p><p>$tpl->SetParam('error-messages-holder', '');</p><p>$tpl->SetParam('post-name', '');</p><p>$tpl->SetParam('post-pass', '');</p><p>$tpl->SetParam('post-tos-check', '');</p><p>$tpl->SetParam('post-mail', '');</p><p> </p><p>if (isset($_GET['doSubmit']))</p><p>{</p><p>if (isset($_POST['checkNameOnly']) && $_POST['checkNameOnly'] == 'true')</p><p>{</p><p>//$name = $_POST['bean_avatarName'];</p><p>$name = filter($_POST['bean_avatarName']); </p><p> </p><p>echo ' <div class="field field-habbo-name"></p><p> <label for="habbo-name">Username</label></p><p> <input type="text" id="habbo-name" size="32" value="' . clean($name) . '" name="bean.avatarName" class="text-field" maxlength="32"/></p><p> <a href="#" class="new-button" id="check-name-btn"><b>Check</b><i></i></a> </p><p> <input type="submit" name="checkNameOnly" id="check-name" value="Check"/></p><p> <div id="name-suggestions">';</p><p> </p><p>if ($users->IsNameTaken($name))</p><p>{</p><p>echo '<div class="taken"><p>Sorry, the name <strong>' . clean($name) . '</strong> is taken!</p></div>';</p><p>}</p><p>else if ($users->IsNameBlocked($name))</p><p>{</p><p>echo '<div class="taken"><p>Sorry, that name is reserved or disallowed.</p></div>';</p><p>}</p><p>else if (!$users->IsValidName($name))</p><p>{</p><p>echo '<div class="taken"><p>Sorry, that name is invalid. Your name can contain lowercase, uppercase letters, and numbers.</p></div>';</p><p>}</p><p>else</p><p>{</p><p>echo '<div class="available"><p>The name <strong>' . clean($name) . '</strong> is available.</p></div>';</p><p>}</p><p> </p><p>echo ' </div> </p><p> <p class="help">Your name can contain lowercase and uppercase letters and numbers.</p></p><p> </div>';</p><p> </p><p>exit;</p><p>}</p><p>else if (isset($_POST['bean_avatarName']))</p><p>{</p><p>$registerErrors = Array();</p><p> </p><p>$name = filter($_POST['bean_avatarName']);</p><p>$password = $_POST['bean_password'];</p><p>$password2 = $_POST['bean_retypedPassword'];</p><p>$email = filter($_POST['bean_email']);</p><p>//$dob_day = $_POST['bean_day'];</p><p>//$dob_month = $_POST['bean_month'];</p><p>//$dob_year = $_POST['bean_year'];</p><p>//$lang = $_POST['bean_lang'];</p><p> </p><p>$tpl->SetParam('post-name', $name);</p><p>$tpl->SetParam('post-pass', $password);</p><p>$tpl->SetParam('post-mail', $email);</p><p> </p><p>if (strlen($name) < 1 || strlen($name) > 32)</p><p>{</p><p>$registerErrors[] = "Your username must be 1 - 32 characters in length.";</p><p>}</p><p> </p><p>if ($users->IsNameTaken($name))</p><p>{</p><p>$registerErrors[] = "Sorry, that name is taken.";</p><p>}</p><p>else if ($users->IsNameBlocked($name))</p><p>{</p><p>$registerErrors[] = "Sorry, that name is reserved or disallowed.";</p><p>}</p><p>else if (!$users->IsValidName($name))</p><p>{</p><p>$registerErrors[] = "Sorry, that name is invalid. Your name can contain lowercase, uppercase letters, and numbers.";</p><p>}</p><p> </p><p>if (strlen($password) < 6)</p><p>{</p><p>$registerErrors[] = "Your password must be at least 6 characters long.";</p><p>}</p><p> </p><p>if ($password != $password2)</p><p>{</p><p>$registerErrors[] = "Your passwords do not match. Please try again.";</p><p>}</p><p> </p><p>if (!$users->IsValidEmail($email))</p><p>{</p><p>$registerErrors[] = "Invalid e-mail address.";</p><p>}</p><p> </p><p>/*if (!is_numeric($dob_day) || !is_numeric($dob_month) || !is_numeric($dob_year) || $dob_day <= 0 || $dob_day > 31 ||</p><p>$dob_month <= 0 || $dob_month > 12 || $dob_year < 1900 || $dob_year > 2010)</p><p>{</p><p>$registerErrors[] = "Please enter a valid date of birth.";</p><p>}</p><p>*/</p><p>if (!isset($_POST['bean_tos']) || $_POST['bean_tos'] != "accept")</p><p>{</p><p>$registerErrors[] = "You need to accept the Rules and Terms and Conditions to create an account.";</p><p>}</p><p>else</p><p>{</p><p>$tpl->SetParam('post-tos-check', 'checked');</p><p>}</p><p> </p><p>/*if (strtolower($lang) != "yes, i will speak english" && strtolower($lang) != "yes, i will speak english.")</p><p>{</p><p>$registerErrors[] = "You must verify you will speak English to creat an account.";</p><p>}*/</p><p> </p><p>if (count($registerErrors) <= 0)</p><p>{</p><p>// Add user</p><p>$users->add($name, $users->UserHash($password, $name), $email, 1, 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-', 'M');</p><p>mysql_query("UPDATE users SET newcrypto = '1' WHERE username = '" . $name . "'");</p><p> </p><p>// Log user in</p><p>$_SESSION['SHOW_WELCOME'] = true;</p><p>$_SESSION['UBER_USER_N'] = $name;</p><p>$_SESSION['UBER_USER_H'] = $users->UserHash($password, $name);</p><p> </p><p>// Redirect user to welcome page</p><p>header("Location: /client");</p><p>exit;</p><p>}</p><p>else</p><p>{</p><p>$errResult = '<div class="error-messages-holder"> </p><p><h3>Please fix the following problems and resubmit the form.</h3> </p><p><ul>';</p><p> </p><p>foreach ($registerErrors as $err)</p><p>{</p><p>$errResult .= '<li><p class="error-message">' . $err . '</p></li>';</p><p>}</p><p> </p><p>$errResult .= '</ul></div>';</p><p> </p><p>$tpl->SetParam('error-messages-holder', $errResult);</p><p>}</p><p>}</p><p>}</p><p> </p><p>$tpl->Init();</p><p> </p><p>$tpl->AddGeneric('head-init');</p><p>$tpl->AddIncludeSet('register');</p><p>$tpl->WriteIncludeFiles();</p><p>$tpl->AddGeneric('head-bottom');</p><p>$tpl->AddGeneric('page-register');</p><p>$tpl->AddGeneric('footer');</p><p> </p><p>$tpl->SetParam('page_title', 'Register your account!');</p><p> </p><p>$tpl->Output();</p><p> </p><p>?>[/code] This is the register PHP. I don't know how to fix it <img src="/styles/default/xenforo/smilies/emojione/tongue.png" class="smilie" loading="lazy" alt=":p" title="Stick Out Tongue :p" data-shortname=":p" /></p></blockquote><p></p>
[QUOTE="Exilo, post: 103690, member: 15964"] [code]<?php /*======================================================================= | UberWeb - Lightweight site system for Uber | ####################################################################### | Copyright (c) 2009, Roy 'Meth0d' | http://www.meth0d.org | ####################################################################### | This program is free software: you can redistribute it and/or modify | it under the terms of the GNU General Public License as published by | the Free Software Foundation, either version 3 of the License, or | (at your option) any later version. | ####################################################################### | This program is distributed in the hope that it will be useful, | but WITHOUT ANY WARRANTY; without even the implied warranty of | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | GNU General Public License for more details. \======================================================================*/ require_once "global.php"; if (mysql_num_rows(mysql_query("SELECT * FROM users WHERE ip_last = '" . $_SERVER["REMOTE_ADDR"] . "'")) > 19) { die('<h1>Hold up!</h2><hr>You have way too many accounts. You are not allowed any more.'); } if (LOGGED_IN) { header("Location: " . WWW . "/me"); exit; } $tpl->SetParam('error-messages-holder', ''); $tpl->SetParam('post-name', ''); $tpl->SetParam('post-pass', ''); $tpl->SetParam('post-tos-check', ''); $tpl->SetParam('post-mail', ''); if (isset($_GET['doSubmit'])) { if (isset($_POST['checkNameOnly']) && $_POST['checkNameOnly'] == 'true') { //$name = $_POST['bean_avatarName']; $name = filter($_POST['bean_avatarName']); echo ' <div class="field field-habbo-name"> <label for="habbo-name">Username</label> <input type="text" id="habbo-name" size="32" value="' . clean($name) . '" name="bean.avatarName" class="text-field" maxlength="32"/> <a href="#" class="new-button" id="check-name-btn"><b>Check</b><i></i></a> <input type="submit" name="checkNameOnly" id="check-name" value="Check"/> <div id="name-suggestions">'; if ($users->IsNameTaken($name)) { echo '<div class="taken"><p>Sorry, the name <strong>' . clean($name) . '</strong> is taken!</p></div>'; } else if ($users->IsNameBlocked($name)) { echo '<div class="taken"><p>Sorry, that name is reserved or disallowed.</p></div>'; } else if (!$users->IsValidName($name)) { echo '<div class="taken"><p>Sorry, that name is invalid. Your name can contain lowercase, uppercase letters, and numbers.</p></div>'; } else { echo '<div class="available"><p>The name <strong>' . clean($name) . '</strong> is available.</p></div>'; } echo ' </div> <p class="help">Your name can contain lowercase and uppercase letters and numbers.</p> </div>'; exit; } else if (isset($_POST['bean_avatarName'])) { $registerErrors = Array(); $name = filter($_POST['bean_avatarName']); $password = $_POST['bean_password']; $password2 = $_POST['bean_retypedPassword']; $email = filter($_POST['bean_email']); //$dob_day = $_POST['bean_day']; //$dob_month = $_POST['bean_month']; //$dob_year = $_POST['bean_year']; //$lang = $_POST['bean_lang']; $tpl->SetParam('post-name', $name); $tpl->SetParam('post-pass', $password); $tpl->SetParam('post-mail', $email); if (strlen($name) < 1 || strlen($name) > 32) { $registerErrors[] = "Your username must be 1 - 32 characters in length."; } if ($users->IsNameTaken($name)) { $registerErrors[] = "Sorry, that name is taken."; } else if ($users->IsNameBlocked($name)) { $registerErrors[] = "Sorry, that name is reserved or disallowed."; } else if (!$users->IsValidName($name)) { $registerErrors[] = "Sorry, that name is invalid. Your name can contain lowercase, uppercase letters, and numbers."; } if (strlen($password) < 6) { $registerErrors[] = "Your password must be at least 6 characters long."; } if ($password != $password2) { $registerErrors[] = "Your passwords do not match. Please try again."; } if (!$users->IsValidEmail($email)) { $registerErrors[] = "Invalid e-mail address."; } /*if (!is_numeric($dob_day) || !is_numeric($dob_month) || !is_numeric($dob_year) || $dob_day <= 0 || $dob_day > 31 || $dob_month <= 0 || $dob_month > 12 || $dob_year < 1900 || $dob_year > 2010) { $registerErrors[] = "Please enter a valid date of birth."; } */ if (!isset($_POST['bean_tos']) || $_POST['bean_tos'] != "accept") { $registerErrors[] = "You need to accept the Rules and Terms and Conditions to create an account."; } else { $tpl->SetParam('post-tos-check', 'checked'); } /*if (strtolower($lang) != "yes, i will speak english" && strtolower($lang) != "yes, i will speak english.") { $registerErrors[] = "You must verify you will speak English to creat an account."; }*/ if (count($registerErrors) <= 0) { // Add user $users->add($name, $users->UserHash($password, $name), $email, 1, 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-', 'M'); mysql_query("UPDATE users SET newcrypto = '1' WHERE username = '" . $name . "'"); // Log user in $_SESSION['SHOW_WELCOME'] = true; $_SESSION['UBER_USER_N'] = $name; $_SESSION['UBER_USER_H'] = $users->UserHash($password, $name); // Redirect user to welcome page header("Location: /client"); exit; } else { $errResult = '<div class="error-messages-holder"> <h3>Please fix the following problems and resubmit the form.</h3> <ul>'; foreach ($registerErrors as $err) { $errResult .= '<li><p class="error-message">' . $err . '</p></li>'; } $errResult .= '</ul></div>'; $tpl->SetParam('error-messages-holder', $errResult); } } } $tpl->Init(); $tpl->AddGeneric('head-init'); $tpl->AddIncludeSet('register'); $tpl->WriteIncludeFiles(); $tpl->AddGeneric('head-bottom'); $tpl->AddGeneric('page-register'); $tpl->AddGeneric('footer'); $tpl->SetParam('page_title', 'Register your account!'); $tpl->Output(); ?>[/code] This is the register PHP. I don't know how to fix it :P [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Title: Duplicate entry '33329' for key 'PRIMARY`?
Top