| |
| |
Weighted Banner Rotating System with ColdFusion |
|
|---|
|
Author: Travis
|
Views: 18,796 /
Created: April 29, 2002
|
| |
Everyone has seen how to do a rotating banner system with
ColdFusion or some other language but adding the twist of weighted banners is
the part many people either don't know to do or keep quite about so people have to buy
there product or script. Well, I will show you how to do this with ColdFusion. It
is really a simple script once you see it. Your database needs to be designed
like so.
| Field Name |
Type |
Description |
| ID |
Integer |
Auto incrementing |
| BANNER_ALT |
Text |
Alt description |
| BANNER_PIC |
Text |
Picture location |
| BANNER_URL |
Text |
URL link for banner |
| BANNER_WEIGHT |
Integer |
A weight from 0-10 |
| BAN_CLICKS |
Number |
How many times clicked |
| BAN_VIEWS |
Number |
How many times viewed |
Assuming you have some banners inputted in to your database,
you can move on to the CF coding. First thing you need to do is query your
database for the data like so.
<!--- Start Query Banner DB --->
<cfquery datasource="YourDSN" name="banner">
select *
from banners
order by ID desc
</cfquery>
<!--- End Query Banner DB --->
Now, it is time to take all your banners and shuffle them and
pick the magical banner to display. This next part will be documented fully so
you can see how the weighted system is accomplished.
<!--- Start Weighting and Rand Num. --->
<!--- This starts your list for all the numbers to pick from --->
<cfset prodlist="">
<!--- Telling it to output the data your queried --->
<cfoutput query="banner">
<!--- Starting the loop --->
<cfloop index="x" from="1" to="#banner_weight#">
<!--- This added the banner ID to the list for every weight --->
<cfset prodlist=listappend(prodlist,#id#)>
<!--- The end of the looping --->
</cfloop>
<!--- End of the data query --->
</cfoutput>
<!--- This startment pulls a random number from 1 to the length of the list
--->
<cfset magicnumb=randrange(1,listlen(prodlist))>
<!--- This one will pull the banner ID out from the random number point
--->
<cfset magicnum=listgetat(prodlist,magicnumb)>
<!--- End Weighting and Rand Num. --->
Almost there. The weighting and random part is done now to add
one view to the Banner_views variable of the particular banner.
<!--- This queries the specific banner --->
<cfquery datasource="YourDSN" name="views">
select *
from banners
where id = #magicnum#
</cfquery>
<!--- start Adds 1 to view --->
<cfoutput query="views">
<CFSET add = #ban_views# + 1>
<CFQUERY datasource="YourDSN" name="UpdateView">
UPDATE Banners Set ban_views = #add# where ID = #id#
</cfquery>
</cfoutput>
<!--- End Adds 1 to view --->
This next part will display the banner.
<cfoutput query="views">
<A HREF="redirect.cfm?ID=#magicnum#" TARGET="_blank">
<IMG SRC="#banner_pic#" alt="#banner_alt#" width="468" height="60"></A>
</cfoutput>
Ok, now for the final part and that is where the system added
one to the Banner_clicks. This will be a different file. It's called
redirect.cfm. This is what you will find in the redirect.cfm.
<!--- Query Banners To Get ID to specify Redirection URL --->
<CFQUERY DATASOURCE="YourDSN" NAME="Banners">
SELECT *
FROM Banners
WHERE ID = #ID#
</CFQUERY>
<!--- Add One To Click --->
<CFSET add = #incrementvalue(val(Banners.ban_CLICKS))#>
<CFQUERY datasource="YourDSN" name="UpdateView">
UPDATE banners Set ban_clicks = #add# where ID = #ID#
</cfquery>
<!--- Go To URL for that Banner --->
<CFOUTPUT QUERY="Banners">
<CFLOCATION URL="http://#Banners.banner_url#">
</CFOUTPUT>
That is it. You have now just created a weighted banner
rotation system. Nice thing that is also added to this is if you set the weight
of the banner to 0 it will not display so you can turn banners off. If you
have any questions or comments, Contact Me.
|
|
|
|
 Digg
 del.icio.us
 Furl
 Google Bookmarks
 Yahoo! MyWeb
 AddThis Bookmark
|
Revision History:
02.25.2009 - Adjusted coding. Had unneeded lines.
|
|
|
View Our World Wide Web Customer Privacy Policy
|
|
|
........
|
|
