Hi!
I am trying to install the Ad management mod manually without the use of the package manager and the only thing missing right now is the querys.
i go to my php my admin and there i go to SQL.
i paste my third code, and i replace the '{$db_prefix}' with my database prefix, but i receive error.
its my error:
"Error
SQL query:
ALTER IGNORE TABLE smf_ads ADD show_lastpost smallint( 4 ) NOT NULL default '0' AFTER show_threadindex
MySQL said: Documentation
#1060 - Duplicate column name 'show_lastpost' "
what i need to do?
thanks very much
Quote from: "url=http://www.smfads.com/forums/index.php?topic=1778.msg7125#msg7125]eladh7 in ~help with the manual install~[/url]"]
I am trying to install the Ad management mod manually
without the use of the package manager
Why have you refused from installing the mod by Package Manager ?
Make sure your host/server permits usage of the CREATE and ALTER MySQL commands.
Quote from: gri on August 19, 2008, 01:53:20 PM
Quote from: "url=http://www.smfads.com/forums/index.php?topic=1778.msg7125#msg7125]eladh7 in ~help with the manual install~[/url]"]
I am trying to install the Ad management mod manually
without the use of the package manager
Why have you refused from installing the mod by Package Manager ?
because every mod that i install with Package Manager, the mod not installed good.
i dont no why.
anyway i succeeded to install the ad mod ;)
Someone should please help me wit steps involve in manually installing adverts on my SMF 1.1.5 Forum. Thanks
Please do a search all the edits are posted here. :)
@ bigguy. I can't find the edit you are refering to in your post. Kindly repost same, thank you.
Hello everyone! Please help or give me instructions on how to do the part below (Code and File Operations). Thanks.
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(8) unsigned NOT NULL auto_increment, NAME tinytext NOT NULL, CONTENT text NOT NULL, BOARDS tinytext, POSTS tinytext, HITS mediumint(8) 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}ads ADD show_lastpost smallint(4) NOT NULL default '0' AFTER show_threadindex
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}ads ADD CATEGORY tinytext AFTER POSTS
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}ads ADD 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', '1')
File Operations
Move the included file "Ads.php" to "./Sources".
Move the included file "LoadAds.php" to "./Sources".
Move the included file "Ads.template.php" to "./Themes/default".
Move the included file "Ads.english.php" to "./Themes/default/languages".
Never mind. I got it. Thanks.