[CD3.55] item db error

[ervinzed]

what is the source of this error?

 

[idaBigA]

I would suggest either you have 2 things named the same, or you number sequence isn't in order. I think an incorrect number sequence returns some different number though.. not 100% sure.

 

[ervinzed]

do you have time to import item db from .xls to sql server and test it?

HL_StdItems.xls

 

[JoeDunn]

just go to the bottom of the DB and check any new items u have made that the index number on the left are in order and that they dont use a normal item name. if u dont do your self now u will never learn.....

 

[ervinzed]

just go to the bottom of the DB and check any new items u have made that the index number on the left are in order and that they dont use a normal item name. if u dont do your self now u will never learn.....

problem is i added 40000 items

---------- Post Merged at 08:44 PM ---------- Previous Post was at 07:38 PM ----------

i get starttimer exception

what do the last 2 ^ lines say?

 

[idaBigA]

There are no duplicate items, and no duplicate or missing numbers so it isn't that.

The number of items?

What is StdMode 99?

 

[ervinzed]

thanks for your help

std mode 99 are integrals and similar items

 

[chimera]

Lines 1220+ needlevel blank

 

[ervinzed]

theres items that dont have level attr

how many letters on item names does the sql db suport? 19 or less?

 

[idaBigA]

50 chars I think, the only restriction is that you can't sell or mirmail anything that has more than 25 chars.

 

[ervinzed]

it was the 255 cap on item stats

 

[dsmir3]

Database entry is 256 characters, as this is the standard length for Microsoft, it can be reduced by changing the type of Database of Table.

There is a limitation on entry's into the database for 3.55.

 

[chimera]

I have craftily got past the lvl 255 ^^

 

[dsmir3]

I have craftily got past the lvl 255 ^^

I take it you used the negative count, rather than positive. Though you can change the database table to show it above 255 without using the negative count.

The database for 3.55 does work with SQL 2005 ;-)

 

[chimera]

Nice guess but nope, I included another attribute into the requirement for items past 255

 

[Serane]

Nice guess but nope, I included another attribute into the requirement for items past 255

Hi chim, have you succeed to add stats over the 255?