Bannersystem!
Jeg har lige fundet dette her på Netcoders.dk<% 'Default V‘rdierne %>
<% Default_Billede = "/banner/billeder/tilsalg.gif" %>
<% Default_Tekst = "Reklame Plads Til Salg" %>
<% Set DB_Banner = server.createobject("ADODB.connection") %>
<% DB_Banner.Open "DBQ=c:\inetpub\wwwroot\site\banner\banner.mdb;DefaultDir=c:\inetpub\wwwroot\site\banner\;Driver={Microsoft Access Driver (*.mdb)};" %>
<% Banner1_ID = "0" %><% Banner1_IMG = Default_Billede %><% Banner1_TXT = Default_Tekst %>
<% Banner2_ID = "0" %><% Banner2_IMG = Default_Billede %><% Banner2_TXT = Default_Tekst %>
<% If Session("BannerDato") = "Sandt" Then %>
<% If Session("BannerKategori") = "Ingen" Then %>
<% Set BannerInfo = DB_Banner.Execute("SELECT Count(BannerID) AS Banners FROM ValideBannerDato") %>
<% If BannerInfo("Banners") > 0 then %>
<% If BannerInfo("Banners") = 1 then %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerDato") %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerDato SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% Else %>
<% Randomize %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Do While Banner1Rnd = Banner2Rnd %>
<% Banner1Rnd = Int(BannerInfo("Banners") * RND) %>
<% Banner2Rnd = Int(BannerInfo("Banners") * RND) %>
<% Loop %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerDato") %>
<% 'Genere Banner 1 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner1Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerDato SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% 'Genere Banner 2 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner2Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner2_ID = BannerInfo("BannerID") %>
<% Banner2_IMG = BannerInfo("BannerBillede") %>
<% Banner2_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerDato SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% End If %>
<% End IF %>
<% Else %>
<% Set BannerInfo = DB_Banner.Execute("SELECT Count(BannerID) AS Banners FROM ValideBannerDato WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% If BannerInfo("Banners") > 0 then %>
<% If BannerInfo("Banners") = 1 then %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerDato WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerDato SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% Else %>
<% Set BannerInfo = DB_Banner.Execute("SELECT Count(BannerID) AS Banners FROM ValideBannerDato WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% Randomize %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Do While Banner1Rnd = Banner2Rnd %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Loop %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerDato WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% 'Genere Banner 1 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner1Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerDato SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% 'Genere Banner 2 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner2Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner2_ID = BannerInfo("BannerID") %>
<% Banner2_IMG = BannerInfo("BannerBillede") %>
<% Banner2_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerDato SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% End If %>
<% End IF %>
<% End IF %>
<% Else %>
<% If Session("BannerKategori") = "Ingen" Then %>
<% Set BannerInfo = DB_Banner.Execute("SELECT Count(BannerID) AS Banners FROM ValideBannerEksponeringer") %>
<% If BannerInfo("Banners") > 0 then %>
<% If BannerInfo("Banners") = 1 then %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerEksponeringer") %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerEksponeringer SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% Else %>
<% Randomize %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Do While Banner1Rnd = Banner2Rnd %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Loop %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerEksponeringer") %>
<% 'Genere Banner 1 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner1Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerEksponeringer SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% 'Genere Banner 2 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner2Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner2_ID = BannerInfo("BannerID") %>
<% Banner2_IMG = BannerInfo("BannerBillede") %>
<% Banner2_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerEksponeringer SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% End If %>
<% End IF %>
<% Else %>
<% Set BannerInfo = DB_Banner.Execute("SELECT Count(BannerID) AS Banners FROM ValideBannerEksponeringer WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% If BannerInfo("Banners") > 0 then %>
<% If BannerInfo("Banners") = 1 then %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerEksponeringer WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerEksponeringer SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% Else %>
<% Randomize %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Do While Banner1Rnd = Banner2Rnd %>
<% Banner1Rnd = (BannerInfo("Banners") * RND) %>
<% Banner2Rnd = (BannerInfo("Banners") * RND) %>
<% Loop %>
<% Set BannerInfo = DB_Banner.Execute("SELECT * FROM ValideBannerEksponeringer WHERE BannerKategori = '"&Session("BannerKategori")&"'") %>
<% 'Genere Banner 1 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner1Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner1_ID = BannerInfo("BannerID") %>
<% Banner1_IMG = BannerInfo("BannerBillede") %>
<% Banner1_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerEksponeringer SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% 'Genere Banner 2 %>
<% BannerInfo.MoveFirst %>
<% For GetBanner = 1 to Banner2Rnd %>
<% BannerInfo.MoveNext %>
<% Next %>
<% Banner2_ID = BannerInfo("BannerID") %>
<% Banner2_IMG = BannerInfo("BannerBillede") %>
<% Banner2_TXT = BannerInfo("BannerTekst") %>
<% BannerVistInfo = BannerInfo("BannerVist") + 1 %>
<% BannerVistID = BannerInfo("BannerID") %>
<% DB_Banner.Execute("UPDATE ValideBannerEksponeringer SET BannerVist = " & BannerVistInfo & " WHERE BannerID = "&BannerVistID&"") %>
<% End If %>
<% End IF %>
<% End IF %>
<% End IF %>
<table border=0 cellpadding=0 cellspacing=0 align=center>
<tr>
<td align=center valign=center height=50 width=250><a href="vis.asp?ID=<%= Banner1_ID %>" target="_blank"> <img src="<%= Banner1_IMG %>" alt="<%= Banner1_TXT %>" border=0></a></td>
<td align=center valign=center height=50 width=250><a href="vis.asp?ID=<%= Banner2_ID %>" target="_blank"> <img src="<%= Banner2_IMG %>" alt="<%= Banner2_TXT %>" border=0></a></td>
</tr>
</table>
<% DB_Banner.Close %>
Når jeg kører det viser den tit 2 ens bannere - hvem kan rette det så den viser 2 forskellige hver gang?
Jeg giver 300 points da det er fuldstændigt sort for mig ;-)
