ITEM_DBF changes

[raventh1984]

Hi elitepvpers,

Well i was looking for an easy way to make an backend panel for an shop.
So i felt inspired with this topic

With thanks to Xxl3lubbs for making such an topic and velmore and FlyCraft.TobiLap for their contribution


Now what i wanted was to make my own ITEM_TBL with my own columns etc.
This is now almost 100% working if i didnt have 2 problems that i cant seem to find

inside the spec_item there are 2 rows szIcon and szComment that i wanted to use

However eveytime the server starts the szIcon and szComment inside the ITEM_TBL remains empty. Now i have tried somethings but it seems i cant get it to work.

i am inserting it into ITEM_TBL like this

i will only show what i am having problems with

sprintf( szSQL, "ITEM_STR 'I1', '%s', '%s'," //0
pItemProp->szIcon, pItemProp->szComment

Those are not working or give an empty result.
Any help will be appriciated.

With kind regards,

[FlyCraft.TobiLap]

I am not sure about the icon but I think it is tha same as the comment.
The comment is only loaded and defined if __CLIENT is defined so it is only loaded in the Neuz.
Just go into the "LoadPropitem" function and look for #ifdef __CLIENT

[raventh1984]

Thank you for the tip. And yes indeed it was located there so i changed it.

Now its working as it should be.

[raventh1984]

Hmm i found yet an other problem with this system.

I have 21 rows that i want to insert.

Now almost everything works fine except for 1 row/value

This is the Funtion to update the ITEM_TBL

 Spoiler

sprintf( szSQL, "ITEM_STR 'I1', %d, '%s'," //0
"%d," //1
"%d," //2
"%d," //3
"%d," //4
"%d," //5
"%d," //6
"%d," //7
"%d," //8
"%d," //9
"%d," //11
"%d," //11
"%d," //12
"%d," //13
"%d," //14
"%d," //15
"%d," //16
"%d," //17
"'%s'," //18
"'%s'", //19

pItemProp->dwID, strItem, //0
pItemProp->dwNum, //1
pItemProp->dwItemJob, //2
pItemProp->dwItemSex, //3
pItemProp->dwDestParam1, //4
pItemProp->dwDestParam2, //5
pItemProp->dwDestParam3, //6
pItemProp->dwDestParam4, //7
pItemProp->dwDestParam5, //8
pItemProp->dwDestParam6, //9
pItemProp->nAdjParamVal1, //10
pItemProp->nAdjParamVal2, //11
pItemProp->nAdjParamVal3, //12
pItemProp->nAdjParamVal4, //13
pItemProp->nAdjParamVal5, //14
pItemProp->nAdjParamVal6, //15
pItemProp->dwReferValue1, //16
pItemProp->dwLimitLevel1, //17
pItemProp->szIcon, //18
strItem2 //19
);

As you can see there are 3 more dwDestParam and nAdjParamVal
so up to dwDestParam5 is working normaly how ever if it reaches dwDestParam6
It insert nAdjParamVal1 into the database
So i got now this


i have checked dwDestParam6 in spec_item and the value is an (=) so it should be an -1 instead of the value that is from nAdjParamVal1.

Does anyone have an clue about this?