Ad Management mod

[Bigguy]

@ ge master: More than likely yes.

@ maxx_oo7: Make all your template files writable.

[symon]

Dose anyone know how to uninstall this mod and what parts of the DB to remove?

Thanks

[stageducky]

Due to database corruption I have to upload a backdated count of the ads hits.

Is there a way where I can rectify this through phpmyadmin? by manually keying in the correct figure? Anyone please advice.

[tink]

I am running SMF1.1.4 default theme. I have downloaded the 2.3 ad management mod.  I have already put my ads on and they are in my welcome user section of the board at the top on every page.

Only my admins can see them, none of the others members can.  When I went to set the permissions for the members to see the ads there is no permission for it.

I am new to this, but I am not finding where I can enable the ads to be seen by everyone.

[Bigguy]

@ symon: Leaving the database fields in won't harm your SMF install.

@ stageducky; Not sure what the table is called but there is a table in the database for the ad mod. I would search it to start.

@ tink: Check to make sure all the edits were done. Are there any errors in the error log.

[kolt]

Please Can Anyone help me?

[stageducky]

Hi biguy,

I know the table but I can't seem to find the part where I can manual key in the figure.

can you tell me what to do when I'm at the table?

[no_quarter]

I'm trying to use www.smfads.com's fine functions
1. you must uploade files to ftp (Done)
2. you must edit some of the files already there (Done)
3. you must run som queries (see them at the bottom). How do I do that, it may be simple, but not to me, I run into problems. I've entered phpmyadmin, go to myhomepage_smf, click SQL and run it. I get error messages

Start of Error message.
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 )
)

MySQL returnerede: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$db_prefix}ads (
ADS_ID mediumint( unsigned NOT NULL auto_increment,
NAME t' at line 1
End of error message
----------------------------------
Queries to be entered, I've only tried the first so far, results above
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}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')

[Bigguy]

@ stageducky: Im sorry Im not really good with databases. There should be someone here that would be able to help with that though.

@ no_quarter: Why are you trying to install manually.

[grevan]

Hello everyone.
I installed this MOD, but i can´t find the "link" to open the configuration screen for the Ad Management Mod. I´m using the Pn-Pn Template.
Thank you for any help.

[prottoy]

can any one plz help me how to do this for 'kelo-it' theme....plz plz plz help...

[MissyNL]

hello,

I have installed the mod and the install went good. I have smf 1.1.5 version.

When i wanted to place and ad on the index page, it did not show under the tab.

When i decided to place it then on every page, because the indexpage did not work i only got a link.

Pleace see the attached file:) 

does anybody know what it is?

[Bigguy]

Use img tags before and after the url to the image:

Code Select Expand

[img]http://www.yoursite.com/image.gif[/img]

[MissyNL]

Use img tags before and after the url to the image:

Code Select Expand

[img]http://www.yoursite.com/image.gif[/img]

Nope.. doesn't work...

But i've heard that ad mod isn't capible with 1.1.5 ... is that correct?

[kolt]

please anyone can replay to me pleaseeee!

I need to put an avatar in add post!

help

[tink]

@ tink: Check to make sure all the edits were done. Are there any errors in the error log.

edits, as in edits on my admin section or edits to the programming.

I have no error messages about this

[Bigguy]

Edits that the mod made to your SMF install while it installed.

[tink]

Edits that the mod made to your SMF install while it installed.

I got no error messages when Installed it.

[DareDevil1990]

hey i think this mod is not wrking in smf 1.1.5 please can anyone edit this mod to work with smf1.1.5 pleasee i need this mod badly and that too fast 

[ccbtimewiz]

It should work fine on SMF 1.1.5

Open the install.xml

Find something like:

Code Select Expand

<install for>1.1.4</install>

And change to:

Code Select Expand

<install for>1.1.5</install>

It's not exactly those tags, but I think you'll find it. ^^