I am trying to intergrate the forum with my exsiting site. I am struggling with the external login.

Has any one created this allready? Or does anyone know of a mod that can do this.

Thanks

Dash

Many have done it before you..search the forum..it's sooo easy once you find the ''search'' button..It's GREAT!!! Try it

<%
'Create  DSN Less connection to Access Database
'Create DBConnection Object
Set DBConnection = Server.CreateObject("adodb.connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.Mappath("/Pathtoyourdatabase.mdb")
DBConnection.Open DSN

UserID = Request.Cookies("Forum")("UID")
last = Request.Cookies("FLVST")("LTVST")

   SQL = "Select * From tblAuthor Where User_code = '"& UserID &"'"
      Set RS = DBConnection.Execute(SQL)
     

Select Case RS.eof
      Case False
        tempRSCount = RS.getrows
        Set RS = Nothing
        logon = Cdbl(UBound(tempRSCount, 2)) + 1
               
     Case True
      logon = "0"
 End Select
     Set RS = Nothing
     
IF logon = "0" Then
%>
<form method="POST" action="/forum/login_user.asp<% = strReturnPageProperties %>">
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
    <tr>
      <td width="50%">&nbsp;</td>
      <td width="50%">&nbsp;</td>
    </tr>
    <tr>
      <td width="50%">
      <p align="right"><font face="Verdana" size="1">Username</font>: </td>
      <td width="50%"><input type="text" name="name" size="11"></td>
    </tr>
    <tr>
      <td width="50%">
      <p align="right"><font face="Verdana" size="1">Password</font>: </td>
      <td width="50%"><input type="password" name="password" size="11"></td>
    </tr>
    <tr>
      <td width="100%" colspan="2">&nbsp;</td>
    </tr>
    <tr>
      <td width="100%" colspan="2">
      <input type="hidden" name="sessionID" value="<% = Session.SessionID %>" />
      <p align="center"><input type="submit" name="Submit" value="<% = strTxtLoginUser %>"></td>
    </tr>
  </table>
  <p align="center">
  &nbsp;<font size="1" face="Verdana">Don't have an account?</font>
  <BR>
  <font face="Verdana" size="2"><a href="/forum/register_form.asp">Register here </a>
  </font>
  </p>
  <input type="hidden" name="AutoLogin" value="True">
  <input type="hidden" name="ActiveUsers" value="True">
</form>
<%
Else

'If user allready loged in don't show login screen
'You can show somthing else insted like maybe last time visited or somthing

End IF
%>

This is how I do it. It works well.

It’s just a quote it doesn’t mater how you type it.

If it has a ( ' ) In front of it. It is only telling you notes or directions

i just tried ur code n got the following error:

Sorry, only members with sufficient permission can access this page.

A security error has occurred with authentication.
Please ensure that all cookies are enabled on your web browser, and you are not using a saved or cached copy of the page.

Did you enter in the path to your database.

this is what i added

<form method="POST" action="/forum/login_user.asp">
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
    <tr>
      <td width="50%">&nbsp;</td>
      <td width="50%">&nbsp;</td>
    </tr>
    <tr>
      <td width="50%">
      <p align="right"><font face="Verdana" size="1">Username</font>: </td>
      <td width="50%"><input type="text" name="name" size="11"></td>
    </tr>
    <tr>
      <td width="50%">
      <p align="right"><font face="Verdana" size="1">Password</font>: </td>
      <td width="50%"><input type="password" name="password" size="11"></td>
    </tr>
    <tr>
      <td width="100%" colspan="2">&nbsp;</td>
    </tr>
    <tr>
      <td width="100%" colspan="2">
      <input type="hidden" name="sessionID" value="761051698" />
      <p align="center"><input type="submit" name="Submit" value="Forum Login"></td>
    </tr>
  </table>
  <p align="center">
  &nbsp;<font size="1" face="Verdana">Don't have an account?</font>
  <BR>
  <font face="Verdana" size="2"><a href="/forum/register_form.asp">Register here </a>
  </font>
  </p>
  <input type="hidden" name="AutoLogin" value="True">
  <input type="hidden" name="ActiveUsers" value="True">
</form>

Go to http://www.cybercpu.net - http://www.cybercpu.net

Look at the login on the top right hand side. Thats this code in action. I just cut and pasted it from there. All I did was take out the path to my database

You need to enter the whole script.

Juat like i typed it. Just change the path to the database as your own

First off Don't post the path to your database for security.

Look at the code I posted and all you need to change is this line.

DSN = DSN & "DBQ=" & Server.Mappath("/Pathtoyourdatabase.mdb")

Instead of Pathtoyourdatabase.mdb enter in the path to YOUR database.

Hello Everyone... I'd like to take a further step in my forum.

I'd like to integrate the Webwiz forum in my site template to create the consistent look and feel overall. (Like BorG did on this site) Is it possible and how can I do it?... Will I break any agreement from -Borg_ if I do this?

Please let me know...

Thanks guys...

It’s all web design bro.

Just code your site to look like the forum.

vdub wrote: It’s all web design bro. Just code your site to look like the forum.

Thanks! Bro...

But is it supposed to be like this:

<% Server.Execute"../forum/default.asp" %> ?? please help, thanks!

thanks vdub for your help but i get this error when i use ur script

501 Not Implemented

Cannot do POST is supported via CGI/API programs only. with this URL /forum/login_user.asp<% = strReturnPageProperties %>.

nvm forget abt Forum Login script

can u help me with the latest_forum_post.inc for ver 7, i had the old one but after i changed to the new version it gives error. borg told me that the path has changed so i tried configuring it, now it does show the post on the index page but when click on them it just takes u to the default.asp, it does not takes u to the page of the post.
I saw it working in your site, hope u can get me the script.

thanks a million!

Ples tell me what to change where???

'Dimension variables
Dim adoDBConnection      'Holds the Database Connection Object
Dim strDBConnection      'Holds the Database driver and the path and name of the database
Dim rsForum      'Holds the recordset for the records in the database
Dim strSQL       'Holds the SQL query for the database
Dim strForumDatabasePath 'Holds the path to the forum database
Dim strForumPath  'Holds the path to the forum

'---------- Enter the correct paths to the forum and forum database below ---------------------

'Place the path to the forum in the string below
strForumPath = "/forum/"

'Place the path to the Forum database in the sting below
strForumDatabasePath = "/forum/admin/database/wwForum.mdb"

'This one is for Brinkser users only
'All you need to do is place your username in the part USERNAME and uncomment the line
'strForumDatabasePath = "/amitabh4u/db/forum.mdb"

'----------------------------------------------------------------------------------------------

'Create an ADO connection odject
Set adoDBConnection = Server.CreateObject("ADODB.Connection")

'Database driver and path to the forum database
strDBConnection = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strForumDatabasePath)

'Set an active connection to the Connection object
adoDBConnection.Open strDBConnection
 
%>   
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000">
  <tr>           
    <td bgcolor="#800000"><font size="2" face="Arial"><b>Today's Hot Topics</b></font></td>
     </tr>
      <tr>          
       <td bgcolor="#000000">
      <%
'Intialise the ADO recordset object
Set rsLatestsPosts = Server.CreateObject("ADODB.Recordset")
 
'Initalise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT Top 8 tblTopic.Forum_ID, tblTopic.Topic_ID, tblTopic.Subject, tblForum.Password "
strSQL = strSQL & "FROM tblTopic INNER JOIN tblForum ON tblForum.Forum_ID = tblTopic.Forum_ID "
strSQL = strSQL & "WHERE (((tblForum.Password) Is Null)) "
strSQL = strSQL & "ORDER BY tblTopic.Last_entry_date DESC;"

 
'Query the database
rsLatestsPosts.Open strSQL, strDBConnection

'If EOF then display an error message
If rsLatestsPosts.EOF Then Response.Write "There have been no Forum Posts"
 
'If there are pages to display then display them
Do while NOT rsLatestsPosts.EOF
 
 %>
      <a href="<% = strForumPath %>forum_posts.asp?TopicID=<% = rsLatestsPosts("Topic_ID") %>" target="_self"><% = rsLatestsPosts("Subject") %></a>
      <br>
      <%
  'Move to the next record in the recordset
  rsLatestsPosts.MoveNext
'Loop back round to display the next record
Loop
%>
    </td>
  </tr>
 </table>

please

I just looked at your Forum and it is possible to download the database!

This is because you have not changed this section:

'Place the path to the Forum database in the sting below
strForumDatabasePath = "/forum/admin/database/wwForum.mdb"

In order to make database secure you sould at least rename the database and the folder, for example:

'Place the path to the Forum database in the sting below
strForumDatabasePath = "/forum/admin/folder/database01.mdb"

If you have a folder with write permissions then this is the best place to store store any Microsoft Access databases or data files because your web server and thus your scripts have full access to this folder, however the folder is not directly accessible by your web site visitors.

The connection to you database if it is in a folder with write permissions usually called "private" may look something like this:

'Place the path to the Forum database in the sting below
strForumDatabasePath = "../../private/wwForum.mdb"

Hope this helps.

what if im using mssql

mssql, with an S :P