Postado Agosto 4, 2021 3 anos 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 3 anos por Aragllov (veja o histórico de edições)
Postado Agosto 18, 2021 3 anos 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: 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 3 anos por Etheron8 (veja o histórico de edições)
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.