Maybe it's an old versionof the ACR? I don't know. Any help appreciated, plus a link to the most recent ACR would be great.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='Skullport' and Tag='alfa01' and `Key`='ACR_TIME_SERVERTIME'
* Returning: 664355041 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Skullport' and Tag='alfa01' and `Key`='ACR_TIME_SERVERTIME'
* Returning: 664355041 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Skullport','alfa01','ACR_TIME_SERVERTIME', '664356480', 0) ON DUPLICATE KEY UPDATE Value='664356480', 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
* Executing: SELECT * FROM servers WHERE ID=1
* Executing: INSERT INTO servers (ID, Name, IPAddress) VALUES(1,'ALFA Skullport','0.0.0.0:5121')
* Executing: UPDATE characters SET IsOnline=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* 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 Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (80) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15,63,63,63,63,63) 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,63,63,63) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (56) 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,11) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT PlotState FROM quests WHERE ServerID=1 AND CharacterID=0 AND PlotID='foc_tutor_01'
* 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,63,63,63) 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 Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT Status FROM characters WHERE id=0
* Executing: SELECT ID FROM item_properties WHERE ItemProperty in (15,1) and IsIllegal=1
* Executing: SELECT Status FROM characters WHERE id=0
* 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 FROM players WHERE CDKey='KA7HUU74' and Name='indio'
* Returning: 0 (column 1)
* Returning: 1 (column 0)
* Executing: SELECT ID, IsDeleted, IsPlayable FROM characters WHERE PlayerID=1 and Name='Kadmaq Ebelless'
* Returning: 0 (column 1)
* Returning: 1 (column 2)
* Returning: 4 (column 0)
* Executing: INSERT INTO logs (ServerID, CharacterID, Event, Description) VALUES (1,4,'Login','Character: Kadmaq Ebelless')
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_MOD_STARTINGGOLD'
* Returning: 1 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' 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=4
* Returning: #A#peasanthome3firstfloor#X#4.399686337#Y#1.599997520#Z#0.000000000#O#122.005516052 (column 10)
* Returning: 0 (column 0)
* Returning: 4032 (column 1)
* Returning: 1224 (column 2)
* Returning: 14 (column 3)
* Returning: 10 (column 4)
* Returning: 16 (column 5)
* Returning: 14 (column 6)
* Returning: 8 (column 7)
* Returning: 15 (column
* Returning: 0 (column 9)
* Executing: INSERT INTO logs (ServerID, CharacterID, Event, Description) VALUES (1,4,'Login, Quarantined','Character: Kadmaq Ebelless')
* Executing: UPDATE characters, players SET characters.IsOnline=1, players.LastLogin=now(), players.Logins=players.Logins+1, players.IsDM=0 WHERE characters.ID=4 and players.ID=characters.PlayerID
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_DTH_LOCATION'
* Executing: SELECT PlotID, PlotState FROM quests WHERE ServerID=1 AND CharacterID=4
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_LOGOUT_TIMER'
* Returning: 664354920 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_HEAL_BONUS'
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_FLAGS'
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_FLAGS'
* Returning: 0 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Kadmaq Ebelless','KA7HUU74','ACR_REST_FLAGS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_FLAGS'
* Returning: 0 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Kadmaq Ebelless','KA7HUU74','ACR_REST_FLAGS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Kadmaq Ebelless','KA7HUU74','ACR_REST_HEAL_BONUS', '0', 0) ON DUPLICATE KEY UPDATE Value='0', Expiration=0
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_STUDY_TIMER'
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_PRAYER_TIMER'
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_REST_TIMER'
* Returning: 11073027 (column 0)
* Executing: DELETE FROM spelltrack WHERE CharacterID=4
* Executing: UPDATE characters SET ServerID=1, Location='#A##X#100.146377563#Y#103.775772095#Z#42.310310364#O#270.000000000', Level=3, Deity='No Deity', HP=26, XP=4032, GP=1224, Morals=85, Ethics=15, Damage=0, Class1=8, Class2=4, Class3=255, Level1=1, Level2=2, Level3=0, STR=14, CON=10, DEX=16, `INT`=14, WIS=8, CHA=15 WHERE ID=4
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_XP_BANKED_RPHOURS'
* Returning: 0 (column 0)
* Executing: SELECT PlotState FROM quests WHERE ServerID=1 AND CharacterID=4 AND PlotID='sp_pirates_a'
* Executing: UPDATE characters SET ServerID=1, Location='#A#peasanthome3firstfloor#X#4.399686337#Y#1.599997520#Z#0.000000000#O#122.005516052', Level=3, Deity='No Deity', HP=26, XP=4032, GP=1224, Morals=85, Ethics=15, Damage=0, Class1=8, Class2=4, Class3=255, Level1=1, Level2=2, Level3=0, STR=14, CON=10, DEX=16, `INT`=14, WIS=8, CHA=15 WHERE ID=4
* Executing: SELECT PlotState FROM quests WHERE ServerID=1 AND CharacterID=4 AND PlotID='sp_pirates_a'
* Executing: INSERT INTO logs (ServerID, CharacterID, Event, Description) VALUES (1,4,'Logout','Character: Kadmaq Ebelless')
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Kadmaq Ebelless','KA7HUU74','ACR_REST_LOGOUT_TIMER', '664356600', 0) ON DUPLICATE KEY UPDATE Value='664356600', Expiration=0
* Executing: UPDATE characters SET ServerID=1, Level=3, Deity='No Deity', HP=26, XP=4032, GP=1224, Morals=85, Ethics=15, Damage=0, Class1=8, Class2=4, Class3=255, Level1=1, Level2=2, Level3=0, STR=14, CON=10, DEX=16, `INT`=14, WIS=8, CHA=15 WHERE ID=4
* Executing: SELECT Status FROM characters WHERE id=4
* Returning: 0 (column 0)
* Executing: UPDATE characters SET IsOnline=0 WHERE ID=4
* Executing: SELECT Value FROM pwdata WHERE Name='Kadmaq Ebelless' and Tag='KA7HUU74' and `Key`='ACR_XP_BANKED_RPHOURS'
* Returning: 0 (column 0)
* Executing: INSERT INTO pwdata (Name, Tag, `Key`, Value, Expiration) VALUES ('Kadmaq Ebelless','KA7HUU74','ACR_XP_BANKED_RPHOURS', '1', 0) ON DUPLICATE KEY UPDATE Value='1', Expiration=0
Thanks.