+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: General Guides (https://lckb.dev/forum/forumdisplay.php?fid=194)
+----- Thread: [Guide] To change the rates (/showthread.php?tid=213)
- Gothic - 10-05-2011
[Guide] To Chance Rates and Drops with +
You have to do a right click on the DB newproject_data and than choose Console in the menue, there you can run this commands. In the press Enter.
You only need to set the last number on which the Rates requested
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;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 1;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 1;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 1;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 1;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 1;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 1;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 1;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 1;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 1;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 1;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 1;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 1;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 1;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 1;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 1;
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 1;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 1;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 1;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 1;
Code for Chance the item Drop with min and max +
With this you can influence the rates. (With + - * /)
With the arithmetic operators you can then edit the rates further.
Please copy the first in the DB: 2
Then comes the change to the script also rates +
# droptable
UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +15;
- Sutz - 10-05-2011
mysql> UPDATE t_npc SET a_exp = a_exp * 70;
UPDATE t_npc SET a_skill_point = a_skill_point * 140;
UPDATE t_npc SET a_prize = a_prize * 70;
# droptable
UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 120;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 120;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 120;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 120;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 120;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 120;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 120;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 120;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 120;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 120;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 120;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 120;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 120;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 120;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 120;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 120;
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 120;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 120;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 1;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 1;
1264 - Out of range value for column a_exp at row 38
1264 - Out of range value for column a_skill_point at row 1
1264 - Out of range value for column a_prize at row 149
1264 - Out of range value for column a_item_percent_0 at row 260
1264 - Out of range value for column a_item_percent_1 at row 260
1264 - Out of range value for column a_item_percent_2 at row 260
1264 - Out of range value for column a_item_percent_3 at row 260
Query OK, 206 rows affected
Rows matched: 498 Changed: 206 Warnings: 0
Query OK, 205 rows affected
Rows matched: 498 Changed: 205 Warnings: 0
Query OK, 205 rows affected
Rows matched: 498 Changed: 205 Warnings: 0
Query OK, 203 rows affected
Rows matched: 498 Changed: 203 Warnings: 0
Query OK, 199 rows affected
Rows matched: 498 Changed: 199 Warnings: 0
Query OK, 190 rows affected
Rows matched: 498 Changed: 190 Warnings: 0
Query OK, 186 rows affected
Rows matched: 498 Changed: 186 Warnings: 0
Query OK, 182 rows affected
Rows matched: 498 Changed: 182 Warnings: 0
Query OK, 178 rows affected
Rows matched: 498 Changed: 178 Warnings: 0
Query OK, 173 rows affected
Rows matched: 498 Changed: 173 Warnings: 0
Query OK, 166 rows affected
Rows matched: 498 Changed: 166 Warnings: 0
Query OK, 157 rows affected
Rows matched: 498 Changed: 157 Warnings: 0
Query OK, 141 rows affected
Rows matched: 498 Changed: 141 Warnings: 0
Query OK, 127 rows affected
Rows matched: 498 Changed: 127 Warnings: 0
Query OK, 0 rows affected
Rows matched: 498 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 498 Changed: 0 Warnings: 0
mysql>
- Gothic - 10-06-2011
Update for chance the + values ??for dropps
- ReturnKratos - 10-06-2011
gotich the minplus and max plus is mine so give me credit -.-
- ReturnKratos - 10-06-2011
this its mine :
2
- Gothic - 10-06-2011
I find your so good but you have it fixed and can not change it. With the code, it can adjust itself to the desired values.
- ReturnKratos - 10-06-2011
OK
- Natzn - 10-06-2011
Warmonger why is your Page forbitten for me ?
Or fo everyone ?
- Gothic - 10-06-2011
The scripts are top and everything I change so thats super easy and fast to where I need a tool?
I use simple mathematics to DB what you learn in elementary school already
- tommzy09 - 10-06-2011
will you still help people? because my friend max cant get his server to work correctly (players outside his LAN cant join his server)
do you have any idea why this is happening?
you can check his thread here
2)