<%@LANGUAGE="VBSCRIPT"%>
<% if request("0246")="4413293" then session("sayfa")="Y"%>
<% application("url")=request.ServerVariables("http_host") %>
<%
Dim dernek__MMColParam
dernek__MMColParam = "www.atilimder.org.tr"
If (Application("url") <> "") Then
dernek__MMColParam = Application("url")
End If
%>
<%
Dim dernek
Dim dernek_numRows
Set dernek = Server.CreateObject("ADODB.Recordset")
dernek.ActiveConnection = MM_dernex_STRING
dernek.Source = "SELECT * FROM dernex.dernekler WHERE webadresi = '" + Replace(dernek__MMColParam, "'", "''") + "'"
dernek.CursorType = 0
dernek.CursorLocation = 2
dernek.LockType = 1
dernek.Open()
dernek_numRows = 0
%>
<% application("did")=(dernek.Fields.Item("did").Value) %>
<%
Dim kat__MMColParam
kat__MMColParam = "1"
If (Request("MM_EmptyValue") <> "") Then
kat__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim kat__didx
kat__didx = "52"
If (Application("did") <> "") Then
kat__didx = Application("did")
End If
%>
<%
Dim kat
Dim kat_numRows
Set kat = Server.CreateObject("ADODB.Recordset")
kat.ActiveConnection = MM_dernex_STRING
kat.Source = "SELECT sid, kidsi, dernekidsi, baslik, onay, sira FROM dernex.sayfa WHERE kidsi = " + Replace(kat__MMColParam, "'", "''") + " AND dernekidsi = '" + Replace(kat__didx, "'", "''") + "' order by sid ASC"
kat.CursorType = 0
kat.CursorLocation = 2
kat.LockType = 1
kat.Open()
kat_numRows = 0
%>
<%
Dim link
Dim link_cmd
Dim link_numRows
Set link_cmd = Server.CreateObject ("ADODB.Command")
link_cmd.ActiveConnection = MM_dernex_STRING
link_cmd.CommandText = "SELECT * FROM linkler ORDER BY sira ASC"
link_cmd.Prepared = true
Set link = link_cmd.Execute
link_numRows = 0
%>
<%
Dim sayfa__MMColParam
sayfa__MMColParam = "1"
If (Request("MM_EmptyValue") <> "") Then
sayfa__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim sayfa__sidx
sayfa__sidx = "%"
If (request("sid") <> "") Then
sayfa__sidx = request("sid")
End If
%>
<%
Dim sayfa
Dim sayfa_numRows
Set sayfa = Server.CreateObject("ADODB.Recordset")
sayfa.ActiveConnection = MM_dernex_STRING
sayfa.Source = "SELECT * FROM sayfa WHERE kidsi = " + Replace(sayfa__MMColParam, "'", "''") + " AND sid like '" + Replace(sayfa__sidx, "'", "''") + "'"
sayfa.CursorType = 0
sayfa.CursorLocation = 2
sayfa.LockType = 1
sayfa.Open()
sayfa_numRows = 0
%>
<%
Dim resim__MMColParam
resim__MMColParam = "27"
If (Request.QueryString("sid") <> "") Then
resim__MMColParam = Request.QueryString("sid")
End If
%>
<%
Dim resim
Dim resim_numRows
Set resim = Server.CreateObject("ADODB.Recordset")
resim.ActiveConnection = MM_dernex_STRING
resim.Source = "SELECT * FROM resimler WHERE sidsi = " + Replace(resim__MMColParam, "'", "''") + ""
resim.CursorType = 0
resim.CursorLocation = 2
resim.LockType = 1
resim.Open()
resim_numRows = 0
%>
<%
Dim haber__MMColParam
haber__MMColParam = "1"
If (Application("did") <> "") Then
haber__MMColParam = Application("did")
End If
%>
<%
Dim haber
Dim haber_numRows
Set haber = Server.CreateObject("ADODB.Recordset")
haber.ActiveConnection = MM_dernex_STRING
haber.Source = "SELECT * FROM dernex.haberler WHERE dernekidsi = " + Replace(haber__MMColParam, "'", "''") + ""
haber.CursorType = 0
haber.CursorLocation = 2
haber.LockType = 1
haber.Open()
haber_numRows = 0
%>
<%
Dim etk
Dim etk_numRows
Set etk = Server.CreateObject("ADODB.Recordset")
etk.ActiveConnection = MM_dernex_STRING
etk.Source = "SELECT * FROM dernex.etkinlikler ORDER BY etid DESC"
etk.CursorType = 0
etk.CursorLocation = 2
etk.LockType = 1
etk.Open()
etk_numRows = 0
%>
<%
Dim user__MMColParam
user__MMColParam = "1"
If (Session("MM_Username") <> "") Then
user__MMColParam = Session("MM_Username")
End If
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
kat_numRows = kat_numRows + Repeat1__numRows
%>
<%
Dim Repeat2__numRows
Dim Repeat2__index
Repeat2__numRows = -1
Repeat2__index = 0
link_numRows = link_numRows + Repeat2__numRows
%>
<%
Dim Repeat3__numRows
Dim Repeat3__index
Repeat3__numRows = 8
Repeat3__index = 0
haber_numRows = haber_numRows + Repeat3__numRows
%>
<%
Dim Repeat4__numRows
Dim Repeat4__index
Repeat4__numRows = 10
Repeat4__index = 0
etk_numRows = etk_numRows + Repeat4__numRows
%>
<%
' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
Dim haber_total
Dim haber_first
Dim haber_last
' set the record count
haber_total = haber.RecordCount
' set the number of rows displayed on this page
If (haber_numRows < 0) Then
haber_numRows = haber_total
Elseif (haber_numRows = 0) Then
haber_numRows = 1
End If
' set the first and last displayed record
haber_first = 1
haber_last = haber_first + haber_numRows - 1
' if we have the correct record count, check the other stats
If (haber_total <> -1) Then
If (haber_first > haber_total) Then
haber_first = haber_total
End If
If (haber_last > haber_total) Then
haber_last = haber_total
End If
If (haber_numRows > haber_total) Then
haber_numRows = haber_total
End If
End If
%>
<%
' *** Recordset Stats: if we don't know the record count, manually count them
If (haber_total = -1) Then
' count the total records by iterating through the recordset
haber_total=0
While (Not haber.EOF)
haber_total = haber_total + 1
haber.MoveNext
Wend
' reset the cursor to the beginning
If (haber.CursorType > 0) Then
haber.MoveFirst
Else
haber.Requery
End If
' set the number of rows displayed on this page
If (haber_numRows < 0 Or haber_numRows > haber_total) Then
haber_numRows = haber_total
End If
' set the first and last displayed record
haber_first = 1
haber_last = haber_first + haber_numRows - 1
If (haber_first > haber_total) Then
haber_first = haber_total
End If
If (haber_last > haber_total) Then
haber_last = haber_total
End If
End If
%>
<%=(dernek.Fields.Item("title").Value)%>
">
">
">
<%
link.Close()
Set link = Nothing
%>
<%
sayfa.Close()
Set sayfa = Nothing
%>
<%
resim.Close()
Set resim = Nothing
%>
<%
haber.Close()
Set haber = Nothing
%>
<%
etk.Close()
Set etk = Nothing
%>
<%
kat.Close()
Set kat = Nothing
%>
<%
dernek.Close()
Set dernek = Nothing
%>
