Important message concerning new database loadouts!

[RangerDown]

A number of users have recenly reported problems with zoning, either being unable to zone or being dumped into qeynos regardless of destination zone.

If you are one of these, I recommend you make sure you have some data in your "variables" database table.

To see if you have some data in there, get to a MySQL command prompt then give this SQL command:

SELECT * FROM variables;

If you get data returned, then you've got a nicely populated variables table. If you get an empty set, then you have no variables in your table.

The variables table holds a handful of run-time options that determine how the server runs. Among many others, it determines whether the worldserver is connecting to a minilogin vs the public login server, how long corpses should stick around before decay, whether players leave corpses upon death, a zoneserver password (to make sure that only your zoneservers connect to your world), and many many more. The server will probably run variable-less, but almost certainly not run the way you want.

If your server is fairly new, you really ought to take a moment to make sure the data in the variables table suits your server. If you use a GUI application like mysqlfront, you can easily see what each variable is for (there's a field in the variables table set aside for a description of what each variable does).

[corinbon]

Could you possibly throw up a sorucable .sql file for those who have an empty variables table?

[sysadmin]

Here is a dump of variables table

-- MySQL dump 9.11
--
-- Host: localhost Database: velius
-- ------------------------------------------------------
-- Server version 4.0.23-nt

--
-- Table structure for table `variables`
--

CREATE TABLE variables (
varname varchar(25) NOT NULL default '',
value text NOT NULL,
information text NOT NULL,
ts timestamp(14) NOT NULL,
PRIMARY KEY (varname)
) TYPE=MyISAM;

--
-- Dumping data for table `variables`
--

INSERT INTO variables VALUES ('MOTD','Welcome! This is a test server. No GM positions are Available.','Server Message of the Day',20050316140316);
INSERT INTO variables VALUES ('disablecommandline','0','Allow command lines to be run from world.exe | 0 - off | 1 - on |',00000000000000);
INSERT INTO variables VALUES ('PersistentZoneState','0','Save zone state on shutdown for bootup | 0 - off | 1 - on |',20031214171856);
INSERT INTO variables VALUES ('decaytime 1 54','1200','Corpse decay time for Level\'s 1 to 54',20040723184803);
INSERT INTO variables VALUES ('decaytime 55 100','3800','Corpse decay time for Level\'s 55 to 100',20040723184756);
INSERT INTO variables VALUES ('Max_AAXP','21626880','Max AA Experience',00000000000000);
INSERT INTO variables VALUES ('ZSPassword','ZonePass','Zone Server Password',20030628130702);
INSERT INTO variables VALUES ('loglevel','0000','Commands,Merchants,Trades,Loot ',20031214171835);
INSERT INTO variables VALUES ('MerchantsKeepItems','0','Merchants keep items sold to them | 0 - off | 1 - on |',20040417033758);
INSERT INTO variables VALUES ('GuildWars','0','Enable Guild Wars Type Server | 0 - off | 1 - on |',00000000000000);
INSERT INTO variables VALUES ('leavecorpses','0','Players leave corpses | 0 - off | 1 - on |',20030628130755);
INSERT INTO variables VALUES ('holdzones','0','Restart Crashed Zone Servers | 0 - off | 1 - on |',20040629201600);
INSERT INTO variables VALUES ('ailevel','6','',20030620202014);
INSERT INTO variables VALUES ('EXPMod','1','Experience multipler. Increase to increase exp rate',00000000000000);
INSERT INTO variables VALUES ('GroupEXPBonus','.2','Experience multipler. Increase to increase group exp rate',00000000000000);
INSERT INTO variables VALUES ('AAXPMod','1','AA Experience multipler. Increase to increase exp rate',00000000000000);
INSERT INTO variables VALUES ('Expansions','255','Accessible expansions for each player',20041005152814);
INSERT INTO variables VALUES ('DBVersion','Velius Beta Release','DB version info',00000000000000);
INSERT INTO variables VALUES ('ACfail','25','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.',20040822132257);
INSERT INTO variables VALUES ('ACreduction','1','',20040725005754);
INSERT INTO variables VALUES ('ACrandom','5','',20040723084922);

if you use minilogin include this line also:

INSERT INTO variables VALUES ('LoginType','minilogin','Set this to Minilogin to login using a minilogin server :)',20050313212944);

[RangerDown]

Big thanks to Sysadmin for putting that data dump up.

I let the other PEQ guys know that we don't have variables data in our PEQ Velious release atm. (If you source in load_users, you get the table created, but no data populated.) In our "Beta 2" release we hope to have a 5th file in there: data for the variables table.

[corinbon]

HUGE thanks! Great job.