API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 15.15 KB | None | 0 0
raw download clone embed print report
  1. <?PHP
  2. //$shopoffers = $SQL->query('SELECT owner, lastwarning, id FROM houses WHERE world_id = 0');
  3. //foreach($shopoffers as $shop) {
  4. //  $SQL->query('UPDATE houses SET owner='.$shop['owner'].', lastwarning='.$shop['lastwarning'].' WHERE world_id = 1 AND id='.$shop['id'].'');
  5. //}
  6. if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
  7.     $type = $_REQUEST['offer_type'];
  8.     if(empty($action) && empty($type)) {
  9.         $main_content .= '<br><h2><center><a href="?subtopic=shopadmin&action=addoffer&offer_type=item">ADD SHOP OFFER</a><br><br><a href="?subtopic=shopadmin&action=viewoffer">
  10.                 VIEW SHOP OFFER <i>(EDIT/DELETE)</i></a><br><br><a href="?subtopic=shopadmin&action=points">ADD POINTS</a></center>';
  11.     }
  12.     if($action == "addoffer"){
  13.         if($shop_points = (int)$_POST['shop_points']) {
  14.             $shop_itemid1 = $type == 'package' ? $_POST['shop_itemid1'] : (int)$_POST['shop_itemid1'];
  15.             $shop_count1 = $type == 'package' ? $_POST['shop_count1'] : (int)$_POST['shop_count1'];
  16.             $shop_itemid2 = (int)$_POST['shop_itemid2'];
  17.             $shop_count2 = (int)$_POST['shop_count2'];
  18.            
  19.             $group = (int)$_POST['group'];
  20.             $shop_offer_description = $_POST['shop_offer_description'];
  21.             $shop_offer_name = $_POST['shop_offer_name'];
  22.             $SQL->query('INSERT INTO `z_shop_offer` (id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name'.($type == 'item' ? ', `group`' : '').') VALUES (NULL, '.quote($shop_points).', '.quote($shop_itemid1).', '.quote($shop_count1).', '.quote($shop_itemid2).', '.quote($shop_count2).', '.quote($type).', '.quote($shop_offer_description).', '.quote($shop_offer_name).($type == 'item' ? ', '.quote($group) : '').')');
  23.             $main_content .= '<center><h2><font color="red">Added to Shop:</font></h2></center><hr/>
  24.                 <tr><td align="center" ><b>Points:</b></td>
  25.                 <td>'.$shop_points.'</td></tr><br>';
  26.             if($type == 'container'){
  27.                 $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
  28.                     <td>'.$shop_itemid1.'</td></tr><br>
  29.                     <tr><td align="center" ><b>Count Container:</b></td>
  30.                     <td>'.$shop_count1.'</td></tr><br>
  31.                     <tr><td align="center" ><b> Item ID (in Container):</b></td>
  32.                     <td>'.$shop_itemid2.'</td></tr><br>
  33.                     <tr><td align="center" ><b>Count Item (in Container):</b></td>
  34.                     <td>'.$shop_count2.'</td></tr><br>';
  35.             }
  36.             if ($type == 'item' || $type == 'package'){
  37.                 $main_content .= '<tr><td align="center" ><b>Item ID:</b></td>
  38.                     <td>'.$shop_itemid1.'</td></tr><br>
  39.                     <tr><td align="center" ><b>Count Item:</b></td>
  40.                     <td>'.$shop_count1.'</td></tr><br>';
  41.                 if($type == 'item') {
  42.                     $main_content .= '
  43.                     <tr><td align="center" ><b>Group:</b></td>
  44.                     <td>'.$group.'</td></tr>';
  45.                 }
  46.                 $main_content .= '<br>';
  47.             }
  48.             if ($type == 'pacc'){
  49.                 $main_content .= '<tr><td align="center" ><b>Days:</b></td>
  50.                     <td>'.$shop_count1.'</td></tr><br>';
  51.             }
  52.             $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
  53.                 <td>'.$type.'</td></tr><br>
  54.                 <tr><td align="center" ><b>Offer Description:</b></td>
  55.                 <td>'.$shop_offer_description.'</td></tr><br>
  56.                 <tr><td align="center" ><b>Offer Name:</b></td>
  57.                 <td>'.$shop_offer_name.'</td></tr>
  58.                 <br>';
  59.         }
  60.             $main_content .= '
  61. <table border="0">
  62.     <tr>
  63.         <td align="center"><b>Select offer type:</b></td>
  64.         <td>
  65.             <table border="0" >
  66.                 <tr bgcolor="#505050">
  67.                     <td><font color="white">Item</td>
  68.                     <td><font color="white">Package</td>
  69.                     <td><font color="white">Container</td>
  70.                     <td><font color="white">Pacc</td>
  71.                     <td><font color="white">Redskull</td>
  72.                     <td><font color="white">Unban</td>
  73.                     <td><font color="white">Changename</td>
  74.                 </tr>
  75.                 <tr bgcolor="#D4C0A1">
  76.                     <form action="" method="post">';
  77.             foreach(array('item','package','container','pacc','redskull','unban','changename') as $v) {
  78.                 $main_content .= '<td align="center"><input type="radio" name="offer_type" value="'.$v.'"'.($type === $v ? ' checked="checked"' : '').' onclick="this.form.submit()"></td>';
  79.             }
  80. $main_content .= '
  81.                     </form>
  82.                 </tr>
  83.             </table>
  84.         </td>
  85.     </tr>
  86.     <form action="?subtopic=shopadmin&action=addoffer&offer_type='.$type.'" method="post" >
  87.         <table border="0">
  88.             <tr>
  89.                 <td align="center" ><b>Points:</b></td>
  90.                 <td><input type="textbox" name="shop_points" maxlength="7" style="width: 70px"></td>
  91.             </tr>';
  92.             if($type == 'container'){
  93.                 $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
  94.                     <td><input type="text" name="shop_itemid1" maxlength="7" style="width: 70px" ></td></tr>
  95.                     <tr><td align="center" ><b>Count Container:</b></td>
  96.                     <td><input type="text" name="shop_count1" maxlength="7" style="width: 70px" ></td></tr>
  97.                     <tr><td align="center" ><b>Item ID:</b></td>
  98.                     <td><input type="text" name="shop_itemid2" maxlength="7" style="width: 70px" ></td></tr>
  99.                     <tr><td align="center" ><b>Count Item:</b></td>
  100.                     <td><input type="text" name="shop_count2" maxlength="7" style="width: 70px" ></td></tr>';
  101.             }
  102.             if($type == 'item' || $type == 'package'){
  103.                 $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
  104.                     <td><input type="text" name="shop_itemid1" maxlength="64" style="width: 70px" ></td></tr>
  105.                     <tr><td align="center"><b>Item Count:</b></td>
  106.                     <td><input type="text" name="shop_count1" maxlength="32" style="width: 70px" ></td></tr>';
  107.                 if($type === 'item') {
  108.                     $main_content .= '<tr><td align="center"><b>Group:</b></td>
  109.                     <td>
  110.                         <select name="group">
  111.                             <option value="0">Weapons</option>
  112.                             <option value="1">Equipment</option>
  113.                             <option value="2">Tools</option>
  114.                         </select>
  115.                     </td></tr>';
  116.                 }
  117.             }
  118.             if($type == 'pacc'){
  119.                 $main_content .= '<tr><td align="center" ><b>Days:</b></td>
  120.                     <td><input type="text" name="shop_count1" maxlength="7" style="width: 70px" ></td></tr>';
  121.             }
  122.             $main_content .= '<tr><td align="center" ><b>Offer Description:</b></td>
  123.                 <td ><textarea name="shop_offer_description" rows="2" cols="35"></textarea></td></tr>
  124.                 <tr><td align="center" ><b>Offer Name:</b></td>
  125.                 <td><input type="text" name="shop_offer_name" maxlength="40" style="width: 200px" ></td></tr></table>
  126.                 <input name="submit" type="submit" value="Submit" /></form>
  127.                 <form action="?subtopic=shopadmin&action=addoffer" method="post" >
  128.                 <input name="submit" type="submit" value="Reset" /></form>';
  129.             $main_content .= '<form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
  130.     }
  131.     if($action == "viewoffer") {
  132.         $order = array("id" => "id", "points" => "points", "offer_type" => "offer_type", "itemid1" => "itemid1", "itemid2" => "itemid2");
  133.         $main_content .= '<center><table width="100%"><tr BGCOLOR="#505050"><td width="5"><font color="white"><a href="?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'id') . '" class=white>ID:</td><td width="5"><font color="white"><a href="?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'points') . '" class=white>Points:</td><td width="7">
  134.             <font color="white"><a href="?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'itemid1') . '" class=white>Item ID:</td><td width="5"><font color="white">Count:</td><td width="7"><center><font color="white"><a href="?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'itemid2') . '" class=white>Container ID:</center></td><td width="5"><font color="white">Count:</td><td width="7"><font color="white"><a href="?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'offer_type') . '" class=white>Offer Type:</td>
  135.             <td width="85"><font color="white">Offer Description:</td><td width="30"><font color="white">Offer Name:</td><td width="30">&nbsp;</td></tr>';
  136.         $shopoffers = $SQL->query('SELECT id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name FROM z_shop_offer ' . makeOrder($order, 'order', 'id'));
  137.         foreach($shopoffers as $shop) {
  138.             $main_content .= '</B><tr BGCOLOR="#D4C0A1"><td align="center">'.$shop['id'].'<td align="center">'.$shop['points'].'</td>';
  139.             if($shop['itemid1'] == "0") {
  140.                 $main_content .= '<td align="center">'.$shop['itemid1'].'<br></td>';
  141.             } else {
  142.                 $main_content .= '<td align="center">'.$shop['itemid1'].'</td>';
  143.             }
  144.             $main_content .= '<td align="center">'.$shop['count1'].'</td>';
  145.             if($shop['itemid2'] == "0") {
  146.                 $main_content .= '<td align="center">'.$shop['itemid2'].'</td>';
  147.             } else {
  148.                 $main_content .= '<td align="center">'.$shop['itemid2'].'</td>';
  149.             }
  150.             $main_content .= '<td align="center">'.$shop['count2'].'</td><td align="center">'.$shop['offer_type'].'</td><td align="left">'.$shop['offer_description'].'</td><td align="left">'.$shop['offer_name'].'</td>';
  151.             $main_content .= '<td align="center"><a href="?subtopic=shopadmin&action=editoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/edit_news.png" border="0"></a><br><br><a href="?subtopic=shopadmin&action=deleteoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/delete_news.png" border="0"></a></td>';
  152.         }
  153.         $main_content .= '</td></tr></table><br><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
  154.     }
  155.     if($action == "deleteoffer") {
  156.         $id = (int) $_REQUEST['id'];
  157.         $SQL->query('DELETE FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
  158.         $main_content .= '<center>Shop offer has been deleted.</center><br><center><form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form></center>';
  159.     }
  160.     if($action == "editoffer") {
  161.         $id = (int) $_REQUEST['id'];
  162.         $q = $SQL->query('SELECT * FROM z_shop_offer WHERE id = '.$id)->fetch();
  163.         $main_content .= '<form action="?subtopic=shopadmin&action=edited&id='.$id.'" method="post" ><table border="0"><tr><td align="center" ><b>Points:</b></td>
  164.             <td><input type="textbox" name="shop_points" maxlength="5" value="'.$q['points'].'" style="width: 70px"></td></tr>';
  165.         if($q['offer_type'] == 'container'){
  166.             $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
  167.                 <td><input type="text" name="shop_itemid1" maxlength="5" value="'.$q['itemid1'].'" style="width: 70px" ></td></tr>
  168.                 <tr><td align="center" ><b>Count Container:</b></td>
  169.                 <td><input type="text" name="shop_count1" maxlength="4" value="'.$q['count1'].'" style="width: 70px" ></td></tr>
  170.                 <tr><td align="center" ><b>Item ID:</b></td>
  171.                 <td><input type="text" name="shop_itemid2" maxlength="5" value="'.$q['itemid2'].'" style="width: 70px" ></td></tr>
  172.                 <tr><td align="center" ><b>Count Item:</b></td>
  173.                 <td><input type="text" name="shop_count2" maxlength="4" value="'.$q['count2'].'" style="width: 70px" ></td></tr>';
  174.         }
  175.         if($q['offer_type'] == 'item' || $q['offer_type'] == 'package'){
  176.             $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
  177.                 <td><input type="text" name="shop_itemid1" maxlength="'.($q['offer_type'] == 'package' ? '64' : '5').'" value="'.$q['itemid1'].'" style="width: '.($q['offer_type'] == 'package' ? '300' : '70').'px" ></td></tr>
  178.                 <tr><td align="center"><b>Item Count:</b></td>
  179.                 <td><input type="text" name="shop_count1" maxlength="'.($q['offer_type'] == 'package' ? '32' : '4').'" value="'.$q['count1'].'" style="width: '.($q['offer_type'] == 'package' ? '150' : '70').'px" ></td></tr>';
  180.             if($q['offer_type'] == 'item') {
  181.                 $q['group'] = (int)$q['group'];
  182.                 $main_content .= '
  183.                     <tr><td align="center"><b>Group:</b></td>
  184.                     <td><select name="group">';
  185.                         foreach(array(0 => 'Weapons', 1 => 'Equipment', 2 => 'Tools') as $k => $v)
  186.                             $main_content .= '<option value="'.$k.'"'.($k === $q['group'] ? ' selected="selected"' : '').'>'.$v.'</option>';
  187.                         $main_content .= '</select></td></tr>';
  188.             }
  189.         }
  190.         if($q['offer_type'] == 'pacc'){
  191.             $main_content .= '<tr><td align="center" ><b>Days:</b></td>
  192.                 <td><input type="text" name="shop_count1" maxlength="7" style="width: 70px" ></td></tr>';
  193.         }
  194.         $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
  195.             <td><input type="text" name="type" value="'.$q['offer_type'].'" maxlength="40" style="width: 200px" ></td></tr>
  196.             <tr><td align="center" ><b>Offer Description:</b></td>
  197.             <td ><textarea name="shop_offer_description" rows="2" cols="35">'.$q['offer_description'].'</textarea></td></tr>
  198.             <tr><td align="center" ><b>Offer Name:</b></td>
  199.             <td><input type="text" name="shop_offer_name" value="'.$q['offer_name'].'" maxlength="40" style="width: 200px" ></td></tr>
  200.             <tr><td><input name="submit" type="submit" value="Submit" /></form></td><td></td></tr></table>';
  201.         $main_content .= '<form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
  202.     }
  203.     if($action == "edited") {
  204.         $id = (int) $_REQUEST['id'];
  205.         $shop_points = (int) $_POST['shop_points'];
  206.         $type = $_POST['type'];
  207.         $shop_itemid1 = $type == 'package' ? $_POST['shop_itemid1'] : (int)$_POST['shop_itemid1'];
  208.         $shop_count1 = $type == 'package' ? $_POST['shop_count1'] : (int)$_POST['shop_count1'];
  209.         $shop_itemid2 = (int) $_POST['shop_itemid2'];
  210.         $shop_count2 = (int) $_POST['shop_count2'];
  211.         $shop_offer_description = $_POST['shop_offer_description'];
  212.         $shop_offer_name = $_POST['shop_offer_name'];
  213.         $group = (int) $_POST['group'];
  214.         $SQL->query('UPDATE `z_shop_offer` SET `points` = '.$shop_points.', `itemid1` = '.quote($shop_itemid1).', `count1` = '.quote($shop_count1).', `itemid2` = '.quote($shop_itemid2).', `count2` = '.quote($shop_count2).', `offer_type` = '.quote($type).', `offer_description` = '.quote($shop_offer_description).', `offer_name` = '.quote($shop_offer_name).($type == 'item' ? ', `group` = '.quote($group) : '').' WHERE `id` = '.$id);
  215.         $main_content = '<b><center>Shop offer successfully edited.</b><br><br><form action="?subtopic=shopadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form><meta http-equiv="refresh" content="1;url=/?subtopic=shopadmin&action=viewoffer" />';
  216.     }
  217.     if($action == "points") {
  218.         $player = trim($_POST['character']);
  219.         if(empty($player)) {
  220.             $main_content .= '<form action="" method="post"><B>Enter Character Name:</B><input type="textbox" name="character"><br>
  221.                 <B>Enter Points Amount:</B><input type="textbox" name="points"><br><br><input type="submit" value="Submit">
  222.                 </form></center><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
  223.         } else {
  224.             $points = (int) $_POST['points'];
  225.             if($player_data = $SQL->query("SELECT account_id FROM `players` WHERE `name` = ".quote($player).";")->fetch()) {
  226.                 $SQL->query("UPDATE `accounts` SET `premium_points` = `premium_points` + ".$points." WHERE `id` = '".$player_data['account_id']."'");
  227.                 $main_content .= '<b><center>'.$points.' Premium Points added to the account of <i>'.$player.'</i> !</b></center><br>';    
  228.             }
  229.             else {
  230.                 $main_content .= 'Player doesn\'t exist!';
  231.             }
  232.             $main_content .= '<form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
  233.         }
  234.     }
  235. } else {
  236.     $main_content .= 'Sorry, you have not the rights to access this page.';
  237. }
  238. ?>
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!