пля запутался...
Код:
mysql> SELECT * FROM creature_loot_template WHERE item IN (SELECT entry FROM item_template WHERE itemlevel=226) AND entry=38462;
+-------+-------+---------------------+----------+---------+---------------+----------+
| entry | item | ChanceOrQuestChance | lootmode | groupid | mincountOrRef | maxcount |
+-------+-------+---------------------+----------+---------+---------------+----------+
| 38462 | 46113 | 5 | 1 | 1 | 1 | 1 |
| 38462 | 46116 | 5 | 1 | 1 | 1 | 1 |
| 38462 | 46119 | 5 | 1 | 1 | 1 | 1 |
| 38462 | 46121 | 5 | 1 | 1 | 1 | 1 |
| 38462 | 46124 | 10 | 1 | 2 | 1 | 1 |
| 38462 | 46126 | 10 | 1 | 2 | 1 | 1 |
| 38462 | 46132 | 10 | 1 | 1 | 1 | 1 |
| 38462 | 46133 | 10 | 1 | 1 | 1 | 1 |
| 38462 | 46135 | 10 | 1 | 2 | 1 | 1 |
| 38462 | 46139 | 10 | 1 | 2 | 1 | 1 |
| 38462 | 46142 | 10 | 1 | 1 | 1 | 1 |
| 38462 | 46144 | 10 | 1 | 1 | 1 | 1 |
| 38462 | 46148 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46150 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46153 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46155 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46158 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46160 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46163 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46164 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46169 | 0 | 1 | 2 | 1 | 1 |
| 38462 | 46170 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46174 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46176 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46179 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46181 | 0 | 1 | 1 | 1 | 1 |
| 38462 | 46183 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46185 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46188 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46189 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46192 | 3.33 | 1 | 1 | 1 | 1 |
| 38462 | 46195 | 5 | 1 | 2 | 1 | 1 |
| 38462 | 46199 | 3.33 | 1 | 2 | 1 | 1 |
| 38462 | 46200 | 3.33 | 1 | 2 | 1 | 1 |
| 38462 | 46202 | 3.33 | 1 | 2 | 1 | 1 |
| 38462 | 46207 | 3.33 | 1 | 2 | 1 | 1 |
| 38462 | 46208 | 3.33 | 1 | 2 | 1 | 1 |
| 38462 | 46210 | 3.33 | 1 | 2 | 1 | 1 |
+-------+-------+---------------------+----------+---------+---------------+----------+
38 rows in set
вместо этих 38 вещей должны падать эти :
Код:
51209, 51207
51154, 51152
51186, 51188
51159, 51157
51126, 51128, 51131, 51132
51179, 51177, 51181, 51183
51213, 51217, 51211, 51216
51144, 51142, 51148, 51146, 51138, 51136
51169, 51168, 51172, 51171, 51163, 51161
51201, 51203, 51196, 51198, 51191, 51193