News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Ad Management mod

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

Previous topic - Next topic

vbgamer45

In phpmyadmin or ask your host to run in on your 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

PenelopeQ

Quote from: vbgamer45 on August 29, 2016, 07:02:56 PM
In phpmyadmin or ask your host to run in on your database.
Yes, I know that part, but what do I do once I am there?

Kindred

Run the command...   ;)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

PenelopeQ

I'll rephrase.
How do I run a command in phpmyadmin?
Is there a tab I need to select that is where I run commands from?

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

PenelopeQ

Okay. Got it did it and got this:
Quote#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

PenelopeQ

Quote from: vbgamer45 on August 30, 2016, 06:42:22 PM
Try

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

This should not be having so many problems!
You're being clear--as you know it is me. :P
I ran it and got this: 
Quote#1146 - Table 'rollerco_smf2.smf_ads' doesn't exist
I did a search for ads on the page and found these tables:
rollerc3_ads
rollerc3_ads_settings

Okay, so is that first one it--just without smf_ coming first?
The database is rollerco_smf2, but that is not how the tables are starting, they are starting with rollerc3 and the search I ran defaults to rollerco_smf2. to start the title of the table.

Can I just change that in the search query and try this?

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


But since the table name is also different than waht you said, is there first a way I can check it is the correct table--something to look for in the table maybe?

vbgamer45

You would do

alter table rollerc3_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


vbgamer45

Glad you having it working finally.
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

engrz

is there any way to place ad in between message body/post by using ad management mod?

vbgamer45

Yes you can choose to put inside a post or after a certain number of posts.
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

Paracelsus

For those that would like to put a different ad-code on the same position but that is different according to the type of pages (post pages, topiclist pages, and others), here's a relatively simple hack that you put in the content (and the ad has to be PHP on Type):

if (isset($_REQUEST['topic']))
{
echo '
YOUR-HTML-AD-CODE-1
';

} else if (isset($_REQUEST['board'])) {
echo '
YOUR-HTML-AD-CODE-2
';

} else {
echo '
YOUR-HTML-AD-CODE-3
';

};


Maybe someone has a better code but this worked for me at least (I needed to have a adunit on the header and footer ads that changes whether it is in index, topiclist or post page).

engrz

Quote from: vbgamer45 on November 10, 2016, 08:37:48 AM
Yes you can choose to put inside a post or after a certain number of posts.


There is no any option to select inside a post.

vbgamer45

I guess it is not part of this mod then.
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

andsim

i came across ad wont display
here r install issues and what look like
no ad showing
on smf 2.0.13

vbgamer45

You are not using the core them so you do not have to worry about that. Continue the install.

Make sure each membergroup has permission to view ads
Also make sure under options  for ad management that you have ads enabled for admins
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

andsim

Quote from: vbgamer45 on February 09, 2017, 03:45:46 PM
You are not using the core them so you do not have to worry about that. Continue the install.

Make sure each membergroup has permission to view ads
Also make sure under options  for ad management that you have ads enabled for admins
gotta now it was google adsense u had to wait

TrackMustangsOnline

Hi, I migrated to a new host and installed a fresh load of SMF 2.0.13 and used my existing DB.  Many of my mods are either not working or working but showing they are not installed.  Anyway with Ad Management 3.0.1 I'm getting the following screen.  How should I proceed on this?  Do I select Execute Modification and Install or should I delete the mode and load the latest version?

Thanks for your advice.


Advertisement: