Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Private Messages - Sorry for the delay
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 9

infinity
New Member

New Zealand
90 Posts

Posted - 22 November 2000 :  23:37:18  Show Profile  Visit infinity's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
You wouldn't happen to be using MS SQL would you?

The Outbox is more like a Sent Items box I believe.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Hi Richard,
Thanks for the help.
No, not using SQL. Whole thing on Access.

And the outbox... My first thought was that it must be a sent type box, but nothing I send comes up in there... SO does anyone else reading this who has PM installed get any life out of the Outbox??

Regards,
Infinity

Life is but a dream... and that dream is Here and Now. Therefore, Be here Now.
Go to Top of Page

jessica
New Member

USA
58 Posts

Posted - 27 November 2000 :  07:33:06  Show Profile  Visit jessica's Homepage  Send jessica an AOL message  Send jessica a Yahoo! Message
This is a really nice mod if I can just get it working... I believe I have narrowed it down to the members.asp file. I am getting different errors when trying to login and view topics.

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'getNewMemberNumber'

/forum/topic.asp, line 62

Line 62 referrs to:

<!--#INCLUDE FILE="inc_footer_short.asp" -->
<%
Response.End
case else
'## Do Nothing - Continue
end select
62 ->>>> Member_ID = getNewMemberNumber()
if (strAuthType = "nt") then
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
call NTauthenticate()
if (ChkAccountReg() = "1") then
call NTUser()
end if
end if

Any help would be wonderful, Thanks

<font size=1><font color=green>Edited by Richard to fix the Display of this page</font id=green></font id=size1>

Edited by - Richard Kinser on 24 January 2001 04:49:50
Go to Top of Page

jessica
New Member

USA
58 Posts

Posted - 27 November 2000 :  08:44:02  Show Profile  Visit jessica's Homepage  Send jessica an AOL message  Send jessica a Yahoo! Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This is a really nice mod if I can just get it working... I believe I have narrowed it down to the members.asp file. I am getting different errors when trying to login and view topics.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Ok, I believe I have fixed this one... (I am still not sure what I have done, but No errors.)

The next question is, I am logged in, but it says I am not. Gosh if I remember correctly this problem was in the whos_online mod.... hmmmm. I don't remember how I fixed that. Well suggestions would be nice, but I will let everyone know where I stand... (OR you can check it out at http://www.webzonecomplete.com (If you sign up and want to be deleted just let me know. But then again you REALLY don't have to go)

Thanks,

Go to Top of Page

jessica
New Member

USA
58 Posts

Posted - 27 November 2000 :  09:00:01  Show Profile  Visit jessica's Homepage  Send jessica an AOL message  Send jessica a Yahoo! Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Ok, I believe I have fixed this one... (I am still not sure what I have done, but No errors.)

The next question is, I am logged in, but it says I am not. Gosh if I remember correctly this problem was in the whos_online mod.... hmmmm. I don't remember how I fixed that. Well suggestions would be nice, but I will let everyone know where I stand... (OR you can check it out at http://www.webzonecomplete.com

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Well the Who's Online login has been found and fixed... Although no the PM is not showing me logged in, I am going to re-read this thread and see if I am missing something. Thank every one for this great mod.

Go to Top of Page

bugzy
Junior Member

USA
147 Posts

Posted - 28 November 2000 :  13:05:54  Show Profile  Visit bugzy's Homepage
hey jessica

i read through the topic again .. and i cant find the whos.zip file anymore
but its on the board somewhere

ill post it up for you to download on my site

http://www.azian.com/stuff/whos.zip


Go to Top of Page

seven
Senior Member

USA
1037 Posts

Posted - 28 November 2000 :  21:08:40  Show Profile  Visit seven's Homepage
the private message mod works great, except the message text doesn't display. It does get added to the database, and when I hit reply it'll show me the message. IS there an error in the privateread.asp file?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 28 November 2000 :  22:38:18  Show Profile
airilm, are you using an SQL database?
Go to Top of Page

seven
Senior Member

USA
1037 Posts

Posted - 28 November 2000 :  22:43:06  Show Profile  Visit seven's Homepage
Richard.. yes SQL 7
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 28 November 2000 :  23:23:21  Show Profile
MS SQL seems to very picky about the order in the SELECT statements.

<b>On line #74 of privateread.asp</b>

<b>Change this:</b>

<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " <font color=red>& strTablePrefix & "PM.M_MESSAGE, "</font id=red> & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM "</font id=code></pre id=code></font id=size1>


<b>To This:</b>

<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM, " <font color=red>& strTablePrefix & "PM.M_MESSAGE "</font id=red></font id=code></pre id=code></font id=size1>
Go to Top of Page

Frodoger
Starting Member

Germany
42 Posts

Posted - 29 November 2000 :  08:14:48  Show Profile
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> where have you uesed the include privatemess.asp ?

