Logo

Site Para Poketibia Versões 8.5X

bruno333
Por bruno333
em Lixeira Pública

bruno333

avatar
Campones
Campones

INFOS

Grupo: CamponesRegistrado: 18/12/05Posts: 29
Postado em março 02, 2011

# Revolution Website #



 

Nome: Revolution Website

Versão: 8.5+

Autor: Bruno333

Coméntario:

Bom, eu vi que tem varios Poketibia e nenhum site , então resolvi fazer um bom, leve e pratico!

 

*lembrando que eu,uso como base o site do Nicaw SVN 19b

 



Configurando o site:


Primeiro passo e acessar o phpmyadmin (http://localhost/ ou http://localhost:8090)

Entre na sua conta do PhpMyAdmin, "Root" "sua senha"

Agora cria uma database (coloque um nome mais simples que puder, aconselho coloca o nome de "tibia")

agora la em cima no menu tem o butão [iMPORTAR]
Clique ele!

Depois irar aparecer uma pagina, com um butão chamado PROCURAR, clique e va até a pasta do seu ot.. e importa a database do ot. Caso não tenho pode baixar Clicando aqui[/url]

Agora continuando no [iMPORTAR] vc deve importar agora a database no NICAW ACC, que se encontra na pasta
xampp/htdocs/documents
nome do arquivo eh shema.mysql (database do nicaw)
Podemos fechar o internet explorer e configurar logo!

va a pasta Xampp/htdocs/config.inc
e abra ele!








 


Vamos agora configurar:




 




# Set data directory of your OT server



$cfg['dirdata'] = 'C:\otserv\data;

 

$cfg['house_file'] = 'world/map-house.xml';

 

# MySQL server settings

$cfg['SQL_Server'] = 'localhost';

$cfg['SQL_User'] = 'root';

$cfg['SQL_Password'] = '123456';

$cfg['SQL_Database'] = 'tibia';





 


 


Configurando:






Onde a pasta data do seu ot está localizado



 entre na pasta data/world do seu ot e ve o arquivo que ta no final com house.xml e coloque no lugar do map-house.xml

senha do seu phpmyadmin!

 Nome da tua database, aconselho colocar a database com nome de tibia!! ai so colocar como está ai em cima!

Agora feche e salve..

 

Va a pasta do seu ot

abra config lua e aperte ctrl + f e procure por root la vc encontrara tpw assim:





 




sql_host = "localhost"



sql_user = "root"

sql_pass = "SUA SENHA"

sql_db = "COLOQUE O NOME DA TUA DATABASE"





 





* só lembrando galera que o site eu ia usar em meu servidor então tem certas funções que esta configurada para meu servidor mais quem tem um conhecimento minimo consegue de boa fazer as devidas mudanças!





 


SS






siteou.png






 


Agora o mais importante de tudo o Download e Scan !!!














 




Bom galerinha do Xtibia é isso ai, espero que gostem do meu Website qualquer Duvida ou Bug's postem aqui



 

Não se esqueça de quem gostou da um +Repp que não vai cair a mão tbem !!!





342b88685af7e861fa7120f5f9959bde.jpg


Xkings World


http://xkingsworld.servegame.com
cadu12299
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 11/08/10Posts: 11
Postado em março 03, 2011
Nossa cara muito bom!! mais so falta uma coisa a database vc boto errado não da pra baixa  :ouch: se der para arruma eu agreço  :wink:
bruno333
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 18/12/05Posts: 29
Postado em março 03, 2011


como assim amigo?


o link para downloads esta ruim?


 


não entendi


342b88685af7e861fa7120f5f9959bde.jpg


Xkings World


http://xkingsworld.servegame.com
cadu12299
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 11/08/10Posts: 11
Postado em março 04, 2011


afs cara não seu tutorial tah Incrivel!!! não sei o que deu acho que fiz besteira agora não quer entra no http://localhost/phpmyadmin/


fala assim:




Erro


Mensagens do MySQL : 


 


#1045 - Access denied for user 'root'@'localhost' (using password: NO) 


Conexão para controle do usuário como definido nas configurações falhou.


phpMyAdmin tentou se conectar no servidor MySQL e a conxão foi recusada. Você deve checar o servidor, nome de usuário e senha no config.inc.php e se certificar que correspondam com as informações fornecidas pelo administrador do servidor MySQL.






 


 :cry:


sabe como arruma  :sad:


 


há cara deixa já vouto ao normal ^^ mas eo seguinte na parte do database eu vo em inportar e escolho o arquivo


forgottenserver.s3db ai tobo em executar e da erro aparece :




Talvez tenha encontrado um bug no analizador (parser) do SQL. Analise a sua Consulta SQL com atenção, e verifique se as aspas estão corretas e não estão desencontradas. Outra possibilidade de falha é o fato de estar tentando subir um arquivo com saída binária de uma área de texto citada. Pode também experimentar a sua consulta SQL no prompt de comandos do MySQL. A saída de erro do MySQL, isto se existir alguma, também poderá ajudar a diagnosticar o problema. Se continuar a ter problemas ou se o analisador (parser) falhar onde a interface da linha de comandos tiver sucesso, reduza por favor a entrada da consulta SQL até aquele que causou o problema, e envie o relatório de bug com os dados do chunk da seção CORTE abaixo:
----INICIO CORTE----
eNrtnF1sG0kBx2d2HLvZVi0fd3Uh19NWrZpETYLXrtM0VSXc4OaiS5zWSfp1cL6NvU2XrHfd3XWb
IHH0AxAvSMADvCAdnE6VECDuherEC0LAAy/wwAnxAAL14Q4KQgcPPXQndMzu2ontfNjbjxDs/y/K
eNc7szs7OzOezDi/dDY7nR2VxmRpLC5NpjOjkpyU5GFpJDkix8SZWX6MiOLMOX7g0ERhVLKv6iXF
slVrSNfmh0pXSpKckOVjUjwWOz4oy4Nu6sRoMjaaiF+SdLV4XDokTi3PnJ0clZJD8tBRWZybyUrT
MwNSajydmR2QzqX5Jc5rhjSTOp3KTvBYsaFk4qh4Zio1KiWG4kN887kzbrSB6Rn3JIkhWTo/kcnM
ipOpzPioVHLmrcGyc3lwRPQuwwPNUaXLplVUHClBQoRS8klJIiT8HVLPVf5La/YpaZEu/vsMc9xN
lb3PHrB/sr+zt9k99kf2e/Zb9mv2K/YL9lP2E/Zj9jr7PrvDvsu+zb7FvsG+yr7CbrOX2bKfGIA2
oXCOB/k5HszP8EA5w4OXMjzIPc+DFyd48JlxHnw6zYMXxnhwKcWDi4cXnBP89cIoD84d48HcUR6c
SvDAPSTz12MDPIj38WDoIA/6JfeYUiyd2M83DnycB8/u5cG+p3jw4T08ELt50B0WeSiwPxP2Dg8A
AG3FboEdoKqRt5ZLjmYaZDfl+4X53DXVsvl+1G//9wj/dL6H0gKg7XqAug5A2F3X/qnf/t8gfEz+
BsoKgP8PnhVClJ4UyHlVz5tFVXJMqWQuqkXTkAqKfeWAN/anPM4UrY0ze0WVTpvWguk4qiHNqBbv
Bw74fcA7hP2bBwCAtibCuwUqEMF7pcQbAzD2J8LeZX/jLwCA9kFkvJ2HBDJ18u5nRXfYEKJkavj9
30Xc4YE7ne+3/z8Q9oD9lb8AANqEXV1ue/cbP/N3/NYvdHdRv/l7n/8khLICoCMHCPw3THcQuoP+
iN4XXhfeZr/sxHK4eYhGor299FbEUeZ11fZmR3J507isLdTtCGPZdGo2Lc2mTk2mpcNXy6Zzoi6C
/5bUJ3b7W3Xvnktlx55LZfsSyX4pMz0rZeYmJ6VPpU+n5iZnpd7egWqia4peVitpJjKz6fF0diU+
jzSXmTg7l5b61l6hX+w/LoSjU72UaEZBXbKv6pqj5pSyY3r7ubq85uS6XXZzjEWiBw/SW1O1pVA0
nULNZmjjEnAPN96/Vtj4Pvwj101LL+Q2jLdSPrGVFI665FRiz6YvzG5QlPWlVD3/gLTeVXm5JUPh
6MTBJuXm3uFKqbk7XTdf6PJrTrm2zCw1b1qFup3wxuXmR2gsubp3H2fpaUXVdpRiqdUKVpuR9Yuv
+m7Dqd3aGG6hNvoXWClXfzfi/W1CzhNynr7LfvPYmvrt/ZFItL+ffqnhgZVMy7Hr93Zs9si8GE1r
+5nsxFQqe1F6Pn3xER5ZSVeW+UUDJTHtpUCxlwPF/tzjq2/rJPFLt3kTr8ZWCnbTk4v9t+d2RKL7
99Mvf9578ko+b5YNx66+7lznaVePBXnOa9uooRTVhk+AeLLmI2C1YBXbvr7a6JtEttRiQVm2Wy9W
XbEdnqL1BGpR0fTNMrPe41hUlxuTxNZLEVtNMq+b+UW1etunpqcn06nMZhm7rliGZiwEuPcFyyyX
WmhB8prub/Xp8f7sE93h6Nj+jfqzanXJydWtXW4vRtlbhL3FXmGvYMQJwPZivOdjNCTuoZTKx0eS
w/KwHHd/yJT7Bct9vTH/i8+HenoqseKJ+LCcHHFfYsmRS160hOlG20d3kj17WOVkMvngg6mTd+/E
KvMslL1H2HvsH/i2FQDtOOFa6RkEd7vSl7AutofKlfZ/g7AbAv9BUYGthpKn3aV/Kgje0r9AfQSB
7hJoyFsQEL0FwlXETLlo82rL6+/gi7G9Pa/+6zXvVHwUS8OEx+0KkQj9GvU/KPsIudVFfuh+Vnpv
PDNHSLdw9AcCKXCq2bgRPBeTyiLPhcBzEdvLc/Ga87NqLoQwCdFQiP0nXM3FyIOGXBzWnRN33YxM
DFYy4h56mR4lR6pXrs2Iez2eEe/6Im3ISMof00tTiqEsqBYJu2so3+Q/XvnGKncYj/MycRdd7vCj
X1hZi9n7knf5wsq0K2X3CbvP3mRvonIC0AbspV6PyfjmTup1W8LTId7PNHYcbhf0oZanJlbiVeYU
Woipq9dUvZWZjspyg5lX3G+Itz6bckVVdOdK0yvEGlMUlaUgidSlkmppqpFXA0xymebivFlYbn6d
uiSXVdUJmITfUiFgEl1tPmfVkMRZLjW9ezkxXJdGKRRMI8DkWFFZaKnK1KYwlCBP0o0f8OG7SeyS
ajit58o2ywHuwTGvGy00pu0zk543jYLmNtTqoz01OX1qbYbzSoCpdltdCjaBrJsLmhEoids1OlqQ
PCnX1GZzwau9l71Y1gM8dS+6uyYRYDlCMRZbqCgLZU0vGFp+MeiMeaVYzXKAqu4uXdnBpsDnFV0J
1JW6qzZaC+08KcdjLisJC5ql5lv5RInXdFu2nWu9v6/tKLykQTskL5G9qOm6HTgZb4eOohmqFTyp
5qjFQKncVR7VCLDwZxo6z1p17Wwic5Gn2bwntyyND0sCdFqWWTSDjRcKqq46QRZ4Cqqdt7RSzVVa
aE0brdtUl6frctHPE5yezqYnxjPeql3f+oOsfimbPp3OpjNj6ZkNFgXrlwT7xX7vWzXkBv9rl/r/
jDMnfE/4C/v5Vo5Fvx4VI9GeHvpql7fY6a8g25UXcZ2lzsqhLVrpbHUNnN/JnsGd4WiqZ6M1t0q+
c3JlY/ets7si0SNH6Bcv1i7z5q5pJV3jPVr97kc2XvStRmkskdaH4Y9/oX9NJW/MzIC07omeWGVf
/7yNV1972obatqYJnRTD0bNHmqyzVp/QynJr9Y2P3ryw2/uSx61Frw4s6Cb/8MvZjmnxnq5+76l1
akB9jMYKsLrA/RiffO1Xvpp0dbG1fd1Kljb8etMJiH8A2HIg/gEAbCEQ/wDQ0T0AxD8AtBkQ/wAA
HgaIfwDoGCD+AaBDgfgHALDpAIFA/OMC8Q/EPxD/QPwD8Q/EPxD/QPwD8Q8AnQHEPwCAR59whfgH
bFcg/oH4BwDw5ID4B+IfiH8g/oH4B+IfiH8g/oH4B+IfiH8g/oH4B+IfiH8g/gGdB8Q/AIAtBOIf
ADq6B4D4B4A2A+IfAMDDAPEPAB0DxD8AdCgQ/wAANh0gEIh/XCD+gfgH4h+IfyD+gfgH4h+IfyD+
AaAzgPgHAPDoE64Q/4DtCsQ/EP8AAJ4cEP9A/APxD8Q/EP9A/APxD8Q/EP9A/APxD8Q/EP9A/APx
D8Q/oPOA+AcAsIVA/ANAR/cAEP8A0GZA/AMAeBgg/gGgY4D4B4AOBeIfAMCmAwQC8Y8LxD8Q/0D8
A/EPxD8Q/0D8A/EPxD8AdAYQ/wAAHn3CFeIfsF2B+AfiHwDAkwPiH4h/IP6B+AfiH4h/IP6B+Afi
H4h/IP6B+AfiH4h/IP6B+Ad0HhD/AAC2EIh/AOjoHgDiHwDaDIh/AAAPA8Q/AHQMEP8A0KFA/AMA
2HSAQCD+cYH4B+IfiH8g/oH4B+IfiH8g/oH4B4DOAOIfAMCjT7hC/AO2KxD/QPwDAHhyQPwD8Q/E
PxD/QPwD8Q/EPxD/QPwD8Q/EPxD/QPwD8c//XPzzX/K6LCU=
----FIM CORTE----
----INICIO CRU----
ERROR: C1 C2 LEN: 15 16 85810
STR: 

SVN: $Id: sqlparser.lib.php 13117 2009-11-15 13:50:32Z lem9 $
MySQL: 5.1.41
USR OS, AGENT, VER: Win SAFARI 5.0.534
PMA: 3.2.4
PHP VER,OS: 5.3.1 WINNT
LANG: ptbr-utf-8
SQL: SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)U}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/	Cindexsqlite_autoindex_accounts_1accounts
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)U}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/	Cindexsqlite_autoindex_accounts_1accounts
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)U}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/	Cindexsqlite_autoindex_accounts_1accounts
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)U}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/	Cindexsqlite_autoindex_accounts_1accounts
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);SQLite format 3@  qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!

