<% Function cevir(yazi) yazi=RTRim(yazi) yazi=Ltrim(yazi) yazi = Replace(yazi, " ", " ") yazi = Replace(yazi, " ", "_") yazi = Replace(yazi, "’", "_") yazi = Replace(yazi, "i", "i") yazi = Replace(yazi, "I", "I") yazi = Replace(yazi, "ö", "o") yazi = Replace(yazi, "ü", "u") yazi = Replace(yazi, "g", "g") yazi = Replace(yazi, "s", "s") yazi = Replace(yazi, "ç", "c") yazi = Replace(yazi, "Ö", "O") yazi = Replace(yazi, "Ü", "U") yazi = Replace(yazi, "S", "S") yazi = Replace(yazi, "G", "G") yazi = Replace(yazi, "Ç", "C") yazi = Replace(yazi, "&", "-") yazi = Replace(yazi, "%", "-") yazi = Replace(yazi, "/", "-") yazi = Replace(yazi, "-", "_") yazi = Replace(yazi, "__", "_") yazi = Replace(yazi, "__", "_") cevir = yazi End Function%> <% Function cevirsektor(yazi) yazi=RTRim(yazi) yazi=Ltrim(yazi) yazi = Replace(yazi, " ", " ") yazi = Replace(yazi, " ", "_") yazi = Replace(yazi, "’", "_") yazi = Replace(yazi, "i", "i") yazi = Replace(yazi, "I", "I") yazi = Replace(yazi, "ö", "o") yazi = Replace(yazi, "ü", "u") yazi = Replace(yazi, "g", "g") yazi = Replace(yazi, "s", "s") yazi = Replace(yazi, "ç", "c") yazi = Replace(yazi, "Ö", "O") yazi = Replace(yazi, "Ü", "U") yazi = Replace(yazi, "S", "S") yazi = Replace(yazi, "G", "G") yazi = Replace(yazi, "Ç", "C") yazi = Replace(yazi, "&", "-") yazi = Replace(yazi, "%", "-") yazi = Replace(yazi, "/", "-") yazi = Replace(yazi, "-", "_") yazi = Replace(yazi, "__", "_") yazi = Replace(yazi, "__", "_") cevirsektor = yazi End Function%> <%Function sektorbul2(sektorkodu) sektorkodu=PostKontrol(sektorKodu) sorgum="Select * from sektor where skodu="&sektorkodu Rx.Open Sorgum, Baglantim, 1, 3 if Rx.eof then sektorkodu="Kategori Bulunamadi." else sektorkodu=rx("Adi") end if rx.close sektorbul2=sektorkodu End Function %> <%Function firmabul2(Firmakodu) Firmakodu=PostKontrol(FirmaKodu) sorgum="Select * from Firma where Fkodu="&Firmakodu Rx.Open Sorgum, Baglantim, 1, 3 if Rx.eof then firmakodu="Üye Bulunamadi." else firmakodu=rx("Adi") end if rx.close firmabul2=firmakodu End Function %> <% Function Temizle(yazi) yazi = Replace(yazi, "<", "") yazi = Replace(yazi, ">", "") yazi = Replace(yazi, "+", "") yazi = Replace(yazi, "(", "") yazi = Replace(yazi, ")", "") yazi = Replace(yazi, ";", "") yazi = Replace(yazi, ":", "") yazi = Replace(yazi, "'", "'") yazi = Replace(yazi, "", "") yazi = Replace(yazi, ",", "") yazi = Replace(yazi, "script", "script", 1, -1, 0) yazi = Replace(yazi, "SCRIPT", "SCRIPT", 1, -1, 0) yazi = Replace(yazi, "Script", "Script", 1, -1, 0) yazi = Replace(yazi, "script", "Script", 1, -1, 1) yazi = Replace(yazi, "object", "object", 1, -1, 0) yazi = Replace(yazi, "OBJECT", "OBJECT", 1, -1, 0) yazi = Replace(yazi, "Object", "Object", 1, -1, 0) yazi = Replace(yazi, "object", "Object", 1, -1, 1) yazi = Replace(yazi, "applet", "applet", 1, -1, 0) yazi = Replace(yazi, "APPLET", "APPLET", 1, -1, 0) yazi = Replace(yazi, "Applet", "Applet", 1, -1, 0) yazi = Replace(yazi, "applet", "Applet", 1, -1, 1) yazi = Replace(yazi, "embed", "embed", 1, -1, 0) yazi = Replace(yazi, "EMBED", "EMBED", 1, -1, 0) yazi = Replace(yazi, "Embed", "Embed", 1, -1, 0) yazi = Replace(yazi, "embed", "Embed", 1, -1, 1) yazi = Replace(yazi, "event", "event", 1, -1, 0) yazi = Replace(yazi, "EVENT", "EVENT", 1, -1, 0) yazi = Replace(yazi, "Event", "Event", 1, -1, 0) yazi = Replace(yazi, "event", "Event", 1, -1, 1) yazi = Replace(yazi, "document", "document", 1, -1, 0) yazi = Replace(yazi, "DOCUMENT", "DOCUMENT", 1, -1, 0) yazi = Replace(yazi, "Document", "Document", 1, -1, 0) yazi = Replace(yazi, "document", "Document", 1, -1, 1) yazi = Replace(yazi, "cookie", "cookie", 1, -1, 0) yazi = Replace(yazi, "COOKIE", "COOKIE", 1, -1, 0) yazi = Replace(yazi, "Cookie", "Cookie", 1, -1, 0) yazi = Replace(yazi, "cookie", "Cookie", 1, -1, 1) yazi = Replace(yazi, "form", "form", 1, -1, 0) yazi = Replace(yazi, "FORM", "FORM", 1, -1, 0) yazi = Replace(yazi, "Form", "Form", 1, -1, 0) yazi = Replace(yazi, "form", "Form", 1, -1, 1) yazi = Replace(yazi, "document.cookie", "Document.cookie", 1, -1, 1) yazi = Replace(yazi, "javascript:", "javascript ", 1, -1, 1) yazi = Replace(yazi, "vbscript:", "vbscript ", 1, -1, 1) yazi = Replace(yazi, "union", "") yazi = Replace(yazi, "select", "") yazi = Replace(yazi, "from", "") yazi = Replace(yazi, "UNION", "") yazi = Replace(yazi, "SELECT", "") yazi = Replace(yazi, "sifre", "") yazi = Replace(yazi, "admin", "") yazi = Replace(yazi, vbCrLf, "") Yol = Request.ServerVariables("URL") s1 = InStr(1,yazi,"+") s2 = InStr(1,yazi,"admin") if s1<>0 or s2<>0 then Response.Redirect("/uyari") End if Temizle = yazi End Function%> <% Function PostKontrol(yazi) s1 = InStr(1,yazi, "<") s2 = InStr(1,yazi, ">") s3 = InStr(1,yazi, "+") s4 = InStr(1,yazi, "(") s5 = InStr(1,yazi, ")") s6 = InStr(1,yazi, ";") s7 = InStr(1,yazi, ":") s8 = InStr(1,yazi, "'") s9 = InStr(1,yazi, "SELECT") s10 = InStr(1,yazi, ",") s11 = InStr(1,yazi, "script") s12 = InStr(1,yazi, "SCRIPT") s13 = InStr(1,yazi, "Script") s14 = InStr(1,yazi, "script") s15 = InStr(1,yazi, "object") s16 = InStr(1,yazi, "OBJECT") s17 = InStr(1,yazi, "Object") s18 = InStr(1,yazi, "object") s19 = InStr(1,yazi, "applet") s20 = InStr(1,yazi, "APPLET") s21 = InStr(1,yazi, "Applet") s22 = InStr(1,yazi, "applet") s23 = InStr(1,yazi, "embed") s24 = InStr(1,yazi, "EMBED") s25 = InStr(1,yazi, "Embed") s26 = InStr(1,yazi, "embed") s27 = InStr(1,yazi, "event") s28 = InStr(1,yazi, "EVENT") s29 = InStr(1,yazi, "Event") s30 = InStr(1,yazi, "event") s31 = InStr(1,yazi, "document") s32 = InStr(1,yazi, "DOCUMENT") s33 = InStr(1,yazi, "Document") s34 = InStr(1,yazi, "document") s35 = InStr(1,yazi, "cookie") s36 = InStr(1,yazi, "COOKIE") s37 = InStr(1,yazi, "Cookie") s38 = InStr(1,yazi, "cookie") s39 = InStr(1,yazi, "form") s40 = InStr(1,yazi, "FORM") s41 = InStr(1,yazi, "Form") s42 = InStr(1,yazi, "form") s43 = InStr(1,yazi, "document.cookie") s44 = InStr(1,yazi, "javascript:") s45 = InStr(1,yazi, "vbscript:") s46 = InStr(1,yazi, "union") s47 = InStr(1,yazi, "select") s48 = InStr(1,yazi, "from") s49 = InStr(1,yazi, "UNION") if s1<>0 or s2<>0 or s3<>0 or s4<>0 or s5<>0 or s6<>0 or s7<>0 or s8<>0 or s9<>0 or s10<>0 then Response.Redirect("uyari.asp") Elseif s11<>0 or s12<>0 or s13<>0 or s14<>0 or s15<>0 or s16<>0 or s17<>0 or s18<>0 or s19<>0 or s20<>0 then Response.Redirect("uyari.asp") Elseif s21<>0 or s22<>0 or s23<>0 or s24<>0 or s25<>0 or s26<>0 or s27<>0 or s28<>0 or s29<>0 or s30<>0 then Response.Redirect("uyari.asp") Elseif s31<>0 or s32<>0 or s33<>0 or s34<>0 or s35<>0 or s36<>0 or s37<>0 or s38<>0 or s39<>0 or s40<>0 then Response.Redirect("uyari.asp") Elseif s40<>0 or s41<>0 or s42<>0 or s43<>0 or s44<>0 or s45<>0 or s46<>0 or s47<>0 or s48<>0 or s49<>0 then Response.Redirect("uyari.asp") End if yazi = Replace(yazi, "<", "") yazi = Replace(yazi, ">", "") yazi = Replace(yazi, "+", "") yazi = Replace(yazi, "(", "") yazi = Replace(yazi, ")", "") yazi = Replace(yazi, ";", "") yazi = Replace(yazi, ":", "") yazi = Replace(yazi, "'", "'") yazi = Replace(yazi, "", "") yazi = Replace(yazi, ",", "") yazi = Replace(yazi, "script", "script", 1, -1, 0) yazi = Replace(yazi, "SCRIPT", "SCRIPT", 1, -1, 0) yazi = Replace(yazi, "Script", "Script", 1, -1, 0) yazi = Replace(yazi, "script", "Script", 1, -1, 1) yazi = Replace(yazi, "object", "object", 1, -1, 0) yazi = Replace(yazi, "OBJECT", "OBJECT", 1, -1, 0) yazi = Replace(yazi, "Object", "Object", 1, -1, 0) yazi = Replace(yazi, "object", "Object", 1, -1, 1) yazi = Replace(yazi, "applet", "applet", 1, -1, 0) yazi = Replace(yazi, "APPLET", "APPLET", 1, -1, 0) yazi = Replace(yazi, "Applet", "Applet", 1, -1, 0) yazi = Replace(yazi, "applet", "Applet", 1, -1, 1) yazi = Replace(yazi, "embed", "embed", 1, -1, 0) yazi = Replace(yazi, "EMBED", "EMBED", 1, -1, 0) yazi = Replace(yazi, "Embed", "Embed", 1, -1, 0) yazi = Replace(yazi, "embed", "Embed", 1, -1, 1) yazi = Replace(yazi, "event", "event", 1, -1, 0) yazi = Replace(yazi, "EVENT", "EVENT", 1, -1, 0) yazi = Replace(yazi, "Event", "Event", 1, -1, 0) yazi = Replace(yazi, "event", "Event", 1, -1, 1) yazi = Replace(yazi, "document", "document", 1, -1, 0) yazi = Replace(yazi, "DOCUMENT", "DOCUMENT", 1, -1, 0) yazi = Replace(yazi, "Document", "Document", 1, -1, 0) yazi = Replace(yazi, "document", "Document", 1, -1, 1) yazi = Replace(yazi, "cookie", "cookie", 1, -1, 0) yazi = Replace(yazi, "COOKIE", "COOKIE", 1, -1, 0) yazi = Replace(yazi, "Cookie", "Cookie", 1, -1, 0) yazi = Replace(yazi, "cookie", "Cookie", 1, -1, 1) yazi = Replace(yazi, "form", "form", 1, -1, 0) yazi = Replace(yazi, "FORM", "FORM", 1, -1, 0) yazi = Replace(yazi, "Form", "Form", 1, -1, 0) yazi = Replace(yazi, "form", "Form", 1, -1, 1) yazi = Replace(yazi, "document.cookie", "Document.cookie", 1, -1, 1) yazi = Replace(yazi, "javascript:", "javascript ", 1, -1, 1) yazi = Replace(yazi, "vbscript:", "vbscript ", 1, -1, 1) yazi = Replace(yazi, "union", "") yazi = Replace(yazi, "select", "") yazi = Replace(yazi, "from", "") yazi = Replace(yazi, "UNION", "") yazi = Replace(yazi, "SELECT", "") yazi = Replace(yazi, "sifre", "") yazi = Replace(yazi, "admin", "") yazi = Replace(yazi, vbCrLf, "") PostKontrol = yazi End Function%> <% Function Sektor_listele() sorgum="Select * from sektor order by adi asc" Rf.Open Sorgum, Baglantim, 1, 3 do while not Rf.eof %>
-<%=cevir(rf("adi"))%>.html"><%= rf("adi") %>
<%Rf.movenext loop Rf.close End Function %> <% Function kategori_listele() sorgum="Select * from sektor order by adi asc" Rf.Open Sorgum, Baglantim, 1, 3 i=0%> <%do while not Rf.eof i=i+1 if rf.eof then exit do %> <% if i=4 then %> <% i=0 end if Rf.movenext loop Rf.close %>
-<%=cevir(rf("adi"))%>.html"><%= rf("adi") %>
<% End Function %> <% Function Altsektor_listele(skodu) skodu=PostKontrol(skodu) sorgum="Select * from altsektor where skodu="&skodu Rf.Open Sorgum, Baglantim, 1, 3 i=1 %> <% do while not Rf.eof i=i+1 %> <% if i mod 2 then %> <% end if %> <%Rf.movenext loop Rf.close %>
<% End Function %> <% Function Altsektor_adibul(askodu) askodu=PostKontrol(askodu) sorgum="Select * from altsektor where askodu="&askodu Rf.Open Sorgum, Baglantim, 1, 3 i=1 %> <%= PostKontrol(rf("adi")) %> <% Rf.close %> <% End Function %> <% Function Altsektoradibul(askodu) altkodu=PostKontrol(altkodu) sorgum="Select * from altsektor where askodu="&askodu Ru.Open Sorgum, Baglantim, 1, 3 %> <%Altsektoradibul=ru("adi") %> <% Ru.close %> <% End Function %> <% Function Altsektor_liste(skodu) skodu=PostKontrol(skodu) sorgum="Select * from altsektor where skodu="&skodu Rf.Open Sorgum, Baglantim, 1, 3 i=0 %> <% do while not Rf.eof i=i+1 %> <% if i=4 then %> <% i=0 end if %> <%Rf.movenext loop Rf.close %>
<% End Function %> <% Function Firma_sayisi(skodu) skodu=PostKontrol(skodu) Sorgum="select * from firma where onay=true and skodu="&skodu Rfs.Open Sorgum, Baglantim, 1, 3 Response.Write rfs.recordcount Rfs.close End Function %> <% Function altfirma_sayisi(askodu) Sorgum="select * from firma where onay=true and askodu LIKE '%"&askodu&"%'" Ras.Open Sorgum, Baglantim, 1, 3 Response.Write ras.recordcount Ras.close End Function %> <% Function Firma_listele(skodu,askodu,ara) skodu=PostKontrol(skodu) askodu=PostKontrol(askodu) ara=PostKontrol(ara) if askodu<>"" then Sorgum="select * from firma where onay=true and askodu LIKE '%"&askodu&"%'" else Sorgum="select * from firma where onay=true and skodu="&skodu end if if ara<>"" then Sorgum="select * from firma where onay=true and adi LIKE '%"&ara&"%'"&" or yetkili LIKE '%"&ara&"%'"&" or aciklama LIKE '%"&ara&"%'" end if Rf.Open Sorgum, Baglantim, 1, 3 if Rf.eof or Rf.bof then Response.Write("
Kayitli Firma Bulunamadi.
") else do while not Rf.eof %> -<%=cevir(rs("adi"))%>.html">
<% if Rf("logo")<>"" then %> <% Path = Server.URLEncode(Server.MapPath(Rf("logo"))) %> -<%=cevir(rs("adi"))%>.html"> <% else %> <% end if %> <%= Rf("adi") %> ( <%= Rf("yetkili") %> )
<%= left( rf("aciklama"),250) %>...
<%= Rf("adresi") %>
Tel:<%= Rf("telefon") %>    <% if rf("ozel")=true then %> ','','resizable=yes,status=yes,width=800,height=600')"> <% else %> -<%=cevir(rs("adi"))%>.html"> <% end if %>   Web : <%= Rf("www") %>
<% Rf.movenext loop end if Rf.close End Function %> <%Function gununsozu(x) ay=month(Now) gun=day(now) sorgum="Select * from olay where ay="&"'"&ay&"'"&" and gun="&"'"&gun&"'" Rf.Open Sorgum, Baglantim, 1, 3 %> <% if x="soz" then %> <%= rf("soz") %> <% end if%> <% if x="olay" then %>
  • <%= rf("olay1")&"
    " %>
  • <%= rf("olay2")&"
    " %>
  • <%= rf("olay3")&"
    " %>
  • <% end if %> <% rf.close %> <% End Function %> <% Function ozel_listele() sorgum="select * from firma where ozel=true" Rf.Open Sorgum, Baglantim, 1, 3 if Rf.eof or Rf.bof then Response.Write("Kayit Bulunamadi") else %> <% cellcolor="EEEEEE"%> <% do while not Rf.eof %> <%Rf.movenext loop Rf.close %>

    ...:: ÖZEL FİRMALAR::..

    <%=Rf("adi") %> <%=Rf("adresi") %>   <%=rf("sehir") %> <%=Rf("telefon") %>
    Özel Kayitli Firma : <%= Rf.recordcount %>
    <% end if End Function %> <% Function arama_listele(deger) deger=PostKontrol(deger) sorgum="select * from firma where adi LIKE '%" & deger & "%'"&" or yetkili LIKE '%" & deger & "%'"&" or adresi LIKE '%" & deger & "%'" &" or sehir LIKE '%" & deger & "%'" &" or bilgi LIKE '%" & deger & "%'" Rf.Open Sorgum, Baglantim, 1, 3 if Rf.eof or Rf.bof then Response.Write("Kayit Bulunamadi") else %> <% cellcolor="EEEEEE"%> <% do while not Rf.eof %> <%Rf.movenext loop Rf.close %>

    ...:: ARAMA SONUÇLARI ::..

    <%=Rf("adi") %> <%=Rf("adresi") %>   <%=rf("sehir") %> <%=Rf("telefon") %>
    Bulunan Firma Sayısı : <%= Rf.recordcount %>
    <% end if End Function %> <% Function sektor_combo() sorgum="Select * from sektor" Rf.Open Sorgum, Baglantim, 1, 3 %> <% rf.close End Function %> <% Function altsektor_combo(skodu) skodu=PostKontrol(skodu) sorgum="Select * from altsektor where skodu='"&skodu&"'" Rf.Open Sorgum, Baglantim, 1, 3 %> <% rf.close End Function %> <% Function altsektor_sec(sektor) sektor=PostKontrol(sektor) sorgum="Select * from altsektor where SKODU='"&sektor&"'" Rf.Open Sorgum, Baglantim, 1, 3 %> <% do while not rf.eof %> "><%= rf("adi") %>
    <% rf.movenext loop Rf.close %> <% End Function %> <% Function menu_yaz() sorgum="Select * from sayfa where (id<>10 and id<>11) and goster=true" Rf.Open Sorgum, Baglantim, 1, 3 %> <% do while not rf.eof %> <% rf.movenext loop Rf.close %>
    <% End Function %> <% Function eczane_yaz() sorgum="Select * from eczane where gun="&day(now()) Rf.Open Sorgum, Baglantim, 1, 3 if not rf.eof then do while not rf.eof Response.Write ""&rf("adi")&"
    "&rf("telefon")&"
    "&rf("adres")&"
    " rf.movenext loop else Response.Write("Eczaneler Kapali") end if Rf.close End Function %> <% Function ilanadi(kod) kod=PostKontrol(kod) select case kod case "" Response.Write("Ilan Katagorisi Bulunmadi") case "1" Response.Write("Eleman Arayanlar") case "2" Response.Write("Is Arayanlar") case "3" Response.Write("Bilgisayar - Elektronik") case "4" Response.Write("Araba - Vasita") case "5" Response.Write("Emlak - Kiralik") case "6" Response.Write("Emlak - Satilik") case "10" Response.Write("Diger") end select End Function Function reklam_goster(id) id=PostKontrol(id) sorgum="Select * from reklam where id="&id Rx.Open Sorgum, Baglantim, 1, 3 bittarihi=cdate(rx("bitis")) if bittarihi>date() then if rx("detay")<>"" then Response.Write rx("detay") else Response.Write siteadi end if else response.write("
    Bu Reklamın Süresi Dolmuştur.
    Reklam Ayarlarını Düzenleyiniz.
    ") end if Rx.close End Function Function sayfa_goster(id) id=PostKontrol(id) sorgum="Select * from sayfa where id="&id Rx.Open Sorgum, Baglantim, 1, 3 if rx.eof or rx.bof then Response.Write("
    Kayit Bulamadim
    ") else Response.Write rx("detay") end if Rx.close End Function Function sayfa_baslik(id) id=PostKontrol(id) sorgum="Select * from sayfa where id="&id Rx.Open Sorgum, Baglantim, 1, 3 if rx.eof or rx.bof then Response.Write("Sayfa Kaldirilmis...") else Response.Write rx("adi") end if Rx.close End Function Function haber_sayisi() sorgum="Select * from haber where goster=true" Rx.Open Sorgum, Baglantim, 1, 3 Response.Write rx.recordcount Rx.close End Function Function hesapla_sektor(sektor) sektro=PostKontrol(sektor) tablo="firma" sorgum="Select * from "&tablo&" where Skodu="&sektor&" and onay=true" Rx.Open Sorgum, Baglantim, 1, 3 Response.Write Rx.recordcount Rx.close End Function Function hesapla_altsektor(altsektor) altsektor=PostKontrol(altsektor) tablo="firma" sorgum="Select * from "&tablo&" where askodu like '%"&altsektor &"%'"&" and onay=true" Rx.Open Sorgum, Baglantim, 1, 3 Response.Write Rx.recordcount Rx.close End Function Function hesapla_talep(sektor) sektor=PostKontrol(sektor) sorgum="Select * from talepler where Skodu="&sektor Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function Function hesapla_urun(sektor) sektor=PostKondtrol(sektor) Set Rx=Server.CreateObject("Adodb.Recordset") sorgum="Select * from urun where Skodu="&sektor Rx.Open Sorgum, Baglantim, 1, 3 Response.Write Rx.recordcount Rx.close End Function Function hesapla_talep_alt(kodu) kodu=PostKontrol(kodu) tablo="talepler" sorgum="Select * from "&tablo&" where Altsektor="&kodu Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function Function ozel_firma() sorgum="Select * from firma where ozel=true" Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function Function normal_firma() sorgum="Select * from firma" Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function %> <%Function firmabul(Fkodu) Fkodu=PostKontrol(FKodu) sorgum="Select * from Firma where Fkodu="&Fkodu Ru.Open Sorgum, Baglantim, 1, 3 if Ru.eof then Response.Write("Firma Bulunamadi") else Response.Write(ru("Adi")) end if ru.close End Function %> <%Function firmabultel(Fkodu) Fkodu=PostKontrol(Fkodu) sorgum="Select * from Firma where Fkodu="&Fkodu Rx.Open Sorgum, Baglantim, 1, 3 if Rx.eof then Response.Write("::") else Response.Write(rx("telefon")) end if rx.close End Function %> <%Function sektorbul(sektor) sektor=PostKontrol(sektor) sorgum="Select * from sektor where skodu="&sektor Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf("Adi") Rf.close End Function Function altsektorbul(altsektor) altsektor=PostKontrol(altsektor) sorgum="Select * from altsektor where askodu='"&altsektor&"'" Ru.Open Sorgum, Baglantim, 1, 3 altsektorbul=Ru("Adi") Ru.close End Function Function firma_toplami() sorgum="Select * from firma " Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function Function urun_toplami(sektor) sektor=PostKontrol(sektor) sorgum="Select * from urun " Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function Function talep_toplami(sektor) sektor=PostKontrol(sektor) sorgum="Select * from talep " Rf.Open Sorgum, Baglantim, 1, 3 Response.Write Rf.recordcount Rf.close End Function Function say(cookle) sorgum="Select * from sayac " Rf.Open Sorgum, Baglantim, 1, 3 if cookle<>"ekle" then x=rf("cogul") x=x+1 rf("cogul")=x Rf.update Response.Write rf("cogul") end if Rf.close End Function %> <% Function sayfa_numarasi()%>
    <%= shf %>

    <% onceki=shf-1%> <%if shf=1 then%> «« <%else%> «« <%end if%>  | <%if onceki<1 then%> « <%else%> « <%end if%>  |  <% for y=1 to sayfa %> <% x=x+1 if shf=y then response.write ""&y&" | " else%> <%=y%> |  <% end if if x>18 then response.write ("
    ") x=0 end if next sonraki=shf+1 if sonraki>sayfa then %> » <%else%> » <%end if%>  |  <%if shf=sayfa then%> »» <%else%> »» <%end if%>
    <% End Function %> <%function resme_yazi_yaz(resim) Set Jpeg = Server.CreateObject("Persits.Jpeg") Path = Server.MapPath(""&resim &"") '{Burasi resimlerimizi depoladigimiz alan Server'daki.} Jpeg.Open Path Jpeg.Canvas.Font.Color = &HFF0000 '{Yazinin Font Rengi} Jpeg.Canvas.Font.Family = "Verdana" '{Yazimizin Türünü belirliyoruz} Jpeg.Canvas.Font.Bold = TRUE '{Kalin veya normal yazim özelligi} Jpeg.Canvas.Pen.Color = &H000000 '{Yazi rengi} Jpeg.Canvas.Pen.Width = 1 '{Yazi Kalinlik} jpeg.Canvas.Font.Size = 20 '{Yazinin büyüklügü} Jpeg.Canvas.Brush.Solid = False '{Firça Baski Sekli} Jpeg.Canvas.PrintText 1, 180, ""&siteadi&"" Jpeg.Save Server.MapPath(""&resim &"") '{Resimler klasörümüzün altina .jpg uzantili resmimizin adini yazdiriyoruz.} end function%> <%function yazar_bul(yid) set yazaRbul =veri.execute("select * from yazar where durum<>1 and id="&yid) if yazarbul.eof then response.write("Yazar Bulunamadi.") else response.write(yazarbul("ad_soyad")) end if yazarbul.close end function%> <% Function bcevir(metin) metin = Replace(metin, "a", "A") metin = Replace(metin, "b", "B") metin = Replace(metin, "c", "C") metin = Replace(metin, "ç", "Ç") metin = Replace(metin, "d", "D") metin = Replace(metin, "e", "E") metin = Replace(metin, "f", "F") metin = Replace(metin, "g", "G") metin = Replace(metin, "g", "G") metin = Replace(metin, "h", "H") metin = Replace(metin, "i", "I") metin = Replace(metin, "i", "I") metin = Replace(metin, "j", "K") metin = Replace(metin, "k", "K") metin = Replace(metin, "l", "L") metin = Replace(metin, "m", "M") metin = Replace(metin, "n", "N") metin = Replace(metin, "o", "O") metin = Replace(metin, "ö", "Ö") metin = Replace(metin, "p", "P") metin = Replace(metin, "r", "R") metin = Replace(metin, "s", "S") metin = Replace(metin, "s", "S") metin = Replace(metin, "t", "T") metin = Replace(metin, "u", "U") metin = Replace(metin, "ü", "Ü") metin = Replace(metin, "v", "V") metin = Replace(metin, "w", "W") metin = Replace(metin, "x", "X") metin = Replace(metin, "y", "Y") metin = Replace(metin, "z", "Z") bcevir = metin End Function Function kcevir(kelime) kelime = Replace(kelime, "A", "a") kelime = Replace(kelime, "B", "b") kelime = Replace(kelime, "C", "c") kelime = Replace(kelime, "Ç", "ç") kelime = Replace(kelime, "D", "d") kelime = Replace(kelime, "E", "e") kelime = Replace(kelime, "F", "f") kelime = Replace(kelime, "G", "g") kelime = Replace(kelime, "G", "g") kelime = Replace(kelime, "H", "h") kelime = Replace(kelime, "I", "i") kelime = Replace(kelime, "I", "i") kelime = Replace(kelime, "J", "j") kelime = Replace(kelime, "K", "k") kelime = Replace(kelime, "L", "l") kelime = Replace(kelime, "M", "m") kelime = Replace(kelime, "N", "n") kelime = Replace(kelime, "O", "o") kelime = Replace(kelime, "Ö", "ö") kelime = Replace(kelime, "P", "p") kelime = Replace(kelime, "R", "r") kelime = Replace(kelime, "S", "s") kelime = Replace(kelime, "S", "s") kelime = Replace(kelime, "T", "t") kelime = Replace(kelime, "U", "u") kelime = Replace(kelime, "Ü", "ü") kelime = Replace(kelime, "V", "v") kelime = Replace(kelime, "W", "w") kelime = Replace(kelime, "X", "x") kelime = Replace(kelime, "Y", "y") kelime = Replace(kelime, "Z", "z") Kcevir = kelime End Function%>