BruceW

explaining further you need mysql so you can put the games server data in there, you need php for connecting clients via web browser to register (create or support existing accounts), SVN so you can transfer files from rathena to your hosted server or from your pc to hosted server, Apache or IIS since it is what makes the web server run. you need basic understanding on database management, dns or basic network for hosting servers, web developent, knowledge on rathena ro game icluding its tools for the game... As tool to edit on your pc for client and server files you may need VS, diff patcher, grftool,grf builder, odbg, peviewer, weemapcche, etc

since error is pointing at the field, yes check the sql first also you need to make sure your server and client has the same version....

you need another entry on your table that has a group_id of 0 or 99 do not use your deafult log pass

don't give up, we are at your back, I felt silly when i was starting as well. keep on reading guide and do it / apply it... installation of server is not that hard... however client tuning will be a challenge.

check your table make sure it comes after expiry_time otherwise edit it.... you can choose to delete the field first then redo the command Emistry ask you to run... Also do it only one time... it'll give you error if you run it twice hence duplicate... last part of the fields should look like "....card0, card1, card2, card3, expire_time, favorite" also re-run you sql and server. Since your using workbench, it would be easy without command... go to ragnarok database, right click the inventory table, choose alter table... from here delete the Column Name favorite, hit apply then add it at the very last as a column Name, Datatype will be TINYINT(3) then tick the boxes NN and UN default will be '0', click apply again.

i reported a bug early on was using 2011-03-15... using flywing while Quest window is open gives me error... also... when equipting crown parrot on Rune Knight no error but error when Assassin Cross is equipting it. can you help me? thanks. http://rathena.org/b...window-is-open/

It would be best as always to start with single machine... both server and client.... follow the tutorial as per Judas Bible... after that try moving the client to another machine letting it run via LAN... when it works you can mke your Pages for support on registration and server forum... then move it or make it public via running it on a hosted site or your own made WAN connection. If you encounter any problem along the way feel free to post again but make sure it is detailed enough for us to debug and understand.

we can help you better if you post or share your configs cause normally by your post thats where we are gonna look... another thing is... do you have any errors on sql data is your login monitored and ok without error... just so we do not need to look at sql permission and config... example... have you retrieve the basic sql file needed to run the map like item_db, mob_db etc... lastly, try what i did, use 127.0.0.1 address all the way... use the same machine as server and client so you do not need to change the address... when it's working then you can change the address.

is the mapserver the only one having problem? if so... check the /conf/map_athena.conf check login, passwd, char_ip, char_port, map_ip, map_port make sure values are as tutorial suggested unless you have your custom password or IP

Can you provide us more info like server/client version, sql model, what part is it actually in the game thata gives error? by the looks of things you are trying to debug something in C++ or VS

not much peeps use SQL for CentOS i suggest google it out on a CentOS / SQL support site... if it's the game proper on rAthena many indiv will help you here. Personal i like mysql / mysql workbench (windows) since you do not need to issue commands .... it's more Graphically assisted...

on client RO make sure they connect to the server IP address... ON CLIENT SIDE: From client Folder go to data folder open the clientinfo.xml and change the IP address to the server IP address.... like say if your RO server is 192.168.0.5 other computer playing and connection to the game would have 192.168.0.6 , 192.168.0.7 and so on.... ON SERVER SIDE: use 127.0.0.1 for all mapserver, logserver and char server.... no problem on that config

Here is a simple guide to help you make your server working for public use... Example only: Physical> RO SERVER <------------------> Router<-------------------->ISP<-------------> Internet <---->Customer IP Add> 192.168.0.2 ........ 192.168.0.254 / 202.1.52.4 ............. 202.1.52.1 ................................192.168.0.2 Prt frwd>........................................6900 to 6900 (using the IP above) ......................................................5121 to 5121 ......................................................6121 to 6121 DNS Reg>..........................................................................202.1.52.4 = www.myro.com.ph ...........................................................................................register on your country's DNS Client>..................................................................................................................................................client must look .............................................................................................................................................................for either 202.1.52.4 .............................................................................................................................................................or your registered .............................................................................................................................................................www.myro.com.ph If you do not know how to port forward, here is an example in youtube, he uses a d-link router opening port for warcraft, in your case use RO using ports above... [media=]http://www.youtube.com/watch?v=3_LbUpXGV7I[/media] To check if you successfully opened the port, use this site and type the port you like to test... http://www.yougetsig...ols/open-ports/ The DNS registration i needed so clients can find where you are either via IP (202.1.52.4) or DNS Name (www.myro.com.ph) This is only a guide please feel free to edit it as you like.

