8.5 Delton Ot V2 (31/07/2009)

[luisfe23 199]

Delton da esse erro e não salva:

 

[14/07/2009 12:00:08] GOD Snowz has logged in.

 

[14/07/2009 12:00:08] Lua Script Error: [CreatureScript Interface]

[14/07/2009 12:00:08] buffer

 

[14/07/2009 12:00:08] [string "loadBuffer"]:3: attempt to index global 'config' (a nil value)

[14/07/2009 12:03:05] GOD Snowz has logged out.

[14/07/2009 12:03:06] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 2; - MYSQL ERROR: Table 'theforgottenserver.player_depotitems' doesn't exist (1146)

[14/07/2009 12:03:06] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 2; - MYSQL ERROR: Table 'theforgottenserver.player_depotitems' doesn't exist (1146)

[14/07/2009 12:03:06] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 2; - MYSQL ERROR: Table 'theforgottenserver.player_depotitems' doesn't exist (1146)

[14/07/2009 12:03:06] Error while saving player: GOD Snowz.

[14/07/2009 12:03:07] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1; - MYSQL ERROR: Table 'theforgottenserver.bans' doesn't exist (1146)

[14/07/2009 12:03:07] mysql_real_query(): SELECT `id` FROM `bans` WHERE `value` = 2 AND `type` = 2 AND `active` = 1; - MYSQL ERROR: Table 'theforgottenserver.bans' doesn't exist (1146)

[14/07/2009 12:03:07] mysql_real_query(): SELECT `id`, `type`, `param`, `expires`, `added`, `admin_id`, `comment`, `reason`, `action`, `statement` FROM `bans` WHERE `value` = 2 AND `type` NOT IN (4) AND `active` = 1 AND (`expires` > 1247583787 OR `expires` <= 0); - MYSQL ERROR: Table 'theforgottenserver.bans' doesn't exist (1146)

[14/07/2009 12:03:07] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 2 ORDER BY `sid` DESC; - MYSQL ERROR: Table 'theforgottenserver.player_depotitems' doesn't exist (1146)

 

 

Pode me ajudar a resolver?

 

Obrigado

Editado Julho 14, 2009 por luisfe23

[delton 6]

Snowz

 

Cara, percebi que você não está utilizando mysql!, ou seja ele não vai funcionar corretamente, utilize Mysql =)

 

 

Delton~~

[meleca125 0]

faz um tutorial de como bota black skull pz e fight nova

plx

Respond

[Tonynh 514]

Cara, seus ot's ja ficam legais.. e ainda você adicionou o Black Skull

 

Parabéns ^^

Ficou maneiro

 

Bom trabalho..

 

Att,

Tonynh

[HeXo 2]

Delton da esse erro e não salva:

 

 

 

 

Pode me ajudar a resolver?

 

Obrigado

Snowz, você tem que usar o MYSQL DUMP do Delton, vc n pode usar o schema.mysql de otro OT que nao vai funfar, porque o ot do delton tem Triggers novas na Table do Mysql.

 

Faça assim:

Delete sua table "theforgottenserver", e depois crie ela denovo.

Salve o que está no spoil abaixo como delton.mysql e depois importe-o para a table que vc acabou de criar.

 

DROP TRIGGER IF EXISTS `oncreate_players`;

DROP TRIGGER IF EXISTS `oncreate_guilds`;

DROP TRIGGER IF EXISTS `ondelete_players`;

DROP TRIGGER IF EXISTS `ondelete_guilds`;

DROP TRIGGER IF EXISTS `ondelete_accounts`;

 

DROP TABLE IF EXISTS `player_depotitems`;

DROP TABLE IF EXISTS `tile_items`;

DROP TABLE IF EXISTS `tiles`;

DROP TABLE IF EXISTS `bans`;

DROP TABLE IF EXISTS `house_lists`;

DROP TABLE IF EXISTS `houses`;

DROP TABLE IF EXISTS `player_items`;

DROP TABLE IF EXISTS `player_namelocks`;

DROP TABLE IF EXISTS `player_skills`;

DROP TABLE IF EXISTS `player_storage`;

DROP TABLE IF EXISTS `player_viplist`;

DROP TABLE IF EXISTS `player_spells`;

DROP TABLE IF EXISTS `player_deaths`;

DROP TABLE IF EXISTS `killers`;

