strcpy(query, "SELECT MAX(id), count(*) FROM items"
 

Just compiled DR2 0.5.0. So far so good. Started up servers and saw it was calling for a table named items_. Why the need for items_ ?

Should:
strcpy(query, "SELECT MAX(ItemNumber), count(*) FROM items_");

be:
strcpy(query, "SELECT MAX(id), count(*) FROM items");

??

Also, the entry ItemNumber is missing in the DB as well....

Items are still under development. While this area is being worked on, the table items_ is being used. The script for this table is newitems_table.sql. Look for this in CVS - I am not sure if it is on there yet.

This table is only temporary, don't build any third-party tools around this table.

Yep, reading further into the code, I realized from the 'old item lookup' comments and what not....

I managed (with devn00bs help in irc) to make a db. Server is up and running and everything seems to be running great.

I was asked to test out necro pets, so ill do that tonight.