[Help Thread] Please post your questions here.

[ThunderNikk]

The splash screens are driven by the sframe if I remember correctly when I ran a German sframe mine were German splash screens as well.

The splash loading has no words on it so I don't see how it could be German but Ill throw it in there.





Splashloading had 3 virus alerts on virus total, they are probably false positives but I did not want to give you anything that looked fishy so I removed it from the zip.



You really do not need the file the game will run without splashloading.exe.

Here is the Virus total for the entire zip without the splash loading...

[Dyson49]

Also today I downloaded SQL Developper and I wanted to know how to transfer my server on it... Or do I just run both on the same one.

Same error with the files... Still in German

I'll redownload the Englsih client later. For now it works in my French files. So i'll run it there for now.

[ThunderNikk]

Originally Posted by Dyson49

Also today I downloaded SQL Developper and I wanted to know how to transfer my server on it... Or do I just run both on the same one.

Make new backups of your databases to the point that you have them at now.

Then once you install SQL developer edition, you would set things up just like you did the first time doing everything all over again.

Restore the newer backups.

Set ownership and password in SQL.

Set TCP IP configuration and port 1433 like before in SQL configuration.

You should not have to do your firewall steps over again as it will use the same ports you opened before.

Then everything should be good to run again, but will have any changes you made to the databases.

[TheSuperKiller]

Originally Posted by thndr

Make new backups of your databases to the point that you have them at now.

Then once you install SQL developer edition, you would set things up just like you did the first time doing everything all over again.

Restore the newer backups.

Set ownership and password in SQL.

Set TCP IP configuration and port 1433 like before in SQL configuration.

You should not have to do your firewall steps over again as it will use the same ports you opened before.

Then everything should be good to run again, but will have any changes you made to the databases.

he doesnt even have to do anything than upgrade option and the installer will do the rest .

[tokesbowls]

Hello,
So my server has been running for about 1 month now and the exp seems really high,
Would anyone be able to tell me:
Retail EXP =
100% EXP =
200%EXP =
300% EXP =

Thank you for your time and help, Keep up the good work

[Dyson49]

1. How do we add an announcement when a staff member connects?

2. How do we remove Chrismas Deco? [RESOLVED]

3. Ho do we change start positions to class cities and change start level to 10, Job level 10, with 5K JP


EDIT:

4. How to change default items

5. How to change NPC names

6. How to debug the special characters (é, â, ç, ë, etc.)

7. How to debug titles? (They are currently showing as emptystrings)

[rickske95]

how can i make a auto register page?

[Dyson49]

this should help

[Azreil]

Originally Posted by Dyson49

1. How do we add an announcement when a staff member connects?

2. How do we remove Chrismas Deco?

3. Ho do we change start positions to class cities and change start level to 10, Job level 10, with 5K JP


EDIT:

4. How to change default items

5. How to change NPC names

6. How to debug the special characters (é, â, ç, ë, etc.)

7. How to debug titles? (They are currently showing as emptystrings)

This for Number 2..

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'

After trying several tries ...each ending in unmentionable scripting horrors...I have arrived at the conclusion that I am stuck at 3 things...

1: Fixing the masters hammer. (and yes I did try the fix mentioned here: ) (Still...it does not repair the dura in the combining window)

2: Removing the Dandy X-Mas helpers and Cutie X-Mas helpers ( Eeekgad and gadzooks these NPCs just wont go away. (Tried editing dbo.NPCResource and NPC_MerchantEtc.lua)

This is my db query I had hoped of getting rid of these pesky NPCs with this....

USE Arcadia
UPDATE NPCResource
SET local_flag = 1048575
WHERE contact_script = 'NPC_event_Kor_Christmas_contact()'
OR contact_script = 'npc_wonderland_new_event_dandy01()'
OR contact_script = 'npc_wonderland_new_event_gom01()'
OR contact_script = 'npc_wonderland_new_event_pumpkin01()'
OR contact_script = 'npc_wonderland_new_event_baron01()'
OR contact_script = 'npc_wonderland_new_tell_panda()'
OR contact_script = 'npc_wonderland_new_tell_milky()'

It did not work -.-


3: Editing NPCs sellable items. (Yes I know how to use the search buttons...and yes I did read the "guide" on custom NPCs....but let's be honest....for those of us whom are not lua and db savvy ...the "guide" is quite lacking...and I'm not 100% sure it is still compatible...with the 8.1 files I mean. (Perhaps it is....but...idk)
And...it doesn't really tell how to actually EDIT the items....more like a generalized overview of how to create a custom NPC. (There use to be a detailed guide on how to edit NPC items...though it seems to have vanished into the ether...)
So....if anyone still has time to show me/us / all of us ....how to do these things....not only would be greatly appreciated..but also would stop a lot of repetitious posts I believe.

Any consideration would be a huge asset (not only personally...but to us all).
All hail the people that bring these files to life...I am amazed at what you guys are accomplishing. Thank you guys...for all you do.

[ThunderNikk]

Can do number 2 much shorter than that...

USE Arcadia
UPDATE FieldPropResource
SET local_flag = -1
WHERE file_name LIKE '%common_event_rangifer%'

Using wild cards you can use the common words between all of them and set them all at once.

Also when I want things to disappear I always use local flag -1

Try that with your NPCs

Originally Posted by Azreil

1: Fixing the masters hammer. (and yes I did try the fix mentioned here: ) (Still...it does not repair the dura in the combining window)

Repair window does not work?

[tokesbowls]

Originally Posted by tokesbowls

Hello,
So my server has been running for about 1 month now and the exp seems really high,
Would anyone be able to tell me:
Retail EXP =
100% EXP =
200%EXP =
300% EXP =

Thank you for your time and help, Keep up the good work

Bump

[Dyson49]

Why is this script not working?

-- Lua ½ºÅ©¸³Æ® ¾ÏÈ£È*
function get_module_name()
             return "on_login"
end




function on_login( name )

 if get_value("permission") > 0 then
  notice(name.' is now connected.');
 end
 end

[Azreil]

Originally Posted by thndr

Can do number 2 much shorter than that...

USE Arcadia
UPDATE FieldPropResource
SET local_flag = -1
WHERE file_name LIKE '%common_event_rangifer%'

Using wild cards you can use the common words between all of them and set them all at once.

Also when I want things to disappear I always use local flag -1

Try that with your NPCs
Those blasted NPCs are still there -.-
"Dandy Stylish santa"
and
"Cutie Santas' Assistant"
Please tell me how to eradicate them. I searched for them in the NPCMerchant.lua and dbo.NPCResource and can't find them. X.X



Repair window does not work?

Repair window works fine....for dura items which are not completely broken.....but..

Masters' hammer still isn't working when used in the combine window. I am not talking about the enhance window....Masters hammer is meant to be used in the Combine window.. along with a broken item. Both the hammer and the broken item can be placed into the Combine window...but I get the "Try a different combination" error message.
Using 8.1 files and US Client fully updated and sframe replaced with 8.1 sframe...launcher is directly from the tutorial. I'm pulling out my hair on this one. and I followed the fix exactly as it was posted.

[Dyson49]

Originally Posted by tokesbowls

Bump

Hi...

x25 = The official x25

...

[rickske95]

when i try to change gold rate in gameserver.opt nothing is changed in game the exp and stuff working