Rules Table
 

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.

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.

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.

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

the rules table needs to be updated
 

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