jorooo

Well guys, I would update first post but, why are there some comented lines in the query? And one more thing, is there any difference in using Hex and Dec. Let's unify the quiries a bit ;]

A friend of mine did a few tests on offy and confirmed. 1 sec hidden cooldown for SoC Procs.

As I mentioned before in another topic, among the hardest to review patches, are the big SQL patches. Though they do not require any knowledge of the code. So maybe it is a good idea to have an SQL branch in the under review section, and some kind of SQL Devs to handle those patches. Or maybe leave more tables to be handled by DB, like spell_proc_event and spell_bonus_data.

Nice, this part also need some love Your work is apriciated, thank you! Btw does this section include, vmaps and movemaps? P.S. Sorry for offtopic.

Yup, ReqSourceRef seems trivial and obsolete.

From wowiki: So it is possible to proc twice in a sec, if it procs on ability and on the triggered auto attack.

Sure... It's done

Tested and works as expected

I thing so.

It's done, tnx.

Those are about to be removed in 3.1.0

Bump + a little cosmetics for Rhyll's fix ;] DELETE FROM `spell_proc_event` WHERE `entry`='60200';

Okay, I checked some other topics. UDB Wiki is outdated indeed. First post updated

Because I don't have access to a MaNGOS DB ATM.

Thank you, Sarjuuk. Just a question before I try to do it UDB Wiki says there are 8 columns in spell_proc_event. Why do you insert 11 values? Is UDB Wiki outdated?

Okay this started as a fix for two spell procs but expanded quite alot, so maybe a mod can change the topic to something more generic ;] Here is the SQL: DELETE FROM `spell_proc_event` WHERE `entry` IN (20375, 50781, 51414, 54695, 54707, 54738, 54808, 54838, 54841, 55747, 57345, 57352, 58442, 58444, 58901, 59345, 60061, 60063, 60066, 60221, 60301, 60306, 60317, 60436, 60442, 60473, 60482, 60487, 60490, 60519, 60529, 60537, 61618, 55381, 27521, 38347, 34320, 33297, 38299, 55640, 55768, 55776, 59630, 61356); INSERT INTO `spell_proc_event`(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ('20375', '0', '0', '0', '0', '0', '0', '0', '7', '0', '1'), -- Seal of Command ('50781', '0', '0', '0', '0', '0', '0', '2', '0', '0', '6'), -- Fate Rune of Primal Energy ('51414', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Venomous Tome ('54695', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Death Knight's Anguish ('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'), -- Sonic Booster ('54738', '0', '0', '0', '0', '0', '0', '2', '0', '0', '45'), -- Serrah's Star ('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'), -- Noise Machine ('54838', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Valonforth's Remembrance ('54841', '0', '0', '0', '0', '0', '0', '2', '0', '0', '3'), -- Thunder Capacitor ('55747', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Horn of Argent Fury ('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Darkmoon Card: Greatness ('57352', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Darkmoon Card: Death ('58442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15'), -- Airy Pale Ale ('58444', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5'), -- Worg Tooth Oatmeal Stout ('58901', '0', '0', '0', '0', '0', '0', '2', '0', '0', '45'), -- Tears of Bitter Anguish ('59345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Crusader's Locket ('60061', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Scarab of the Infinite Cycle ('60063', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Sundial of the Exiled ('60066', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Hourglass of the Unraveller ('60221', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Essence of Gossamer ('60301', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Meteorite Whetstone ('60306', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Vestige of Haldor ('60317', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Signet of Edward the Odd ('60436', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Grim Toll ('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Bandit's Insignia ('60473', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Forge Ember ('60482', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Pendulum of Telluric Currents ('60487', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15'), -- Extract of Necromantic Power ('60490', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Embrace of the Spider ('60519', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Spark of Life ('60529', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Forethought Talisman ('60537', '0', '0', '0', '0', '0', '0', '2', '0', '0', '45'), -- Soul of the Dead ('61618', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Chuchu's Tiny Box of Horrors ('55381', '0', '0', '0', '0', '0', '0', '65536', '0', '0', '15'), -- Insightful Earthsiege Diamond ('27521', '0', '0', '0', '0', '0', '0', '65536', '0', '0', '15'), -- Insightful Earthstorm Diamond ('38347', '0', '0', '0', '0', '0', '0', '2', '0', '0', '45'), -- Sextant of Unstable Currents ('34320', '0', '0', '0', '0', '0', '0', '2', '0', '0', '45'), -- Shiffar's Nexus-Horn ('33297', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Quagmirran's Eye ('38299', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15'), -- Fel Reaver's Piston ('55640', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Lightweave ('55768', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'), -- Darkglow ('55776', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Swordguard ('59630', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'), -- Black Magic ('61356', '0', '0', '0', '0', '0', '680' , '2', '0', '0', '90'); -- Invigorating Earthsiege Diamond Credits: Sephiroth1983, nos4r2zod, Sarjuuk, oc_redfox, Alez and me.

I can confirm the bug. Kinda annoying

This seems promising Hopefully the devs will have time to commit this patch in git :rolleyes:

I meant the phasing introduced in WotLK. e.g. DK Phases http://www.wowwiki.com/Phasing

Shouldn't something similar be written for Phases support? Only it should be player dependant, not realm dependant.

I have no idea :lol: Search here -> http://wiki.udbforums.org/index.php

Yes, this can be set in the DB.

You can ask specific questions in the forums ;] I'm sure the devs or some expirienced user will answer xP

Thanks and Merry Christmas!

With those two in todo list, I doubt you can actually test something about this patch... yet... Neo's proposal for upload was directed at coders willing to develop the patch, I believe.