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