Then just loop them all with the Method of zBot , otherwise rewrite it du avoid the errorsQuote:
i did but its not working i need to make it generic for all servers and because some server has custom npc so i need to find a way to extract the content and the shop type
Quote:
GGWP; You just wasted a lot of time.Quote:
in zbot there is no alex npc in the parse and also you made other npc static
so what if the client have custom npc names how would I auto buy pots for example
thats why I need to make it generic
Quote:
However, if you do find a better way to do this, go ahead and post it.
This is strictly speaking only for Type 8 @ 0xB034, since the rest is entirely different.
All those people making alchemy bots etc.. this is highly useful for you :p
EDIT: For shit like this:
First create this function
PHP Code:CREATE FUNCTION _getTabIndex(@NPCID INT, @TabCodename VARCHAR(128))
RETURNS INT
AS
BEGIN
DECLARE @Index INT;
SELECT @Index = tabindex
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY tab.RefTabGroupCodeName ASC, tab.ID ASC)-1 tabindex, tab.CodeName128
FROM _RefShopTab tab
JOIN _RefMappingShopWithTab maptab ON tab.RefTabGroupCodeName = maptab.RefTabGroupCodeName
JOIN _RefShop shop ON maptab.RefShopCodeName = shop.CodeName128
JOIN _RefMappingShopGroup mapshop ON shop.CodeName128 = mapshop.RefShopCodeName
JOIN _RefShopGroup shopgroup ON mapshop.RefShopGroupCodeName = shopgroup.CodeName128
JOIN _Refobjcommon R ON shopgroup.RefNPCCodeName = R.CodeName128
WHERE R.ID = @NPCID
) q
WHERE q.CodeName128 = @TabCodename
RETURN @Index
END
Then run this and create your npcshoplist. You need to parse NPCs via single/groupspawn beforehand though, otherwise you cant get the NPC ID.
PHP Code:
SELECT npc.ID as NPCID,.dbo._getTabIndex(npc.ID,goods.RefTabCodeName) TabID, Item.id as ItemID, goods.SlotIndex ,scrap.Data
FROM _RefShopGoods goods
JOIN _RefShopTab tab ON goods.RefTabCodeName = tab.CodeName128
JOIN _RefMappingShopWithTab maptab ON tab.RefTabGroupCodeName = maptab.RefTabGroupCodeName
JOIN _RefShop shop ON maptab.RefShopCodeName = shop.CodeName128
JOIN _RefMappingShopGroup mapgroup ON shop.CodeName128 = mapgroup.RefShopCodeName
JOIN _RefShopGroup shopgroup ON mapgroup.RefShopGroupCodeName = shopgroup.CodeName128
JOIN _Refobjcommon npc ON shopgroup.RefNPCCodeName = npc.CodeName128
JOIN _RefPackageItem package ON goods.RefPackageItemCodeName = package.CodeName128
JOIN _RefScrapOfPackageItem scrap ON package.CodeName128 = scrap.RefPackageItemCodeName
JOIN _Refobjcommon item ON scrap.RefItemCodeName = item.CodeName128
WHERE npc.ID = 2073
ORDER BY tab.RefTabGroupCodeName ASC, tab.ID ASC
public static int ParseNPC(object opacket, object xresult, bool groupspawn)
{
Packet packet = (Packet)opacket;
SpawnData result = (SpawnData)xresult;
int startpos = (int)packet.data.pointer - 4;
//try
//{
result.UniqueId = packet.data.ReadDWORD();
result.xSec = packet.data.ReadBYTE();
result.ySec = packet.data.ReadBYTE();
result.X = packet.data.ReadSINGLE();
result.Z = packet.data.ReadSINGLE();
result.Y = packet.data.ReadSINGLE();
packet.data.ReadWORD(); //angle
result.XCoord = Functions.GetXCoord((int)result.X, result.xSec);
result.YCoord = Functions.GetYCoord((int)result.Y, result.ySec);
result.distance = Functions.CalcDistance(result.XCoord, result.YCoord);
byte haveDest = packet.data.ReadBYTE();
byte movingType = packet.data.ReadBYTE();
if (haveDest == 0x01)
{
result.DestXSec = packet.data.ReadBYTE();
result.DestYSec = packet.data.ReadBYTE();
if (result.DestYSec == 0x80)
{
packet.data.ReadSignedDWORD();
packet.data.ReadSignedDWORD();
packet.data.ReadSignedDWORD();
}
else
{
result.DestX = packet.data.ReadSignedWORD();
result.DestZ = packet.data.ReadSignedWORD();
result.DestY = packet.data.ReadSignedWORD();
}
}
else
{
packet.data.ReadBYTE();
packet.data.ReadWORD();
}
result.DeathFlag = packet.data.ReadBYTE();
packet.data.ReadBYTE(); //movement flag
packet.data.ReadBYTE(); //berserk gauge
packet.data.ReadBYTE(12); //walk speeds
byte skillcount = packet.data.ReadBYTE();
for (int s = 0; s < skillcount; s++)
{
uint skillid = Functions.ReverseNumber(packet.data.ReadDWORD()); // ID
packet.data.ReadDWORD(); // SKILL UNIQUE ID
foreach (SkillData sd in Main.Skills)
{
if (sd.ID == skillid)
{
if (Functions.extraByte(sd.pk2name) == true)
packet.data.ReadBYTE();
break;
}
}
}
byte action = packet.data.ReadBYTE();
if (action == 2)
packet.data.ReadDWORD();
else if (action != 0x00)
packet.data.ReadBYTE(packet.data.ReadBYTE());
Main.UpdateSpawns(result, true);
//}
//catch
//{
// string packetasstring = "S->C(" + packet.Opc.ToString("X4") + ") ";
// foreach (byte b in packet.ToByteArray())
// {
// packetasstring += b.ToString("X2");
// }
// System.IO.File.AppendAllText(System.Environment.CurrentDirectory + "\\err_npc.txt", packetasstring + "\r\n" + "Pos:" + packet.data.pointer.ToString() + " LEN:" + packet.data.len.ToString() + " START POS:" + startpos.ToString() + " MODEL:" + result.model.ToString("X8") + "\r\n");
//}
return packet.data.pointer;
}