erro [Encerrado] ERROR NO SHOP

JonatasLucasf · Dezembro 23, 2013

galera estou com esse error quando vou no bagulho lá pra adicionar items no SHOP DO SITE

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

MEU SHOPADMIN.PHP

<?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&offer_type=item">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($_REQUEST['offer_type']){

$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></table></td></tr>';

$main_content .= '<form action="?subtopic=shopadmin&offer_type='.$shop_offer_type.'&check" 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>

<tr><td align="center" ><b>Count Container:</b></td>

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

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

<tr><td align="center" ><b>Offer Name:</b></td>

<input name="submit" type="submit" value="Reset" /></form></td></tr></table>';

$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&offer_type=item" 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>

<tr><td align="center" ><b>Count Container:</b></td>

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

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

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

<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><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.';

}

?>

Alexclusive · Dezembro 24, 2013

Execute em sua database:

CREATE TABLE `pid` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`date` INT(11) NOT NULL ,
`text` TEXT NOT NULL
) ENGINE=MYISAM ;

JonatasLucasf · Dezembro 31, 2013

valew alex, já tinha conseguido kkk até esqueci de vir aqui pra falar que a duvida foi sanada hehe obrigado pela ajuda

xXMythuszXx · Janeiro 2, 2014

Dúvida sanada, tópico reportado para moverem.

Alexclusive · Janeiro 2, 2014

Tópico movido para a seção de dúvidas e pedidos resolvidos.

Stigal · Abril 21, 2018

A questão neste tópico de suporte foi encerrada por falta de respostas. Este tópico está fechado e foi movido para Suporte - Tópicos Sem Resposta.

+ Caso a dúvida não tenha sido resolvida você poderá criar outro tópico solicitando ajuda.
* Lembre-se que é permitido dar UP no tópico a cada 24 horas para assim o destacar e manter movimentado.

Entrar

erro [Encerrado] ERROR NO SHOP

Posts Recomendados

JonatasLucasf 60

Link para o comentário

Compartilhar em outros sites

Alexclusive 687

Link para o comentário

Compartilhar em outros sites

JonatasLucasf 60

Link para o comentário

Compartilhar em outros sites

xXMythuszXx 50

Link para o comentário

Compartilhar em outros sites

Alexclusive 687

Link para o comentário

Compartilhar em outros sites

Stigal 584

Link para o comentário

Compartilhar em outros sites

Quem Está Navegando 0 membros estão online

Conteúdo Similar

script alguém pode me ajudar nessa spells aqui, queira que colocassem pro meu personagem ficar inatingível por 6 segundos e podendo atacar livremente

Object Builder 7.10 até 12.60 + AdobeAIR

source Erro ao compilar Sources

Erro ao abrir Remeres

Letreiro ao entrar em local

Fóruns

Tutoriais

Suporte