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

Threaded Mode
Fix t_npc drop hs all mob
ReturnKratos Offline
Member
***
Posts: 207
Threads: 29
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jun 2011
Reputation: 0
#1
10-05-2011, 06:40 PM

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

Find
ReturnKratos Offline
Member
***
Posts: 207
Threads: 29
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jun 2011
Reputation: 0
#2
10-05-2011, 06:53 PM

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

 

2

Find
MonarC
Unregistered
 
#3
10-22-2011, 08:56 PM
Thank you, it work fine =)

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
DocWebster
Unregistered
 
#5
10-23-2011, 03:43 AM
You are an officer and a gentleman and a fine judge of whiskey

MonarC
Unregistered
 
#6
10-23-2011, 07:45 AM
someone, how i add this in my database ?

zhuk Offline
Member
***
Posts: 107
Threads: 1
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jul 2011
Reputation: 0
#7
10-23-2011, 08:38 AM

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

Than add to ur database

Find
rioking Offline
Member
***
Posts: 54
Threads: 4
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Oct 2011
Reputation: 0
#8
10-23-2011, 08:40 AM
hahaha Zhuk Smile

Find
MonarC
Unregistered
 
#9
10-23-2011, 09:03 AM
Can i make a .SQL, how i want ?

someone Offline
Senior Member
****
Posts: 313
Threads: 20
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: Jul 2011
Reputation: 0
#10
10-23-2011, 09:45 AM

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

2

 

phpMyAdmin:

2

Find


Forum Jump:


Users browsing this thread: 1 Guest(s)