Tema: Error MySQL
Ver Mensaje Individual
  #7 (permalink)  
Antiguo 26/05/2011, 15:48
Duffing
 
Fecha de Ingreso: mayo-2011
Mensajes: 47
Antigüedad: 13 años
Puntos: 0
Respuesta: Error MySQL
Código PHP: 
Ver original
  1. {
  2.         $createuser = mysql_query("INSERT INTO wqw_users (username, password, email, age, dob, signupip, gender, coins, currentclass, plaColorSkin, plaColorHair, plaColorEyes)
  3.         VALUES ('$username', '$pass', '$email', '$age', '$dob', '$ip','$gender',50000,'1','$skincol','$haircol','$eyecol')"); 
  4.     }
  5.     $usersql = mysql_query("SELECT id FROM wqw_users WHERE username='$username'") or die ("Query failed with error: ".mysql_error());
  6.     $userquery = mysql_fetch_array($usersql);
  7.     $userid = $userquery["id"];
  8.     $addweapon = mysql_query("INSERT INTO wqw_items (itemid, userid, equipped, sES, iLvl) VALUES ('1', '$userid', '1', 'Weapon', '1')"); 
  9.     //Add's Starting Armor
  10. switch ($classid) {
  11.     case 1: //Warrior
  12.         $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());
  13.         $updateclass = mysql_query("UPDATE wqw_users SET currentClass=1 WHERE id=$userid");
  14.         break;
  15.     case 4: //Ninja
  16.         $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());
  17.         $updateclass = mysql_query("UPDATE wqw_users SET currentClass=4 WHERE id=$userid");
  18.         break;
  19.     case 3: //Mage
  20.         $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());
  21.         $updateclass = mysql_query("UPDATE wqw_users SET currentClass=3 WHERE id=$userid");
  22.         break;
  23.     case 10: //Berserker
  24.         $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());
  25.         $updateclass = mysql_query("UPDATE wqw_users SET currentClass=10 WHERE id=$userid");
  26.         break;
  27. }       
  28.     $addfriends = mysql_query("INSERT INTO wqw_friends (userid) VALUES ('$userid')");
  29.     $achievements = mysql_query("INSERT INTO wqw_achievements (username, achievement_image) VALUES ('$username','badge-bt.png')");
  30.  include "top.php";
  31.  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";
  32.   include "bottom.php";
  33.  } 
  34.  else 
  35.  {  
  36.  include "top.php";
  37.  ?>
  38.  <form action="signup.php" method="post" style="width: 550px;">
  39.  
  40. <h3>Create a free account</h3>
  41. <p> Note: This server contains full support to girls so don't always pick male ^_^</p>
  42.  <tr><td>Username:</td><td>
  43.  <input id="username" type="text" name="strUsername" size="50%">
  44.  </td></tr>
  45.  <tr><td>Password:</td><td>
  46.  <input type="password" name="strPassword" size="50%">
  47.  </td></tr>
  48.  <tr><td>Confirm Password:</td><td>
  49.  <input type="password" name="strPassword2" size="50%">
  50.  </td></tr>
  51.  <tr><td>Starting Class:</td><td>
  52.  <select name="ClassID">
  53.     <option value="1">PokePirate</option>
  54. </option>
  55.  </select>
  56.  </td></tr>
  57.  <tr><td>Date of Birth:</td><td>
  58.   <select name="date">
  59. <option value="1">January</option>
  60. <option value="2">February</option>
  61. <option value="3">March</option>
  62. <option value="4">April</option>
  63. <option value="5">May</option>
  64. <option value="6">June</option>
  65. <option value="7">July</option>
  66. <option value="8">August</option>
  67. <option value="9">September</option>
  68. <option value="10">October</option>
  69. <option value="11">November</option>
  70. <option value="12">December</option>
  71. </select>
  72.  <select name="day">
  73. <option value="01">01</option>
  74. <option value="02">02</option>
  75. <option value="03">03</option>
  76. <option value="04">04</option>
  77. <option value="05">05</option>
  78. <option value="06">06</option>
  79. <option value="07">07</option>
  80. <option value="08">08</option>
  81. <option value="09">09</option>
  82. <option value="10">10</option>
  83. <option value="11">11</option>
  84. <option value="12">12</option>
  85. <option value="13">13</option>
  86. <option value="14">14</option>
  87. <option value="15">15</option>
  88. <option value="16">16</option>
  89. <option value="17">17</option>
  90. <option value="18">18</option>
  91. <option value="19">19</option>
  92. <option value="20">20</option>
  93. <option value="21">21</option>
  94. <option value="22">22</option>
  95. <option value="23">23</option>
  96. <option value="24">24</option>
  97. <option value="25">25</option>
  98. <option value="26">26</option>
  99. <option value="27">27</option>
  100. <option value="28">28</option>
  101. <option value="29">29</option>
  102. <option value="30">30</option>
  103. <option value="31">31</option>
  104. </select>
  105.  <select name="year">
  106. <option value="2001">2001</option>
  107. <option value="2000">2000</option>
  108. <option value="1999">1999</option>
  109. <option value="1998">1998</option>
  110. <option value="1997">1997</option>
  111. <option value="1996">1996</option>
  112. <option value="1995">1995</option>
  113. <option value="1994">1994</option>
  114. <option value="1993">1993</option>
  115. <option value="1992">1992</option>
  116. <option value="1991">1991</option>
  117. <option value="1990">1990</option>
  118. </select>
  119.  </td></tr>
  120.  <tr><td>Gender:</td><td>
  121.  <select name="strGender" id="gender">
  122. <option value="M">Male</option>
  123. <option value="F">Female</option>
  124. </select>
  125.  </td></tr>
  126.  <tr><td>Skin Color:</td><td>
  127. <input name="skincol" id="skincol" class="color" size="50%">
  128.  </td></tr>
  129.  <tr><td>Hair Color:</td><td>
  130. <input name="haircol" id="haircol" class="color" size="50%">
  131.  </td></tr>
  132.  <tr><td>Eye Color:</td><td>
  133. <input name="eyecol" id="eyecol" class="color" size="50%">
  134.  </td></tr>
  135.  <tr><td>Email:</td><td>
  136.  <input type="text" name="strEmail" value="[email protected]" size="50%">
  137.  </td></tr>
  138.  <tr><td>Security Image:</td><td>
  139.  <img id="imgCaptcha" src="captcha.php" />
  140.  </td></tr>
  141.  <tr><td>Security Code:</td><td>
  142.  <input type="text" size="20%" maxlength="6" name="strSecur">
  143.  </td></tr>
  144. <td colspan='2' align='center'><input type="submit" name="submit" value="Sign Up! and Get 50k AC as reward!"></td>
  145. <script src="http://jscolor.com/jscolor/jscolor.js"></script>
  146.  </form>
  147.  <?php
  148.   include "bottom.php";
  149.  }
  150.  ?>