Menu
▾
▴
[PlaneShift-svn] SF.net SVN: planeshift:[9094] trunk/src/server
|
From: <ma...@us...> - 2013-12-22 01:03:00
|
Revision: 9094
http://sourceforge.net/p/planeshift/code/9094
Author: magodra
Date: 2013-12-22 01:02:56 +0000 (Sun, 22 Dec 2013)
Log Message:
-----------
Cleaned up pet code regarding timers. Fixed PS#4578.
Modified Paths:
--------------
trunk/src/server/adminmanager.cpp
trunk/src/server/bulkobjects/pscharacter.cpp
trunk/src/server/bulkobjects/pscharacter.h
trunk/src/server/bulkobjects/pscharacterloader.cpp
trunk/src/server/database/mysql/characters.sql
trunk/src/server/database/mysql/math_scripts.sql
trunk/src/server/database/mysql/server_options.sql
trunk/src/server/database/mysql/upgrade_schema.sql
trunk/src/server/gem.h
trunk/src/server/npcmanager.cpp
trunk/src/server/npcmanager.h
trunk/src/server/psserver.cpp
Modified: trunk/src/server/adminmanager.cpp
===================================================================
--- trunk/src/server/adminmanager.cpp 2013-12-22 00:17:59 UTC (rev 9093)
+++ trunk/src/server/adminmanager.cpp 2013-12-22 01:02:56 UTC (rev 9094)
@@ -1626,8 +1626,9 @@
else if(words.GetCount() == (index + 1))
{
if (words[index] == "all" ||
- words[index] == "summary" ||
- words[index] == "old")
+ words[index] == "old" || // For now keep old output format with this option.
+ words[index] == "pet" ||
+ words[index] == "summary")
{
subCmd = words[index];
}
@@ -1647,7 +1648,7 @@
csString AdminCmdDataInfo::GetHelpMessage()
{
- return "Syntax: \"" + command + " summary|all|help\"";
+ return "Syntax: \"" + command + " all|old|pet|summary\"";
}
AdminCmdDataItem::AdminCmdDataItem(AdminManager* msgManager, MsgEntry* me, psAdminCmdMessage &msg, Client* client, WordArray &words)
@@ -5222,6 +5223,11 @@
if(client->GetSecurityLevel() >= GM_LEVEL_0)
{
+ if (npcChar->IsPet() && (data->subCmd == "all" || data->subCmd == "pet"))
+ {
+ psserver->GetNPCManager()->PetInfo(client, npcChar);
+ }
+
// Queue info request perception (Perception as command to superclient)
psserver->GetNPCManager()->QueueInfoRequestPerception(npc, client, data->subCmd);
}
Modified: trunk/src/server/bulkobjects/pscharacter.cpp
===================================================================
--- trunk/src/server/bulkobjects/pscharacter.cpp 2013-12-22 00:17:59 UTC (rev 9093)
+++ trunk/src/server/bulkobjects/pscharacter.cpp 2013-12-22 01:02:56 UTC (rev 9094)
@@ -129,6 +129,10 @@
pid = 0;
ownerId = 0;
+ petElapsedTime = 0.0;
+ lastSavedPetElapsedTime = 0.0;
+
+ joinNotifications = 0;
overrideMaxHp = 0.0f;
overrideMaxMana = 0.0f;
@@ -460,7 +464,9 @@
vitals->SetOrigVitals(); // This saves them as loaded state for restoring later without hitting db, npc death resurrect.
- lastlogintime = row["last_login"];
+ lastLoginTime = row["last_login"];
+ petElapsedTime = row.GetFloat("pet_elapsed_time");
+ lastSavedPetElapsedTime = petElapsedTime;
progressionScriptText = row["progression_script"];
// Set on-hand money.
@@ -923,39 +929,57 @@
return true; // cant see how this can fail, but keep convention for now.
}
-void psCharacter::SetLastLoginTime(const char* last_login, bool save)
+void psCharacter::SetLastLoginTime()
{
csString timeStr;
- if(!last_login)
+ time_t curr=time(0);
+ tm result;
+#ifdef WIN32
+ tm* gmtm = &result;
+ errno_t err = gmtime_s(&result, &curr);
+#else
+ tm* gmtm = gmtime_r(&curr, &result);
+#endif
+
+ lastLoginTime.Format("%d-%02d-%02d %02d:%02d:%02d",
+ gmtm->tm_year+1900,
+ gmtm->tm_mon+1,
+ gmtm->tm_mday,
+ gmtm->tm_hour,
+ gmtm->tm_min,
+ gmtm->tm_sec);
+
+ if(guildinfo)
{
- time_t curr=time(0);
- //TOFIX: gmtime is not thread safe, but windows uses gmtime_s() and linux gmtime_r()
- // so we need a wrapper function or similar
- tm* gmtm = gmtime(&curr);
+ guildinfo->UpdateLastLogin(this);
+ }
- timeStr.Format("%d-%02d-%02d %02d:%02d:%02d",
- gmtm->tm_year+1900,
- gmtm->tm_mon+1,
- gmtm->tm_mday,
- gmtm->tm_hour,
- gmtm->tm_min,
- gmtm->tm_sec);
- }
- else
+ //Store in database
+ if(!db->CommandPump("UPDATE characters SET last_login='%s' WHERE id='%d'", lastLoginTime.GetData(), pid.Unbox()))
{
- timeStr = last_login;
+ Error2("Last login storage: DB Error: %s\n", db->GetLastError());
+ return;
}
+}
- this->lastlogintime = timeStr;
+csString psCharacter::GetLastLoginTime() const
+{
+ return lastLoginTime;
+}
- if(guildinfo)
- guildinfo->UpdateLastLogin(this);
+void psCharacter::SetPetElapsedTime(double elapsedTime)
+{
+ static double saveInterval = 10.0; // Default to 10sec.
+ petElapsedTime = elapsedTime;
- if(save)
+ // If new and last saved value differ for more than saveInterval store the
+ // current value to db.
+ if (fabs(petElapsedTime - lastSavedPetElapsedTime) > saveInterval)
{
+ lastSavedPetElapsedTime = petElapsedTime;
//Store in database
- if(!db->CommandPump("UPDATE characters SET last_login='%s' WHERE id='%d'", timeStr.GetData(), pid.Unbox()))
+ if(!db->CommandPump("UPDATE characters SET pet_elapsed_time='%.2f' WHERE id='%d'", petElapsedTime, pid.Unbox()))
{
Error2("Last login storage: DB Error: %s\n", db->GetLastError());
return;
@@ -963,9 +987,9 @@
}
}
-csString psCharacter::GetLastLoginTime() const
+double psCharacter::GetPetElapsedTime() const
{
- return lastlogintime;
+ return petElapsedTime;
}
bool psCharacter::LoadSpells(PID use_id)
Modified: trunk/src/server/bulkobjects/pscharacter.h
===================================================================
--- trunk/src/server/bulkobjects/pscharacter.h 2013-12-22 00:17:59 UTC (rev 9093)
+++ trunk/src/server/bulkobjects/pscharacter.h 2013-12-22 01:02:56 UTC (rev 9094)
@@ -901,15 +901,28 @@
}
/**
- * Set the last login time for the character in the format YYYY-MM-DD HH:MM:SS.
+ * Set the last login time for the character.
*/
- void SetLastLoginTime(const char* last_login = NULL, bool save = true);
+ void SetLastLoginTime();
/**
* Retrive the last login time in the format YYYY-MM-DD HH:MM:SS.
*/
csString GetLastLoginTime() const;
+ /**
+ * Set the elapsed time for pets.
+ */
+ void SetPetElapsedTime(double elapsedTime);
+
+ /**
+ * Retrive the elapsed time for pets.
+ */
+ double GetPetElapsedTime() const;
+
+ /**
+ * Set the name of the spouse.
+ */
void SetSpouseName(const char* name);
/**
@@ -1778,7 +1791,9 @@
unsigned int timeconnected;
csTicks startTimeThisSession;
- csString lastlogintime;///< String value copied from the database containing the last login time
+ csString lastLoginTime;///< String value copied from the database containing the last login time
+ double petElapsedTime;
+ double lastSavedPetElapsedTime; ///< Store time for when the petElapsedTime was last saved to db.
psMoney money; ///< Current cash set on player.
psMoney bankMoney; ///< Money stored in the players bank account.
Modified: trunk/src/server/bulkobjects/pscharacterloader.cpp
===================================================================
--- trunk/src/server/bulkobjects/pscharacterloader.cpp 2013-12-22 00:17:59 UTC (rev 9093)
+++ trunk/src/server/bulkobjects/pscharacterloader.cpp 2013-12-22 01:02:56 UTC (rev 9094)
@@ -703,23 +703,9 @@
if(!chardata->GetLastLoginTime().GetData())
{
- time_t curr=time(0);
- tm* gmtm = gmtime(&curr);
- csString timeStr;
-
- timeStr.Format("%d-%02d-%02d %02d:%02d:%02d",
- gmtm->tm_year+1900,
- gmtm->tm_mon+1,
- gmtm->tm_mday,
- gmtm->tm_hour,
- gmtm->tm_min,
- gmtm->tm_sec);
- targetUpdate->AddField("last_login", timeStr.GetData() );
+ chardata->SetLastLoginTime();
}
- else
- {
- targetUpdate->AddField("last_login", chardata->GetLastLoginTime().GetData() );
- }
+ targetUpdate->AddField("last_login", chardata->GetLastLoginTime().GetData() );
// Create XML for a new progression script that'll restore ActiveSpells.
csString script;
Modified: trunk/src/server/database/mysql/characters.sql
===================================================================
--- trunk/src/server/database/mysql/characters.sql 2013-12-22 00:17:59 UTC (rev 9093)
+++ trunk/src/server/database/mysql/characters.sql 2013-12-22 01:02:56 UTC (rev 9094)
@@ -61,6 +61,7 @@
`guild_private_notes` varchar(255) default '0',
`join_notifications` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Contains a bitfield with the notifications being issued to this client about players login/logoff',
`last_login` datetime default NULL,
+ `pet_elapsed_time` float(10,2) NOT NULL default '0.00',
`progression_script` blob,
`npc_spawn_rule` int(10) unsigned default '0',
`npc_master_id` int(10) unsigned default '0',
@@ -89,92 +90,93 @@
# Dumping data for table characters
#
-INSERT INTO `characters` VALUES (1,'Guest','Char','',0,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-43.86,-0.01,-152.30,1.50,0,0,0,0,0,NULL,NULL,0,'2006-11-20 19:43:10','',0,0,'N',3,2604,0,180,18,'Was born in a jar','','','',10,'',0,'2001-10-10 00:00:00',0,0);
-INSERT INTO `characters` VALUES (2,'Vengeance','IsMine','',0,0,300.00,60.00,60.00,60.00,60.00,60.00,0.00,280.00,0.00,120.00,200.00,200.00,34,40,10,134,0,0,0,0,0,3,-32.03,0.00,-154.36,0.49,444,9,0,0,0,NULL,NULL,0,'2007-03-27 05:52:44','',0,0,'N',1,14985,0,150,10,'Grew up on a ice mountain','','','',10,'<category attribute=\"Lifecycle\" name=\"Daylight\" value=\"10\" /><category attribute=\"Type\" name=\"Animal\" value=\"5\" />',3,'2006-11-29 21:55:15',0,0);
-INSERT INTO `characters` VALUES (3,'Acraig','Newfie','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,5,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'description','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
-INSERT INTO `characters` VALUES (16,'Guildie','One','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,4,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'I love my guild','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
-INSERT INTO `characters` VALUES (17,'Guilder','Two','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,3,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'My guild is the best','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
-INSERT INTO `characters` VALUES (18,'Guildor','Three','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,2,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15','',0,0,'N',5,3798,0,150,1000,'I\'m proud to be in this guild','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
+INSERT INTO `characters` VALUES (1,'Guest','Char','',0,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-43.86,-0.01,-152.30,1.50,0,0,0,0,0,NULL,NULL,0,'2006-11-20 19:43:10',0.0,'',0,0,'N',3,2604,0,180,18,'Was born in a jar','','','',10,'',0,'2001-10-10 00:00:00',0,0);
+INSERT INTO `characters` VALUES (2,'Vengeance','IsMine','',0,0,300.00,60.00,60.00,60.00,60.00,60.00,0.00,280.00,0.00,120.00,200.00,200.00,34,40,10,134,0,0,0,0,0,3,-32.03,0.00,-154.36,0.49,444,9,0,0,0,NULL,NULL,0,'2007-03-27 05:52:44',0.0,'',0,0,'N',1,14985,0,150,10,'Grew up on a ice mountain','','','',10,'<category attribute=\"Lifecycle\" name=\"Daylight\" value=\"10\" /><category attribute=\"Type\" name=\"Animal\" value=\"5\" />',3,'2006-11-29 21:55:15',0,0);
+INSERT INTO `characters` VALUES (3,'Acraig','Newfie','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,5,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15',0.0,'',0,0,'N',5,3798,0,150,1000,'description','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
+INSERT INTO `characters` VALUES (16,'Guildie','One','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,4,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15',0.0,'',0,0,'N',5,3798,0,150,1000,'I love my guild','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
+INSERT INTO `characters` VALUES (17,'Guilder','Two','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,3,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15',0.0,'',0,0,'N',5,3798,0,150,1000,'My guild is the best','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
+INSERT INTO `characters` VALUES (18,'Guildor','Three','',2,0,144.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-61.32,-0.01,-187.16,0.00,444,2,0,0,0,NULL,NULL,0,'2006-11-29 21:55:15',0.0,'',0,0,'N',5,3798,0,150,1000,'I\'m proud to be in this guild','','','',1000,'',0,'2001-10-10 00:00:00',0,0);
-INSERT INTO `characters` VALUES (4,'MaleEnki','','',1,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-179.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (5,'Smith','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-53.54,0.00,-155.11,0.00,0,0,0,0,0,'','',0,NULL,'',1,5,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (4,'MaleEnki','','',1,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-179.00,0.00,0,0,0,0,0,'','',0,'2000-01-01 00:00:00',0.0,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (5,'Smith','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-53.54,0.00,-155.11,0.00,0,0,0,0,0,'','',0,'2000-01-01 00:00:00',0.0,'',1,5,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-- All fighters have random loot
-INSERT INTO `characters` VALUES (6,'Fighter1','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-2.00,0.00,-181.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (7,'Fighter2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-92.00,0.00,-266.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (8,'Merchant','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-46.54,0.00,-151.11,0.00,0,0,0,0,0,'','',0,NULL,'',1,8,'N',9,0,0,0,0,'description','','','',500,'',0,'0000-00-00 00:00:00', 1,0);
-INSERT INTO `characters` VALUES (9,'Lady','Aren','',14,0,44.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-43.86,-0.01,-152.30,1.50,0,0,0,0,0,NULL,NULL,0,'0000-00-00 00:00:00','',0,0,'N',1,2604,0,180,18,'The love of Guest Char.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (12,'QuestMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-30.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,12,'Y',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (13,'QuestMaster2','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-35.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,13,'Y',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (14,'DictMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-40.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,14,'N',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (15,'DictMaster2','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-45.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,15,'N',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (20,'Miner','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-45.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,'',0,20,'N',9,0,0,0,0,'Tribe member. Used in tribe testing.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (21,'MoveMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-30.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,21,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (22,'MoveMaster2','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-35.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,22,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (23,'MoveMaster3','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-40.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,23,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (24,'MoveMaster4','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-45.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,24,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (25,'Fighter3','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,2.50,0.00,-132.50,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (26,'Fighter4','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,17.50,0.00,-147.50,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (27,'MoveMaster5A','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-60.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,27,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (28,'MoveMaster5B','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-60.00,0.00,-128.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,28,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (29,'MoveMaster5C','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-60.00,0.00,-126.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,29,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (30,'WinchBeast1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-50.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,30,'N',9,0,0,0,0,'Used to test interactions with sequences.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (40,'WinchMover1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,31,'N',9,0,0,0,0,'Used to test interactions with sequences.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (50,'FAMILIAR:Roge','Sample','',23,2,60.00,60.00,60.00,60.00,60.00,60.00,60.00,100.00,100.00,100.00,200.00,200.00,100,100,100,100,100,100,100,100,0,3,0.00,0.00,0.00,0.00,0,0,0,0,0,'','',0,'0000-00-00 00:00:00','',0,0,'N',9,0,0,10000,1000,'A Pet Sample','','','',10000,NULL,0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (51,'FAMILIAR:Clacker','Sample','',24,2,60.00,60.00,60.00,60.00,60.00,60.00,60.00,100.00,100.00,100.00,200.00,200.00,100,100,100,100,100,100,100,100,0,3,0.00,0.00,0.00,0.00,0,0,0,0,0,'','',0,'0000-00-00 00:00:00','',0,0,'N',9,0,0,10000,1000,'A Pet Sample','','','',10000,NULL,0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (52,'FAMILIAR:Rat','Sample','',25,2,60.00,60.00,60.00,60.00,60.00,60.00,60.00,100.00,100.00,100.00,200.00,200.00,100,100,100,100,100,100,100,100,0,3,0.00,0.00,0.00,0.00,0,0,0,0,0,'','',0,'0000-00-00 00:00:00','',0,0,'N',9,0,0,10000,1000,'A Pet Sample','','','',10000,NULL,0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (53,'MoveUnderground','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,53,'N',9,0,0,0,0,'Used to test wander underground.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (6,'Fighter1','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-2.00,0.00,-181.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (7,'Fighter2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-92.00,0.00,-266.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (8,'Merchant','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-46.54,0.00,-151.11,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,8,'N',9,0,0,0,0,'description','','','',500,'',0,'0000-00-00 00:00:00', 1,0);
+INSERT INTO `characters` VALUES (9,'Lady','Aren','',14,0,44.00,40.00,44.00,40.00,40.00,40.00,0.00,100.00,0.00,100.00,216.00,200.00,34,40,10,134,100,100,100,100,0,3,-43.86,-0.01,-152.30,1.50,0,0,0,0,0,NULL,NULL,0,'0000-00-00 00:00:00',0.0,'',0,0,'N',1,2604,0,180,18,'The love of Guest Char.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (12,'QuestMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-30.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,12,'Y',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (13,'QuestMaster2','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-35.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,13,'Y',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (14,'DictMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-40.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,14,'N',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (15,'DictMaster2','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-45.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,15,'N',9,0,0,0,0,'Used for quest testing. Type \"step1\" to start Test.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (20,'Miner','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-45.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',0,20,'N',9,0,0,0,0,'Tribe member. Used in tribe testing.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (21,'MoveMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-30.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,21,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (22,'MoveMaster2','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-35.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,22,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (23,'MoveMaster3','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-40.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,23,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (24,'MoveMaster4','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-45.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,24,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (25,'Fighter3','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,2.50,0.00,-132.50,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (26,'Fighter4','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,17.50,0.00,-147.50,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (27,'MoveMaster5A','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-60.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,27,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (28,'MoveMaster5B','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-60.00,0.00,-128.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,28,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (29,'MoveMaster5C','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-60.00,0.00,-126.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,29,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (30,'WinchBeast1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-50.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,30,'N',9,0,0,0,0,'Used to test interactions with sequences.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (40,'WinchMover1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,31,'N',9,0,0,0,0,'Used to test interactions with sequences.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (50,'FAMILIAR:Roge','Sample','',23,2,60.00,60.00,60.00,60.00,60.00,60.00,60.00,100.00,100.00,100.00,200.00,200.00,100,100,100,100,100,100,100,100,0,3,0.00,0.00,0.00,0.00,0,0,0,0,0,'','',0,'0000-00-00 00:00:00',0.0,'',0,0,'N',9,0,0,10000,1000,'A Pet Sample','','','',10000,NULL,0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (51,'FAMILIAR:Clacker','Sample','',24,2,60.00,60.00,60.00,60.00,60.00,60.00,60.00,100.00,100.00,100.00,200.00,200.00,100,100,100,100,100,100,100,100,0,3,0.00,0.00,0.00,0.00,0,0,0,0,0,'','',0,'0000-00-00 00:00:00',0.0,'',0,0,'N',9,0,0,10000,1000,'A Pet Sample','','','',10000,NULL,0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (52,'FAMILIAR:Rat','Sample','',25,2,60.00,60.00,60.00,60.00,60.00,60.00,60.00,100.00,100.00,100.00,200.00,200.00,100,100,100,100,100,100,100,100,0,3,0.00,0.00,0.00,0.00,0,0,0,0,0,'','',0,'0000-00-00 00:00:00',0.0,'',0,0,'N',9,0,0,10000,1000,'A Pet Sample','','','',10000,NULL,0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (53,'MoveUnderground','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,53,'N',9,0,0,0,0,'Used to test wander underground.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (54,'Gertie','Hollaback','',1,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-178.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (55,'Reginald','Hartlepool','',2,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-177.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (56,'Butch','','',3,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-176.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (57,'Loudon','','',4,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (58,'Cabot','','',5,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-174.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (54,'Gertie','Hollaback','',1,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-178.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (55,'Reginald','Hartlepool','',2,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-177.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (56,'Butch','','',3,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-176.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (57,'Loudon','','',4,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (58,'Cabot','','',5,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-1.00,0.00,-174.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'N',9,0,0,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (59,'NPCroom1','','',9999,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-40.08,0.00,-191.86,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'Y',9,0,0,0,0,'NPCroom1 exploration area.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (60,'NPCroom2','','',9999,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-32.77,2.61,-0.38,0.00,0,0,0,0,0,'','',0,NULL,'',1,4,'Y',9,0,0,0,0,'NPCroom2 exploration area.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (59,'NPCroom1','','',9999,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-40.08,0.00,-191.86,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'Y',9,0,0,0,0,'NPCroom1 exploration area.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (60,'NPCroom2','','',9999,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-32.77,2.61,-0.38,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,4,'Y',9,0,0,0,0,'NPCroom2 exploration area.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (61,'Mount1','','',32,3,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.86,-0.01,-152.30,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'Y',9,0,2,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (62,'Hunter','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-90.00,0.00,-230.00,0.00,0,0,0,0,0,'','',0,NULL,'',0,62,'N',9,0,0,0,0,'Tribe member. Used in tribe testing.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (61,'Mount1','','',32,3,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.86,-0.01,-152.30,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'Y',9,0,2,0,0,'description','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (63,'RespawnCircle','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-415.00,0.00,0,0,0,0,0,'','',0,NULL,'',100,63,'N',0,0,2,0,0,'Test respawn rule in circle','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (64,'RespawnCircle','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-415.00,0.00,0,0,0,0,0,'','',0,NULL,'',100,63,'N',0,0,2,0,0,'Test respawn rule in circle','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (65,'RespawnCircle','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-415.00,0.00,0,0,0,0,0,'','',0,NULL,'',100,63,'N',0,0,2,0,0,'Test respawn rule in circle','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (66,'RespawnArea','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-417.00,0.00,0,0,0,0,0,'','',0,NULL,'',101,63,'N',0,0,2,0,0,'Test respawn rule in area','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (67,'RespawnArea','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-417.00,0.00,0,0,0,0,0,'','',0,NULL,'',101,63,'N',0,0,2,0,0,'Test respawn rule in area','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (68,'RespawnArea','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-417.00,0.00,0,0,0,0,0,'','',0,NULL,'',101,63,'N',0,0,2,0,0,'Test respawn rule in area','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (69,'RespawnLine','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.00,0.00,-379.00,0.00,0,0,0,0,0,'','',0,NULL,'',102,63,'N',0,0,2,0,0,'Test respawn rule in line','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (70,'RespawnLine','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.00,0.00,-379.00,0.00,0,0,0,0,0,'','',0,NULL,'',102,63,'N',0,0,2,0,0,'Test respawn rule in line','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (71,'RespawnLine','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.00,0.00,-379.00,0.00,0,0,0,0,0,'','',0,NULL,'',102,63,'N',0,0,2,0,0,'Test respawn rule in line','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (72,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (73,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (74,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (75,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (76,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (77,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (78,'MoveMaster6','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-15.00,0.00,-230.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,29,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (79,'LocateMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-230.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,29,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (80,'Chaser1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-10.00,0.00,-200.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Used to test chase operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (81,'Chaser2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-37.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Used to test chase operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (82,'SpellMaster1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-25.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,0,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (83,'SpellFighter','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,17.50,0.00,-132.50,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (84,'Fighter5','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-10.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (85,'Fighter6','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-12.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (86,'Fighter7','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-14.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (87,'Fighter8','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-16.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (88,'Fighter9','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-110.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (89,'Fighter10','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-105.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (90,'Fighter11','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-100.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (91,'Fighter12','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-95.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (92,'SpellMaster2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-25.00,0.00,-145.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,0,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (100,'NPC Fighter 1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,20.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (101,'NPC Fighter 2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (102,'NPC Fighter 3','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (103,'NPC Fighter 4','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,20.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (104,'Small Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-160.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,104,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (105,'Large Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,105,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (106,'Huge Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-180.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,106,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
-INSERT INTO `characters` VALUES (107,'Chaser3','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-37.00,0.00,-135.00,0.00,0,0,0,0,0,'','',0,NULL,'',1,6,'N',9,0,2,0,0,'Used to test chase operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (62,'Hunter','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-90.00,0.00,-230.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',0,62,'N',9,0,0,0,0,'Tribe member. Used in tribe testing.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+
+INSERT INTO `characters` VALUES (63,'RespawnCircle','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-415.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',100,63,'N',0,0,2,0,0,'Test respawn rule in circle','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (64,'RespawnCircle','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-415.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',100,63,'N',0,0,2,0,0,'Test respawn rule in circle','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (65,'RespawnCircle','','',2,1,65.00,65.00,65.00,60.00,60.00,60.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-65.00,0.00,-415.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',100,63,'N',0,0,2,0,0,'Test respawn rule in circle','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (66,'RespawnArea','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-417.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',101,63,'N',0,0,2,0,0,'Test respawn rule in area','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (67,'RespawnArea','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-417.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',101,63,'N',0,0,2,0,0,'Test respawn rule in area','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (68,'RespawnArea','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-55.00,0.00,-417.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',101,63,'N',0,0,2,0,0,'Test respawn rule in area','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (69,'RespawnLine','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.00,0.00,-379.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',102,63,'N',0,0,2,0,0,'Test respawn rule in line','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (70,'RespawnLine','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.00,0.00,-379.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',102,63,'N',0,0,2,0,0,'Test respawn rule in line','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (71,'RespawnLine','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-42.00,0.00,-379.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',102,63,'N',0,0,2,0,0,'Test respawn rule in line','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (72,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (73,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (74,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (75,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (76,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (77,'RespawnCombination','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-70.00,0.00,-380.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',103,63,'N',0,0,2,0,0,'Test respawn rule in combination','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (78,'MoveMaster6','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-15.00,0.00,-230.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,29,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (79,'LocateMaster1','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-230.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,29,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (80,'Chaser1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-10.00,0.00,-200.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Used to test chase operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (81,'Chaser2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-37.00,0.00,-130.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Used to test chase operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (82,'SpellMaster1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-25.00,0.00,-150.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,0,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (83,'SpellFighter','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,17.50,0.00,-132.50,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (84,'Fighter5','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-10.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (85,'Fighter6','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-12.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (86,'Fighter7','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-14.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (87,'Fighter8','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-16.00,0.00,-250.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (88,'Fighter9','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-110.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (89,'Fighter10','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-105.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (90,'Fighter11','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-100.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (91,'Fighter12','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,6,-95.00,0.00,-55.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,87,'N',9,0,2,0,0,'Fighting with region','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (92,'SpellMaster2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-25.00,0.00,-145.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,0,'N',9,0,2,0,0,'Used to test NPC spell operations.','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (100,'NPC Fighter 1','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,20.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (101,'NPC Fighter 2','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (102,'NPC Fighter 3','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,25.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (103,'NPC Fighter 4','','',3,1,100.00,100.00,100.00,100.00,100.00,100.00,200.00,200.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,20.00,0.00,-175.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,6,'N',9,0,2,0,0,'Attacking nearest NPC','','','',10,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (104,'Small Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-160.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,104,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00:00:00',0,0);
+INSERT INTO `characters` VALUES (105,'Large Mover','','',7,1,44.00,40.00,44.00,40.00,40.00,40.00,50.00,100.00,100.00,100.00,100.00,100.00,100,100,100,100,100,100,100,100,0,3,-20.00,0.00,-170.00,0.00,0,0,0,0,0,'','',0,NULL,0.0,'',1,105,'N',9,0,0,0,0,'Used to test movement.','','','',500,'',0,'0000-00-00 00...
[truncated message content] |