LCKB › ** OLD LCKB DATABASE ** › Release Zone › Episode 1 Releases › Server Side v
Fix t_npc drop hs all mob

Linear Mode
Fix t_npc drop hs all mob
someone Offline
Senior Member
****
Posts: 313
Threads: 20
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jul 2011
Reputation: 0
#4
10-23-2011, 12:00 AM

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;

Find


Messages In This Thread
[No subject] - by ReturnKratos - 10-05-2011, 06:40 PM
[No subject] - by ReturnKratos - 10-05-2011, 06:53 PM
[No subject] - by MonarC - 10-22-2011, 08:56 PM
[No subject] - by someone - 10-23-2011, 12:00 AM
[No subject] - by DocWebster - 10-23-2011, 03:43 AM
[No subject] - by MonarC - 10-23-2011, 07:45 AM
[No subject] - by zhuk - 10-23-2011, 08:38 AM
[No subject] - by rioking - 10-23-2011, 08:40 AM
[No subject] - by MonarC - 10-23-2011, 09:03 AM
[No subject] - by someone - 10-23-2011, 09:45 AM
[No subject] - by MonarC - 10-25-2011, 06:36 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)