If im gonna ban somebody it would be through their account not NIC address nor IP address... I Also have the luxury of changing (when you update) you client knowing who you are... call it a sh!t marker. try using another account on a original client with another NIC on another router IP settings. That will surely work.

I have error when i use flywing while Quest Window is open, how do i fix it... client and server running 2011-03-15, thanks, Bruce Module Name: RO.exe Time Stamp: 0x4d7f06a5 - Tue Mar 15 16:26:45 2011 Exception Type: 0xc0000005 eax: 0x05749728 ebx: 0x0089dc58 ecx: 0x05d869c8 edx: 0x00000000 esi: 0x008368a8 edi: 0x00000001 ebp: 0x00000000 esp: 0x0012fb18 stack 0012fb18 - 0012ff18 0012FB18 : DB 00 53 00 00 00 00 00 17 00 00 00 00 00 00 00 0012FB28 : 00 00 00 00 00 00 00 00 00 00 00 00 A8 12 F8 00 0012FB38 : 00 00 00 00 30 27 11 21 27 EE 6F 00 B9 20 8E 1D 0012FB48 : 01 00 00 00 F0 5B 89 00 00 00 00 00 01 24 80 7C 0012FB58 : 58 DC 89 00 FC FB 12 00 13 C4 76 00 FF FF FF FF 0012FB68 : 78 08 60 00 81 20 8E 1D 01 00 00 00 78 A9 79 03 0012FB78 : 01 24 80 7C 13 01 00 00 4C 6C 00 00 1F DE CA 0F 0012FB88 : B0 24 11 21 CD AB BA DC 00 00 00 00 D8 FB 12 00 0012FB98 : B0 24 11 21 04 FC 12 00 D9 8B 41 7E 74 33 89 00 0012FBA8 : 58 CB 7F 00 74 33 89 00 65 38 5A 00 ED 6C 6B 03 0012FBB8 : F0 5B 89 00 58 CB 7F 00 4E 01 00 00 00 00 00 00 0012FBC8 : 4B 56 42 00 F0 5B 89 00 ED 6C 6B 03 4E 01 00 00 0012FBD8 : 58 CB 7F 00 4E 01 00 00 51 3B 42 00 4E 01 00 00 0012FBE8 : F0 5B 89 00 01 00 00 00 78 A9 79 03 E8 02 8E 1D 0012FBF8 : 8D 20 8E 1D 98 FC 12 00 AD 71 76 00 FF FF FF FF 0012FC08 : 57 53 61 00 F0 5B 89 00 E5 27 8E 1D 4F 4E B4 76 Launch Info 00C7 00C7 00C7 00C7 00A4 0000 00C7 00C7 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 Job : Assassin ---------------------------------------------------- Also another error while Equipting crown parrots[1] Module Name: RO.exe Time Stamp: 0x4d7f06a5 - Tue Mar 15 16:26:45 2011 Exception Type: 0xc0000005 0x0042e3d0 RO.exe 0x005c4f31 RO.exe eax: 0x0012fb6c ebx: 0x05770a70 ecx: 0x00000000 edx: 0x00000000 esi: 0x00000262 edi: 0x037e4d78 ebp: 0x0012fc00 esp: 0x0012fb68 stack 0012fb68 - 0012ff68 0012FB68 : EA CB 14 AE 98 FC 12 00 1E 0D 74 00 FF FF FF FF 0012FB78 : 6F E4 42 00 00 00 00 00 00 00 00 00 52 A6 55 00 0012FB88 : 00 00 00 00 00 00 00 00 78 4D 7E 03 62 02 00 00 0012FB98 : 70 0A 77 05 00 00 00 00 00 00 00 00 00 00 00 00 0012FBA8 : 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0012FBB8 : 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0012FBC8 : 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0012FBD8 : 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0012FBE8 : 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0012FBF8 : 00 00 00 00 00 00 00 00 14 02 00 00 31 4F 5C 00 0012FC08 : 62 02 00 00 14 02 00 00 00 00 00 00 00 00 00 00 0012FC18 : 00 00 00 00 00 00 00 00 00 00 80 3F 00 00 00 00 0012FC28 : FF FF FF FA B6 CC 14 AE 00 00 00 00 78 4D 7E 03 0012FC38 : 01 00 00 00 46 24 80 7C A8 DB 9D 05 70 0A 77 05 0012FC48 : A8 68 83 00 08 A3 5F 05 17 FF FF FF 13 00 00 00 0012FC58 : 1F 00 00 00 F3 01 00 00 20 0A 77 05 50 02 00 00 Launch Info 00E9 018E 018D 016A 016A 00A4 00E9 00A4 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 Job : Assassin Cross

