API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2018
155
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.58 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. //header_remove();
  3. header('Pragma:');
  4. function set_content_length($output)
  5. {
  6. header("Content-Length: ".strlen($output));
  7. return $output;
  8. }
  9. ob_start("set_content_length");
  10. //the above part is for fixing a warband reading headers error
  11.  
  12. $database_host = "db_host";
  13. $database_username = "db_username";
  14. $database_password = "db_password";
  15. $database_name = "db_name";
  16.  
  17. //if($_SERVER['REMOTE_ADDR'] == "127.0.0.1") //uncomment this if you want to check the ip too
  18. if(isset($_GET['pass']))
  19. if($_GET['pass'] == "password")
  20. if(isset($_GET["event"]))
  21. {
  22. $event = $_GET["event"];
  23. if($event == 1) // save bunch of players stats
  24. {
  25. if(isset($_GET["nrp"]))
  26. {
  27. $nr_players = $_GET["nrp"];
  28. }else{
  29. die(" |-2|");
  30. }
  31.  
  32. $db_handle = mysqli_connect($database_host, $database_username, $database_password, $database_name) or die(" |-1|");
  33.  
  34. $i = 0;
  35. while($i < $nr_players)
  36. {
  37. if(
  38. isset($_GET['u'.$i]) && // uid
  39. isset($_GET['s'.$i]) && // username
  40. isset($_GET['b'.$i]) && // bow
  41. isset($_GET['a'.$i]) && // arrows
  42. isset($_GET['x'.$i]) && // xbow
  43. isset($_GET['o'.$i]) && // bolts
  44. isset($_GET['n'.$i]) && // one h
  45. isset($_GET['t'.$i]) && // two h
  46. isset($_GET['h'.$i]) && // head
  47. isset($_GET['d'.$i]) && // body
  48. isset($_GET['f'.$i]) && // foot
  49. isset($_GET['g'.$i]) && // gloves
  50. isset($_GET['i'.$i]) && // shield
  51. isset($_GET['v'.$i]) && // level
  52. isset($_GET['p'.$i]) && // xp
  53. isset($_GET['z'.$i]) // gold
  54. )
  55. {
  56. $uid = $_GET['u'.$i];
  57. $username = $_GET['s'.$i];
  58. $bow = $_GET['b'.$i];
  59. $arrows = $_GET['a'.$i];
  60. $xbow = $_GET['x'.$i];
  61. $bolts = $_GET['o'.$i];
  62. $oneh = $_GET['n'.$i];
  63. $twoh = $_GET['t'.$i];
  64. $head = $_GET['h'.$i];
  65. $body = $_GET['d'.$i];
  66. $foot = $_GET['f'.$i];
  67. $gloves = $_GET['g'.$i];
  68. $shield = $_GET['i'.$i];
  69. $level = $_GET['v'.$i];
  70. $xp = $_GET['p'.$i];
  71. $gold = $_GET['z'.$i];
  72.  
  73.  
  74. if($db_handle)
  75. {
  76. $sql_result = mysqli_query($db_handle, "INSERT INTO `players` (`Username`, `UniqueId`, `HeadArmor`, `BodyArmor`, `FootArmor`, `GloveArmor`, `Bow`, `Arrows`, `Xbow`, `Bolts`, `Shield`, `OneH`, `TwoH`, `XP`, `Gold`, `Level`)".
  77. " VALUES('$username', $uid, $head, $body, $foot, $gloves, $bow, $arrows, $xbow, $bolts, $shield, $oneh, $twoh, $xp, $gold, $level) ON DUPLICATE KEY UPDATE ".
  78. "Username=VALUES(Username),".
  79. "HeadArmor=VALUES(HeadArmor),".
  80. "BodyArmor=VALUES(BodyArmor),".
  81. "FootArmor=VALUES(FootArmor),".
  82. "GloveArmor=VALUES(GloveArmor),".
  83. "Bow=VALUES(Bow),".
  84. "Arrows=VALUES(Arrows),".
  85. "Xbow=VALUES(Xbow),".
  86. "Bolts=VALUES(Bolts),".
  87. "Shield=VALUES(Shield),".
  88. "OneH=VALUES(OneH),".
  89. "TwoH=VALUES(TwoH),".
  90. "XP=VALUES(XP),".
  91. "Level=VALUES(Level),".
  92. "Gold=VALUES(Gold)");
  93.  
  94. if($sql_result === FALSE)
  95. die(mysqli_error($db_handle)." |-3|");
  96. }
  97.  
  98. }else{
  99. break;
  100. }
  101.  
  102. $i += 1;
  103. }
  104.  
  105. echo "1234|"; // ack
  106.  
  107. mysqli_close($db_handle);
  108. }else if($event == 2) // on player join; register and returns stats
  109. {
  110. if(isset($_GET["username"]) &&
  111. isset($_GET["uid"]) &&
  112. isset($_GET["lid"]))
  113. {
  114. $uid = $_GET["uid"];
  115. $lid = $_GET["lid"];//for feedback only
  116. $username = $_GET["username"];
  117.  
  118.  
  119. $db_handle = mysqli_connect($database_host, $database_username, $database_password, $database_name) or die(" |-1|");
  120.  
  121. // $s = "SELECT 'HeadArmor', BodyArmor, FootArmor, GloveArmor, Bow, Arrows, Xbow, Bolts, Shield, OneH, TwoH, XP, Gold, Level FROM players WHERE UniqueId = $uid" ;
  122. $s = "SELECT `HeadArmor`, `BodyArmor`, `FootArmor`, `GloveArmor`, `Bow`, `Arrows`, `Xbow`, `Bolts`, `Shield`, `OneH`, `TwoH`, `XP`, `Gold`, `Level` FROM `players` WHERE UniqueId = $uid" ;
  123. //echo $s;
  124. // exit();
  125. $sql_result = mysqli_query($db_handle, $s);
  126. if($sql_result === FALSE)
  127. die(mysqli_error($db_handle)." |-3|");
  128. $result = mysqli_fetch_row($sql_result);
  129.  
  130. if (!$result)
  131. {//the player is not in the database, so we will insert it
  132. $s = " INSERT INTO `players`(`Username`, `UniqueId`, `HeadArmor`, `BodyArmor`, `FootArmor`, `GloveArmor`, `Bow`, `Arrows`, `Xbow`, `Bolts`, `Shield`, `OneH`, `TwoH`, `XP`, `Gold`, `Level`)".
  133. " VALUES ('$username', $uid, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1)";
  134. // echo "\r\n".$s;
  135.  
  136. $sql_result = mysqli_query($db_handle, $s);
  137. if($sql_result === FALSE)
  138. die(mysqli_error($db_handle)." |-3|");
  139.  
  140. $bow = 1;
  141. $arrows = 1;
  142. $xbow =1;
  143. $bolts = 1;
  144. $oneh = 1;
  145. $twoh = 1;
  146. $head = 1;
  147. $body = 1;
  148. $foot = 1;
  149. $gloves = 1;
  150. $shield = 1;
  151. $level = 1;
  152. $xp = 0;
  153. $gold = 0;
  154. echo "2|$uid|$lid|$bow|$arrows|$xbow|$bolts|$oneh|$twoh|$head|$body|$foot|$gloves|$shield|$level|$xp|$gold|";
  155. }else{
  156. $head = $result[0];
  157. $body = $result[1];
  158. $foot = $result[2];
  159. $gloves = $result[3];
  160. $bow = $result[4];
  161. $arrows = $result[5];
  162. $xbow = $result[6];
  163. $bolts = $result[7];
  164. $shield = $result[8];
  165. $oneh = $result[9];
  166. $twoh = $result[10];
  167. $xp = $result[11];
  168. $gold = $result[12];
  169. $level = $result[13];
  170. echo "2|$uid|$lid|$bow|$arrows|$xbow|$bolts|$oneh|$twoh|$head|$body|$foot|$gloves|$shield|$level|$xp|$gold|";
  171. }
  172. mysqli_close($db_handle);
  173.  
  174. }
  175. }else if($event == 3) // save player stats
  176. {
  177. $db_handle = mysqli_connect($database_host, $database_username, $database_password, $database_name) or die(" |-1|");
  178.  
  179. if(
  180. isset($_GET['u']) && // uid
  181. isset($_GET['s']) && // username
  182. isset($_GET['b']) && // bow
  183. isset($_GET['a']) && // arrows
  184. isset($_GET['x']) && // xbow
  185. isset($_GET['o']) && // bolts
  186. isset($_GET['n']) && // one h
  187. isset($_GET['t']) && // two h
  188. isset($_GET['h']) && // head
  189. isset($_GET['d']) && // body
  190. isset($_GET['f']) && // foot
  191. isset($_GET['g']) && // gloves
  192. isset($_GET['i']) && // shield
  193. isset($_GET['v']) && // level
  194. isset($_GET['p']) && // xp
  195. isset($_GET['z']) // gold
  196. )
  197. {
  198. $uid = $_GET['u'];
  199. $username = $_GET['s'];
  200. $bow = $_GET['b'];
  201. $arrows = $_GET['a'];
  202. $xbow = $_GET['x'];
  203. $bolts = $_GET['o'];
  204. $oneh = $_GET['n'];
  205. $twoh = $_GET['t'];
  206. $head = $_GET['h'];
  207. $body = $_GET['d'];
  208. $foot = $_GET['f'];
  209. $gloves = $_GET['g'];
  210. $shield = $_GET['i'];
  211. $level = $_GET['v'];
  212. $xp = $_GET['p'];
  213. $gold = $_GET['z'];
  214.  
  215.  
  216. if($db_handle)
  217. {
  218. $s = "INSERT INTO `players` (`Username`, `UniqueId`, `HeadArmor`, `BodyArmor`, `FootArmor`, `GloveArmor`, `Bow`, `Arrows`, `Xbow`, `Bolts`, `Shield`, `OneH`, `TwoH`, `XP`, `Gold`, `Level`)".
  219. " VALUES('$username', $uid, $head, $body, $foot, $gloves, $bow, $arrows, $xbow, $bolts, $shield, $oneh, $twoh, $xp, $gold, $level) ON DUPLICATE KEY UPDATE ".
  220. "Username=VALUES(Username),".
  221. "HeadArmor=VALUES(HeadArmor),".
  222. "BodyArmor=VALUES(BodyArmor),".
  223. "FootArmor=VALUES(FootArmor),".
  224. "GloveArmor=VALUES(GloveArmor),".
  225. "Bow=VALUES(Bow),".
  226. "Arrows=VALUES(Arrows),".
  227. "Xbow=VALUES(Xbow),".
  228. "Bolts=VALUES(Bolts),".
  229. "Shield=VALUES(Shield),".
  230. "OneH=VALUES(OneH),".
  231. "TwoH=VALUES(TwoH),".
  232. "XP=VALUES(XP),".
  233. "Level=VALUES(Level),".
  234. "Gold=VALUES(Gold)";
  235. //echo $s;
  236. $sql_result = mysqli_query($db_handle, $s);
  237. if($sql_result === FALSE)
  238. die(mysqli_error($db_handle)." |-3|");
  239. echo "1234|" ;// ack
  240. }
  241. }
  242. mysqli_close($db_handle);
  243. }
  244. }
  245. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!