Have you tried dropping the items table and reimporting the main items sql then the 16.3 update sql Dabaron? Oh and there are a couple items that were updated in 16.3 that don't have icon numbers assigned. Namely some Miiir clothing pieces.

I guess I should do a complete export of the data that includes the 16.3 stuff along with putting the optional clusters.sql and symbs.sql files all rolled up into one .zip file. I leave the cluster and symbs out of my main items table but they are on my FTP server for those that want to add them.

16.3 UPDATE: 16.3.01 Items Update for Bebot is HERE! Just run the sql there against your bots database to update the Items table.

I seem to have real problems connecting to this link (from several different hosts around the UK).

Any ideas why? Or better.. is there any alternative download site for this sql data?

www.jjones.co.uk/files/items17.00.00.zip

empty table and re-add, should be complete.

caveat emptor!  vhab's is better :-)

-jj-

Great! Thanks a lot    .. will download once I get home.

Whilst Vhabs certainly is better, it's also much slower, will only get slower as more orgs use bebot, and is reliant on an external connection to his site. I simply prefer a local db for speed.

..what he said 

Queries are much faster running it locally, and as long as the DB is up to date then orgies are happy 

Vhab faps to the new version :p

Quote from: Malosar on December 18, 2006, 06:20:09 pm

it's also much slower

It's somewhat faster on the new version though
moved from a shared host to a dead sexy one

I downloaded your items.php on saturday so I assume it was using the new one. It still took 3-5 seconds for a result, compared to <1 for local. Whether it's your host or my work connection or issues between us, it's moot. There will always be issues with external sources.

*smacks JJ for being off topic*