News:

Welcome to SMF Ads Support Forum

Main Menu
Coinbase

Ad Management 2.3.3 for SMF 1.1.7

Started by abcx, January 18, 2009, 02:36:39 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

abcx

In the installation instruction of Ad Management 2.3.3 for SMF 1.1.7 there is a section that says:

Code
install.php
This file should not be able to execute standalone. You may have to run the following queries manually.


Query: [Select]
CREATE TABLE IF NOT EXISTS {$db_prefix}ads (ADS_ID mediumint unsigned NOT NULL auto_increment,NAME tinytext NOT NULL,CONTENT text NOT NULL,BOARDS tinytext,POSTS tinytext,HITS mediumint NOT NULL default '0',TYPE smallint(4) NOT NULL default '0',show_index smallint(4) NOT NULL default '0',show_board smallint(4) NOT NULL default '0',show_threadindex smallint(4) NOT NULL default '0',show_lastpost smallint(4) NOT NULL default '0',show_thread smallint(4) NOT NULL default '0',show_bottom smallint(4) NOT NULL default '0',show_welcome smallint(4) NOT NULL default '0',show_topofpage smallint(4) NOT NULL default '0',show_towerright smallint(4) NOT NULL default '0',show_towerleft smallint(4) NOT NULL default '0',show_betweencategories smallint(4) NOT NULL default '0',show_underchildren smallint(4) NOT NULL default '0',PRIMARY KEY (ADS_ID))
Query: [Select]
CREATE TABLE IF NOT EXISTS {$db_prefix}ads_settings (variable tinytext NOT NULL,value text NOT NULL,PRIMARY KEY (variable(30)))
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}adsADD   show_lastpost smallint(4) NOT NULL default '0' AFTER show_threadindex
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}adsADD   CATEGORY tinytext AFTER POSTS
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}adsADD   show_underchildren smallint(4) NOT NULL default '0'
Query: [Select]
INSERT IGNORE INTO {$db_prefix}settings(variable, value)VALUES ('ads_displayAdsAdmin', '0'),('ads_updateReports', '0'),('ads_quickDisable', '0'),('ads_lookLikePosts'

Can someone please explain what I am suppose to do? How to execute standalone / run the queries manually? Thanks!