[FIXED]Fringe Science Benefits - Quest - 13373

[Header]

Fringe Science Benefits не зачита гарголитите и дебелаците...

[untaught]

А въобще има ли ги точно тези мобове?

[Header]

Щом пиша, че ги има най-вероятно съм ги бил за да кажа,че не ги отчита?

[untaught]

Я ми ги снимай да ги видя къде са точно тези, защото аз не ги виждам в базата с данни да са спаунати.

[Header]

Дебелаците сега видях, че наистина ги няма... но гарголитите са си там и не ги отчита -
http://tinypic.com/view.php?pic=166n3sy&s=5

[untaught]

Код: [Маркирай кода]

SET @GUID=xxxxx; --last guid +1
UPDATE `creature_template` SET `maxlevel`=80,`minlevel`=80,`modelid1`=15961,`faction_a`=14,`faction_h`=14 WHERE `entry`=32410;

insert into `creature` values
(@GUID,'32410','571','1','0','0','0','7735.94','1682.79','344.863','2.3664','300','0','0','5342','0','0','0','0','0'),
(@GUID+1,'32410','571','1','0','0','0','7749.98','1568.42','349.802','4.32047','300','0','0','5342','0','0','0','0','0'),
(@GUID+2,'32410','571','1','0','0','0','7624.33','1570.72','334.919','0.406831','300','0','0','5342','0','0','0','0','0'),
(@GUID+3,'32410','571','1','0','0','0','7690.89','1592.45','337.377','3.02613','300','0','0','5342','0','0','0','0','0'),
(@GUID+4,'32410','571','1','0','0','0','7779.23','1759.86','353.793','1.59985','300','0','0','5342','0','0','0','0','0'),
(@GUID+5,'32410','571','1','0','0','0','7738.3','1845.29','356.402','3.15101','300','0','0','5342','0','0','0','0','0'),
(@GUID+6,'32410','571','1','0','0','0','7706.23','1922.14','364.422','4.14533','300','0','0','5342','0','0','0','0','0'),
(@GUID+7,'32410','571','1','0','0','0','7622.65','1846.83','363.436','4.95821','300','0','0','5342','0','0','0','0','0'),
(@GUID+8,'32410','571','1','0','0','0','7606.6','1759.81','350.984','4.86789','300','0','0','5342','0','0','0','0','0'),
(@GUID+9,'32410','571','1','0','0','0','7633.81','1680.41','341.685','0.175134','300','0','0','5342','0','0','0','0','0'),
(@GUID+10,'32410','571','1','0','0','0','7668.11','1654.93','338.913','5.95567','300','0','0','5342','0','0','0','0','0'),
(@GUID+11,'32188','571','1','0','0','0','7851.76','1911.66','363.971','4.84669','300','0','0','12600','3994','0','0','0','0'),
(@GUID+12,'32188','571','1','0','0','0','7782.79','1837.95','358.809','4.4854','300','0','0','12600','3994','0','0','0','0'),
(@GUID+13,'32188','571','1','0','0','0','7762.64','1797.01','350.904','1.52837','300','0','0','12600','3994','0','0','0','0'),
(@GUID+14,'32188','571','1','0','0','0','7668.42','1718.71','347.262','4.13354','300','0','0','12600','3994','0','0','0','0'),
(@GUID+15,'32188','571','1','0','0','0','7617.72','1722.05','344.808','0.933038','300','0','0','12600','3994','0','0','0','0'),
(@GUID+16,'32188','571','1','0','0','0','7548.8','1698.53','353.788','6.05776','300','0','0','12600','3994','0','0','0','0'),
(@GUID+16,'32188','571','1','0','0','0','7715.43','1636.01','340.375','3.63874','300','0','0','12600','3994','0','0','0','0'),
(@GUID+17,'32188','571','1','0','0','0','7795.16','1592.53','359.311','3.21462','300','0','0','12600','3994','0','0','0','0'),
(@GUID+18,'32188','571','1','0','0','0','7608.77','1574.33','338.322','1.05477','300','0','0','12600','3994','0','0','0','0'),
(@GUID+19,'32188','571','1','0','0','0','7579.39','1677.84','345.918','0.948746','300','0','0','12600','3994','0','0','0','0'),
(@GUID+20,'32188','571','1','0','0','0','7628.34','1649.86','340.437','5.83235','300','0','0','12600','3994','0','0','0','0'),
(@GUID+21,'32188','571','1','0','0','0','7697.04','1703.15','342.091','5.69726','300','0','0','12600','3994','0','0','0','0'),
(@GUID+22,'32188','571','1','0','0','0','7856.72','1830.75','363.998','3.1722','300','0','0','12600','3994','0','0','0','0'),
(@GUID+23,'32188','571','1','0','0','0','7816.48','1748.81','355.562','4.66603','300','0','0','12600','3994','0','0','0','0'),
(@GUID+24,'32188','571','1','0','0','0','7589.41','1774.34','356.161','4.06756','300','0','0','12600','3994','0','0','0','0'),
(@GUID+25,'32188','571','1','0','0','0','7592.97','1841.03','366.428','0.80423','300','0','0','12600','3994','0','0','0','0'),
(@GUID+26,'32188','571','1','0','0','0','7699.87','1850.62','355.349','1.41684','300','0','0','12600','3994','0','0','0','0'),
(@GUID+27,'32188','571','1','0','0','0','7675.93','1897.64','359.545','4.98255','300','0','0','12600','3994','0','0','0','0');


