[Gio~Logist]

Originally Posted by KTBleeding

Just to let you know:

I had to take a look at the install code to fix an error I was getting after running the query you posted above.. but I believe I have that sorted.

Noticed this in the installer:

$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `sr_classifieds_ratings` (
  `rateid` int(10) unsigned NOT NULL auto_increment,
  `ratedid` int(10) unsigned NOT NULL default '0',
  `raterid` int(10) unsigned NOT NULL default '0',
  `rating` int(2) NOT NULL default '0',
  `comment` varchar(250) NOT NULL default '',
  `type` varchar(20) NOT NULL default '',
  `adid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rateid`)
) TYPE=MyISAM
");


$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `sr_classifieds_uploads` (
  `classifiedid` int(10) unsigned NOT NULL default '0',
  `image` varchar(250) NOT NULL default 'noimage.gif'
) TYPE=MyISAM;
");

They should have ". TABLE_PREFIX ." assigned, correct?

Ah yes. That's not a major issue as far as functionability is concerned, however, it should be there. I added it and updated the zip