Shop Guild Completo Talkaction+Pagina Site

[LTKReturns 19]

Como Diz O Titulo Do Pedido Gostaria De Um Guild Shop Que Apenas Os Pontos Adiquiridos No Comando !guildpoints Poderam Comprar Na Pagina Do Guild Shop

 

Existe Esse Aqui Mais Não Consigo Executar A Segunda Query Que Vem No Script Talvez Seja Por Causa Do Meu Sistema De Vip BY ACCOUNT

 

http://www.xtibia.co...ebsite-scripts/

Editado Janeiro 22, 2013 por LTKReturns

[AlexandreKG 134]

Poderia me passar as querys pra mim dar uma olhada?

[LTKReturns 19]

AE

 

 

-- phpMyAdmin SQL Dump

-- version 3.3.2deb1ubuntu1

-- http://www.phpmyadmin.net

--

-- Servidor: localhost

-- Tempo de Geração: Nov 19, 2012 as 05:58 PM

-- Versão do Servidor: 5.1.63

-- Versão do PHP: 5.3.2-1ubuntu4.18

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

 

--

-- Banco de Dados: `zenon`

--

 

-- --------------------------------------------------------

 

--

-- Estrutura da tabela `z_shopguild_history_item`

--

 

CREATE TABLE IF NOT EXISTS `z_shopguild_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 AUTO_INCREMENT=66 ;

 

--

-- Extraindo dados da tabela `z_shopguild_history_item`

--

 

INSERT INTO `z_shopguild_history_item` (`id`, `to_name`, `to_account`, `from_nick`, `from_account`, `price`, `offer_id`, `trans_state`, `trans_start`, `trans_real`) VALUES

(65, 'Planta', 3876497, '', 3876497, 3, 100, 'wait', 1352659901, 0),

(13, 'Teste', 9560780, '', 9560780, 3, 0, 'wait', 1352933205, 0);

 

-- --------------------------------------------------------

 

--

-- Estrutura da tabela `z_shopguild_history_pacc`

--

 

CREATE TABLE IF NOT EXISTS `z_shopguild_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 AUTO_INCREMENT=1 ;

 

--

-- Extraindo dados da tabela `z_shopguild_history_pacc`

--

 

 

-- --------------------------------------------------------

 

--

-- Estrutura da tabela `z_shopguild_offer`

--

 

