Beermonster, Is there any way to modify this hack to just it to display forum specfic banner ads that show on top of ceratin forums?

You've lose me, each forum can have it's own ad displayed

What I meant was to be displayed on top of each forum listing as well as on every thread under that forum. I've just finished up my doings thanks in great part to your hack. If you like I will gladly share it with you. My little variation works directly with phpAdsnew so that tracking can be done on the ads.

Here is an example:

http://www.rcflying.net/images/example.jpg

It shows a very large banner, 700x125 is what I am using.

Beermonster,

This works like a charm on my forums for users with IE, but users with Nescape browsers are reporting that the ad doesn't align correctly. I have verified that myself, please check out the attachment. Any way to correct this?

Sorry for not knowing everything, I have installed about 5 hacks already, but am having problems understanding what to do for the first part of this hack, where it is asking me to add field to the forum table and the "Run Query" part.

Can someone be a little more clear for me?

Cavs,

You need to login to your database and run those queries there.
Alternatively you may try to run them in your admincp if you have the appropriate privileges set.

^ I still have no clue what to do though, that's doing nothing for me. Remember, I'm a raw newbie. How do I run them? Where exactly are they?

The query needs to be run in mysql, go to phpmyadmin choose your database, then click on the sql tab you will then see a box that says Run SQL query/queries on database just paste the contents in to it and press go :)

if I'm the admin and Im' in the adminCP panel and go down to import and maint.

I then tell it to execute SQL query and it says I don't have access. HOw is that when I am the admin of the site.

I also can't do it from the hosting center when I go to the mysql option.

I"m also a newbie and have no idea of what's going on.. LOL

I think once i get the tables setup I"ll be fine.. :ermm:

If your hosting has cpanel click on the mysql icon then scroll down to the bottom and you will see a link to phpmysql click on that and it will take you to another page, there you can choose your database and them run the query.


As for not being able to run it from admincp I think, and I might be wrong, but edit your includes/config.php and find
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
you will see $canrunqueries = '1';
If you setup the forum then you should be user #1 but if someone set it up for you then made you a member you will have a different number.
Also make sure $superadministrators in the same file has your number in it.

Hope that works for you :)