Elio
New Member
- Joined
- Jan 22, 2011
- Messages
- 6
- Reaction score
- 1
Uso nicaw acc para avesta 7.6
El xamp version 1.6.6 (me han dicho, que es recomendable).
Error:
Pues bien llegue a crear mi web de mi servidor, ahora bien a la hora de crear un character me sale el siguiente error.
Uploaded with ImageShack.us
En la confi.Inc puse el localhost y su root debidamente, e importe las tablas.
Cuando voy a players.php como me indica arriba en la linea 250 no entiendo lo que dice.
Una captura
Uploaded with ImageShack.us
Y una captura de las tablas ya importadas
Uploaded with ImageShack.us
Desde ya saludos y suerte.
Si necesitan que les ponga algún código solo digan.
El xamp version 1.6.6 (me han dicho, que es recomendable).
Error:
Pues bien llegue a crear mi web de mi servidor, ahora bien a la hora de crear un character me sale el siguiente error.
Uploaded with ImageShack.us
En la confi.Inc puse el localhost y su root debidamente, e importe las tablas.
Cuando voy a players.php como me indica arriba en la linea 250 no entiendo lo que dice.
Una captura
Uploaded with ImageShack.us
Y una captura de las tablas ya importadas
Uploaded with ImageShack.us
PHP:
CREATE TABLE `groups` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COMMENT 'group name',
`flags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`access` INT NOT NULL,
`maxdepotitems` INT NOT NULL,
`maxviplist` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
CREATE TABLE `accounts` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
`email` VARCHAR(255) NOT NULL DEFAULT '',
`premend` INT UNSIGNED NOT NULL DEFAULT 0,
`blocked` TINYINT(1) NOT NULL DEFAULT FALSE,
`deleted` TINYINT(1) NOT NULL DEFAULT FALSE,
`warned` TINYINT(1) NOT NULL DEFAULT FALSE,
`warnings` INT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
CREATE TABLE `players` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`account_id` INT UNSIGNED NOT NULL,
`group_id` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'users group',
`sex` INT UNSIGNED NOT NULL DEFAULT 0,
`vocation` INT UNSIGNED NOT NULL DEFAULT 0,
`experience` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`level` INT UNSIGNED NOT NULL DEFAULT 1,
`maglevel` INT UNSIGNED NOT NULL DEFAULT 0,
`health` INT UNSIGNED NOT NULL DEFAULT 100,
`healthmax` INT UNSIGNED NOT NULL DEFAULT 100,
`mana` INT UNSIGNED NOT NULL DEFAULT 100,
`manamax` INT UNSIGNED NOT NULL DEFAULT 100,
`manaspent` INT UNSIGNED NOT NULL DEFAULT 0,
`soul` INT UNSIGNED NOT NULL DEFAULT 0,
`direction` INT UNSIGNED NOT NULL DEFAULT 0,
`lookbody` INT UNSIGNED NOT NULL DEFAULT 10,
`lookfeet` INT UNSIGNED NOT NULL DEFAULT 10,
`lookhead` INT UNSIGNED NOT NULL DEFAULT 10,
`looklegs` INT UNSIGNED NOT NULL DEFAULT 10,
`looktype` INT UNSIGNED NOT NULL DEFAULT 136,
`posx` INT NOT NULL DEFAULT 0,
`posy` INT NOT NULL DEFAULT 0,
`posz` INT NOT NULL DEFAULT 0,
`cap` INT NOT NULL DEFAULT 0,
`lastlogin` INT UNSIGNED NOT NULL DEFAULT 0,
`lastip` INT UNSIGNED NOT NULL DEFAULT 0,
`save` TINYINT(1) NOT NULL DEFAULT TRUE,
`conditions` BLOB NOT NULL COMMENT 'drunk, poisoned etc (maybe also food and redskull)',
`redskulltime` INT UNSIGNED NOT NULL DEFAULT 0,
`redskull` TINYINT(1) NOT NULL DEFAULT FALSE,
`guildnick` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'additional nick in guild - mostly for web interfaces i think',
`loss_experience` INT NOT NULL DEFAULT 10,
`loss_mana` INT NOT NULL DEFAULT 10,
`loss_skills` INT NOT NULL DEFAULT 10,
`loss_items` INT NOT NULL DEFAULT 10,
`rank_id` INT UNSIGNED NOT NULL COMMENT 'by this field everything with guilds is done - player has a rank which belongs to certain guild',
`town_id` INT NOT NULL COMMENT 'old masterpos, temple spawn point position',
`balance` INT NOT NULL DEFAULT 0 COMMENT 'money balance of the player for houses paying',
`status` TINYINT(1) NOT NULL DEFAULT FALSE,
PRIMARY KEY (`id`),
UNIQUE (`name`),
FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE = InnoDB;
CREATE TABLE `guilds` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COMMENT 'guild name - nothing else needed here',
`ownerid` INT NOT NULL,
`creationdata` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
CREATE TABLE `guild_ranks` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`guild_id` INT UNSIGNED NOT NULL COMMENT 'guild',
`name` VARCHAR(255) NOT NULL COMMENT 'rank name',
`level` INT NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
PRIMARY KEY (`id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `player_viplist` (
`player_id` INT UNSIGNED NOT NULL COMMENT 'id of player whose viplist entry it is',
`vip_id` INT UNSIGNED NOT NULL COMMENT 'id of target player of viplist entry',
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `player_spells` (
`player_id` INT UNSIGNED NOT NULL,
`name` VARCHAR(255) NOT NULL,
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `server_record` (
`record` INT UNSIGNED NOT NULL,
PRIMARY KEY(`record`)
) ENGINE = InnoDB;
INSERT INTO `server_record` VALUES (0);
CREATE TABLE `player_storage` (
`player_id` INT UNSIGNED NOT NULL,
`key` INT NOT NULL,
`value` INT NOT NULL,
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `player_skills` (
`player_id` INT UNSIGNED NOT NULL,
`skillid` INT UNSIGNED NOT NULL,
`value` INT UNSIGNED NOT NULL DEFAULT 0,
`count` INT UNSIGNED NOT NULL DEFAULT 0,
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `player_items` (
`player_id` INT UNSIGNED NOT NULL,
`sid` INT NOT NULL,
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB COMMENT 'replaces unique_id, action_id, text, special_desc',
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
UNIQUE (`player_id`, `sid`)
) ENGINE = InnoDB;
CREATE TABLE `houses` (
`id` INT UNSIGNED NOT NULL,
`owner` INT NOT NULL,
`paid` INT UNSIGNED NOT NULL DEFAULT 0,
`warnings` INT NOT NULL DEFAULT 0,
`lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
CREATE TABLE `house_lists` (
`house_id` INT UNSIGNED NOT NULL,
`listid` INT NOT NULL,
`list` TEXT NOT NULL,
FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `bans` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`type` INT NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban',
`value` INT UNSIGNED NOT NULL COMMENT 'ip, player guid, account number',
`param` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'mask',
`active` TINYINT(1) NOT NULL DEFAULT TRUE,
`expires` INT UNSIGNED NOT NULL,
`added` INT UNSIGNED NOT NULL,
`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
`reason` VARCHAR(255) NOT NULL DEFAULT '',
`comment` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY (`type`, `value`),
KEY (`expires`)
) ENGINE = InnoDB;
CREATE TABLE `tiles` (
`id` INT UNSIGNED NOT NULL,
`x` INT NOT NULL,
`y` INT NOT NULL,
`z` INT NOT NULL,
PRIMARY KEY(`id`)
) ENGINE = InnoDB;
CREATE TABLE `tile_items` (
`tile_id` INT UNSIGNED NOT NULL,
`sid` INT NOT NULL,
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE,
INDEX (`sid`)
) ENGINE = InnoDB;
CREATE TABLE `map_store` (
`house_id` INT UNSIGNED NOT NULL,
`data` BLOB NOT NULL,
KEY(`house_id`)
) ENGINE = InnoDB;
CREATE TABLE `player_depotitems` (
`player_id` INT UNSIGNED NOT NULL,
`depot_id` INT NOT NULL DEFAULT 0,
`sid` INT NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
INDEX (`player_id`, `depot_id`),
UNIQUE (`player_id`, `sid`)
) ENGINE = InnoDB;
CREATE TABLE `player_deaths` (
`player_id` INT UNSIGNED NOT NULL,
`time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`level` INT UNSIGNED NOT NULL DEFAULT 1,
`lasthit_killer` VARCHAR(255) NOT NULL,
`mostdamage_killer` VARCHAR(255) NOT NULL,
KEY (`player_id`),
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;
CREATE TABLE `global_storage` (
`key` INT UNSIGNED NOT NULL,
`value` INT NOT NULL,
PRIMARY KEY(`key`)
) ENGINE = InnoDB;
CREATE TABLE `schema_info` (
`version` INT UNSIGNED NOT NULL
) ENGINE = InnoDB;
INSERT INTO `schema_info` (`version`) VALUES (2);
DELIMITER |
CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `type` = 3 AND `value` = OLD.`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`);
DELETE FROM `guild_ranks` WHERE `guild_id` = OLD.`id`;
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|
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 `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|
DELIMITER ;
Desde ya saludos y suerte.
Si necesitan que les ponga algún código solo digan.
Last edited: