Problem With 2.71 Admin?

[mByte]

I was fiddling around making items and logged into to try them out.

Keep getting that your class, race and or diety cannot use this item messege

funnything is I checked all the class's and races when that did not work I check all dieties too.

No Go.

[Windcatcher]

Grrr this is getting frustrating. There must be some field in the item structure that's still unknown that's affecting it. If we knew the location of the field that sets the player's deity it would be a big help too. Is there anyone else (dev or otherwise) who might be able to help track down these unknown fields? When I test the tool I usually put up a label and fill it with hex dumps of everything still marked as unknown, but so far I haven't been able to make heads or tails of anything else.

WC

[mByte]

Well see if you can use any of this information it's what I use for my web based item editor.

Note the code is php but is has most of the offsets.

*************************************************
//Common Information
$itemname = GetNulLTermString(substr($row[0],0,64));
$itemlore = GetNulLTermString(substr($row[0],64,80));
// * - lore item
// ~ - pending lore
// # - artifact
// & - summoned
$itemVisual = GetNulLTermString(substr($row[0],144,16));
$itemWeight = hexdec(bin2hex(substr($row[0],174,1)));
$itemNoRent = hexdec(bin2hex(substr($row[0],175,1)));
$itemNoDrop = hexdec(bin2hex(substr($row[0],176,1)));
$itemSize = hexdec(bin2hex(substr($row[0],177,1)));
$itemTypeFlag = hexdec(bin2hex(substr($row[0],178,1)));
// 0 - Generic
// 1 - Contaner
// 2 - Book
$itemNuma = bin2hex(substr($row[0],180,1));
$itemNumb = bin2hex(substr($row[0],181,1));
$itemNum = hexdec($itemNumb . $itemNuma);
$itemIcona = hexdec(bin2hex(substr($row[0],182,1)));
$itemIconb = hexdec(bin2hex(substr($row[0],183,2)));
$itemIcon = $itemIcona + $itemIconb;
$itemPSlot = hexdec(bin2hex(substr($row[0],184,1)));
$itemSlotsa = hexdec(bin2hex(substr($row[0],188,1)));
$itemSlotsb = hexdec(bin2hex(substr($row[0],189,2)));
$itemSlotsc = hexdec(bin2hex(substr($row[0],190,2))) * 256 - $itemSlotsb;
if($itemSlotsc <= -1){
$itemSlotsc = 0;
}
$itemSlots = $itemSlotsa + $itemSlotsb + $itemSlotsc;
$itemCost = hexdec(bin2hex(substr($row[0],192,1)));
$itemID = "0"; //hexdec(bin2hex(substr($row[0],212,1))); // somthing about the zone

//General Item Information
$itemSTR = hexdec(bin2hex(substr($row[0],228,1)));
$itemSTA = hexdec(bin2hex(substr($row[0],229,1)));
$itemCHA = hexdec(bin2hex(substr($row[0],230,1)));
$itemDEX = hexdec(bin2hex(substr($row[0],231,1)));
$itemINT = hexdec(bin2hex(substr($row[0],232,1)));
$itemAGI = hexdec(bin2hex(substr($row[0],233,1)));
$itemWIS = hexdec(bin2hex(substr($row[0],234,1)));
$itemMR = hexdec(bin2hex(substr($row[0],235,1)));
$itemFR = hexdec(bin2hex(substr($row[0],236,1)));
$itemCR = hexdec(bin2hex(substr($row[0],237,1)));
$itemPR = hexdec(bin2hex(substr($row[0],238,1)));
$itemDR = hexdec(bin2hex(substr($row[0],239,1)));
$itemHP = hexdec(bin2hex(substr($row[0],240,1)));
$itemMana = hexdec(bin2hex(substr($row[0],242,1)));
$itemAC = hexdec(bin2hex(substr($row[0],244,1)));
$itemMaxCharges = hexdec(bin2hex(substr($row[0],246,1)));
$itemGMFLAG = hexdec(bin2hex(substr($row[0],247,1)));
$itemLight = hexdec(bin2hex(substr($row[0],248,1)));
$itemDelay = hexdec(bin2hex(substr($row[0],249,1)));
$itemDMG = hexdec(bin2hex(substr($row[0],250,1)));
$itemEffect = hexdec(bin2hex(substr($row[0],251,1)));
$itemRange = hexdec(bin2hex(substr($row[0],252,1)));
$itemSkill = hexdec(bin2hex(substr($row[0],253,1)));
$itemMagicFlag = hexdec(bin2hex(substr($row[0],254,1)));
$itemCastLevel = hexdec(bin2hex(substr($row[0],255,1)));
$itemEquipType = hexdec(bin2hex(substr($row[0],256,1)));
$itemColor = hexdec(bin2hex(substr($row[0],260,1)));
$itemDiety = hexdec(bin2hex(substr($row[0],264,1)));
$itemSpell = hexdec(bin2hex(substr($row[0],266,1)));
$itemClass1 = hexdec(bin2hex(substr($row[0],268,1)));
$itemClass2 = hexdec(bin2hex(substr($row[0],269,2)));
$itemClass = $itemClass1 + $itemClass2;
$itemRaces1 = hexdec(bin2hex(substr($row[0],272,1)));
$itemRaces2 = hexdec(bin2hex(substr($row[0],273,2)));
$itemRaces = $itemRaces1 + $itemRaces2;
$itemSaleRate = hexdec(bin2hex(substr($row[0],288,1)));
$itemCastTime = hexdec(bin2hex(substr($row[0],292,1)));
$itemSkillModIndex = hexdec(bin2hex(substr($row[0],312,1)));
$itemSkillModValue = hexdec(bin2hex(substr($row[0],314,1)));
$itemBaneDMGrace = hexdec(bin2hex(substr($row[0],316,1)));
$itemBaneDMGbody = hexdec(bin2hex(substr($row[0],318,1)));
$itemBaneDMG = hexdec(bin2hex(substr($row[0],320,1)));
$itemReqLevel = hexdec(bin2hex(substr($row[0],324,1)));
$itemReqSkill = hexdec(bin2hex(substr($row[0],325,1)));
$itemElemDMGType = hexdec(bin2hex(substr($row[0],328,1)));
// 0 - None
// 1 - MR
// 2 - FR
// 3 - CR
// 4 - PR
// 5 - DR
$itemElemDMG = hexdec(bin2hex(substr($row[0],329,1)));
$itemDietyReq = hexdec(bin2hex(substr($row[0],348,1)));

//Faction Modification - No Idea on this yet
// itemFactionModI_1 = hexdec(bin2hex(substr($row[0],330,1)));
// itemFactionModI_2 = hexdec(bin2hex(substr($row[0],330,1)));
// itemFactionModI_3 = hexdec(bin2hex(substr($row[0],330,1)));
// itemFactionModI_4 = hexdec(bin2hex(substr($row[0],330,1)));
// itemFactionModV_1 = hexdec(bin2hex(substr($row[0],338,1)));
// itemFactionModV_2 = hexdec(bin2hex(substr($row[0],338,1)));
// itemFactionModV_3 = hexdec(bin2hex(substr($row[0],338,1)));
// itemFactionModV_4 = hexdec(bin2hex(substr($row[0],338,1)));

[DeletedUser]

link ?

btw: its the 3.5 item DB i've been told from several people in irc... drop the 3.5 db's items and put in the 3.4 items.. two mysql commands.. i don't know them but search button can help.. i gotta rush so I can't.. but should be useful to try that.

[mByte]

btw: its the 3.5 item DB i've been told from several people in irc... drop the 3.5 db's items and put in the 3.4 items.. two mysql commands.. i don't know them but search button can help.. i gotta rush so I can't.. but should be useful to try that.

I have already dropped the table from my 3.5 database and imported the 3.4 items

Same Error

I also dropped the 3.5 items and created new items nothing

BUT I created a 1hs, Normal Item, HUM, WAR, RALLOS ZEK and it worked

so its not the table if i can get the same error on both databases.

only thing that i had a problem with from the 3.5 items table was i couldnt summon items in game. that was sloved by dropping 3.5 items and adding 3.4 items

[Lurker_005]

Windcatcher, here is a item structure deffinition I have edited as best as I can. It is based on EQEmu/hackersquest/ShowEQ, with a few entries from you

#define ITEM_STRUCT_SIZE 356
// #define SHORT_BOOK_ITEM_STRUCT_SIZE	356
// #define SHORT_CONTAINER_ITEM_STRUCT_SIZE 356
struct Item_Struct
{
/*0000*/ char      name[64];        // Name of item
/*0064*/ char      lore[80];        // Lore text
/*0144*/ char      idfile[6];       // Not sure what this is used for
/*0150*/ sint16    flag;
/*0152*/ uint8	   unknown0150[22]; // Placeholder
/*0174*/ uint8	   weight;          // Weight of item
/*0175*/ sint8     nosave;          // Nosave flag 1=normal, 0=nosave, -1=spell?
/*0176*/ sint8     nodrop;          // Nodrop flag 1=normal, 0=nodrop, -1=??
/*0177*/ uint8     size;            // Size of item
/*0178*/ int8      type;			// 0 - generic item, 1 - container, 2 - book
/*0179*/ uint8     unknown0178;     // ***Placeholder
/*0180*/ uint16    item_nr;          // Unique Item number
/*0182*/ uint16    icon_nr;          // Icon Number
/*0184*/ sint16    equipSlot;       // Current Equip slot
/*0186*/ uint8     unknwn0186[2];      // Equip slot cont.?
/*0188*/ uint32    equipableSlots;  // Slots where this item goes
/*0192*/ sint32    cost;            // Item cost in copper
/*0196*/ uint8     unknown0196[32]; // ***Placeholder
union
{
	struct
	{
	// 0228- have different meanings depending on flags
	/*0228*/ sint8    STR;              // Strength
	/*0229*/ sint8    STA;              // Stamina
	/*0230*/ sint8    CHA;              // Charisma
	/*0231*/ sint8    DEX;              // Dexterity
	/*0232*/ sint8    INT;              // Intelligence
	/*0233*/ sint8    AGI;              // Agility
	/*0234*/ sint8    WIS;              // Wisdom
	/*0235*/ sint8    MR;               // Magic Resistance
	/*0236*/ sint8    FR;               // Fire Resistance
	/*0237*/ sint8    CR;               // Cold Resistance
	/*0238*/ sint8    DR;               // Disease Resistance
	/*0239*/ sint8    PR;               // Poison Resistance
	/*0240*/ uint16   HP;               // Hitpoints
	/*0242*/ uint16   MANA;             // Mana
	/*0244*/ uint16   AC;               // Armor Class
	/*0246*/ uint8    maxCharges;		// Number of charges
	/*0247*/ uint8    GMflag;          // GM flag 0  - normal item, -1 - gm item
	/*0248*/ uint8    light;            // Light effect of this item
	/*0249*/ uint8    delay;            // Weapon Delay
	/*0250*/ uint8    damage;           // Weapon Damage
	/*0251*/ sint8    effecttype0;      // 0=combat, 1=click anywhere w/o class check, 2=latent/worn, 3=click anywhere EXPENDABLE, 4=click worn, 5=click anywhere w/ class check, -1=no effect
	/*0252*/ uint8    range;            // Range of weapon
	/*0253*/ uint8    skill;            // Skill of this weapon | Item Type?
                        //   0 - 1H Slashing
                        //   1 - 2H Slashing
                        //   2 - 1H Piercing
                        //   3 - 1H Blunt
                        //   4 - 2H Blunt
                        //   5 - archery
	                    //   6 - archery - 2
	                    //   7 - throwing
	                    //   8 - shield
	                    //  10 - defence
	                    //  11 - precious stones
	                    //  12 - lockpicks
	                    //  14 - food
	                    //  15 - water
	                    //  16 - source of light
	                    //  17 - archery (more stones, arrow components)
	                    //  18 - bandages
	                    //  19 - throwing (more)
	                    //  20 - spells
	                    //  21 - EXPENDABLE (potion)
	                    //  23 - wind instrument
	                    //  24 - stringed instrument
	                    //  25 - brass instrument
	                    //  26 - percussion instrument
	                    //  27 - arrows
	                    //  27 - archery related item
	                    //  29 - jewelry
	                    //  30 - skull (1 item)
	                    //  32 - ??? 
	                    //  33 - keys
	                    //  34 - coins
	                    //  35 - ???
	                    //  36 - fishing pole
	                    //  37 - fishing bait
	                    //  38 - alcohol
	                    //  39 - more keys, some letters
	                    //  40 - compass
	                    //  42 - poisons
	/*0254*/ sint8    magic;            // Magic flag
                        //   00  (0000)  =   ???
                        //   01  (0001)  =  magic
                        //   12  (1100)  =   ???
                        //   14  (1110)  =   ???
                        //   15  (1111)  =   ???
	/*0255*/ sint8    level0;           // Casting level
	/*0256*/ uint8    material;         // Material?
                        //   0 Armor (cloth)
                        //   1 Armor (leather)
                        //   2 Armor (chain)
                        //   3 Armor (plate)
                        //   4 Armor (monk)
                        //   5 Armor (chitin)
                        //   7 Armor (scale)
                        //   10 Robe (advisor pattern)
                        //   11 Robe (FBR pattern)
                        //   12 Robe (ishva pattern)
                        //   13 Robe (oracle pattern)
                        //   14 Robe (kedge pattern)
                        //   15 Robe (SMR pattern)
                        //   16 Robe (plain)
                        //   17 Armor (icy)
                        //   18 Armor (dragonskin)
                        //   19 Armor (stability pattern)
                        //   20 Armor (ulthork)
                        //   21 Armor (ry'gorr pattern)
                        //   22 Armor (guardian pattern)
                        //   105 unknown
                        //   213 unknown
	/*0258*/ uint8    unknown0258[3];   // ***Placeholder
	/*0260*/ uint32   color;            // Amounts of RGB in original color
	/*0264*/ uint16   deity;		// deity
	/*0266*/ uint16   spellId0;         // SpellID of special effect
	/*0268*/ uint16   classes;          // Classes that can use this item
	/*0270*/ uint8    unknown0270[2];   // ***Placeholder
		/*0272*/ uint16   races;            // Races that can use this item
		/*0274*/ sint8    unknown0274[2];   // ***Placeholder
		/*0276*/ sint8    stackable;        //  1= stackable, 3 = normal, 0 = ? (not stackable)
	/*0277*/ uint8    level;            // Casting level
	union // 0278 has different meanings depending on an stackable
	{
    /*0278*/ sint8    number;          // Number of items in stack
    /*0278*/ sint8    charges;         // Number of charges (-1 = unlimited)
	};
	/*0279*/ sint8    effecttype;       // 0=combat, 1=click anywhere w/o class check, 2=latent/worn, 3=click anywhere EXPENDABLE, 4=click worn, 5=click anywhere w/ class check, -1=no effect
	/*0280*/ uint16   spellId;           // spellId of special effect
	/*0282*/ uint8    effectmask;	   	// Windcatchers label
	/*0283*/ uint8    unknown0283[3];   	// ***Placeholder
	/*0288*/ uint32   sellRate;		// multiplyer to item price in case of it selling from shopkeeper
	/*0290*/ uint16   foodSize;   		// Value for size of food or drink
	/*0292*/ uint32   casttime;   // Cast time of clicky item in miliseconds
	/*0296*/ uint8    unknown0296[16];   // ***Placeholder
	/*0312*/ uint16   skillModId; 		// ID of skill that item modifies
	/*0314*/ sint16   skillModPercent; // Percent that item modifies skill
	/*0316*/ uint16   baneRaceDMG;		// Race bane damage applies to
	/*0318*/ uint16   baneBodyDMG;		// Body type bane damage applies to
	/*0320*/ uint8    bandDMG;		// Ammount of bane damage
	/*0321*/ uint8    unknown0321[3];	// ***Placeholder
	/*0324*/ uint8    reqLevel;		// Required Level
	/*0325*/ uint8    reqSkill;		// Required Skill
	/*0326*/ uint8    unknown0326[2];	// ***Placeholder
	/*0328*/ uint8    elemDMGtype;		// Elemental Damage Type
	/*0329*/ uint8    elemDMG;		// Elemental Damage ammount
	/*0330*/ uint16   factionModindex[4];	// Faction Modifier Index
	/*0338*/ uint16   factionModvalue[4];	// Faction Modifier values
	/*0346*/ uint8    unknown0346[2];	// ***Placeholder
	/*0348*/ uint32   Diety2;		// Diety only wearable
	/*0352*/ uint8    unknown0352[4];	// ***Placeholder
	} common;
	struct // Book Structure (flag == 0x7669)
	{
    /*0228*/ sint8    bookType;      		// 0 - note, 1 - book
    /*0229*/ sint8    bookOpen;      		// 0 - closed/rolled up, 1 - open/unrolled
    /*0230*/ sint8    unknown0230;      	// ***Placeholder
    /*0231*/ char     file[33];         	// Filename of book text on server
    /*0264*/ sint8    unknown0264[92];  	// ***Placeholder
	} book;
	struct // containers flag == 0x5400 or 0x5450
	{
    /*0228*/ sint8    unknown0228[40];     	// ***Placeholder
    /*0268*/ sint8    containerType;     	// Container Type ?
			// 0x10 - deluxe sewing kit
			// 0x12 - fletching kit
			// 0x2B - fier'dal fletching kit
			// 0x10 - small sewing kit
			// 0x10 - large sewing kit
			// 0x14 - jeweller kit
    /*0269*/ uint8    numSlots;        		// number of slots in container
    /*0270*/ sint8    unknown0270;     		// ***Placeholder
    /*0271*/ sint8    sizeCapacity;    		// Maximum size item container can hold
    /*0272*/ uint8    weightReduction; 		// % weight reduction of container
    /*0273*/ sint8    unknown0273[83];     	// ***Placeholder
	} container;
};
};

[Windcatcher]

OK, I'm adding the new fields in...but is this for 0.34 or 0.35 items? Or are they the same?

[Lurker_005]

They are the same