Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-10-2008, 12:51 AM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

Quote:
Originally Posted by blackjack1 View Post
thanks much which table is this.. does it say "variables" on it. maybe I just keep missing it??

thanks
Yes it will say Variables, What DB are you using? Correct me if i'm wrong, But I don;t think PEQ comes with this table, If you don;t have the table you could just run this.

Code:
CREATE TABLE `variables` (
  `varname` varchar(25) NOT NULL default '',
  `value` text NOT NULL,
  `information` text NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `variables` VALUES ('MOTD', 'Welcome to Shards of LaMarch. If you experience any problems you can contact Souls @ lamarch.no-ip.org/eq. ETA\'s will not be given for anything. However, I will be working on updates as I find time. Visit lamarch.no-ip.org/eq . THIS SERVER WILL BE UP AND DOWN. I AM WORKING ON THE SERVER. PLEASE BE PATIENT.', '', '2007-08-08 20:44:55');
INSERT INTO `variables` VALUES ('disablecommandline', '0', 'Allow command lines to be run from world.exe | 0 - off | 1 - on |', '2004-10-20 07:49:25');
INSERT INTO `variables` VALUES ('GuildCreation', '3', 'Sets amount of people needed to create a guild.', '2006-10-31 13:22:56');
INSERT INTO `variables` VALUES ('GroupEXPBonus', '1.75\r\n', 'Amount of bonus experiance for grouping.', '2007-01-13 21:23:36');
INSERT INTO `variables` VALUES ('PersistentZoneState', '0', 'Save zone state on shutdown for bootup | 0 - off | 1 - on |', '0000-00-00 00:00:00');
INSERT INTO `variables` VALUES ('decaytime 1 54', '600', 'Corpse decay time for Level\'s 1 to 54', '2007-08-08 20:45:10');
INSERT INTO `variables` VALUES ('decaytime 55 100', '1800', 'Corpse decay time for Level\'s 55 to 100', '0000-00-00 00:00:00');
INSERT INTO `variables` VALUES ('Max_AAXP', '21626880', 'Max AA Experience', '0000-00-00 00:00:00');
INSERT INTO `variables` VALUES ('ZSPassword', '12345', 'Zone Server Password', '2005-09-14 21:50:25');
INSERT INTO `variables` VALUES ('loglevel', '0000', 'Commands,Merchants,Trades,Loot  ', '0000-00-00 00:00:00');
INSERT INTO `variables` VALUES ('MerchantsKeepItems', '1', 'Merchants keep items sold to them | 0 - off | 1 - on |', '2004-08-27 18:12:07');
INSERT INTO `variables` VALUES ('GuildWars', '0', 'Enable Guild Wars Type Server | 0 - off | 1 - on |', '0000-00-00 00:00:00');
INSERT INTO `variables` VALUES ('leavecorpses', '1', 'Players leave corpses | 0 - off | 1 - on |', '2004-10-19 20:41:59');
INSERT INTO `variables` VALUES ('holdzones', '1', 'Restart Crashed Zone Servers | 0 - off | 1 - on |', '2004-09-19 15:05:13');
INSERT INTO `variables` VALUES ('EXPMod', '2.0', 'Experience multipler. Increase to increase exp rate', '2007-10-14 20:46:29');
INSERT INTO `variables` VALUES ('AAXPMod', '1.5', 'AA Experience multipler. Increase to increase exp rate', '2007-04-22 04:24:40');
INSERT INTO `variables` VALUES ('Expansions', '255', 'Accessible expansions for each player', '2004-04-03 21:54:03');
INSERT INTO `variables` VALUES ('LoginType', 'public', 'Set this to Minilogin to login using a minilogin server :)', '2007-10-31 18:55:46');
INSERT INTO `variables` VALUES ('ServerType', '0', 'Sets server type | 0 - normal | 1 - pvp |', '2004-10-28 11:09:41');
INSERT INTO `variables` VALUES ('DisableNoDrop', '0', 'Takes No-Drop off of items', '2004-10-28 11:08:04');
INSERT INTO `variables` VALUES ('ACfail', '35', 'the percentage of time AC fails to protect. 0 would mean there was always some level of protection, 100 would mean AC has no affect. When AC fails, it will be possible to get a max dmg hit.', '2005-02-04 11:36:09');
INSERT INTO `variables` VALUES ('ACreduction', '1', 'the percentage of AC that is ALWAYS reduced from a hit (except when AC fails with ACfail) \n\n', '2004-11-03 10:24:23');
INSERT INTO `variables` VALUES ('ACrandom', '3', 'the maximum amount of additional protection AC provides. 0 would mean no additional protection is provided, otherwise an additional amount of reduction is calculated using a random percentage of 1 to this value (except when AC fails with ACfail) \n', '2005-02-04 11:36:15');
INSERT INTO `variables` VALUES ('DBVersion', 'test', 'DB version info', '2007-08-08 20:42:59');
INSERT INTO `variables` VALUES ('LootCoin', '0', 'Allows players to loot coin off a player corpse in pvp | 0 - off | 1 - on |', '2004-11-08 07:28:26');
INSERT INTO `variables` VALUES ('PvPreward', '0', 'Allows players to loot items off a player corpse in pvp | 0 - no items | 1 - a single item | 2 - all items | 3 - item specified in PvPreward |', '2004-11-08 07:28:35');
INSERT INTO `variables` VALUES ('PvPitem', '0', 'Specific item that can be looted off a player in pvp', '2004-11-08 07:28:08');
INSERT INTO `variables` VALUES ('ailevel', '6', 'Had something to do with NPC casting. Leave at 6.', '2005-10-01 10:37:20');
INSERT INTO `variables` VALUES ('startzone', 'tutorial', '', '2007-08-08 14:01:58');
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 04:11 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3