Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Forum Login Tool from other folder
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum Login Tool from other folder

 Post Reply Post Reply
Author
leiti View Drop Down
Groupie
Groupie


Joined: 16 February 2005
Status: Offline
Points: 65
Post Options Post Options   Thanks (0) Thanks(0)   Quote leiti Quote  Post ReplyReply Direct Link To This Post Topic: Forum Login Tool from other folder
    Posted: 04 November 2007 at 7:59pm

Hello,

i have the following problem. in one folder I have installed webwiz forum, in another there is an application.

i want to user the quik login cookie as login for the other application. is this possible and how would this work?

thanks for your help!

Back to Top
leiti View Drop Down
Groupie
Groupie


Joined: 16 February 2005
Status: Offline
Points: 65
Post Options Post Options   Thanks (0) Thanks(0)   Quote leiti Quote  Post ReplyReply Direct Link To This Post Posted: 05 November 2007 at 6:16am
I tried it with the following self written function.
 
Problem: I think I can't read webwiz Cookies?
 
FUNCTION loginForum()
 strLoggedInUserCode = Trim(Mid(Request.Cookies("WWFsLID")("UID"), 1, 44))
 If NOT strLoggedInUserCode = "" Then
 
  Set ConnF = Server.CreateObject("ADODB.Connection")                                               
  ConnF.Open(strConnForum) 
 
  'Initalise the strSQL variable with an SQL statement to query the database
  strSQL = "SELECT tblAuthor.Username, tblAuthor.Author_ID, tblAuthor.Group_ID, tblAuthor.Active, tblAuthor.Banned, " & _
  "FROM tblAuthor, tblGroup " & _
  "WHERE tblAuthor.Group_ID  = tblGroup.Group_ID " & _
   "AND tblAuthor.User_code = '" & strLoggedInUserCode & "';"
 
  set rsForumUser = ConnF.Execute(strSQL)
 
  'If the database has returned a record then run next bit
  If NOT rsForumUser.EOF Then
 
   'Read in the users details from the recordset
   strLoggedInUsername = rsForumUser("Username")
   intGroupID = rsForumUser("Group_ID")
   lngLoggedInUserID = CLng(rsForumUser("Author_ID"))
   blnActiveMember = CBool(rsForumUser("Active"))
   blnBanned = CBool(rsForumUser("Banned"))
   
   If blnActiveMember = False OR blnBanned Then
    loginForum = ""
   else
    loginForum = lngLoggedInUserID
   end if
  End If
 
  ConnF.Close()
  set ConnF = nothing
 End If 
END FUNCTION
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.