%
'use some fancy s**t to get the username from the folder. since this is unique then
'we can search the database for that username and find the appropriate ID
'if not found then redirect to the member listing
pathinfo = Request.serverVariables("PATH_INFO")
pathinfo = replace(pathinfo,"/community/","")
pathinfo = replace(pathinfo,"/index.php","")
'check to see if this is a valid user
userID = request.querystring("id")
if userID = "" then
sql = "SELECT * FROM USERS WHERE userName='" & pathinfo & "'"
else
sql = "SELECT * FROM USERS WHERE userID=" & userID
end if
Dim strConn
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("\database/gallery.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open(strConn)
'Get a recordset corresponding to the submitted username and password
Set rsUser = Server.CreateObject("ADODB.Recordset")
rsUser.Open sql, strConn, 3, 3
If NOT rsUser.EOF then
%>
TriniTuner.com - Community
| |
|
|
|
|
| |
© Copyright
2000-2008
Duane Boodasingh, Daren Dhoray and TriniTuner.com
All Rights Reserved
| Legal Statements
|
All rights to this product will be vigorously defended.
Concept & Design by
Duane Boodasingh
Maintainance by
Duane Boodasingh
and Paul Adam.
Programming by Richard WIlliams and Daren Dhoray.
| info@trinituner.com
|
Made
with pride in the Republic of Trinidad & Tobago W.I.
3NE 2NR
& TriniTuner
are registered trademarks of
TriniTuner Co. Ltd.
|
|
|
| |
| |
| |
|
<%
else
response.redirect("index.php?user=false")
end if
%>