Ir para conteúdo

Site Para Poketibia Versões 8.5X

bruno333

Por bruno333
em Lixeira Pública

 Share

Posts Recomendados

bruno333

bruno333 17

Postado
Postado

# 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 !!!






			
		


		

		
			

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
						





					
					
						










	

		
    
			
  • 
				Respostas
				63
			
    • 
			
  • 
				Created
				
			
    • 
			
  • 
				Última resposta
				
			
    • 
		

		
	

	
		

			

				
					

						
Top Posters In This Topic

						
					

				
				
					

						
Popular Days

						
					

				
			

		

	
	
	

		
			

				
Top Posters In This Topic

				
			

		
		
			

				
Popular Days

				
			

		
		
		
	

	
		
	
	






					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					






	

	

	

		

			

				


	
		cadu12299
	

				
				
			

		

		

			

				


cadu12299
              	
				

	
		
	
			 0
	
		
	

			

			

				Postado 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Postado 
			
			
				
				
			
		

	


	

    

	

		
		

			

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??



			
		


		

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/#findComment-1008310
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
					
				

					

					
					






	

	

	

		

			

				


	
		kmiikze
	

				
				
			

		

		

			

				


kmiikze
              	
				

	
		
	
			 0
	
		
	

			

			

				Postado 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Postado 
			
			
				
				
			
		

	


	

    

	

		
		

			
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


			
		


		

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/#findComment-1008408
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
					
				

					

					
					






	

	

	

		

			

				


	
		bruno333
	

				
				
			

		

		

			

				


bruno333
              	
				

	
		
	
			 17
	
		
	

			

			

				Postado 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Autor
    • 
					
					
					
					
					
				

			

			
		


		

			Postado 
			
			
				
				
			
		

	


	

    

	

		
		

			

@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 !!!



			
		


		

		
			

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/#findComment-1008429
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
					
				

					

					
					





					
						
    
							
							
								
  • 
									2 weeks later...
								
    • 
							
						

					
					
					
				

					

					
					





					
					
					
				

					

					
					






	

	

	

		

			

				


	
		JuninMts
	

				
				
			

		

		

			

				


JuninMts
              	
				

	
		
	
			 0
	
		
	

			

			

				Postado 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Postado 
			
			
				
					(editado)
				
				
			
		

	


	

    

	

		
		

			

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:  *\\



			
				


	Editado  por 081094
	
	

			
		


		

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/#findComment-1014675
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					






	

	

	

		

			

				


	
		eliasjunior157
	

				
				
			

		

		

			

				


eliasjunior157
              	
				

	
		
	
			 3
	
		
	

			

			

				Postado 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Postado 
			
			
				
				
			
		

	


	

    

	

		
		

			

                                  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



			
		


		

		
			

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/#findComment-1020366
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
					
				

					

					
					






	

	

	

		

			

				


	
		thunder1999
	

				
				
			

		

		

			

				


thunder1999
              	
				

	
		
	
			 0
	
		
	

			

			

				Postado 
				
			

		

	

	
	

		




	

		

			

				
    
					
					
					
					
					
				

			

			
		


		

			Postado 
			
			
				
				
			
		

	


	

    

	

		
		

			



                                  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:



			
		


		

		
	


	

	





	
Link para o comentário

	
		
	
	
    
         https://xtibia.com/forum/topic/152632-site-para-poketibia-vers%C3%B5es-85x/#findComment-1020797
    

	
	
Compartilhar em outros sites

	

	


	

	

	




	



					
					
					
				
			
			



		

	


	
		

			


	
	

		

	
	
	
	
	
		
	

			
				
					


	


	
		Visitante
	


	

		

			 Este tópico está impedido de receber novos posts. 
		
			
		

	



				
			
		

	

	
		

			

				
					


    
          Share
    

    

				
				
                

                


				
			

		

	







	

		
			
				Ir para a lista de tópicos
			
		
	

	




						


	

		
    
			
				
					
					
  • 

    
    
    
        
            Quem Está Navegando
        
        
          0 membros estão online
        
    
    
    
    
        
      
            
                
    • Nenhum usuário registrado visualizando esta página.
      • 
            
        
    
        
    




    

    • 
				
					
					
  • 
				
			
		

	


					

					


	

		
			


		
		
			
			

		
		
		


	


				

				
				

			

			

      	
		

		
		



	

		×
		

			
				

					
				

			
          	
          	
          	

            	
    
					
  
    				
    					
    • 
    				
  
    				
    					
    • 
    				

					
  
					

					
                  
					
                  		
  • 
							
							
      
								
									
    • 
										
      
											
										
      
									
      • 
								
									
    • 
										
      
											
										
      
									
      • 
								
							
    
						
    • 
  					
              	

          	

			
          
			
          
			

			
		

	






	

		×
		

			
    
				
  • Criar Novo...
    •