• TibiaFace

    Tibiaface | Una comunidad Open Tibia donde encontras : mapas, scripts, Otserver, npc y amigos etc ...

    .
    demo menumenu

    Afiliados



    Votar:

    [Ayuda] Error En Shop y Otras Cosas

    Compartir:

    Ver el tema anterior Ver el tema siguiente Ir abajo  Mensaje (Página 1 de 1.)

    1Resuelto [Ayuda] Error En Shop y Otras Cosas el Jue Jun 22, 2017 5:51 pm

    El Negrito

    El Negrito
    Nuevo Miembro
    Nuevo Miembro
    Cuando Quiero Agregar Los Items A La Shop Sale Esto VVV
    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:61 Stack trace: #0 C:\xampp\htdocs\shopadmin.php(61): PDO->query('INSERT INTO `z_...') #1 C:\xampp\htdocs\index.php(225): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopadmin.php on line 61

    Ver perfil de usuario

    2Resuelto Re: [Ayuda] Error En Shop y Otras Cosas el Jue Jun 22, 2017 6:05 pm

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    a ver vamos a intentar si le atino bueno ejecuta esta tabla en tu mysql phpadmin

    Código:
    ALTER TABLE `z_shop_offer` ADD `pid` INT( 11 ) NOT NULL DEFAULT 0;


    y si por un caso sigue mañaneado utiliza este shopadmin.php

    Código:
    <?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.';
    }
    ?>



    [Ayuda] Error En Shop y Otras Cosas YNU5B25
    Ver perfil de usuario https://www.tibiaface.com

    3Resuelto Re: [Ayuda] Error En Shop y Otras Cosas el Jue Jun 22, 2017 6:10 pm

    El Negrito

    El Negrito
    Nuevo Miembro
    Nuevo Miembro
    Cuando Piso My account aparece eso


    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'empire.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\xampp\htdocs\pot\OTS_Account.php(935): OTS_AccountBan->find('1') #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55

    Ver perfil de usuario

    4Resuelto Re: [Ayuda] Error En Shop y Otras Cosas el Jue Jun 22, 2017 6:14 pm

    [Admin] God Maya

    [Admin] God Maya
    Administrador
    Administrador
    ejecute esta tabla en su mysql php admin

    Código:
    CREATE TABLE `bans`
    (
        `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
        `type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
        `value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
        `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
        `active` TINYINT(1) NOT NULL DEFAULT TRUE,
        `expires` INT NOT NULL,
        `added` INT UNSIGNED NOT NULL,
        `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
        `comment` TEXT NOT NULL,
        `reason` INT UNSIGNED NOT NULL DEFAULT 0,
        `action` INT UNSIGNED NOT NULL DEFAULT 0,
        `statement` VARCHAR(255) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`),
        KEY `type` (`type`, `value`),
        KEY `active` (`active`)
    ) ENGINE = InnoDB;


    S i tu tema se soluciono porfavor dele clic al boton resuelto



    [Ayuda] Error En Shop y Otras Cosas YNU5B25
    Ver perfil de usuario https://www.tibiaface.com

    5Resuelto Re: [Ayuda] Error En Shop y Otras Cosas el Jue Jun 22, 2017 6:15 pm

    El Negrito

    El Negrito
    Nuevo Miembro
    Nuevo Miembro
    Very Happy Resuelto Gracias Very Happy

    Ver perfil de usuario

    Contenido patrocinado


    Ver el tema anterior Ver el tema siguiente Volver arriba  Mensaje (Página 1 de 1.)

    Permisos de este foro:
    No puedes responder a temas en este foro.

    Temas Recomendados×+

       

      BienvenidosTibiaFace es una comunidad de Open Tibia. Para participar debes estar registrado (click para Regístrate).