[Help Thread] Please post your questions here.

[thund22222]

Anyhelp for this problem?

Originally Posted by thund22222

I need some help you implement code to modify the value of gold, for example
update Character set gold = 100 and the player is online to change value, But if the player Login again returns the previous value !

[ThunderNikk]

Originally Posted by colonelx

In fact i dont know how to configure it
So i have never used it

How to configure what?

Originally Posted by colonelx

Oh i forgot lately i have changed my previous mssql user and password
Is there any relation about that with the problem ?
Keep in mind the previous user also is custom created

Why would you change from one custom SQL user to another?

Have you tried it with your old user?

[colonelx]

u said if i use scheduled command so i tell u i have not tried it before so i dont know how to configure

the second thing about sql user cuz i thought some one has discover it so i wanted to be sure that my mssql user and pass are unkown to others so i changed user and pass
but is this related to my problem ?!

[ThunderNikk]

Originally Posted by colonelx

u said if i use scheduled command so i tell u i have not tried it before so i dont know how to configure

the second thing about sql user cuz i thought some one has discover it so i wanted to be sure that my mssql user and pass are unkown to others so i changed user and pass
but is this related to my problem ?!

Look the only one who is going to figure out and fix your problem is you...I am just trying to help give you ideas.

If you are not willing to do the ground work and try your old user and pass in the .opt file than it doesn't matter how many ideas I give you, you are never going to fix your issue.

Oh and dbo.ScheduledCommand is already configured but you won't even look in your data base objects to see that.

[ismokedrow]

Don't use big words like objects, you will confuse the underling

[thund22222]

Can anyone know the solution to this problem?

Originally Posted by thund22222

I need some help you implement code to modify the value of gold, for example
update Character set gold = 100 and the player is online to change value, But if the player Login again returns the previous value !

[colonelx]

Originally Posted by thndr

Look the only one who is going to figure out and fix your problem is you...I am just trying to help give you ideas.

If you are not willing to do the ground work and try your old user and pass in the .opt file than it doesn't matter how many ideas I give you, you are never going to fix your issue.

Oh and dbo.ScheduledCommand is already configured but you won't even look in your data base objects to see that.

Thank you very much for your patience with me to resolve this problem
i think i have finally figured out the main reason for this problem
thanks again thndr

[28_Eloy_08]

Hallo, habe Windows 10 drauf aber Combat Arms startet nicht mehr, obwohl die schreiben, das min. Windows XP drauf sein muss, oder besser, nun habe ich ein besseres Betriebsystem drauf und nun?

[Saltaya]

Originally Posted by 28_Eloy_08

Hallo, habe Windows 10 drauf aber Combat Arms startet nicht mehr, obwohl die schreiben, das min. Windows XP drauf sein muss, oder besser, nun habe ich ein besseres Betriebsystem drauf und nun?

Völlig falsche Sektion

[kojima2501]

hi i have this probleme
Fail the authentication server. [18]

I met so that we now cover a sudden all exe launched ect
thank you if you have a solution to the Indo serv is set locally

Serveur 9.1
i follow

screen:

 Spoiler

Auth.opt

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:sa

auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_mask

#include config in common.opt
%include:common.opt

common.opt

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
#example auth database password no hashed you enter it to login on sql server management studio with sql authentication
auth.db.password:koko2501
# key for hash your accout password for connect to your account 
auth.db.salt:2011
#You can make passwords by visiting: http://www.miraclesalad.com/webtools/md5.php (KEYPASSWORD = hashed password)
#or simply hash function on sql insert request :Value password : LOWER(CONVERT(VARCHAR(32),( HashBytes('MD5', '2011yourpassword')), 2))

#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
# port for .bat launcher
auth.clients.port:58422
#i m think it s key for encription betwin client server
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=C:\inetpub\wwwroot\rappelzfamily\icons\
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Account WITH(NOLOCK) WHERE login_name = ? AND password = ?;

GameServer.opt

 Spoiler

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:RappelzFamily

S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:sa

S:db.c._password:4556000003005bce4acde64933c9c63131331dc93f163232323a05b61132
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
S:db.user.account:sa

S:db.user._password:4556000003005bce4acde64933c9c63131331dc93f163232323a05b61132

N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1

S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1

N:console.port:44554
S:console.allow_ip:127.0.0.1

S:console._password:4556000003005bce4acde64933c9c63131331dc93f163232323a05b61132

S io.upload.port:4616
S io.upload.ip:127.0.0.1

T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:0
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0

T:game.disable_trade:0
T:game.disable_booth:0
S: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:2500
T:db.user.thread:4

S game.guild_icon_base_url:http://127.0.0.1/C:/inetpub/wwwroot/rappelzfamily/icons/
S:game.url_list:guild.url|http://127.0.0.1/login.aspx|guild_test_download.url|guild/|web_download|127.0.0.1|web_download_port|0|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|127.0.0.1|guild_icon_upload.port|4617

S:game.server_screenshot_url:http://127.0.0.1/C:/inetpub/wwwroot/rappelzfamily/screenshot/
S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html
S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html
S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html
S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html
S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment

S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_damage:.30
F:game.base_ethereal_durability_consumption_on_skill_attack:.40
F:game.base_ethereal_durability_consumption_on_normal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30

Launcher.bat

 Spoiler

RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:Windows-1256 /country:FR /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

can u help me ? =)

and I also speak french (* - *)

Add my skype:kojim25

Need help

[ThunderNikk]

Please post your authserver.opt and your included common.opt.

Please post your .bat arguments.

[kojima2501]

up edit = new probleme Error [18]

[ThunderNikk]

You can not put your external IP in the .bat file and then put local host IP in the .opt files...

/auth_ip:25.89.50.195

S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1

Wont work

Also you have stated you followed the 9.1 guide but you do not have the .bat file from the 9.1 guide because your auth port is not in your .bat file like this...

RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

Yours...

RappelzCmdLauncher.exe sframe.exe /auth_ip:25.89.50.195 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:Windows-1256 /country:FR /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

Where is your auth port?

[kojima2501]

sry bad .bat
my bat is

 Spoiler

RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:Windows-1256 /country:FR /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

and i edit for update this

but my probleme is not resolve

step in this video with my problem

 Spoiler

http://www.dailymotion.com/video/k2pUvC96TNk0Z9aZALb

but why i have error in left windows ?

[Questiontest]

Hello please how to fix that?