Here's the latest log. Damned if I can see anything wrong. This log tracks all the way from log in, running to the quest giver, then fialing to get the quest...
NWNX MySQL Plugin V.0.0.8
(c) 2007 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org
(built using mysql-5.0.27 source)
* Log level set to 2 (everything)
* Connecting to server vault.alandfaraway.org
* Plugin initialized.
* Registering under function class SQL
* Executing: CREATE TABLE IF NOT EXISTS `areas` (`ID` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,`ServerID` smallint(8) UNSIGNED NOT NULL,`Name` varchar(64) NOT NULL,`Tag` varchar(64) NOT NULL,`Visits` int(10) UNSIGNED NOT NULL default 0,`X` smallint(5) default NULL,`Y` smallint(5) default NULL,`Z` smallint(5) default NULL,`IsSafe` bool NOT NULL default false,`IsInside` bool NOT NULL default false,`IsNatural` bool NOT NULL default false,PRIMARY KEY (`ID`), UNIQUE KEY (`ServerID`, `Tag`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `cdkeys` (`CDKey` varchar(8) NOT NULL,`IsBanned` bool NOT NULL default false,PRIMARY KEY (`CDKey`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `characters` (`ID` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,`ServerID` smallint(5) UNSIGNED NOT NULL,`PlayerID` mediumint(8) UNSIGNED NOT NULL,`Name` varchar(32) NOT NULL,`Level` tinyint(3) UNSIGNED NOT NULL default 1,`Race` tinyint(3) UNSIGNED NOT NULL,`Subrace` tinyint(3) UNSIGNED default NULL,`Deity` varchar(32) default NULL,`Gender` tinyint(3) UNSIGNED NOT NULL,`HP` smallint(5) UNSIGNED NOT NULL,`XP` mediumint(8) UNSIGNED NOT NULL default 0,`GP` int(10) UNSIGNED NOT NULL default 0,`Wealth` int(10) UNSIGNED NOT NULL default 0,`Ethics` tinyint(3) UNSIGNED NOT NULL,`Morals` tinyint(3) UNSIGNED NOT NULL,`Class1` smallint(5) UNSIGNED NOT NULL,`Level1` tinyint(3) UNSIGNED NOT NULL default 1,`Class2` smallint(5) UNSIGNED default NULL,`Level2` tinyint(3) UNSIGNED default NULL,`Class3` smallint(5) UNSIGNED default NULL,`Level3` tinyint(3) UNSIGNED default NULL,`STR` tinyint(3) UNSIGNED NOT NULL,`CON` tinyint(3) UNSIGNED NOT NULL,`DEX` tinyint(3) UNSIGNED NOT NULL,`INT` tinyint(3) UNSIGNED NOT NULL,`WIS` tinyint(3) UNSIGNED NOT NULL,`CHA` tinyint(3) UNSIGNED NOT NULL,`Location` varchar(128) default NULL,`Damage` smallint(5) UNSIGNED NOT NULL default 0,`Deaths` smallint(5) UNSIGNED NOT NULL default 0,`Status` int(10) UNSIGNED NOT NULL default 0,`IsOnline` bool NOT NULL default false,`IsDeleted` bool NOT NULL default false,`IsPlayable` bool NOT NULL default true,PRIMARY KEY (`ID`), UNIQUE KEY (`PlayerID`, `Name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `heedspwdata` (`player` varchar(64) NOT NULL,`tag` varchar(64) NOT NULL,`name` varchar(64) NOT NULL,`val` varchar(128) default NULL,`expire` mediumint(8) UNSIGNED NOT NULL default 0,`index` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,PRIMARY KEY (`index`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `ipaddress` (`ID` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,`CDKey` varchar(8) NOT NULL,`IPAddress` varchar(16) NOT NULL,`IsBanned` bool NOT NULL default false,PRIMARY KEY (`ID`), UNIQUE KEY (`CDKey`, `IPAddress`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `item_properties` (`ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,`ItemProperty` smallint(5) NOT NULL,`Description` varchar(128) default NULL,`IsIllegal` bool NOT NULL default 0,PRIMARY KEY (`ID`), UNIQUE KEY (`ItemProperty`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `logs` (`ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,`ServerID` smallint(5) UNSIGNED NOT NULL,`CharacterID` mediumint(8) UNSIGNED default NULL,`Event` varchar(32) NOT NULL,`Description` varchar(128) default NULL,`Date` timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `players` (`ID` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,`CDKey` varchar(8) NOT NULL,`Name` varchar(32) NOT NULL,`FirstLogin` datetime,`LastLogin` datetime,`LastLogout` datetime,`Logins` int(10) UNSIGNED NOT NULL default 0,`TimeOnline` mediumint(8) UNSIGNED NOT NULL default 0,`IsDM` bool NOT NULL default false,`IsBanned` bool NOT NULL default false,PRIMARY KEY (`ID`), UNIQUE KEY(`CDKey`, `Name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `pwdata` (`Name` varchar(64) NOT NULL,`Tag` varchar(64) NOT NULL,`Key` varchar(64) NOT NULL,`Value` varchar(128) default NULL,`Expiration` smallint(5) UNSIGNED NOT NULL default 0,`Last` timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (`Name`, `Tag`, `Key`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `pwobject` (`Name` varchar(64) NOT NULL,`Tag` varchar(64) NOT NULL,`Key` varchar(64) NOT NULL,`Value` varchar(128) default NULL,`Expiration` smallint(5) UNSIGNED NOT NULL default 0,`Last` timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (`Name`, `Tag`, `Key`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `quests` (`ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,`ServerID` smallint(5) UNSIGNED NOT NULL,`CharacterID` mediumint(8) UNSIGNED NOT NULL,`PlotID` varchar(32) NOT NULL DEFAULT '',`PlotState` varchar(4) NOT NULL DEFAULT '',PRIMARY KEY (`ID`), UNIQUE KEY(`ServerID`, `CharacterID`, `PlotID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `servers` (`ID` smallint(5) UNSIGNED NOT NULL,`Name` varchar(64) NOT NULL,`IPAddress` varchar(21) NOT NULL,PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: CREATE TABLE IF NOT EXISTS `spelltrack` (`ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,`CharacterID` mediumint(11) UNSIGNED NOT NULL,`Class` smallint(5) NOT NULL,`Uses` varchar(128) default NULL,PRIMARY KEY (`ID`), UNIQUE KEY (`CharacterID`, `Class`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
* Executing: SELECT Value FROM pwdata WHERE Name='alfa_skullport' and Tag='alfa01' and `Key`='ACR_TIME_SERVERTIME'
* Returning: 664363981 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='alfa_skullport' and Tag='alfa01' and `Key`='ACR_TIME_SERVERTIME'
* Returning: 664363981 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('alfa_skullport','alfa01','ACR_TIME_SERVERTIME', '664365840', 0) ON DUPLICATE KEY UPDATE Value='664365840', Expiration=0
* Executing: SELECT pwdata.Name, pwdata.Tag, pwdata.Value, characters.ID, characters.Status FROM characters JOIN players on players.ID=characters.PlayerID JOIN pwdata on pwdata.Name=characters.Name WHERE pwdata.Tag=players.CDKey and pwdata.`Key`='ACR_DTH_LOCATION' and characters.Status = characters.Status | 1
* Returning: #A#sgk_jae_dng_cavel1#X#32.339710236#Y#66.776313782#Z#0.000000006#O#36.074256897 (column 2)
* Returning: KA7HUU74 (column 1)
* Returning: 21 (column 3)
* Returning: 1 (column 4)
* Returning: Kalaine (column 0)
* Returning: #A#sgk_jae_dng_arca1#X#37.158470154#Y#29.817396164#Z#-4.000000000#O#270.460083008 (column 2)
* Returning: KA7HARHW (column 1)
* Returning: 22 (column 3)
* Returning: 1 (column 4)
* Returning: Bronco Mermax (column 0)
* Executing: SELECT * FROM servers WHERE ID=3
* Returning: ALFA 001 Skullport (column 1)
* Returning: 0.0.0.0:5121 (column 2)
* Executing: UPDATE servers SET Name='ALFA 001 Skullport', IPAddress='10.1.1.3:5200' WHERE ID=3
* Executing: UPDATE characters SET IsOnline=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15,11) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (6) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (0) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (1) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (6) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (1) and IsIllegal=1
* Executing: SELECT IsBanned FROM cdkeys WHERE CDKey='KA7HUU74'
* Returning: 0 (column 0)
* Executing: SELECT IsBanned FROM ipaddress WHERE CDKey='KA7HUU74'
* Returning: 0 (column 0)
* Executing: SELECT ID, IsBanned, CDKey FROM players WHERE Name='indio'
* Returning: 0 (column 1)
* Returning: 1 (column 0)
* Returning: KA7HUU74 (column 2)
* Executing: SELECT ID, IsDeleted, IsPlayable FROM characters WHERE PlayerID=1 and Name='Reytlin'
* Returning: 0 (column 1)
* Returning: 1 (column 2)
* Returning: 73 (column 0)
* Executing: INSERT INTO logs (ServerID, CharacterID, Event, Description) VALUES (3,73,'Login','Character: Reytlin')
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_MOD_STARTINGGOLD'
* Returning: 1 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_MOD_FIRSTAID_IT'
* Returning: 1 (column 0)
* Executing: SELECT ServerID, XP, GP, STR, CON, DEX, `INT`, WIS, CHA, Damage, Location FROM characters WHERE ID=73
* Returning: #A#WuggsNecessities#X#12.652141571#Y#33.683593750#Z#-0.000000000#O#53.303405762 (column 10)
* Returning: 3 (column 0)
* Returning: 29010 (column 1)
* Returning: 4551 (column 2)
* Returning: 14 (column 3)
* Returning: 14 (column 4)
* Returning: 14 (column 5)
* Returning: 14 (column 6)
* Returning: 8 (column 7)
* Returning: 17 (column
* Returning: 0 (column 9)
* Executing: SELECT Uses FROM spelltrack WHERE CharacterID=73
* Executing: UPDATE characters, players SET characters.IsOnline=1, players.LastLogin=now(), players.Logins=players.Logins+1, players.IsDM=0 WHERE characters.ID=73 and players.ID=characters.PlayerID
* Executing: SELECT Status FROM characters WHERE id=73
* Returning: 0 (column 0)
* Executing: SELECT Status FROM characters WHERE id=73
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_DTH_LOCATION'
* Executing: SELECT PlotID, PlotState FROM quests WHERE ServerID=3 AND CharacterID=73
* Executing: SELECT Status FROM characters WHERE id=73
* Returning: 0 (column 0)
* Executing: SELECT Status FROM characters WHERE id=73
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_LOGOUT_TIMER'
* Returning: 664363500 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_HEAL_BONUS'
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_FLAGS'
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_FLAGS'
* Returning: 0 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Reytlin','KA7HUU74','ACR_REST_FLAGS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_FLAGS'
* Returning: 0 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Reytlin','KA7HUU74','ACR_REST_FLAGS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Reytlin','KA7HUU74','ACR_REST_HEAL_BONUS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_STUDY_TIMER'
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_PRAYER_TIMER'
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_REST_TIMER'
* Returning: 11072614 (column 0)
* Executing: DELETE FROM spelltrack WHERE CharacterID=73
* Executing: UPDATE characters SET ServerID=3, Location='#A#01a_startarea#X#40.568988800#Y#22.533580780#Z#-0.000000000#O#270.000000000', Level=8, Deity='No Deity', HP=64, XP=29010, GP=4551, Morals=85, Ethics=50, Damage=0, Class1=1, Class2=255, Class3=255, Level1=8, Level2=0, Level3=0, STR=14, CON=14, DEX=14, `INT`=14, WIS=8, CHA=17 WHERE ID=73
* Executing: UPDATE characters SET ServerID=3, Location='#A#01a_startarea#X#40.568988800#Y#22.533580780#Z#-0.000000000#O#270.000000000', Level=8, Deity='No Deity', HP=64, XP=29010, GP=4551, Morals=85, Ethics=50, Damage=0, Class1=1, Class2=255, Class3=255, Level1=8, Level2=0, Level3=0, STR=14, CON=14, DEX=14, `INT`=14, WIS=8, CHA=17 WHERE ID=73
* Executing: SELECT Status FROM characters WHERE id=73
* Returning: 0 (column 0)
* Executing: SELECT Status FROM characters WHERE id=73
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_XP_BANKED_RPHOURS'
* Returning: 3 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_XPZ_XP'
* Returning: 29010 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Reytlin','KA7HUU74','ACR_XPZ_XP', '29011', 0) ON DUPLICATE KEY UPDATE Value='29011', Expiration=0
* Executing: SELECT Value FROM pwdata WHERE Name='Reytlin' and Tag='KA7HUU74' and `Key`='ACR_XP_TOTAL_LIFETIME_RPXP'
* Returning: 10 (column 0)
* Executing: INSERT INTO logs (ServerID, CharacterID, Event, Description) VALUES (3,73,'XP Gain, RP Scripts','1 XP for 3 game-hours. Lifetime total from these scripts is 11.')
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Reytlin','KA7HUU74','ACR_XP_BANKED_RPHOURS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Reytlin','KA7HUU74','ACR_XP_TOTAL_LIFETIME_RPXP', '11', 0) ON DUPLICATE KEY UPDATE Value='11', Expiration=0