!encryption!db_version
!encryption!db_version
=Welcome to pokemon dash!&MWelcome to The Forgotten Server!


M=j
M6
M=jM6	

$''tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)U}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/	Cindexsqlite_autoindex_accounts_1accounts
G
1985616121212M>'0$
23261582326058ZM>3o0
11M=0
232615819856161


Nums1-^0M>(M>U	4dddd

Laks100tM>8M><	I-dddd~4+


Account Manager022M=`ddddd
NumsLaks+Account Manager0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
&U
tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);
----FIM CRU----

consulta SQL:

SQLite format 3@ qte~ytdVcUbSaP`N_K^I]G\E[CZAY>X:V7U4B3>17,2(.#) &!  !encryption!db_version !encryption!db_version =Welcome to pokemon dash!&MWelcome to The Forgotten Server!   M=j M6 M=jM6	  $''tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHAR(35) NOT NULL DEFAULT '', "value" INTEGER NOT NULL, UNIQUE ("config") )9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'indexsqlite_autoindex_server_record_1server_record WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL DEFAULT 0, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL DEFAULT 0, "report" TEXT NOT NULL DEFAULT '', "reads" INTEGER NOT NULL DEFAULT 0 )U}tableaccountsaccountsCREATE TABLE "accounts" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "password" VARCHAR(255) NOT NULL, "premdays" INTEGER NOT NULL DEFAULT 0, "lastday" INTEGER NOT NULL DEFAULT 0, "email" VARCHAR(255) NOT NULL DEFAULT '', "key" VARCHAR(20) NOT NULL DEFAULT '0', "blocked" BOOLEAN NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL DEFAULT 1, UNIQUE ("name") )/	Cindexsqlite_autoindex_accounts_1accounts G 1985616121212M>'0$ 23261582326058ZM>3o0 11M=0 232615819856161   Nums1-^0M>(M>U	4dddd  Laks100tM>8M>< I-dddd~4+   Account Manager022M=`ddddd NumsLaks+Account Manager0, "group_id" INTEGER NOT NULL, "account_id" INTEGER NOT NULL, "level" INTEGER NOT NULL DEFAULT 1, "vocation" INTEGER NOT NULL DEFAULT 0, "health" INTEGER NOT NULL DEFAULT 100, "healthmax" INTEGER NOT NULL DEFAULT 100, "experience" INTEGER NOT NULL DEFAULT 0, "lookbody" INTEGER NOT NULL DEFAULT 10, "lookfeet" INTEGER NOT NULL DEFAULT 10, "lookhead" INTEGER NOT NULL DEFAULT 10, "looklegs" INTEGER NOT NULL DEFAULT 10, "looktype" INTEGER NOT NULL DEFAULT 136, "lookaddons" INTEGER NOT NULL DEFAULT 0, "maglevel" INTEGER NOT NULL DEFAULT 0, "mana" INTEGER NOT NULL DEFAULT 100, "manamax" INTEGER NOT NULL DEFAULT 100, "manaspent" INTEGER NOT NULL DEFAULT 0, "soul" INTEGER NOT NULL DEFAULT 0, "town_id" INTEGER NOT NULL, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "conditions" BLOB NOT NULL, "cap" INTEGER NOT NULL DEFAULT 0, "sex" INTEGER NOT NULL DEFAULT 0, "lastlogin" INTEGER NOT NULL DEFAULT 0, "lastip" INTEGER NOT NULL DEFAULT 0, "save" BOOLEAN NOT NULL DEFAULT 1, "skull" INTEGER NOT NULL DEFAULT 0, "skulltime" INTEGER NOT NULL DEFAULT 0, "rank_id" INTEGER NOT NULL, "guildnick" VARCHAR(255) NOT NULL DEFAULT '', "lastlogout" INTEGER NOT NULL DEFAULT 0, "blessings" INTEGER NOT NULL DEFAULT 0, "balance" INTEGER NOT NULL DEFAULT 0, "stamina" INTEGER NOT NULL DEFAULT 151200000, "direction" INTEGER NOT NULL DEFAULT 2, "loss_experience" INTEGER NOT NULL DEFAULT 100, "loss_mana" INTEGER NOT NULL DEFAULT 100, "loss_skills" INTEGER NOT NULL DEFAULT 100, "loss_containers" INTEGER NOT NULL DEFAULT 100, "loss_items" INTEGER NOT NULL DEFAULT 100, "premend" INTEGER NOT NULL DEFAULT 0, "online" TINYINT NOT NULL DEFAULT 0, "marriage" INTEGER NOT NULL DEFAULT 0, "promotion" INTEGER NOT NULL DEFAULT 0, "deleted" BOOLEAN NOT NULL DEFAULT 0, "description" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "deleted"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id") ) &U tableplayersplayers CREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" ( "account_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL, UNIQUE ("account_id", "player_id"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )= Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" ( "key" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "value" VARCHAR(255) NOT NULL DEFAULT '0', UNIQUE ("key", "world_id") );

Mensagens do MySQL : 

#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 'SQLite format 3' at line 1 







 


sabe como arruma isso??


kmiikze
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 24/02/11Posts: 0Char no Tibia: Pokemon
Postado em março 04, 2011
homens me venda un erro cuando creo la cuenta por la pagina venda me la pokebag y en el suelo y la sem recojer puedo cuando me la creo gerente de conta con el me venda do todo bien ayudaaaa
bruno333
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 18/12/05Posts: 29
Postado em março 04, 2011


@XmaximoX 


 


você esta tentando importa o banco de dados sqlite


 


esse site não tem suporte para sqlite ... somente para Mysql


por isso esta dando esse erro ai


 


vlw espero ter ajudado !!!


342b88685af7e861fa7120f5f9959bde.jpg


Xkings World


http://xkingsworld.servegame.com
cadu12299
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 11/08/10Posts: 11
Postado em março 04, 2011
ha .... então tudo bem valeu mesmo assim  :smile_positivo:
thunder1999
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 23/02/11Posts: 5Char no Tibia: nao
Postado em março 16, 2011
cara esse website tem q usar com Xampp?
JuninMts
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 17/06/09Posts: 0
Postado em março 19, 2011


Percebi ai a dúvida de muita gente em relação ao database, é o seguinte, você não vai utilizar o database "forgotten.s3db" pelo fato de phpmyadmin não reconhecer sqlite, então o database que vocês irão importar pode ser encontrado no seguinte diretório: 


"PASTA-DO-SEU-OT/schemas/mysql.sql". Nesse site também é necessário importar o banco de dados do próprio site, para executar suas funcções como adicionar novas notícias e etc... Para isso você vai no diretório: "PASTA-DO-SITE/documents/schema.sql" e importa esse arquivo no mesmo banco de dados da importação anterior.


 


Na pasta do site você abre o arquivo config.inc.php, e em database ele vai pedir o nome do banco de dados e não o nome do arquivo, não vá confundir... "Mas e aonde eu vejo o nome do banco de dados?" vai no seu phpmyadmin logo na página inicial tem um local pra você criar seu banco de dados e importar o arquivo ".SQL" esse nome será o que você irá colocar lá.


 


//* Primeira contribuição, espero que ajude!  :weight_lift:  *\\


keiker
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 22/02/11Posts: 4Char no Tibia: Ofleo
Postado em março 27, 2011


Dae mano bruno333 poderia me ajudar me add msn se poderia


ofelo@gotmail.com


ajuda ai mano ta complicado aki 


porfavor espero sua resposta


eliasjunior157
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 01/03/11Posts: 21
Postado em março 31, 2011
Ei cara dono do post poderia me ajudar tbm to com muito problema pliz me ajuda add msn ae elias_psy_dance@hotmail.com por favor me add e me ajuda
Hospedagem, Streaming, Dominio, Semi- Dedicados e muito mais é aqui UWH.


xat2.jpg
keiker
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 22/02/11Posts: 4Char no Tibia: Ofleo
Postado em abril 02, 2011
Tenta espesifica mais o Topico e esses locallhost nao entro aki
eliasjunior157
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 01/03/11Posts: 21
Postado em abril 03, 2011


                                  Entao cara no meu esta dando este erro como resolvo este erro?


 


 


Fatal error: Uncaught exception 'DatabaseConnectException'


Message: Unable to connect to mysql server. Please make sure it is up and running and you have correct user/password in config.inc.php.


Online help: More Info


File: sql.php on line: 37


Script was terminated because something unexpected happened. You can report this, if you think it's a bug.


 


Debug Backtrace:Disabled


Hospedagem, Streaming, Dominio, Semi- Dedicados e muito mais é aqui UWH.


xat2.jpg
thunder1999
avatar
Campones
Campones
INFOS
Grupo: CamponesRegistrado: 23/02/11Posts: 5Char no Tibia: nao
Postado em abril 04, 2011




                                  Entao cara no meu esta dando este erro como resolvo este erro?


 


 


Fatal error: Uncaught exception 'DatabaseConnectException'


Message: Unable to connect to mysql server. Please make sure it is up and running and you have correct user/password in config.inc.php.


Online help: More Info


File: sql.php on line: 37


Script was terminated because something unexpected happened. You can report this, if you think it's a bug.


 


Debug Backtrace:Disabled




Vai no C:\xampp\htdocs/config.inc
 


 


$cfg['SQL_Password']e tirar o Password


 


 :button_ok: :button_ok: :button_ok: