API tools faq
paste
Guest User

Untitled

a guest
Nov 9th, 2016
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.16 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /**
  3. *
  4. * @ This file is created by deZender.Net
  5. * @ deZender (PHP5 Decoder for ionCube Loader)
  6. *
  7. * @ Version : 2.0.0.4
  8. * @ Author : DeZender
  9. * @ Release on : 21.10.2015
  10. * @ Official site : http://DeZender.Net
  11. *
  12. */
  13.  
  14. function getuseridbykey($key) {
  15.  
  16. global $wpdb;
  17. $id = $wpdb->get_var("SELECT `id` FROM `" . $wpdb->prefix . "mlm_users` WHERE `user_key` = '" . $key . "'");
  18. return $id;
  19. }
  20.  
  21. function getusernamebykey($key) {
  22.  
  23. global $wpdb;
  24. $id = $wpdb->get_var("SELECT `username` FROM `" . $wpdb->prefix . "mlm_users` WHERE `user_key` = '" . $key . "'");
  25. return $id;
  26. }
  27.  
  28. function getuserkeybyid($user_id) {
  29.  
  30. global $wpdb;
  31. $key = $wpdb->get_var("SELECT `user_key` FROM `" . $wpdb->prefix . "mlm_users` WHERE `user_id` = '" . $user_id . "'");
  32. return $key;
  33. }
  34.  
  35. function getparentkeybyid($user_id) {
  36.  
  37. global $wpdb;
  38. $key = $wpdb->get_var("SELECT `parent_key` FROM `" . $wpdb->prefix . "mlm_users` WHERE `user_id` = '" . $user_id . "'");
  39. return $key;
  40. }
  41.  
  42. function getsponsorkeybyid($user_id) {
  43.  
  44. global $wpdb;
  45. $key = $wpdb->get_var("SELECT `sponsor_key` FROM `" . $wpdb->prefix . "mlm_users` WHERE `user_id` = '" . $user_id . "'");
  46. return $key;
  47. }
  48.  
  49. function generateKey() {
  50.  
  51. $characters = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
  52. $keys = array();
  53. $length = 9;
  54. while (count($keys) < $length)
  55. {
  56. $x = mt_rand(0, count($characters) - 1);
  57. if (!!in_array($x, $keys))
  58. {
  59. continue;
  60. }
  61. $keys[] = $x;
  62. continue;
  63. }
  64. $random_chars = "";
  65. foreach ($keys as $key)
  66. {
  67. $random_chars .= $characters[$key];
  68. continue;
  69. }
  70. return $random_chars;
  71. }
  72.  
  73. function get_current_user_key() {
  74.  
  75. global $current_user;
  76. global $wpdb;
  77. get_currentuserinfo();
  78. $username = $current_user->user_login;
  79. $user_key = $wpdb->get_var("SELECT `user_key` FROM `" . $wpdb->prefix . "mlm_users` WHERE `username` = '" . $username . "'");
  80. return $user_key;
  81. }
  82.  
  83. function get_user_key_admin($username) {
  84.  
  85. global $wpdb;
  86. $user_key = $wpdb->get_var("SELECT `user_key` FROM `" . $wpdb->prefix . "mlm_users` WHERE `username` = '" . $username . "'");
  87. return $user_key;
  88. }
  89.  
  90. function getUserIdByUsername($username) {
  91.  
  92. global $wpdb;
  93. $id = $wpdb->get_var("SELECT `ID` FROM `" . $wpdb->prefix . "users` WHERE `user_login` = '" . $username . "'");
  94. return $id;
  95. }
  96.  
  97. function checkKey($key) {
  98.  
  99. global $wpdb;
  100. $user_key = $wpdb->get_var("SELECT `user_key` FROM `" . $wpdb->prefix . "mlm_users` WHERE `user_key` = '" . $key . "' AND banned = '0'");
  101. if (!$user_key)
  102. {
  103. return false;
  104. }
  105. return true;
  106. }
  107.  
  108. function checkallowed($key, $leg = null) {
  109.  
  110. global $wpdb;
  111. $username = $wpdb->get_var("SELECT `username` FROM `" . $wpdb->prefix . "mlm_users` WHERE leg = '" . $leg . "' AND `parent_key` = '" . $key . "'");
  112. return $wpdb->num_rows;
  113. }
  114.  
  115. function totalLeftLegUsers($pkey) {
  116.  
  117. global $wpdb;
  118. $num = $wpdb->get_var("SELECT COUNT(*) AS num FROM `" . $wpdb->prefix . "mlm_leftleg` WHERE `pkey` = '" . $pkey . "'");
  119. return $num;
  120. }
  121.  
  122. function totalRightLegUsers($pkey) {
  123.  
  124. global $wpdb;
  125. $num = $wpdb->get_var("SELECT COUNT(*) AS num FROM `" . $wpdb->prefix . "mlm_rightleg` WHERE `pkey` = '" . $pkey . "'");
  126. return $num;
  127. }
  128.  
  129. function totalLeftLegUsersByPayoutId($pkey, $payout_id) {
  130.  
  131. global $wpdb;
  132. $num = $wpdb->get_var("SELECT COUNT(*) AS num FROM " . $wpdb->prefix . "mlm_leftleg WHERE pkey = '" . $pkey . "' and payout_id in('" . $payout_id . "')");
  133. return $num;
  134. }
  135.  
  136. function totalRightLegUsersByPayoutId($pkey, $payout_id) {
  137.  
  138. global $wpdb;
  139. $num = $wpdb->get_var("SELECT COUNT(*) AS num FROM " . $wpdb->prefix . "mlm_rightleg WHERE pkey = '" . $pkey . "' and payout_id in('" . $payout_id . "')");
  140. return $num;
  141. }
  142.  
  143. function activeUsersOnLeftLeg($pkey) {
  144.  
  145. global $wpdb;
  146. $num = $wpdb->get_var("SELECT COUNT(*) AS num FROM " . $wpdb->prefix . "mlm_users WHERE payment_status = '1' AND user_key IN ( SELECT ukey FROM " . $wpdb->prefix . "mlm_leftleg WHERE pkey = '" . $pkey . "' ) ");
  147. return $num;
  148. }
  149.  
  150. function activeUsersOnRightLeg($pkey) {
  151.  
  152. global $wpdb;
  153. $num = $wpdb->get_var(" SELECT COUNT(*) AS num FROM " . $wpdb->prefix . "mlm_users WHERE payment_status = '1' AND user_key IN( SELECT ukey FROM " . $wpdb->prefix . "mlm_rightleg WHERE pkey = '" . $pkey . "' ) ");
  154. return $num;
  155. }
  156.  
  157. function totalMyPersonalSales($sponsor) {
  158.  
  159. global $wpdb;
  160. $num = $wpdb->get_var(" SELECT COUNT(*) AS num FROM " . $wpdb->prefix . "mlm_users WHERE sponsor_key = '" . $sponsor . "' ");
  161. return $num;
  162. }
  163.  
  164. function activeUsersOnPersonalSales($sponsor) {
  165.  
  166. global $wpdb;
  167. $num = $wpdb->get_var(" SELECT COUNT(*) AS num FROM " . $wpdb->prefix . "mlm_users WHERE sponsor_key = '" . $sponsor . "' AND payment_status = '1' ");
  168. return $num;
  169. }
  170.  
  171. function activeNotActive($status) {
  172.  
  173. if ($status == "1")
  174. {
  175. return "Active";
  176. }
  177. return "Not Active";
  178. }
  179.  
  180. function myFiveLeftLegUsers($pkey) {
  181.  
  182. global $wpdb;
  183. $sql = "SELECT username, payment_status FROM " . $wpdb->prefix . "mlm_users
  184. WHERE user_key IN
  185. (
  186. SELECT ukey
  187. FROM " . $wpdb->prefix . "mlm_leftleg
  188. WHERE pkey = '" . $pkey . "'
  189. ORDER BY id DESC
  190. )
  191. ORDER BY id DESC
  192. LIMIT 0,5";
  193. $results = $wpdb->get_results($sql);
  194. $i = 0;
  195. if (0 < $wpdb->num_rows)
  196. {
  197. foreach ($results as $data)
  198. {
  199. $users[$i]["username"] = $data->username;
  200. $users[$i]["payment_status"] = activenotactive($data->payment_status);
  201. ++$i;
  202. continue;
  203. }
  204. }
  205. else
  206. {
  207. $users[$i]["username"] = "No Member Found";
  208. $users[$i]["payment_status"] = "";
  209. }
  210. return $users;
  211. }
  212.  
  213. function myFiveRightLegUsers($pkey) {
  214.  
  215. global $wpdb;
  216. $sql = "SELECT username, payment_status FROM " . $wpdb->prefix . "mlm_users
  217. WHERE user_key IN
  218. (
  219. SELECT ukey
  220. FROM " . $wpdb->prefix . "mlm_rightleg
  221. WHERE pkey = '" . $pkey . "'
  222. ORDER BY id DESC
  223. )
  224. ORDER BY id DESC
  225. LIMIT 0,5";
  226. $results = $wpdb->get_results($sql);
  227. $i = 0;
  228. if (0 < $wpdb->num_rows)
  229. {
  230. foreach ($results as $data)
  231. {
  232. $users[$i]["username"] = $data->username;
  233. $users[$i]["payment_status"] = activenotactive($data->payment_status);
  234. ++$i;
  235. continue;
  236. }
  237. }
  238. else
  239. {
  240. $users[$i]["username"] = "No Member Found";
  241. $users[$i]["payment_status"] = "";
  242. }
  243. return $users;
  244. }
  245.  
  246. function myFivePersonalUsers($pkey) {
  247.  
  248. global $wpdb;
  249. $sql = "SELECT username, payment_status FROM " . $wpdb->prefix . "mlm_users
  250. WHERE sponsor_key = '" . $pkey . "' ORDER BY id DESC LIMIT 0,5";
  251. $results = $wpdb->get_results($sql);
  252. $i = 0;
  253. if (0 < $wpdb->num_rows)
  254. {
  255. foreach ($results as $data)
  256. {
  257. $users[$i]["username"] = $data->username;
  258. $users[$i]["payment_status"] = activenotactive($data->payment_status);
  259. ++$i;
  260. continue;
  261. }
  262. }
  263. else
  264. {
  265. $users[$i]["username"] = "No Member Found";
  266. $users[$i]["payment_status"] = "";
  267. }
  268. return $users;
  269. }
  270.  
  271. function getSponsorName($key) {
  272.  
  273. global $wpdb;
  274. $sql = "SELECT username
  275. FROM " . $wpdb->prefix . "mlm_users
  276. WHERE user_key = '" . $key . "'";
  277. $username = $wpdb->get_var($sql);
  278. return $username;
  279. }
  280.  
  281. function myTotalLeftLegUsers($pkey) {
  282.  
  283. global $wpdb;
  284. $sql = "SELECT username, payment_status, user_key, sponsor_key
  285. FROM " . $wpdb->prefix . "mlm_users
  286. WHERE user_key IN
  287. (
  288. SELECT ukey
  289. FROM " . $wpdb->prefix . "mlm_leftleg
  290. WHERE pkey = '" . $pkey . "'
  291. ORDER BY id DESC
  292. )
  293. ORDER BY id DESC";
  294. $results = $wpdb->get_results($sql);
  295. $i = 0;
  296. if (0 < $wpdb->num_rows)
  297. {
  298. foreach ($results as $data)
  299. {
  300. $users[$i]["username"] = $data->username;
  301. $users[$i]["user_key"] = $data->user_key;
  302. $users[$i]["sponsor_key"] = getsponsorname($data->sponsor_key);
  303. $users[$i]["payment_status"] = activenotactive($data->payment_status);
  304. ++$i;
  305. continue;
  306. }
  307. }
  308. else
  309. {
  310. $users[$i]["username"] = "No Member Found";
  311. $users[$i]["user_key"] = "";
  312. $users[$i]["sponsor_key"] = "";
  313. $users[$i]["payment_status"] = "";
  314. }
  315. return $users;
  316. }
  317.  
  318. function myTotalRightLegUsers($pkey) {
  319.  
  320. global $wpdb;
  321. $sql = "SELECT username, payment_status, user_key, sponsor_key
  322. FROM " . $wpdb->prefix . "mlm_users
  323. WHERE user_key IN
  324. (
  325. SELECT ukey
  326. FROM " . $wpdb->prefix . "mlm_rightleg
  327. WHERE pkey = '" . $pkey . "'
  328. ORDER BY id DESC
  329. )
  330. ORDER BY id DESC";
  331. $results = $wpdb->get_results($sql);
  332. $i = 0;
  333. if (0 < $wpdb->num_rows)
  334. {
  335. foreach ($results as $data)
  336. {
  337. $users[$i]["username"] = $data->username;
  338. $users[$i]["user_key"] = $data->user_key;
  339. $users[$i]["sponsor_key"] = getsponsorname($data->sponsor_key);
  340. $users[$i]["payment_status"] = activenotactive($data->payment_status);
  341. ++$i;
  342. continue;
  343. }
  344. }
  345. else
  346. {
  347. $users[$i]["username"] = "No Member Found";
  348. $users[$i]["user_key"] = "";
  349. $users[$i]["sponsor_key"] = "";
  350. $users[$i]["payment_status"] = "";
  351. }
  352. return $users;
  353. }
  354.  
  355. function myTotalPersonalUsers($pkey) {
  356.  
  357. global $wpdb;
  358. $sql = "SELECT username, payment_status, user_key FROM " . $wpdb->prefix . "mlm_users WHERE sponsor_key = '" . $pkey . "' ORDER BY id DESC";
  359. $results = $wpdb->get_results($sql);
  360. $i = 0;
  361. if (0 < $wpdb->num_rows)
  362. {
  363. foreach ($results as $data)
  364. {
  365. $users[$i]["username"] = $data->username;
  366. $users[$i]["user_key"] = $data->user_key;
  367. $users[$i]["payment_status"] = activenotactive($data->payment_status);
  368. ++$i;
  369. continue;
  370. }
  371. }
  372. else
  373. {
  374. $users[$i]["username"] = "No Member Found";
  375. $users[$i]["user_key"] = "";
  376. $users[$i]["payment_status"] = "";
  377. }
  378. return $users;
  379. }
  380.  
  381. function legPlacement($leg) {
  382.  
  383. if ($leg == 0)
  384. {
  385. return "Left";
  386. }
  387. return "Right";
  388. }
  389.  
  390. function totalSales($pkey) {
  391.  
  392. global $wpdb;
  393. $sql = "SELECT username, payment_status, user_key, sponsor_key, leg
  394. FROM " . $wpdb->prefix . "mlm_users
  395. WHERE user_key IN(
  396. SELECT ukey
  397. FROM " . $wpdb->prefix . "mlm_rightleg
  398. WHERE pkey = '" . $pkey . "'
  399. ORDER BY id DESC)
  400. ORDER BY id DESC";
  401. $results = $wpdb->get_results($sql);
  402. $i = 0;
  403. if (0 < $wpdb->num_rows)
  404. {
  405. foreach ($results as $data)
  406. {
  407. $rightUsers[$i]["username"] = $data->username;
  408. $rightUsers[$i]["user_key"] = $data->user_key;
  409. $rightUsers[$i]["sponsor_key"] = getsponsorname($data->sponsor_key);
  410. $rightUsers[$i]["leg"] = legplacement("1");
  411. $rightUsers[$i]["payment_status"] = activenotactive($data->payment_status);
  412. ++$i;
  413. continue;
  414. }
  415. }
  416. $sql = "SELECT username, payment_status, user_key, sponsor_key, leg
  417. FROM " . $wpdb->prefix . "mlm_users
  418. WHERE user_key IN(
  419. SELECT ukey
  420. FROM " . $wpdb->prefix . "mlm_leftleg
  421. WHERE pkey = '" . $pkey . "'
  422. ORDER BY id DESC)
  423. ORDER BY id DESC";
  424. $results = $wpdb->get_results($sql);
  425. $i = 0;
  426. if (0 < $wpdb->num_rows)
  427. {
  428. foreach ($results as $data)
  429. {
  430. $leftUsers[$i]["username"] = $data->username;
  431. $leftUsers[$i]["user_key"] = $data->user_key;
  432. $leftUsers[$i]["sponsor_key"] = getsponsorname($data->sponsor_key);
  433. $leftUsers[$i]["leg"] = legplacement("0");
  434. $leftUsers[$i]["payment_status"] = activenotactive($data->payment_status);
  435. .............................................................
  436. ..............................
  437. ........
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!