<%
Randomize Timer
RGS = Int(Rnd*2)
If RGS = 0 Then
%>
|
F O R U M D A S O N G E L İ Ş M E L E R |
|
Konu
|
Ekleyen
|
Kategori
|
<%
Set ARs = Bag.Execute("(SELECT fldID AS Id, fldSoran AS ekleyen, fldTarih AS tarih, fldKategoriID AS kategori, fldForumID AS forum, fldOnay AS onay FROM tblForum_Sorular WHERE fldOnay=1) UNION (Select fldSoruID AS Id, fldCevaplayan AS ekleyen, fldTarih AS tarih, fldKategoriID AS kategori, fldForumID AS forum, fldOnay AS onay FROM tblForum_Cevaplar WHERE fldOnay=1) ORDER BY tarih DESC LIMIT 5")
Ap = 0
If Not ARs.EOF Then
Do While Not ARs.EOF
Set Rs = Bag.Execute("SELECT * FROM tblForum_Sorular WHERE fldOnay=1 AND fldKilit=0 AND fldSabit=0 AND fldID= " & ARs("Id"))
If Ap Mod 2 = 0 Then
Bg = "#FFFFFF"
Else
Bg = "#FFFAF7"
End If
%>
&forum_id=<%=Rs("fldForumID")%>&konu_id=<%=Rs("fldID")%>" id="Download"><%=IlkHarfBuyuk(Left(Rs("fldSoruBasligi"),33))%> (<%=Left(TimeValue(ARs("tarih")),5)%>)
|
<%=B64Decode(ARs("ekleyen"))%>
|
" id="Download"><%Set Kat = Bag.Execute("SELECT fldKategoriAdi FROM tblForum_Kategoriler WHERE fldID=" & Rs("fldKategoriID")): If Not Kat.EOF Then Response.Write Kat("fldKategoriAdi")%>
|
<%
Ap=Ap+1
ARs.MoveNext
Loop
End If
%>
|
<% Else %>
|
F O R U M D A S O N G E L İ Ş M E L E R |
|
Konu
|
Ekleyen
|
Kategori
|
<%
Set ARs = Bag.Execute("(SELECT fldID AS Id, fldSoran AS ekleyen, fldTarih AS tarih, fldKategoriID AS kategori, fldForumID AS forum, fldOnay AS onay FROM tblForum_Sorular WHERE fldOnay=1) UNION (Select fldSoruID AS Id, fldCevaplayan AS ekleyen, fldTarih AS tarih, fldKategoriID AS kategori, fldForumID AS forum, fldOnay AS onay FROM tblForum_Cevaplar WHERE fldOnay=1) ORDER BY tarih DESC LIMIT 5")
Ap = 0
If Not ARs.EOF Then
Do While Not ARs.EOF
Set Rs = Bag.Execute("SELECT * FROM tblForum_Sorular WHERE fldOnay=1 AND fldKilit=0 AND fldSabit=0 AND fldID= " & ARs("Id"))
If Ap Mod 2 = 0 Then
Bg = "#FFFFFF"
Else
Bg = "#FFFAF7"
End If
%>
&forum_id=<%=Rs("fldForumID")%>&konu_id=<%=Rs("fldID")%>" id="Download"><%=IlkHarfBuyuk(Left(Rs("fldSoruBasligi"),33))%> (<%=Left(TimeValue(ARs("tarih")),5)%>)
|
<%=B64Decode(ARs("ekleyen"))%>
|
" id="Download"><%Set Kat = Bag.Execute("SELECT fldKategoriAdi FROM tblForum_Kategoriler WHERE fldID=" & Rs("fldKategoriID")): If Not Kat.EOF Then Response.Write Kat("fldKategoriAdi")%>
|
<%
Ap=Ap+1
ARs.MoveNext
Loop
End If
%>
|
<% End If %>
<%=DikeyBol%>
|
<%
Linkler = Array("Ülke Yazıları|ulke_yazilari.asp", "Anadolu Yazıları|anadolu_yazilari.asp", "Editör Yazıları|editor.asp", "Köşe Yazıları|kose_yazilari.asp", "Modern Batının İlkel Tarihi|modern_bati.asp", "Seyahat Fotoğrafları|seyahat_fotolari.asp", "Nostaljik Kartpostallar|nostaljik.asp", "İlginç Seyahat Notları|ilginc_notlar.asp", "Dünyadan İlginç Siteler|ilginc_siteler.asp", "Şiirler|siirler.asp", "Fıkralar|fikralar.asp", "Dünyadan İlginç Kanunlar|ilginc_kanunlar.asp", "İlginç Bilgiler|ilginc_bilgiler.asp", "Basit Çince|cince.asp", "Göz Yanılmaları|goz_yanilmalari.asp", "Seyahat Tavsiyeleri|tavsiye.asp", "Seyahat Listesi|seyahat_liste.asp", "Havayolu Şirketleri|havayolu.asp", "Download|download.asp", "Üyelik|uyelik.asp|b", "Webmaster Özel|webmaster.asp", "Misafir Defteri|zdefter.asp","Forum|forum")
LinkSayisi = UBound(Linkler)
Randomize Timer
Sayi = Int(Rnd*LinkSayisi)
Response.Write "LİNK: " & IlkHarfBuyuk(Split(Linkler(Sayi),"|",-1,1)(0)) & " "
Set Rs = Bag.Execute("SELECT * FROM tblDownload WHERE fldDurum=1 ORDER BY RAND()")
Response.Write "MP3: " & IlkHarfBuyuk(Rs("fldMP3Adi")) & " "
Set Rs = Bag.Execute("SELECT * FROM tblEditorYazilari WHERE fldDurum=1 ORDER BY RAND()")
Response.Write "EDİTÖR YAZISI: " & IlkHarfBuyuk(Rs("fldBaslik")) & " "
Set Rs = Bag.Execute("SELECT * FROM tblFikralar WHERE fldDurum=1 ORDER BY RAND()")
Response.Write "FIKRA: " & IlkHarfBuyuk(Rs("fldBaslik")) & " "
Set Rs = Bag.Execute("SELECT * FROM tblIlgincSiteler WHERE fldDurum=1 ORDER BY RAND()")
Response.Write "İLGİNÇ SİTE: " & IlkHarfBuyuk(Rs("fldSiteAdi")) & " "
Set Rs = Bag.Execute("SELECT * FROM tblKoseYazilari WHERE fldOnay=1 ORDER BY RAND()")
Response.Write "KÖŞE YAZISI: " & IlkHarfBuyuk(Rs("fldBaslik")) & " "
Set Rs = Bag.Execute("SELECT * FROM tblSiirler WHERE fldDurum=1 ORDER BY RAND()")
Response.Write "ŞİİR: " & IlkHarfBuyuk(Rs("fldBaslik")) & " "
Set Rs = Bag.Execute("SELECT * FROM tblUlkeYazilari WHERE fldDurum=1 ORDER BY RAND()")
Response.Write "ÜLKE YAZILARI: " & IlkHarfBuyuk(Rs("fldBaslik")) & " "
%>
|
|