API tools faq
paste
Guest User

Untitled

a guest
Apr 4th, 2010
148
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.62 KB | None | 0 0
raw download clone embed print report
  1. $loginid = strtolower(mysql_real_escape_string($_POST['id']));
  2. $gameid = mysql_real_escape_string($_POST['gid']);
  3. $password = mysql_real_escape_string($_POST['pw1']);
  4. $repeat_password = mysql_real_escape_string($_POST['pw2']);
  5. $email = mysql_real_escape_string($_POST['email']);
  6. $birth_month = mysql_real_escape_string($_POST['birthmonth']);
  7. $birth_day = mysql_real_escape_string($_POST['birthday']);
  8. $birth_year = mysql_real_escape_string($_POST['birthyear']);
  9. $lastname = mysql_real_escape_string($_POST['lname']);
  10. $firstname = mysql_real_escape_string($_POST['fname']);
  11. $gender = mysql_real_escape_string($_POST['gender']);
  12. $birthday = "$birth_year-$birth_month-$birth_day";
  13. $nickdate = date("Y-m-d");
  14. $ip = $_SERVER['REMOTE_ADDR'];
  15. $gold = "350000";
  16. $cash = "50000";
  17. $gp = "1000";
  18. $grade = "19";
  19. function iptocountry($ip) {
  20. $numbers = preg_split( "/\./", $ip);
  21. include("ip_files/".$numbers[0].".php");
  22. $code=($numbers[0] * 16777216) + ($numbers[1] * 65536) + ($numbers[2] * 256) + ($numbers[3]);
  23. foreach($ranges as $key => $value){
  24. if($key<=$code){
  25. if($ranges[$key][0]>=$code){$two_letter_country_code=$ranges[$key][1];break;}
  26. }
  27. }
  28. if ($two_letter_country_code==""){$two_letter_country_code="unkown";}
  29. return $two_letter_country_code;
  30. }
  31. $IPaddress=$_SERVER['REMOTE_ADDR'];
  32. $two_letter_country_code=iptocountry($IPaddress);
  33.  
  34. include("IP_FILES/countries.php");
  35. $three_letter_country_code=$countries[ $two_letter_country_code][0];
  36. $country_name=$countries[$two_letter_country_code][1];
  37.  
  38.  
  39. /*Country name to Country number script*/
  40. if ($country_name=="Andorra") {$country_number="4";}
  41. if ($country_name=="United Arab Emirates") {$country_number="205";}
  42. if ($country_name=="Afghanistan") {$country_number="1";}
  43. if ($country_name=="Antigua And Barbuda") {$country_number="8";}
  44. if ($country_name=="Anguilla") {$country_number="6";}
  45. if ($country_name=="Albania") {$country_number="2";}
  46. if ($country_name=="Armenia") {$country_number="10";}
  47. if ($country_name=="Netherlands Antilles") {$country_number="143";}
  48. if ($country_name=="Angola") {$country_number="5";}
  49. if ($country_name=="Antarctica") {$country_number="7";}
  50. if ($country_name=="Argentina") {$country_number="9";}
  51. if ($country_name=="American Samoa") {$country_number="170";}
  52. if ($country_name=="Austria") {$country_number="13";}
  53. if ($country_name=="Australia") {$country_number="12";}
  54. if ($country_name=="Aruba") {$country_number="11";}
  55. if ($country_name=="Azerbaijan") {$country_number="14";}
  56. if ($country_name=="Bosnia And Herzegovina") {$country_number="26";}
  57. if ($country_name=="Barbados") {$country_number="18";}
  58. if ($country_name=="Bangladesh") {$country_number="17";}
  59. if ($country_name=="Belgium") {$country_number="19";}
  60. if ($country_name=="Burkina Faso") {$country_number="31";}
  61. if ($country_name=="Bulgaria") {$country_number="30";}
  62. if ($country_name=="Bahrain") {$country_number="16";}
  63. if ($country_name=="Burundi") {$country_number="32";}
  64. if ($country_name=="Benin") {$country_number="22";}
  65. if ($country_name=="Bermuda") {$country_number="23";}
  66. if ($country_name=="Brunei Darussalam") {$country_number="29";}
  67. if ($country_name=="Bolivia") {$country_number="25";}
  68. if ($country_name=="Brazil") {$country_number="28";}
  69. if ($country_name=="Bahamas") {$country_number="15";}
  70. if ($country_name=="Bhutan") {$country_number="24";}
  71. if ($country_name=="Botswana") {$country_number="27";}
  72. if ($country_name=="Belarus") {$country_number="21";}
  73. if ($country_name=="Belize") {$country_number="20";}
  74. if ($country_name=="Canada") {$country_number="35";}
  75. if ($country_name=="The Democratic Republic Of The Congo") {$country_number="45";}
  76. if ($country_name=="Central African Republic") {$country_number="38";}
  77. if ($country_name=="Congo") {$country_number="44";}
  78. if ($country_name=="Switzerland") {$country_number="190";}
  79. if ($country_name=="Cote D'ivoire") {$country_number="48";}
  80. if ($country_name=="Cook Islands") {$country_number="46";}
  81. if ($country_name=="Chile") {$country_number="39";}
  82. if ($country_name=="Cameroon") {$country_number="34";}
  83. if ($country_name=="China") {$country_number="40";}
  84. if ($country_name=="Colombia") {$country_number="42";}
  85. if ($country_name=="Costa Rica") {$country_number="47";}
  86. if ($country_name=="Serbia And Montenegro") {$country_number="245";}
  87. if ($country_name=="Cuba") {$country_number="50";}
  88. if ($country_name=="Cape Verde") {$country_number="36";}
  89. if ($country_name=="Cyprus") {$country_number="51";}
  90. if ($country_name=="Czech Republic") {$country_number="52";}
  91. if ($country_name=="Germany") {$country_number="72";}
  92. if ($country_name=="Djibouti") {$country_number="54";}
  93. if ($country_name=="Denmark") {$country_number="53";}
  94. if ($country_name=="Dominica") {$country_number="55";}
  95. if ($country_name=="Dominican Republic") {$country_number="56";}
  96. if ($country_name=="Algeria") {$country_number="3";}
  97. if ($country_name=="Ecuador") {$country_number="57";}
  98. if ($country_name=="Estonia") {$country_number="62";}
  99. if ($country_name=="Egypt") {$country_number="58";}
  100. if ($country_name=="Eritrea") {$country_number="61";}
  101. if ($country_name=="Spain") {$country_number="184";}
  102. if ($country_name=="Ethiopia") {$country_number="63";}
  103. /* DOESN'T EXIST IN ORIGINAL GUNBOUND if ($country_name=="European Union") {$country_number="Unknown";} */
  104. if ($country_name=="Finland") {$country_number="66";}
  105. if ($country_name=="Fiji") {$country_number="65";}
  106. if ($country_name=="Falkland Islands (Malvinas)") {$country_number="64";}
  107. if ($country_name=="Federated States Of Micronesia") {$country_number="132";}
  108. if ($country_name=="Faroe Islands") {$country_number="228";}
  109. if ($country_name=="France") {$country_number="67";}
  110. if ($country_name=="Gabon") {$country_number="70";}
  111. if ($country_name=="United Kingdom") {$country_number="206";}
  112. if ($country_name=="Grenada") {$country_number="78";}
  113. if ($country_name=="Georgia") {$country_number="73";}
  114. if ($country_name=="French Guiana") {$country_number="68";}
  115. if ($country_name=="Ghana") {$country_number="75";}
  116. if ($country_name=="Gibraltar") {$country_number="230";}
  117. if ($country_name=="Greenland") {$country_number="77";}
  118. if ($country_name=="Gambia") {$country_number="71";}
  119. if ($country_name=="Guinea") {$country_number="82";}
  120. if ($country_name=="Guadeloupe") {$country_number="79";}
  121. if ($country_name=="Equatorial Guinea") {$country_number="60";}
  122. if ($country_name=="Greece") {$country_number="76";}
  123. if ($country_name=="South Georgia And The South Sandwich Islands") {$country_number="74";}
  124. if ($country_name=="Guatemala") {$country_number="81";}
  125. if ($country_name=="Guam") {$country_number="80";}
  126. if ($country_name=="Guinea-Bissau") {$country_number="83";}
  127. if ($country_name=="Guyana") {$country_number="84";}
  128. if ($country_name=="Hong Kong") {$country_number="87";}
  129. if ($country_name=="Honduras") {$country_number="86";}
  130. if ($country_name=="Croatia") {$country_number="49";}
  131. if ($country_name=="Haiti") {$country_number="85";}
  132. if ($country_name=="Hungary") {$country_number="88";}
  133. if ($country_name=="Indonesia") {$country_number="91";}
  134. if ($country_name=="Ireland") {$country_number="94";}
  135. if ($country_name=="Israel") {$country_number="95";}
  136. if ($country_name=="India") {$country_number="90";}
  137. if ($country_name=="British Indian Ocean Territory") {$country_number="224";}
  138. if ($country_name=="Iraq") {$country_number="93";}
  139. if ($country_name=="Islamic Republic Of Iran") {$country_number="92";}
  140. if ($country_name=="Iceland") {$country_number="89";}
  141. if ($country_name=="Italy") {$country_number="96";}
  142. if ($country_name=="Jamaica") {$country_number="97";}
  143. if ($country_name=="Jordan") {$country_number="99";}
  144. if ($country_name=="Japan") {$country_number="98";}
  145. if ($country_name=="Kenya") {$country_number="101";}
  146. if ($country_name=="Kyrgyzstan") {$country_number="106";}
  147. if ($country_name=="Cambodia") {$country_number="33";}
  148. if ($country_name=="Kiribati") {$country_number="102";}
  149. if ($country_name=="Comoros") {$country_number="43";}
  150. if ($country_name=="Saint Kitts And Nevis") {$country_number="103";}
  151. if ($country_name=="Republic Of Korea") {$country_number="105";}
  152. if ($country_name=="Kuwait") {$country_number="107";}
  153. if ($country_name=="Cayman Islands") {$country_number="37";}
  154. if ($country_name=="Kazakhstan") {$country_number="100";}
  155. if ($country_name=="Lao People's Democratic Republic") {$country_number="108";}
  156. if ($country_name=="Lebanon") {$country_number="110";}
  157. if ($country_name=="Saint Lucia") {$country_number="168";}
  158. if ($country_name=="Liechtenstein") {$country_number="114";}
  159. if ($country_name=="Sri Lanka") {$country_number="185";}
  160. if ($country_name=="Liberia") {$country_number="112";}
  161. if ($country_name=="Lesotho") {$country_number="111";}
  162. if ($country_name=="Lithuania") {$country_number="115";}
  163. if ($country_name=="Luxembourg") {$country_number="116";}
  164. if ($country_name=="Latvia") {$country_number="109";}
  165. if ($country_name=="Libyan Arab Jamahiriya") {$country_number="113";}
  166. if ($country_name=="Morocco") {$country_number="136";}
  167. if ($country_name=="Monaco") {$country_number="232";}
  168. if ($country_name=="Republic Of Moldova") {$country_number="133";}
  169. if ($country_name=="Madagascar") {$country_number="119";}
  170. if ($country_name=="Marshall Islands") {$country_number="123";}
  171. if ($country_name=="The Former Yugoslav Republic Of Macedonia") {$country_number="118";}
  172. if ($country_name=="Mali") {$country_number="122";}
  173. if ($country_name=="Myanmar") {$country_number="138";}
  174. if ($country_name=="Mongolia") {$country_number="134";}
  175. if ($country_name=="Macao") {$country_number="117";}
  176. if ($country_name=="Northern Mariana Islands") {$country_number="125";}
  177. if ($country_name=="Martinique") {$country_number="127";}
  178. if ($country_name=="Mauritania") {$country_number="128";}
  179. if ($country_name=="Malta") {$country_number="124";}
  180. if ($country_name=="Mauritius") {$country_number="129";}
  181. if ($country_name=="Maldives") {$country_number="121";}
  182. if ($country_name=="Malawi") {$country_number="126";}
  183. if ($country_name=="Mexico") {$country_number="131";}
  184. if ($country_name=="Malaysia") {$country_number="120";}
  185. if ($country_name=="Mozambique") {$country_number="137";}
  186. if ($country_name=="Namibia") {$country_number="139";}
  187. if ($country_name=="New Caledonia") {$country_number="144";}
  188. if ($country_name=="Niger") {$country_number="147";}
  189. if ($country_name=="Norfolk Island") {$country_number="233";}
  190. if ($country_name=="Nigeria") {$country_number="148";}
  191. if ($country_name=="Nicaragua") {$country_number="146";}
  192. if ($country_name=="Netherlands") {$country_number="142";}
  193. if ($country_name=="Norway") {$country_number="150";}
  194. if ($country_name=="Nepal") {$country_number="141";}
  195. if ($country_name=="Nauru") {$country_number="140";}
  196. if ($country_name=="Niue") {$country_number="149";}
  197. if ($country_name=="New Zealand") {$country_number="145";}
  198. if ($country_name=="Oman") {$country_number="151";}
  199. if ($country_name=="Panama") {$country_number="154";}
  200. if ($country_name=="Peru") {$country_number="157";}
  201. if ($country_name=="French Polynesia") {$country_number="69";}
  202. if ($country_name=="Papua New Guinea") {$country_number="155";}
  203. if ($country_name=="Philippines") {$country_number="158";}
  204. if ($country_name=="Pakistan") {$country_number="152";}
  205. if ($country_name=="Poland") {$country_number="160";}
  206. if ($country_name=="Puerto Rico") {$country_number="162";}
  207. if ($country_name=="Palestinian Territory") {$country_number="244";}
  208. if ($country_name=="Portugal") {$country_number="161";}
  209. if ($country_name=="Palau") {$country_number="153";}
  210. if ($country_name=="Paraguay") {$country_number="156";}
  211. if ($country_name=="Qatar") {$country_number="163";}
  212. if ($country_name=="Reunion") {$country_number="164";}
  213. if ($country_name=="Romania") {$country_number="165";}
  214. if ($country_name=="Russian Federation") {$country_number="166";}
  215. if ($country_name=="Rwanda") {$country_number="167";}
  216. if ($country_name=="Saudi Arabia") {$country_number="174";}
  217. if ($country_name=="Solomon Islands") {$country_number="181";}
  218. if ($country_name=="Seychelles") {$country_number="176";}
  219. if ($country_name=="Sudan") {$country_number="186";}
  220. if ($country_name=="Sweden") {$country_number="189";}
  221. if ($country_name=="Singapore") {$country_number="178";}
  222. if ($country_name=="Slovenia") {$country_number="180";}
  223. if ($country_name=="Slovakia (Slovak Republic)") {$country_number="179";}
  224. if ($country_name=="Sierra Leone") {$country_number="177";}
  225. if ($country_name=="San Marino") {$country_number="172";}
  226. if ($country_name=="Senegal") {$country_number="175";}
  227. if ($country_name=="Somalia") {$country_number="182";}
  228. if ($country_name=="Suriname") {$country_number="187";}
  229. if ($country_name=="Sao Tome And Principe") {$country_number="173";}
  230. if ($country_name=="El Salvador") {$country_number="59";}
  231. if ($country_name=="Syrian Arab Republic") {$country_number="191";}
  232. if ($country_name=="Swaziland") {$country_number="188";}
  233. if ($country_name=="Chad") {$country_number="225";}
  234. if ($country_name=="French Southern Territories") {$country_number="229";}
  235. if ($country_name=="Togo") {$country_number="196";}
  236. if ($country_name=="Thailand") {$country_number="195";}
  237. if ($country_name=="Tajikistan") {$country_number="193";}
  238. if ($country_name=="Tokelau") {$country_number="237";}
  239. if ($country_name=="Timor-Leste") {$country_number="227";}
  240. if ($country_name=="Turkmenistan") {$country_number="201";}
  241. if ($country_name=="Tunisia") {$country_number="199";}
  242. if ($country_name=="Tonga") {$country_number="197";}
  243. if ($country_name=="Turkey") {$country_number="200";}
  244. if ($country_name=="Trinidad And Tobago") {$country_number="198";}
  245. if ($country_name=="Tuvalu") {$country_number="202";}
  246. if ($country_name=="Taiwan Province Of China") {$country_number="192";}
  247. if ($country_name=="United Republic Of Tanzania") {$country_number="194";}
  248. if ($country_name=="Ukraine") {$country_number="204";}
  249. if ($country_name=="Uganda") {$country_number="203";}
  250. if ($country_name=="United States") {$country_number="207";}
  251. if ($country_name=="Uruguay") {$country_number="208";}
  252. if ($country_name=="Uzbekistan") {$country_number="209";}
  253. if ($country_name=="Saint Vincent And The Grenadines") {$country_number="169";}
  254. if ($country_name=="Venezuela") {$country_number="212";}
  255. if ($two_letter_country_code=="VG") {$country_number="241";}
  256. if ($country_name=="Virgin Islands") {$country_number="213";}
  257. if ($country_name=="Viet Nam") {$country_number="214";}
  258. if ($country_name=="Vanuatu") {$country_number="210";}
  259. if ($country_name=="Samoa") {$country_number="170";}
  260. if ($country_name=="Yemen") {$country_number="216";}
  261. if ($country_name=="Mayotte") {$country_number="130";}
  262. if ($country_name=="Serbia And Montenegro (Formally Yugoslavia)") {$country_number="217";}
  263. if ($country_name=="South Africa") {$country_number="183";}
  264. if ($country_name=="Zambia") {$country_number="218";}
  265. if ($country_name=="Zimbabwe") {$country_number="219";}
  266.  
  267.  
  268.  
  269.  
  270.  
  271. if (isset($_POST['register'])){
  272.  
  273. /* Validating Input From Registration Page Start */
  274. if(!$loginid||!$gameid||!$password||!$repeat_password||!$email||!$birth_month||!$birth_day||!$birth_year) {
  275. die("<script>alert('Registration Error: Fill in all fields'); history.back();</script>");
  276. }
  277.  
  278. if($country_number > 242 && $country_number < 0) {
  279. die("<script>alert('Registration Error: Invalid country'); history.back();</script>");
  280. }
  281.  
  282. if($birth_month > 13 && $birth_month < 0) {
  283. die("<script>alert('Registration Error: Invalid birth month'); history.back();</script>");
  284. }
  285.  
  286. if($birth_day > 32 && $birth_day < 0) {
  287. die("<script>alert('Registration Error: Invalid birth day'); history.back();</script>");
  288. }
  289.  
  290. if($birth_year > 2008 && $birth_year < 1899) {
  291. die("<script>alert('Registration Error: Invalid birth year'); history.back();</script>");
  292. }
  293.  
  294. if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)) {
  295. die("<script>alert('Registration Error: Invalid e-mail'); history.back();</script>");
  296. }
  297.  
  298. $sqllogin = mysql_query("SELECT Id FROM user WHERE Id='$loginid'");
  299. $sqllyid = mysql_num_rows($sqllogin);
  300. if($sqllyid != 0) {
  301. die("<script>alert('Registration Error: Login ID is already in use'); history.back();</script>");
  302. }
  303.  
  304. $sqlid = mysql_query("SELECT NickName FROM user WHERE NickName='$gameid'");
  305. $sqllyid = mysql_num_rows($sqlid);
  306. if($sqllyid != 0) {
  307. die("<script>alert('Registration Error: Game ID already in use'); history.back();</script>");
  308. }
  309.  
  310. if($loginid == $gameid) {
  311. die("<script>alert('Registration Error: Game ID and Login ID should not match'); history.back();</script>");
  312. }
  313.  
  314. if($password != $repeat_password) {
  315. die("<script>alert('Registration Error: Your passwords do not match'); history.back();</script>");
  316. }
  317.  
  318. if(!preg_match("/^[a-z0-9]([a-z0-9]|[a-z0-9])+$/i", $gameid)) {
  319. die("<script>alert('Registration Error: Game ID must be alpha-numeric'); history.back();</script>");
  320. }
  321.  
  322. if(!preg_match("/^[a-z0-9]([a-z0-9]|[a-z0-9])+$/i", $loginid)) {
  323. die("<script>alert('Registration Error: Login ID must be alpha-numeric'); history.back();</script>");
  324. }
  325.  
  326. if($firstname) {
  327. if(!preg_match("/^ [a-z0-9]([a-z0-9]|[a-z0-9])+$/i", $firstname)) {
  328. die("<script>alert('Registration Error: Firstname must be alpha-numeric'); history.back();</script>");
  329. }
  330. }
  331.  
  332. if($lastname) {
  333. if(!preg_match("/^ [a-z0-9]([a-z0-9]|[a-z0-9])+$/i", $lastname)) {
  334. die("<script>alert('Registration Error: Lastname must be alpha-numeric'); history.back();</script>");
  335. }
  336. }
  337.  
  338. if($gender > 1 || $gender < 0) {
  339. die("<script>alert('Registration Error: Invalid gender'); history.back();</script>");
  340. }
  341.  
  342. $sqle = mysql_query("SELECT E_Mail FROM user WHERE E_Mail='$email'");
  343. $sqllye = mysql_num_rows($sqle);
  344. if($sqllye != 0) {
  345. die("<script>alert('Registration Error: That E-mail is already in use'); history.back();</script>");
  346. }
  347.  
  348. if((strlen($password)>16) || (strlen($password)<4)){
  349. die("<script>alert('Registration Error: Password must be between 4~16 characters'); history.back();</script>");
  350. }
  351.  
  352. if((strlen($gameid)>12) || (strlen($gameid)<3)){
  353. die("<script>alert('Registration Error: Game ID must be between 3~12 characters'); history.back();</script>");
  354. }
  355.  
  356. if((strlen($loginid)>16) || (strlen($loginid)<4)){
  357. die("<script>alert('Registration Error: Login ID must be between 4~16 characters'); history.back();</script>");
  358. }
  359.  
  360. if($firstname) {
  361. if((strlen($firstname)>25) || (strlen($firstname)<3)){
  362. die("<script>alert('Registration Error: Firstname must be between 3~25 characters'); history.back();</script>");
  363. }
  364. }
  365.  
  366. if($lastname) {
  367. if((strlen($lastname)>25) || (strlen($lastname)<3)){
  368. die("<script>alert('Registration Error: Lastname must be between 3~25 characters'); history.back();</script>");
  369. }
  370. /* Validating Input From Registration Page End */
  371. }
  372.  
  373. mysql_query("INSERT INTO user (Id, user, Gender, NickName, Password, Status, E_Mail, Code, Country, IP, Birthdate, Countryname, FirstName, LastName, imagelocation) VALUES('$loginid','$loginid','$gender','$gameid','$password','1','$email', '$codeins', '$country_number','$ip','$birthday','$country_name','$firstname','$lastname','')") or die(mysql_error());
  374. mysql_query("INSERT INTO game (Id, NickName, Nick_Date, Money, TotalScore, SeasonScore, TotalGrade, SeasonGrade, Country) VALUES('$loginid','$gameid','$nickdate','$gold','$gp','$gp','$grade','$grade','$country_number')") or die(mysql_error());
  375. mysql_query("INSERT INTO gunwcuser (Id, user, Gender, NickName, Password, Status, Authority, E_Mail, Country) VALUES('$loginid','$loginid','$gender','$gameid','$password','1','1','$email','$country_number')") or die(mysql_error());
  376. mysql_query("INSERT INTO cash (ID, Cash) VALUES('$loginid','$cash')") or die(mysql_error());
  377.  
  378. echo("<script>alert('Thank you for registering ".$gameid.". Please login!');</script>");
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!