[admin]

Относно creatures, не може ли да ползваме добавянето им по следния начин:

Код: [Маркирай кода]

DELETE FROM `creature` WHERE `id` IN (32410, 32188); -- проверка за съществуващи (да не направим дубликати)
insert into `creature` values
(NULL,'32410','571','1','0','0','0','7735.94','1682.79','344.863','2.3664','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7749.98','1568.42','349.802','4.32047','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7624.33','1570.72','334.919','0.406831','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7690.89','1592.45','337.377','3.02613','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7779.23','1759.86','353.793','1.59985','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7738.3','1845.29','356.402','3.15101','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7706.23','1922.14','364.422','4.14533','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7622.65','1846.83','363.436','4.95821','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7606.6','1759.81','350.984','4.86789','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7633.81','1680.41','341.685','0.175134','300','0','0','5342','0','0','0','0','0'),
(NULL,'32410','571','1','0','0','0','7668.11','1654.93','338.913','5.95567','300','0','0','5342','0','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7851.76','1911.66','363.971','4.84669','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7782.79','1837.95','358.809','4.4854','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7762.64','1797.01','350.904','1.52837','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7668.42','1718.71','347.262','4.13354','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7617.72','1722.05','344.808','0.933038','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7548.8','1698.53','353.788','6.05776','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7715.43','1636.01','340.375','3.63874','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7795.16','1592.53','359.311','3.21462','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7608.77','1574.33','338.322','1.05477','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7579.39','1677.84','345.918','0.948746','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7628.34','1649.86','340.437','5.83235','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7697.04','1703.15','342.091','5.69726','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7856.72','1830.75','363.998','3.1722','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7816.48','1748.81','355.562','4.66603','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7589.41','1774.34','356.161','4.06756','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7592.97','1841.03','366.428','0.80423','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7699.87','1850.62','355.349','1.41684','300','0','0','12600','3994','0','0','0','0'),
(NULL,'32188','571','1','0','0','0','7675.93','1897.64','359.545','4.98255','300','0','0','12600','3994','0','0','0','0');

Предлагам го за да не ми се налага да помня/записвам до коя creature guid сме стигнали. По този начин се генерират автоматично след най-голямата добавена.

(предишните скриптове мога да ги променя при мен)

Изключение може да има ако ни е необходимо точно guid ИД-то на моба, което ме съмнява да се ползва някъде за справка, ползва се само id колоната.

Добавил съм го и може да тествате след рестарт.

[untaught]

Може, но проблема е, че така се генерира не последен+1, а над 10К мисля, че беше и после почват +1,+1... И така става, но остават празни много guids. Както кажеш, така ще е.

Код: [Маркирай кода]

UPDATE `creature_template` SET `maxlevel`=80,`minlevel`=80,`modelid1`=15961,`faction_a`=14,`faction_h`=14 WHERE `entry`=32410;Изтървал си това и са невидими.

[admin]

Готово. Добавих го и релоаднах таблицата.

[untaught]

Като ги добавя ръчно се виждат вече, но ги няма спаунати.
Явно phasemask се иска да е 1 както си написал в другата тема.

[Header]

fixed.