'Resistance is futile' <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

1. i have dl the 3sr2.
2. i have build the db on sql server
3. have dl the pm_mod.zip and save it to the forum dir
4. i run the pmdbsetup.asp
5. i changed my default.asp like this:

<pre id=code><font face=courier size=2 id=code>
<%
else
blnHiddenForums = true
end if ' ChkDisplayForum()
rsForum.MoveNext
loop
end if
rs.MoveNext
loop
end if
%>
<!--#include file="privatemess.asp"-->
<%
if strShowStatistics = "1" then
WriteStatistics
end if %>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%">
<tr>
<td>
<font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>">
<img alt="New Posts" src="icon_folder_new.gif" width=8 height=9> Contains new posts since last visit.<br>
<img alt="Old Posts" src="icon_folder.gif" width=8 height=9> No new posts since the last visit.<br>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>



<% set rs = nothing
set rsForum = nothing %>
<!--#INCLUDE FILE="inc_footer.asp" -->
<% sub PostingOptions()
if (mlev = 4) or (lcase(strNoCookies) = "1") then %>
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
</font id=code></pre id=code>

6. and this:
<pre id=code><font face=courier size=2 id=code>
'## Harpswell, ME 04079
'#################################################################################
%>
<!--#INCLUDE FILE="config.asp" -->
<!--#include file="privatemess.asp"-->
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<%
</font id=code></pre id=code>




Edited by - Frodoger on 29 November 2000 08:16:03
<font size=1><font color=green>Edited by Richard to fix the Display of this page</font id=green></font id=size1>

Edited by - Richard Kinser on 24 January 2001 04:51:27
Go to Top of Page

seven
Senior Member

USA
1037 Posts

Posted - 29 November 2000 :  19:17:09  Show Profile  Visit seven's Homepage
Thank you so much Richard. You are now my official hero. I can stop pulling my hair out now. Thanks for all your help.

Is there a web site that has compiled all these nifty upgrades into one short concise format. It takes some skill to be able to paste all these rev's together and read through all the different changes. It would be nice to go to one site (or locked forum) for the final product.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
MS SQL seems to very picky about the order in the SELECT statements.

<b>On line #74 of privateread.asp</b>

<b>Change this:</b>

<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " <font color=red>& strTablePrefix & "PM.M_MESSAGE, "</font id=red> & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM "</font id=code></pre id=code></font id=size1>


<b>To This:</b>

<font size=1><pre id=code><font face=courier size=2 id=code> strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "PM.M_ID, " & strTablePrefix & "PM.M_TO, " & strTablePrefix & "PM.M_SUBJECT, " & strTablePrefix & "PM.M_SENT, " & strTablePrefix & "PM.M_FROM, " <font color=red>& strTablePrefix & "PM.M_MESSAGE "</font id=red></font id=code></pre id=code></font id=size1>

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 29 November 2000 :  20:13:39  Show Profile
Frodoger,

remove the line highlighted in <font color=red>red</font id=red>.


<pre id=code><font face=courier size=2 id=code><font size=1>'## Harpswell, ME 04079
'#################################################################################
%>
<!--#INCLUDE FILE="config.asp" -->
<font color=red><!--#include file="privatemess.asp"--></font id=red>
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<%</font id=size1></font id=code></pre id=code>

Edited by - Richard Kinser on 24 January 2001 04:51:50
Go to Top of Page

Nam
Starting Member

36 Posts

Posted - 04 December 2000 :  23:58:17  Show Profile  Visit Nam's Homepage
I'm confused ????????????

So many files out there, which one should I download? Richard, you gave 4 links on page 2 about members2, forumcosd, private... on page 3, you also gave pm_mod.zip, so which one should I download? I already have whoisonline working, I really like private message function on my page. Thanks

Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 05 December 2000 :  00:15:05  Show Profile
If you are using v3.1 final or newer, you would just need this file:

http://www1.domaindlx.com/dssdbs/files/pm_mod.zip
Go to Top of Page

Nam
Starting Member

36 Posts

Posted - 05 December 2000 :  00:55:12  Show Profile  Visit Nam's Homepage
I got this error while running private message setup file pmdbsetup.asp:

<b>CREATE TABLE FORUM_PM (M_ID integer IDENTITY (1, 1) NOT NULL , M_SUBJECT nvarchar (50) NULL , M_FROM integer NULL , M_TO integer NULL , M_SENT nvarchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT nvarchar (50) NULL , M_READ integer NULL DEFAULT 0 , M_MAIL nvarchar (50) NULL , M_OUTBOX smallint NULL )

ADODB.Connection.1 error '80004005'

Syntax error in CREATE TABLE statement.

/forum/pmdbsetup.asp, line 62
</b>
please help

Go to Top of Page
Page: of 9 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07