+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 1 Releases (https://lckb.dev/forum/forumdisplay.php?fid=191)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=113)
+----- Thread: Release "My Starter Pack" (/showthread.php?tid=1008)
- blade5000 - 08-13-2012
thx for tip
you link for my
- blade5000 - 08-14-2012
exp, sp and gold of 1*
and Tomb teleporter missing
help my
- OrangeUniverse - 08-14-2012
Sweeet i finally found the perfect cilent for my server ^^ great job
btw does it have nightshadow or sorceress to?
- blade5000 - 08-14-2012
exp, sp and gold of 1*
and Tomb teleporter missing
you help my rate of 1 * all ?????
and teleporter tomb is of you online ?????
mfg
- someone - 08-14-2012
UPDATE t_npc SET a_exp = a_exp * 1;
UPDATE t_npc SET a_skill_point = a_skill_point * 1;
UPDATE t_npc SET a_prize = a_prize * 1;
# droptable
UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 1;
....;
For gold drop and item drop table there already is the table t_drop_prob.
For EXP/SP I suggest using a temporary table to hold the original EXP/SP, because
Create a temp table to hold the original data
CREATE TABLE IF NOT EXISTS t_rates(
a_index int not null,
a_exp bigint not null,
a_sp int not null
);
-- if table exists it will clear it
DELETE FROM t_rates;
-- inserts new data from t_npc
INSERT INTO t_rates
SELECT a_index, a_exp, a_skill_point from t_npc;
Changing rates is much easier:
-- input data
SET @exp_rate = 1;
SET @sp_rate = 1;
-- restores exp/sp in t_npc to the original
UPDATE t_npc npc, t_rates p SET npc.a_exp = p.a_exp * @exp_rate WHERE npc.a_index = p.a_index;
UPDATE t_npc npc, t_rates p SET npc.a_skill_point = p.a_sp * @sp_rate WHERE npc.a_index = p.a_index;
If you added new NPC to t_npc this will update the rates table:
-- changes exp/sp in t_npc according with exp_rate and sp_rate
UPDATE t_npc npc, t_rates p SET npc.a_exp = p.a_exp WHERE npc.a_index = p.a_index;
UPDATE t_npc npc, t_rates p SET npc.a_skill_point = p.a_sp WHERE npc.a_index = p.a_index;
-- clear the rates table
DELETE FROM t_rates;
-- inserts new data from t_npc
INSERT INTO t_rates
SELECT a_index, a_exp, a_skill_point from t_npc;
Why do this, modifying the t_npc table without a backup its not a good Idea.
- DEAD675 - 08-15-2012
Help keeps crashing connector please! What to do?
- SibaN - 08-15-2012
i go to healer skill master i get send error
how i fix that please
- SibaN - 08-15-2012
ah one skill dont have icone please fix last skill icone from healer Dark..... for healer
- blade5000 - 08-15-2012
;(
need the setting
Level Cap : 255
Exp Rate : x1
SP Rate : x1
Drop Rate: off for sets and weapons
Gold Rate : x1
you my help
- moosna - 08-16-2012
Pls help my Gameserver not work