Rules Table

[pfyon]

Is there some sql file somewhere containing all the currently defined rules? I hate having to put in my own, and it seems like depending on what db version you use, certain defined rules aren't included in the table.

[gaeorn]

The PEQ db contains all the rule entries the SQL was submitted for. This list may not be complete as not every rule is created with the corresponding SQL.

[pfyon]

Whoops, I was looking at the variables table instead of rules_values. Looks like all (or most) of the rules listed in common/ruletypes.h are already there.

[cavedude]

If you find any missing ones, please post so I can add them :)

[ivanstalyn]

Hi,

I really do not know where this update should go whether in utils/sql/svn or in peqdatabase/updates/ but I think you might need to add the following SQL statement in to your next DB update:

DELETE FROM `rule_values` WHERE rule_name IN ('AA:MaxEffectSlots','Pathing:MaxNodesLeftForLOSCh eck','Zone:MQWarpDetectorDistance','Zone:NPCGlobal PositionUpdateInterval','Zone:MQWarpLagThreshold', 'Zone:MQWarpThresholdTimer','Combat:ChanceToHitDiv ideBy','Combat:ArcheryStationaryPenalty');

My best guess is to put an sql file with this update in the utils/sql/svn/ folder.

Anyway, those rules are not in the source code of the rules system since Rev923.

I went through every single sql file of the above mentioned folders. I could not find any sql statement that deletes those rules.

Having those rules in the database produces errors when loading the world in LINUX.

I hope this helps somehow.

Ivancho