[Help Thread] Please post your questions here.

[ridhapellz]

Originally Posted by thndr

Does "sa" own the databases? (set ownership to "sa")

Did you make your edits to the .opt files and compress them?

Did you open the correct ports in Windows Advanced Firewall?

Did the 2 First But still get that Error of Auth DB Intel Error Cant Find SQL ConnectionOPEN dammn
but for the windows advance firewall no idea how to open them they may be on or off idk ! guid me on how to open them please

[ThunderNikk]

Originally Posted by ridhapellz

Did the 2 First But still get that Error of Auth DB Intel Error Cant Find SQL ConnectionOPEN dammn
but for the windows advance firewall no idea how to open them they may be on or off idk ! guid me on how to open them please

Use the guide linked here...



It has the Windows advanced firewall instructions.

[Azreil]

Originally Posted by HeavenOnlyWishes

Well first off, whatever lua editor your using ditch it and get Notepadd++ it's the only editor you need. It even works with SQL formats.

Secondly, if your having trouble finding something just use the 'Find' option in the editor, you should be able to search for the strings you need. But if I'm not mistaken... the functions for the NPCs I listed are in the npc_merchantetc.lua

Your reply...heartily appreciated.
I asked myself....self, I says...what if...other npc are broken because of changing the iscashshopserver =0 ? And self answered....Guess what....there are. For example....not only were the custom npcs broken...but also...the blacksmiths shop (not leveling the items...but buying the leveling items). And so...I did the following to repair all npc shops:

I searched all the .luas with notepad ++ for this line:

"-- game.cash_usable_server ? 1: ½ÃÅ©·çÆ® °ü·Ã ³»¿ë »ç¿ë ¼*¹ö / 0: »ç¿ë ¾È ÇÏ´Â ¼*¹ö
if get_env("game.cash_usable_server") == 0 then"

and I changed it to:

"-- game.cash_usable_server ? 0: ½ÃÅ©·çÆ® °ü·Ã ³»¿ë »ç¿ë ¼*¹ö / 1: »ç¿ë ¾È ÇÏ´Â ¼*¹ö
if get_env("game.cash_usable_server") == 1 then"

