• 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!

Error iPACC v1.2+

E

Eazy M

Developer
Joined
Oct 17, 2010
Messages
911
Reaction score
62
Location
.
Hi, when i click at "VIEW SHOP OFFER (EDIT/DELETE)" i get this error:


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'field list'' in C:\xampp\xampp\htdocs\shopadmin.php:102 Stack trace: #0 C:\xampp\xampp\htdocs\shopadmin.php(102): PDO->query('SELECT id, poin...') #1 C:\xampp\xampp\htdocs\index.php(225): include('C:\xampp\xampp\...') #2 {main} thrown in C:\xampp\xampp\htdocs\shopadmin.php on line 102


And when i try add points to someone i get this error:


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'love'pants'' at line 1' in C:\xampp\xampp\htdocs\shopadmin.php:183 Stack trace: #0 C:\xampp\xampp\htdocs\shopadmin.php(183): PDO->query('SELECT * FROM `...') #1 C:\xampp\xampp\htdocs\index.php(225): include('C:\xampp\xampp\...') #2 {main} thrown in C:\xampp\xampp\htdocs\shopadmin.php on line 183


And when i try add new offers i get this error:


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pid' in 'field list'' in C:\xampp\xampp\htdocs\shopadmin.php:61 Stack trace: #0 C:\xampp\xampp\htdocs\shopadmin.php(61): PDO->query('INSERT INTO `z_...') #1 C:\xampp\xampp\htdocs\index.php(225): include('C:\xampp\xampp\...') #2 {main} thrown in C:\xampp\xampp\htdocs\shopadmin.php on line 61

Here you got the SHOPADMIN script:


<?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=shopadmin&action=addoffer">ADD SHOP OFFER</a><br><br><a href="?subtopic=shopadmin&action=viewoffer">
VIEW SHOP OFFER <i>(EDIT/DELETE)</i></a><br><br><a href="?subtopic=shopadmin&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">Pacc</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="pacc" 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=shopadmin&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'] == 'pacc'){
$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=shopadmin&action=addoffer" method="post" >
<input name="submit" type="submit" value="Reset" /></form>';
$main_content .= '<form action="?subtopic=shopadmin" 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_shop_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 == 'pacc'){
$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=shopadmin&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=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'id') . '" class=white>ID:</td><td width="5"><font color="white"><a href="index.php?subtopic=shopadmin&action=viewoffer&order=' . getOrder($order, 'order', 'points') . '" class=white>Points:</td><td width="7">
<font color="white"><a href="index.php?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="index.php?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="index.php?subtopic=shopadmin&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_shop_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=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>';
}
$main_content .= '</td></tr></TABLE><br><form action="?subtopic=shopadmin" method="post" ><input name="submit" type="submit" value="Back" title="Back"/></form>';
}
if($action == "deleteoffer") {
$id = (int) $_REQUEST['id'];
$SQL->query('DELETE FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
$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>';
}
if($action == "editoffer") {
$id = (int) $_REQUEST['id'];
$shopoffers = $SQL->query('SELECT * FROM z_shop_offer WHERE id = '.$id.' LIMIT 1;');
foreach($shopoffers as $shop) {
$main_content .= '<form action="?subtopic=shopadmin&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'] == 'pacc'){
$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=shopadmin&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_shop_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=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" />';
}
if($action == "points") {
$player = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
$points = $_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=shopadmin" 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 `premium_points` = `premium_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=shopadmin" 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.';
}
?>
Click to expand...



Help fast please ;);)
 
