On most databases the bloodfrenzy is disabled, along with a random mob I happened to notice, fix:

 

# Elite Corpse Solider
UPDATE t_npc SET a_enable = 1 WHERE a_index = 147;
# Blood Frenzy
UPDATE t_npc SET a_enable = 1 WHERE a_index = 157;

2

Hi guys

 

Im searching for someone who manages the viewer tool (the one which is used to make poses) to make some poses for me, Im paying for it or maybe we can make a deal.

 

Answer here or start a private conversation with me

1) Go to "Navicat>newproject_data"

2)Open "t_zonedata"

3) Search "a_canusemempos"

4) Replace all "0" by a "1"

5) Have fun, you can use a memoryscroll in all maps :p

 

Little thank ?

1) Go to "Navicat>newproject_data"

2)Open "t_zonedata"

3) Search "a_canmountpet"

4) Replace all "0" by a "1"

5) Have fun, you can mount your pets in all maps

 

Little thank ?

This is an update to increase the damage of attack skills below dual class. All those skills take too much time to perform to make the damage they deal worth it, especially with +ed weapons, so this upgrades all those attack skills to deal more damage.

 

UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 45;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 49;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 52;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 56;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 63;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 64;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 66;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 69;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 70;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 72;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 75;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 79;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 80;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 85;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 87;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 92;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 93;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 99;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 104;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 107;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 114;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 115;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 121;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 122;
UPDATE t_magiclevel SET a_power = a_power * .2 WHERE a_index = 123;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 145;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 156;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 157;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 158;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 159;
UPDATE t_magiclevel SET a_power = a_power * 2 WHERE a_index = 172;

 

This takes all those skills that were powered up, and increases the MP they use up to 200%, your choice if you want it or not :p.

 

UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 45;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 49;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 52;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 56;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 63;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 64;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 66;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 69;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 70;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 72;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 75;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 79;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 80;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 85;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 87;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 92;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 93;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 99;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 104;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 107;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 114;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 115;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 121;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 122;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 145;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 156;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 157;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 158;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 159;
UPDATE t_skilllevel SET a_needMP = a_needMP * 2 WHERE a_index = 172;

Here is an update to your database, making exp rise more slowly for lower level players, but rise normally for higher level players. If you have a server with 100x more xp, a player at lv1-10 will earn 10x xp, a player from lv11 to 15 will earn 20x xp, and the rate will continue to gradually go up as the player levels. This is basically meant to allow people to experience the noob levels before moving on, I, along with many of my players, enjoy playing as a little player again. These private servers all always jump so fast through these levels that people forget how easy going and simple the levels are.

 

UPDATE t_npc SET a_exp = a_exp * .1 WHERE a_level <= 10 AND a_level >= 1;
UPDATE t_npc SET a_exp = a_exp * .2 WHERE a_level < 15 AND a_level > 10;
UPDATE t_npc SET a_exp = a_exp * .35 WHERE a_level < 20 AND a_level > 14;
UPDATE t_npc SET a_exp = a_exp * .5 WHERE a_level < 25 AND a_level > 19;
UPDATE t_npc SET a_exp = a_exp * .65 WHERE a_level <= 30 AND a_level >= 25;
UPDATE t_npc SET a_exp = a_exp * .8 WHERE a_level <= 40 AND a_level > 30;
UPDATE t_npc SET a_exp = a_exp * .9 WHERE a_level <= 50 AND a_level > 40;

hey Guys

 

Here a little Guide how do u find out the offset of the EXp_table in ur Gameserver.

 

What do u need:

- ExptextTOBin

- Gameserver (Hex-Editor)

- full function Server

 

 

 

What we do:

We Compare with a other server. We need the full function Gameserver to find the Exptable then its nothing than searching in the other Gameserver.

 

 

 

 

So step by step:

 

1. We start the full function Server with the Gameserver, where we want to find out the Offsets.

2. Now we level from 1 to 20 example and write all exp from each level on a text document. Example: 36 140 415 1161 2787 5853 [EXAMPLE]

3. We write the Exp per level in the exptable.text

4. Now we start ExptextTOBin without a Gameserver in the folder. Now the ExptextTOBin create a Gameserver.exe himself.

5. Now we start the Hex Editor with the new created Gameserver.exe and the the Gameserver.exe where we want the offsets.

6. in the new Gameserver.exe we find some numbers. We dont want to know what the numbers mean. These numbers we find normally at the Offset: (0x00353000).

7.No we copy the numbers next to the Offset. ( in my example: 24000000000000008C00000000000000

8.We open the Gameserver.exe with the unknown offset and click [ctrl+f]. Now we search for the numbers we copy in the last step.

9. Now we find the new Offset at the left side and must change the offset file from EXPtextTOBin

 

 

Hope i help u and sry for my fck bad English

Hey there,

 

Seems like alot of u are asking for the old Juno from the 2005 client... so here it is: 2

 

Hf

 

(thanks Aqualung for sharing those old files)

Hi all guys

Can someone tell me to do some event in my server and how to get them?

Thx