I know...there is probably some much easier way to get the same results...
but...so far..every shop works. (Got to thinking...well ...if this line checks for cashshop = true and it isn't set to true...then shop doesnt open....why not change it to check for cash shop = false ? ^^

I am a noob....who is trying to use his head and I have zero experience with .luas and scripts...but I'm in there poking around.

Next 3 projects:
1: remove all the christmas stuff from ingame. (aka learn how to set and undo events).

2: remove two non working npcs from laksey (1 is invisible and neither have names nor empty string numbers...so..I'm not sure how to even search for them to remove them.)

3: start work on repairing all the empty strings in the npcs and items. (whew...that's going to take some time.)

So...thank you guys for pointing me in the right(ish) directions.
Even though I may not understand everything that needs to be done...and I am a slow learner....at least I am willing to try.
Thank you guys again for your patience and for the work that goes into the files and fixes and tools...I can't begin to imagine what it took to bring the files to light....but, I for one, am truly grateful. Deepest respect guys.

[HeavenOnlyWishes]

Originally Posted by Azreil

Next 3 projects:
1: remove all the christmas stuff from ingame. (aka learn how to set and undo events).

2: remove two non working npcs from laksey (1 is invisible and neither have names nor empty string numbers...so..I'm not sure how to even search for them to remove them.)

3: start work on repairing all the empty strings in the npcs and items. (whew...that's going to take some time.)

1. Use the following code on your FieldPropResource: (Decorations are actually setup by changing their local_flag, not by flagging an event.... but that's actually a good idea, and probably would have been better....) This is modeled after Wisp's version that's designed to activate the Christmas Deco btw.

 Spoiler

USE Arcadia
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE  'common_event_rangifer_tree'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament01'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament02'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament03'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament04'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration01'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration02'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration06'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration07'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration08'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration09'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_decoration10'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament11_01'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament11_02'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'ccommon_event_rangifer_ornament11_03'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament05'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament06'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament07'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament08'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament09'
UPDATE FieldPropResource
SET local_flag = 1048575
WHERE file_name LIKE 'common_event_rangifer_ornament10'

2. There's actually a very simple way of doing this, but it takes a little bit of time:
Step 1) Make sure your character in game is standing next to those 2 NPCs before you log out.

Step 2) Go into your Resource/Script folder for your server and remove all scripts that start with npc_.

Step 3) Log back in game and double click on the NPCs, the chat window should give you an error and tell you that the NPC is trying to call a function that doesn't exist and it will list that function's name. Write it down.

Step 4) Go into your NPCResource table, and search for any NPCs that use that function, and vuala, those are your two NPCs you keep seeing.

You can use this querie at the end of the Search Top 1000 querie in your NPCResource table: (Just replace function_name with the name of the function you are searching for.)

WHERE contact_script = 'function_name'

3. Just download ACRE like I said in the previous post, you can use the AdvancedUnpacker utility to unpack the client you are using. Use ACRE to load up the db_string.rdb file in the rdb folder of your client's dump, then click "Save to DB" and let it save.... There you go all String issues fixed. This will also make it so that the client and server you are using run on the same language... i.e. French, German, English, etc.

[helistor]

Originally Posted by helistor

Hello,

I modified the "insert" stored procedure of auction in DB, in order to set end_time to 2014.
But it seems the client uses its memory and doesn't check the value in DB.
I must reboot if i want that the auction reads the db value.

Is it possible to force "reload" the auction house from the DB without reboot the server ?

Someone can help me ?

[HeavenOnlyWishes]

Originally Posted by helistor

Hello,

I modified the "insert" stored procedure of auction in DB, in order to set end_time to 2014.
But it seems the client uses its memory and doesn't check the value in DB.
I must reboot if i want that the auction reads the db value.

Is it possible to force "reload" the auction house from the DB without reboot the server ?

Sorry... I can't help you on this one. As far as I know any changes to the server have to be initialized during start up, and thus making a change to anything server related would require a reboot. Basically, in OOP languages which is what MMORPGs are built in, you have a Main class that initializes everything in that instance of the program... most of the stuff for any server is generally stored in the heap and thus only changeable within the program itself or a related program that has access.... but no body really does that. Your basically changing something outside of the program.... So the main program has to reboot to "re-initialize" anything that you've changed.... That's kind of a dumb way of explaining it, but that's basically how it works.

[Ne0@NCarbon]

I'm having a strange issue and i post here just to know if i'm alone with this.
Using 8.1 GS from Files8.1_By_Al7oB (gs is 4976ko)
Properly set opt files with :
S console.port:5555
S console._password:56bf37f2326d1e5f
S io.ip_address:127.0.0.1

Netstat -a show me :
TCP 0.0.0.0:5555 COMPUTER:0 LISTENING

But i'm unable to telnet to gs, never get the banner for login !! (tryed with cdm line, putty and teraterm)
On same computer, can telnet without any issue to logserver and authserver
No other soft listen on 5555 .....

Other got the same ?

Ok got solved
S:console.allow_ip:127.0.0.1

[kisodiac]

hi all, i have a problem on my captain.herlock, its crashing when i selecting my character previously created, its has 100 permition and i cast on him 12 buff with x10000 option. here is my log:
2013-05-29 22:41:29 SendLoginToAuth (zeldiac)

2013-05-29 22:41:33 onLogin ([MJ]Arwen)

2013-05-29 22:52:33 SendLoginToAuth (zeldiac)

2013-05-29 22:52:36 onLogin ([MJ]Arwen)

2013-05-29 22:53:15 onRequestLogoutTimer (zeldiac, [MJ]Arwen)

2013-05-29 22:53:15 onRequestLogoutTimer (zeldiac, [MJ]Arwen)

2013-05-29 22:56:57 SendLoginToAuth (zeldiac)

2013-05-29 22:57:05 onLogin ([DEV]Arwen)

[Pyrochina]

Hi can somone give me Auth.opt + GameServer.opt + Where to put the Hamachi IP and etc.

[woshini1daye]

Hi guys i still got trouble with login server. everything run smoothly even princesxxxx and captinxxxx. i run them in order and then type in start_service &
set game.open_external 1

however still when i type in user id and pwd, then msg pops up "unable to connect to login server"

pls see my auth opt and game server opt

Auth opt

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:RACQI
S log.ip:127.0.0.1
S db.auth.port:1433
S io.auth.port:8841
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011
*****************************

Game server opt

S app.name:Game Server
S auth.server_idx:1
S auth.server_name:RACQ

S db.user.work_total:
S db.user.work_pending:
S db.user.work_active:
S db.user.thread_active:
S db.user.thread_total:

S console.port:4515
S console._password:

S db.game.ip:127.0.0.1

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

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

S io.auth.ip:127.0.0.1
S io.ip_address:101.165.48.100
S io.port:4504

S game.server_screenshot_url:

S io.upload.port:4617
S io.upload.ip:your_website/external_ip
S game.guild_icon_base_url:
S game.url_list:guild_icon_upload.ip|your_website/external_ip|guild_icon_upload.port|4615

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:300
S game.item_drop_rate:1
S game.gold_drop_rate:1
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50
*****************************
launcher bat file

@ECHO OFF
START SFRAME /auth_ip:101.165.48.100 /auth_port:8841 /locale:ASCII /country:US /commercial_shop /cash

i have tried to place my ip as 101.165.48.100 to 127.0.0.1 but still unable to connect to login server. i have disabled firewall as well.

i am new here so i appreciate for any help

[ThunderNikk]

Disabling the firewall will not help your case at all, you need to make sure the ports have been opened in Windows advanced firewall settings...

[woshini1daye]

Originally Posted by thndr

Disabling the firewall will not help your case at all, you need to make sure the ports have been opened in Windows advanced firewall settings...

Hi bro, i have followed the step as above. when run captinxxx. here is the msg:
"Connect To Auth...Failed
Connecting to the auth server failed. Check auth server status. IP:my external IP / PORT 4502
Enter 'connect auth' to retry

btw i have enable all four ports as per instruction: 8841 4504 4615 4617 also i have enabled 4502

so what should i do next

[mlejnek2]

ok server crash on dismantling gears or items so ony one know how to disable this ? any info would be nice tyvm

[ThunderNikk]

Make sure these entries are in your drop group resource table...

-3002001	705001	1	1	0.25	705001	2	2	0.5	705001	3	3	0.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
-3002002	705001	2	2	0.25	705001	3	3	0.5	705001	4	4	0.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
-3002003	705001	3	3	0.25	705001	4	4	0.5	705001	5	5	0.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
-3002004	705001	6	6	0.25	705001	7	7	0.5	705001	8	8	0.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
-3002005	705001	24	24	0.25	705001	25	25	0.5	705001	26	26	0.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

And the server should stop crashing

[woshini1daye]

Hi Guys,

can anyone advise me what is the item code for MC gears (D1,D2 and D3)

MC weapson, armor, belt, gloves, shots, belts, necky and accessories pls?


thanks