GameOver

November 15, 2014

hi friends I'm having trouble with the connection to the server, connect everything right and when I enter the map it's a mistake.

disconnected from the server (3)

http://imgur.com/3YZrZDS,0FBXJBp,Y6ppsj5

http://imgur.com/3YZrZDS,0FBXJBp,Y6ppsj5#1

http://imgur.com/3YZrZDS,0FBXJBp,Y6ppsj5#2

your packet version and clientinfo version are wrong. change it .. and find a lates packetdb for your client.exe

and how do I do this friend?

November 15, 2014

hi friends I'm having trouble with the connection to the server, connect everything right and when I enter the map it's a mistake.

disconnected from the server (3)

http://imgur.com/3YZrZDS,0FBXJBp,Y6ppsj5

http://imgur.com/3YZrZDS,0FBXJBp,Y6ppsj5#1

http://imgur.com/3YZrZDS,0FBXJBp,Y6ppsj5#2

November 15, 2014

Try to create a new database for your logs.sql,

create database ragnalog;

then upload the sql-files/logs.sql inside the ragnalog database then change your inter_athena.conf to this:
// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: vertrigo
log_db_db: ragnalog
log_codepage:
log_login_db: loginlog

OMGGGGGGGGGGG...........

O_O

you made it work thks Thks Thks....

Thks >D

November 15, 2014

https://github.com/rathena/rathena/blob/master/sql-files/logs.sql

Nada nao resolveu!

antes pedia ragnarok.logis...

agora ta pedindo ragnarok.ragnarok

pode ser essa pasta mesmo o_O

Tpw cara se um dia voce tiver animado nois tenta fazer um acesso remoto aqui pra voce ver a situaçao!

November 14, 2014

Como posso fazer isso? Eu estou usando a versão mais recente do rathena

verificar o seu banco de dados que você não tem mesa "loginlog" em seu banco de dados é indicado em seu erro.

Como posso fazer isso? Eu estou usando a versão mais recente do rathena

i add...

#PickLog types (M)onsters Drop, (P)layers Drop/Take, Mobs Drop (L)oot Drop/Take,

# Players (T)rade Give/Take, Players (V)ending Sell/Take, (S)hop Sell/Take, (N)PC Give/Take,

# ©onsumable Items, (A)dministrators Create/Delete, Sto®age, (G)uild Storage,

# (E)mail attachment,(B)uying Store, Pr(O)duced Items/Ingredients, Auct(I)oned Items,

# (X) Other, (D) Stolen from mobs, (U) MVP Prizes

#Database: ragnarok

#Table: picklog

CREATE TABLE IF NOT EXISTS `picklog` (

`id` int(11) NOT NULL auto_increment,

`time` datetime NOT NULL default '0000-00-00 00:00:00',

`char_id` int(11) NOT NULL default '0',

`type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','$') NOT NULL default 'P',

`nameid` smallint(5) unsigned NOT NULL default '0',

`amount` int(11) NOT NULL default '1',

`refine` tinyint(3) unsigned NOT NULL default '0',

`card0` smallint(5) unsigned NOT NULL default '0',

`card1` smallint(5) unsigned NOT NULL default '0',

`card2` smallint(5) unsigned NOT NULL default '0',

`card3` smallint(5) unsigned NOT NULL default '0',

`unique_id` bigint(20) unsigned NOT NULL default '0',

`map` varchar(11) NOT NULL default '',

`bound` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`id`),

INDEX (`type`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators,(E)Mail,(B)uying Store

#Database: ragnarok

#Table: zenylog

CREATE TABLE IF NOT EXISTS `zenylog` (

`id` int(11) NOT NULL auto_increment,

`time` datetime NOT NULL default '0000-00-00 00:00:00',

`char_id` int(11) NOT NULL default '0',

`src_id` int(11) NOT NULL default '0',

`type` enum('T','V','P','M','S','N','D','C','A','E','I','B','K') NOT NULL default 'S',

`amount` int(11) NOT NULL default '0',

`map` varchar(11) NOT NULL default '',

PRIMARY KEY (`id`),

INDEX (`type`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok

#Table: branchlog

CREATE TABLE IF NOT EXISTS `branchlog` (

`branch_id` mediumint(9) unsigned NOT NULL auto_increment,

`branch_date` datetime NOT NULL default '0000-00-00 00:00:00',

`account_id` int(11) NOT NULL default '0',

`char_id` int(11) NOT NULL default '0',

`char_name` varchar(25) NOT NULL default '',

`map` varchar(11) NOT NULL default '',

PRIMARY KEY (`branch_id`),

INDEX (`account_id`),

INDEX (`char_id`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok

#Table: mvplog

CREATE TABLE IF NOT EXISTS `mvplog` (

`mvp_id` mediumint(9) unsigned NOT NULL auto_increment,

`mvp_date` datetime NOT NULL default '0000-00-00 00:00:00',

`kill_char_id` int(11) NOT NULL default '0',

`monster_id` smallint(6) NOT NULL default '0',

`prize` smallint(5) unsigned NOT NULL default '0',

`mvpexp` mediumint(9) NOT NULL default '0',

`map` varchar(11) NOT NULL default '',

PRIMARY KEY (`mvp_id`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok

#Table: atcommandlog

CREATE TABLE IF NOT EXISTS `atcommandlog` (

`atcommand_id` mediumint(9) unsigned NOT NULL auto_increment,

`atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00',

`account_id` int(11) unsigned NOT NULL default '0',

`char_id` int(11) unsigned NOT NULL default '0',

`char_name` varchar(25) NOT NULL default '',

`map` varchar(11) NOT NULL default '',

`command` varchar(255) NOT NULL default '',

PRIMARY KEY (`atcommand_id`),

INDEX (`account_id`),

INDEX (`char_id`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok

#Table: npclog

CREATE TABLE IF NOT EXISTS `npclog` (

`npc_id` mediumint(9) unsigned NOT NULL auto_increment,

`npc_date` datetime NOT NULL default '0000-00-00 00:00:00',

`account_id` int(11) unsigned NOT NULL default '0',

`char_id` int(11) unsigned NOT NULL default '0',

`char_name` varchar(25) NOT NULL default '',

`map` varchar(11) NOT NULL default '',

`mes` varchar(255) NOT NULL default '',

PRIMARY KEY (`npc_id`),

INDEX (`account_id`),

INDEX (`char_id`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat

#Database: ragnarok

#Table: chatlog

CREATE TABLE IF NOT EXISTS `chatlog` (

`id` bigint(20) NOT NULL auto_increment,

`time` datetime NOT NULL default '0000-00-00 00:00:00',

`type` enum('O','W','P','G','M') NOT NULL default 'O',

`type_id` int(11) NOT NULL default '0',

`src_charid` int(11) NOT NULL default '0',

`src_accountid` int(11) NOT NULL default '0',

`src_map` varchar(11) NOT NULL default '',

`src_map_x` smallint(4) NOT NULL default '0',

`src_map_y` smallint(4) NOT NULL default '0',

`dst_charname` varchar(25) NOT NULL default '',

`message` varchar(150) NOT NULL default '',

PRIMARY KEY (`id`),

INDEX (`src_accountid`),

INDEX (`src_charid`)

) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok

#Table: loginlog

CREATE TABLE IF NOT EXISTS `loginlog` (

`time` datetime NOT NULL default '0000-00-00 00:00:00',

`ip` varchar(15) NOT NULL default '',

`user` varchar(23) NOT NULL default '',

`rcode` tinyint(4) NOT NULL default '0',

`log` varchar(255) NOT NULL default '',

INDEX (`ip`)

) ENGINE=MyISAM ;

#Database: ragnarok

#Table: cashlog

CREATE TABLE IF NOT EXISTS `cashlog` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`char_id` int(11) NOT NULL DEFAULT '0',

`type` enum('T','V','P','M','S','N','D','C','A','E','I','B','$') NOT NULL DEFAULT 'S',

`cash_type` enum('O','K','C') NOT NULL DEFAULT 'O',

`amount` int(11) NOT NULL DEFAULT '0',

`map` varchar(11) NOT NULL DEFAULT '',

PRIMARY KEY (`id`),

INDEX `type` (`type`)

) ENGINE=MyISAM AUTO_INCREMENT=1;

not resolved

November 14, 2014

You are missing the tables required for SQL logging. Be sure to execute sql-files/logs.sql on your server (same way you loaded main.sql).

Check your map_athena.conf as well, ensure you configured the server IP there.

Edit: Also this is not a support thread. See http://rathena.org/board/forum-2/announcement-1-this-section-is-not-a-support-section/

yes am importing it in Vertrigo but keeps giving error, did the same thing I did with mainsql

November 14, 2014

Não tem mais nada, só adicionar as tabelas da log e pronto..

Olha manolo o meu ta assim to com a conf padrao tpw ta tudo blz so esse erro que nao to conseguindo resolver.

// MySQL Login server

login_server_ip: 127.0.0.1

login_server_port: 3306

login_server_id: root

login_server_pw: vertrigo

login_server_db: ragnarok

login_codepage:

login_case_sensitive: no

ipban_db_ip: 127.0.0.1

ipban_db_port: 3306

ipban_db_id: root

ipban_db_pw: vertrigo

ipban_db_db: ragnarok

ipban_codepage:

// MySQL Character server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: root

char_server_pw: vertrigo

char_server_db: ragnarok

// MySQL Map Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: root

map_server_pw: vertrigo

map_server_db: ragnarok

// MySQL Log Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: root

log_db_pw: vertrigo

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

November 14, 2014

My server is giving error that table does anyone know to resolve?

http://imgur.com/XmDtgJ8

It's because you put a wrong information on the inter_athena.conf inside conf folder.

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: mysqlusername
login_server_pw: mysqlpassword
login_server_db: uprise
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: mysqlusername
ipban_db_pw: mysqlpassword
ipban_db_db: maindbname
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: mysqlusername
char_server_pw: mysqlpassword
char_server_db: maindbname

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: mysqlusername
map_server_pw: mysqlpassword
map_server_db: maindbname

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: mysqlusername
log_db_pw: mysqlpassword
log_db_db: logssqlname
log_codepage:
log_login_db: loginlog

I'm using the standard conf

// MySQL Login server

login_server_ip: 127.0.0.1

login_server_port: 3306

login_server_id: root

login_server_pw: vertrigo

login_server_db: ragnarok

login_codepage:

login_case_sensitive: no

ipban_db_ip: 127.0.0.1

ipban_db_port: 3306

ipban_db_id: root

ipban_db_pw: vertrigo

ipban_db_db: ragnarok

ipban_codepage:

// MySQL Character server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: root

char_server_pw: vertrigo

char_server_db: ragnarok

// MySQL Map Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: root

map_server_pw: vertrigo

map_server_db: ragnarok

// MySQL Log Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: root

log_db_pw: vertrigo

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

November 14, 2014

My server is giving error that table does anyone know to resolve?

http://imgur.com/XmDtgJ8

November 14, 2014

I know that missing a table ta the problem and do not know where I am missing ...

already changed some things in the main folder and log sql plus not resolved

http://imgur.com/XmDtgJ8

November 14, 2014

i can't see the message. but, I saw some aqua and purple colors, I'm assuming it's SQL problem.

drop your ragnarok database and make a new one, load main.sql and logs.sql there.

already tried to do this so that you do not have any to getting to and to get me?

excuse my English I am not very good in English

November 14, 2014

a própria imagem já diz, ta faltando tabelas.

sim manolo veio so que tpw eu vi oque tava faltando e coloquei so que continua o erro,voce nao teria uma base onde e o problema pra me ajudar...?

Alias to usando a nova versao que saiu.

Obrigado pela atenção tava ficando doido ja kkkk.

November 13, 2014

I have a problem in the emulator, when I connect

it's disconnected from the server

HELP Please!

November 13, 2014

Olha ae o problem ... PORQUE nao intendi nada !!

[Attachment = 11268: help.png]

Quando conecto não Servidor e tal crio o char, quando Vai ENTRAR nenhum mapa da Desconectado!

November 13, 2014

Você está olhando para 'down'load os arquivos para rAthena?

https://github.com/rathena/rathena

Você postou na seção de banco de dados Im supondo que você precisa para encontrar os arquivos de banco de dados?!?!?!

rAthena / db / (aqui)

https://github.com/rathena/rathena/tree/master/db

Thank you santa poring rathena was the link I was not thinking

Sorry my English! I do not speak very well! I'm Brazilian

November 13, 2014

need to know where down the necessary files to the server.

PLEASE!

November 13, 2014

Usaposkapokspoaks....

Nao to conseguindo achar os programas que cria servidor com o rathenas alguem ae pode me passa os links atualizados abraço a todos!

Sign In

GameOver

Posts

Joined

Last visited

Content Type

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by GameOver

helpProblem connecting to the server! "clif_parse"

helpProblem connecting to the server! "clif_parse"

[Resolvido]helpMy server is giving error that table does anyone know to resolve?

[Resolvido]Problema na conf. do emulador!

[Resolvido]helpMy server is giving error that table does anyone know to resolve?

[Resolvido]helpMy server is giving error that table does anyone know to resolve?

[Resolvido]Problema na conf. do emulador!

[Resolvido]helpMy server is giving error that table does anyone know to resolve?

[Resolvido]helpMy server is giving error that table does anyone know to resolve?

[Resolvido]I have a problem in the emulator!

[Resolvido]I have a problem in the emulator!

[Resolvido]Problema na conf. do emulador!

[Resolvido]I have a problem in the emulator!

[Resolvido]Problema na conf. do emulador!

[Resolvido]need to know where down the necessary files to the server.

[Resolvido]need to know where down the necessary files to the server.

[Resolvido]galera me passa o link ae do rathena que nao to achando abraço!

Docs

Get Started

Github

Community

My Account