ty vm -------------------------------------------------------- i see http://ratemyserver....&map=moc_fild01 is diff from http://ratemyserver.net/index.php?page=npc_shop_warp&map=moc_fild01&re_mob=1

Newbie here... Can you point me in the right direction? Problem: i would like to edit the what monsters to put in particular maps sunch as prontera, fld or dun... how do i do this? which table shall i use? also do you have a sql file for the original monsters located on map in case i screw up? Thanks, BruceW

I've tried the one in trunk, it's not the original job quest (first job) do you have an older version... where to be a swordy you go to izlude then walk nd not fall.... to be thief you pick up mushrooms...to be archer you gather woods and so on. Thanks in Advance, BruceW

First off i wanna apologize cause i do not know if this is the right forum section... it might be for server side or somewhere else. Problem: i currently have an edited NPC job quest but i want to revert back to the original job (NPC) quest where players can change job as per ratemyserver job quest. I wanted my players to experience what i experience from novice to the regular NPC job change like... if you want to change as swordsman you go to izlude... if thief you go morocc and so on... Is there a guide for this or a repository of original npc scripts maps etc... Thanks in advance, BruceW

@Euphy got it thanks i'll test them all

i got the server working and client as well... Question: Being new and all how do i display GM Command? I'm using 2011-03-15. Do we have a guide somewhere here in term of game administration? Thank, BruceW

problem fix my Clientinfo.xml is in my root it should be located at the data folder

"Error: geoip_cache reading didn't read all elements" howv do i fix this problem... thanks.

how exactly does Data.ini and Clientinfo.xlm work.... i thought it would be like data.ini will declare the GRF files for picture and sound while Clientinfo.xml will declare the connection for my client's EXE sure the exe get the picture from the GRF to display the look you like for character menu... but that is not my problem right now... my problem is connection of my client exe+clientinfo.xml to my mysql... as i've said my sql is stale or not moving. sorry im confused now. Thank you for your patience. my log_db_db is "log" while my passwords are all the same but not ragnarok logserver connects to the char server same with map... all green or white color no warnings or errors... Do i need to add another account/priviledge for "ALL USERS of the server" on my RO Db or will the current (as per guide) will suffice? Is the exe nailed to password ragnarok? do i need to hex for this purpose? I;ve tried 2 clients ragexe 2010-08-17 and 2011-03-15 no connection on mysql

i followed the install guide and this is what i have... on SQL Dev i got my localhost connection on Serv admin i got mysql@localhost instance under manage security @ mysql@localhost instance i got ragnarok as user with admin roles Mon Admin, DBM, DBD, BackupAdm on schem Priv under ragnarok i got log and ragnarok as schema all priviledges... additional info on my xml port is 6900 ver 28 langtype 1 anything i did wrong? thanks,