[Andy R]

OK, I have run the MySQL command via PHPMyAdmin. In order to run the comman, I had to remove the apostrophy marks (').

Here is the result I got:

PHP Code:

Your SQL-query has been executed successfully
 
SQL-query :
CREATE TABLE ads (
adid smallint(5) NOT NULL auto_increment,
name varchar(25) NOT NULL default '',
forumid smallint(5) NOT NULL default 0,
wholeforum smallint(1) NOT NULL default 0,
exposed smallint(10) NOT NULL default 0,
exposures smallint(10) NOT NULL default 0,
time int(10) NOT NULL default 0,
advert text NOT NULL,
KEY adid (adid)
) 


I have edited the /forums/admin/index.php file and all the admin features seem to be working. I can create ads and modify them.

When I ad the code to global.php and upload the modified file, I get a MySQL error:

PHP Code:

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT * FROM ads WHERE wholeforum='1' AND time>=1024693619 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()
mysql error: You have an error in your SQL syntax near 'RAND()' at line 1

mysql error number: 1064

Date: Friday 21st of June 2002 03:06:59 PM
Script: [url]http://www.airstreamforums.com/forums/forums/index.php?s=[/url]
Referer: [url]http://www.airstreamforums.com/forums/online.php?s=[/url] 


I have reverted back to the original gloabl.php for now.

Any clues on what I might be doing wrong?

Thanks,

Andy