Bitsys,
this is what my items_user table looks like:
Field Type Attributes Null Default Extra Action
userid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
bankval int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
btime int(11) No 0 Change Drop Primary Index Unique Fulltext
item0 char(250) No No Item Change Drop Primary Index Unique Fulltext
points0 int(5) No 0 Change Drop Primary Index Unique Fulltext
description0 char(250) No No Description Available Change Drop Primary Index Unique Fulltext
icon0 char(250) No Change Drop Primary Index Unique Fulltext
itid0 int(11) No 0 Change Drop Primary Index Unique Fulltext
item1 char(250) No No Item Change Drop Primary Index Unique Fulltext
points1 int(5) No 0 Change Drop Primary Index Unique Fulltext
description1 char(250) No No Description Available Change Drop Primary Index Unique Fulltext
icon1 char(250) No Change Drop Primary Index Unique Fulltext
itid1 int(11) No 0 Change Drop Primary Index Unique Fulltext
item2 char(250) No No Item Change Drop Primary Index Unique Fulltext
points2 int(5) No 0 Change Drop Primary Index Unique Fulltext
description2 char(250) No No Description Available Change Drop Primary Index Unique Fulltext
icon2 char(250) No Change Drop Primary Index Unique Fulltext
itid2 int(11) No 0 Change Drop Primary Index Unique Fulltext
item3 char(250) No No Item Change Drop Primary Index Unique Fulltext
points3 int(5) No 0 Change Drop Primary Index Unique Fulltext
description3 char(250) No No Description Available Change Drop Primary Index Unique Fulltext
icon3 char(250) No Change Drop Primary Index Unique Fulltext
itid3 int(11) No 0 Change Drop Primary Index Unique Fulltext
|