[Help Thread] Please post your questions here.

08/12/2013 10:10 Nada92#2296
excuse me one more noobs question

im beginner at sql things and editing servers so i would ask how to import sql file into Arcadia database.
i've downloaded an NPCResource.sql file and i would know how do i replace it with the old one or how to insert it as a new one.[ because i deleted my old NPCResource.sql file ]
simply like this
[Only registered and activated users can see links. Click Here To Register...]

+

can somebody give me the ID of Master class Belts please ?



Thank you :)
08/12/2013 14:56 thund22222#2297
hello,
I need help changing the prices of tools during the sale of NPc's
Not the procurement process.
08/12/2013 16:15 tokesbowls#2298
could someone please tell me where to locate the abuselist.txt thank you
08/12/2013 17:20 Player95#2299
Clientdump/txt/abuse_list.txt
08/12/2013 17:25 ThunderNikk#2300
Quote:
Originally Posted by tokesbowls View Post
could someone please tell me where to locate the abuselist.txt thank you
Sure it is in your client in data.007

Dump your client and you will find it.

It resources as qtY(CEJXt%-O4p2s
08/12/2013 19:46 opie1225#2301
thnder... hey man could you help me out i hd to redo my entire computer and i got my rapplez server back up but when i try and login it says "can not connect to login server" any thoughts is greatly appreciated
i had to completely re install every thing even mssql but i did manage to save my BAK files from before and restored them to the new one
08/12/2013 19:52 ThunderNikk#2302
Did you skip the SQL configuration step (port 1433)

Did you open the ports you needed to open again through the firewall.

This is usually either client mismatch (hopefully you saved your working client), or it is a port or address issue (sometimes also involving the .opt files.)
08/12/2013 20:13 opie1225#2303
no i didnt skip it and when upload,princess,and captian is running a port checker says that 1433 is open i changed my ip address in the opt file and the client works cause i use it to log in a friend of mines game as well just cant log into mine now lol , i just completely took sql out again and reinstalling it now maybe i did miss something
08/12/2013 20:25 c1ph3r#2304
Quote:
Originally Posted by opie1225 View Post
no i didnt skip it and when upload,princess,and captian is running a port checker says that 1433 is open i changed my ip address in the opt file and the client works cause i use it to log in a friend of mines game as well just cant log into mine now lol , i just completely took sql out again and reinstalling it now maybe i did miss something
This isn't a sql issue. looks like authserver port isn't open in your firewall.
08/12/2013 20:36 opie1225#2305
thats what i thought but i checked and even turned off my firewall but to late now im redownloading mssql 2012 now and will try it again.and this time make sure the firewall is not stopping any thing ill let you know in about an hour or so whats going on thank you guys again
08/12/2013 21:43 ThunderNikk#2306
Just remember 1433 is the SQL port you will also need 8841 open for auth for the IO port. The game client connects on 8841 in the launcher arguments.

As long as you did not change the IO port in the .opt files.
08/12/2013 21:44 ahmadkuhail#2307
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
08/12/2013 21:46 ThunderNikk#2308
This is my reply to your thread outside the "Help Thread"...

Did you start the upload server.

It is only needed for guild icons, and there is a whole lot more you will need to do to get the guild icons working, so the fact that this is a problem is really only a matter of opinion.

I don't see it as a problem.

Next time please use the help thread...

[Only registered and activated users can see links. Click Here To Register...]

It exists for "problems" like this.
08/13/2013 00:15 opie1225#2309
Quote:
Originally Posted by c1ph3r View Post
This isn't a sql issue. looks like authserver port isn't open in your firewall.
and

Quote:
Originally Posted by thndr View Post
Just remember 1433 is the SQL port you will also need 8841 open for auth for the IO port. The game client connects on 8841 in the launcher arguments.

As long as you did not change the IO port in the .opt files.
i opened the ports in my router and my firewall i have checked my .opt files and i just dont know i never had this problem before
AuthServer.....
S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S db.auth.port:1433
S io.auth.port:8841
S app.name:auth
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000
S db.auth.md5_key:
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0
N billing.user_keep_alive_interval:30000

GameServer....
S:app.name:game001
N:auth.server_idx:1
S:auth.server_name:Radioactive
S:db.c._password:
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:127.0.0.1
S:db.user._password:
S:db.user.account:sa
S:db.user.server:127.0.0.1
N:game.AdultServer:1
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.broadcast_event_item_pickup:0
T:game.cash_usable_server:0
F:game.chaos_drop_rate:1
N:game.check_storage_security_always:0
N:game.enhance_fail_type:2
F:game.exp_rate:1
F:game.gold_drop_rate:1
F:game.item_drop_rate:1
N:game.limit_field_logout:0
N:game.local_flag:8192
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
N:game.min_booth_startable_level:20
N:game.min_global_chat_usable_level:1
F:game.mod:0.2
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1
F:game.premium_pcbang_chaos_bonus_rate:0.1
N:game.restrict_banword_for_booth:1
N:game.use_auto_jail:0
N:game.use_auto_trap:0
N:game.use_delete_security:0
N:game.use_play_point:0
N:game.use_security:0
N:game.use_storage_security:0
N:io.max_connection:5000
N:log.chat.working:0
N:CodePage:1256
N:game.ServiceServer:1
S:game.caution_url:
S:game.guild_icon_base_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.server_screenshot_url:
N:game.update.version:24
S:game.url_list:
N:game.version:200610030
S:io.auth.ip:127.0.0.1
S:io.ip_address:***.***.**.***
N:io.port:4514
S:io.user_count_ip_mask:
S:log.ip:127.0.0.1
N:game.global_chat_restrict_level:20
S:log.chat.ip:127.0.0.1
N:game.security_solution_type:0
N:game.disable_buy_booth:0
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:upload.server_name:game001
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
S:console.allow_ip:127.0.0.1
S:console._password:
S log.working:0

gamelog error....
2013/08/12 17:58:54 onDeInit is called with SDS 0x00000000.
08/13/2013 00:28 ThunderNikk#2310
That game server .opt is a mess. You have a colon after every begging letter and should not it probably cant read anything.

What is wrong with using stuff from the actual guide?

N:io.port:4514

should be...

S io.port:4504

Example of a game server .opt without all the typos...


Just compare your authserver.opt to your gameserver.opt and you can see what is wrong.