DROP TABLE IF EXISTS `environment_killers`;

DROP TABLE IF EXISTS `player_killers`;

DROP TABLE IF EXISTS `guild_ranks`;

DROP TABLE IF EXISTS `guilds`;

DROP TABLE IF EXISTS `guild_invites`;

DROP TABLE IF EXISTS `global_storage`;

DROP TABLE IF EXISTS `players`;

DROP TABLE IF EXISTS `accounts`;

DROP TABLE IF EXISTS `server_record`;

DROP TABLE IF EXISTS `server_motd`;

DROP TABLE IF EXISTS `server_reports`;

DROP TABLE IF EXISTS `server_config`;

 

CREATE TABLE `accounts`

(

`id` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(32) NOT NULL DEFAULT \'\',

`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT \'MD5\'*//* VARCHAR(40) NOT NULL COMMENT \'SHA1\'*/,

`premdays` INT NOT NULL DEFAULT 0,

`lastday` INT UNSIGNED NOT NULL DEFAULT 0,

`email` VARCHAR(255) NOT NULL DEFAULT \'\',

`key` VARCHAR(20) NOT NULL DEFAULT \'0\',

`blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT \'internal usage\',

`warnings` INT NOT NULL DEFAULT 0,

`group_id` INT NOT NULL DEFAULT 1,

PRIMARY KEY (`id`), UNIQUE (`name`)

) ENGINE = InnoDB;

 

