public void writeWaypointstoSQL()
{
SqlWrapper ms = new SqlWrapper();
int count;
ms.SqlDelete("DELETE FROM "+getSQLTablefromDynelType()+"waypoints WHERE ID="+ID.ToString());
for (count = 0; count < Waypoints.Count; count++)
{
ms.SqlInsert("INSERT INTO " + getSQLTablefromDynelType() + "waypoints VALUES (" + ID.ToString() + "," + PlayField.ToString() + ","
+ String.Format(System.Globalization.CultureInfo.InvariantCulture, "'{0}'", Waypoints[count].x) + ","
+ String.Format(System.Globalization.CultureInfo.InvariantCulture, "'{0}'", Waypoints[count].y) + ","
+ String.Format(System.Globalization.CultureInfo.InvariantCulture, "'{0}'", Waypoints[count].z) + ")");
}
if (Waypoints.Count > 0) { }
}
// Save All Container Arrays To SQL
void SaveToSQL(string tablename)
{
SqlWrapper sql = new SqlWrapper();
sql.SqlDelete("DELETE FROM " + tablename + " WHERE container=" + Type + " AND ID=" + Instance);
for (int i = 0; i < Items.Length; i++)
{
if (Items[i] is ContainerEntry)
{
// Not instanced items first
ContainerEntry ce = (ContainerEntry)Items[i];
sql.SqlInsert("INSERT INTO " + tablename + " (ID,Placement, flags, multiplecount, type,instance, lowid,highid, quality,nothing, container) VALUES (" + Instance + "," + i + "," + ce.Flags + "," + ce.Amount + ",0,0," + ce.LowID + "," + ce.HighID + "," + ce.QL + ",0," + Type + ")");
}
else
{
// Do instanced items stuff here
// insert into inventory table AND store item's stats
}
}
}
/// <summary>
/// Write nanos to database
/// TODO: catch exceptions
/// </summary>
public void writeNanostoSQL()
{
lock (ActiveNanos)
{
SqlWrapper ms = new SqlWrapper();
int count;
ms.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "activenanos WHERE ID=" + ID.ToString());
for (count = 0; count < ActiveNanos.Count; count++)
{
ms.SqlInsert("INSERT INTO " + getSQLTablefromDynelType() + "activenanos VALUES (" + ID.ToString() + "," + ActiveNanos[count].ID.ToString() + "," + ActiveNanos[count].NanoStrain.ToString() + ")");
}
}
}
/// <summary>
/// Write timers to database
/// TODO: catch exceptions
/// </summary>
public void writeTimerstoSQL()
{
lock (Timers)
{
SqlWrapper ms = new SqlWrapper();
int count;
// remove HP and NP tick
count = Timers.Count;
while (count > 0)
{
count--;
if ((Timers[count].Strain == 0) || (Timers[count].Strain == 1))
{
Timers.RemoveAt(count);
}
}
ms.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "timers WHERE ID=" + ID.ToString());
TimeSpan ts;
DateTime n = DateTime.Now;
for (count = 0; count < Timers.Count; count++)
{
ts = Timers[count].Timestamp - n;
ms.SqlInsert("INSERT INTO " + getSQLTablefromDynelType() + "timers VALUES (" + ID.ToString() + "," + Timers[count].Strain + "," + Timers[count].Timestamp.Second.ToString() + ",X'" + Timers[count].Function.ToBlob() + "');");
}
}
}
public static void Read(byte[] packet, Client client)
{
SqlWrapper mys = new SqlWrapper();
// Packet Reader Unknown Values are Returning 0 Integers, Unable to Store Needed Packet data To Reply.
#region PacketReader
PacketReader packetReader = new PacketReader(packet);
Header m_header = packetReader.PopHeader(); // 0 - 28
byte unknown = packetReader.PopByte(); // 29
int actionNum = packetReader.PopInt(); // 30 - 33
int unknown1 = packetReader.PopInt(); // 34 - 37
Identity m_ident = packetReader.PopIdentity(); // 38 - 35
int unknown2 = packetReader.PopInt(); // 36 - 39
int unknown3 = packetReader.PopInt(); // 40 - 43
short unknown4 = packetReader.PopShort(); // 44 - 45
#endregion
switch (actionNum)
{
#region Cast nano
case 19: // Cast nano
{
// CastNanoSpell
PacketWriter castNanoSpell = new PacketWriter();
castNanoSpell.PushByte(0xDF);
castNanoSpell.PushByte(0xDF);
castNanoSpell.PushShort(10);
castNanoSpell.PushShort(1);
castNanoSpell.PushShort(0);
castNanoSpell.PushInt(3086);
castNanoSpell.PushInt(client.Character.Id);
castNanoSpell.PushInt(0x25314D6D);
castNanoSpell.PushIdentity(50000, client.Character.Id);
castNanoSpell.PushByte(0);
castNanoSpell.PushInt(unknown3); // Nano ID
castNanoSpell.PushIdentity(m_ident); // Target
castNanoSpell.PushInt(0);
castNanoSpell.PushIdentity(50000, client.Character.Id); // Caster
byte[] castNanoSpellA = castNanoSpell.Finish();
Announce.Playfield(client.Character.PlayField, castNanoSpellA);
// CharacterAction 107
PacketWriter characterAction107 = new PacketWriter();
characterAction107.PushByte(0xDF);
characterAction107.PushByte(0xDF);
characterAction107.PushShort(10);
characterAction107.PushShort(1);
characterAction107.PushShort(0);
characterAction107.PushInt(3086);
characterAction107.PushInt(client.Character.Id);
characterAction107.PushInt(0x5E477770);
characterAction107.PushIdentity(50000, client.Character.Id);
characterAction107.PushByte(0);
characterAction107.PushInt(107);
characterAction107.PushInt(0);
characterAction107.PushInt(0);
characterAction107.PushInt(0);
characterAction107.PushInt(1);
characterAction107.PushInt(unknown3);
characterAction107.PushShort(0);
byte[] characterAction107A = characterAction107.Finish();
Announce.Playfield(client.Character.PlayField, characterAction107A);
// CharacterAction 98
PacketWriter characterAction98 = new PacketWriter();
characterAction98.PushByte(0xDF);
characterAction98.PushByte(0xDF);
characterAction98.PushShort(10);
characterAction98.PushShort(1);
characterAction98.PushShort(0);
characterAction98.PushInt(3086);
characterAction98.PushInt(client.Character.Id);
characterAction98.PushInt(0x5E477770);
characterAction98.PushIdentity(m_ident);
characterAction98.PushByte(0);
characterAction98.PushInt(98);
characterAction98.PushInt(0);
characterAction98.PushInt(0xCF1B);
characterAction98.PushInt(unknown3);
characterAction98.PushInt(client.Character.Id);
characterAction98.PushInt(0x249F0); // duration?
characterAction98.PushShort(0);
byte[] characterAction98A = characterAction98.Finish();
Announce.Playfield(client.Character.PlayField, characterAction98A);
}
break;
#endregion
#region search
/* this is here to prevent server crash that is caused by
* search action if server doesn't reply if something is
* found or not */
case 66: // If action == search
{
/* Msg 110:136744723 = "No hidden objects found." */
client.SendFeedback(110, 136744723);
}
break;
#endregion
#region info
case 105: // If action == Info Request
{
Client tPlayer = null;
if ((tPlayer = FindClient.FindClientById(m_ident.Instance)) != null)
{
#region Titles
uint LegacyScore = tPlayer.Character.Stats.PvpRating.StatBaseValue;
string LegacyTitle = null;
if (LegacyScore < 1400)
{
LegacyTitle = "";
}
else if (LegacyScore < 1500)
{
LegacyTitle = "Freshman";
}
else if (LegacyScore < 1600)
{
LegacyTitle = "Rookie";
}
else if (LegacyScore < 1700)
{
LegacyTitle = "Apprentice";
}
else if (LegacyScore < 1800)
{
LegacyTitle = "Novice";
}
else if (LegacyScore < 1900)
{
LegacyTitle = "Neophyte";
}
else if (LegacyScore < 2000)
{
LegacyTitle = "Experienced";
}
else if (LegacyScore < 2100)
{
LegacyTitle = "Expert";
}
else if (LegacyScore < 2300)
{
LegacyTitle = "Master";
}
else if (LegacyScore < 2500)
{
LegacyTitle = "Champion";
}
else
{
LegacyTitle = "Grand Master";
}
#endregion
int orgGoverningForm = 0;
SqlWrapper ms = new SqlWrapper();
DataTable dt =
ms.ReadDatatable(
"SELECT `GovernmentForm` FROM organizations WHERE ID=" + tPlayer.Character.OrgId);
if (dt.Rows.Count > 0)
{
orgGoverningForm = (Int32)dt.Rows[0][0];
}
string orgRank = OrgClient.GetRank(
orgGoverningForm, tPlayer.Character.Stats.ClanLevel.StatBaseValue);
// Uses methods in ZoneEngine\PacketHandlers\OrgClient.cs
/* Known packetFlags--
* 0x40 - No org | 0x41 - Org | 0x43 - Org and towers | 0x47 - Org, towers, player has personal towers | 0x50 - No pvp data shown
* Bitflags--
* Bit0 = hasOrg, Bit1 = orgTowers, Bit2 = personalTowers, Bit3 = (Int32) time until supression changes (Byte) type of supression level?, Bit4 = noPvpDataShown, Bit5 = hasFaction, Bit6 = ?, Bit 7 = null.
*/
byte packetFlags = 0x40; // Player has no Org
if (tPlayer.Character.OrgId != 0)
{
packetFlags = 0x41; // Player has Org, no towers
}
PacketWriter infoPacket = new PacketWriter();
// Start packet header
infoPacket.PushByte(0xDF);
infoPacket.PushByte(0xDF);
infoPacket.PushShort(10);
infoPacket.PushShort(1);
infoPacket.PushShort(0);
infoPacket.PushInt(3086); // sender (server ID)
infoPacket.PushInt(client.Character.Id); // receiver
infoPacket.PushInt(0x4D38242E); // packet ID
infoPacket.PushIdentity(50000, tPlayer.Character.Id); // affected identity
infoPacket.PushByte(0); // ?
// End packet header
infoPacket.PushByte(packetFlags); // Based on flags above
infoPacket.PushByte(1); // esi_001?
infoPacket.PushByte((byte)tPlayer.Character.Stats.Profession.Value); // Profession
infoPacket.PushByte((byte)tPlayer.Character.Stats.Level.Value); // Level
infoPacket.PushByte((byte)tPlayer.Character.Stats.TitleLevel.Value); // Titlelevel
infoPacket.PushByte((byte)tPlayer.Character.Stats.VisualProfession.Value);
// Visual Profession
infoPacket.PushShort(0); // Side XP Bonus
infoPacket.PushUInt(tPlayer.Character.Stats.Health.Value); // Current Health (Health)
infoPacket.PushUInt(tPlayer.Character.Stats.Life.Value); // Max Health (Life)
infoPacket.PushInt(0); // BreedHostility?
infoPacket.PushUInt(tPlayer.Character.OrgId); // org ID
infoPacket.PushShort((short)tPlayer.Character.FirstName.Length);
infoPacket.PushBytes(Encoding.ASCII.GetBytes(tPlayer.Character.FirstName));
infoPacket.PushShort((short)tPlayer.Character.LastName.Length);
infoPacket.PushBytes(Encoding.ASCII.GetBytes(tPlayer.Character.LastName));
infoPacket.PushShort((short)LegacyTitle.Length);
infoPacket.PushBytes(Encoding.ASCII.GetBytes(LegacyTitle));
infoPacket.PushShort(0); // Title 2
// If receiver is in the same org as affected identity, whom is not orgless, send org rank and city playfield
if ((client.Character.OrgId == tPlayer.Character.OrgId) && (tPlayer.Character.OrgId != 0))
{
infoPacket.PushShort((short)orgRank.Length);
infoPacket.PushBytes(Encoding.ASCII.GetBytes(orgRank));
infoPacket.PushInt(0);
//infoPacket.PushIdentity(0, 0); // City (50201, Playfield) // Pushed 1 zero to much and screwed info for characters in orgs, but I´ll leave it for later just incase.
}
infoPacket.PushUInt(tPlayer.Character.Stats.InvadersKilled.Value); // Invaders Killed
infoPacket.PushUInt(tPlayer.Character.Stats.KilledByInvaders.Value); // Killed by Invaders
infoPacket.PushUInt(tPlayer.Character.Stats.AlienLevel.Value); // Alien Level
infoPacket.PushUInt(tPlayer.Character.Stats.PvpDuelKills.Value); // Pvp Duel Kills
infoPacket.PushUInt(tPlayer.Character.Stats.PvpDuelDeaths.Value); // Pvp Duel Deaths
infoPacket.PushUInt(tPlayer.Character.Stats.PvpProfessionDuelDeaths.Value);
// Pvp Profession Duel Kills
infoPacket.PushUInt(tPlayer.Character.Stats.PvpRankedSoloKills.Value); // Pvp Solo Kills
infoPacket.PushUInt(tPlayer.Character.Stats.PvpRankedSoloDeaths.Value); // Pvp Team Kills
infoPacket.PushUInt(tPlayer.Character.Stats.PvpSoloScore.Value); // Pvp Solo Score
infoPacket.PushUInt(tPlayer.Character.Stats.PvpTeamScore.Value); // Pvp Team Score
infoPacket.PushUInt(tPlayer.Character.Stats.PvpDuelScore.Value); // Pvp Duel Score
byte[] infoPacketA = infoPacket.Finish();
client.SendCompressed(infoPacketA);
}
else
{
NonPlayerCharacterClass npc =
(NonPlayerCharacterClass)FindDynel.FindDynelById(m_ident.Type, m_ident.Instance);
if (npc != null)
{
PacketWriter infoPacket = new PacketWriter();
// Start packet header
infoPacket.PushByte(0xDF);
infoPacket.PushByte(0xDF);
infoPacket.PushShort(10);
infoPacket.PushShort(1);
infoPacket.PushShort(0);
infoPacket.PushInt(3086); // sender (server ID)
infoPacket.PushInt(client.Character.Id); // receiver
infoPacket.PushInt(0x4D38242E); // packet ID
infoPacket.PushIdentity(50000, npc.Id); // affected identity
infoPacket.PushByte(0); // ?
// End packet header
infoPacket.PushByte(0x50); // npc's just have 0x50
infoPacket.PushByte(1); // esi_001?
infoPacket.PushByte((byte)npc.Stats.Profession.Value); // Profession
infoPacket.PushByte((byte)npc.Stats.Level.Value); // Level
infoPacket.PushByte((byte)npc.Stats.TitleLevel.Value); // Titlelevel
infoPacket.PushByte((byte)npc.Stats.VisualProfession.Value); // Visual Profession
infoPacket.PushShort(0); // no idea for npc's
infoPacket.PushUInt(npc.Stats.Health.Value); // Current Health (Health)
infoPacket.PushUInt(npc.Stats.Life.Value); // Max Health (Life)
infoPacket.PushInt(0); // BreedHostility?
infoPacket.PushUInt(0); // org ID
infoPacket.PushShort(0);
infoPacket.PushShort(0);
infoPacket.PushShort(0);
infoPacket.PushShort(0);
infoPacket.PushInt(0x499602d2);
infoPacket.PushInt(0x499602d2);
infoPacket.PushInt(0x499602d2);
byte[] infoPacketA = infoPacket.Finish();
client.SendCompressed(infoPacketA);
}
}
}
break;
#endregion
#region logout
case 120: // If action == Logout
{
//Start 30 second logout timer if client is not a GM (statid 215)
if (client.Character.Stats.GMLevel.Value == 0)
{
client.startLogoutTimer();
}
else // If client is a GM, disconnect without timer
{
client.Server.DisconnectClient(client);
}
}
break;
case 121: // If action == Stop Logout
{
//Stop current logout timer and send stop logout packet
client.Character.UpdateMoveType((byte)client.Character.PreviousMoveMode);
client.CancelLogOut();
}
break;
#endregion
#region stand
case 87: // If action == Stand
{
client.Character.UpdateMoveType(37);
//Send stand up packet, and cancel timer/send stop logout packet if timer is enabled
client.StandCancelLogout();
}
break;
#endregion
#region Team
case 22: //Kick Team Member
{
}
break;
case 24: //Leave Team
{
TeamClass team = new TeamClass();
team.LeaveTeam(client);
}
break;
case 25: //Transfer Team Leadership
{
}
break;
case 26: //Team Join Request
{
// Send Team Invite Request To Target Player
TeamClass team = new TeamClass();
team.SendTeamRequest(client, m_ident);
}
break;
case 28: //Request Reply
{
// Check if positive or negative response
// if positive
TeamClass team = new TeamClass();
uint teamID = TeamClass.GenerateNewTeamId(client, m_ident);
// Destination Client 0 = Sender, 1 = Reciever
// Reciever Packets
///////////////////
// CharAction 15
team.TeamRequestReply(client, m_ident);
// CharAction 23
team.TeamRequestReplyCharacterAction23(client, m_ident);
// TeamMember Packet
team.TeamReplyPacketTeamMember(1, client, m_ident, "Member1");
// TeamMemberInfo Packet
team.TeamReplyPacketTeamMemberInfo(1, client, m_ident);
// TeamMember Packet
team.TeamReplyPacketTeamMember(1, client, m_ident, "Member2");
// Sender Packets
/////////////////
// TeamMember Packet
team.TeamReplyPacketTeamMember(0, client, m_ident, "Member1");
// TeamMemberInfo Packet
team.TeamReplyPacketTeamMemberInfo(0, client, m_ident);
// TeamMember Packet
team.TeamReplyPacketTeamMember(0, client, m_ident, "Member2");
}
break;
#endregion
#region Delete Item
case 0x70:
mys.SqlDelete(
"DELETE FROM " + client.Character.GetSqlTablefromDynelType() + "inventory WHERE placement="
+ m_ident.Instance.ToString() + " AND container=" + m_ident.Type.ToString());
InventoryEntries i_del = client.Character.GetInventoryAt(m_ident.Instance);
client.Character.Inventory.Remove(i_del);
byte[] action2 = new byte[0x37];
Array.Copy(packet, action2, 0x37);
action2[8] = 0x00;
action2[9] = 0x00;
action2[10] = 0x0C;
action2[11] = 0x0E;
client.SendCompressed(action2);
break;
#endregion
#region Split item
case 0x34:
int nextid = client.Character.GetNextFreeInventory(m_ident.Type);
InventoryEntries i = client.Character.GetInventoryAt(m_ident.Instance);
i.Item.MultipleCount -= unknown3;
InventoryEntries i2 = new InventoryEntries();
i2.Item = i.Item.ShallowCopy();
i2.Item.MultipleCount = unknown3;
i2.Placement = nextid;
client.Character.Inventory.Add(i2);
client.Character.WriteInventoryToSql();
break;
#endregion
#region Join item
case 0x35:
InventoryEntries j1 = client.Character.GetInventoryAt(m_ident.Instance);
InventoryEntries j2 = client.Character.GetInventoryAt(unknown3);
j1.Item.MultipleCount += j2.Item.MultipleCount;
client.Character.Inventory.Remove(j2);
client.Character.WriteInventoryToSql();
byte[] joined = new byte[0x37];
Array.Copy(packet, joined, 0x37);
joined[8] = 0x00;
joined[9] = 0x00;
joined[10] = 0x0C;
joined[11] = 0x0E;
client.SendCompressed(joined);
break;
#endregion
#region Sneak Action
// ###################################################################################
// Spandexpants: This is all i have done so far as to make sneak turn on and off,
// currently i cannot find a missing packet or link which tells the server the player
// has stopped sneaking, hidden packet or something, will come back to later.
// ###################################################################################
// Sneak Packet Received
case 163:
{
PacketWriter Sneak = new PacketWriter();
// TODO: IF SNEAKING IS ALLOWED RUN THIS CODE.
// Send Action 162 : Enable Sneak
Sneak.PushByte(0xDF);
Sneak.PushByte(0xDF);
Sneak.PushShort(0xA);
Sneak.PushShort(1);
Sneak.PushShort(0);
Sneak.PushInt(3086); // Send
Sneak.PushInt(client.Character.Id); // Reciever
Sneak.PushInt(0x5e477770); // Packet ID
Sneak.PushIdentity(50000, client.Character.Id); // TYPE / ID
Sneak.PushInt(0);
Sneak.PushByte(0xA2); // Action ID
Sneak.PushInt(0);
Sneak.PushInt(0);
Sneak.PushInt(0);
Sneak.PushInt(0);
Sneak.PushInt(0);
Sneak.PushShort(0);
byte[] sneakpacket = Sneak.Finish();
client.SendCompressed(sneakpacket);
// End of Enable sneak
// TODO: IF SNEAKING IS NOT ALLOWED SEND REJECTION PACKET
}
break;
#endregion
#region Use Item on Item
case 81:
{
Identity item1 = new Identity();
Identity item2 = new Identity();
item1.Type = m_ident.Type;
item1.Instance = m_ident.Instance;
item2.Type = unknown2;
item2.Instance = unknown3;
Tradeskill cts = new Tradeskill(client, item1.Instance, item2.Instance);
cts.ClickBuild();
break;
}
#endregion
#region Change Visual Flag
case 166:
{
client.Character.Stats.VisualFlags.Set(unknown3);
// client.SendChatText("Setting Visual Flag to "+unknown3.ToString());
AppearanceUpdate.AnnounceAppearanceUpdate(client.Character);
break;
}
#endregion
#region Tradeskill Source Changed
case 0xdc:
TradeSkillReceiver.TradeSkillSourceChanged(client, unknown2, unknown3);
break;
#endregion
#region Tradeskill Target Changed
case 0xdd:
TradeSkillReceiver.TradeSkillTargetChanged(client, unknown2, unknown3);
break;
#endregion
#region Tradeskill Build Pressed
case 0xde:
TradeSkillReceiver.TradeSkillBuildPressed(client, m_ident.Instance);
break;
#endregion
#region default
default:
{
byte[] action = new byte[0x37];
Array.Copy(packet, action, 0x37);
action[8] = 0x00;
action[9] = 0x00;
action[10] = 0x0C;
action[11] = 0x0E;
Announce.Playfield(client.Character.PlayField, action);
}
break;
#endregion
}
packetReader.Finish();
}
/// <summary>
/// Write bank contents to database
/// TODO: catch exceptions
/// </summary>
public void WriteBankContentsToSql()
{
lock (this.bank)
{
SqlWrapper sqlWrapper = new SqlWrapper();
sqlWrapper.SqlDelete("DELETE FROM bank WHERE charID=" + this.Id.ToString());
foreach (AOItem item in this.bank)
{
string insert = "INSERT INTO bank VALUES(" + this.Id.ToString() + "," + item.Flags.ToString() + ","
+ item.LowID.ToString() + "," + item.HighID.ToString() + ","
+ item.MultipleCount.ToString() + "," + item.Quality.ToString() + ","
+ item.Type.ToString() + "," + item.Instance.ToString() + ",X'";
foreach (AOItemAttribute tempattr in item.Stats)
{
insert = insert + this.reverseString(tempattr.Stat.ToString("X8"))
+ this.reverseString(tempattr.Stat.ToString("X8"));
}
insert = insert + "');";
sqlWrapper.SqlInsert(insert);
}
}
}
/// <summary>
/// Write nanos to database
/// TODO: catch exceptions
/// </summary>
public void WriteNanosToSql()
{
lock (this.activeNanos)
{
SqlWrapper sqlWrapper = new SqlWrapper();
int count;
sqlWrapper.SqlDelete(
"DELETE FROM " + this.GetSqlTablefromDynelType() + "activenanos WHERE ID=" + this.Id.ToString());
for (count = 0; count < this.activeNanos.Count; count++)
{
sqlWrapper.SqlInsert(
"INSERT INTO " + this.GetSqlTablefromDynelType() + "activenanos VALUES (" + this.Id.ToString()
+ "," + this.activeNanos[count].ID.ToString() + ","
+ this.activeNanos[count].NanoStrain.ToString() + ")");
}
}
}
/// <summary>
/// </summary>
/// <param name="charid">
/// </param>
public void DeleteChar(int charid)
{
var ms = new SqlWrapper();
try
{
/* delete char */
/* i assume there should be somewhere a flag, caus FC can reenable a deleted char.. */
string sqlQuery = "DELETE FROM `characters` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
StatDao.DeleteStats(50000, charid);
sqlQuery = "DELETE FROM `organizations` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
sqlQuery = "DELETE FROM `inventory` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
}
catch (Exception e)
{
Console.WriteLine(this.Name + e.Message);
}
}
public void writeMeshstoSQL()
{
SqlWrapper Sql = new SqlWrapper();
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "meshs WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
int c;
for (c = 0; c < Meshs.Count; c++)
{
Sql.SqlInsert("INSERT INTO " + getSQLTablefromDynelType() + "meshs VALUES (" + ID.ToString() + "," + PlayField.ToString() + "," + Meshs[c].Position.ToString() + "," + Meshs[c].Mesh.ToString() + "," + Meshs[c].OverrideTexture.ToString() + ")");
}
}
// Save All Container Arrays To SQL
void SaveToSQL(string tablename)
{
SqlWrapper sql = new SqlWrapper();
sql.SqlDelete("DELETE FROM " + tablename + " WHERE container=" + Type + " AND ID=" + Instance);
for (int i = 0; i < Items.Length; i++)
{
if (Items[i] is ContainerEntry)
{
// Not instanced items first
ContainerEntry ce = (ContainerEntry)Items[i];
sql.SqlInsert("INSERT INTO " + tablename + " (ID,Placement, flags, multiplecount, type,instance, lowid,highid, quality,nothing, container) VALUES (" + Instance + "," + i + "," + ce.Flags + "," + ce.Amount + ",0,0," + ce.LowID + "," + ce.HighID + "," + ce.QL + ",0," + Type + ")");
}
else
{
// Do instanced items stuff here
// insert into inventory table AND store item's stats
}
}
}
/// <summary>
///
/// </summary>
/// <param name="client"></param>
/// <param name="charid"></param>
public void DeleteChar(Client client, Int32 charid)
{
MemoryStream stream = new MemoryStream();
BinaryWriter writer = new BinaryWriter(stream);
SqlWrapper ms = new SqlWrapper();
try
{
/* delete char */
/* i assume there should be somewhere a flag, caus FC can reenable a deleted char.. */
string sqlQuery = "DELETE FROM `characters` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
sqlQuery = "DELETE FROM `characters_stats` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
sqlQuery = "DELETE FROM `organizations` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
sqlQuery = "DELETE FROM `inventory` WHERE ID = " + charid;
ms.SqlDelete(sqlQuery);
}
catch (Exception e)
{
Console.WriteLine(this.Name + e.Message);
}
/* Send Cleint delete message */
writer.Write(
new byte[]
{
0xDF, 0xDF, 0x00, 0x01, 0x00, 0x01, 0x00, 0x00, /* msg size - 2 byte */
0x00, 0x00, 0x00, 0x01, 0x00, 0x00, 0xff, 0xff, 0x00, 0x00, 0x00, 0x15 /* answer 0x15, char_id */
});
writer.Write(IPAddress.HostToNetworkOrder(charid));
writer.Flush();
stream.Capacity = (int)stream.Length;
byte[] reply = stream.GetBuffer();
writer.Close();
stream.Dispose();
/* insert size */
byte[] packetlength = BitConverter.GetBytes(reply.Length);
reply[7] = packetlength[0];
/* send response */
client.Send(reply);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
private Int32 CreateNewChar()
{
SqlWrapper ms = new SqlWrapper();
Int32 charID = 0;
switch (this.Breed)
{
case 0x1: /* solitus */
this.Abis = new int[6] { 6, 6, 6, 6, 6, 6 };
break;
case 0x2: /* opifex */
this.Abis = new int[6] { 3, 3, 10, 6, 6, 15 };
break;
case 0x3: /* nanomage */
this.Abis = new int[6] { 3, 10, 6, 15, 3, 3 };
break;
case 0x4: /* atrox */
this.Abis = new int[6] { 15, 3, 3, 3, 10, 6 };
break;
default:
Console.WriteLine("unknown breed: ", this.Breed);
break;
}
/*
* Note, all default values are not specified here as defaults are handled
* in the CharacterStats Class for us automatically. Also minimises SQL
* usage for default stats that are never changed from their default value
* ~NV
*/
ms.SqlDelete("DELETE FROM `characters_stats` WHERE ID=" + charID);
String sqlInsert = "INSERT INTO `characters` (`Username`,`Name`,`FirstName`,`LastName`,";
String sqlValues = "VALUES('" + this.AccountName + "','" + this.Name + "','','',";
sqlInsert += "`playfield`,`X`,`Y`,`Z`,`HeadingX`,`HeadingY`,`HeadingZ`,`HeadingW`)";
sqlValues += "0,0,0,0,0,0,0,0)";
sqlInsert += sqlValues;
try
{
ms.SqlInsert(sqlInsert);
}
catch (Exception e)
{
Console.WriteLine(sqlInsert + e.Message);
return 0;
}
try
{
/* select new char id */
string sqlQuery = "SELECT `ID` FROM `characters` WHERE Name = " + "'" + this.Name + "'";
DataTable dt = ms.ReadDatatable(sqlQuery);
foreach (DataRow row in dt.Rows)
{
charID = (Int32)row[0];
}
}
catch (Exception e)
{
ms.sqlclose();
Console.WriteLine(this.Name + e.Message);
return 0;
}
ms.SqlDelete("DELETE FROM `characters_stats` WHERE ID=" + charID);
sqlInsert = "INSERT INTO `characters_stats` (`ID`, `Stat`, `Value`) VALUES ";
// Flags / 0 (Player)
sqlInsert += "(" + charID + ", 0, " + 20 + "),";
// Level / 54
sqlInsert += "(" + charID + ", 54, " + 1 + "),";
// HeadMesh / 64
sqlInsert += "(" + charID + ", 64, " + this.HeadMesh + "),";
// MonsterScale / 360
sqlInsert += "(" + charID + ", 360, " + this.MonsterScale + "),";
// Sex / 59
sqlInsert += "(" + charID + ", 59, " + this.Gender + "),";
// VisualSex / 369
sqlInsert += "(" + charID + ", 369, " + this.Gender + "),";
// Breed / 4
sqlInsert += "(" + charID + ", 4, " + this.Breed + "),";
// VisualBreed / 367
sqlInsert += "(" + charID + ", 367, " + this.Breed + "),";
// Profession / 60
sqlInsert += "(" + charID + ", 60, " + this.Profession + "),";
// VisualProfession / 368
sqlInsert += "(" + charID + ", 368, " + this.Profession + "),";
// Fatness / 47
sqlInsert += "(" + charID + ", 47, " + this.Fatness + "),";
// Strength / 16
sqlInsert += "(" + charID + ", 16, " + this.Abis[0] + "),";
// Psychic / 21
sqlInsert += "(" + charID + ", 21, " + this.Abis[1] + "),";
// Sense / 20
sqlInsert += "(" + charID + ", 20, " + this.Abis[2] + "),";
// Intelligence / 19
sqlInsert += "(" + charID + ", 19, " + this.Abis[3] + "),";
// Stamina / 18
sqlInsert += "(" + charID + ", 18, " + this.Abis[4] + "),";
// Agility / 17
sqlInsert += "(" + charID + ", 17, " + this.Abis[5] + "),";
// Set HP and NP auf 1
sqlInsert += "(" + charID + ",1,1),";
sqlInsert += "(" + charID + ",214,1);";
ms.SqlInsert(sqlInsert);
return charID;
}
public void writeWeaponpairstoSQL()
{
SqlWrapper Sql = new SqlWrapper();
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "weaponpairs WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString() + ";");
int c;
for (c = 0; c < Weaponpairs.Count; c++)
{
Sql.SqlInsert("INSERT INTO " + getSQLTablefromDynelType() + "weaponpairs VALUES (" + ID.ToString() + "," + PlayField.ToString() + "," + Weaponpairs[c].value1.ToString() + "," + Weaponpairs[c].value2.ToString() + "," + Weaponpairs[c].value3.ToString() + "," + Weaponpairs[c].value4.ToString() + ");");
}
}
public void RemoveFromDB()
{
SqlWrapper Sql = new SqlWrapper();
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + " WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "inventory WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "activenanos WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "meshs WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "timers WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "waypoints WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "weaponpairs WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
Sql.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "_stats WHERE ID=" + ID.ToString() + " AND playfield=" + PlayField.ToString());
}
/// <summary>
/// Write bank contents to database
/// TODO: catch exceptions
/// </summary>
public void writeBankContentstoSQL()
{
SqlWrapper ms = new SqlWrapper();
ms.SqlDelete("DELETE FROM bank WHERE charID=" + ID.ToString());
foreach (AOItem temp in Bank)
{
string insert = "INSERT INTO bank VALUES(" + ID.ToString() + "," + temp.flags.ToString() + "," + temp.lowID.ToString() + "," + temp.highID.ToString() + "," + temp.multiplecount.ToString() + "," + temp.Quality.ToString() + "," + temp.Type.ToString() + "," + temp.Instance.ToString() + ",X'";
foreach (AOItemAttribute tempattr in temp.Stats)
{
insert = insert + reverseString(tempattr.Stat.ToString("X8")) + reverseString(tempattr.Stat.ToString("X8"));
}
insert = insert + "');";
ms.SqlInsert(insert);
}
}
/// <summary>
/// Write timers to database
/// TODO: catch exceptions
/// </summary>
public void WriteTimersToSql()
{
lock (this.timers)
{
SqlWrapper ms = new SqlWrapper();
int count;
// remove HP and NP tick
count = this.timers.Count;
while (count > 0)
{
count--;
if ((this.timers[count].Strain == 0) || (this.timers[count].Strain == 1))
{
this.timers.RemoveAt(count);
}
}
ms.SqlDelete("DELETE FROM " + this.GetSqlTablefromDynelType() + "timers WHERE ID=" + this.Id.ToString());
TimeSpan ts;
DateTime n = DateTime.Now;
for (count = 0; count < this.timers.Count; count++)
{
ts = this.timers[count].Timestamp - n;
ms.SqlInsert(
"INSERT INTO " + this.GetSqlTablefromDynelType() + "timers VALUES (" + this.Id.ToString() + ","
+ this.timers[count].Strain + "," + this.timers[count].Timestamp.Second.ToString() + ",X'"
+ this.timers[count].Function.Serialize() + "');");
}
}
}
/// <summary>
/// Write inventory to database
/// TODO: catch exceptions
/// </summary>
public void writeInventorytoSQL()
{
lock (Inventory)
{
SqlWrapper ms = new SqlWrapper();
int count;
ms.SqlDelete("DELETE FROM " + getSQLTablefromDynelType() + "inventory WHERE ID=" + ID.ToString() + " AND container=104;");
for (count = 0; count < Inventory.Count; count++)
{
if (Inventory[count].Container != -1) // dont save possible trade leftovers
{
ms.SqlInsert("INSERT INTO " + getSQLTablefromDynelType() + "inventory (ID,placement,flags,multiplecount,lowid,highid,quality,container) values (" + ID.ToString() + "," + Inventory[count].Placement.ToString() + ",1," + Inventory[count].Item.multiplecount.ToString() + "," + Inventory[count].Item.lowID.ToString() + "," + Inventory[count].Item.highID.ToString() + "," + Inventory[count].Item.Quality.ToString() + ",104);");
}
}
}
}
/// <summary>
/// Write waypoints to database
/// TODO: catch exceptions, replace the string formats with something more convenient
/// </summary>
public void writeWaypointstoSql()
{
SqlWrapper ms = new SqlWrapper();
int count;
ms.SqlDelete("DELETE FROM " + this.GetSqlTablefromDynelType() + "waypoints WHERE ID=" + this.Id.ToString());
for (count = 0; count < this.Waypoints.Count; count++)
{
ms.SqlInsert(
"INSERT INTO " + this.GetSqlTablefromDynelType() + "waypoints VALUES (" + this.Id.ToString() + ","
+ this.PlayField.ToString() + ","
+ String.Format(CultureInfo.InvariantCulture, "'{0}'", this.Waypoints[count].x) + ","
+ String.Format(CultureInfo.InvariantCulture, "'{0}'", this.Waypoints[count].y) + ","
+ String.Format(CultureInfo.InvariantCulture, "'{0}'", this.Waypoints[count].z) + ")");
}
if (this.Waypoints.Count > 0)
{
}
}