Rotating ads

[Ph0eniX]

Does anyone have sample code for rotating ads with hyperlinks?

Thanks.

[irish]

http://sourceforge.net/projects/phpadsnew/

[Ph0eniX]

Originally posted by irish
http://sourceforge.net/projects/phpadsnew/

Thanks. That's good stuff. But is there anything simpler that I could do myself?

[greg252]

Do yourself?
If you are looking for a simply way to rotate ads, go with something that someone has already written- no need to re-invent the wheel.

If you are looking for something very specific and decide to write it yourself, get ready for a long journey.
I started my banner rotation script about 2 months ago and it's still not 100%.

my suggestion:
Check our hotscripts.com and resourceindex for some easy to install/use stuff.

[Ph0eniX]

Originally posted by greg252
Do yourself?
If you are looking for a simply way to rotate ads, go with something that someone has already written- no need to re-invent the wheel.

If you are looking for something very specific and decide to write it yourself, get ready for a long journey.
I started my banner rotation script about 2 months ago and it's still not 100%.

my suggestion:
Check our hotscripts.com and resourceindex for some easy to install/use stuff.

It can't be more than 10 lines of code ...I'm going to re-write this to work in PHP/MySQL:

<SCRIPT Language="JavaScript1.2">
if (timeout) {clearTimeout(timeout);}
var timeout = setTimeout("logmeout();", 1000 * 5) // 1 sec
function logmeout() {
    window.self.location.reload();
}
</SCRIPT>
<%
Dim CN
Dim RS
Set CN = Server.CreateObject("ADODB.Connection")
CN.Open "ads","user","password"
Set RS = CN.Execute("SELECT top 1 * from ads order by lastsrv asc")
CN.Execute "update ads set lastsrv = getdate() where adid =" & rs.fields("adid")
Response.Write ("<A href='" & rs.fields("href") & "'><IMG border=0 SRC='" & rs.fields("src") & "'></A>")
Set CN = Nothing
%>

[ScubaDvr2]

It's very simple to have a rotating [anything]. put everything you want to be randomly shown up in an array. then do the array_rand() function. It'll randomly choose a value from whatever array you do this function on.

NOTE:You'll have to do an srand() function before this will work, because PHP has poor randomization 🙁.

If this doesn't work for you, then you could do the SHUFFLE() function. Then just echo the $array[0] variable. Much simpler, but you have 0 control over what is echoed. It's completely random rather than partially random.

I hope this helps..

[Ph0eniX]

All done and working!

Table Definition:

CREATE TABLE ads (
  adid int(4) NOT NULL auto_increment,
  href varchar(255) default NULL,
  src varchar(255) default NULL,
  description varchar(255) default NULL,
  lastsrv datetime default NULL,
  PRIMARY KEY  (adid)
) TYPE=MyISAM;

Code:

<SCRIPT Language="JavaScript1.2">
if (timeout) {clearTimeout(timeout);}
var timeout = setTimeout("logmeout();", 1000 * 5)
function logmeout() {
    window.self.location.reload();
}
</SCRIPT>
<?php
MYSQL_CONNECT("localhost","user","password");
mysql_select_db("ads");
$query = "SELECT * FROM ads ORDER BY lastsrv LIMIT 1";
$result = mysql_query($query);
$tstamp = date("Y-m-d H:i:s");
while ($row = mysql_fetch_array($result)) { 
$adid = $row[0];
echo "<A href='$row[1]'><IMG border=0 SRC='$row[2]' ALT='$row[3]'></A>";
}
$tstamp = date("Y-m-d H:i:s");
$result = MYSQL_QUERY("UPDATE ads SET lastsrv='$tstamp' where adid='$adid'");
MYSQL_CLOSE();
?>

[ednark]

🆒

[Ph0eniX]

Originally posted by greg252

I started my banner rotation script about 2 months ago and it's still not 100%.

What exactly are trying to put in there? ...and how far did you get?