• Welcome to Simple Machines Community Forum. Please login or sign up.
October 28, 2021, 05:55:15 PM

News:

Wondering if this will always be free?  See why free is better.


Ad Management mod

Started by SMFHacks.com Team, January 30, 2006, 08:41:19 PM

Previous topic - Next topic

vbgamer45

Updated files attached
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

jbridges87

I've uploaded the files, and I'm awaiting Google AdSense confirmation, but the Ad Management settings appear to be showing ad bars now, so I think it's working.

I will have to wait for my confirmation to be sure, but it looks promising.

Thanks again for the assistance!
Come by and check out my sports forum, here.
Running SMF v2.0.17

humbleworld

I need to manually uninstall the Ad Management mod because it messed up some codes in my forum. After the manual removal, I would like to install a fresh, clean Ad Management MOD.

Any guide how to uninstall it MANUALLY? Thank you.

vbgamer45

Upload the package to https://www.smfhacks.com/smf-package-parser.html and follow the uninstall steps
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

humbleworld


jbridges87

I'm logged in as administrator, but I'm receiving a '403 Forbidden  Error' when trying to place ad content via the Ad Management mod.

I've attached a screenshot of the error.
Any ideas?
Come by and check out my sports forum, here.
Running SMF v2.0.17

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

jbridges87

Should the .htaccess file be placed in the public_html folder and/or the folder SMF is installed in, or does the file need to go into a specific folder? [I didn't see any mention of the location in the link]
Come by and check out my sports forum, here.
Running SMF v2.0.17

vbgamer45

try in the SMF Folder first.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

jbridges87

I tried the htaccess approach, but didn't have any luck.
I was able to speak with my host and they made a modification to the firewall rule, and it's working now. Thank you for that.

I was directed to input a snippet of code into the <head> and another snippet into the <body>
After inputting the code into the Ad Management mod, I viewed the page source, and I can't find a way to get the Ad Management mod to input the code into the <head>, as directed.

I tried each individual option, and then view the page source after, none of the selections put the code into the <head>.
Come by and check out my sports forum, here.
Running SMF v2.0.17

vbgamer45

There is no built in function at this time to add code to the header but could be a good feature requesst.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

jbridges87

So I was recently approved for adsense, and was given a code snippet, with instructions to add that into the <head> section, but as mentioned earlier, that's not an option through the mod, so I just put the code in manually.

Then I went into the settings of the mod, and configured as desired. However, the ad code doesn't show up anywhere on the site.

I attached a screenshot of my settings.
Am I missing something?
Come by and check out my sports forum, here.
Running SMF v2.0.17

shadav

if you were just approved it may take a bit of time before google actually starts showing ads....the other thing is to make sure you don't have an adblocker on, whitelist your site :)

I had this installed and it was working (sort of), removed it because it didn't really play well with my themes and found it easier just to edit the files manually since I only wanted it in the footer and after the first post

though I have noticed that ads do not always show....google's a pita.....
ads show fine on the site, but not always on the forum, which I believe is due to "lack of content"

jbridges87

That could be, but I have a feeling there might be something wrong with my mod, as the Google Auto-ads were working as soon as I turned them on.

The reason I wanted to use the ad management mod was so that I could have more control over the display.
Come by and check out my sports forum, here.
Running SMF v2.0.17

perfec2

June 20, 2020, 08:35:41 AM #7914 Last Edit: June 20, 2020, 09:31:05 AM by perfec2
How can I fix this?

I installed Ad Management mod and got the error below in all threads in the forum:

Out of range value for column 'HITS' at row 1
File: /home/username/public_html/Sources/LoadAds.php
Line: 298

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0.13. The above error might possibly go away if you execute the latest version of upgrade.php.

vbgamer45

You have an old version of the mod you need to change the hits column in the database table to a larger datatype.

alter table smf_ads HITS HITS BIGINT NOT NULL default '0'; .
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

perfec2

Quote from: vbgamer45 on June 20, 2020, 09:49:13 AM
You have an old version of the mod you need to change the hits column in the database table to a larger datatype.

alter table smf_ads HITS HITS BIGINT NOT NULL default '0'; .


Please what are the steps to do this?

I went to phpmyadmin, click the database, smf_ads, structure, and change value to NULL, then clicked  save. The error still on the site.
By the way I installed version of the mod I downloaded a week back "ad_mod_v3.5_SMF_2.0_and_SMF2.1d"

vbgamer45

You have to run that query on the database.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

perfec2

Quote from: vbgamer45 on June 20, 2020, 10:16:50 AM
You have to run that query on the database.


I went to the database >> smf_ads, Structure >> Hit>> SQL
After putting the query, click GO and got the error below after the execution:
"Static analysis:

1 errors were found during analysis.

Unrecognized alter operation. (near "" at position 0)
SQL query:

alter table smf_ads HITS HITS BIGINT NOT NULL default '0'

MySQL said: Documentation

#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 'HITS HITS BIGINT NOT NULL default '0'' at line 1

vbgamer45

TRY

alter table smf_ads change HITS HITS BIGINT NOT NULL default '0';
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: