omimo

August 19, 2012

ahm actually i don't get any errors from it, i always get stuck after entering the server selection.

August 19, 2012

Here's my console status:

and then after i enter the server i always got stuck, how can i resolve this part?

Thank you

August 18, 2012

at your inter_athena.conf

Try this:

log_db_db: ragnarok

and change that to

log_db_db: log

August 15, 2012

ok i see, thank you

August 15, 2012

after i change the log_db_db: ragnarok to log_db_db: log it says this:

http://img829.images...65/68612118.png

sir these are the step i did for setting up mysql server:

1.new instance

>localhost

>username:ragnarok

>password:ragnarok

2.Query Database

>New schema>ragnarok

>New schema>log

>ragnarok schema>open script>main.sql

>log schema>open script>logs.sql

3.management security

>new account>login name: ragnarok>connectivity: 127.0.0.1>password: ragnarok

>new account>login name: logs>connectivity: 127.0.0.1>password: ragnarok

4.Schema Privilege

>ragnarok>selected port>selected schema: ragnarok>select all

>logs>selected port>selected schema: log>select all

my inter_athena.conf(didn't do anything here)


// Global SQL settings
// overriden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: ragnarok
sql.db_password: ragnarok
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: ragnarok
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: ragnarok
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

my logs.sql

#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 `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` int(11) NOT NULL default '0',
 `amount` int(11) NOT NULL default '1',
 `refine` tinyint(3) unsigned NOT NULL default '0',
 `card0` int(11) NOT NULL default '0',
 `card1` int(11) NOT NULL default '0',
 `card2` int(11) NOT NULL default '0',
 `card3` int(11) NOT NULL default '0',
 `map` varchar(11) NOT NULL default '',
 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 `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('M','T','V','S','N','A','E','B','I','D') 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 `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 `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` int(11) 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 `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 `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 `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 `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 ;

every time i run the logserv_sql it always says this part (frustrated)

http://imageshack.us...51/37915219.png

i've tried everything X_x

did i do anything wrong to have an error in my logserv_sql console

Thank You

August 14, 2012

sir i did add the logs.sql to log schema, after i change the log_db_db: ragnarok to log_db_db: log it says this:

http://img829.images...65/68612118.png

sir these are the step i did for setting up mysql server:

1.new instance

>localhost

>username:ragnarok

>password:ragnarok

2.Query Database

>New schema>ragnarok

>New schema>log

>ragnarok schema>open script>main.sql

>log schema>open script>logs.sql

3.management security

>new account>login name: ragnarok>connectivity: 127.0.0.1>password: ragnarok

>new account>login name: logs>connectivity: 127.0.0.1>password: ragnarok

4.Schema Privilege

>ragnarok>selected port>selected schema: ragnarok>select all

>logs>selected port>selected schema: log>select all

my inter_athena.conf(didn't do anything here)

// Global SQL settings

// overriden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok

char_server_pw: ragnarok

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok

map_server_pw: ragnarok

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

did i do anything wrong to have an error in my logserv_sql console?

August 13, 2012

ahm i tried to replace it in the logs.sql and debug it. i got the same error on the logserv_sql console

August 13, 2012

ahm i've manage to run it but one the on the logserv_sql console it says:

http://img850.imageshack.us/img850/2067/99668295.png

how can i resolve this?

i followed everything on setting up sql server/installation and everything is working.

August 13, 2012

You can use this: supportmii.com/ro1/JudasBible.pdf

August 13, 2012

i've tried the schema priviledge but i dont see ragnarok schema.

i'm crap, i'm sorry coz i don't know anything at all when using my sql coz whenever i download pre-compiled svn's i always go for text.

August 12, 2012

well i'll have to check ur MySQL ro know if its right and btw why are you're passwords s1 an p1 lol Did you Configure MySQL Admin?

are you sure its the pass and user to MySQL That you added in inter.conf?

no, ok i will change it to the default settings for userid and pwid (ragnarok)

August 12, 2012

You are misunderstanding the s1 / p1 part. This one is defined in the map_athena.conf & char_athena.conf. And this one is also defined in the login sql database.

Do you even have a SQL database setup?

no, i will change it to the default setting which is "ragnarok"

August 12, 2012

ahm i changed everything here's the one i did

// Global SQL settings

// overriden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: s1

sql.db_password: p1

sql.db_database: ragnarok

sql.codepage:

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 6121

char_server_id: s1

char_server_pw: p1

char_server_db: ragnarok

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 5121

map_server_id: s1

map_server_pw: p1

map_server_db: ragnarok

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 6900

log_db_id: s1

log_db_pw: p1

log_db_db: ragnarok

log_codepage:

log_login_db: loginlog

is this right?

August 12, 2012

yes i've followed that one also

August 12, 2012

ahm, at first it is set as ragnarok, actually i've just downloaded everything from here : https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/ and i'm just changing everything.

hope you can help me

August 12, 2012

I've already change username and password to s1 and p1 and change the char map login server port tru c++ and debug it still i got this message

http://img853.imageshack.us/img853/9382/86752821.png

Thank you for the help

August 12, 2012

http://rathena.org/wiki/SVN_Checkout

Thank you sir!!

August 11, 2012

Uh don't go there.. you must go into the /trunk section: https://rathena.svn..../rathena/trunk/

Yes, i've downloaded the turtoiseSVN and i'm having a little problem using it.

Thank you

August 10, 2012

Ah i see, its just kinda confusing what to use whether 3ceam or rathena. coz from what i heard rathena is the older version while the 3ceam is the newer version.

Ahm By the way i saw this on the SVN tab

https://rathena.svn.sourceforge.net/svnroot/rathena/

how do i use this?

August 10, 2012

ahm i'm not sure if i'm correct or wrong does rathena is supported by 3rd classes ?

August 10, 2012

Hi where can i download the latest 3ceam SVN compilations?

Thank you

August 10, 2012

Ahm, where can i find the "latest" svn compiled downloads.

Thank you

July 22, 2012

Sir ganun parin po eh, kahit naka sorcerrer na ako at pag sinamon tru skill at meron ding requirements wala talagang nalabas, di naman siya skill fail/delay. nagtataka nga po ako e

July 21, 2012

kahit may item requirement na ako bakit hinde parin sila nalabas pero pag @summon agni/ventus/aqua/tera nalabas naman sila kaso nga lang hinde lang sila nagalaw.

O_O" paano po ayusin to?

salamat

June 4, 2012

"Ahm, i'm looking on data.grf and searching for gloria/adoramus sound effect but it is zero found, where can i look for the sound effects of the skills?

Thank you!"

end of discussion

please close it.

Thank you, Sorry for the trouble

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by omimo