• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Keep getting this error..

E

Exempel

New Member
Joined
Jul 1, 2007
Messages
6
Reaction score
0
Every time i try to make a account with my account manager on my server,i keep getting this error time after time..I think there's something wrong with my SQL database,but i can't seem to fixs it,help? anyone?

hmko3.png


here's the file that i execute into my databse ..

Code: 
-- phpMyAdmin SQL Dump
-- version 2.11.1
-- [URL]http://www.phpmyadmin.net[/URL]
--
-- Servidor: localhost
-- Tempo de Geração: Fev 01, 2008 as 06:40 PM
-- Versão do Servidor: 3.23.32
-- Versão do PHP: 5.2.4


--
-- Banco de Dados: `testeot`
--

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

--
-- Estrutura da tabela `accounts`
--

CREATE TABLE `accounts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `password` varchar(255) collate latin1_general_ci NOT NULL,
  `premDays` int(11) NOT NULL default '0',
  `premEnd` int(11) NOT NULL default '0',
  `email` varchar(255) collate latin1_general_ci NOT NULL default '',
  `blocked` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12159334 ;

--
-- Extraindo dados da tabela `accounts`
--

INSERT INTO `accounts` (`id`, `password`, `premDays`, `premEnd`, `email`, `blocked`) VALUES
(121593, '121593', 15, 1202596925, '[email protected]', 0);

INSERT INTO `accounts` (`id`, `password`, `premDays`, `premEnd`, `email`, `blocked`) VALUES
(111111, 'tibia', 0, 0, '', 0);

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

--
-- Estrutura da tabela `bans`
--

CREATE TABLE `bans` (
  `type` int(11) NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban',
  `ip` int(10) unsigned NOT NULL default '0',
  `mask` int(10) unsigned NOT NULL default '4294967295',
  `player` int(10) unsigned NOT NULL default '0',
  `account` int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `bans`
--


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

--
-- Estrutura da tabela `deathlist`
--

CREATE TABLE `deathlist` (
  `player` int(21) NOT NULL default '0',
  `killer` varchar(30) collate latin1_general_ci NOT NULL default '',
  `level` int(21) NOT NULL default '0',
  `date` int(21) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `deathlist`
--


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

--
-- Estrutura da tabela `global_storage`
--

CREATE TABLE `global_storage` (
  `key` int(10) unsigned NOT NULL,
  `value` int(11) NOT NULL,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `global_storage`
--


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

--
-- Estrutura da tabela `groups`
--

CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) collate latin1_general_ci NOT NULL COMMENT 'group name',
  `flags` bigint(20) unsigned NOT NULL default '0',
  `access` int(11) NOT NULL,
  `maxdepotitems` int(11) NOT NULL,
  `maxviplist` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

--
-- Extraindo dados da tabela `groups`
--

INSERT INTO `groups` (`id`, `name`, `flags`, `access`, `maxdepotitems`, `maxviplist`) VALUES
(1, 'Player', 0, 0, 2000, 50),
(5, 'GOD', 272730398715, 5, 1000, 100),
(3, 'GM', 272730398715, 3, 2000, 50);

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

--
-- Estrutura da tabela `guilds`
--

CREATE TABLE `guilds` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) collate latin1_general_ci NOT NULL COMMENT 'guild name - nothing else needed here',
  `ownerid` int(11) NOT NULL,
  `creationdata` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Extraindo dados da tabela `guilds`
--


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

--
-- Estrutura da tabela `guild_ranks`
--

CREATE TABLE `guild_ranks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `guild_id` int(10) unsigned NOT NULL COMMENT 'guild',
  `name` varchar(255) collate latin1_general_ci NOT NULL COMMENT 'rank name',
  `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
  PRIMARY KEY  (`id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Extraindo dados da tabela `guild_ranks`
--


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

--
-- Estrutura da tabela `houses`
--

