Suporte Erro na database

[Aragllov 11]

Query:	Boa noite, alguém pode me ajudar com esse teorema? Acredito que falta essas query, mas não sei como fazer.     SELECT `id`, `name`, `password`, `premdays`, `coins`, `lastday`, `email`, `key`, `create_ip`, `creation`, `page_access`, `location`, `rlname`, `birth_date`, `gender`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`, `vote`, `loyalty_points`, `guild_points` FROM `accounts` WHERE `name` = 'Teste'
SQLSTATE:	00000
Driver code:
Error message:

 

Query:	SELECT * FROM `z_shop_offer` WHERE `category` = '2'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `value` FROM `server_config` WHERE `config` = 'double'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_shop_category` WHERE `hide` = 0 ORDER BY `id` ASC
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_shop_offer` WHERE `category` = '2' AND `hide` = 0 ORDER BY `offer_date` DESC
SQLSTATE:	00000
Driver code:
Error message:

 

Query:	SELECT COUNT(*) FROM `players`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT COUNT(*) FROM `accounts`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT COUNT(*) FROM `guilds`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT COUNT(*) FROM `z_shop_offer`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `newsticker` ORDER BY `date` DESC LIMIT 1
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM tickets WHERE ticket_status = 'Waiting' AND ticket_admin_reply = 0
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM tickets WHERE ticket_status = 'Waiting' AND ticket_admin_reply = 1
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM tickets WHERE ticket_status = 'Closed'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `value` FROM `server_config` WHERE `config` = 'double'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_shop_category` ORDER BY `name` ASC
SQLSTATE:	00000
Driver code:
Error message:

Editado Agosto 4, 2021 por Aragllov (veja o histórico de edições)

[Etheron8 9]

  Em 04/08/2021 em 22:59, Aragllov disse:

Query:	Boa noite, alguém pode me ajudar com esse teorema? Acredito que falta essas query, mas não sei como fazer.     SELECT `id`, `name`, `password`, `premdays`, `coins`, `lastday`, `email`, `key`, `create_ip`, `creation`, `page_access`, `location`, `rlname`, `birth_date`, `gender`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag`, `vote`, `loyalty_points`, `guild_points` FROM `accounts` WHERE `name` = 'Teste'
SQLSTATE:	00000
Driver code:
Error message:

 

Query:	SELECT * FROM `z_shop_offer` WHERE `category` = '2'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `value` FROM `server_config` WHERE `config` = 'double'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_shop_category` WHERE `hide` = 0 ORDER BY `id` ASC
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_shop_offer` WHERE `category` = '2' AND `hide` = 0 ORDER BY `offer_date` DESC
SQLSTATE:	00000
Driver code:
Error message:

 

Query:	SELECT COUNT(*) FROM `players`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT COUNT(*) FROM `accounts`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT COUNT(*) FROM `guilds`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT COUNT(*) FROM `z_shop_offer`
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `newsticker` ORDER BY `date` DESC LIMIT 1
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM tickets WHERE ticket_status = 'Waiting' AND ticket_admin_reply = 0
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM tickets WHERE ticket_status = 'Waiting' AND ticket_admin_reply = 1
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM tickets WHERE ticket_status = 'Closed'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `value` FROM `server_config` WHERE `config` = 'double'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_shop_category` ORDER BY `name` ASC
SQLSTATE:	00000
Driver code:
Error message:

Expand   Mostrar mais  

CREATE TABLE `z_shop_offer` (
  `id` int(11) NOT NULL auto_increment,
  `points` int(11) NOT NULL default '0',
  `itemid1` int(11) NOT NULL default '0',
  `count1` int(11) NOT NULL default '0',
  `itemid2` int(11) NOT NULL default '0',
  `count2` int(11) NOT NULL default '0',
  `offer_type` varchar(255) default NULL,
  `offer_description` text NOT NULL,
  `offer_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES (NULL , '10', '0', '12', '0', '0', 'pacc', 'Buy 12 days of premium account for yourself or your friend!', '12 Days of PACC'
), (NULL , '40', '5890', '50', '0', '0', 'item', 'Buy 50 Chicken Feathers!', '50x Chicken Feather'
), (NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor');

CREATE TABLE `z_shop_history_item` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `offer_id` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE `z_shop_history_pacc` (
  `id` int(11) NOT NULL auto_increment,
  `to_name` varchar(255) NOT NULL default '0',
  `to_account` int(11) NOT NULL default '0',
  `from_nick` varchar(255) NOT NULL,
  `from_account` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `pacc_days` int(11) NOT NULL default '0',
  `trans_state` varchar(255) NOT NULL,
  `trans_start` int(11) NOT NULL default '0',
  `trans_real` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `z_news_tickers` (
  `date` int(11) NOT NULL default '1',
  `author` int(11) NOT NULL,
  `image_id` int(3) NOT NULL default '0',
  `text` text NOT NULL,
  `hide_ticker` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `z_news_tickers` (`date`, `author`, `image_id`, `text`, `hide_ticker`) VALUES
(1274141844, 1, 1, 'Hello! Gesior account manager 0.3.6 installed. Report bugs Otland.Net Thread. Thanks to widnet and Norix.', 1);

 

Editado Agosto 18, 2021 por Etheron8 (veja o histórico de edições)