CREATE TABLE IF NOT EXISTS `z_shopguild_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,

`pid` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12656 ;

 

--

-- Extraindo dados da tabela `z_shopguild_offer`

--

 

INSERT INTO `z_shopguild_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`) VALUES

(2, 7, 0, 7, 0, 0, 'vipdays', '7 Dias de VIP Days', '7 Dias de VIP Days', 0),

(2160, 3, 2160, 100, 0, 0, 'item', 'Compre 100 crystals coins (1KK)', '100 Crystal Coins', 0),

(2798, 3, 2798, 20, 0, 0, 'item', 'Compre 20 Bloods Herbs para decorar sua House', 'Blood Herbs', 0),

(8884, 3, 8884, 1, 0, 0, 'item', 'Arm:15, shielding +1, protection energy -5%, ice +5%).\r\nIt can only be wielded properly by knights of level 90 or higher.', 'Oceanborn Leviathan Armor', 0),

(8890, 3, 8890, 1, 0, 0, 'item', 'You see a robe of the underworld (Arm:12, protection holy -12%, death +12%).\r\nIt can only be wielded properly by sorcerers of level 100 or higher.\r\nIt weighs 19.00 oz.', 'Robe of the underworld', 0),

(8889, 3, 8889, 1, 0, 0, 'item', 'You see a skullcracker armor (Arm:14, protection holy -5%, death +5%).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 110.00 oz.', 'Skullcracker armor', 0),

(8881, 5, 8881, 1, 0, 0, 'item', 'You see a fireborn giant armor (Arm:15, sword fighting +2, protection fire +5%, ice -5%).\r\nIt can only be wielded properly by knights of level 90 or higher.\r\nIt weighs 120.00 oz.', 'Fireborn giant armor', 0),

(2495, 5, 2495, 1, 0, 0, 'item', 'You see demon legs (Arm:9).\r\nIt weighs 54.00 oz.', 'Demon Legs', 0),

(6132, 4, 6132, 1, 0, 0, 'item', 'You see a pair of soft boots that has energy for 240 minutes left. It weighs 8.00 oz.', 'Soft Boots', 0),

(8918, 4, 8918, 1, 0, 0, 'item', 'You see a spellbook of dark mysteries (Def:16, magic level +3).\r\nIt can only be wielded properly by sorcerers and druids of level 80 or higher.\r\nIt weighs 28.50 oz.\r\nIt shows your spells and can also shield against attack when worn.', 'Spellbook of the Dark Mysteries', 0),

(8882, 5, 8882, 1, 0, 0, 'item', 'You see an earthborn titan armor (Arm:15, axe fighting +2, protection earth +5%, fire -5%).\r\nIt can only be wielded properly by knights of level 90 or higher.\r\nIt weighs 120.00 oz.', 'Earthborn titan armor', 0),

(6391, 5, 6391, 1, 0, 0, 'item', 'You see a nightmare shield (Def:37).\r\nIt weighs 32.00 oz.\r\nIt was crafted by the ancient order of the nightmare knights.', 'Nightmare Shield', 0),

(2493, 3, 2493, 1, 0, 0, 'item', 'You see a demon helmet (Arm:10).\r\nIt weighs 29.50 oz.\r\nYou hear an evil whispering from the inside.', 'Demon Helmet', 0),

(9778, 3, 9778, 1, 0, 0, 'item', 'You see a yalahari mask (Arm:5, magic level +2).\r\nIt can only be wielded properly by sorcerers and druids of level 80 or higher.\r\nIt weighs 35.00 oz.', 'Yalahari Mask', 0),

(6433, 5, 6433, 1, 0, 0, 'item', 'You see a necromancer shield (Def:37).\r\nIt weighs 32.00 oz.\r\nIt is enchanted with unholy, necromantic powers.', 'Necromancer Shield', 0),

(8888, 3, 8888, 1, 0, 0, 'item', 'You see a master archer''s armor (Arm:15, distance fighting +3).\r\nIt can only be wielded properly by paladins of level 100 or higher.\r\nIt weighs 69.00 oz.', 'Master archer''s armor', 0),

(9776, 3, 9776, 1, 0, 0, 'item', 'You see a yalahari armor (Arm:16, protection death +3%).\r\nIt can only be wielded properly by knights of level 80 or higher.\r\nIt weighs 70.00 oz.', 'Yalahari Armor', 0),

(9777, 3, 9777, 1, 0, 0, 'item', 'You see a yalahari leg piece (Arm:8, distance fighting +2, protection death +5%).\r\nIt can only be wielded properly by paladins of level 80 or higher.\r\nIt weighs 65.00 oz.', 'Yalahari Legs Piece', 0),

(8905, 5, 8905, 1, 0, 0, 'item', 'You see a rainbow shield (Def:30).\r\nIt can only be wielded properly by knights of level 100 or higher.\r\nIt weighs 69.00 oz.', 'Rainbow Shield', 0),

(8930, 5, 8930, 1, 0, 0, 'item', '(Atk:49, Def:33 +3).\r\nIt can only be wielded properly by players of level 100 or higher.\r\nIt weighs 41.00 oz.', 'Emerald Sword', 0),

(8925, 7, 8925, 1, 0, 0, 'item', 'You see a solar axe (Atk:52, Def:29 +3).\r\nIt can only be wielded properly by players of level 130 or higher.', 'Solar Axe', 0),

(9932, 5, 9932, 1, 0, 0, 'item', 'firewalker boots (Arm:2, protection fire +90%)', 'firewalker boots', 0),

(7439, 2, 7439, 1, 0, 0, 'item', 'Dá +5 de axe, club e sword skill e -10 de shielding durante 10 minutos.', 'Berserk Potion', 0),

(8851, 3, 8851, 1, 0, 0, 'item', '(Range:6, Atk +5, Hit% +3).\r\nIt can only be wielded properly by paladins of level 130 or higher.', 'Royal Crossbow', 0),

(1432, 3, 12647, 1, 0, 0, 'item', '(Def:14, magic level +3).\r\nIt can only be wielded properly by sorcerers and druids of level 100 or higher.\r\nIt shows your spells and can also shield against attacks when worn', 'Snake god''s wristguard', 0),

(2494, 2, 2494, 1, 0, 0, 'item', 'You see a demon armor (Arm:16).\r\nIt weighs 80.00 oz.', 'Demon Armor', 0),

(8266, 4, 8266, 1, 0, 0, 'item', '(protection holy -50%, death +8%).', 'Koshei''s ancient amulet', 0),

(8867, 3, 8867, 1, 0, 0, 'item', 'You see a dragon robe (Arm:12, protection fire +12%, ice -12%).\r\nIt can only be wielded properly by sorcerers.', 'Dragon Robe', 0),

(8927, 7, 8927, 1, 0, 0, 'item', 'You see a dark trinity mace (Atk:51, Def:32 -1).\r\nIt can only be wielded properly by players of level 120 or higher.\r\nIt weighs 99.00 oz.', 'Dark Trinity Mace', 0),

(8865, 4, 8865, 1, 0, 0, 'item', 'You see a dark lord''s cape (Arm:11, protection holy -8%, death +8%). Para sorcerers.', 'Dark lord''s cape', 0),

(8924, 5, 8924, 1, 0, 0, 'item', '(Atk:51, Def:28 +2).\r\nIt can only be wielded properly by players of level 110 or higher.\r\nIt weighs 88.00 oz.', 'Hellforged Axe', 0),

(12645, 4, 12645, 1, 0, 0, 'item', 'protection death +3%, distance +2', 'Elite Draken Helmet', 0),

(12643, 4, 12643, 1, 0, 0, 'item', '(Arm:10, magic level +2, protection fire +5%).\r\nIt can only be wielded properly by sorcerers and druids of level 100 or higher.\r\nIt weighs 45.00 oz', 'Royal Scale Robe', 0),

(12642, 4, 12642, 1, 0, 0, 'item', '(Arm:16, shielding +3, protection physical +5%).\r\nIt can only be wielded properly by knights of level 100 or higher.', 'Royal Draken Mail', 0),

(1254, 7, 0, 0, 0, 0, 'redskull', 'Remova seu red skull ou de seu amigo.', 'Remover Red Skull', 0);

 

 

 

 

 

O Erro è Nessa Query

 

 

 

-- phpMyAdmin SQL Dump

-- version 3.3.2deb1ubuntu1

-- http://www.phpmyadmin.net

--

-- Servidor: localhost

-- Tempo de Geração: Nov 19, 2012 as 05:59 PM

-- Versão do Servidor: 5.1.63

-- Versão do PHP: 5.3.2-1ubuntu4.18

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

 

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

 

--

-- Banco de Dados: `zenon`

--

 

-- --------------------------------------------------------

 

--

-- Estrutura da tabela `accounts`

--

 

CREATE TABLE IF NOT EXISTS `accounts` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(32) NOT NULL DEFAULT '',

`password` varchar(255) NOT NULL,

`salt` varchar(40) NOT NULL DEFAULT '',

`premdays` int(11) NOT NULL DEFAULT '0',

`lastday` int(10) unsigned NOT NULL DEFAULT '0',

`email` varchar(255) NOT NULL DEFAULT '',

`key` varchar(20) NOT NULL DEFAULT '0',

`blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',

`warnings` int(11) NOT NULL DEFAULT '0',

`group_id` int(11) NOT NULL DEFAULT '1',

`page_lastday` int(11) NOT NULL,

`email_new` varchar(255) NOT NULL,

`email_new_time` int(15) NOT NULL,

`created` int(11) NOT NULL DEFAULT '0',

`rlname` varchar(255) NOT NULL DEFAULT '',

`location` varchar(255) NOT NULL DEFAULT '',

`page_access` int(11) NOT NULL DEFAULT '0',

`email_code` varchar(255) NOT NULL DEFAULT '0',

`next_email` int(11) NOT NULL DEFAULT '0',

`premium_points` int(11) NOT NULL DEFAULT '0',

`vote` int(11) NOT NULL,

`last_post` int(11) NOT NULL DEFAULT '0',

`flag` varchar(255) NOT NULL,

`viptime` int(15) NOT NULL DEFAULT '0',

`vip_time` int(15) NOT NULL DEFAULT '0',

`vipdays` int(15) NOT NULL DEFAULT '0',

`guild_points` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9766198 ;

 

--

-- Extraindo dados da tabela `accounts`

--

 

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `viptime`, `vip_time`, `vipdays`, `guild_points`) VALUES

(1, '1', '765d7d1f3dcd58cb85c29482b2548c764caede3c', '', 65535, 0, 'eduardo.yhago@hotmail.com', '', 0, 0, 1, 1353015990, '', 0, 0, '', '', 6, '0', 0, 0, 0, 1274912789, '', 0, 0, 0, 0);

 

