• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Gesior, ShopGuildAdmin error Could not load items!

Eduardo170

Eduardo170

Well-Known Member
Joined
Jan 7, 2014
Messages
422
Solutions
3
Reaction score
66
Location
Caracas, Venezuela
Hello otland comunity, anyone help me with this script of Gesior edit by @Natan Beckman

Code: 
Warning: simplexml_load_file(): I/O warning : failed to load external entity "data/items/items.xml" in C:\xampp\htdocs\pages\shopguildadmin.php on line 95
Could not load items!

line 95
Code: 
$items = simplexml_load_file($config['site']['server_path'].'data\items\items.xml') or die('<b>Could not load items!</b>');



Code: 
<?PHP
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
        $offertype = $_REQUEST['offer_type'];
        if((empty($action)) AND (empty($offertype))) {
                 $main_content .= '<br><h2><center><a href="?subtopic=shopguildadmin&action=addoffer">ADD SHOP OFFER</a><br><br><a href="?subtopic=shopguildadmin&action=viewoffer">
                              VIEW SHOP OFFER <i>(EDIT/DELETE)</i></a><br><br><a href="?subtopic=shopguildadmin&action=points">ADD POINTS</a></center>';
        }
        if($action == "addoffer"){
                $shop_points = stripslashes(ucwords(strtolower(trim($_REQUEST['shop_points']))));
                $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
                if(empty($shop_points)) {
                        $main_content .= '<table border="0"><tr><td  align="center"><b>Select offer type:</b></td><td><table border="0" ><tr bgcolor="#505050">
                              <td><font color="white">Item</td><td><font color="white">Container</td><td><font color="white">VipDays</td><td><font color="white">Redskull</td>
                              <td><font color="white">Unban</td><td><font color="white">Changename</td></tr><tr bgcolor="#D4C0A1"><form action="" method="post">
                              <td align="center"><input type="radio" name="offer_type" value="item" onClick="this.form.submit()"></td></lable>
                              <td align="center"><input type="radio" name="offer_type" value="container" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="vipdays" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="redskull" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="unban" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="changename" onClick="this.form.submit()"></td>
                              </form></tr></table></td></tr>';
                        $main_content .= '<form action="?subtopic=shopguildadmin&action=addoffer&offer_type='.$shop_offer_type.'" method="post" ><table border="0"><tr>
                              <td align="center" ><b>Points:</b></td><td><input type="textbox" name="shop_points" maxlenght="7" style="width: 70px"></td></tr>';
                        if($_REQUEST['offer_type'] == 'container'){
                                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Container:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid2" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Item:</b></td>
                                      <td><input type="text" name="shop_count2" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        if($_REQUEST['offer_type'] == 'item'){
                                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center"><b>Item Count:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        if($_REQUEST['offer_type'] == 'vipdays'){
                                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        $main_content .= '<tr><td align="center" ><b>Offer Description:</b></td>
                              <td ><textarea name="shop_offer_description" rows="2" cols="35"></textarea></td></tr>
                              <tr><td align="center" ><b>Offer Name:</b></td>
                              <td><input type="text" name="shop_offer_name" maxlenght="40" style="width: 200px" ></td></tr></table>
                              <input name="submit" type="submit" value="Submit" /></form>
                              <form action="?subtopic=shopguildadmin&action=addoffer" method="post" >
                              <input name="submit" type="submit" value="Reset" /></form>';
                        $main_content .= '<form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                } else {
                        $shop_points = stripslashes(trim($_POST['shop_points']));
                        $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
                        $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
                        $shop_count1 = stripslashes(trim($_POST['shop_count1']));
                        $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
                        $shop_count2 = stripslashes(trim($_POST['shop_count2']));
                        $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
                        $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
                        $SQL->query('INSERT INTO `z_shopguild_offer` (id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid) VALUES (NULL, '.$SQL->quote($shop_points).', '.$SQL->quote($shop_itemid1).', '.$SQL->quote($shop_count1).', '.$SQL->quote($shop_itemid2).', '.$SQL->quote($shop_count2).', '.$SQL->quote($shop_offer_type).', '.$SQL->quote($shop_offer_description).', '.$SQL->quote($shop_offer_name).', 0)');
                        $main_content .= '<center><h2><font color="red">Added to Shop:</font></h2></center><hr/>
                              <tr><td align="center" ><b>Points:</b></td>
                              <td>'.$shop_points.'</td></tr><br>';
                        if($shop_offer_type == 'container'){
                                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                                      <td>'.$shop_itemid1.'</td></tr><br>
                                      <tr><td align="center" ><b>Count Container:</b></td>
                                      <td>'.$shop_count1.'</td></tr><br>
                                      <tr><td align="center" ><b> Item ID (in Container):</b></td>
                                      <td>'.$shop_itemid2.'</td></tr><br>
                                      <tr><td align="center" ><b>Count Item (in Container):</b></td>
                                      <td>'.$shop_count2.'</td></tr><br>';
                        }
                        if ($shop_offer_type == 'item'){
                                $main_content .= '<tr><td align="center" ><b>Item ID:</b></td>
                                      <td>'.$shop_itemid1.'</td></tr><br>
                                      <tr><td align="center" ><b>Count Item:</b></td>
                                      <td>'.$shop_count1.'</td></tr><br>';
                        }
                        if ($shop_offer_type == 'vipdays'){
                                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                                      <td>'.$shop_count1.'</td></tr><br>';
                        }
                        $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
                              <td>'.$shop_offer_type.'</td></tr><br>
                              <tr><td align="center" ><b>Offer Description:</b></td>
                              <td>'.$shop_offer_description.'</td></tr><br>
                              <tr><td align="center" ><b>Offer Name:</b></td>
                              <td>'.$shop_offer_name.'</td></tr>
                              <br><form action="?subtopic=shopguildadmin&action=addoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                }
        }
        if($action == "viewoffer") {
                $items = simplexml_load_file($config['site']['server_path'].'data\items\items.xml') or die('<b>Could not load items!</b>');
                foreach($items->item as $v)
                        $itemList[(int)$v['id']] = $v['name'];
                $order = array("id" => "id", "points" => "points", "offer_type" => "offer_type", "itemid1" => "itemid1", "itemid2" => "itemid2");
                $main_content .= '<center><table width="550"><tr BGCOLOR="#505050"><td width="5"><font color="white"><a href="index.php?subtopic=shopguildadmin&action=viewoffer&order=' . getOrder($order, 'order', 'id') . '" class=white>ID:</td><td width="5"><font color="white"><a href="index.php?subtopic=shopguildadmin&action=viewoffer&order=' . getOrder($order, 'order', 'points') . '" class=white>Points:</td><td width="7">
                      <font color="white"><a href="index.php?subtopic=shopguildadmin&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="index.php?subtopic=shopguildadmin&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="index.php?subtopic=shopguildadmin&action=viewoffer&order=' . getOrder($order, 'order', 'offer_type') . '" class=white>Offer Type:</td>
                      <td width="85"><font color="white">Offer Description:</td><td width="30"><font color="white">Offer Name:</td><td width="30"></td></tr>';
                $shopoffers = $SQL->query('SELECT id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid FROM z_shopguild_offer ' . makeOrder($order, 'order', 'id'));
                foreach($shopoffers as $shop) {
                        $main_content .= '</B><tr BGCOLOR="#D4C0A1"><td align="center">'.$shop['id'].'<td align="center">'.$shop['points'].'</td>';
                        if($shop['itemid1'] == "0") {
                                $main_content .= '<td align="center">'.$shop['itemid1'].'<br></td>';
                        } else {
                                $main_content .= '<td align="center">'.$shop['itemid1'].'<br>(' . $itemList[(int)$shop['itemid1']] . ')</td>';
                        }
                        $main_content .= '<td align="center">'.$shop['count1'].'</td>';
                        if($shop['itemid2'] == "0") {
                                $main_content .= '<td align="center">'.$shop['itemid2'].'</td>';
                        } else {
                                $main_content .= '<td align="center">'.$shop['itemid2'].'<br>(' . $itemList[(int)$shop['itemid2']] . ')</td>';
                        }
                        $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>';
                        $main_content .= '<td align="center"><a href="?subtopic=shopguildadmin&action=editoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/edit_news.png" border="0"></a><br><br><a href="?subtopic=shopguildadmin&action=deleteoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/delete_news.png" border="0"></a></td>';
                }
                $main_content .= '</td></tr></TABLE><br><form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        }
        if($action == "deleteoffer") {
                $id = (int) $_REQUEST['id'];
                $SQL->query('DELETE FROM z_shopguild_offer WHERE id = '.$id.' LIMIT 1;');
                $main_content .= '<center>Shop offer has been deleted.</center><br><center><form action="?subtopic=shopguildadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form></center>';
        }
        if($action == "editoffer") {
                $id = (int) $_REQUEST['id'];
                $shopoffers = $SQL->query('SELECT * FROM z_shopguild_offer WHERE id = '.$id.' LIMIT 1;');
                foreach($shopoffers as $shop) {
                        $main_content .= '<form action="?subtopic=shopguildadmin&action=edited&id='.$id.'" method="post" ><table border="0"><tr><td align="center" ><b>Points:</b></td>
                              <td><input type="textbox" name="shop_points" maxlenght="7" value="'.$shop['points'].'" style="width: 70px"></td></tr>';
                        if($shop['offer_type'] == 'container'){
                                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Container:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid2" maxlenght="7" value="'.$shop['itemid2'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Item:</b></td>
                                      <td><input type="text" name="shop_count2" maxlenght="7" value="'.$shop['count2'].'" style="width: 70px" ></td></tr>';
                        }
                        if($shop['offer_type'] == 'item'){
                                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center"><b>Item Count:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>';
                        }
                        if($shop['offer_type'] == 'vipdays'){
                                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
                              <td><input type="text" name="shop_offer_type" value="'.$shop['offer_type'].'" maxlenght="40" style="width: 200px" ></td></tr>
                              <tr><td align="center" ><b>Offer Description:</b></td>
                              <td ><textarea name="shop_offer_description" rows="2" cols="35">'.$shop['offer_description'].'</textarea></td></tr>
                              <tr><td align="center" ><b>Offer Name:</b></td>
                              <td><input type="text" name="shop_offer_name" value="'.$shop['offer_name'].'" maxlenght="40" style="width: 200px" ></td></tr>
                              <tr><td><input name="submit" type="submit" value="Submit" /></form></td><td></td></tr></table>';
                        $main_content .= '<form action="?subtopic=shopguildadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                }
        }
        if($action == "edited") {
                $id = (int) $_REQUEST['id'];
                $shop_points = stripslashes(trim($_POST['shop_points']));
                $shop_offer_type = stripslashes(trim($_POST['shop_offer_type']));
                $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
                $shop_count1 = stripslashes(trim($_POST['shop_count1']));
                $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
                $shop_count2 = stripslashes(trim($_POST['shop_count2']));
                $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
                $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
                $SQL->query('UPDATE `z_shopguild_offer` SET `points` = '.$shop_points.', `itemid1` = '.$SQL->quote($shop_itemid1).', `count1` = '.$SQL->quote($shop_count1).', `itemid2` = '.$SQL->quote($shop_itemid2).', `count2` = '.$SQL->quote($shop_count2).', `offer_type` = '.$SQL->quote($shop_offer_type).', `offer_description` = '.$SQL->quote($shop_offer_description).', `offer_name` = '.$SQL->quote($shop_offer_name).' WHERE `id` = '.$id.';');
                $main_content .= '<b><center>Shop offer successfully edited.</b><br><br><form action="?subtopic=shopguildadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form><meta http-equiv="refresh" content="1;url=/?subtopic=shopguildadmin&action=viewoffer" />';
        }
        if($action == "points") {
                $player = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
                $points = (int) $_POST['points'];
                if(empty($player)) {
                        $main_content .= '<form action="" method="post"><B>Enter Character Name:</B><input type="textbox" name="character"><br>
                              <B>Enter Points Amount:</B><input type="textbox" name="points"><br><br><input type="submit" value="Submit">
                              </form></center><form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                } else {
                        $player_data = $SQL->query("SELECT * FROM `players` WHERE `name` = '".$player."';")->fetch();
                        $SQL->query("UPDATE `accounts` SET `guild_points` = `guild_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");
                        $main_content .= '<b><center>'.$points.' Premium Points added to the account of <i>'.$player.'</i> !</b></center><br>
                              <form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                }
        }
} else {
        $main_content .= 'Sorry, you have not the rights to access this page.';
}
?>
 
Sort by date Sort by votes
Wrong path in the variable server_path?
Read the errors and you already found the code, so why not read the code while you are at it?

In this case is tries to find items.xml via server_path, so a good "debug" procedure would be to print these values out, to see where the direction is heading.
You might have an error in the script aswell, but most likely your variable server_path is wrong, switched servers lately? :p
 
Upvote 0 Downvote
WibbenZ said:
Wrong path in the variable server_path?
Read the errors and you already found the code, so why not read the code while you are at it?

In this case is tries to find items.xml via server_path, so a good "debug" procedure would be to print these values out, to see where the direction is heading.
You might have an error in the script aswell, but most likely your variable server_path is wrong, switched servers lately? :p
Click to expand...
It is this script, my gesior works, only that when giving the option VIEW SHOP OFFER <i> (EDIT / DELETE) sends me this error but the other options if they work.


I Deleted that option for the moments while they help me to find solution.
 
Upvote 0 Downvote
Eduardo170 said:
It is this script, my gesior works, only that when giving the option VIEW SHOP OFFER <i> (EDIT / DELETE) sends me this error but the other options if they work.


I Deleted that option for the moments while they help me to find solution.
Click to expand...

Code: 
<?PHP
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
        $offertype = $_REQUEST['offer_type'];
        if((empty($action)) AND (empty($offertype))) {
                 $main_content .= '<br><h2><center><a href="?subtopic=shopguildadmin&action=addoffer">ADD SHOP OFFER</a><br><br><a href="?subtopic=shopguildadmin&action=viewoffer">
                              VIEW SHOP OFFER <i>(EDIT/DELETE)</i></a><br><br><a href="?subtopic=shopguildadmin&action=points">ADD POINTS</a></center>';
        }
        if($action == "addoffer"){
                $shop_points = stripslashes(ucwords(strtolower(trim($_REQUEST['shop_points']))));
                $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
                if(empty($shop_points)) {
                        $main_content .= '<table border="0"><tr><td  align="center"><b>Select offer type:</b></td><td><table border="0" ><tr bgcolor="#505050">
                              <td><font color="white">Item</td><td><font color="white">Container</td><td><font color="white">VipDays</td><td><font color="white">Redskull</td>
                              <td><font color="white">Unban</td><td><font color="white">Changename</td></tr><tr bgcolor="#D4C0A1"><form action="" method="post">
                              <td align="center"><input type="radio" name="offer_type" value="item" onClick="this.form.submit()"></td></lable>
                              <td align="center"><input type="radio" name="offer_type" value="container" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="vipdays" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="redskull" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="unban" onClick="this.form.submit()"></td>
                              <td align="center"><input type="radio" name="offer_type" value="changename" onClick="this.form.submit()"></td>
                              </form></tr></table></td></tr>';
                        $main_content .= '<form action="?subtopic=shopguildadmin&action=addoffer&offer_type='.$shop_offer_type.'" method="post" ><table border="0"><tr>
                              <td align="center" ><b>Points:</b></td><td><input type="textbox" name="shop_points" maxlenght="7" style="width: 70px"></td></tr>';
                        if($_REQUEST['offer_type'] == 'container'){
                                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Container:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid2" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Item:</b></td>
                                      <td><input type="text" name="shop_count2" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        if($_REQUEST['offer_type'] == 'item'){
                                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" style="width: 70px" ></td></tr>
                                      <tr><td align="center"><b>Item Count:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        if($_REQUEST['offer_type'] == 'vipdays'){
                                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        $main_content .= '<tr><td align="center" ><b>Offer Description:</b></td>
                              <td ><textarea name="shop_offer_description" rows="2" cols="35"></textarea></td></tr>
                              <tr><td align="center" ><b>Offer Name:</b></td>
                              <td><input type="text" name="shop_offer_name" maxlenght="40" style="width: 200px" ></td></tr></table>
                              <input name="submit" type="submit" value="Submit" /></form>
                              <form action="?subtopic=shopguildadmin&action=addoffer" method="post" >
                              <input name="submit" type="submit" value="Reset" /></form>';
                        $main_content .= '<form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                } else {
                        $shop_points = stripslashes(trim($_POST['shop_points']));
                        $shop_offer_type = stripslashes(trim($_REQUEST['offer_type']));
                        $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
                        $shop_count1 = stripslashes(trim($_POST['shop_count1']));
                        $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
                        $shop_count2 = stripslashes(trim($_POST['shop_count2']));
                        $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
                        $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
                        $SQL->query('INSERT INTO `z_shopguild_offer` (id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid) VALUES (NULL, '.$SQL->quote($shop_points).', '.$SQL->quote($shop_itemid1).', '.$SQL->quote($shop_count1).', '.$SQL->quote($shop_itemid2).', '.$SQL->quote($shop_count2).', '.$SQL->quote($shop_offer_type).', '.$SQL->quote($shop_offer_description).', '.$SQL->quote($shop_offer_name).', 0)');
                        $main_content .= '<center><h2><font color="red">Added to Shop:</font></h2></center><hr/>
                              <tr><td align="center" ><b>Points:</b></td>
                              <td>'.$shop_points.'</td></tr><br>';
                        if($shop_offer_type == 'container'){
                                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                                      <td>'.$shop_itemid1.'</td></tr><br>
                                      <tr><td align="center" ><b>Count Container:</b></td>
                                      <td>'.$shop_count1.'</td></tr><br>
                                      <tr><td align="center" ><b> Item ID (in Container):</b></td>
                                      <td>'.$shop_itemid2.'</td></tr><br>
                                      <tr><td align="center" ><b>Count Item (in Container):</b></td>
                                      <td>'.$shop_count2.'</td></tr><br>';
                        }
                        if ($shop_offer_type == 'item'){
                                $main_content .= '<tr><td align="center" ><b>Item ID:</b></td>
                                      <td>'.$shop_itemid1.'</td></tr><br>
                                      <tr><td align="center" ><b>Count Item:</b></td>
                                      <td>'.$shop_count1.'</td></tr><br>';
                        }
                        if ($shop_offer_type == 'vipdays'){
                                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                                      <td>'.$shop_count1.'</td></tr><br>';
                        }
                        $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
                              <td>'.$shop_offer_type.'</td></tr><br>
                              <tr><td align="center" ><b>Offer Description:</b></td>
                              <td>'.$shop_offer_description.'</td></tr><br>
                              <tr><td align="center" ><b>Offer Name:</b></td>
                              <td>'.$shop_offer_name.'</td></tr>
                              <br><form action="?subtopic=shopguildadmin&action=addoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                }
        }
        if($action == "viewoffer") {
                $items = simplexml_load_file($config['site']['server_path'].'data\items\items.xml') or die('<b>Could not load items!</b>' . $config['site']['server_path'].'data\items\items.xml');
                foreach($items->item as $v)
                        $itemList[(int)$v['id']] = $v['name'];
                $order = array("id" => "id", "points" => "points", "offer_type" => "offer_type", "itemid1" => "itemid1", "itemid2" => "itemid2");
                $main_content .= '<center><table width="550"><tr BGCOLOR="#505050"><td width="5"><font color="white"><a href="index.php?subtopic=shopguildadmin&action=viewoffer&order=' . getOrder($order, 'order', 'id') . '" class=white>ID:</td><td width="5"><font color="white"><a href="index.php?subtopic=shopguildadmin&action=viewoffer&order=' . getOrder($order, 'order', 'points') . '" class=white>Points:</td><td width="7">
                      <font color="white"><a href="index.php?subtopic=shopguildadmin&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="index.php?subtopic=shopguildadmin&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="index.php?subtopic=shopguildadmin&action=viewoffer&order=' . getOrder($order, 'order', 'offer_type') . '" class=white>Offer Type:</td>
                      <td width="85"><font color="white">Offer Description:</td><td width="30"><font color="white">Offer Name:</td><td width="30"></td></tr>';
                $shopoffers = $SQL->query('SELECT id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name, pid FROM z_shopguild_offer ' . makeOrder($order, 'order', 'id'));
                foreach($shopoffers as $shop) {
                        $main_content .= '</B><tr BGCOLOR="#D4C0A1"><td align="center">'.$shop['id'].'<td align="center">'.$shop['points'].'</td>';
                        if($shop['itemid1'] == "0") {
                                $main_content .= '<td align="center">'.$shop['itemid1'].'<br></td>';
                        } else {
                                $main_content .= '<td align="center">'.$shop['itemid1'].'<br>(' . $itemList[(int)$shop['itemid1']] . ')</td>';
                        }
                        $main_content .= '<td align="center">'.$shop['count1'].'</td>';
                        if($shop['itemid2'] == "0") {
                                $main_content .= '<td align="center">'.$shop['itemid2'].'</td>';
                        } else {
                                $main_content .= '<td align="center">'.$shop['itemid2'].'<br>(' . $itemList[(int)$shop['itemid2']] . ')</td>';
                        }
                        $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>';
                        $main_content .= '<td align="center"><a href="?subtopic=shopguildadmin&action=editoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/edit_news.png" border="0"></a><br><br><a href="?subtopic=shopguildadmin&action=deleteoffer&id='.$shop['id'].'"><img src="'.$layout_name.'/images/news/delete_news.png" border="0"></a></td>';
                }
                $main_content .= '</td></tr></TABLE><br><form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
        }
        if($action == "deleteoffer") {
                $id = (int) $_REQUEST['id'];
                $SQL->query('DELETE FROM z_shopguild_offer WHERE id = '.$id.' LIMIT 1;');
                $main_content .= '<center>Shop offer has been deleted.</center><br><center><form action="?subtopic=shopguildadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form></center>';
        }
        if($action == "editoffer") {
                $id = (int) $_REQUEST['id'];
                $shopoffers = $SQL->query('SELECT * FROM z_shopguild_offer WHERE id = '.$id.' LIMIT 1;');
                foreach($shopoffers as $shop) {
                        $main_content .= '<form action="?subtopic=shopguildadmin&action=edited&id='.$id.'" method="post" ><table border="0"><tr><td align="center" ><b>Points:</b></td>
                              <td><input type="textbox" name="shop_points" maxlenght="7" value="'.$shop['points'].'" style="width: 70px"></td></tr>';
                        if($shop['offer_type'] == 'container'){
                                $main_content .= '<tr><td align="center" ><b>Container ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Container:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid2" maxlenght="7" value="'.$shop['itemid2'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center" ><b>Count Item:</b></td>
                                      <td><input type="text" name="shop_count2" maxlenght="7" value="'.$shop['count2'].'" style="width: 70px" ></td></tr>';
                        }
                        if($shop['offer_type'] == 'item'){
                                $main_content .= '<tr><td align="center"><b>Item ID:</b></td>
                                      <td><input type="text" name="shop_itemid1" maxlenght="7" value="'.$shop['itemid1'].'" style="width: 70px" ></td></tr>
                                      <tr><td align="center"><b>Item Count:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" value="'.$shop['count1'].'" style="width: 70px" ></td></tr>';
                        }
                        if($shop['offer_type'] == 'vipdays'){
                                $main_content .= '<tr><td align="center" ><b>Days:</b></td>
                                      <td><input type="text" name="shop_count1" maxlenght="7" style="width: 70px" ></td></tr>';
                        }
                        $main_content .= '<tr><td align="center" ><b>Offer Type:</b></td>
                              <td><input type="text" name="shop_offer_type" value="'.$shop['offer_type'].'" maxlenght="40" style="width: 200px" ></td></tr>
                              <tr><td align="center" ><b>Offer Description:</b></td>
                              <td ><textarea name="shop_offer_description" rows="2" cols="35">'.$shop['offer_description'].'</textarea></td></tr>
                              <tr><td align="center" ><b>Offer Name:</b></td>
                              <td><input type="text" name="shop_offer_name" value="'.$shop['offer_name'].'" maxlenght="40" style="width: 200px" ></td></tr>
                              <tr><td><input name="submit" type="submit" value="Submit" /></form></td><td></td></tr></table>';
                        $main_content .= '<form action="?subtopic=shopguildadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                }
        }
        if($action == "edited") {
                $id = (int) $_REQUEST['id'];
                $shop_points = stripslashes(trim($_POST['shop_points']));
                $shop_offer_type = stripslashes(trim($_POST['shop_offer_type']));
                $shop_itemid1 = stripslashes(trim($_POST['shop_itemid1']));
                $shop_count1 = stripslashes(trim($_POST['shop_count1']));
                $shop_itemid2 = stripslashes(trim($_POST['shop_itemid2']));
                $shop_count2 = stripslashes(trim($_POST['shop_count2']));
                $shop_offer_description = stripslashes(trim($_POST['shop_offer_description']));
                $shop_offer_name = stripslashes(trim($_POST['shop_offer_name']));
                $SQL->query('UPDATE `z_shopguild_offer` SET `points` = '.$shop_points.', `itemid1` = '.$SQL->quote($shop_itemid1).', `count1` = '.$SQL->quote($shop_count1).', `itemid2` = '.$SQL->quote($shop_itemid2).', `count2` = '.$SQL->quote($shop_count2).', `offer_type` = '.$SQL->quote($shop_offer_type).', `offer_description` = '.$SQL->quote($shop_offer_description).', `offer_name` = '.$SQL->quote($shop_offer_name).' WHERE `id` = '.$id.';');
                $main_content .= '<b><center>Shop offer successfully edited.</b><br><br><form action="?subtopic=shopguildadmin&action=viewoffer" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form><meta http-equiv="refresh" content="1;url=/?subtopic=shopguildadmin&action=viewoffer" />';
        }
        if($action == "points") {
                $player = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
                $points = (int) $_POST['points'];
                if(empty($player)) {
                        $main_content .= '<form action="" method="post"><B>Enter Character Name:</B><input type="textbox" name="character"><br>
                              <B>Enter Points Amount:</B><input type="textbox" name="points"><br><br><input type="submit" value="Submit">
                              </form></center><form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                } else {
                        $player_data = $SQL->query("SELECT * FROM `players` WHERE `name` = '".$player."';")->fetch();
                        $SQL->query("UPDATE `accounts` SET `guild_points` = `guild_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");
                        $main_content .= '<b><center>'.$points.' Premium Points added to the account of <i>'.$player.'</i> !</b></center><br>
                              <form action="?subtopic=shopguildadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
                }
        }
} else {
        $main_content .= 'Sorry, you have not the rights to access this page.';
}
?>

Try that script and show me the error you get again.
 
Upvote 0 Downvote

Similar threads

J
  • Question
Problem with Accountmangament
Replies
2
Views
284
jareczekjsp
J
F
  • Question
TFS 1.X+ Multiworld log in issue
Replies
1
Views
541
ForgottenNot
F
J
  • Question
OTClient otcv8 autodapter error -windows 10
Replies
7
Views
685
Jeyci
J
Back
Top