default rule set :)

[Cripp]

Hi, thought i would post the sql for the full default ruleset values...
here it is as it is present...

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:MaxLevel", "65");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:DeathExpLossLevel", "6");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:LeaveCorpses", "false");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:CorpseDecayTimeMS", "10800000");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:LeaveNakedCorpses", "false");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:ExpMultiplier", "1.0");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:AutosaveIntervalS", "300");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:HPRegenMultiplier", "100");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:ManaRegenMultiplier", "100");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Character:EnduranceRegenMultiplier", "100");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Guild:MaxMembers", "2048");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Skills:MaxTrainTradeskills", "21");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Pets:AttackCommandRange", "150");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "GM:MinStatusToZoneAnywhere", "250");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "World:ZoneAutobootTimeoutMS", "60000");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "World:ClientKeepaliveTimeoutMS", "65000");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Spells:SpellAggroModifier", "100");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Spells:BardSpellAggroMod", "3");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Spells:PetSpellAggroMod", "10");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Combat:BaseCritChance", "0.0");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Combat:WarBerBaseCritChance", "0.03");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Combat:BerserkBaseCritChance", "0.06");

INSERT INTO rule_values
  (ruleset_id, rule_name, rule_value)
VALUES
  (0, "Combat:NPCBashKickLevel", "6");

I will add more threads to this as more rules are added to the source.. I think i actualy might be missing 1 or 2 in this one.. ill have to check and repost an updated one.

edit: i will also add this to the wiki and update it there too.
safe travels

[rojadruid]

That would be good I just edited that pages recently with with a slq example.

[John Adams]

Thanks for the info, Cripp. I forget exactly how I got a default rules set before, but it was something like setting everything to defaults in-game, then saving that set do a new name. I think it dumped everything *default* to the rule_values table using my new name (it's been a long time, so I am not sure if these were the exact steps). With all the new rules being developed, it's good to know how to create default sets, for those who like to *see* them

Thanks again!
J