CREATE TABLE `houses` (
  `id` int(10) unsigned NOT NULL,
  `owner` int(11) NOT NULL,
  `paid` int(10) unsigned NOT NULL default '0',
  `warnings` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `houses`
--


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

--
-- Estrutura da tabela `house_lists`
--

CREATE TABLE `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `listid` int(11) NOT NULL,
  `list` text collate latin1_general_ci NOT NULL,
  KEY `house_id` (`house_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `house_lists`
--


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

--
-- Estrutura da tabela `players`
--

CREATE TABLE `players` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) collate latin1_general_ci NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL default '0',
  `premend` int(10) unsigned NOT NULL default '0',
  `sex` int(10) unsigned NOT NULL default '0',
  `vocation` int(10) unsigned NOT NULL default '0',
  `experience` int(10) unsigned NOT NULL default '0',
  `level` int(10) unsigned NOT NULL default '1',
  `maglevel` int(10) unsigned NOT NULL default '0',
  `health` int(10) unsigned NOT NULL default '100',
  `healthmax` int(10) unsigned NOT NULL default '100',
  `mana` int(10) unsigned NOT NULL default '100',
  `manamax` int(10) unsigned NOT NULL default '100',
  `manaspent` int(10) unsigned NOT NULL default '0',
  `soul` int(10) unsigned NOT NULL default '0',
  `direction` int(10) unsigned NOT NULL default '0',
  `lookbody` int(10) unsigned NOT NULL default '10',
  `lookfeet` int(10) unsigned NOT NULL default '10',
  `lookhead` int(10) unsigned NOT NULL default '10',
  `looklegs` int(10) unsigned NOT NULL default '10',
  `looktype` int(10) unsigned NOT NULL default '136',
  `lookaddons` int(10) unsigned NOT NULL default '0',
  `posx` int(11) NOT NULL default '0',
  `posy` int(11) NOT NULL default '0',
  `posz` int(11) NOT NULL default '0',
  `cap` int(11) NOT NULL default '0',
  `lastlogin` int(10) unsigned NOT NULL default '0',
  `lastip` int(10) unsigned NOT NULL default '0',
  `save` tinyint(1) NOT NULL default '1',
  `conditions` blob NOT NULL COMMENT 'drunk, poisoned etc (maybe also food and redskull)',
  `redskulltime` int(10) unsigned NOT NULL default '0',
  `redskull` tinyint(1) NOT NULL default '0',
  `guildnick` varchar(255) collate latin1_general_ci NOT NULL default '' COMMENT 'additional nick in guild - mostly for web interfaces i think',
  `loss_experience` int(11) NOT NULL default '10',
  `loss_mana` int(11) NOT NULL default '10',
  `loss_skills` int(11) NOT NULL default '10',
  `rank_id` int(11) NOT NULL COMMENT 'by this field everything with guilds is done - player has a rank which belongs to certain guild',
  `town_id` int(11) NOT NULL COMMENT 'old masterpos, temple spawn point position',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `account_id` (`account_id`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Extraindo dados da tabela `players`
--

INSERT INTO `players` (`id`, `name`, `account_id`, `group_id`, `premend`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `manamax`, `manaspent`, `soul`, `direction`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastip`, `save`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `loss_experience`, `loss_mana`, `loss_skills`, `rank_id`, `town_id`) VALUES
(2, 'GOD Testa', 121593, 5, 0, 1, 2, 185359720, 225, 8, 810, 810, 12750, 12750, 320, 10, 2, 128, 128, 128, 128, 128, 0, 451, 510, 7, 0, 1201266467, 16777343, 1, '', 0, 0, '', 0, 0, 0, 0, 1);

INSERT INTO `players` (`id`, `name`, `account_id`, `group_id`, `premend`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `manamax`, `manaspent`, `soul`, `direction`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastip`, `save`, `conditions`, `redskulltime`, `redskull`, `guildnick`, `loss_experience`, `loss_mana`, `loss_skills`, `rank_id`, `town_id`) VALUES
(2222, 'Account Manager', 111111, 0, 0, 1, 4, 4200, 8, 0, 190, 190, 40, 40, 0, 0, 0, 10, 10, 10, 10, 128, 0, 438, 504, 8, 500, 0, 1670595273, 1, '', 0, 0, '', 10, 10, 10, 0, 1);

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

--
-- Estrutura da tabela `player_addons`
--

CREATE TABLE `player_addons` (
  `player_id` int(11) NOT NULL,
  `outfit` int(11) NOT NULL,
  `addon` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_addons`
--


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

--
-- Estrutura da tabela `player_blessings`
--

CREATE TABLE `player_blessings` (
  `player_id` int(11) NOT NULL,
  `blessing` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_blessings`
--


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

--
-- Estrutura da tabela `player_depotitems`
--

CREATE TABLE `player_depotitems` (
  `player_id` int(10) unsigned NOT NULL,
  `depot_id` int(11) NOT NULL default '0',
  `sid` int(11) 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(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `player_id_2` (`player_id`,`sid`),
  KEY `player_id` (`player_id`,`depot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_depotitems`
--


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

--
-- Estrutura da tabela `player_items`
--

CREATE TABLE `player_items` (
  `player_id` int(10) unsigned NOT NULL,
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob COMMENT 'replaces unique_id, action_id, text, special_desc',
  UNIQUE KEY `player_id` (`player_id`,`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_items`
--


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

--
-- Estrutura da tabela `player_skills`
--

CREATE TABLE `player_skills` (
  `player_id` int(10) unsigned NOT NULL,
  `skillid` int(10) unsigned NOT NULL,
  `value` int(10) unsigned NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_skills`
--


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

--
-- Estrutura da tabela `player_spells`
--

CREATE TABLE `player_spells` (
  `player_id` int(10) unsigned NOT NULL,
  `name` varchar(255) collate latin1_general_ci NOT NULL,
  KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_spells`
--


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

--
-- Estrutura da tabela `player_storage`
--

CREATE TABLE `player_storage` (
  `player_id` int(10) unsigned NOT NULL,
  `key` int(11) NOT NULL,
  `value` int(11) NOT NULL,
  KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_storage`
--


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

--
-- Estrutura da tabela `player_viplist`
--

CREATE TABLE `player_viplist` (
  `player_id` int(10) unsigned NOT NULL COMMENT 'id of player whose viplist entry it is',
  `vip_id` int(10) unsigned NOT NULL COMMENT 'id of target player of viplist entry',
  KEY `player_id` (`player_id`),
  KEY `vip_id` (`vip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `player_viplist`
--


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

--
-- Estrutura da tabela `tiles`
--

CREATE TABLE `tiles` (
  `id` int(10) unsigned NOT NULL,
  `x` int(11) NOT NULL,
  `y` int(11) NOT NULL,
  `z` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `tiles`
--


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

--
-- Estrutura da tabela `tile_items`
--

CREATE TABLE `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  KEY `tile_id` (`tile_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Extraindo dados da tabela `tile_items`
--

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` = 3 AND `account` = 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 `player` = 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|

CREATE TRIGGER `onupdate_players`
AFTER UPDATE
ON `players`
FOR EACH ROW
BEGIN
    IF OLD.`lastlogin` < NEW.`lastlogin` THEN
        DELETE FROM `player_spells` WHERE `player_id` = OLD.`id`;
        DELETE FROM `player_items` WHERE `player_id` = OLD.`id`;
        DELETE FROM `player_depotitems` WHERE `player_id` = OLD.`id`;
        DELETE FROM `player_storage` WHERE `player_id` = OLD.`id`;
        DELETE FROM `player_viplist` WHERE `player_id` = OLD.`id`;
    END IF;
END|

DELIMITER ;
Is there something wrong with it ?
 
Last edited by a moderator:
Sort by date Sort by votes

Similar threads

A
  • Question
House dont saved when purchased
Replies
0
Views
176
Azerty
A
A
  • Question
Bounty Hunter System mysql error
Replies
1
Views
280
Dakos
D
J
  • Question
Myacc tfs 1.5 problem
Replies
8
Views
381
jareczekjsp
J
abdala ragab
  • Question
TFS 1.X+ I'm trying to add a VIP system Tfs 1.5
Replies
5
Views
284
Evalor
Evalor
T
  • Question
AAC Return to Mercado Pago PIX
Replies
3
Views
526
Odranoel
Odranoel
johnsamir
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
595
johnsamir
johnsamir
Albert José
  • Question
TFS 1.X+ Segmentation fault (Accessing storage value)
Replies
4
Views
241
Albert José
Albert José
Back
Top