Advertisement
Guest User

Untitled

a guest
Sep 17th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.87 KB | None | 0 0
  1. <?php
  2. $servername = "xxx";
  3. $username = "xxx";
  4. $password = "xxx";
  5. $dbname = "xxx";
  6.  
  7. $conn = new mysqli($servername, $username, $password, $dbname);
  8. if ($conn->connect_error) {
  9. die("Connection failed: " . $conn->connect_error . "\n");
  10. }
  11.  
  12. $command = readline("Item Unique_ID: ");
  13. // $players = $conn->query("SELECT * FROM store_players;");
  14. // $items = $conn->query("SELECT * FROM store_items;");
  15.  
  16. $players = $conn->query("SELECT DISTINCT player_id AS player_id FROM store_items");
  17.  
  18. foreach ($players as $player) {
  19. echo "Handling... " . $player['player_id'] . "<br/ >";
  20. $items = $conn->query("SELECT * FROM store_items WHERE player_id=" . $player['player_id']);
  21. $total = 0;
  22. foreach ($items as $item) {
  23. $total += $item['price_of_purchase'];
  24. }
  25. echo "Got data " . $total . " for user " . $player['player_id'] . "<br />";
  26. $conn->query("UPDATE store_players SET credits = credits + " . $total . " WHERE id=" . $player['player_id'])
  27. $conn->query("DELETE FROM store_items WHERE player_id=" . $player['player_id'])
  28. }
  29.  
  30.  
  31. /*
  32. Array
  33. (
  34. [id] => 962
  35. [player_id] => 7072
  36. [type] => hat
  37. [unique_id] => models/store/hats/afro.mdl
  38. [date_of_purchase] => 1423782508
  39. [date_of_expiration] => 0
  40. [price_of_purchase] => 150
  41. )
  42.  
  43. Array
  44. (
  45. [id] => 9161
  46. [authid] => 1:47577598
  47. [name] => Kikud
  48. [credits] => 0
  49. [date_of_join] => 1425727250
  50. [date_of_last_join] => 1425727250
  51. )
  52. */
  53.  
  54.  
  55. function findItems(){
  56. global $mask, $items;
  57. $mask = "|%5.5s |%-10.10s |%-25.25s |%-7.7s |%-12.12s |%-10.10s |\r\n";
  58. printf($mask, "ID", "SteamID", "Name", "Credits", "Date Of Join", "Last Join");
  59. foreach($items as $value) {
  60. $playerValue = findPlayer($value['player_id']);
  61. echo "GUNSTAR " . $playerValue['id'];
  62. refundPlayer($playerValue['id'], (string)($playerValue['credits'] + $value['price_of_purchase']), $value['id']);
  63. }
  64. }
  65.  
  66. function findPlayer($player_id) {
  67. global $players, $mask;
  68. foreach($players as $value) {
  69. if ($value['id'] == $player_id) {
  70. printf($mask, $value['id'], $value['authid'], $value['name'], $value['credits'], $value['date_of_join'], $value['date_of_last_join']);
  71. return $value;
  72. }
  73. }
  74. }
  75.  
  76. function refundPlayer($player_id, $amount, $item_id) {
  77. global $conn;
  78. $sql = "UPDATE store_players SET credits=" . $amount . " WHERE id=" . $player_id;
  79. echo $sql;
  80. if (mysqli_query($conn, $sql)) {
  81. echo "Record updated successfully, removing entry...";
  82. $sql = "DELETE FROM store_players WHERE id=" . $item_id;
  83. if (mysqli_query($conn, $sql)) {
  84. echo "Record removed successfully";
  85. } else {
  86. echo "Error removing record: " . $conn->error;
  87. }
  88. } else {
  89. echo "Error updating record: " . $conn->error;
  90. }
  91. }
  92.  
  93. // findItems();
  94.  
  95. // refundPlayer("3260", "123");
  96.  
  97. $conn->close();
  98. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement