Ad Management mod

[wlchase]

Can I install the update (3.0.1) over 2.3.6.1 with no problems, or should I uninstall first?

Love the mod, BTW!
Bill

[Arantor]

Uninstall first.

[wlchase]

I won't lose my current ad configuration?

[Arantor]

No, it's still in the database.

[Mayhem30]

You missed a part of the query in your latest update.

In order to use the PRIMARY key, the query should be "SELECT * FROM {$db_prefix}ads WHERE ADS_ID > 0"



Your "SELECT * FROM {$db_prefix}ads" in the latest update still produces :

[vbgamer45]

That's strange surprised it would do a filesort without anything in the where clause will look at it later.

[Arantor]

MySQL is optimising the query a particular way: without a WHERE, it's going to tablescan it because it has no index that is suitable, and if there isn't an ORDER BY, SMF may add its own in (and failing that, MySQL may order by primary key in lieu of not being given an explicit order), so it's doing it all on disk to minimise reads. It isn't actually that surprising if you get down into the internals of MySQL.

[vbgamer45]

Hmmm maybe start doing that will all my queries now if that is true

[Mayhem30]

If you put the word "EXPLAIN" in front of your queries, it will show you exactly how it's going to handle things. That way you can try different methods and see which works best.

This is a basic breakdown of what "EXPLAIN" will show you (found this on google).

table : shows us which table the output is about (for when you join many tables in the query)

type :  is an important one - it tells us which type of join is being used. From best to worst the types are: system, const, eq_ref, ref, range, index, all

possible_keys : Shows which possible indexes apply to this table.
key : and which one is actually used.
key_len : give us the length of the key used. The shorter that better.
ref : Tells us which column, or a constant, is used.
rows : Number of rows mysql believes it must examine to get the data.
extra : Extra info - the bad ones to see here are "using temporary" and "using filesort".

[Pedro1234]

Hi Folks, just a quick question. I have uploaded the ad mod but i have no ad management in my admin menu. My language is English so i know that i will have to make the code changes for my specific custom theme. I simply dont know what to put in where.

Can anyone help with what code i need to put in the theme and where??

My theme is sm-tema v2

thanks a heap..

Pedro

[vbgamer45]

What SMF version?

Check the manual install options for your SMF version

[BizBink]

So I have a slight prob and it's that I need this mod to only show ads on one theme (destopk version) and to display another different ad for another theme (mobile theme)

How would I do this, thanks in advance

[vbgamer45]

You would follow the manual install steps for theme part on your custom theme to make it appear correctly.

[BizBink]

It never installed it onto the mobile theme though... Also I'm not so great at php (just started learning it a month ago)

[Kindred]

however, as far as I know, there is no way to make it show one ad for one theme and another for a different theme

[An0nymousHelper]

Hi, is there a way for me to get my banner ad that goes right under the menu to be centered? Because right now it's on the far left and just looks very out of place. How would I re-position this? Any help is well appreciated! Thanks!

Edit: I'm on 1.1.13 if that makes a difference...

[vbgamer45]

If your using html you can use a center tag around your banner code <center></center>

[BizBink]

however, as far as I know, there is no way to make it show one ad for one theme and another for a different theme

so theres no possible way of making it so it is like that... what if i have it so it displays one ad for the desktop theme and another ad for th mobile theme

anyway of doing that

[Kindred]

Not as designed

[ohhhdear]

I've tried to upload this (Ad Management)  a couple of times.

I have 1.1.13
Using Core Default Theme

It says: "The package you are trying to download or install is either corrupt or not compatible with this version of SMF."