INSERT INTO `accounts` VALUES (1, \'1\', \'1\', 65535, 0, \'\', \'0\', 0, 0, 1);

 

CREATE TABLE `players`

(

`id` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(255) NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`group_id` INT NOT NULL DEFAULT 1,

`account_id` INT NOT NULL DEFAULT 0,

`level` INT NOT NULL DEFAULT 1,

`vocation` INT NOT NULL DEFAULT 0,

`health` INT NOT NULL DEFAULT 150,

`healthmax` INT NOT NULL DEFAULT 150,

`experience` BIGINT NOT NULL DEFAULT 0,

`lookbody` INT NOT NULL DEFAULT 0,

`lookfeet` INT NOT NULL DEFAULT 0,

`lookhead` INT NOT NULL DEFAULT 0,

`looklegs` INT NOT NULL DEFAULT 0,

`looktype` INT NOT NULL DEFAULT 136,

`lookaddons` INT NOT NULL DEFAULT 0,

`maglevel` INT NOT NULL DEFAULT 0,

`mana` INT NOT NULL DEFAULT 0,

`manamax` INT NOT NULL DEFAULT 0,

`manaspent` INT NOT NULL DEFAULT 0,

`soul` INT UNSIGNED NOT NULL DEFAULT 0,

`town_id` INT NOT NULL DEFAULT 0,

`posx` INT NOT NULL DEFAULT 0,

`posy` INT NOT NULL DEFAULT 0,

`posz` INT NOT NULL DEFAULT 0,

`conditions` BLOB NOT NULL,

`cap` INT NOT NULL DEFAULT 0,

`sex` INT NOT NULL DEFAULT 0,

`lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,

`lastip` INT UNSIGNED NOT NULL DEFAULT 0,

`save` TINYINT(1) NOT NULL DEFAULT 1,

`skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

`skulltime` INT NOT NULL DEFAULT 0,

`rank_id` INT NOT NULL DEFAULT 0,

`guildnick` VARCHAR(255) NOT NULL DEFAULT \'\',

`lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,

`blessings` TINYINT(2) NOT NULL DEFAULT 0,

`balance` BIGINT NOT NULL DEFAULT 0,

`stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT \'stored in miliseconds\',

`direction` INT NOT NULL DEFAULT 2,

`loss_experience` INT NOT NULL DEFAULT 100,

`loss_mana` INT NOT NULL DEFAULT 100,

`loss_skills` INT NOT NULL DEFAULT 100,

`loss_containers` INT NOT NULL DEFAULT 100,

`loss_items` INT NOT NULL DEFAULT 100,

`premend` INT NOT NULL DEFAULT 0 COMMENT \'NOT IN USE BY THE SERVER\',

`online` TINYINT(1) NOT NULL DEFAULT 0,

`marriage` INT UNSIGNED NOT NULL DEFAULT 0,

`promotion` INT NOT NULL DEFAULT 0,

`deleted` TINYINT(1) NOT NULL DEFAULT FALSE,

`description` VARCHAR(255) NOT NULL DEFAULT \'\',

PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),

KEY (`account_id`), KEY (`group_id`),

KEY (`online`), KEY (`deleted`),

FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

INSERT INTO `players` VALUES (1, \'Account Manager\', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, \'\', 400, 0, 0, 0, 0, 0, 0, 0, \'\', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, \'\');

 

CREATE TABLE `player_deaths`

(

`id` INT NOT NULL AUTO_INCREMENT,

`player_id` INT NOT NULL,

`date` BIGINT UNSIGNED NOT NULL,

`level` INT UNSIGNED NOT NULL,

PRIMARY KEY (`id`), INDEX (`date`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_depotitems`

(

`player_id` INT NOT NULL,

`sid` INT NOT NULL COMMENT \'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots\',

`pid` INT NOT NULL DEFAULT 0,

`itemtype` INT NOT NULL,

`count` INT NOT NULL DEFAULT 0,

`attributes` BLOB NOT NULL,

KEY (`player_id`), UNIQUE (`player_id`, `sid`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_items`

(

`player_id` INT NOT NULL DEFAULT 0,

`pid` INT NOT NULL DEFAULT 0,

`sid` INT NOT NULL DEFAULT 0,

`itemtype` INT NOT NULL DEFAULT 0,

`count` INT NOT NULL DEFAULT 0,

`attributes` BLOB NOT NULL,

KEY (`player_id`), UNIQUE (`player_id`, `sid`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_namelocks`

(

`player_id` INT NOT NULL DEFAULT 0,

`name` VARCHAR(255) NOT NULL,

`new_name` VARCHAR(255) NOT NULL,

`date` BIGINT NOT NULL DEFAULT 0,

KEY (`player_id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_skills`

(

`player_id` INT NOT NULL DEFAULT 0,

`skillid` TINYINT(2) NOT NULL DEFAULT 0,

`value` INT UNSIGNED NOT NULL DEFAULT 0,

`count` INT UNSIGNED NOT NULL DEFAULT 0,

KEY (`player_id`), UNIQUE (`player_id`, `skillid`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_spells`

(

`player_id` INT NOT NULL,

`name` VARCHAR(255) NOT NULL,

KEY (`player_id`), UNIQUE (`player_id`, `name`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_storage`

(

`player_id` INT NOT NULL DEFAULT 0,

`key` INT UNSIGNED NOT NULL DEFAULT 0,

`value` VARCHAR(255) NOT NULL DEFAULT \'0\',

KEY (`player_id`), UNIQUE (`player_id`, `key`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_viplist`

(

`player_id` INT NOT NULL,

`vip_id` INT NOT NULL,

KEY (`player_id`), KEY (`vip_id`), UNIQUE (`player_id`, `vip_id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `killers`

(

`id` INT NOT NULL AUTO_INCREMENT,

`death_id` INT NOT NULL,

`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

PRIMARY KEY (`id`),

FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `player_killers`

(

`kill_id` INT NOT NULL,

`player_id` INT NOT NULL,

FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `environment_killers`

(

`kill_id` INT NOT NULL,

`name` VARCHAR(255) NOT NULL,

FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `houses`

(

`id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`owner` INT NOT NULL,

`paid` INT UNSIGNED NOT NULL DEFAULT 0,

`warnings` INT NOT NULL DEFAULT 0,

`lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,

`name` VARCHAR(255) NOT NULL,

`town` INT UNSIGNED NOT NULL DEFAULT 0,

`size` INT UNSIGNED NOT NULL DEFAULT 0,

`price` INT UNSIGNED NOT NULL DEFAULT 0,

`rent` INT UNSIGNED NOT NULL DEFAULT 0,

`doors` INT UNSIGNED NOT NULL DEFAULT 0,

`beds` INT UNSIGNED NOT NULL DEFAULT 0,

`tiles` INT UNSIGNED NOT NULL DEFAULT 0,

`guild` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

`clear` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

UNIQUE (`id`, `world_id`)

) ENGINE = InnoDB;

 

CREATE TABLE `house_auctions`

(

`house_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`player_id` INT NOT NULL,

`bid` INT UNSIGNED NOT NULL DEFAULT 0,

`limit` INT UNSIGNED NOT NULL DEFAULT 0,

`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,

UNIQUE (`house_id`, `world_id`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,

FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `house_lists`

(

`house_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`listid` INT NOT NULL,

`list` TEXT NOT NULL,

UNIQUE (`house_id`, `world_id`, `listid`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `house_data`

(

`house_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`data` LONGBLOB NOT NULL,

UNIQUE (`house_id`, `world_id`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `tiles`

(

`id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`house_id` INT UNSIGNED NOT NULL,

`x` INT(5) UNSIGNED NOT NULL,

`y` INT(5) UNSIGNED NOT NULL,

`z` TINYINT(2) UNSIGNED NOT NULL,

UNIQUE (`id`, `world_id`),

KEY (`x`, `y`, `z`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `tile_items`

(

`tile_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`sid` INT NOT NULL,

`pid` INT NOT NULL DEFAULT 0,

`itemtype` INT NOT NULL,

`count` INT NOT NULL DEFAULT 0,

`attributes` BLOB NOT NULL,

UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),

FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `guilds`

(

`id` INT NOT NULL AUTO_INCREMENT,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`name` VARCHAR(255) NOT NULL,

`ownerid` INT NOT NULL,

`creationdata` INT NOT NULL,

`motd` VARCHAR(255) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE (`name`, `world_id`)

) ENGINE = InnoDB;

 

CREATE TABLE `guild_invites`

(

`player_id` INT NOT NULL DEFAULT 0,

`guild_id` INT NOT NULL DEFAULT 0,

UNIQUE (`player_id`, `guild_id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

CREATE TABLE `guild_ranks`

(

`id` INT NOT NULL AUTO_INCREMENT,

`guild_id` INT NOT NULL,

`name` VARCHAR(255) NOT NULL,

`level` INT NOT NULL COMMENT \'1 - leader, 2 - vice leader, 3 - member\',

PRIMARY KEY (`id`),

FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

 

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;

 

CREATE TABLE `global_storage`

(

`key` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`value` VARCHAR(255) NOT NULL DEFAULT \'0\',

UNIQUE (`key`, `world_id`)

) ENGINE = InnoDB;

 

CREATE TABLE `server_config`

(

`config` VARCHAR(35) NOT NULL DEFAULT \'\',

`value` INT NOT NULL,

UNIQUE (`config`)

) ENGINE = InnoDB;

 

INSERT INTO `server_config` VALUES (\'db_version\', 20);

 

CREATE TABLE `server_motd`

(

`id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`text` TEXT NOT NULL,

UNIQUE (`id`, `world_id`)

) ENGINE = InnoDB;

 

INSERT INTO `server_motd` VALUES (1, 0, \'Welcome to The Forgotten Server!\');

 

CREATE TABLE `server_record`

(

`record` INT NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`timestamp` BIGINT NOT NULL,

UNIQUE (`record`, `world_id`, `timestamp`)

) ENGINE = InnoDB;

 

INSERT INTO `server_record` VALUES (0, 0, 0);

 

CREATE TABLE `server_reports`

(

`id` INT NOT NULL AUTO_INCREMENT,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`player_id` INT UNSIGNED NOT NULL DEFAULT 0,

`posx` INT NOT NULL DEFAULT 0,

`posy` INT NOT NULL DEFAULT 0,

`posz` INT NOT NULL DEFAULT 0,

`timestamp` BIGINT NOT NULL DEFAULT 0,

`report` TEXT NOT NULL,

`reads` INT NOT NULL DEFAULT 0,

PRIMARY KEY (`id`),

KEY (`world_id`), KEY (`reads`)

) ENGINE = InnoDB;

 

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|

 

CREATE TRIGGER `oncreate_guilds`

AFTER INSERT

ON `guilds`

FOR EACH ROW

BEGIN

INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES (\'Leader\', 3, NEW.`id`);

INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES (\'Vice-Leader\', 2, NEW.`id`);

INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES (\'Member\', 1, NEW.`id`);

END|

 

CREATE TRIGGER `ondelete_guilds`

BEFORE DELETE

ON `guilds`

FOR EACH ROW

BEGIN

UPDATE `players` SET `guildnick` = \'\', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);

END|

 

CREATE TRIGGER `oncreate_players`

AFTER INSERT

ON `players`

FOR EACH ROW

BEGIN

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);

END|

 

CREATE TRIGGER `ondelete_players`

BEFORE DELETE

ON `players`

FOR EACH ROW

BEGIN

DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`;

UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;

END|

 

DELIMITER ;

Isso deve resolver, se não conseguir me mande uma MP que eu te ajudo pelo MSN.

Editado Julho 15, 2009 por HeXo

[meleca125 0]

faz um tuto de como botar black skull e icone de pz

plx

[delton 6]

Meleca não entendi? Oo, para colocar Pz icon e black skull vc prescisa modificar as sources, e não existe um tutorial explicando isso não =).

[HeXo 2]

Delton, o seu OT está de parabéns, todos as novas funçoes funcionando direitinho e tudo mais!!

 

So estou recebendo este erro:

[15/07/2009 22:01:29] Lua Script Error: [CreatureScript Interface] 
[15/07/2009 22:01:29] buffer

[15/07/2009 22:01:29] [string "loadBuffer"]:3: attempt to index global 'config' (a nil value)

Na verdade não faz muita diferença, não está atrapalhando em nada o OT, só que está enchendo minha GUI com estes erros.

Percebi que é um erro no CreatureScript, então pesquisei por lá, mas não achei nada com "loadBuffer" lá.

Pode me ajudar com isto??

 

Valeu!

 

~edit:

Os erros estão na nova função "MODS", porém como eu não conheço esta nova função, não faço ideia de como arrumar.

Alguem aí teria uma ideia de como arrumar isto??

 

Valeu!!

Editado Julho 18, 2009 por HeXo

[meleca125 0]

Meleca não entendi? Oo, para colocar Pz icon e black skull vc prescisa modificar as sources, e não existe um tutorial explicando isso não =).

Como mexe nas sources pd me explicar to presisando muito

[HeXo 2]

Delton, o seu OT está de parabéns, todos as novas funçoes funcionando direitinho e tudo mais!!

 

So estou recebendo este erro:

[15/07/2009 22:01:29] Lua Script Error: [CreatureScript Interface] 
[15/07/2009 22:01:29] buffer

[15/07/2009 22:01:29] [string "loadBuffer"]:3: attempt to index global 'config' (a nil value)

...

Bom, mesmo não tendo recebido a ajuda de ninguem, consegui resolver meu problema e agora deixo aqui a solução para o mesmo:

 

Abra a pasta "mods", nela abra os arquivos "buypremium_command.xml"; "changender_command.xml" e "highscorebook.xml" dentro deles procure por event="buffer" mude para event="think". Salve.

 

Agora ainda na pasta "mods", abra o arquivo "firstitems.xml" dentro dele procura por event="buffer", mude para event="login". Salve.

 

Atenciosamente.

HeXo

Editado Julho 18, 2009 por HeXo

[gspinazzola 0]

Delton sou novato em ots, porem consegui fazer a configuração no mysql e rodar o ot só q o account manager não funciona tipo vc poe 1/1 e num aparece nada me ajuda ai.

Vlws :smile_positivo:

[delton 6]

HeXo

Obrigado por postar isso, eu iria postar pois com muitas atualizações é dificil vim aqui e explicar =)

 

Em breve versões para Sqlite, mas ta muiiito dificil e a equipe do TFS estpa demorando um pouco para lançarem versões para Private SVN =X

 

Enquanto isso to mexendo no Thyrania =)

[brunozd 0]

Eii veio Por favor me Pssa o seu MAP EDITOR!! POSTA ELE AE NO SITE EU NUM ACHEI NENHUM!! VLW =)

 

O Delton Ajuda aki pareiro... é q estou kerendo o MAP EDITOR 8.50 ... e num tem nenhuma... =/ plz posta o seu ae... xD vlw's =)

[HeXo 2]

Eii veio Por favor me Pssa o seu MAP EDITOR!! POSTA ELE AE NO SITE EU NUM ACHEI NENHUM!! VLW =)

 

O Delton Ajuda aki pareiro... é q estou kerendo o MAP EDITOR 8.50 ... e num tem nenhuma... =/ plz posta o seu ae... xD vlw's =)

http://remeresmapeditor.com/

esse ai é 8.5 ...

[brunozd 0]

http://remeresmapeditor.com/

esse ai é 8.5 ...

 

 

PO Veio vlw ae... xD Seu OT mt massa... so tem q arrumar uns bugs mais vc ta cuidando disso !! xD