API tools faq
paste
Advertisement
Whistik

Untitled

Whistik
Aug 2nd, 2017
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 34.08 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. /**
  4.  * @package   TinyIsland-Private
  5.  * @version   1.0
  6.  * @author    Whistik
  7. **/
  8.  
  9. class Player{
  10.  
  11.     public function Player_savegame($Player_name){
  12.  
  13.         $db = $GLOBALS['db'];
  14.         $qry = $db->prepare("SELECT * FROM players WHERE players_name = :players_name");
  15.         $qry->execute(array(":players_name" => $Player_name));
  16.         $gamedata = $qry->fetch(PDO::FETCH_ASSOC);
  17.  
  18.         $data[0] = $gamedata['players_id'];
  19.         $data[1] = 0;
  20.         $data[2] = $gamedata['players_rec'];
  21.         $data[3] = time();
  22.  
  23.         for($i=1;$i<11;$i++){
  24.             $data[3 + $i] = $gamedata['players_registrationip'];
  25.         }
  26.  
  27.         for($i=1;$i<11;$i++){
  28.             $data[14 + $i] = 0;
  29.         }
  30.  
  31.         $data[25] = $gamedata['players_registrationdate'];
  32.         $data[26] = $gamedata['players_registrationip'];
  33.         $data[27] = $gamedata['players_recoveryflag'];
  34.         $data[28] = $gamedata['players_validationdate'];
  35.         $data[29] = $gamedata['players_validationtype'];
  36.         $data[30] = $gamedata['players_validationip'];
  37.         $data[31] = $gamedata['players_validationdate'];
  38.         $data[32] = $gamedata['players_validationagaincount'];
  39.         $data[33] = $gamedata['players_lockstatus'];
  40.         $data[34] = $gamedata['players_lockduration'];
  41.         $data[35] = $gamedata['players_deleteprotectiondate'];
  42.         $data[36] = $gamedata['players_missingyou'];
  43.         $data[37] = $gamedata['players_coins'];
  44.         $data[38] = $gamedata['players_coinsrealbought'];
  45.         $data[39] = $gamedata['players_coinsdate'];
  46.         $data[40] = $gamedata['players_coinsboughtlasttime'];
  47.         $data[41] = $gamedata['players_firstpaymentuserfor'];
  48.         $data[42] = $gamedata['players_wiretransfercount'];
  49.         $data[43] = $gamedata['players_money'];
  50.         $data[44] = $gamedata['players_level'];
  51.         $data[45] = $gamedata['players_honor'];
  52.         $data[46] = $gamedata['players_rank'];
  53.         $data[47] = $gamedata['players_exp'];
  54.         $data[48] = $gamedata['players_exptonextlevel'];
  55.         $data[49] = $gamedata['players_life'];
  56.         $data[50] = $gamedata['players_armor'];
  57.         $data[51] = $gamedata['players_attack'];
  58.         for($i=1;$i<9;$i++){
  59.             // INVENTORY
  60.             $data[51 + $i] = $GLOBALS['player']->Player_getInventory($gamedata['players_id'], $i);
  61.         }
  62.         for($i=1;$i<11;$i++){
  63.             // BACKPACK
  64.             $data[60 + $i] = $GLOBALS['player']->Player_getBackpack($gamedata['players_id'], $i);
  65.         }
  66.         for($i=1;$i<10;$i++){
  67.             $data[71 + $i] = $gamedata['players_potion_'.$i];
  68.         }
  69.         $data[81] = $gamedata['players_gender'];
  70.         for($i=1;$i<16;$i++){
  71.             $data[81 + $i] = $gamedata['players_faceLook_'.$i];
  72.         }
  73.         for($i=1;$i<9;$i++){
  74.             $data[97 + $i] = $gamedata['players_boost_'.$i];
  75.         }
  76.         $data[106] = $gamedata['players_shiplevel'];
  77.         $data[107] = $GLOBALS['player']->Player_shipprice($gamedata['players_shiplevel']);
  78.         $data[108] = $gamedata['players_lives'];
  79.         $data[109] = $gamedata['players_livesrecharge'];
  80.         for($i=1;$i<10;$i++){
  81.             $data[109 + $i] = $gamedata['players_maps_'.$i];
  82.         }
  83.         $data[119] = $gamedata['players_nextislandlevel'];
  84.         $data[120] = $gamedata['players_nextmaptime'];
  85.         $data[121] = strtotime('today midnight');
  86.         for($i=1;$i<7;$i++){
  87.             $data[121 + $i] = $GLOBALS['player']->Player_getshopitems($gamedata['players_id'], 'voodoo', $i);
  88.         }
  89.         $data[128] = strtotime('today midnight');
  90.         for($i=1;$i<7;$i++){
  91.             $data[128 + $i] = $GLOBALS['player']->Player_getshopitems($gamedata['players_id'], 'weapon', $i);
  92.         }
  93.         $data[135] = 0;
  94.         for($i=1;$i<9;$i++){
  95.             $data[135 + $i] = 0;
  96.         }
  97.         for($i=1;$i<9;$i++){
  98.             $data[144 + $i] = 0;
  99.         }
  100.         $data[153] = 7;
  101.         $data[154] = 0;
  102.         $data[155] = 0;
  103.         $data[156] = 0;
  104.         $data[157] = 0;
  105.         $data[158] = 0;
  106.         for($i=1;$i<101;$i++){
  107.             $data[158 + $i] = 0;
  108.         }
  109.         $data[259] = time();
  110.         $data[260] = 0;//getNextIslandCost
  111.         $data[261] = $gamedata['players_shiplevelreset'];
  112.         $data[262] = $gamedata['players_privacy'];
  113.         $data[263] = $gamedata['players_shiplevelbonus'];
  114.         $data[264] = $gamedata['players_shiplevelbonusnext'];
  115.         $data[265] = $gamedata['players_shipcannonlevel'];
  116.         $data[266] = $gamedata['players_shipcannoncosts'];
  117.         $data[267] = $gamedata['players_shipshieldlevel'];
  118.         $data[268] = $gamedata['players_shipshieldcosts'];
  119.         $data[269] = $gamedata['players_lifebonus'];
  120.         $data[270] = $gamedata['players_attackbonus'];
  121.         $data[271] = $gamedata['players_attackbonusnext'];
  122.         $data[272] = $gamedata['players_shiplevelreset'];
  123.         for($i=1;$i<68;$i++){
  124.             $data[272 + $i] = 0;
  125.         }
  126.         $data[340] = 0;
  127.         $data[341] = 0;
  128.         $data[342] = 0;
  129.         $data[343] = 0;
  130.         $data[344] = 0;
  131.         $data[345] = 0;
  132.         $data[346] = 0;
  133.         $data[347] = 0;
  134.         $data[348] = 0;
  135.         for($i=1;$i<1648;$i++){
  136.             $data[348 + $i] = 0;
  137.         }
  138.  
  139.         return join("/", $data);
  140.  
  141.     }
  142.  
  143.     public function Player_generateitem($Player_name, $Item_isepic = false){
  144.  
  145.         $db = $GLOBALS['db'];
  146.  
  147.         $qry = $db->prepare("SELECT * FROM players WHERE players_name = :players_name");
  148.         $qry->execute(array(":players_name" => $Player_name));
  149.         $getdata = $qry->fetch(PDO::FETCH_ASSOC);
  150.  
  151.         $generateitem = rand(1, 9);
  152.         if($generateitem == 1){
  153.             if($Item_isepic == true){
  154.                 $item_picture = rand(1, 3);
  155.             }else{
  156.                 $item_picture = rand(1, 7);
  157.             }
  158.         }elseif($generateitem == 2){
  159.             if($Item_isepic == true){
  160.                 $item_picture = rand(1, 3);
  161.             }else{
  162.                 $item_picture = rand(1, 7);
  163.             }
  164.         }elseif($generateitem == 3){
  165.             if($Item_isepic == true){
  166.                 $item_picture = rand(1, 3);
  167.             }else{
  168.                 $item_picture = rand(1, 7);
  169.             }
  170.         }elseif($generateitem == 4){
  171.             if($Item_isepic == true){
  172.                 $item_picture = rand(1, 4);
  173.             }else{
  174.                 $item_picture = rand(1, 6);
  175.             }
  176.         }elseif($generateitem == 5){
  177.             if($Item_isepic == true){
  178.                 $item_drop = 4;
  179.                 $item_picture = rand(1, 4);
  180.             }else{
  181.                 $item_picture = rand(1, 4);
  182.             }
  183.         }elseif($generateitem == 6){
  184.             if($Item_isepic == true){
  185.                 $item_picture = rand(1, 3);
  186.             }else{
  187.                 $item_picture = rand(1, 4);
  188.             }
  189.         }elseif($generateitem = 7){
  190.             if($Item_isepic == true){
  191.                 $item_picture = rand(1, 3);
  192.             }else{
  193.                 $item_picture = rand(1, 4);
  194.             }
  195.         }elseif($generateitem = 8){
  196.             if($Item_isepic == true){
  197.                 $item_picture = rand(1, 3);
  198.             }else{
  199.                 $item_picture = rand(1, 4);
  200.             }
  201.         }else{
  202.             if($Item_isepic == true){
  203.                 $item_picture = rand(1, 3);
  204.             }else{
  205.                 $item_picture = rand(1, 4);
  206.             }
  207.         }
  208.         $data[0] = 0;
  209.         $data[1] = $generateitem;
  210.         $data[2] = $item_picture;
  211.         if($Item_isepic == false){
  212.             $data[3] = 0;
  213.             $data[4] = 0;
  214.             $data[5] = rand(($getdata['players_level']*$getdata['players_level']), ($getdata['players_level']*$getdata['players_level']) * 2);
  215.         }else{
  216.             $data[3] = 1;
  217.             $data[4] = 15;
  218.             $data[5] = rand(($getdata['players_level']*$getdata['players_level']) * 2, ($getdata['players_level']*$getdata['players_level']) * 4);
  219.         }
  220.         $data[6] = 0;
  221.         $data[7] = 0;
  222.         $data[8] = 0;
  223.         $data[9] = 0;
  224.         $data[10] = 0;
  225.         $data[11] = 0;
  226.         $data[12] = 0;
  227.         $data[13] = 0;
  228.  
  229.         if($slot <= 19){
  230.             $slot = $backpackdata['bs'] + 1;
  231.         }else{
  232.             exit("Error:moving not allowed");
  233.         }
  234.        
  235.         $qry = $db->prepare("INSERT INTO backpack(backpack_slot, backpack_level, backpack_item, backpack_picture, backpack_isepic, backpack_price_coins, backpack_price_moneys, backpack_attributetype_1, backpack_attributetype_2, backpack_attributetype_3, backpack_attributetype_4, backpack_attributevalue_1, backpack_attributevalue_2, backpack_attributevalue_3, backpack_attributevalue_4, backpack_owner) VALUES(:backpack_slot, :backpack_level, :backpack_item, :backpack_picture, :backpack_isepic, :backpack_price_coins, :backpack_price_moneys, :backpack_attributetype_1, :backpack_attributetype_2, :backpack_attributetype_3, :backpack_attributetype_4, :backpack_attributevalue_1, :backpack_attributevalue_2, :backpack_attributevalue_3, :backpack_attributevalue_4, :backpack_owner)");
  236.         $qry->execute(array(":backpack_slot" => $slot, ":backpack_level" => $getdata['players_level'], ":backpack_item" => $generateitem, ":backpack_picture" => $item_picture, ":backpack_isepic" => $data[3], ":backpack_price_coins" => $data[4], ":backpack_price_moneys" => $data[5], ":backpack_attributetype_1" => $data[6], ":backpack_attributetype_2" => $data[7], ":backpack_attributetype_3" => $data[8], ":backpack_attributetype_4" => $data[9], ":backpack_attributevalue_1" => $data[10], ":backpack_attributevalue_2" => $data[11], ":backpack_attributevalue_3" => $data[12], ":backpack_attributevalue_4" => $data[13], ":backpack_owner" => $getdata['players_id']));
  237.  
  238.         return join("/", $data);
  239.  
  240.     }
  241.  
  242.     public function Player_adrift($Player_name){
  243.  
  244.         $db = $GLOBALS['db'];
  245.  
  246.         $item_reward = rand(1, 100);
  247.         if($item_reward <= 70){
  248.             $item_reward = "0/0/0/0/0/0/0/0/0/0/0/0/0/0";
  249.         }else{
  250.             $item_reward = $GLOBALS['player']->Player_generateitem($Player_name, false);
  251.         }
  252.  
  253.         $data[0] = "0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0";
  254.         $data[22] = 1; //TYPE
  255.         $data[23] = 2; //PICTURE
  256.         $data[24] = time() + (time() / 2); //EXPIRE
  257.         $data[25] = 0; //MATCHTYPE ??
  258.         $data[26] = 100001; //ENEMY ??
  259.         $data[27] = 1; //ENEMY LEVEL
  260.         $data[28] = 500; //GOLD REW
  261.         $data[29] = 500; //EXP REW
  262.         $data[30] = $item_reward;
  263.  
  264.         return join("/", $data);
  265.  
  266.     }
  267.  
  268.     public function Player_achdata($Player_name){
  269.  
  270.         $data[0] = "0/25/50/75/100/150/200/250/0/1/1/1/1/1/1/10";
  271.         $data[1] = "1/10/50/100/500/1000/5000/10000/1/1/1/1/1/1/1/10";
  272.         $data[2] = "10/50/100/500/1000/5000/10000/100000/1/1/1/1/1/1/1/10";
  273.         $data[3] = "10000/100000/1000000/10000000/50000000/100000000/500000000/1000000000/1/1/1/1/1/1/1/10";
  274.         $data[4] = "1/2/3/4/5/6/7/8/1/1/1/1/1/1/1/10";
  275.         $data[5] = "100/500/1000/5000/10000/50000/100000/1000000/1/1/1/1/1/1/1/10";
  276.         $data[6] = "10/50/100/500/1000/5000/10000/100000/1/1/1/1/1/1/1/10";
  277.         $data[7] = "10/100/500/1000/5000/10000/50000/100000/1/1/1/1/1/1/1/10";
  278.         return join("/", $data);
  279.  
  280.     }
  281.  
  282.     public function Player_shiplevels($Player_name){
  283.  
  284.         $data[] = "5/5/10/15/20/25/30/35/40/45/50/55/60/65/70/75/80/85/90/95/100/105/110/115/120/125/130/135/140/145/41/";
  285.         return implode("", $data);
  286.  
  287.     }
  288.  
  289.     public function Player_shipprice($Player_shiplevel){
  290.  
  291.         $shipprice = (((($Player_shiplevel + $Player_shiplevel) * $Player_shiplevel) * 100) * 1.5) + 100;
  292.         return intval($shipprice);
  293.  
  294.     }
  295.  
  296.     public function Player_getdata($Player_name, $arg){
  297.  
  298.         $db = $GLOBALS['db'];
  299.         $qry = $db->prepare("SELECT * FROM players WHERE players_name = :players_name");
  300.         $qry->execute(array(":players_name" => $Player_name));
  301.         $getdata = $qry->fetch(PDO::FETCH_ASSOC);
  302.         return $getdata[$arg];
  303.  
  304.     }
  305.  
  306.     public function Player_generateshopitems($Player_id, $Item_shop){
  307.  
  308.         $db = $GLOBALS['db'];
  309.  
  310.         $qry = $db->prepare("SELECT * FROM players WHERE players_id = :players_id");
  311.         $qry->execute(array(":players_id" => $Player_id));
  312.         $getdata = $qry->fetch(PDO::FETCH_ASSOC);
  313.  
  314.         $qry = $db->prepare("UPDATE players SET players_coins = players_coins - 1 WHERE players_id = :players_id");
  315.         $qry->execute(array(":players_id" => $Player_id));
  316.  
  317.         $qry = $db->prepare("DELETE FROM shops WHERE shops_name = :shops_name AND shops_owner = :shops_owner");
  318.         $qry->execute(array(":shops_name" => $Item_shop, ":shops_owner" => $Player_id));
  319.  
  320.         $qry = $db->prepare("SELECT * FROM players WHERE players_id = :players_id");
  321.         $qry->execute(array(":players_id" => $Player_id));
  322.         $getdata = $qry->fetch(PDO::FETCH_ASSOC);
  323.         $items_ammount = rand(6, 6);
  324.  
  325.  
  326.         for($i=0;$i<6;$i++){
  327.             $epic_chance = rand(1, 100);
  328.             if($epic_chance <= 90){
  329.                 $item_isepic = false;
  330.             }else{
  331.                 $item_isepic = true;
  332.             }
  333.             if($Item_shop == "voodoo"){
  334.                 $item_drop = rand(1, 3);
  335.                 if($item_drop == 1){
  336.                     if($item_isepic == true){
  337.                         $item_picture = rand(1, 3);
  338.                     }else{
  339.                         $item_picture = rand(1, 15);
  340.                     }
  341.                 }elseif($item_drop == 2){
  342.                     if($item_isepic == true){
  343.                         $item_picture = rand(1, 3);
  344.                     }else{
  345.                         $item_picture = rand(1, 15);
  346.                     }
  347.                 }elseif($item_drop == 3){
  348.                     if($item_isepic == true){
  349.                         $item_picture = rand(1, 3);
  350.                     }else{
  351.                         $item_picture = rand(1, 15);
  352.                     }
  353.                 }
  354.                 $data[0] = $getdata['players_level'];
  355.                 $data[1] = $item_drop;
  356.                 $data[2] = $item_picture;
  357.                 if($epic_chance <= 98){
  358.                     $data[3] = 0;
  359.                     $data[4] = 0;
  360.                     $data[5] = rand(($getdata['players_level']*$getdata['players_level']), ($getdata['players_level']*$getdata['players_level']) * 2);
  361.                 }else{
  362.                     $data[3] = 1;
  363.                     $data[4] = 15;
  364.                     $data[5] = rand(($getdata['players_level']*$getdata['players_level']) * 2, ($getdata['players_level']*$getdata['players_level']) * 4);
  365.                 }
  366.                 $data[6] = 1;
  367.                 $data[7] = 2;
  368.                 $data[8] = 3;
  369.                 $data[9] = 4;
  370.                 $data[10] = 5;
  371.                 $data[11] = 6;
  372.                 $data[12] = 7;
  373.                 $data[13] = 8;
  374.             }else{
  375.                 $item_drop = rand(4, 9);
  376.                 if($item_drop == 4){
  377.                     if($item_isepic == true){
  378.                         $item_picture = rand(1, 10);
  379.                     }else{
  380.                         $item_picture = rand(1, 30);
  381.                     }
  382.                 }elseif($item_drop == 5){
  383.                     if($item_isepic == true){
  384.                         $item_drop = 4;
  385.                         $item_picture = rand(5, 10);
  386.                     }else{
  387.                         $item_picture = rand(1, 15);
  388.                     }
  389.                 }elseif($item_drop == 6){
  390.                     if($item_isepic == true){
  391.                         $item_picture = rand(1, 4);
  392.                     }else{
  393.                         $item_picture = rand(1, 20);
  394.                     }
  395.                 }elseif($item_drop == 7){
  396.                     if($item_isepic == true){
  397.                         $item_picture = rand(1, 4);
  398.                     }else{
  399.                         $item_picture = rand(1, 20);
  400.                     }
  401.                 }elseif($item_drop == 8){
  402.                     if($item_isepic == true){
  403.                         $item_picture = rand(1, 3);
  404.                     }else{
  405.                         $item_picture = rand(1, 20);
  406.                     }
  407.                 }elseif($item_drop == 9){
  408.                     if($item_isepic == true){
  409.                         $item_picture = rand(1, 3);
  410.                     }else{
  411.                         $item_picture = rand(1, 20);
  412.                     }
  413.                 }
  414.                 $data[0] = $getdata['players_level'];
  415.                 $data[1] = $item_drop;
  416.                 $data[2] = $item_picture;
  417.                 if($epic_chance <= 98){
  418.                     $data[3] = 0;
  419.                     $data[4] = 0;
  420.                     $data[5] = rand(($getdata['players_level']*$getdata['players_level']), ($getdata['players_level']*$getdata['players_level']) * 2);
  421.                 }else{
  422.                     $data[3] = 1;
  423.                     $data[4] = 15;
  424.                     $data[5] = rand(($getdata['players_level']*$getdata['players_level']) * 2, ($getdata['players_level']*$getdata['players_level']) * 4);
  425.                 }
  426.                 $data[6] = 0;
  427.                 $data[7] = 0;
  428.                 $data[8] = 0;
  429.                 $data[9] = 0;
  430.                 $data[10] = 0;
  431.                 $data[11] = 0;
  432.                 $data[12] = 0;
  433.                 $data[13] = 0;
  434.             }
  435.             $shops_slot_gen = (1 + $i);
  436.             $shops_slot = $shops_slot_gen;
  437.             $qry = $db->prepare("SELECT * FROM shops WHERE shops_name = :shops_name, shops_owner = :shops_owner, shops_slot = :shops_slot");
  438.             $qry->execute(array(":shops_name" => $Item_shop, ":shops_owner" => $Player_id, ":shops_slot" => $shops_slot));
  439.             if($qry->rowCount() == 0){
  440.                 $qry = $db->prepare("INSERT INTO shops(shops_name, shops_owner, shops_slot, shops_isepic, shops_type, shops_picture, shops_level, shops_price_coins, shops_price_moneys, shops_dmg) VALUES(:shops_name, :shops_owner, :shops_slot, :shops_isepic, :shops_type, :shops_picture, :shops_level, :shops_price_coins, :shops_price_moneys, :shops_dmg)");
  441.                 $qry->execute(array(":shops_name" => $Item_shop, ":shops_owner" => $Player_id, ":shops_slot" => $shops_slot, ":shops_isepic" => $data[3], ":shops_type" => $data[1], ":shops_picture" => $data[2], ":shops_level" => $getdata['players_level'], ":shops_price_coins" => $data[4], ":shops_price_moneys" => $data[5], ":shops_dmg" => $data[12]));
  442.             }else{
  443.                 $this->Player_generateshopitems($Player_id, $Item_shop);
  444.             }
  445.         }
  446.         return join("/", $data);
  447.  
  448.     }
  449.  
  450.     public function Player_getshopitems($Player_id, $Item_shop, $Item_place){
  451.  
  452.         $db = $GLOBALS['db'];
  453.         $qry = $db->prepare("SELECT * FROM shops WHERE shops_name = :shops_name AND shops_owner = :shops_owner AND shops_slot = :shops_slot");
  454.         $qry->execute(array(":shops_name" => $Item_shop, ":shops_owner" => $Player_id, ":shops_slot" => $Item_place));
  455.  
  456.         if($qry->rowCount() == 0){
  457.             $data[] = "0/0/0/0/0/0/0/0/0/0/0/0/0/0";
  458.         }else{
  459.             $getshopitems = $qry->fetch(PDO::FETCH_ASSOC);
  460.             $data[0] = 2;
  461.             $data[1] = $getshopitems['shops_type'];
  462.             $data[2] = $getshopitems['shops_picture'];
  463.             $data[3] = $getshopitems['shops_isepic'];
  464.             $data[4] = $getshopitems['shops_price_coins'];
  465.             $data[5] = $getshopitems['shops_price_moneys'];
  466.             $data[6] = 0;
  467.             $data[7] = 0; //Výzbroj, životy
  468.             $data[8] = 0; //Výzbroj, životy
  469.             $data[9] = 0; //Výzbroj, životy
  470.             $data[10] = 4;
  471.             $data[11] = 0; //Výzbroj value
  472.             $data[12] = 0; //Výzbroj wtf?
  473.             $data[13] = 0;
  474.         }
  475.         return join("/", $data);
  476.  
  477.     }
  478.     public function Player_getBackpack($Player_id, $Inventory_slot){
  479.  
  480.         $db = $GLOBALS['db'];
  481.  
  482.         $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_owner = :backpack_owner AND backpack_slot = :backpack_slot");
  483.         $qry->execute(array(":backpack_owner" => $Player_id, ":backpack_slot" => $Inventory_slot));
  484.         $getInventory = $qry->fetch(PDO::FETCH_ASSOC);
  485.         if($qry->rowCount() > 0){
  486.             $data[0] = $getInventory['backpack_item'];
  487.             $data[1] = $getInventory['backpack_picture'];
  488.             $data[2] = $getInventory['backpack_isepic'];
  489.             $data[3] = $getInventory['backpack_price_coins'];
  490.             $data[4] = $getInventory['backpack_price_moneys'];
  491.  
  492.             //ATTRIBUTE TYPE
  493.             $data[5] = $getInventory['backpack_attributetype_1'];
  494.             $data[6] = $getInventory['backpack_attributetype_2'];
  495.             $data[7] = $getInventory['backpack_attributetype_3'];
  496.             $data[8] = $getInventory['backpack_attributetype_4'];
  497.             //ATTRIBUTE VALUE
  498.             $data[9] = $getInventory['backpack_attributevalue_1'];
  499.             $data[10] = $getInventory['backpack_attributevalue_2'];
  500.             $data[11] = $getInventory['backpack_attributevalue_3'];
  501.             $data[12] = $getInventory['backpack_dmg'];
  502.             $data[13] = $getInventory['backpack_attributevalue_4'];
  503.         }else{
  504.             $data[] = "0/0/0/0/0/0/0/0/0/0/0/0/0/0";
  505.         }
  506.         return join("/", $data);
  507.  
  508.     }
  509.  
  510.     public function Player_getItem($Player_id, $Item_location, $Item_slot){
  511.  
  512.         $db = $GLOBALS['db'];
  513.  
  514.         $qry = $db->prepare("SELECT * FROM item WHERE item_owner = :item_owner AND item_location = :item_location AND item_slot = :item_slot");
  515.         $qry->execute(array(":item_owner" => $Player_id, ":item_location" => $Item_location, ":item_slot" => $Item_slot));
  516.         $getItem = $qry->fetch(PDO::FETCH_ASSOC);
  517.         if($qry->rowCount() > 0){
  518.             $data[] = $getInventory['item_type'];
  519.             $data[] = $getInventory['item_picture'];
  520.             $data[] = $getInventory['item_isepic'];
  521.             $data[] = $getInventory['item_price_coins'];
  522.             $data[] = $getInventory['item_price_moneys'];
  523.             $data[] = $getInventory['item_dmg'];
  524.             $data[] = $getInventory['item_attributetype_1'];
  525.             $data[] = $getInventory['item_attributetype_2'];
  526.             $data[] = $getInventory['item_attributetype_3'];
  527.             $data[] = $getInventory['item_attributetype_4'];
  528.             $data[] = $getInventory['item_attributevalue_1'];
  529.             $data[] = $getInventory['item_attributevalue_2'];
  530.             $data[] = $getInventory['item_attributevalue_3'];
  531.             $data[] = $getInventory['item_attributevalue_4'];
  532.         }else{
  533.             return "0/0/0/0/0/0/0/0/0/0/0/0/0/0";
  534.         }
  535.         return join("/", $data);
  536.     }
  537.     public function Player_getInventory($Player_id, $Inventory_slot){
  538.  
  539.         $db = $GLOBALS['db'];
  540.  
  541.         $qry = $db->prepare("SELECT * FROM inventory WHERE inventory_owner = :inventory_owner AND inventory_slot = :inventory_slot");
  542.         $qry->execute(array(":inventory_owner" => $Player_id, ":inventory_slot" => $Inventory_slot));
  543.         $getInventory = $qry->fetch(PDO::FETCH_ASSOC);
  544.         if($qry->rowCount() > 0){
  545.             $data[0] = $getInventory['inventory_place'];
  546.             $data[1] = $getInventory['inventory_look'];
  547.             $data[2] = $getInventory['inventory_isepic'];
  548.             $data[3] = $getInventory['inventory_price_coins'];
  549.             $data[4] = $getInventory['inventory_price_money'];
  550.             $data[12] = $getInventory['inventory_dmg'];
  551.             //ATTRIBUTE TYPE
  552.             $data[5] = $getInventory['inventory_attributetype_1'];
  553.             $data[6] = $getInventory['inventory_attributetype_2'];
  554.             $data[7] = $getInventory['inventory_attributetype_3'];
  555.             $data[8] = $getInventory['inventory_attributetype_4'];
  556.             //ATTRIBUTE VALUE
  557.             $data[9] = $getInventory['inventory_attributevalue_1'];
  558.             $data[10] = $getInventory['inventory_attributevalue_2'];
  559.             $data[11] = $getInventory['inventory_attributevalue_3'];
  560.             $data[13] = $getInventory['inventory_attributevalue_4'];
  561.         }else{
  562.             $data[] = "0/0/0/0/0/0/0/0/0/0/0/0/0/0";
  563.         }
  564.         return join("/", $data);
  565.  
  566.     }
  567.  
  568.     public function Player_insertitem($Player_id, $item_place, $item_look, $item_isepic = 0, $item_price_coins = 0, $item_price_money, $item_dmg, $item_attributetype_1, $item_attributetype_2, $item_attributetype_3, $item_attributetype_4, $item_attributevalue_1, $item_attributevalue_2, $item_attributevalue_3, $item_attributevalue_4){
  569.  
  570.         $db = $GLOBALS['db'];
  571.  
  572.         if($item_place == 9){
  573.             $item_slot = 8;
  574.         }elseif($item_place == 8){
  575.             $item_slot = 7;
  576.         }elseif($item_place == 7){
  577.             $item_slot = 6;
  578.         }elseif($item_place == 6){
  579.             $item_slot = 5;
  580.         }elseif($item_place == 5 || $item_place == 4){
  581.             $item_slot = 4;
  582.         }elseif($item_place == 3){
  583.             $item_slot = 3;
  584.         }elseif($item_place == 2){
  585.             $item_slot = 2;
  586.         }elseif($item_place == 1){
  587.             $item_slot = 1;
  588.         }
  589.  
  590.         $qry = $db->prepare("SELECT * FROM inventory WHERE inventory_slot = :inventory_slot");
  591.         $qry->execute(array(":inventory_slot" => $item_slot));
  592.  
  593.         if($qry->rowCount() > 0) exit();
  594.  
  595.         $qry = $db->prepare("INSERT INTO inventory(inventory_place, inventory_look, inventory_isepic, inventory_price_coins, inventory_price_money, inventory_dmg, inventory_owner, inventory_slot, inventory_attributetype_1, inventory_attributetype_2, inventory_attributetype_3, inventory_attributetype_4, inventory_attributevalue_1, inventory_attributevalue_2, inventory_attributevalue_3, inventory_attributevalue_4) VALUES(:inventory_place, :inventory_look, :inventory_isepic, :inventory_price_coins, :inventory_price_money, :inventory_dmg, :inventory_owner, :inventory_slot, :inventory_attributetype_1, :inventory_attributetype_2, :inventory_attributetype_3, :inventory_attributetype_4, :inventory_attributevalue_1, :inventory_attributevalue_2, :inventory_attributevalue_3, :inventory_attributevalue_4)");
  596.         $qry->execute(array(":inventory_place" => $item_place, ":inventory_look" => $item_look, ":inventory_isepic" => $item_isepic, ":inventory_price_coins" => $item_price_coins, ":inventory_price_money" => $item_price_money, ":inventory_dmg" => $item_dmg, ":inventory_owner" => $Player_id, ":inventory_slot" => $item_slot, ":inventory_attributetype_1" => $item_attributetype_1, ":inventory_attributetype_2" => $item_attributetype_2, ":inventory_attributetype_3" => $item_attributetype_3, ":inventory_attributetype_4" => $item_attributetype_4, ":inventory_attributevalue_1" => $item_attributevalue_1, ":inventory_attributevalue_2" => $item_attributevalue_2, ":inventory_attributevalue_3" => $item_attributevalue_3, ":inventory_attributevalue_4" => $item_attributevalue_4));
  597.  
  598.     }
  599.  
  600.     public function Player_itemMove($Player_id, $source, $sourceTo, $sourceSlot, $targetSlot){
  601.  
  602.         $db = $GLOBALS['db'];
  603.  
  604.  
  605.         if($source == 1 && $sourceTo == 2){
  606.             $qry = $db->prepare("SELECT * FROM inventory WHERE inventory_slot = :inventory_slot AND inventory_owner = :inventory_owner");
  607.             $qry->execute(array(":inventory_slot" => $sourceSlot, ":inventory_owner" => $Player_id));
  608.             $itemMove = $qry->fetch(PDO::FETCH_ASSOC);
  609.  
  610.             $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_owner = :backpack_owner");
  611.             $qry->execute(array(":backpack_owner" => $Player_id));
  612.             while($backpackdata = $qry->fetch(PDO::FETCH_ASSOC)){
  613.                 if($backpackdata['backpack_slot'] == $targetSlot){
  614.                     exit("Error:moving not allowed");
  615.                 }
  616.             }
  617.  
  618.             $qry = $db->prepare("INSERT INTO backpack(backpack_slot, backpack_level, backpack_item, backpack_picture, backpack_isepic, backpack_price_coins, backpack_price_moneys, backpack_attributetype_1, backpack_attributetype_2, backpack_attributetype_3, backpack_attributetype_4, backpack_attributevalue_1, backpack_attributevalue_2, backpack_attributevalue_3, backpack_attributevalue_4, backpack_owner, backpack_dmg) VALUES(:backpack_slot, :backpack_level, :backpack_item, :backpack_picture, :backpack_isepic, :backpack_price_coins, :backpack_price_moneys, :backpack_attributetype_1, :backpack_attributetype_2, :backpack_attributetype_3, :backpack_attributetype_4, :backpack_attributevalue_1, :backpack_attributevalue_2, :backpack_attributevalue_3, :backpack_attributevalue_4, :backpack_owner, :backpack_dmg)");
  619.             $qry->execute(array(":backpack_slot" => $targetSlot, ":backpack_level" => "0", ":backpack_item" => $itemMove['inventory_place'], ":backpack_picture" => $itemMove['inventory_look'], ":backpack_isepic" => $itemMove['inventory_isepic'], ":backpack_price_coins" => $itemMove['inventory_price_coins'], ":backpack_price_moneys" => $itemMove['inventory_price_money'], ":backpack_attributetype_1" => $itemMove['inventory_attributetype_1'], ":backpack_attributetype_2" => $itemMove['inventory_attributetype_2'], ":backpack_attributetype_3" => $itemMove['inventory_attributetype_3'], ":backpack_attributetype_4" => $itemMove['inventory_attributetype_4'], ":backpack_attributevalue_1" => $itemMove['inventory_attributevalue_1'], ":backpack_attributevalue_2" => $itemMove['inventory_attributevalue_2'], ":backpack_attributevalue_3" => $itemMove['inventory_attributevalue_3'], ":backpack_attributevalue_4" => $itemMove['inventory_attributevalue_4'], ":backpack_owner" => $itemMove['inventory_owner'], ":backpack_dmg" => $itemMove['inventory_dmg']));
  620.  
  621.             $qry = $db->prepare("DELETE FROM inventory WHERE inventory_slot = :inventory_slot AND inventory_owner = :inventory_owner");
  622.             $qry->execute(array(":inventory_slot" => $sourceSlot, ":inventory_owner" => $Player_id));
  623.         }elseif($source == 2 && $sourceTo == 1){
  624.             $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_slot = :backpack_slot AND backpack_owner = :backpack_owner");
  625.             $qry->execute(array(":backpack_slot" => $sourceSlot, ":backpack_owner" => $Player_id));
  626.             $itemMove = $qry->fetch(PDO::FETCH_ASSOC);
  627.  
  628.             if($itemMove['backpack_item'] == 9){
  629.                 $targetSlot = 8;
  630.             }elseif($itemMove['backpack_item'] == 8){
  631.                 $targetSlot = 7;
  632.             }elseif($itemMove['backpack_item'] == 7){
  633.                 $targetSlot = 6;
  634.             }elseif($itemMove['backpack_item'] == 6){
  635.                 $targetSlot = 5;
  636.             }elseif($itemMove['backpack_item'] == 5 || $itemMove['backpack_item'] == 4){
  637.                 $targetSlot = 4;
  638.             }elseif($itemMove['backpack_item'] == 3){
  639.                 $targetSlot = 3;
  640.             }elseif($itemMove['backpack_item'] == 2){
  641.                 $targetSlot = 2;
  642.             }elseif($itemMove['backpack_item'] == 1){
  643.                 $targetSlot = 1;
  644.             }
  645.  
  646.             $qry = $db->prepare("SELECT * FROM inventory WHERE inventory_owner = :inventory_owner AND inventory_slot = :inventory_slot");
  647.             $qry->execute(array(":inventory_owner" => $Player_id, ":inventory_slot" => $targetSlot));
  648.             while($backpackdata = $qry->fetch(PDO::FETCH_ASSOC)){
  649.                 if($backpackdata['inventory_slot'] == $targetSlot || $backpackdata['inventory_place'] != $itemMove['backpack_item']){
  650.                     exit("Error:moving not allowed");
  651.                 }
  652.             }
  653.  
  654.             $qry = $db->prepare("INSERT INTO inventory(inventory_place, inventory_look, inventory_isepic, inventory_price_coins, inventory_price_money, inventory_dmg, inventory_owner, inventory_slot, inventory_attributetype_1, inventory_attributetype_2, inventory_attributetype_3, inventory_attributetype_4, inventory_attributevalue_1, inventory_attributevalue_2, inventory_attributevalue_3, inventory_attributevalue_4) VALUES(:inventory_place, :inventory_look, :inventory_isepic, :inventory_price_coins, :inventory_price_money, :inventory_dmg, :inventory_owner, :inventory_slot, :inventory_attributetype_1, :inventory_attributetype_2, :inventory_attributetype_3, :inventory_attributetype_4, :inventory_attributevalue_1, :inventory_attributevalue_2, :inventory_attributevalue_3, :inventory_attributevalue_4)");
  655.             $qry->execute(array(":inventory_place" => $itemMove['backpack_item'], ":inventory_look" => $itemMove['backpack_picture'], ":inventory_isepic" => $itemMove['backpack_isepic'], ":inventory_price_coins" => $itemMove['backpack_price_coins'], ":inventory_price_money" => $itemMove['backpack_price_moneys'], ":inventory_dmg" => $itemMove['backpack_dmg'], ":inventory_owner" => $itemMove['backpack_owner'], ":inventory_slot" => $targetSlot, ":inventory_attributetype_1" => $itemMove['backpack_attributetype_1'], ":inventory_attributetype_2" => $itemMove['backpack_attributetype_2'], ":inventory_attributetype_3" => $itemMove['backpack_attributetype_3'], ":inventory_attributetype_4" => $itemMove['backpack_attributetype_4'], ":inventory_attributevalue_1" => $itemMove['backpack_attributevalue_1'], ":inventory_attributevalue_2" => $itemMove['backpack_attributevalue_2'], ":inventory_attributevalue_3" => $itemMove['backpack_attributevalue_3'], ":inventory_attributevalue_4" => $itemMove['backpack_attributevalue_4']));
  656.             $qry = $db->prepare("DELETE FROM backpack WHERE backpack_slot = :backpack_slot AND backpack_owner = :backpack_owner");
  657.             $qry->execute(array(":backpack_slot" => $sourceSlot, ":backpack_owner" => $Player_id));
  658.         }elseif($source == 2 && $sourceTo == 2){
  659.             $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_slot = :backpack_slot AND backpack_owner = :backpack_owner");
  660.             $qry->execute(array(":backpack_slot" => $sourceSlot, ":backpack_owner" => $Player_id));
  661.             $itemMove = $qry->fetch(PDO::FETCH_ASSOC);
  662.  
  663.             $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_owner = :backpack_owner");
  664.             $qry->execute(array(":backpack_owner" => $Player_id));
  665.             while($backpackdata = $qry->fetch(PDO::FETCH_ASSOC)){
  666.                 if($backpackdata['backpack_slot'] == $targetSlot){
  667.                     exit("Error:moving not allowed");
  668.                 }
  669.             }
  670.  
  671.             $qry = $db->prepare("UPDATE backpack SET backpack_slot = :backpack_slot WHERE backpack_item = :backpack_item AND backpack_picture = :backpack_picture AND backpack_dmg = :backpack_dmg AND backpack_owner = :backpack_owner");
  672.             $qry->execute(array(":backpack_slot" => $targetSlot, ":backpack_item" => $itemMove['backpack_item'], ":backpack_picture" => $itemMove['backpack_picture'], ":backpack_dmg" => $itemMove['backpack_dmg'], ":backpack_owner" => $Player_id));
  673.         }elseif($source == 3 || $source == 4 && $sourceTo == 2){
  674.             if($source == 4){
  675.                 $shop = "weapon";
  676.             }elseif($source == 3){
  677.                 $shop = "voodoo";
  678.             }
  679.             $qry = $db->prepare("SELECT * FROM shops WHERE shops_name = :shops_name AND shops_owner = :shops_owner AND shops_slot = :shops_slot");
  680.             $qry->execute(array(":shops_name" => $shop, ":shops_owner" => $Player_id, ":shops_slot" => $sourceSlot));
  681.             $itemMove = $qry->fetch(PDO::FETCH_ASSOC);
  682.             $qry = $db->prepare("SELECT * FROM players WHERE players_id = :players_id");
  683.             $qry->execute(array(":players_id" => $Player_id));
  684.             $playerMove = $qry->fetch(PDO::FETCH_ASSOC);
  685.             $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_owner = :backpack_owner");
  686.             $qry->execute(array(":backpack_owner" => $Player_id));
  687.             while($backpackdata = $qry->fetch(PDO::FETCH_ASSOC)){
  688.                 if($backpackdata['backpack_slot'] == $targetSlot){
  689.                     exit("Error:moving not allowed");
  690.                 }
  691.             }
  692.  
  693.             if($playerMove['players_money'] < $itemMove['shops_price_moneys']){
  694.                 exit("Error:moving not allowed");
  695.             }else{
  696.                 $qry = $db->prepare("UPDATE players SET players_money = players_money - :players_money WHERE players_id = :players_id");
  697.                 $qry->execute(array(":players_money" => $itemMove['shops_price_moneys'], ":players_id" => $Player_id));
  698.             }
  699.             if($playerMove['players_money'] < $itemMove['shops_price_moneys']){
  700.                 exit("Error:not enough coins");
  701.             }else{
  702.                 $qry = $db->prepare("UPDATE players SET players_coins = players_coins - :players_coins WHERE players_id = :players_id");
  703.                 $qry->execute(array(":players_coins" => $itemMove['shops_price_coins'], ":players_id" => $Player_id));
  704.             }
  705.  
  706.             $useditem_price_coins = 0;
  707.             $useditem_price_moneys = ($itemMove['shops_price_moneys'] / 8);
  708.             $qry = $db->prepare("INSERT INTO backpack(backpack_slot, backpack_level, backpack_item, backpack_picture, backpack_isepic, backpack_price_coins, backpack_price_moneys, backpack_attributetype_1, backpack_attributetype_2, backpack_attributetype_3, backpack_attributetype_4, backpack_attributevalue_1, backpack_attributevalue_2, backpack_attributevalue_3, backpack_attributevalue_4, backpack_owner, backpack_dmg) VALUES(:backpack_slot, :backpack_level, :backpack_item, :backpack_picture, :backpack_isepic, :backpack_price_coins, :backpack_price_moneys, :backpack_attributetype_1, :backpack_attributetype_2, :backpack_attributetype_3, :backpack_attributetype_4, :backpack_attributevalue_1, :backpack_attributevalue_2, :backpack_attributevalue_3, :backpack_attributevalue_4, :backpack_owner, :backpack_dmg)");
  709.             $qry->execute(array(":backpack_slot" => $targetSlot, ":backpack_level" => "0", ":backpack_item" => $itemMove['shops_type'], ":backpack_picture" => $itemMove['shops_picture'], ":backpack_isepic" => $itemMove['shops_isepic'], ":backpack_price_coins" => $useditem_price_coins, ":backpack_price_moneys" => $useditem_price_moneys, ":backpack_attributetype_1" => $itemMove['shops_attributetype_1'], ":backpack_attributetype_2" => $itemMove['shops_attributetype_2'], ":backpack_attributetype_3" => $itemMove['shops_attributetype_3'], ":backpack_attributetype_4" => $itemMove['shops_attributetype_4'], ":backpack_attributevalue_1" => $itemMove['shops_attributevalue_1'], ":backpack_attributevalue_2" => $itemMove['shops_attributevalue_2'], ":backpack_attributevalue_3" => $itemMove['shops_attributevalue_3'], ":backpack_attributevalue_4" => $itemMove['shops_attributevalue_4'], ":backpack_owner" => $Player_id, ":backpack_dmg" => $itemMove['shops_dmg']));
  710.  
  711.             $qry = $db->prepare("DELETE FROM shops WHERE shops_name = :shops_name AND shops_owner = :shops_owner AND shops_slot = :shops_slot");
  712.             $qry->execute(array(":shops_name" => $shop, ":shops_owner" => $Player_id, ":shops_slot" => $sourceSlot));
  713.         }elseif($source == 2 && $sourceTo == 3 || $sourceTo == 4){
  714.             $qry = $db->prepare("SELECT * FROM backpack WHERE backpack_slot = :backpack_slot AND backpack_owner = :backpack_owner");
  715.             $qry->execute(array(":backpack_slot" => $sourceSlot, ":backpack_owner" => $Player_id));
  716.             $itemMove = $qry->fetch(PDO::FETCH_ASSOC);
  717.             $qry = $db->prepare("UPDATE players SET players_money = players_money + :players_money WHERE players_id = :players_id");
  718.             $qry->execute(array(":players_money" => $itemMove['backpack_price_moneys'], ":players_id" => $Player_id));
  719.             $qry = $db->prepare("DELETE FROM backpack WHERE backpack_slot = :backpack_slot AND backpack_owner = :backpack_owner");
  720.             $qry->execute(array(":backpack_slot" => $sourceSlot, ":backpack_owner" => $Player_id));
  721.         }
  722.  
  723.  
  724.     }
  725.  
  726. }
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!