Tema: Error MySQL
Ver Mensaje Individual
  #2 (permalink)  
Antiguo 26/05/2011, 15:34
Duffing
 
Fecha de Ingreso: mayo-2011
Mensajes: 47
Antigüedad: 13 años
Puntos: 0
Respuesta: Error MySQL
Código: 
{
		$createuser = mysql_query("INSERT INTO wqw_users (username, password, email, age, dob, signupip, gender, coins, currentclass, plaColorSkin, plaColorHair, plaColorEyes)
		VALUES ('$username', '$pass', '$email', '$age', '$dob', '$ip','$gender',50000,'1','$skincol','$haircol','$eyecol')"); 
	}
	$usersql = mysql_query("SELECT id FROM wqw_users WHERE username='$username'") or die ("Query failed with error: ".mysql_error());
	$userquery = mysql_fetch_array($usersql);
	$userid = $userquery["id"];
	$addweapon = mysql_query("INSERT INTO wqw_items (itemid, userid, equipped, sES, iLvl) VALUES ('1', '$userid', '1', 'Weapon', '1')"); 
	//Add's Starting Armor
switch ($classid) {
	case 1: //Warrior
		$addarmour = mysql_query("INSERT INTO wqw_items (itemid, userid, equipped, sES, iLvl, classXP, className) VALUES ('16', '$userid', '1', 'ar', '1', '0', 'The Hybrid Class')") or die("Error adding class! contact PDL Staff immediately!" . mysql_error());
		$updateclass = mysql_query("UPDATE wqw_users SET currentClass=1 WHERE id=$userid");
		break;
	case 4: //Ninja
		$addarmour = mysql_query("INSERT INTO wqw_items (itemid, userid, equipped, sES, iLvl, classXP, className) VALUES ('293', '$userid', '1', 'ar', '1', '0', 'Ninja Class')") or die("Error adding class! contact PDL Staff immediately!" . mysql_error());
		$updateclass = mysql_query("UPDATE wqw_users SET currentClass=4 WHERE id=$userid");
		break;
	case 3: //Mage
		$addarmour = mysql_query("INSERT INTO wqw_items (itemid, userid, equipped, sES, iLvl, classXP, className) VALUES ('143', '$userid', '1', 'ar', '1', '0', 'Mage Class')") or die("Error adding class! contact PDL Staff immediately!" . mysql_error());
		$updateclass = mysql_query("UPDATE wqw_users SET currentClass=3 WHERE id=$userid");
		break;
	case 10: //Berserker
		$addarmour = mysql_query("INSERT INTO wqw_items (itemid, userid, equipped, sES, iLvl, classXP, className) VALUES ('864', '$userid', '1', 'ar', '1', '0', 'Berserker')") or die("Error adding class! contact PDL Staff immediately!" . mysql_error());
		$updateclass = mysql_query("UPDATE wqw_users SET currentClass=10 WHERE id=$userid");
		break;
}		
	$addfriends = mysql_query("INSERT INTO wqw_friends (userid) VALUES ('$userid')");
	$achievements = mysql_query("INSERT INTO wqw_achievements (username, achievement_image) VALUES ('$username','badge-bt.png')");
 include "top.php";
 echo "Your character has been created and is automatically activated with chat enabled, but your account is not an upgrade so you can't buy upgrade items unless you gain membership in the server";
  include "bottom.php";
 } 
 else 
 {	
 include "top.php";
 ?>
 <form action="signup.php" method="post" style="width: 550px;">
 
<h3>Create a free account</h3>
<p> Note: This server contains full support to girls so don't always pick male ^_^</p>
 <tr><td>Username:</td><td>
 <input id="username" type="text" name="strUsername" size="50%">
 </td></tr>
 <tr><td>Password:</td><td>
 <input type="password" name="strPassword" size="50%">
 </td></tr>
 <tr><td>Confirm Password:</td><td>
 <input type="password" name="strPassword2" size="50%">
 </td></tr>
 <tr><td>Starting Class:</td><td>
 <select name="ClassID">
 	<option value="1">PokePirate</option>
</option>
 </select>
 </td></tr>
 <tr><td>Date of Birth:</td><td>
  <select name="date">
<option value="1">January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
 <select name="day">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
 <select name="year">
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
</select>
 </td></tr>
 <tr><td>Gender:</td><td>
 <select name="strGender" id="gender">
<option value="M">Male</option>
<option value="F">Female</option>
</select>
 </td></tr>
 <tr><td>Skin Color:</td><td>
<input name="skincol" id="skincol" class="color" size="50%">
 </td></tr>
 <tr><td>Hair Color:</td><td>
<input name="haircol" id="haircol" class="color" size="50%">
 </td></tr>
 <tr><td>Eye Color:</td><td>
<input name="eyecol" id="eyecol" class="color" size="50%">
 </td></tr>
 <tr><td>Email:</td><td>
 <input type="text" name="strEmail" value="[email protected]" size="50%">
 </td></tr>
 <tr><td>Security Image:</td><td>
 <img id="imgCaptcha" src="captcha.php" />
 </td></tr>
 <tr><td>Security Code:</td><td>
 <input type="text" size="20%" maxlength="6" name="strSecur">
 </td></tr>
<td colspan='2' align='center'><input type="submit" name="submit" value="Sign Up! and Get 50k AC as reward!"></td>
<script src="http://jscolor.com/jscolor/jscolor.js"></script>
 </form>
 <?php
  include "bottom.php";
 }
 ?>
Si nececitan mas Informacion de la Base de datos posten y yo la agrego.

Desde ya muchas gracias.