LCKB
Fix t_npc drop hs all mob - Printable Version

+- 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: Fix t_npc drop hs all mob (/showthread.php?tid=211)

Pages: 1 2

- ReturnKratos - 10-05-2011


HI GUYS

 

New update interesting:

 

2

 

Guide:

1. Download

2. Open Navicat

3. Execute SQL file

4. if succesful test if work

 

EHM acepted 1+ XD



- ReturnKratos - 10-05-2011


DOWNLOAD THIS !!!! I FIXED THE PERCENT OF DROP ITEM....NOW HS AND OTHER ITEM DROP 100%

 

2



- MonarC - 10-22-2011

Thank you, it work fine =)



- someone - 10-23-2011


I think your SQL code needs a little modification(because some NPCS has Items on those slots).

UPDATE `newproject_data`.`t_npc` SET `a_item_15` = 85;
UPDATE `newproject_data`.`t_npc` SET `a_item_16` = 85;
UPDATE `newproject_data`.`t_npc` SET `a_item_17` = 85;

Here IS my version:

SET @itemID = YOUR ITEM ID; /* HS = 85 */

UPDATE `newproject_data`.`t_npc` SET `a_item_0` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` = -1 and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_1` = @itemID
WHERE `a_item_1` = -1 and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` = @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_2` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` = -1
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_3` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` =-1 and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_4` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` = -1
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_5` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` = -1 and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_6` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` = -1
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_6` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` = -1
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_7` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6`!= @itemID
and `a_item_7` = -1 and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_8` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` = -1
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_9` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` = -1 and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_10` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` = -1
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_11` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` = -1;

UPDATE `newproject_data`.`t_npc` SET `a_item_12` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` = -1 and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_13` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` = -1
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID ;

UPDATE `newproject_data`.`t_npc` SET `a_item_14` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` = -1 and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_15` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` =-1
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_16` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` = -1 and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_17` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` = -1
and `a_item_18` != @itemID and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_18` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` = -1 and `a_item_19` != @itemID
and `a_item_0` != @itemID and `a_item_11` != @itemID;

UPDATE `newproject_data`.`t_npc` SET `a_item_19` = @itemID
WHERE `a_item_1` != @itemID and `a_item_2` != @itemID
and `a_item_3` != @itemID and `a_item_4` != @itemID
and `a_item_5` != @itemID and `a_item_6` != @itemID
and `a_item_7` != @itemID and `a_item_8` != @itemID
and `a_item_9` != @itemID and `a_item_10` != @itemID
and `a_item_12` != @itemID and `a_item_13` != @itemID
and `a_item_14` != @itemID and `a_item_15` != @itemID
and `a_item_16` != @itemID and `a_item_17` != @itemID
and `a_item_18` != @itemID and `a_item_19` = -1
and `a_item_0` != @itemID and `a_item_11` != @itemID;

 

 

The Item Procent.

SET @procent = YOUR PROCENT; /* 10000 ->100% */
SET @itemID = YOUR ITEM ID; /* HS = 85 */

UPDATE `newproject_data`.`t_npc` SET `a_item_percent_0` = @procent WHERE `a_item_0` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_1` = @procent WHERE `a_item_1` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_2` = @procent WHERE `a_item_2` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_3` = @procent WHERE `a_item_3` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_4` = @procent WHERE `a_item_4` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_5` = @procent WHERE `a_item_5` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_6` = @procent WHERE `a_item_6` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_7` = @procent WHERE `a_item_7` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_8` = @procent WHERE `a_item_8` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_9` = @procent WHERE `a_item_9` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_10` = @procent WHERE `a_item_10` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_11` = @procent WHERE `a_item_11` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_12` = @procent WHERE `a_item_12` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_13` = @procent WHERE `a_item_13` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_14` = @procent WHERE `a_item_14` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_15` = @procent WHERE `a_item_15` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_16` = @procent WHERE `a_item_16` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_17` = @procent WHERE `a_item_17` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_18` = @procent WHERE `a_item_18` = @itemID;
UPDATE `newproject_data`.`t_npc` SET `a_item_percent_19` = @procent WHERE `a_item_19` = @itemID;



- DocWebster - 10-23-2011

You are an officer and a gentleman and a fine judge of whiskey



- MonarC - 10-23-2011

someone, how i add this in my database ?



- zhuk - 10-23-2011


someone, how i add this in my database ?
omg, make .sql file and put this in it.

Than add to ur database



- rioking - 10-23-2011

hahaha Zhuk Smile



- MonarC - 10-23-2011

Can i make a .SQL, how i want ?



- someone - 10-23-2011


someone, how i add this in my database ?
With Navicat:

2

 

phpMyAdmin:

2