protected override void Execute()
{
SqlCommand sqcmd = new SqlCommand();
sqcmd.CommandType = CommandType.StoredProcedure;
sqcmd.CommandText = "WZ_GetShopInfo1";
if (!CallWOApi(sqcmd))
{
return;
}
// "SHO1"
byte[] itemHdr = new byte[4] {
83, 72, 79, 49
};
MemoryStream ms = new MemoryStream();
ms.Write(itemHdr, 0, 4);
// all items
while (reader.Read())
{
OutShopItem(ms);
}
ms.Write(itemHdr, 0, 4);
GResponse.Write("WO_0");
GResponse.BinaryWrite(ms.ToArray());
}
protected override void Execute()
{
SqlCommand sqcmd = new SqlCommand();
sqcmd.CommandType = CommandType.StoredProcedure;
sqcmd.CommandText = "WO_GetShopInfo5";
if (!CallWOApi(sqcmd))
{
return;
}
// "SHO3"
byte[] itemHdr = new byte[4] {
83, 72, 79, 51
};
MemoryStream ms = new MemoryStream();
ms.Write(itemHdr, 0, 4);
OutSkillPrices2(ms);
ms.Write(itemHdr, 0, 4);
// common items
reader.NextResult();
while (reader.Read())
{
OutShopItem(ms);
}
// packages - must be SAME as item for now
reader.NextResult();
while (reader.Read())
{
// package can be disabled
if (getInt("IsEnabled") == 0)
{
continue;
}
OutShopItem(ms);
}
ms.Write(itemHdr, 0, 4);
GResponse.Write("WO_0");
GResponse.BinaryWrite(ms.ToArray());
}