creio que no config.lua ta para conectar com msqyl e não com sql
sei lá, não entendo muito disso
JO
[Encerrado] por que da esse erro na hora de abrir o serve dbko arena
Por joseanpereira, 19 de ago. de 2013 em Tópicos Sem Resposta
resolvido
25
2k
info
Grupo: Infante
Registrado: 25/01/12
Posts: 1.6k
Reputação: +330
19 de agosto de 2013 às 17:59
info
Grupo: Conde
Registrado: 25/04/12
Posts: 752
Reputação: +125
Gênero: Masculino
21 de agosto de 2013 às 03:12
Por acaso voce tá usando pelo SQLITE ou pelo XAMP/Vertrigo lá(MYSQL)?
Se for MYSQL a senha do usuário deve estar errada...
Configure assim: MYSQ
sqlType = "mysq" sqlHost = "localhost" -- TENTE TROCAR PARA "127.0.0.1" sqlPort = 3306 sqlUser = "root" -- NOME DO USUÁRIO ( padrão é root ) sqlPass = "A SENHA DO URUÁRIO AQUI" sqlDatabase = "DataBaseDoOt" -- o nome do banco de dados que você criou... sqlFile = "theforgottenserver.s3db" -- isso não importa!
Editado Agosto 21 por Cleberadm
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
21 de agosto de 2013 às 06:41
eu n estou usando nenhum site
info
Grupo: Conde
Registrado: 25/04/12
Posts: 752
Reputação: +125
Gênero: Masculino
21 de agosto de 2013 às 06:48
Então muda o sqlType = "mysq"
para sqlType = "sqlite"
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
25 de agosto de 2013 às 14:28
onde eu mudo?
info
Grupo: Cavaleiro
Registrado: 12/10/09
Posts: 160
Reputação: +19
Gênero: Masculino
26 de agosto de 2013 às 05:20
PASTA DO OT/CONFIG.LUA
PROCURA A PARTE
....
sqlType = "mysql" E TROQUE POR sqlType = "sqlite" , ou baixe 1 xamp ou algo que crie database mysql
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
26 de agosto de 2013 às 11:01
eu tenho aki o xamp me ensina ai como eu crio eu n achei no configure sqlType
info
Grupo: Conde
Registrado: 25/04/12
Posts: 752
Reputação: +125
Gênero: Masculino
26 de agosto de 2013 às 11:18
posta seu congif.lua que arrumo pra voce, nao precisa criar site nao...
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
26 de agosto de 2013 às 11:56
okei meu configure a baixo
-------- config.lua --------
-- Config file for OTServ --
----------------------------
-- data directory location
datadir = "data/"
-- map location
map = "data/world/WoDBO 2.51.otbm"
-- mapkind
-- options: OTBM for binary map, XML for OTX map
mapkind = "OTBM"
-- map store location (for XML only)
mapstore = "data/world/WoDBO 2.51-mapstore.xml"
-- house store location (for XML only)
housestore = "data/world/WoDBO 2.51-housestore.xml"
-- bans storage (for XML only)
banIdentifier = "data/bans.xml"
-- server name
servername = "Dragon Ball Hunter Online"
-- server location
location = "Brasil"
-- server ip (the ip that server listens on)
ip = "127.0.0.1"
-- server port (the port that server listens on)
port = "7171"
-- server owner name
ownername = "HunterGames"
-- world type
-- options: pvp, no-pvp, pvp-enforced
worldtype = "pvp-enforced"
-- exhausted time in ms (1000 = 1 second) for none-aggressive spells/weapons
exhausted = 1000
-- exhausted time in ms (1000 = 1 second) for aggressive spells/weapons
fightexhausted = 800
-- how many ms to add if the player is already exhausted and tries to cast a spell (1000 = 1 second)
exhaustedadd = 1000
-- how long does the player has to stay out of fight to get pz unlocked in ms (1000 = 1 second)
pzlocked = 5*1000
-- set to 0 = disabled (default), 1 = enabled
enablehotkeys = 1
-- minimum amount of time between actions ('Use') (1000 = 1 second)
minactioninterval = 100
-- minimum amount of time between extended actions ('Use with...') (1000 = 1 second)
minactionexinterval = 2000
-- how many messages player can span before get muted
maxmessagebuffer = 10
despawnragne = 2
despawnradius = 50
-- house rent period
-- options: daily, weekly, monthly
houserentperiod = "daily"
-- motd (the message box that you sometimes get before you choose characters)
motd = "Welcome to Dragon Ball Hunter Online. Obrigado Por Jogar DBHO. Bom Jogo."
motdnum = "1"
-- login message
loginmsg = "Welcome to World of Dragon Ball Online"
-- how many logins attempts until ip is temporary disabled
-- set to 0 to disable
logintries = 0
-- how long the retry timeout until a new login can be made (without disabling the ip)
retrytimeout = 60*1000
-- how long the player need to wait until the ip is allowed again
logintimeout = 60 * 1000
-- allow clones (multiple logins of the same char)
-- options: 0 (no), 1 (yes)
allowclones = 0
-- max number of players allowed
maxplayers = "200"
-- SQL type
-- options: mysql
sql_type = "mysql"
--- MySQL part (ignore if you are using SQLite)
sql_host = "localhost"
sql_user = "root"
sql_pass = "lokoabreu"
sql_db = "wodbo"
--- SQLite part (ignore if you are using MySQL)
sqlite_db = "db.s3db"
-------------------------------------------------------------------------------------------------
---------------------------- Configuration ------------------------------------------------------
-------------------------------------------------------------------------------------------------
-- world name (shows in the character list)
worldname = "DBHO"
-- time to save the server (default = 5)
autosave = 5
-- do you want to enable cap system? (yes/no)
capsystem = "no"
-- anti-afk - maximum idle time to kick player (1 = 1min)
kicktime = 3600
-- how many summons player can have
maxsummons = 0
-- maximum items in depot
maxdepotitems = 1000
-- learn spells (yes/no)
learnspells = "no"
-- do you want everyone to have premium
freepremium = "no"
-- how many mana grow in 1 min sleep
bedregen = 10
-- Price for each SQM when buying a house
houseprice = 1000
-- level to buy a house
houselevel = 100
-- maximum death entries per player
maxdeathentries = 10
-- time, what player need wait to open body, if he not kill this creature (in seconds)
ownerloot = 10
-- players with that and lower lvl's cant be attacked
protectlevel = 50
-- color o exp above player
expcolor = 71
-- animated spells above player (yes/no)
animatedspells = "yes"
-- remove distance ammunition (yes/no)
removedistance = "no"
-- remove runes (yes/no
removerunes = "no"
-------------------------------------------------------------------------------------
----------------------------------- Multipliers -----------------------------------
-------------------------------------------------------------------------------------
-- experience multiplier (how much faster you got exp from monsters)
rate_exp = 900
-- monster lootrating (how much faster you get items from monsters)
rate_loot = 8
-- skill multiplier (another multiplier in data/vocations.xml)
rate_skill = 100
-- manaspent multiplier (another multiplier in data/vocations.xml)
rate_magic = 100
-- spawn multiplier
rate_spawn = 2
---------------------------------------------------------------------------------------
-------------------------- Skull System -----------------------------------------------
---------------------------------------------------------------------------------------
-- time to lose a white skull (1 = 1 minute)
whitetime = 10
-- time to lose one frag (1 = 1 hour)
fragtime = 10
-- ban unjust, how many frags you need to get banned (1 = 1 frag)
banunjust = 6
-- red skull unjust, how many frags you need to get a red skull (1 = 1 frag)
redunjust = 3
-- bantime, for how long the player is banned (1 = 1 hour)
bantime = 24*1
--------------------------------------------------------------------------------------
------------------------------- GM access rights -------------------------------------
--------------------------------------------------------------------------------------
-- access to walk into houses and open house doors
accesshouse = 5
-- access to login without waiting in the queue or when server is closed
accessenter = 1
-- access to ignore damage, exhaustion, cap limit and be ignored by monsters
accessprotect = 5
-- access to broadcast messages and talk in colors (#c blabla - in public channels)
accesstalk = 2
-- access to see id and position of the item you are looking at
accesslook = 4
info
Grupo: Cavaleiro
Registrado: 12/10/09
Posts: 160
Reputação: +19
Gênero: Masculino
26 de agosto de 2013 às 22:53
-- SQL type
-- options: mysql
sql_type = "mysql"
troca para
-- SQL type
-- options: mysql
sql_type = "sqlite"
ou liga o apache e mysql no xamp
vai em
localhost/phpmyadmin
se vc ja cadastrou seu xamp faz login
vai lem cima add database cria 1 nome
vai em importa e importa a mysql dentro da pasta do ot schems
e pronto ai vc deixa do geito que o seu config ta ou apelas mude do geito que te falei em cima para Sqlite mesmo...e pronto nao tera trabalho nenhum mais...
info
Grupo: Conde
Registrado: 25/04/12
Posts: 752
Reputação: +125
Gênero: Masculino
27 de agosto de 2013 às 04:15
Kb paulo, o carinha ta sofrend opra por SQL imagina MYSQL( que no meu ver é bem mais complicadinho) pra quem ta começando... :x
Usa esse:
-------- config.lua --------
-- Config file for OTServ --
----------------------------
-- data directory location
datadir = "data/"
-- map location
map = "data/world/WoDBO 2.51.otbm"
-- mapkind
-- options: OTBM for binary map, XML for OTX map
mapkind = "OTBM"
-- map store location (for XML only)
mapstore = "data/world/WoDBO 2.51-mapstore.xml"
-- house store location (for XML only)
housestore = "data/world/WoDBO 2.51-housestore.xml"
-- bans storage (for XML only)
banIdentifier = "data/bans.xml"
-- server name
servername = "Dragon Ball Hunter Online"
-- server location
location = "Brasil"
-- server ip (the ip that server listens on)
ip = "127.0.0.1"
-- server port (the port that server listens on)
port = "7171"
-- server owner name
ownername = "HunterGames"
-- world type
-- options: pvp, no-pvp, pvp-enforced
worldtype = "pvp-enforced"
-- exhausted time in ms (1000 = 1 second) for none-aggressive spells/weapons
exhausted = 1000
-- exhausted time in ms (1000 = 1 second) for aggressive spells/weapons
fightexhausted = 800
-- how many ms to add if the player is already exhausted and tries to cast a spell (1000 = 1 second)
exhaustedadd = 1000
-- how long does the player has to stay out of fight to get pz unlocked in ms (1000 = 1 second)
pzlocked = 5*1000
-- set to 0 = disabled (default), 1 = enabled
enablehotkeys = 1
-- minimum amount of time between actions ('Use') (1000 = 1 second)
minactioninterval = 100
-- minimum amount of time between extended actions ('Use with...') (1000 = 1 second)
minactionexinterval = 2000
-- how many messages player can span before get muted
maxmessagebuffer = 10
despawnragne = 2
despawnradius = 50
-- house rent period
-- options: daily, weekly, monthly
houserentperiod = "daily"
-- motd (the message box that you sometimes get before you choose characters)
motd = "Welcome to Dragon Ball Hunter Online. Obrigado Por Jogar DBHO. Bom Jogo."
motdnum = "1"
-- login message
loginmsg = "Welcome to World of Dragon Ball Online"
-- how many logins attempts until ip is temporary disabled
-- set to 0 to disable
logintries = 0
-- how long the retry timeout until a new login can be made (without disabling the ip)
retrytimeout = 60*1000
-- how long the player need to wait until the ip is allowed again
logintimeout = 60 * 1000
-- allow clones (multiple logins of the same char)
-- options: 0 (no), 1 (yes)
allowclones = 0
-- max number of players allowed
maxplayers = "200"
-- SQL type
-- options: mysql
sql_type = "sqlite"
--- MySQL part (ignore if you are using SQLite)
sql_host = "localhost"
sql_user = "root"
sql_pass = "lokoabreu"
sql_db = "wodbo"
--- SQLite part (ignore if you are using MySQL)
sqlite_db = "db.s3db"
-------------------------------------------------------------------------------------------------
---------------------------- Configuration ------------------------------------------------------
-------------------------------------------------------------------------------------------------
-- world name (shows in the character list)
worldname = "DBHO"
-- time to save the server (default = 5)
autosave = 5
-- do you want to enable cap system? (yes/no)
capsystem = "no"
-- anti-afk - maximum idle time to kick player (1 = 1min)
kicktime = 3600
-- how many summons player can have
maxsummons = 0
-- maximum items in depot
maxdepotitems = 1000
-- learn spells (yes/no)
learnspells = "no"
-- do you want everyone to have premium
freepremium = "no"
-- how many mana grow in 1 min sleep
bedregen = 10
-- Price for each SQM when buying a house
houseprice = 1000
-- level to buy a house
houselevel = 100
-- maximum death entries per player
maxdeathentries = 10
-- time, what player need wait to open body, if he not kill this creature (in seconds)
ownerloot = 10
-- players with that and lower lvl's cant be attacked
protectlevel = 50
-- color o exp above player
expcolor = 71
-- animated spells above player (yes/no)
animatedspells = "yes"
-- remove distance ammunition (yes/no)
removedistance = "no"
-- remove runes (yes/no
removerunes = "no"
-------------------------------------------------------------------------------------
----------------------------------- Multipliers -----------------------------------
-------------------------------------------------------------------------------------
-- experience multiplier (how much faster you got exp from monsters)
rate_exp = 900
-- monster lootrating (how much faster you get items from monsters)
rate_loot = 8
-- skill multiplier (another multiplier in data/vocations.xml)
rate_skill = 100
-- manaspent multiplier (another multiplier in data/vocations.xml)
rate_magic = 100
-- spawn multiplier
rate_spawn = 2
---------------------------------------------------------------------------------------
-------------------------- Skull System -----------------------------------------------
---------------------------------------------------------------------------------------
-- time to lose a white skull (1 = 1 minute)
whitetime = 10
-- time to lose one frag (1 = 1 hour)
fragtime = 10
-- ban unjust, how many frags you need to get banned (1 = 1 frag)
banunjust = 6
-- red skull unjust, how many frags you need to get a red skull (1 = 1 frag)
redunjust = 3
-- bantime, for how long the player is banned (1 = 1 hour)
bantime = 24*1
--------------------------------------------------------------------------------------
------------------------------- GM access rights -------------------------------------
--------------------------------------------------------------------------------------
-- access to walk into houses and open house doors
accesshouse = 5
-- access to login without waiting in the queue or when server is closed
accessenter = 1
-- access to ignore damage, exhaustion, cap limit and be ignored by monsters
accessprotect = 5
-- access to broadcast messages and talk in colors (#c blabla - in public channels)
accesstalk = 2
-- access to see id and position of the item you are looking at
accesslook = 4
E vai na pasta do ot e ve se tem um arquivo chamado db.s3db
Se tiver, tudo bem, mas se nao tiver com esse nome e o fim dele ser .S3DB
você renomeia para db.s3db
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
27 de agosto de 2013 às 07:45
-- SQL type
-- options: mysql
sql_type = "mysql"
troquei por
-- SQL type
-- options: mysql
sql_type = "sqlite"
não mudou nada da a mesma mensagem ainda
Cleberadm
eu não achei nenhum arquivo com o nome no fim S3DB
veja a imagem vc mesmo do que so tem na pasta do meu ot
Editado Agosto 27 por joseanpereira
info
Grupo: Conde
Registrado: 25/04/12
Posts: 752
Reputação: +125
Gênero: Masculino
27 de agosto de 2013 às 11:23
Blz, sabe esse arquivo DB ali? posta ele aqui em spoiler... é por isso que nao ta funcionando, ta faltando a database sql
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
27 de agosto de 2013 às 11:29
okei mano ai o arquivo db
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
--
-- Host: localhost
-- Czas wygenerowania: 25 Lip 2011, 13:19
-- Wersja serwera: 5.1.37
-- Wersja PHP: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Baza danych: `dbko`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`id` int(11) unsigned NOT NULL DEFAULT '0',
`password` varchar(32) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`premDays` int(11) NOT NULL DEFAULT '0',
`premEnd` int(11) NOT NULL DEFAULT '0',
`email` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`blocked` tinyint(4) NOT NULL DEFAULT '0',
`rlname` varchar(45) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`location` varchar(45) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`recovery_key` varchar(20) COLLATE latin1_general_ci NOT NULL,
`hide` tinyint(1) NOT NULL DEFAULT '0',
`hidemail` tinyint(1) NOT NULL DEFAULT '0',
`page_access` int(11) NOT NULL DEFAULT '0',
`lastday` int(11) NOT NULL DEFAULT '0',
`created` int(11) NOT NULL DEFAULT '0',
`page_lastday` int(11) NOT NULL DEFAULT '0',
`premium_points` int(11) NOT NULL DEFAULT '0',
KEY `accno` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `accounts`
--
INSERT INTO `accounts` (`id`, `password`, `premDays`, `premEnd`, `email`, `blocked`, `rlname`, `location`, `recovery_key`, `hide`, `hidemail`, `page_access`, `lastday`, `created`, `page_lastday`, `premium_points`) VALUES
(8548596, 'lolek14', 0, 1311592424, 'sdasad@o2.pl', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `addons`
--
CREATE TABLE IF NOT EXISTS `addons` (
`player` int(20) NOT NULL DEFAULT '0',
`outfit` int(10) NOT NULL DEFAULT '0',
`addon` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `addons`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`type` int(11) NOT NULL DEFAULT '0' 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',
`reason` varchar(25) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `bans`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `blessings`
--
CREATE TABLE IF NOT EXISTS `blessings` (
`player` int(20) NOT NULL DEFAULT '0',
`id` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
--
-- Zrzut danych tabeli `blessings`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `deathlist`
--
CREATE TABLE IF NOT EXISTS `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;
--
-- Zrzut danych tabeli `deathlist`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'group name',
`flags` bigint(20) unsigned NOT NULL DEFAULT '0',
`access` int(11) NOT NULL DEFAULT '0',
`ranga` int(11) NOT NULL DEFAULT '0',
`maxdepotitems` int(11) NOT NULL DEFAULT '0',
`maxviplist` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `groups`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `guilds`
--
CREATE TABLE IF NOT EXISTS `guilds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'guild name - nothing else needed here',
`ownerid` int(11) NOT NULL,
`creationdata` int(11) NOT NULL,
`invited_to` int(11) NOT NULL,
`invited_by` int(11) NOT NULL,
`in_war_with` int(11) NOT NULL,
`kills` int(11) NOT NULL,
`show` smallint(1) NOT NULL,
`war_time` int(11) NOT NULL,
`kills_all` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `guilds`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `guild_ranks`
--
CREATE TABLE IF NOT EXISTS `guild_ranks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guild_id` int(11) NOT NULL COMMENT 'guild',
`name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '' 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 ;
--
-- Zrzut danych tabeli `guild_ranks`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 AUTO_INCREMENT=69 ;
--
-- Zrzut danych tabeli `houses`
--
INSERT INTO `houses` (`id`, `owner`, `paid`, `warnings`) VALUES
(1, 0, 0, '0'),
(2, 0, 0, '0'),
(3, 0, 0, '0'),
(4, 0, 0, '0'),
(5, 0, 0, '0'),
(6, 0, 0, '0'),
(7, 0, 0, '0'),
(8, 0, 0, '0'),
(9, 0, 0, '0'),
(10, 0, 0, '0'),
(11, 0, 0, '0'),
(12, 0, 0, '0'),
(13, 0, 0, '0'),
(14, 0, 0, '0'),
(15, 0, 0, '0'),
(16, 0, 0, '0'),
(17, 0, 0, '0'),
(18, 0, 0, '0'),
(19, 0, 0, '0'),
(20, 0, 0, '0'),
(21, 0, 0, '0'),
(22, 0, 0, '0'),
(23, 0, 0, '0'),
(24, 0, 0, '0'),
(25, 0, 0, '0'),
(26, 0, 0, '0'),
(27, 0, 0, '0'),
(28, 0, 0, '0'),
(29, 0, 0, '0'),
(30, 0, 0, '0'),
(31, 0, 0, '0'),
(32, 0, 0, '0'),
(33, 0, 0, '0'),
(34, 0, 0, '0'),
(35, 0, 0, '0'),
(36, 0, 0, '0'),
(37, 0, 0, '0'),
(38, 0, 0, '0'),
(39, 0, 0, '0'),
(40, 0, 0, '0'),
(41, 0, 0, '0'),
(42, 0, 0, '0'),
(43, 0, 0, '0'),
(44, 0, 0, '0'),
(45, 0, 0, '0'),
(46, 0, 0, '0'),
(47, 0, 0, '0'),
(48, 0, 0, '0'),
(49, 0, 0, '0'),
(50, 0, 0, '0'),
(51, 0, 0, '0'),
(52, 0, 0, '0'),
(53, 0, 0, '0'),
(54, 0, 0, '0'),
(55, 0, 0, '0'),
(56, 0, 0, '0'),
(57, 0, 0, '0'),
(58, 0, 0, '0'),
(59, 0, 0, '0'),
(60, 0, 0, '0'),
(61, 0, 0, '0'),
(62, 0, 0, '0'),
(63, 0, 0, '0'),
(64, 0, 0, '0'),
(65, 0, 0, '0'),
(66, 0, 0, '0'),
(67, 0, 0, '0'),
(68, 0, 0, '0');
-- --------------------------------------------------------
--
-- Struktura tabeli dla `house_lists`
--
CREATE TABLE IF NOT EXISTS `house_lists` (
`house_id` int(11) 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;
--
-- Zrzut danych tabeli `house_lists`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_accounts`
--
CREATE TABLE IF NOT EXISTS `nicaw_accounts` (
`account_id` int(10) unsigned NOT NULL,
`rlname` varchar(50) DEFAULT NULL,
`location` varchar(50) DEFAULT NULL,
`comment` tinytext,
`recovery_key` char(32) DEFAULT NULL,
UNIQUE KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Zrzut danych tabeli `nicaw_accounts`
--
INSERT INTO `nicaw_accounts` (`account_id`, `rlname`, `location`, `comment`, `recovery_key`) VALUES
(8548596, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_account_logs`
--
CREATE TABLE IF NOT EXISTS `nicaw_account_logs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(11) NOT NULL,
`date` int(11) NOT NULL,
`action` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Zrzut danych tabeli `nicaw_account_logs`
--
INSERT INTO `nicaw_account_logs` (`id`, `account_id`, `ip`, `date`, `action`) VALUES
(1, 8548596, 2130706433, 1309701004, 'Created'),
(2, 8548596, 2130706433, 1309701022, 'Created character: Lutzenek');
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_guild_info`
--
CREATE TABLE IF NOT EXISTS `nicaw_guild_info` (
`id` int(10) unsigned NOT NULL COMMENT 'guild id',
`description` tinytext,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Zrzut danych tabeli `nicaw_guild_info`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_guild_invites`
--
CREATE TABLE IF NOT EXISTS `nicaw_guild_invites` (
`gid` int(10) unsigned NOT NULL COMMENT 'guild id',
`pid` int(10) unsigned NOT NULL COMMENT 'player id',
`rank` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Zrzut danych tabeli `nicaw_guild_invites`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_news`
--
CREATE TABLE IF NOT EXISTS `nicaw_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(64) NOT NULL,
`creator` varchar(25) NOT NULL,
`date` int(11) NOT NULL,
`text` text NOT NULL,
`html` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `nicaw_news`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_polls`
--
CREATE TABLE IF NOT EXISTS `nicaw_polls` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(255) NOT NULL,
`startdate` int(10) unsigned NOT NULL,
`enddate` int(10) unsigned NOT NULL,
`minlevel` int(10) unsigned NOT NULL,
`hidden` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `nicaw_polls`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_poll_options`
--
CREATE TABLE IF NOT EXISTS `nicaw_poll_options` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`poll_id` int(10) unsigned NOT NULL,
`option` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `nicaw_poll_options`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `nicaw_poll_votes`
--
CREATE TABLE IF NOT EXISTS `nicaw_poll_votes` (
`option_id` int(10) unsigned NOT NULL,
`account_id` int(11) NOT NULL,
`ip` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Zrzut danych tabeli `nicaw_poll_votes`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `players`
--
CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`account_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL COMMENT 'users group',
`access` int(10) 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 '136',
`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 '10',
`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',
`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`),
KEY `name` (`name`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
--
-- Zrzut danych tabeli `players`
--
INSERT INTO `players` (`id`, `name`, `account_id`, `group_id`, `access`, `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`, `rank_id`, `town_id`) VALUES
(1, 'lutzenek', 8548596, 0, 9999, 1, 333, 162000001, 215, 0, 7740, 7740, 14160, 14160, 0, 100, 0, 136, 10, 10, 10, 334, 0, 99, 187, 7, 0, 1311590679, 16777343, 1, 0x010001000002000000000398921b0010d7000000110b00000012d007000013adc20200fe, 0, 0, '', 0, 1);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `player_depotitems`
--
CREATE TABLE IF NOT EXISTS `player_depotitems` (
`player_id` int(11) NOT NULL,
`depotid` 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,
KEY `player_id` (`player_id`,`depotid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `player_depotitems`
--
INSERT INTO `player_depotitems` (`player_id`, `depotid`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES
(1, 0, 102, 101, 2594, 1, ''),
(1, 0, 101, 1, 2589, 1, '');
-- --------------------------------------------------------
--
-- Struktura tabeli dla `player_items`
--
CREATE TABLE IF NOT EXISTS `player_items` (
`player_id` int(11) 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',
KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `player_items`
--
INSERT INTO `player_items` (`player_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES
(1, 129, 102, 2549, 1, ''),
(1, 128, 102, 2549, 1, ''),
(1, 127, 102, 2549, 1, ''),
(1, 126, 102, 2450, 1, ''),
(1, 125, 102, 2450, 1, ''),
(1, 124, 102, 2450, 1, ''),
(1, 123, 102, 2450, 1, ''),
(1, 122, 102, 2450, 1, ''),
(1, 121, 102, 4852, 1, ''),
(1, 120, 102, 4852, 1, ''),
(1, 119, 101, 2296, 1, 0x0c01),
(1, 118, 101, 2316, 1, 0x0c01),
(1, 117, 101, 2310, 1, 0x0c01),
(1, 116, 101, 2266, 1, 0x0c01),
(1, 113, 101, 2314, 1, 0x0c01),
(1, 114, 101, 2267, 1, 0x0c01),
(1, 115, 101, 2308, 1, 0x0c01),
(1, 112, 101, 2309, 1, 0x0c01),
(1, 111, 101, 2269, 1, 0x0c01),
(1, 110, 101, 2312, 1, 0x0c01),
(1, 109, 101, 2287, 1, 0x0c01),
(1, 108, 101, 2315, 1, 0x0c01),
(1, 107, 10, 2450, 1, ''),
(1, 106, 8, 2640, 1, ''),
(1, 105, 7, 2521, 1, ''),
(1, 104, 6, 2450, 1, ''),
(1, 103, 5, 3956, 98, ''),
(1, 102, 3, 1996, 1, ''),
(1, 101, 2, 2003, 1, '');
-- --------------------------------------------------------
--
-- Struktura tabeli dla `player_skills`
--
CREATE TABLE IF NOT EXISTS `player_skills` (
`player_id` int(11) 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;
--
-- Zrzut danych tabeli `player_skills`
--
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 0, 1, 0),
(1, 1, 1, 0),
(1, 2, 1, 0),
(1, 3, 1, 0),
(1, 4, 1, 0),
(1, 5, 1, 0),
(1, 6, 1, 0);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `player_spells`
--
CREATE TABLE IF NOT EXISTS `player_spells` (
`player_id` int(11) NOT NULL,
`name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `player_spells`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `player_storage`
--
CREATE TABLE IF NOT EXISTS `player_storage` (
`player_id` int(11) 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;
--
-- Zrzut danych tabeli `player_storage`
--
INSERT INTO `player_storage` (`player_id`, `key`, `value`) VALUES
(1, 20010, 3),
(1, 6628, 1);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `player_viplist`
--
CREATE TABLE IF NOT EXISTS `player_viplist` (
`player_id` int(11) NOT NULL COMMENT 'id of player whose viplist entry it is',
`vip_id` int(11) NOT NULL COMMENT 'id of target player of viplist entry',
KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Zrzut danych tabeli `player_viplist`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tiles`
--
CREATE TABLE IF NOT EXISTS `tiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 AUTO_INCREMENT=2669 ;
--
-- Zrzut danych tabeli `tiles`
--
INSERT INTO `tiles` (`id`, `x`, `y`, `z`) VALUES
(16, 70, 182, 7),
(137, 76, 182, 7),
(286, 78, 174, 7),
(420, 54, 196, 6),
(437, 60, 196, 6),
(450, 54, 198, 6),
(467, 60, 198, 6),
(477, 124, 441, 15),
(490, 55, 196, 5),
(507, 61, 196, 5),
(513, 131, 436, 15),
(523, 55, 198, 5),
(530, 124, 436, 15),
(540, 61, 198, 5),
(557, 57, 178, 6),
(570, 72, 104, 7),
(582, 96, 422, 15),
(596, 64, 179, 6),
(613, 88, 113, 7),
(624, 115, 115, 7),
(639, 115, 95, 7),
(682, 93, 164, 7),
(705, 93, 160, 7),
(723, 93, 156, 7),
(740, 93, 152, 7),
(744, 96, 152, 7),
(776, 93, 164, 6),
(791, 93, 160, 6),
(806, 93, 156, 6),
(821, 93, 152, 6),
(823, 101, 158, 6),
(840, 101, 163, 6),
(870, 93, 164, 5),
(885, 93, 160, 5),
(900, 93, 156, 5),
(915, 93, 152, 5),
(917, 101, 163, 5),
(939, 101, 158, 5),
(969, 93, 164, 4),
(984, 93, 160, 4),
(999, 93, 156, 4),
(1014, 93, 152, 4),
(1016, 101, 163, 4),
(1037, 101, 158, 4),
(1062, 438, 629, 6),
(1088, 442, 629, 6),
(1093, 117, 416, 15),
(1098, 439, 642, 6),
(1115, 444, 642, 6),
(1184, 47, 114, 4),
(1188, 47, 119, 4),
(1273, 55, 119, 4),
(1343, 44, 114, 5),
(1344, 44, 116, 5),
(1452, 55, 113, 5),
(1454, 55, 118, 5),
(1524, 44, 114, 6),
(1525, 44, 116, 6),
(1594, 51, 114, 6),
(1595, 51, 116, 6),
(1696, 43, 114, 7),
(1698, 43, 116, 7),
(1824, 55, 113, 7),
(1830, 55, 119, 7),
(1870, 59, 115, 7),
(1889, 484, 626, 6),
(1905, 335, 905, 7),
(1916, 333, 912, 7),
(1961, 347, 908, 7),
(1977, 351, 905, 7),
(2002, 361, 903, 7),
(2009, 357, 893, 7),
(2028, 347, 893, 7),
(2041, 369, 925, 7),
(2063, 369, 933, 7),
(2103, 381, 928, 7),
(2132, 381, 935, 7),
(2169, 357, 945, 7),
(2203, 78, 169, 7),
(2239, 115, 183, 7),
(2281, 86, 134, 5),
(2283, 86, 136, 5),
(2315, 90, 134, 5),
(2343, 93, 138, 5),
(2347, 94, 134, 5),
(2381, 86, 135, 6),
(2445, 95, 135, 6),
(2468, 87, 135, 7),
(2489, 91, 135, 7),
(2494, 91, 140, 7),
(2510, 95, 135, 7),
(2529, 72, 179, 6),
(2560, 78, 174, 6),
(2581, 78, 169, 6),
(2592, 80, 163, 6),
(2620, 86, 163, 6),
(2634, 54, 187, 6),
(2668, 51, 183, 7);
-- --------------------------------------------------------
--
-- Struktura tabeli dla `tile_items`
--
CREATE TABLE IF NOT EXISTS `tile_items` (
`tile_id` int(11) 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;
--
-- Zrzut danych tabeli `tile_items`
--
INSERT INTO `tile_items` (`tile_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES
(16, 1, 0, 1252, 1, ''),
(137, 1, 0, 1252, 1, ''),
(286, 1, 0, 1250, 1, ''),
(420, 1, 0, 1252, 1, ''),
(437, 1, 0, 1252, 1, ''),
(450, 1, 0, 1252, 1, ''),
(467, 1, 0, 1252, 1, ''),
(477, 1, 0, 1252, 1, ''),
(490, 1, 0, 1252, 1, ''),
(507, 1, 0, 1252, 1, ''),
(513, 1, 0, 1252, 1, ''),
(523, 1, 0, 1252, 1, ''),
(530, 1, 0, 1252, 1, ''),
(540, 1, 0, 1252, 1, ''),
(557, 1, 0, 1250, 1, ''),
(570, 1, 0, 1252, 1, ''),
(582, 1, 0, 1250, 1, ''),
(596, 1, 0, 1252, 1, ''),
(613, 1, 0, 1252, 1, ''),
(624, 1, 0, 1253, 1, ''),
(639, 1, 0, 1253, 1, ''),
(682, 1, 0, 1250, 1, ''),
(705, 1, 0, 1250, 1, ''),
(723, 1, 0, 1250, 1, ''),
(740, 1, 0, 1250, 1, ''),
(744, 1, 0, 1250, 1, ''),
(776, 1, 0, 1250, 1, ''),
(791, 1, 0, 1250, 1, ''),
(806, 1, 0, 1250, 1, ''),
(821, 1, 0, 1250, 1, ''),
(823, 1, 0, 1250, 1, ''),
(840, 1, 0, 1250, 1, ''),
(870, 1, 0, 1250, 1, ''),
(885, 1, 0, 1250, 1, ''),
(900, 1, 0, 1250, 1, ''),
(915, 1, 0, 1250, 1, ''),
(917, 1, 0, 1250, 1, ''),
(939, 1, 0, 1250, 1, ''),
(969, 1, 0, 1250, 1, ''),
(984, 1, 0, 1250, 1, ''),
(999, 1, 0, 1250, 1, ''),
(1014, 1, 0, 1250, 1, ''),
(1016, 1, 0, 1250, 1, ''),
(1037, 1, 0, 1250, 1, ''),
(1062, 1, 0, 3536, 1, ''),
(1088, 1, 0, 3536, 1, ''),
(1093, 1, 0, 1251, 1, ''),
(1098, 1, 0, 3536, 1, ''),
(1115, 1, 0, 3536, 1, ''),
(1184, 1, 0, 1250, 1, ''),
(1188, 1, 0, 1250, 1, ''),
(1273, 1, 0, 1250, 1, ''),
(1343, 1, 0, 1253, 1, ''),
(1344, 1, 0, 1253, 1, ''),
(1452, 1, 0, 1250, 1, ''),
(1454, 1, 0, 1250, 1, ''),
(1524, 1, 0, 1252, 1, ''),
(1525, 1, 0, 1252, 1, ''),
(1594, 1, 0, 1252, 1, ''),
(1595, 1, 0, 1252, 1, ''),
(1696, 1, 0, 1252, 1, ''),
(1698, 1, 0, 1252, 1, ''),
(1824, 1, 0, 1250, 1, ''),
(1830, 1, 0, 1250, 1, ''),
(1870, 1, 0, 1250, 1, ''),
(1889, 1, 0, 3536, 1, ''),
(1905, 1, 0, 1253, 1, ''),
(1916, 1, 0, 1250, 1, ''),
(1961, 1, 0, 1253, 1, ''),
(1977, 1, 0, 1250, 1, ''),
(2002, 1, 0, 1250, 1, ''),
(2009, 1, 0, 1253, 1, ''),
(2028, 1, 0, 1253, 1, ''),
(2041, 1, 0, 1250, 1, ''),
(2063, 1, 0, 1250, 1, ''),
(2103, 1, 0, 1252, 1, ''),
(2132, 1, 0, 1252, 1, ''),
(2169, 1, 0, 1253, 1, ''),
(2203, 1, 0, 1250, 1, ''),
(2239, 1, 0, 1250, 1, ''),
(2281, 1, 0, 1252, 1, ''),
(2283, 1, 0, 1252, 1, ''),
(2315, 1, 0, 1252, 1, ''),
(2343, 1, 0, 1250, 1, ''),
(2347, 1, 0, 1252, 1, ''),
(2381, 1, 0, 1252, 1, ''),
(2445, 1, 0, 1252, 1, ''),
(2468, 1, 0, 1252, 1, ''),
(2489, 1, 0, 1252, 1, ''),
(2494, 1, 0, 1252, 1, ''),
(2510, 1, 0, 1252, 1, ''),
(2529, 1, 0, 1253, 1, ''),
(2560, 1, 0, 1249, 1, ''),
(2581, 1, 0, 1249, 1, ''),
(2592, 1, 0, 1253, 1, ''),
(2620, 1, 0, 1253, 1, ''),
(2634, 1, 0, 1252, 1, ''),
(2668, 1, 0, 1250, 1, '');
-- --------------------------------------------------------
--
-- Struktura tabeli dla `z_ots_comunication`
--
CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `z_ots_comunication`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `z_shop_history_item`
--
CREATE TABLE IF NOT EXISTS `z_shop_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=1 ;
--
-- Zrzut danych tabeli `z_shop_history_item`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `z_shop_history_pacc`
--
CREATE TABLE IF NOT EXISTS `z_shop_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 ;
--
-- Zrzut danych tabeli `z_shop_history_pacc`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `z_shop_offer`
--
CREATE TABLE IF NOT EXISTS `z_shop_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=1 ;
--
-- Zrzut danych tabeli `z_shop_offer`
--
info
Grupo: Barão
Registrado: 29/03/13
Posts: 215
Reputação: +4
Char no Tibia: gm
gente baixei o ot dbko arena so que na hora que abro da erro no executável
quem pode me ajudar a ajeitar dou mais rep
se for algo faltando no ot da o link ai para eu poder baixar