///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Special Transports / Unicorns etc
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
bool HandleSpecialTrans(int ItemID)
{
try
{
int model = Global.objectdata.GetItem(Data.ItemBase[ItemID].ObjectName);
if (this.Character.Information.Level < Data.ItemBase[ItemID].Level)
{
return(true);
}
{
model = Global.objectdata.GetItem(Data.ItemBase[ItemID].ObjectName);
if (model == 0)
{
return(true);
}
}
pet_obj o = new pet_obj();
o.Model = model;
o.Ids = new Global.ID(Global.ID.IDS.Object);
o.UniqueID = o.Ids.GetUniqueID;
o.x = Character.Position.x;
o.z = Character.Position.z;
o.y = Character.Position.y;
o.xSec = Character.Position.xSec;
o.ySec = Character.Position.ySec;
o.Hp = Data.ObjectBase[model].HP;
o.OwnerID = this.Character.Information.UniqueID;
this.Character.Transport.Right = true;
List <int> S = o.SpawnMe();
o.Information = true;
client.Send(Packet.Pet_Information(o.UniqueID, o.Model, o.Hp, Character.Information.CharacterID, o));
Send(S, Packet.Player_UpToHorse(this.Character.Information.UniqueID, true, o.UniqueID));
Systems.HelperObject.Add(o);
this.Character.Transport.Horse = o;
return(false);
}
catch (Exception ex)
{
Systems.Debugger.Write(ex);
}
return(false);
}
///////////////////////////////////////////////////////////////////////////
// Load grabpet
///////////////////////////////////////////////////////////////////////////
public void HandleGrabPet(byte slot, int ItemID)
{
try
{
//Checks before we continue (Level check).
if (!CheckItemLevel(Character.Information.Level, ItemID))
{
client.Send(Packet.MoveItemError(0x6C, 0x18));
}
//Else we continue
else
{
//Our database query for loading pet information.
MsSQL ms = new MsSQL("SELECT * FROM pets WHERE pet_itemid='" + ItemID + "' AND playerid='" + Character.Information.CharacterID + "'");
//Get detailed item information.
Global.slotItem item = GetItem((uint)Character.Information.CharacterID, slot, 0);
//Get item model information
int model = Global.objectdata.GetItem(Data.ItemBase[ItemID].ObjectName);
//Create new pet object
pet_obj o = new pet_obj();
//Our sql data reader
using (SqlDataReader reader = ms.Read())
{
//While our reader is open we read all info below.
while (reader.Read())
{
int itemid = reader.GetInt32(7);
Character.Grabpet.Grabpetid = item.dbID;
o.UniqueID = Character.Grabpet.Grabpetid;
o.Model = model;
o.Slots = reader.GetByte(8);
o.x = Character.Position.x + rnd.Next(1, 3);
o.z = Character.Position.z;
o.y = Character.Position.y + rnd.Next(1, 3);
o.xSec = Character.Position.xSec;
o.ySec = Character.Position.ySec;
o.OwnerID = Character.Information.CharacterID;
o.OwnerName = Character.Information.Name;
o.Walking = Character.Position.Walking;
o.Petname = reader.GetString(3);
o.Named = 2;
o.Run = Character.Speed.RunSpeed;
o.Walk = Character.Speed.WalkSpeed;
o.Zerk = Character.Speed.BerserkSpeed;
}
ms.Close();
}
//We set our pet active bool, so user cannot spawn multiple.
Character.Grabpet.Active = true;
o.Information = true;
//Set all details above to definitions
Character.Grabpet.Details = o;
//Global spawn the pet
Systems.HelperObject.Add(o);
//Spawn ourselfs
o.SpawnMe();
//Send then packet required (Pet information block).
client.Send(Packet.Pet_Information_grab(o, slot));
//Update pet status to active (For relog purposes).
MsSQL.UpdateData("UPDATE pets SET pet_active='1' WHERE pet_unique='" + Character.Grabpet.Grabpetid + "' AND playerid='" + Character.Information.CharacterID + "'");
}
}
catch (Exception ex)
{
Console.WriteLine("Grab pet spawn error : " + ex);
}
}
void HandleAttackPet(byte slot, int ItemID)
{
try
{
//Check if player level is high enough to spawn.
if (!CheckItemLevel(Character.Information.Level, ItemID))
{
client.Send(Packet.MoveItemError(0x6C, 0x18));
}
//If ok we continue to spawn the attack pet.
else
{
//Our sql query
MsSQL ms = new MsSQL("SELECT * FROM pets WHERE pet_itemid='" + ItemID + "' AND playerid='" + Character.Information.CharacterID + "'");
//Create new pet object.
pet_obj o = new pet_obj();
//Open our data reader
using (SqlDataReader reader = ms.Read())
{
//Start reading data from the query above.
while (reader.Read())
{
Character.Attackpet.Uniqueid = reader.GetInt32(11);
Character.Attackpet.Spawned = true;
o.UniqueID = Character.Attackpet.Uniqueid;
o.Model = Global.objectdata.GetItem(Data.ItemBase[ItemID].ObjectName); o.Level = reader.GetByte(13);
o.exp = reader.GetInt64(14);
o.x = Character.Position.x + rnd.Next(1, 3);
o.z = Character.Position.z;
o.y = Character.Position.y + rnd.Next(1, 3);
o.xSec = Character.Position.xSec;
o.ySec = Character.Position.ySec;
o.OwnerID = Character.Information.CharacterID;
o.OwnerName = Character.Information.Name;
o.Walking = Character.Position.Walking;
o.Petname = reader.GetString(3);
o.Named = 3;
o.Run = Character.Speed.RunSpeed;
o.Walk = Character.Speed.WalkSpeed;
o.Zerk = Character.Speed.BerserkSpeed;
}
ms.Close();
}
//We set our pet active bool, so user cannot spawn multiple.
Character.Attackpet.Active = true;
o.Information = true;
//Set all details above to definitions
Character.Attackpet.Details = o;
//Global spawn the pet
Systems.HelperObject.Add(o);
//Spawn ourselfs
o.SpawnMe();
//Send then packet required (Pet information block).
client.Send(Packet.AttackPetStats(o, slot));
client.Send(Packet.AttackPetHGP(o));
//Update pet status to active (For relog purposes).
MsSQL.UpdateData("UPDATE pets SET pet_active='1' WHERE pet_unique='" + Character.Grabpet.Grabpetid + "' AND playerid='" + Character.Information.CharacterID + "'");
}
}
catch (Exception ex)
{
Console.WriteLine("Attack pet spawn error : " + ex);
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Normal Transport
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
bool HandleHorseScroll(int ItemID)
{
try
{
int model = Global.objectdata.GetItem(Data.ItemBase[ItemID].ObjectName);
if (model == 0)
{
string extrapath = null;
if (this.Character.Information.Level >= 1 && this.Character.Information.Level <= 5)
{
extrapath = "_5";
}
else if (this.Character.Information.Level >= 6 && this.Character.Information.Level <= 10)
{
extrapath = "_10";
}
else if (this.Character.Information.Level >= 11 && this.Character.Information.Level <= 20)
{
extrapath = "_20";
}
else if (this.Character.Information.Level >= 21 && this.Character.Information.Level <= 30)
{
extrapath = "_30";
}
else if (this.Character.Information.Level >= 31 && this.Character.Information.Level <= 45)
{
extrapath = "_45";
}
else if (this.Character.Information.Level >= 46 && this.Character.Information.Level <= 60)
{
extrapath = "_60";
}
else if (this.Character.Information.Level >= 61 && this.Character.Information.Level <= 75)
{
extrapath = "_75";
}
else if (this.Character.Information.Level >= 76 && this.Character.Information.Level <= 90)
{
extrapath = "_90";
}
else if (this.Character.Information.Level >= 91 && this.Character.Information.Level <= 105)
{
extrapath = "_105";
}
else if (this.Character.Information.Level >= 106 && this.Character.Information.Level <= 120)
{
extrapath = "_120";
}
model = Global.objectdata.GetItem(Data.ItemBase[ItemID].ObjectName + extrapath);
if (model == 0)
{
return(true);
}
}
pet_obj o = new pet_obj();
o.Model = model;
o.Ids = new Global.ID(Global.ID.IDS.Object);
o.UniqueID = o.Ids.GetUniqueID;
o.x = Character.Position.x;
o.z = Character.Position.z;
o.y = Character.Position.y;
o.xSec = Character.Position.xSec;
o.ySec = Character.Position.ySec;
o.Hp = Data.ObjectBase[model].HP;
o.OwnerID = this.Character.Information.UniqueID;
o.Speed1 = Data.ObjectBase[model].Speed1;
o.Speed2 = Data.ObjectBase[model].Speed2;
this.Character.Transport.Right = true;
List <int> S = o.SpawnMe();
o.Information = true;
client.Send(Packet.Pet_Information(o.UniqueID, o.Model, o.Hp, Character.Information.CharacterID, o));
Send(Packet.SetSpeed(o.UniqueID, o.Speed1, o.Speed2)); //Global Speed Update
Send(Packet.ChangeStatus(o.UniqueID, 3, 0)); // Global Status
Send(S, Packet.Player_UpToHorse(this.Character.Information.UniqueID, true, o.UniqueID));
Systems.HelperObject.Add(o);
this.Character.Transport.Horse = o;
return(false);
}
catch (Exception ex)
{
Systems.Debugger.Write(ex);
}
return(false);
}
/////////////////////////////////////////////////////////////////////////////////
// Load grabpet if active state
/////////////////////////////////////////////////////////////////////////////////
#region Grab pet loading
void LoadGrabPet()
{
//Wrap our function inside a catcher
try
{
//Query check
MsSQL ms = new MsSQL("SELECT * FROM pets WHERE playerid='" + Character.Information.CharacterID + "' AND pet_active='1'");
//Get active pet count
int checkactive = ms.Count();
//If the player has an active grabpet
if (checkactive > 0)
{
//Set new pet object
pet_obj o = new pet_obj();
//Create new data reader for mssql
using (SqlDataReader reader = ms.Read())
{
//While the sql data reader is reading
while (reader.Read())
{
//Get pet location inside the player inventory
string slot = reader.GetString(12);
//Check our slot inside the database
int slotcheck = MsSQL.GetDataInt("SELECT * FROM char_items WHERE itemnumber='" + slot + "' AND owner='" + Character.Information.CharacterID + "' AND storagetype='0'", "slot");
//Set slot item information (item).
Global.slotItem item = GetItem((uint)Character.Information.CharacterID, Convert.ToByte(slotcheck), 0);
//Set model information of the pet
int model = Global.objectdata.GetItem(Data.ItemBase[item.ID].ObjectName);
//Set id for the pet (First database value is always unique).
Character.Grabpet.Grabpetid = item.dbID;
//Set unique id
o.UniqueID = Character.Grabpet.Grabpetid;
//Pet object model
o.Model = model;
//Spawning location of the pet
o.x = Character.Position.x + rnd.Next(1, 3);
o.z = Character.Position.z;
o.y = Character.Position.y + rnd.Next(1, 3);
o.xSec = Character.Position.xSec;
o.ySec = Character.Position.ySec;
//Owner id information
o.OwnerID = Character.Information.CharacterID;
//Owner name information
o.OwnerName = Character.Information.Name;
//Set walking state
o.Walking = Character.Position.Walking;
//Set petname
o.Petname = reader.GetString(3);
//Set our switch case
o.Named = 2;
//Set speed of pet (Need to check speed on official).
o.Run = Character.Speed.RunSpeed - 3;
o.Walk = Character.Speed.WalkSpeed - 3;
o.Zerk = Character.Speed.BerserkSpeed - 3;
//Set grabpet as active so there cant be double spawns
Character.Grabpet.Active = true;
//Set object information to true
o.Information = true;
//Spawn the pet
Systems.HelperObject.Add(o);
//Set global information for the pet
Character.Grabpet.Details = o;
//Send the visual packet for details of the pet management
client.Send(Packet.Pet_Information_grab(o, Convert.ToByte(slotcheck)));
//Spawn
o.SpawnMe();
//Update state into database
MsSQL.UpdateData("UPDATE pets SET pet_active='1' WHERE pet_unique='" + Character.Grabpet.Grabpetid + "' AND playerid='" + Character.Information.CharacterID + "'");
}
//Close sql reader
ms.Close();
}
//Set state
Character.Grabpet.Active = true;
}
}
catch (Exception ex)
{
Console.WriteLine("Grab pet player load error {0}", ex);
Systems.Debugger.Write(ex);
}
}
/////////////////////////////////////////////////////////////////////////////////
// Load grabpet if active state
/////////////////////////////////////////////////////////////////////////////////
void LoadGrabPet()
{
try
{
#region Grab pet loading
//Query check
MsSQL ms = new MsSQL("SELECT * FROM pets WHERE playerid='" + Character.Information.CharacterID + "' AND pet_active='1'");
//Get active pet count
int checkactive = ms.Count();
//If 1 pet is active then..
if (checkactive > 0)
{
//Spawn our pet
pet_obj o = new pet_obj();
using (SqlDataReader reader = ms.Read())
{
while (reader.Read())
{
//Get slot of pet from inventory 12
string slot = reader.GetString(12);
int slotcheck = MsSQL.GetDataInt("SELECT * FROM char_items WHERE itemnumber='" + slot + "' AND owner='" + Character.Information.CharacterID + "' AND storagetype='0'", "slot");
Global.slotItem item = GetItem((uint)Character.Information.CharacterID, Convert.ToByte(slotcheck), 0);
int model = Global.objectdata.GetItem(Data.ItemBase[item.ID].ObjectName);
int itemid = reader.GetInt32(7);
Character.Grabpet.Grabpetid = item.dbID;
o.UniqueID = Character.Grabpet.Grabpetid;
o.Model = model;
o.x = Character.Position.x + rnd.Next(1, 3);
o.z = Character.Position.z;
o.y = Character.Position.y + rnd.Next(1, 3);
o.xSec = Character.Position.xSec;
o.ySec = Character.Position.ySec;
o.OwnerID = Character.Information.CharacterID;
o.OwnerName = Character.Information.Name;
o.Walking = Character.Position.Walking;
o.Petname = reader.GetString(3);
o.Named = 2;
o.Run = Character.Speed.RunSpeed;
o.Walk = Character.Speed.WalkSpeed;
o.Zerk = Character.Speed.BerserkSpeed;
Character.Grabpet.Active = true;
List<int> S = Character.Spawn;
o.Information = true;
Systems.HelperObject.Add(o);
Character.Grabpet.Details = o;
client.Send(Packet.Pet_Information_grab(o, Convert.ToByte(slotcheck)));
o.SpawnMe();
MsSQL.UpdateData("UPDATE pets SET pet_active='1' WHERE pet_unique='" + Character.Grabpet.Grabpetid + "' AND playerid='" + Character.Information.CharacterID + "'");
}
ms.Close();
}
//Set state
Character.Grabpet.Active = true;
}
#endregion
}
catch (Exception ex)
{
Console.WriteLine("Grab pet player load error {0}", ex);
deBug.Write(ex);
}
}
