[Help Thread] Please post your questions here.

06/14/2013 23:05 ThunderNikk#1906
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.

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

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

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.

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

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...

[Only registered and activated users can see links. Click Here To Register...]
06/14/2013 23:15 Dyson49#1907
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.
06/14/2013 23:52 ThunderNikk#1908
Quote:
Originally Posted by Dyson49 View Post
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.
06/15/2013 00:57 TheSuperKiller#1909
Quote:
Originally Posted by thndr View Post
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 .
06/16/2013 17:56 tokesbowls#1910
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
06/16/2013 18:32 Dyson49#1911
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)
06/16/2013 19:45 rickske95#1912
how can i make a auto register page?
06/16/2013 19:54 Dyson49#1913
[Only registered and activated users can see links. Click Here To Register...]

this should help
06/16/2013 22:39 Azreil#1914
Quote:
Originally Posted by Dyson49 View Post
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: [Only registered and activated users can see links. Click Here To Register...] ) (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.
06/17/2013 02:26 ThunderNikk#1915
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

Quote:
Originally Posted by Azreil View Post
1: Fixing the masters hammer. (and yes I did try the fix mentioned here: [Only registered and activated users can see links. Click Here To Register...] ) (Still...it does not repair the dura in the combining window)
Repair window does not work?
06/17/2013 02:31 tokesbowls#1916
Quote:
Originally Posted by tokesbowls View Post
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
06/17/2013 03:25 Dyson49#1917
Why is this script not working?

Code:
-- 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
06/17/2013 03:39 Azreil#1918
Quote:
Originally Posted by thndr View Post
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.
06/17/2013 03:43 Dyson49#1919
Quote:
Originally Posted by tokesbowls View Post
Bump
Hi...

x25 = The official x25

...
06/17/2013 20:02 rickske95#1920
when i try to change gold rate in gameserver.opt nothing is changed in game the exp and stuff working