API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 24th, 2016
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.75 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. $user_pseudo = $_GET['pseudo'];
  4.  
  5. $db_mineweb_host = 'COUCOU';
  6. $db_mineweb_user = 'COUCOU';
  7. $db_mineweb_password = 'COUCOU';
  8. $db_mineweb_name = 'COUCOU';
  9. if (isset($_GET['pseudo']) && $_GET['pseudo'] = !"") {
  10. try {
  11. $db_mineweb = new PDO("mysql:host=$db_mineweb_host;dbname=$db_mineweb_name", $db_mineweb_user, $db_mineweb_password);
  12. } catch (Exception $e) {
  13. die('Impossible de se connecter &agrave la base de donn&eacutee de MineWeb. Erreur : ' . $e->getMessage());
  14. }
  15.  
  16. $user = $db_mineweb->query("SELECT * FROM users where pseudo='" . $user_pseudo . "'");
  17. $user = $user->fetch();
  18. $registered = strtotime($user['created']);
  19.  
  20. $buys = $db_mineweb->query("SELECT * FROM shop__items_buy_histories where user_id='" . $user['id'] . "'");
  21. $buys = $buys->fetchAll();
  22. $buys_str = '';
  23.  
  24. $buys_v4 = $db_mineweb->query("SELECT * FROM histories_v4 where author='" . $user_pseudo . "'");
  25. $buys_v4 = $buys_v4->fetchAll();
  26.  
  27. $vote = $db_mineweb->query("SELECT * FROM vote__votes where user_id='" . $user['id'] . "'");
  28. $vote = $vote->fetch();
  29.  
  30.  
  31. $nb_reward_waiting = $user['rewards_waited'];
  32. $nb_total_vote = $user['vote'];
  33. $votestamp = strtotime($vote['created']);
  34.  
  35. $today = new DateTime();
  36. $today->format('Y-m-d H:i:s');
  37.  
  38. $json = file_get_contents("../../tmp/cache/plugins/ranking_faction.cache");
  39. $parsed_json = json_decode($json);
  40. $factions_pseudo = "";
  41. $nb_heure_grade = "";
  42. $nb_jour_grade = "";
  43. $display_grade_restant = "";
  44.  
  45. foreach ($parsed_json->{'data'} as $key => $dataa) {
  46. switch ($dataa->position) {
  47. case 1:
  48. $faction_first = $dataa->name;
  49. break;
  50. case 2:
  51. $faction_second = $dataa->name;
  52. break;
  53. case 3;
  54. $faction_third = $dataa->name;
  55. break;
  56. }
  57.  
  58. foreach ($dataa->players_pseudo as $index => $pseudo) {
  59. if ($user_pseudo == $pseudo) {
  60. $factions_pseudo = $dataa->name;
  61. }
  62. }
  63. }
  64.  
  65. if ($factions_pseudo == "") {
  66. $factions_pseudo = "Aucune";
  67. }
  68. $nb_achat_boutique = 0;
  69.  
  70. foreach ($buys as $buy) {
  71. $nb_achat_boutique++;
  72. if ($buys_str == '') {
  73. switch ($buy['item_id']) {
  74. case 6:
  75. $buys_str = "Alchimiste";
  76. break;
  77. case 7:
  78. $buys_str = "Destruction";
  79. break;
  80. case 8:
  81. $buys_str = "Construction";
  82. break;
  83. case 9:
  84. $buys_str = "Exploration";
  85. break;
  86. case 10:
  87. $buys_str = "Xp";
  88. break;
  89. case 12:
  90. $buys_str = "Ingredients";
  91. break;
  92. case 1:
  93. if (strtotime($buy['created']) > strtotime('-30 days')) {
  94. $add = strtotime($buy['created']) + 2592000;
  95. $final = $add - strtotime("now");
  96. $nb_heure_grade = round($final/3600);
  97. $nb_jour_grade = round($final/86400);
  98. if($nb_jour_grade < 2){
  99. $display_grade_restant = $nb_heure_grade."_heures_restantes";
  100. }
  101. else{
  102. $display_grade_restant = $nb_jour_grade."_jours_restants";
  103. }
  104. $buy_grade = "Maitre";
  105. }
  106. break;
  107. case 2:
  108. if (strtotime($buy['created']) > strtotime('-30 days')) {
  109. $add = strtotime($buy['created']) + 2592000;
  110. $final = $add - strtotime("now");
  111. $nb_heure_grade = round($final/3600);
  112. $nb_jour_grade = round($final/86400);
  113. if($nb_jour_grade < 2){
  114. $display_grade_restant = $nb_heure_grade."_heures_restantes";
  115. }
  116. else{
  117. $display_grade_restant = $nb_jour_grade."_jours_restants";
  118. }
  119. $buy_grade = "Legende";
  120. }
  121. break;
  122. case 3:
  123. if (strtotime($buy['created']) > strtotime('-30 days')) {
  124. $add = strtotime($buy['created']) + 2592000;
  125. $final = $add - strtotime("now");
  126. $nb_heure_grade = round($final/3600);
  127. $nb_jour_grade = round($final/86400);
  128. if($nb_jour_grade < 2){
  129. $display_grade_restant = $nb_heure_grade."_heures_restantes";
  130. }
  131. else{
  132. $display_grade_restant = $nb_jour_grade."_jours_restants";
  133. }
  134. $buy_grade = "Guerrier";
  135. }
  136. break;
  137. }
  138. } else {
  139. switch ($buy['item_id']) {
  140. case 6:
  141. if (strpos($buys_str, 'Alchimiste') !== false) {
  142. } else {
  143. $buys_str = $buys_str . ";Alchimiste";
  144. }
  145. break;
  146. case 7:
  147. if (strpos($buys_str, 'Destruction') !== false) {
  148. } else {
  149. $buys_str = $buys_str . ";Destruction";
  150. }
  151. break;
  152. case 8:
  153. if (strpos($buys_str, 'Construction') !== false) {
  154. } else {
  155. $buys_str = $buys_str . ";Construction";
  156. }
  157. break;
  158. case 9:
  159. if (strpos($buys_str, 'Exploration') !== false) {
  160. } else {
  161. $buys_str = $buys_str . ";Exploration";
  162. }
  163. break;
  164. case 10:
  165. if (strpos($buys_str, 'Xp') !== false) {
  166. } else {
  167. $buys_str = $buys_str . ";Xp";
  168. }
  169. break;
  170. case 12:
  171. if (strpos($buys_str, 'Ingredients') !== false) {
  172. } else {
  173. $buys_str = $buys_str . ";Ingredients";
  174. }
  175. break;
  176. case 1:
  177. if (strtotime($buy['created']) > strtotime('-30 days')) {
  178. $add = strtotime($buy['created']) + 2592000;
  179. $final = $add - strtotime("now");
  180. $nb_heure_grade = round($final/3600);
  181. $nb_jour_grade = round($final/86400);
  182. if($nb_jour_grade < 2){
  183. $display_grade_restant = $nb_heure_grade."_heures_restantes";
  184. }
  185. else{
  186. $display_grade_restant = $nb_jour_grade."_jours_restants";
  187. }
  188. $buy_grade = "Maitre";
  189. }
  190. break;
  191. case 2:
  192. if (strtotime($buy['created']) > strtotime('-30 days')) {
  193. $add = strtotime($buy['created']) + 2592000;
  194. $final = $add - strtotime("now");
  195. $nb_heure_grade = round($final/3600);
  196. $nb_jour_grade = round($final/86400);
  197. if($nb_jour_grade < 2){
  198. $display_grade_restant = $nb_heure_grade."_heures_restantes";
  199. }
  200. else{
  201. $display_grade_restant = $nb_jour_grade."_jours_restants";
  202. }
  203. $buy_grade = "Legende";
  204. }
  205. break;
  206. case 3:
  207. if (strtotime($buy['created']) > strtotime('-30 days')) {
  208. $add = strtotime($buy['created']) + 2592000;
  209. $final = $add - strtotime("now");
  210. $nb_heure_grade = round($final/3600);
  211. $nb_jour_grade = round($final/86400);
  212. if($nb_jour_grade < 2){
  213. $display_grade_restant = $nb_heure_grade."_heures_restantes";
  214. }
  215. else{
  216. $display_grade_restant = $nb_jour_grade."_jours_restants";
  217. }
  218. $buy_grade = "Guerrier";
  219. }
  220. break;
  221. }
  222. }
  223. }
  224.  
  225. foreach ($buys_v4 as $buy_v4) {
  226. $nb_achat_boutique++;
  227. if ($buys_str == '') {
  228. switch ($buy_v4['other']) {
  229. case "Xp":
  230. $buys_str = "Xp";
  231. break;
  232. case "Alchimiste":
  233. $buys_str = "Alchimiste";
  234. break;
  235. case "Exploration":
  236. $buys_str = "Exploration";
  237. break;
  238. case "Destruction":
  239. $buys_str = "Destruction";
  240. break;
  241. case "Construction":
  242. $buys_str = "Construction";
  243. break;
  244. case "Ingredients":
  245. $buys_str = "Ingredients";
  246. break;
  247. case "Farmeur":
  248. $buys_str = "Farmeur";
  249. break;
  250. }
  251. } else {
  252. switch ($buy_v4['other']) {
  253. case "Xp":
  254. if (strpos($buys_str, 'Xp') != false) {
  255. } else {
  256. $buys_str = $buys_str . ";Xp";
  257. }
  258. break;
  259. case "Alchimiste":
  260. if (strpos($buys_str, 'Alchimiste') !== false) {
  261. } else {
  262. $buys_str = $buys_str . ";Alchimiste";
  263. }
  264. break;
  265. case "Exploration":
  266. if (strpos($buys_str, 'Exploration') !== false) {
  267. } else {
  268. $buys_str = $buys_str . ";Exploration";
  269. }
  270. break;
  271. case "Destruction":
  272. if (strpos($buys_str, 'Destruction') !== false) {
  273. } else {
  274. $buys_str = $buys_str . ";Destruction";
  275. }
  276. break;
  277. case "Construction":
  278. if (strpos($buys_str, 'Construction') !== false) {
  279. } else {
  280. $buys_str = $buys_str . ";Construction";
  281. }
  282. break;
  283. case "Ingredients":
  284. if (strpos($buys_str, 'Ingredients') !== false) {
  285. } else {
  286. $buys_str = $buys_str . ";Ingredients";
  287. }
  288. break;
  289. case "Farmeur":
  290. $buys_str = $buys_str . ";Farmeur";
  291. break;
  292. }
  293. }
  294. }
  295.  
  296. if ($buys_str == "") {
  297. $buys_str = "Aucun";
  298. }
  299.  
  300. if ($buy_grade == "") {
  301. $buy_grade = "Apprenti";
  302. }
  303.  
  304. if ($user_pseudo == "Max961" || $user_pseudo == "Zaw96") {
  305. $buy_grade = "Admin";
  306. } elseif ($user_pseudo == "Procyx" || $user_pseudo == "tibst") {
  307. $buy_grade = "Dev";
  308. } elseif ($user_pseudo == "Meko76") {
  309. $buy_grade = "Chef-Modo";
  310. } elseif ($user_pseudo == "franchiltz" || $user_pseudo == "Lezhy"){
  311. $buy_grade = "Modérateur";
  312. }
  313.  
  314. if ($votestamp == false) {
  315. $votestamp = 0;
  316. }
  317.  
  318. if($nb_heure_grade == ""){
  319. $nb_heure_grade = "Aucun";
  320. }
  321.  
  322. if($nb_jour_grade == ""){
  323. $nb_jour_grade = "Aucun";
  324. }
  325.  
  326. if($display_grade_restant == ""){
  327. $display_grade_restant = "Aucun";
  328. }
  329.  
  330.  
  331.  
  332. $a = array(
  333. "displayUsername" => $user_pseudo,
  334. "userPoints" => $user['money'],
  335. "userRegisterStamp" => $registered,
  336. "userKits" => $buys_str, "userGrades" => $buy_grade,
  337. "displayGradeRestant"=>$display_grade_restant,
  338. "nbHeureGrade"=>$nb_heure_grade,
  339. "nbJourGrade"=>$nb_jour_grade,
  340. "nbBuyShop" => $nb_achat_boutique,
  341. "voteStamp" => $votestamp,
  342. "nbTotalVotes" => $nb_total_vote,
  343. "nbRewardWaiting" => $nb_reward_waiting,
  344. 'user_factions' => $factions_pseudo,
  345. "factionFirst" => $faction_first,
  346. "factionSecond" => $faction_second,
  347. "factionThird" => $faction_third);
  348. echo json_encode($a);
  349.  
  350. $date_modo = date("d/m/y", $registered);
  351.  
  352. $kits_modo = str_replace(";"," - ",$buys_str);
  353.  
  354. echo "<br>Pseudo : ".$user_pseudo;
  355. echo "<br>Adresse email : ".$user['email'];
  356. echo "<br>Golds : ".$user['money'];
  357. echo "<br>Création du compte sur le site : ".$date_modo;
  358. echo "<br>Kits : ".$kits_modo;
  359. echo "<br>Grade : ".$buy_grade;
  360. echo "<br>Temps restant au grade : ".$display_grade_restant;
  361. echo "<br>Nombre d'achats boutique : ".$nb_achat_boutique;
  362. echo "<br>Nombre de votes : ".$nb_total_vote;
  363. echo "<br>Nombre de récompenses en attente : ".$nb_reward_waiting;
  364. echo "<br>Faction du joueur : ".$factions_pseudo;
  365.  
  366. } else {
  367. echo "Invalide";
  368. }
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!