Adding Golden Archer to 97d +99 - 100% Works

Many serverfiles are ready to run, but I think that 95% the golden archer does not work, because the dbs are so old, also, some people dont know that exists.
I will explain how to add the golden archer 100% works, to get to your server, a new feature, for funny events.

1-After configuring the server, in the folder MU2003_EVENT_SERVER will have the file named WZ_MU2003_EVENT_SERVER.exe (event server). (Attach folder with file).
***Remember that if you change the name or puts this file, you must edit the links or the MuserverStarUp, so you can connect normally without an error when you connect.

2 - Now, open the next file.
C: or D: / MuServer / Data / MonsterSetBase.txt
Go to Npcs, or Go to the last line of text and add the lines

/ / --------------------------------------------- ---------------
/ / Lorencia NPC:
/ / ------------------------------------------------ ------------
0
236 0 0 130 127 3 / / NPC Golden Archer
end
/ / ------------------------------------------------ ------------ 

3 - Now you need configure the commonserver.cfg.
(MuServer / Data / coomonserver.cfg)

Find and configure the settings as it says below:

EventChipServerConnect = 1; [1 = enable, 0 = disable]
EventChipServerIp = 127.0.0.1
EventChipEvent = 1; [1 = enable, 0 = disable]
BoxOfGoldDropRate = 6; [20/100 = 20%]
ItemDropRateForBoxOfGold = 80; rate drop elements [50/100 = 50%]
EventChipDropRateForBoxOfGold = 0; percentage drop Rena [90/100 = 90%]
and setting the drop that you want 

Other settings here:

StoneItemDrop = 1 ; event ( Bless Fragment )
StoneDropRate = 100 ; (StoneDropRate/ 10000) 

4 - Now, the script to fix the NPC, you should executed the following command with the Query Analizer.
How to use the Query Analizer?
Simple, do the following:
Start-> Program Files-> Microsoft SQL Server-> Query Analizer-> Identify. At the top, where it says Master, we changed to MuOnline-> Enter the queryt in the console>>and then press F5!
Remember run in MuOnline, not in ranking!
(Attach - Code to run in Query Analizer.)

5 - Now go to
C: or D: \ MuServer \ MU2003_EVENT_SERVER \ Data \ svconfig.ini and set up this:

pim_setting]
queue_no = 4
workerthread_no = 4
[odbc_connection]
mu2003_dbname = MuOnline
mu2003_dsn = MuOnline
mu2003_uid = sa
mu2003_pass SQL = password 

6 - Ready now almost complete connect your server and locate the NPC's outside the bar, in Lorencia.
The Golden Archer serves as a warehouse, and carries the accounts of Rena's collected by the users, most of the servers do not have it because it does not work, but now you can get in there and let your imagination fly with the possible events that you can do .

If you want to create a php script, like that of any ranking, only changing tables, showing, as each carries renas Id, and when users collect a certain quantity, published his prize items, jewelry, days of VIP, etc, in web,

Downloads:
Query to FIXGoldenArcher.txt :
LINK 1: Download
LINK 2: Download

MU2003_EVENT_SERVER.rar:
LINK 1: Download
LINK 2: Download

SpanishGuide.txt:
LINK 1: Download
LINK 2: Download

Rumanian_Guide.txt :
LINK 1: Download
LINK 2: Download

Credits:
-  Juliom (RZ)