Sort by date Sort by votes
Try this script:
first part
Code: 
<?php
///////////////////////////////////////
// Administration Panel
///////////////////////////////////////
// Make sure we're still logged in.
if(!$logged) {
	echo 'Please login first.';
	exit;
}
// Make sure nobody's trying anything sneeky....
if(!$admin) {
	echo 'What do you think you\'re doing?';
	exit;
}
// If we are good, then here we go!
else
	{
	$getNumbQuery = "SELECT * FROM z_shop_admin_todo WHERE trans_state='Incomplete';";
	$getNumbQueryResult = $SQL->query($getNumbQuery);
	$iii = 0;
	foreach($getNumbQueryResult as $offer) {$iii++;}
	echo "<br />Welcome to the shop admin panel, ".$accountName.".";
	if ($adminAction == "" || $adminAction == "home")
		{
			echo "<b>Options</b><br />";
			echo "<ul>";
			echo "<li><a href=\"/index.php/p/v/shop/admin/view_other\">View Administrator To-Do List (Special Account Services/Others)</a> <b>".$iii." Incomplete</b></li>";
			echo "<li><a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a></li>";
		}
	if ($adminAction == "manage")
		{
			echo '<table width="100%">
			<tr>
				<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="5"><font color="'.$offerTypeTextColor.'" size="4"><b>Available Offers</b> - <a href="/index.php/p/v/shop/admin/add">Add Offer</a></font></td>
			</tr>
			<tr>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>ID</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Name</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Point Cost</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Type</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Action</b></font></td>
			</tr>';
			$getOffersQuery = "SELECT * FROM z_shop_offer ORDER BY offer_type";
			$getOffersQueryResult = $SQL->query($getOffersQuery);
			$iii = 0;
			foreach($getOffersQueryResult as $offer)
				{
				if ($offer['offer_type'] == "special"){ $type = "Special"; }
				if ($offer['offer_type'] == "pacc"){ $type = "Premium"; }
				if ($offer['offer_type'] == "item"){ $type = "Item"; }
				if ($offer['offer_type'] == "container"){ $type = "Container"; }
				if ($offer['offer_type'] == "other"){ $type = "Other"; }
				echo '<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["id"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["offer_name"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["points"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$type.'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<center>
								<form action="/index.php/p/v/shop/admin/edit" method="POST">
								<input name="id" value="'.$offer["id"].'" type="hidden">
								<input name="type" value="'.$offer["offer_type"].'" type="hidden">
								<input value="Edit" type="submit">
								</form><form action="/index.php/p/v/shop/admin/delete" method="POST">
								<input name="id" value="'.$offer["id"].'" type="hidden">
								<input name="name" value="'.$offer["offer_name"].'" type="hidden">
								<input value="Delete" type="submit">
								</form>
							</center>
						</font></td>
				</tr>';
				$iii++;
				}
			echo "</table>";
			if ($iii == 0){ echo "There are no offers in the database! Maybe you should add some?"; }
		}
	if ($adminAction == "view_other")
		{
		if (!isset($_POST['id']))
			{
			echo '<table width="100%">
			<tr>
				<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="6"><font color="'.$offerTypeTextColor.'" size="4"><b>Administrator To-Do List</b></font></td>
			</tr>
			<tr>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>ID</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Service</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>For (account / player)</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>From (account / nickname)</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Status</b></font></td>
				<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Action</b></font></td>
			</tr>';
			$getOffersQuery = "SELECT * FROM z_shop_admin_todo ORDER BY id DESC";
			$getOffersQueryResult = $SQL->query($getOffersQuery);
			$iii = 0;
			foreach($getOffersQueryResult as $offer)
				{
				echo '<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["id"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["service"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["to_account"].' / '.$offer["to_name"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["from_account"].' / '.$offer["from_nick"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">'.$offer["trans_state"].'</font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<center>
								<form action="/index.php/p/v/shop/admin/view_other" method="POST">
								<input name="id" value="'.$offer["id"].'" type="hidden">
								<input name="name" value="'.$offer["service"].'" type="hidden">
								<input name="trans_state" value="Completed" type="hidden">
								<input value="Completed" type="submit">
								</form><form action="/index.php/p/v/shop/admin/view_other" method="POST">
								<input name="id" value="'.$offer["id"].'" type="hidden">
								<input name="name" value="'.$offer["service"].'" type="hidden">
								<input name="trans_state" value="Incomplete" type="hidden">
								<input value="Incomplete" type="submit">
								</form>
							</center>
						</font></td>
				</tr>';
				$iii++;
				}
			echo "</table>";
			if ($iii == 0){ echo "Nothing todo!"; }
			}
		else
			{
			$insertQuery = "UPDATE z_shop_admin_todo SET trans_state='".$_POST['trans_state']."' WHERE id='".$_POST['id']."';";
			$insertQueryResult = $SQL->query($insertQuery);
			if ($insertQueryResult)
				{
				echo "Offer ".$_POST['name']." set to ".$_POST['trans_state']."!<br />";
				echo "<a href=\"/index.php/p/v/shop/admin/view_other\">Manage Todo</a>";
				}
			if (!$insertQueryResult)
				{
				echo "Offer ".$_POST['name']." was <b>NOT</b> updated! An error occured.<br />";
				echo "<a href=\"/index.php/p/v/shop/admin/view_other\">Manage Todo</a>";
				}
			}
		}
	if ($adminAction == "delete")
		{
			$id=$_POST['id'];
			$name=$_POST['name'];
			$getOffersQuery = "DELETE FROM z_shop_offer WHERE id='".$id."'";
			$getOffersQueryResult = $SQL->query($getOffersQuery);
				if ($getOffersQueryResult)
					{
					echo $name." has been removed from the offers list.<br />";
					echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
					}
				if (!$getOffersQueryResult)
					{
					echo $name." was <b>NOT</b> removed from the offers list. An error occured.<br />";
					echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
					}
		}
	if ($adminAction == "add")
		{
			if (!isset($_POST['type']))
				{
				echo 'Please select the type of offer you would like to create.<br />';
				echo '<form action="/index.php/p/v/shop/admin/add" method="POST">
					<select name="type">
						<option value="pacc">Premium Account</option>
						<option value="item">Item</option>
						<option value="container">Container of Items</option>
						<option value="other">Other*</option>
						<option value="special">Special Account Service*</option>
					</select>
					<input value="Continue" type="submit">
					</form> ';
				echo '* These type will reqiure action from an administrator to be completed. (ie: you)';
				}
			else
				{
				if (!isset($_POST['step'])){
				if ($_POST['type'] == "pacc")
					{
					echo '
					<form action="/index.php/p/v/shop/admin/add" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Add Premium Account Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Premium Days</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count1" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30"></textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="type" value="pacc" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Add Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "item")
					{
					echo '
					<form action="/index.php/p/v/shop/admin/add" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Add Item Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item ID</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="itemid1" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item Count/Charges</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count1" maxlength="60" type="text"> (UH and 100 here would make a 100x UH Rune.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Image URL</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="imageURL" maxlength="255" type="text"> (URL to picture to show in offers list.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30"></textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="type" value="item" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Add Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "container")
					{
					echo '
					<form action="/index.php/p/v/shop/admin/add" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Add Container Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item ID</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="itemid1" maxlength="60" type="text"> (The item <b>inside</b> the container.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item Count/Charges</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count1" maxlength="60" type="text"> (UH and 100 here would make a 100x UH Rune.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Container ID</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="itemid2" maxlength="60" type="text">(Bag - 1987; Backpack - 1988; Others may be used.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Amount of Items</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count2" maxlength="60" type="text"> (How many items are inside the container.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Image URL</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="imageURL" maxlength="255" type="text"> (URL to picture to show in offers list.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30"></textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="type" value="container" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Add Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "other")
					{
					echo '
					<form action="/index.php/p/v/shop/admin/add" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Add Other Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Image URL</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="imageURL" maxlength="255" type="text"> (URL to picture to show in offers list.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30"></textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="type" value="other" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Add Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "special")
					{
					echo '
					<form action="/index.php/p/v/shop/admin/add" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Add Special Account Service Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30"></textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="type" value="special" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Add Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				}
				if (isset($_POST['step']) && $_POST['step'] == "insert")
					{	
						if ($_POST['type'] == "pacc")
							{
							$insertQuery = "INSERT INTO z_shop_offer (points,count1,offer_type,offer_description,offer_name) VALUES ('".$_POST['points']."','".$_POST['count1']."','".$_POST['type']."','".$_POST['offer_description']."','".$_POST['offer_name']."');";
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." added!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "item")
							{
							$insertQuery = "INSERT INTO z_shop_offer (points,itemid1,count1,offer_type,offer_description,offer_name,imageURL) VALUES ('".$_POST['points']."','".$_POST['itemid1']."','".$_POST['count1']."','".$_POST['type']."','".$_POST['offer_description']."','".$_POST['offer_name']."','".$_POST['imageURL']."');";
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." added!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "container")
							{
							$insertQuery = "INSERT INTO z_shop_offer (points,itemid1,count1,itemid2,count2,offer_type,offer_description,offer_name,imageURL) VALUES ('".$_POST['points']."','".$_POST['itemid1']."','".$_POST['count1']."','".$_POST['itemid2']."','".$_POST['count2']."','".$_POST['type']."','".$_POST['offer_description']."','".$_POST['offer_name']."','".$_POST['imageURL']."');";
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." added!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "other")
							{
							$insertQuery = "INSERT INTO z_shop_offer (points,offer_type,offer_description,offer_name,imageURL) VALUES ('".$_POST['points']."','".$_POST['type']."','".$_POST['offer_description']."','".$_POST['offer_name']."','".$_POST['imageURL']."');";
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." added!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "special")
							{
							$insertQuery = "INSERT INTO z_shop_offer (points,offer_type,offer_description,offer_name) VALUES ('".$_POST['points']."','".$_POST['type']."','".$_POST['offer_description']."','".$_POST['offer_name']."');";
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." added!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
					}
				}
		
		}
	if ($adminAction == "edit")
		{
				{
				if (!isset($_POST['step'])){
				if ($_POST['type'] == "pacc")
					{
					$selectQuery = "SELECT * FROM z_shop_offer WHERE id='".$_POST['id']."';";
					$selectQueryResult = $SQL->query($selectQuery);
					foreach($selectQueryResult as $data)
					echo '
					<form action="/index.php/p/v/shop/admin/edit" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Revise Premium Account Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" value="'.$data["offer_name"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Premium Days</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count1" value="'.$data["count1"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30">'.$data["offer_description"].'</textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" value="'.$data["points"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="id" value="'.$_POST["id"].'" type="hidden">
							<input name="type" value="pacc" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Revise Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';

\/ \/ \/ down \/ \/ \/
 
Upvote 0 Downvote
second part
Code: 
				}
				if ($_POST['type'] == "item")
					{
					$selectQuery = "SELECT * FROM z_shop_offer WHERE id='".$_POST['id']."';";
					$selectQueryResult = $SQL->query($selectQuery);
					foreach($selectQueryResult as $data)
					echo '
					<form action="/index.php/p/v/shop/admin/edit" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Revise Item Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" value="'.$data["offer_name"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item ID</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="itemid1" value="'.$data["itemid1"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item Count/Charges</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count1" value="'.$data["count1"].'" maxlength="60" type="text"> (UH and 100 here would make a 100x UH Rune.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Image URL</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="imageURL" value="'.$data["imageURL"].'" maxlength="255" type="text"> (URL to picture to show in offers list.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30">'.$data["offer_description"].'</textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" value="'.$data["points"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="id" value="'.$_POST["id"].'" type="hidden">
							<input name="type" value="item" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Revise Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "container")
					{
					$selectQuery = "SELECT * FROM z_shop_offer WHERE id='".$_POST['id']."';";
					$selectQueryResult = $SQL->query($selectQuery);
					foreach($selectQueryResult as $data)
					echo '
					<form action="/index.php/p/v/shop/admin/edit" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Revise Container Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" value="'.$data["offer_name"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item ID</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="itemid1" value="'.$data["itemid1"].'" maxlength="60" type="text"> (The item <b>inside</b> the container.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Item Count/Charges</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count1" value="'.$data["count1"].'" maxlength="60" type="text"> (UH and 100 here would make a 100x UH Rune.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Container ID</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="itemid2" value="'.$data["itemid2"].'" maxlength="60" type="text">(Bag - 1987; Backpack - 1988; Others may be used.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Amount of Items</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="count2" value="'.$data["count2"].'" maxlength="60" type="text"> (How many items are inside the container.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Image URL</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="imageURL" value="'.$data["imageURL"].'" maxlength="255" type="text"> (URL to picture to show in offers list.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30">'.$data["offer_description"].'</textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" value="'.$data["points"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="id" value="'.$_POST["id"].'" type="hidden">
							<input name="type" value="container" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Revise Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "other")
					{
					$selectQuery = "SELECT * FROM z_shop_offer WHERE id='".$_POST['id']."';";
					$selectQueryResult = $SQL->query($selectQuery);
					foreach($selectQueryResult as $data)
					echo '
					<form action="/index.php/p/v/shop/admin/edit" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Revise Other Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" value="'.$data["offer_name"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Image URL</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="imageURL" value="'.$data["imageURL"].'" maxlength="255" type="text"> (URL to picture to show in offers list.)</font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30">'.$data["offer_description"].'</textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" value="'.$data["points"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="id" value="'.$_POST["id"].'" type="hidden">
							<input name="type" value="other" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Revise Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				if ($_POST['type'] == "special")
					{
					$selectQuery = "SELECT * FROM z_shop_offer WHERE id='".$_POST['id']."';";
					$selectQueryResult = $SQL->query($selectQuery);
					foreach($selectQueryResult as $data)
					echo '
					<form action="/index.php/p/v/shop/admin/edit" method="POST">
					<table width="100%">
						<tr>
							<td bgcolor="'.$offerTypeBackgroundColor.'" colspan="2"><font color="'.$offerTypeTextColor.'" size="4"><b>Revise Special Account Service Offer</b></font></td>
						</tr>
						<tr>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Field</b></font></td>
							<td bgcolor="'.$offerTableTitlesBackgroundColor.'"><font color="'.$offerTableTitlesTextColor.'"><b>Value</b></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Offer Name</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'" valign="center"><font color="'.$offerMainTextColor.'"><input name="offer_name" value="'.$data["offer_name"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Description</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><textarea name="offer_description" rows="4" cols="30">'.$data["offer_description"].'</textarea></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'" align="center"><font color="'.$offerMainTextColor.'"><b>Point Cost</b></font></td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input name="points" value="'.$data["points"].'" maxlength="60" type="text"></font></td>
						</tr>
						<tr>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'">
							<input name="id" value="'.$_POST["id"].'" type="hidden">
							<input name="type" value="special" type="hidden">
							<input name="step" value="insert" type="hidden"></font>
						</td>
						<td bgcolor="'.$offerMainBackgroundColor.'"><font color="'.$offerMainTextColor.'"><input value="Revise Offer" type="submit"></font></td>
						</tr>
					</table>
					</form>';
					}
				}
				if (isset($_POST['step']) && $_POST['step'] == "insert")
					{	
						if ($_POST['type'] == "pacc")
							{
							$insertQuery = "UPDATE z_shop_offer SET points='".$_POST['points']."', count1='".$_POST['count1']."', offer_description='".$_POST['offer_description']."', offer_name='".$_POST['offer_name']."' WHERE id='".$_POST['id']."';";
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." updated!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> updated! An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "item")
							{
							$insertQuery = "UPDATE z_shop_offer SET points='".$_POST['points']."', itemid1='".$_POST['itemid1']."', count1='".$_POST['count1']."', offer_description='".$_POST['offer_description']."', offer_name='".$_POST['offer_name']."', imageURL='".$_POST['imageURL']."' WHERE id='".$_POST['id']."';";							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." updated!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> updated! An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "container")
							{
							$insertQuery = "UPDATE z_shop_offer SET points='".$_POST['points']."', itemid1='".$_POST['itemid1']."', count1='".$_POST['count1']."', itemid2='".$_POST['itemid2']."', count2='".$_POST['count2']."', offer_description='".$_POST['offer_description']."', offer_name='".$_POST['offer_name']."', imageURL='".$_POST['imageURL']."' WHERE id='".$_POST['id']."';";							$insertQueryResult = $SQL->query($insertQuery);
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." updated!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> updated! An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "other")
							{
							$insertQuery = "UPDATE z_shop_offer SET points='".$_POST['points']."', offer_description='".$_POST['offer_description']."', offer_name='".$_POST['offer_name']."', imageURL='".$_POST['imageURL']."' WHERE id='".$_POST['id']."';";							$insertQueryResult = $SQL->query($insertQuery);
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." updated!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> updated! An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
						if ($_POST['type'] == "special")
							{
							$insertQuery = "UPDATE z_shop_offer SET points='".$_POST['points']."', offer_description='".$_POST['offer_description']."', offer_name='".$_POST['offer_name']."' WHERE id='".$_POST['id']."';";							$insertQueryResult = $SQL->query($insertQuery);
							$insertQueryResult = $SQL->query($insertQuery);
							if ($insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." updated!<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							if (!$insertQueryResult)
								{
								echo "Offer ".$_POST['offer_name']." was <b>NOT</b> updated! An error occured.<br />";
								echo "<a href=\"/index.php/p/v/shop/admin/manage\">Manage Offers</a>";
								}
							}
					}
				}
		}

	}
?>

Try if its working.
 
Upvote 0 Downvote
Rasmus75 said:
@Mogex
I use Gesior AAC now.
Click to expand...

Why? It don't worked for you?
They said that have bugs. In modern acc what fails is that they don't have any good shop script relased, only priv buying it, cuz PATXON hates donations, and the last is that Kula_ don't give war.lua for modern -.-,
But it's the best choise =)!
 
Upvote 0 Downvote
Each post can contain up to 37500 characters.
I had to divide my post, cuz there was about 44k characters.
Try if working. Modern AAC is much better than Gesior AAC.
 
Upvote 0 Downvote
modern AAC its only for people whos know any from programming, gesior is for a people getting started, sorry but for me gesior was the best
 
Upvote 0 Downvote
but it's easier to hack gesior aac... Modern isn't hard to compile. To be honest... i'm noob in programming, etc. I tried to set up Gesior, but there was some errors, so I've decided to work on Modern AAC. Nothing hard... just try... if you need help, ask. Maybe I could help you...
 
Upvote 0 Downvote
@Up

I need a WORKING donate system for modern, that's why i use Gesior becaus it's more scripts,layouts for it.
And by the way, I dont buy scripts for Modern.
 
Upvote 0 Downvote
Back
Top