public override void ExecuteCommand(Client client, Identity target, string[] args)
{
Client targetClient = null;
if ((targetClient = FindClient.FindClientByName(args[1])) != null)
{
int firstfree = 64;
firstfree = targetClient.Character.GetNextFreeInventory(104);
if (firstfree <= 93)
{
InventoryEntries mi = new InventoryEntries();
AOItem it = ItemHandler.GetItemTemplate(Convert.ToInt32(args[2]));
mi.Placement = firstfree;
mi.Container = 104;
mi.Item.LowID = Convert.ToInt32(args[2]);
mi.Item.HighID = Convert.ToInt32(args[3]);
mi.Item.Quality = Convert.ToInt32(args[4]);
if (it.ItemType != 1)
{
mi.Item.MultipleCount = Math.Max(1, it.getItemAttribute(212));
}
else
{
bool found = false;
foreach (AOItemAttribute a in mi.Item.Stats)
{
if (a.Stat != 212)
{
continue;
}
found = true;
a.Value = Math.Max(1, it.getItemAttribute(212));
break;
}
if (!found)
{
AOItemAttribute aoi = new AOItemAttribute();
aoi.Stat = 212;
aoi.Value = Math.Max(1, it.getItemAttribute(212));
mi.Item.Stats.Add(aoi);
}
}
targetClient.Character.Inventory.Add(mi);
AddTemplate.Send(targetClient, mi);
}
else
{
client.SendChatText("Your Inventory is full");
}
}
}
public static void Convertitems()
{
SqlWrapper sql = new SqlWrapper();
DataTable dt_items = sql.ReadDatatable("SELECT * FROM Items order by aoid asc");
Stream sf = new FileStream("items.dat", FileMode.Create);
ZOutputStream ds = new ZOutputStream(sf, zlibConst.Z_BEST_COMPRESSION);
MemoryStream sm = new MemoryStream();
//DeflateStream sm = new DeflateStream(sf, CompressionMode.Compress);
BinaryFormatter bf = new BinaryFormatter();
Console.WriteLine("Processing data... This will take a while!");
List<AOItem> ITEMS = new List<AOItem>();
int count = dt_items.Rows.Count;
int oldperc = 0;
int countall = 0;
byte[] buffer = BitConverter.GetBytes(maxnum);
sm.Write(buffer, 0, buffer.Length);
if (File.Exists("items2.dat"))
{
ItemHandler.CacheAllItems("items2.dat");
foreach (AOItem aoi in ItemHandler.ItemList)
{
ITEMS.Add(aoi);
if (ITEMS.Count == maxnum)
{
bf.Serialize(sm, ITEMS);
sm.Flush();
ITEMS.Clear();
countall += maxnum;
}
}
}
else
{
foreach (DataRow itemrow in dt_items.Rows)
{
AOItem _item = new AOItem();
_item.LowID = (Int32)itemrow[0];
_item.HighID = (Int32)itemrow[0];
_item.Quality = (Int32)itemrow[2];
_item.ItemType = (Int32)itemrow[3];
DataTable dt_itemevents = sql.ReadDatatable("SELECT * FROM item_events WHERE itemid=" + _item.LowID + " ORDER BY eventid asc");
foreach (DataRow eventrow in dt_itemevents.Rows)
{
AOEvents aoe = new AOEvents();
aoe.EventType = (Int32)eventrow[2];
int eventid = (Int32)eventrow["eventid"];
DataTable dt_itemeventfunctions = sql.ReadDatatable("SELECT * FROM item_functions WHERE itemid=" + _item.LowID + " AND eventid=" + eventid + " ORDER BY functionid asc");
foreach (DataRow eventfunctionrow in dt_itemeventfunctions.Rows)
{
int eventfuncid = (Int32)eventfunctionrow["functionid"];
AOFunctions aof = new AOFunctions();
aof.FunctionType = (Int32)eventfunctionrow[3];
aof.Target = (Int32)eventfunctionrow[4];
aof.TickCount = (Int32)eventfunctionrow[5];
aof.TickInterval = (uint)(Int32)eventfunctionrow[6];
DataTable functionargs = sql.ReadDatatable("SELECT * FROM item_function_arguments WHERE functionid=" + eventfuncid + " AND eventid=" + eventid + " AND itemid=" + _item.LowID + " ORDER BY attrid asc");
foreach (DataRow attrs in functionargs.Rows)
{
if (!(attrs["argvalint"] is DBNull))
{
aof.Arguments.Add((Int32)attrs["argvalint"]);
}
else
if (!(attrs["argvalsingle"] is DBNull))
{
aof.Arguments.Add((Single)(float)attrs["argvalsingle"]);
}
else
if (!(attrs["argvalstring"] is DBNull))
{
string s = attrs["argvalstring"].ToString();
aof.Arguments.Add(s);
}
else
throw (new NotSupportedException("No Argument value given, all NULL: " + _item.LowID));
}
DataTable reqs = sql.ReadDatatable("SELECT * from item_function_reqs WHERE functionid=" + eventfuncid + " AND eventid=" + eventid + " AND itemid=" + _item.LowID + " ORDER BY reqid asc");
foreach (DataRow rrow in reqs.Rows)
{
AORequirements aor = new AORequirements();
aor.Statnumber = (Int32)rrow["attrnum"];
aor.Value = (Int32)rrow["attrval"];
aor.Target = (Int32)rrow["target"];
aor.Operator = (Int32)rrow["operator"];
aor.ChildOperator = (Int32)rrow["child_op"];
aof.Requirements.Add(aor);
}
aoe.Functions.Add(aof);
}
_item.Events.Add(aoe);
}
DataTable dt_actions = sql.ReadDatatable("SELECT * FROM item_actions WHERE itemid=" + _item.LowID);
foreach (DataRow acrow in dt_actions.Rows)
{
AOActions aoa = new AOActions();
aoa.ActionType = (Int32)acrow["actionnum"];
DataTable reqs = sql.ReadDatatable("SELECT * FROM item_action_reqs WHERE itemid=" + _item.LowID + " AND actionid=" + ((Int32)acrow["actionid"]) + " ORDER BY reqid ASC");
foreach (DataRow rrow in reqs.Rows)
{
AORequirements aor = new AORequirements();
aor.Statnumber = (Int32)rrow["attrnum"];
aor.Value = (Int32)rrow["attrval"];
aor.Target = (Int32)rrow["target"];
aor.Operator = (Int32)rrow["operator"];
aor.ChildOperator = (Int32)rrow["child_op"];
aoa.Requirements.Add(aor);
}
_item.Actions.Add(aoa);
}
DataTable dtdef = sql.ReadDatatable("SELECT * FROM item_defense_attributes where itemid=" + _item.LowID + " ORDER BY defenseid asc");
foreach (DataRow defrow in dtdef.Rows)
{
AOItemAttribute aoia = new AOItemAttribute();
aoia.Stat = (Int32)defrow["num"];
aoia.Value = (Int32)defrow["value"];
_item.Defend.Add(aoia);
}
DataTable dtatt = sql.ReadDatatable("select * FROM item_attack_attributes where itemid=" + _item.LowID + " ORDER BY attackid asc");
foreach (DataRow defrow in dtatt.Rows)
{
AOItemAttribute aoia = new AOItemAttribute();
aoia.Stat = (Int32)defrow["num"];
aoia.Value = (Int32)defrow["value"];
_item.Defend.Add(aoia);
}
DataTable attributes = sql.ReadDatatable("SELECT * FROM item_attributes WHERE itemid=" + _item.LowID + " ORDER BY attributeid asc");
foreach (DataRow atrow in attributes.Rows)
{
AOItemAttribute aoia = new AOItemAttribute();
aoia.Stat = (Int32)atrow["num"];
aoia.Value = (Int32)atrow["value"];
_item.Stats.Add(aoia);
}
ITEMS.Add(_item);
int perc = Convert.ToInt32(Math.Floor((double)(ITEMS.Count + countall) / count * 100.0));
if (perc != oldperc)
{
Console.Write("\rDone " + perc.ToString().PadLeft(3) + "%");
oldperc = perc;
}
if (ITEMS.Count == maxnum)
{
bf.Serialize(sm, ITEMS);
sm.Flush();
ITEMS.Clear();
countall += maxnum;
}
}
}
bf.Serialize(sm, ITEMS);
sm.Seek(0, SeekOrigin.Begin);
Console.WriteLine();
CopyStream(sm, ds);
sm.Close();
ds.Close();
}
/// Methods to do:
/// Read Item
/// Write Item
/// Return Dynel Item (placing on the ground)
public AONanos ShallowCopy()
{
AONanos it = new AONanos();
it.ID = ID;
foreach (AOItemAttribute ai in Attack)
{
AOItemAttribute z = new AOItemAttribute();
z.Stat = ai.Stat;
z.Value = ai.Value;
it.Attack.Add(z);
}
foreach (AOItemAttribute ai in Defend)
{
AOItemAttribute z = new AOItemAttribute();
z.Stat = ai.Stat;
z.Value = ai.Value;
it.Defend.Add(z);
}
foreach (AOItemAttribute ai in Stats)
{
AOItemAttribute z = new AOItemAttribute();
z.Stat = ai.Stat;
z.Value = ai.Value;
it.Stats.Add(z);
}
foreach (AOEvents ev in Events)
{
AOEvents newEV = new AOEvents();
foreach (AOFunctions aof in ev.Functions)
{
AOFunctions newAOF = new AOFunctions();
foreach (AORequirements aor in aof.Requirements)
{
AORequirements newAOR = new AORequirements();
newAOR.ChildOperator = aor.ChildOperator;
newAOR.Operator = aor.Operator;
newAOR.Statnumber = aor.Statnumber;
newAOR.Target = aor.Target;
newAOR.Value = aor.Value;
newAOF.Requirements.Add(newAOR);
}
foreach (object ob in aof.Arguments.Values)
{
if (ob.GetType() == typeof(string))
{
string z = (string)ob;
newAOF.Arguments.Values.Add(z);
}
if (ob.GetType() == typeof(int))
{
int i = (int)ob;
newAOF.Arguments.Values.Add(i);
}
if (ob.GetType() == typeof(Single))
{
Single s = (Single)ob;
newAOF.Arguments.Values.Add(s);
}
}
newAOF.dolocalstats = aof.dolocalstats;
newAOF.FunctionType = aof.FunctionType;
newAOF.Target = aof.Target;
newAOF.TickCount = aof.TickCount;
newAOF.TickInterval = aof.TickInterval;
newEV.Functions.Add(newAOF);
}
newEV.EventType = ev.EventType;
it.Events.Add(newEV);
}
it.flags = flags;
it.Instance = Instance;
it.ItemType = ItemType;
it.NCUCost = NCUCost;
return(it);
}
/// Methods to do:
/// Read Item
/// Write Item
/// Return Dynel Item (placing on the ground)
public AOItem ShallowCopy()
{
AOItem it = new AOItem();
it.LowID = this.LowID;
it.HighID = this.HighID;
foreach (AOItemAttribute ai in Attack)
{
AOItemAttribute z = new AOItemAttribute();
z.Stat = ai.Stat;
z.Value = ai.Value;
it.Attack.Add(z);
}
foreach (AOItemAttribute ai in Defend)
{
AOItemAttribute z = new AOItemAttribute();
z.Stat = ai.Stat;
z.Value = ai.Value;
it.Defend.Add(z);
}
foreach (AOItemAttribute ai in Stats)
{
AOItemAttribute z = new AOItemAttribute();
z.Stat = ai.Stat;
z.Value = ai.Value;
it.Stats.Add(z);
}
foreach (AOEvents ev in Events)
{
AOEvents newEV = new AOEvents();
foreach (AOFunctions aof in ev.Functions)
{
AOFunctions newAOF = new AOFunctions();
foreach (AORequirements aor in aof.Requirements)
{
AORequirements newAOR = new AORequirements();
newAOR.ChildOperator = aor.ChildOperator;
newAOR.Operator = aor.Operator;
newAOR.Statnumber = aor.Statnumber;
newAOR.Target = aor.Target;
newAOR.Value = aor.Value;
newAOF.Requirements.Add(newAOR);
}
foreach (object ob in aof.Arguments)
{
if (ob.GetType() == typeof (string))
{
string z = (string) ob;
newAOF.Arguments.Add(z);
}
if (ob.GetType() == typeof (int))
{
int i = (int) ob;
newAOF.Arguments.Add(i);
}
if (ob.GetType() == typeof (Single))
{
Single s = (Single) ob;
newAOF.Arguments.Add(s);
}
}
newAOF.dolocalstats = aof.dolocalstats;
newAOF.FunctionType = aof.FunctionType;
newAOF.Target = aof.Target;
newAOF.TickCount = aof.TickCount;
newAOF.TickInterval = aof.TickInterval;
newEV.Functions.Add(newAOF);
}
newEV.EventType = ev.EventType;
it.Events.Add(newEV);
}
it.Flags = this.Flags;
it.Instance = Instance;
it.ItemType = ItemType;
it.MultipleCount = this.MultipleCount;
it.Nothing = Nothing;
it.Quality = Quality;
return it;
}
public static List<AOItem> GetLoot(NonPlayerCharacterClass npc)
{
List<AOItem> drops = new List<AOItem>();
int minql = (int)Math.Ceiling(npc.Stats.Level.Value - 0.2 * npc.Stats.Level.Value);
int maxql = (int)Math.Floor(npc.Stats.Level.Value + 0.2 * npc.Stats.Level.Value);
var lootinfo =
new SqlWrapper().ReadDatatable(
"SELECT drophashes, dropslots, droppercents FROM mobtemplate WHERE hash = " + npc.Hash + ";").Rows;
int numberOfSlots = 0;
string[] hashes = lootinfo[0][0].ToString().ToLower().Split(',');
string[] slots = lootinfo[0][1].ToString().ToLower().Split(',');
string[] percents = lootinfo[0][2].ToString().ToLower().Split(',');
if (!hashes.Any())
{
return null;
}
if (hashes[0] == string.Empty)
{
return null;
}
foreach (string s in slots)
{
numberOfSlots = Math.Max(numberOfSlots, Convert.ToInt32(s.Trim()));
}
List<PartialSlot> list = new List<PartialSlot>();
for (int hashNumber = 0; hashNumber < hashes.Count(); ++hashNumber)
{
list.Add(
new PartialSlot(hashes[hashNumber].Trim(), slots[hashNumber].Trim(), percents[hashNumber].Trim()));
}
for (int slotNumber = 1; slotNumber <= numberOfSlots; ++slotNumber)
{
var fullSlot = list.Where(match => match.Slot == slotNumber).Select(match => match);
Random rand = new Random();
double num = rand.NextDouble();
double chance = 0;
foreach (PartialSlot slot in fullSlot)
{
chance = chance + (slot.Chance / (double)10000);
if (num <= chance)
{
List<LootItem> union = new List<LootItem>();
foreach (string hash in slot.HashList)
{
var matches =
FullDropList.Where(
match =>
((match.MinQL <= minql && match.MaxQL >= maxql)
|| (match.MinQL < maxql && match.MaxQL >= maxql)
|| (match.MinQL <= minql && match.MaxQL > minql)
|| (match.MinQL >= minql && match.MaxQL <= maxql) || !match.RangeCheck)
&& match.Hash == hash).Select(match => match);
foreach (LootItem li in matches)
{
if (
!union.Exists(
duplicate => duplicate.HighId == li.HighId && duplicate.MaxQL == li.MaxQL))
{
union.Add(li);
}
}
}
int ql = rand.Next(minql - 1, maxql + 1);
if (union.Any())
{
int select = rand.Next(-1, union.Count());
AOItem item = ItemHandler.interpolate(
union.ElementAt(@select).LowId, union.ElementAt(@select).HighId, ql);
if (item.ItemType != 1)
{
item.MultipleCount = Math.Max(1, item.getItemAttribute(212));
}
else
{
bool found = false;
foreach (AOItemAttribute a in item.Stats)
{
if (a.Stat != 212)
{
continue;
}
found = true;
a.Value = Math.Max(1, item.getItemAttribute(212));
break;
}
if (!found)
{
AOItemAttribute aoi = new AOItemAttribute
{ Stat = 212, Value = Math.Max(1, item.getItemAttribute(212)) };
item.Stats.Add(aoi);
}
}
drops.Add(item);
break;
}
}
}
}
return drops;
}
