Gesior AAC Erro Shop Gesior

Strung · Julho 24, 2017

Galera estou enfrentando esse erro aqui, alguma alma de Deus pode me ajudar?

Rep+

Spoiler

Query:SELECT `id`, `vip_time`, `guild_points`, `backup_points`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`, `vote` FROM `accounts` WHERE `name` = 'tibia'

SQLSTATE:00000

Driver code:

Error message:

Query:SELECT * FROM `z_shop_offer` WHERE `offer_category` = 1;

SQLSTATE:42S22

Driver code:1054

Error message:Unknown column 'offer_category' in 'where clause'

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\pages\shopsystem.php on line 35

Rusherzin · Julho 24, 2017

Tenta executar isso na aba SQL do phpmyadmin:

ALTER TABLE z_shop_offer ADD `offer_category` int(11) DEFAULT NULL;

Strung · Julho 24, 2017

39 minutos atrás, Rusherzin disse:
Tenta executar isso na aba SQL do phpmyadmin:
ALTER TABLE z_shop_offer ADD `offer_category` int(11) DEFAULT NULL;

o outro erro ja deu, ta abrindo o shop normal, agora apareceu esse.

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\shopsystem.php on line 251

mesmo colocabdo DEBUG = true

n mostra o que é

Rusherzin · Julho 24, 2017

Posta o que tem nas linhas 250~252 do arquivo shopsystem.php.

Strung · Julho 24, 2017

4 minutos atrás, Rusherzin disse:

Posta o que tem nas linhas 250~252 do arquivo shopsystem.php.

Spoiler

                       <div class="InnerTableContainer">
                           <table style="width:100%;">
                               <tbody>
                                   <tr>
                                       <td> ';

foreach ($config["site"]["shop_categories"] as $ServiceCategoryID => $data) {

if ($data["enabled"]) {
$main_content .= '

da linha 244 até a 254

Rusherzin · Julho 24, 2017

Quantas categorias tem no array $config["site"]["shop_categories"]? Se tiver só uma ou estiver vazio, esse pode ser o problema. (fica no config.php)

Strung · Julho 24, 2017

6 minutos atrás, Rusherzin disse:

Quantas categorias tem no array $config["site"]["shop_categories"]? Se tiver só uma ou estiver vazio, esse pode ser o problema. (fica no config.php)

meu config.php

Spoiler

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "C:\Users\Andre\Desktop\otserver/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'FortitWar');
$towns_list[0] = array(1 => 'Venore');

$config['site']['outfit_images_url'] = '/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/960/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';
$config['site']['players_group_id_block'] = 3;
$config['site']['limitDeath'] = 5;
$config['site']['levelVideo'] = 150;

# PAGE: donate.php
$config['site']['usePagseguro'] = true; //true show / false hide
$config['site']['usePaypal'] = false;   //true show / false hide
$config['site']['useDeposit'] = true;   //true show / false hide
$config['site']['useZaypay'] = false;   //true show / false hide
$config['site']['useContenidopago'] = false;   //true show / false hide
$config['site']['useOnebip'] = false;   //true show / false hide

# Pagseguro config By IVENSPONTES
$config['pagSeguro']['email'] = "[email protected]"; //Email Pagseguro
$config['pagSeguro']['token'] = "B462B6CE61784785B9BE5929716ADDB9"; // TOKEN
$config['pagSeguro']['urlRedirect'] = 'http://tibia.com/?subtopic=donate&action=final'; //turn off redirect and notifications in pagseguro.com.br
$config['pagSeguro']['urlNotification'] = 'http://tibia.com/retpagseguro.php'; //your return location

$config['pagSeguro']['productName'] = 'Premium Points';
$config['pagSeguro']['productValue'] = 1.00; // 1.50 = R$ 1,50 etc...
$config['pagSeguro']['doublePoints'] = false; ## Double points - true is on / false is off

$config['pagSeguro']['host'] = 'localhost';       ## YOUR HOST
$config['pagSeguro']['database'] = 'baiak860';   ## DATABASE
$config['pagSeguro']['databaseUser'] = 'root';   ## USER
$config['pagSeguro']['databasePass'] = 'notile';       ## PASSWORD

# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 0;
$config['site']['send_register_email'] = false;

# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'][0] = array(1);
$config['site']['max_players_per_account'] = 15;

# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "smtp.xxxxx.com.br";
$config['site']['smtp_port'] = 587;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxx";

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/

# PAGE: characters.php
$config['site']['quests'] = array('Annihilator' => 5000,'Demon Helmet' => 2645,'Pits of Inferno' => 5550);
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 1;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['generate_new_reckey'] = true;
$config['site']['generate_new_reckey_price'] = 500;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 8;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;
$config['site']['access_tickers'] = 3;
$config['site']['access_admin_painel'] = 3;
$config['site']['access_staff_painel'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6, 7);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: shopsystem.php
$config['site']['shop_system'] = true;
$config['site']['shopguild_system'] = true;

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

# Layout Config
$config['site']['layout'] = 'tibiarl';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;

Rusherzin · Julho 24, 2017

É, não tem a parte de categorias. Bota isso aqui dentro do config.php só para ver se funciona, depois tu edita as categorias como quiser.

$config['site']['shop_categories'] = array( 
	"Sorcerer e Druid" => array("id" => 1, "description" => "Itens vips para Sorcerer e Druid.", "new" => 0, "enabled" => true),
    "Knight" => array("id" => 2, "description" => "Itens vips para Knight.","new" => 0, "enabled" => true),
    "Paladin" => array("id" => 3, "description" => "Itens vips para Paladin.","new" => 0, "enabled" => true),
    "Addons e Mounts" => array("id" => 4, "description" => "Addons e Mountarias","new" => 0, "enabled" => true),
    "UpgradeRunes" => array("id" => 5, "description" => "Melhore seus itens com as runes de upgrades.","new" => 0, "enabled" => true),
    "Vip Days e Extras" => array("id" => 6, "description" => "Vips days e Extras.","new" => 0, "enabled" => true));

Strung · Julho 24, 2017

3 minutos atrás, Rusherzin disse:

É, não tem a parte de categorias. Bota isso aqui dentro do config.php só para ver se funciona, depois tu edita as categorias como quiser.


$config['site']['shop_categories'] = array( 
	"Sorcerer e Druid" => array("id" => 1, "description" => "Itens vips para Sorcerer e Druid.", "new" => 0, "enabled" => true),
    "Knight" => array("id" => 2, "description" => "Itens vips para Knight.","new" => 0, "enabled" => true),
    "Paladin" => array("id" => 3, "description" => "Itens vips para Paladin.","new" => 0, "enabled" => true),
    "Addons e Mounts" => array("id" => 4, "description" => "Addons e Mountarias","new" => 0, "enabled" => true),
    "UpgradeRunes" => array("id" => 5, "description" => "Melhore seus itens com as runes de upgrades.","new" => 0, "enabled" => true),
    "Vip Days e Extras" => array("id" => 6, "description" => "Vips days e Extras.","new" => 0, "enabled" => true));

tem como se por pra mim, não sei mexer muito com php

Rusherzin · Julho 24, 2017

<?php 
# Account Maker Config
$config['site']['serverPath'] = "C:\Users\Andre\Desktop\otserver/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'FortitWar');
$towns_list[0] = array(1 => 'Venore');

$config['site']['outfit_images_url'] = '/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/960/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';
$config['site']['players_group_id_block'] = 3;
$config['site']['limitDeath'] = 5;
$config['site']['levelVideo'] = 150;

# PAGE: donate.php
$config['site']['usePagseguro'] = true; //true show / false hide
$config['site']['usePaypal'] = false;    //true show / false hide
$config['site']['useDeposit'] = true;    //true show / false hide
$config['site']['useZaypay'] = false;    //true show / false hide
$config['site']['useContenidopago'] = false;    //true show / false hide
$config['site']['useOnebip'] = false;    //true show / false hide

# Pagseguro config By IVENSPONTES
$config['pagSeguro']['email'] = "[email protected]"; //Email Pagseguro
$config['pagSeguro']['token'] = "B462B6CE61784785B9BE5929716ADDB9"; // TOKEN
$config['pagSeguro']['urlRedirect'] = 'http://tibia.com/?subtopic=donate&action=final'; //turn off redirect and notifications in pagseguro.com.br
$config['pagSeguro']['urlNotification'] = 'http://tibia.com/retpagseguro.php'; //your return location

$config['pagSeguro']['productName'] = 'Premium Points';
$config['pagSeguro']['productValue'] = 1.00;     // 1.50 = R$ 1,50 etc...
$config['pagSeguro']['doublePoints'] = false;     ## Double points - true is on / false is off

$config['pagSeguro']['host'] = 'localhost';        ## YOUR HOST
$config['pagSeguro']['database'] = 'baiak860';    ## DATABASE
$config['pagSeguro']['databaseUser'] = 'root';    ## USER
$config['pagSeguro']['databasePass'] = 'notile';        ## PASSWORD

# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 0;
$config['site']['send_register_email'] = false;

# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'][0] = array(1);
$config['site']['max_players_per_account'] = 15;


# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "smtp.xxxxx.com.br";
$config['site']['smtp_port'] = 587;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxx";

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/

# PAGE: characters.php
$config['site']['quests'] = array('Annihilator' => 5000,'Demon Helmet' => 2645,'Pits of Inferno' => 5550);
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 1;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['generate_new_reckey'] = true;
$config['site']['generate_new_reckey_price'] = 500;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 8;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;
$config['site']['access_tickers'] = 3;
$config['site']['access_admin_painel'] = 3;
$config['site']['access_staff_painel'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6, 7);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: shopsystem.php
$config['site']['shop_system'] = true;
$config['site']['shopguild_system'] = true;

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

# Layout Config
$config['site']['layout'] = 'tibiarl';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;

$config['site']['shop_categories'] = array( 
	"Sorcerer e Druid" => array("id" => 1, "description" => "Itens vips para Sorcerer e Druid.", "new" => 0, "enabled" => true),
    "Knight" => array("id" => 2, "description" => "Itens vips para Knight.","new" => 0, "enabled" => true),
    "Paladin" => array("id" => 3, "description" => "Itens vips para Paladin.","new" => 0, "enabled" => true),
    "Addons e Mounts" => array("id" => 4, "description" => "Addons e Mountarias","new" => 0, "enabled" => true),
    "UpgradeRunes" => array("id" => 5, "description" => "Melhore seus itens com as runes de upgrades.","new" => 0, "enabled" => true),
    "Vip Days e Extras" => array("id" => 6, "description" => "Vips days e Extras.","new" => 0, "enabled" => true));
 ?>

Strung · Julho 24, 2017

Bom ficou assim.

como ele tem que ficar.

7 minutos atrás, Rusherzin disse:


<?php 
# Account Maker Config
$config['site']['serverPath'] = "C:\Users\Andre\Desktop\otserver/";
$config['site']['useServerConfigCache'] = false;
$config['site']['worlds'] = array(0 => 'FortitWar');
$towns_list[0] = array(1 => 'Venore');

$config['site']['outfit_images_url'] = '/outfit.php';
$config['site']['item_images_url'] = 'http://item-images.ots.me/960/';
$config['site']['item_images_extension'] = '.gif';
$config['site']['flag_images_url'] = 'http://flag-images.ots.me/';
$config['site']['flag_images_extension'] = '.png';
$config['site']['players_group_id_block'] = 3;
$config['site']['limitDeath'] = 5;
$config['site']['levelVideo'] = 150;

# PAGE: donate.php
$config['site']['usePagseguro'] = true; //true show / false hide
$config['site']['usePaypal'] = false;    //true show / false hide
$config['site']['useDeposit'] = true;    //true show / false hide
$config['site']['useZaypay'] = false;    //true show / false hide
$config['site']['useContenidopago'] = false;    //true show / false hide
$config['site']['useOnebip'] = false;    //true show / false hide

# Pagseguro config By IVENSPONTES
$config['pagSeguro']['email'] = "[email protected]"; //Email Pagseguro
$config['pagSeguro']['token'] = "B462B6CE61784785B9BE5929716ADDB9"; // TOKEN
$config['pagSeguro']['urlRedirect'] = 'http://tibia.com/?subtopic=donate&action=final'; //turn off redirect and notifications in pagseguro.com.br
$config['pagSeguro']['urlNotification'] = 'http://tibia.com/retpagseguro.php'; //your return location

$config['pagSeguro']['productName'] = 'Premium Points';
$config['pagSeguro']['productValue'] = 1.00;     // 1.50 = R$ 1,50 etc...
$config['pagSeguro']['doublePoints'] = false;     ## Double points - true is on / false is off

$config['pagSeguro']['host'] = 'localhost';        ## YOUR HOST
$config['pagSeguro']['database'] = 'baiak860';    ## DATABASE
$config['pagSeguro']['databaseUser'] = 'root';    ## USER
$config['pagSeguro']['databasePass'] = 'notile';        ## PASSWORD

# Create Account Options
$config['site']['one_email'] = false;
$config['site']['create_account_verify_mail'] = false;
$config['site']['verify_code'] = true;
$config['site']['email_days_to_change'] = 3;
$config['site']['newaccount_premdays'] = 0;
$config['site']['send_register_email'] = false;

# Create Character Options
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_towns'][0] = array(1);
$config['site']['max_players_per_account'] = 15;


# Emails Config
$config['site']['send_emails'] = true;
$config['site']['mail_address'] = "[email protected]";
$config['site']['smtp_enabled'] = true;
$config['site']['smtp_host'] = "smtp.xxxxx.com.br";
$config['site']['smtp_port'] = 587;
$config['site']['smtp_auth'] = true;
$config['site']['smtp_user'] = "[email protected]";
$config['site']['smtp_pass'] = "xxx";

# PAGE: whoisonline.php
$config['site']['private-servlist.com_server_id'] = 1;
/*
Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature.
To use this feature you must register on 'private-servlist.com' and add your server.
Format: number, 0 [disable] or higher
*/

# PAGE: characters.php
$config['site']['quests'] = array('Annihilator' => 5000,'Demon Helmet' => 2645,'Pits of Inferno' => 5550);
$config['site']['show_skills_info'] = true;
$config['site']['show_vip_storage'] = 1;

# PAGE: accountmanagement.php
$config['site']['send_mail_when_change_password'] = true;
$config['site']['send_mail_when_generate_reckey'] = true;
$config['site']['generate_new_reckey'] = true;
$config['site']['generate_new_reckey_price'] = 500;

# PAGE: guilds.php
$config['site']['guild_need_level'] = 8;
$config['site']['guild_need_pacc'] = false;
$config['site']['guild_image_size_kb'] = 50;
$config['site']['guild_description_chars_limit'] = 2000;
$config['site']['guild_description_lines_limit'] = 6;
$config['site']['guild_motd_chars_limit'] = 250;

# PAGE: adminpanel.php
$config['site']['access_admin_panel'] = 3;
$config['site']['access_tickers'] = 3;
$config['site']['access_admin_painel'] = 3;
$config['site']['access_staff_painel'] = 3;

# PAGE: latestnews.php
$config['site']['news_limit'] = 6;

# PAGE: killstatistics.php
$config['site']['last_deaths_limit'] = 40;

# PAGE: team.php
$config['site']['groups_support'] = array(2, 3, 4, 5, 6, 7);

# PAGE: highscores.php
$config['site']['groups_hidden'] = array(4, 5, 6);
$config['site']['accounts_hidden'] = array(1);

# PAGE: shopsystem.php
$config['site']['shop_system'] = true;
$config['site']['shopguild_system'] = true;

# PAGE: lostaccount.php
$config['site']['email_lai_sec_interval'] = 180;

# Layout Config
$config['site']['layout'] = 'tibiarl';
$config['site']['vdarkborder'] = '#505050';
$config['site']['darkborder'] = '#D4C0A1';
$config['site']['lightborder'] = '#F1E0C6';
$config['site']['download_page'] = false;
$config['site']['serverinfo_page'] = true;

$config['site']['shop_categories'] = array( 
	"Sorcerer e Druid" => array("id" => 1, "description" => "Itens vips para Sorcerer e Druid.", "new" => 0, "enabled" => true),
    "Knight" => array("id" => 2, "description" => "Itens vips para Knight.","new" => 0, "enabled" => true),
    "Paladin" => array("id" => 3, "description" => "Itens vips para Paladin.","new" => 0, "enabled" => true),
    "Addons e Mounts" => array("id" => 4, "description" => "Addons e Mountarias","new" => 0, "enabled" => true),
    "UpgradeRunes" => array("id" => 5, "description" => "Melhore seus itens com as runes de upgrades.","new" => 0, "enabled" => true),
    "Vip Days e Extras" => array("id" => 6, "description" => "Vips days e Extras.","new" => 0, "enabled" => true));
 ?>

Rusherzin · Julho 24, 2017

Entendi, esse gesior parece estar com alguns bugs, não sei como resolver.

Strung · Julho 24, 2017

52 minutos atrás, Rusherzin disse:

Entendi, esse gesior parece estar com alguns bugs, não sei como resolver.

blz, vlw mesmo assim!

Entrar

Gesior AAC Erro Shop Gesior

Posts Recomendados

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Participe da conversa

Quem Está Navegando 0 membros estão online

Conteúdo Similar

TibiaKing

Open Tibia Server

Redes Sociais

Anuncie no TibiaKing

Informação Importante