--

-- Gatilhos `accounts`

--

DROP TRIGGER IF EXISTS `ondelete_accounts`;

DELIMITER //

CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`

FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END

//

DELIMITER ;

 

 

 

Editado Janeiro 22, 2013 por LTKReturns

[danlpk 8]

no meu tambem deu o mesmo erro!

[edilson22 2]

no meu também, queria sabe pq n consigo abri o site para os maluko sem :8090 , ja liberei tudo , eu consigo entra sem:8090 , mais os player não ai eu coloco :8090 ai os cara consegue , help! ja liberei tudo

[AlexandreKG 134]

no meu também, queria sabe pq n consigo abri o site para os maluko sem :8090 , ja liberei tudo , eu consigo entra sem:8090 , mais os player não ai eu coloco :8090 ai os cara consegue , help! ja liberei tudo

 

Não utilize tópico dos outros para fazer uma dúvida,crie o seu com sua dúvida para tentarmos ajudar!

 

 

-Topic

 

Gente quero que todos,executem assim:

Lembrando cada query de 1 ves.

 

CREATE TABLE IF NOT EXISTS `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL,
`salt` varchar(40) NOT NULL DEFAULT '',
`premdays` int(11) NOT NULL DEFAULT '0',
`lastday` int(10) unsigned NOT NULL DEFAULT '0',
`email` varchar(255) NOT NULL DEFAULT '',
`key` varchar(20) NOT NULL DEFAULT '0',
`blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
`warnings` int(11) NOT NULL DEFAULT '0',
`group_id` int(11) NOT NULL DEFAULT '1',
`page_lastday` int(11) NOT NULL,
`email_new` varchar(255) NOT NULL,
`email_new_time` int(15) NOT NULL,
`created` int(11) NOT NULL DEFAULT '0',
`rlname` varchar(255) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`page_access` int(11) NOT NULL DEFAULT '0',
`email_code` varchar(255) NOT NULL DEFAULT '0',
`next_email` int(11) NOT NULL DEFAULT '0',
`premium_points` int(11) NOT NULL DEFAULT '0',
`vote` int(11) NOT NULL,
`last_post` int(11) NOT NULL DEFAULT '0',
`flag` varchar(255) NOT NULL,
`viptime` int(15) NOT NULL DEFAULT '0',
`vip_time` int(15) NOT NULL DEFAULT '0',
`vipdays` int(15) NOT NULL DEFAULT '0',
`guild_points` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9766198 ;

 

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `viptime`, `vip_time`, `vipdays`, `guild_points`) VALUES
(1, '1', '765d7d1f3dcd58cb85c29482b2548c764caede3c', '', 65535, 0, 'eduardo.yhago@hotmail.com', '', 0, 0, 1, 1353015990, '', 0, 0, '', '', 6, '0', 0, 0, 0, 1274912789, '', 0, 0, 0, 0);

 

DROP TRIGGER IF EXISTS `ondelete_accounts`;
DELIMITER //
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`;

 

OBS:Se der algum erro, ..... table already exists. Apenas ignorem e executem a proxima query.

Abraços,espero ter ajudado..

Atenciosamente,Mozark001.

[edilson22 2]

funfo , mais no site do guild shop da esse erro

Invalid subtopic. Can't load page.

[Piabeta Kun 359]

claro nao tem a pagina criada amigo!

[Stigal 585]

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