[Help Thread] Please post your questions here.

kastuki · 09/14/2015, 23:54

Hello, I would like create my Pserver with 9.1 files. I use Hamachi.
I have install SQL, config SQL and install database (Arcadia, auth,..)
I have a problem when I start "Princess" and "Captain", there are no troubles.. But when I start the game I can't enter in my account.
So I have look "Princess" and "Captain" and i have see that:

My AuthServer.opt:
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 app.name:auth
S io.auth.port:8841
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:2011
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0

My GameServer.opt:
S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:Pixie
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:127.0.0.1
S:db.user.account:sa
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster1
N:io.port:4504
S:io.auth.ip:25.89.112.44
S:io.ip_address:25.89.112.44
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:1
T:log.working:0
F:game.exp_rate:90
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
T:game.update.version:24
F:game.gold_drop_rate:90
F:game.item_drop_rate:90
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
N:game.local_flag:8192
T:game.min_global_chat_usable_level:5
T:game.use_auto_trap:0
T:game.use_auto_jail:0
N:CodePage:1256
T:game.ServiceServer:1
N:console.port:65528
S:console.allow_ip:127.0.0.1
S:console._password:
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url: S:game.url_list:

S:game.server_screenshot_url: S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url: S:game.newbiehelp_gaia_url:
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
T:game.disable_trade:0
T:game.disable_booth:0
T:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:500
T:db.user.thread:4

Thank you in advance

ThunderNikk · 09/15/2015, 00:06

There is nothing wrong with the picture you linked at the top of the page.

If you are not running a log server or the upload server for guild icons you will get both of those messages but can still run the game without them.

So what happens when you run the client?

kastuki · 09/15/2015, 00:24

When i run the client, i write my ID and Pass and i click enter. But nothing happens..
Have you got a link for client 9.1 ?

My launcher code is that:
@ECHO OFF
START SFRAME /auth_ip:HamaIp/auth_port:1433 /locale:ASCII /country:US /commercial_shop

ThunderNikk · 09/15/2015, 01:19

You have the wrong auth port in your .bat

You have the database port and you need the IO port from your authserver.opt

It should be 8841

Sherock · 09/15/2015, 05:14

Quote:

Originally Posted by Sherock

is there any code to delete any duplicated ids and leave one ? [ ItemResource ]

up ^^

~~omaromar1~~ · 09/15/2015, 06:08

by the way thx guys BB

TheOnlyOneRaskim · 09/15/2015, 07:48

Quote:

Originally Posted by Sherock

is there any code to delete any duplicated ids and leave one ? [ ItemResource ]

Code:

SELECT id, COUNT(*) as 'Duplicate_count' FROM dbo.itemresource
GROUP BY id
HAVING COUNT(*) > 1

execute that and this script show's you what entry's are duplicated.

There is a way with scripts to delete duplicate's, but it would delete ALL of these entry's (the original's also)

Sherock · 09/15/2015, 15:27

Quote:
Originally Posted by TheOnlyOneRaskim
Code:
SELECT id, COUNT(*) as 'Duplicate_count' FROM dbo.itemresource
GROUP BY id
HAVING COUNT(*) > 1
execute that and this script show's you what entry's are duplicated.

There is a way with scripts to delete duplicate's, but it would delete ALL of these entry's (the original's also)

thank you

kastuki · 09/15/2015, 18:43

Hello,
I have a problem with my server. When I open my client, I enter my ID and PASS, after I enter in server list and when I select my server.. One message open.. the message says "You are disconnect of the server"..
However I have enter that "start_service" and "set game.open_external 1" in Princess :/
Why?

ThunderNikk · 09/15/2015, 21:08

Since I already know that you are trying to connect hamachi...

Did you open your game server ports in your firewall and your router / modem?

8841
4504

kastuki · 09/15/2015, 21:21

I have open the port in the SQL server configuration manager, and i have add 1433 in the end of TCP/IP.

The screen of my problem:

ThunderNikk · 09/16/2015, 01:33

For some reason it looks like you changed the game server port to 1433 in the .opt file because that is the message from the game server...

"Acceptor Initialize... failed (IP: 0.0.0.0 Port: 1433)" today's picture of your game server.

So change it back. It used to be...

"Acceptor Initialize... OK (IP: 0.0.0.0 Port: 4504)" yesterday's picture of your game server.

1433 is only the database port, it can not be used anywhere else because it is in use.

So change your gameserver.opt back to what it was before. All you needed to change was the .bat and you changed more.

kastuki · 09/16/2015, 08:38

Have you got skype for help me ? It's easier

I have understand, i test this afternoon ! Thanks !!

ThunderNikk · 09/16/2015, 12:51

I do not have a public Skype, sorry.

I hope you do understand.

Sherock · 09/16/2015, 17:47

i had a problem with state time remains

when i use any harmful skill with state

the remain time at the first time is ok
after few mins the state's remain time changes to less

when i logoff and login again state's remain time back to the original and after few mins the state's remain time changes to less again

i have change the arcadia to the original arcadia and i also change the telecaster to the original one and i have download the original client

and the problem still