xTibia

.com
VI

[GESIOR] VictorWEBMaster 2019v

Por VictorWEBMaster, 22 de jul. de 2012 em Websites & Layouts

gesior
website
otserver
victor;
otserv
tibia
920
200.1k
VictorWEBMasterV
14 de dezembro de 2013 às 15:44

aeww.... deu certinho agora.... xD vlw mesmo rep+.... (removido ja achei o lugar xD)

 

 

nesses mostros q estao com um x de erro como faço pra arrumar ?

 

X de No Image? Só colocar a imagem deles na pasta images/monsters/

Editado Dezembro 14 por VictorWebMaster

maper1M
14 de dezembro de 2013 às 20:32

deu certo aki porem achei um outro problema... quando eu ligo o xampp até ai bl, eu desligo ele e beleza, porem quando eu ligo o xampp pela 2ª vez e aperto start em Mysql da esse erro e ele não carrega...

 

20:30:22 [mysql] Error: MySQL shutdown unexpectedly.
20:30:22 [mysql] This may be due to a blocked port, missing dependencies,
20:30:22 [mysql] improper privileges, a crash, or a shutdown by another method.
20:30:22 [mysql] Press the Logs button to view error logs and check
20:30:22 [mysql] the Windows Event Viewer for more clues
20:30:22 [mysql] If you need more help, copy and post this
20:30:22 [mysql] entire log window on the forums
fica so o apache ligado... oq eu faço ???
eu achei um site q ensina arrumar isso so n sei se é certo... ele fala pra apagar:

Ei, eu só fiz isso e deu certo:

  1. saída servidor Xampp
  2. ir para o seu C: \ xampp \ mysql \ data
  3. excluir o ibdata1 arquivo
  4. restart servidor xampp

Ele deve funcionar

so q toda vez q eu fecho o xampp esse arquivo volta....

affs so q agora aparece isso:

Erro fatal : Uncaught exceção 'PDOException "com mensagem' SQLSTATE [42S02]: tabela base ou exibição não encontrado: 1146 Table 'otserverr.accounts' não existe 'em C: \ xampp \ htdocs \ pot \ OTS_Account.php: 237 Rastreamento de pilha: # 0 C: \ xampp \ htdocs \ pot \ OTS_Account.php (237): PDO-> query ('SELECT `id`, `n ...') # 1 C: \ xampp \ htdocs \ index. php (24): OTS_Account-> load ('8395385 ') # 2 {main} jogado em C: \ xampp \ htdocs \ pot \ OTS_Account.php na linha 237

¬¬" negocio complicado.... kkkk



Editado Dezembro 14 por maper1
mapperproM
15 de dezembro de 2013 às 00:06


Vitão não esquece do meu pedido mano kkkk brinks


E aí, como que tá o negócio dos worldid ? 


Desculpa a ansiedade rsrs


VictorWEBMasterV
15 de dezembro de 2013 às 21:15




Vitão não esquece do meu pedido mano kkkk brinks


E aí, como que tá o negócio dos worldid ? 


Desculpa a ansiedade rsrs




 


Evoluindo com novo website!!


mapperproM
16 de dezembro de 2013 às 00:13
blz...
maper1M
17 de dezembro de 2013 às 18:20


Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 41 

Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 55 

Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 64


 


como arruma ??


Editado Dezembro 18 por maper1
VictorWEBMasterV
19 de dezembro de 2013 às 00:37




Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 41 


 


Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 55 


 


Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 64


 


como arruma ??




 


Baixe a ultima versão do XAMPP.


kinglekkeK
19 de dezembro de 2013 às 09:06


da 1 ajuda aew vitor to com o seguinte erro meio que exclui o account manage oque eu faso ?


 


 








STEP 4


Add samples to DB:


Query: SELECT `id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Account Managerarrow-10x10.png' SQLSTATE: 00000 Driver code:   Error message:   Error occured!


Error ID: 
More info: Character Account Manager does not exist. Cannot install sample characters!


File: C:\xampp\htdocs/install.php   Line: 374






 


vinnevinneV
19 de dezembro de 2013 às 09:11




 




 




 




o erro q da no vertrigo 


 


 








Erro


consulta SQL:


 


DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` IN ( 3, 4 ) AND `value` = OLD.`id` ;


 


 


Mensagens do MySQL : Documentação


 


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |


 


CREATE TRIGGER `ondelete_accounts`


BEFORE DELETE


ON `accounts`


' at line 1






 


 


 


minha mysql:


 


 


 








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`;


DROP TABLE IF EXISTS `account_viplist`;


 


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 `account_viplist`


(


`account_id` INT NOT NULL,


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


`player_id` INT NOT NULL,


KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),


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


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


) ENGINE = InnoDB;


 


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', 23);


 


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 NOT NULL DEFAULT 1,


`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`),


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


) ENGINE = InnoDB;


 


DELIMITER |


 


CREATE TRIGGER `ondelete_accounts`


BEFORE DELETE


ON `accounts`


FOR EACH ROW


BEGIN


DELETE FROM `bans` WHERE `type` IN (3, 4) 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` IN (2, 5) AND `value` = OLD.`id`;


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


END|


 


DELIMITER ;






 




up


 




#up


 




 




Importou a DB no topico? Se não ... 


 


 


 


 


fiz td sertinho igual ao tutorial q eu vi


Editado Dezembro 19 por vinnevinne
snurexxS
19 de dezembro de 2013 às 09:17
Esse funciona no 8.6?
maper1M
19 de dezembro de 2013 às 16:36
victor eu ja to com a versão atualizada so xampp .1,8,3 e do control panelv 3.2.1
Editado Dezembro 19 por maper1
VictorWEBMasterV
19 de dezembro de 2013 às 23:34


Esse funciona no 8.6?


Sim


 


victor eu ja to com a versão atualizada so xampp .1,8,3 e do control panelv 3.2.1


Vou verificar..


snurexxS
20 de dezembro de 2013 às 10:43


Estou com o mesmo problema do maper 1 com a última versão do Xampp instalada.
Fica nessa tela:


Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 

Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 

Notice : Undefined index: página em C: \ xampp \ htdocs \ install.php on-line 


só que no meu caso os números são outros.


Editado Dezembro 20 por Shirocake
maper1M
20 de dezembro de 2013 às 17:25
retirado...
Editado Dezembro 21 por maper1
Enzo CaueE
21 de dezembro de 2013 às 13:20


	Objeto não encontrado!


A URL requisitada não foi encontrada neste servidor. O link na página referida parece estar com algum erro ou desatualizado. Por favor informe o autor desta página sobre o erro.


Se você acredita ter encontrado um problema no servidor, por favor entre em contato com o webmaster.
	Error 404	localhost
21/12/2013 13:18:26


	Apache/2.2.12 (Win32) DAV/2 mod_ssl/2.2.12 OpenSSL/0.9.8k mod_autoindex_color PHP/5.3.0 mod_perl/2.0.4 Perl/v5.10.0


 


	help ai