Author |
Topic  |
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 14 December 2000 : 06:24:03
|
The is a re-release of the Private Messages Mod. It is for v3.1 Final and newer of Snitz Forums 2000. It was originally released by slemieux, I have just modified it so that it will work with v3.1 Final and newer. It may work with earlier versions of the Forum, but I have not tested it.
If you have already installed the Private Messages Mod and it's working, then there is no need to download this one. There is no new functionality, I have just incorporated all of the fixes that were posted in the previous thread.
Please read the included pm_readme.txt file before installing this mod.
site #1 FILE: http://www1.domaindlx.com/dssdbs/files/private_messages_mod.zip
site #2 FILE: http://www11.ewebcity.com/dssdbs/files/private_messages_mod.zip
Edited by - Richard Kinser on 14 December 2000 06:47:40 |
|
lcs78816
Junior Member
 
195 Posts |
Posted - 14 December 2000 : 07:16:18
|
is there demo available? |
 |
|
evehawk
New Member

Australia
65 Posts |
|
André
Starting Member
24 Posts |
Posted - 14 December 2000 : 11:39:40
|
I get this message with both Mod default and access 97
Creating table(s)... CREATE TABLE FORUM_PM( , M_SUBJECT varchar (50) NULL , M_FROM int NULL , M_TO int NULL , M_SENT varchar (50) NULL , M_MESSAGE text NULL , M_PMCOUNT varchar (50) NULL , M_READ int NULL , M_MAIL varchar (50) NULL , M_OUTBOX smallint NULL ) -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
-------------------------------------------------------------------------------- The others are created succesfully !
Edited by - André on 14 December 2000 11:41:42 |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
Posted - 14 December 2000 : 12:10:56
|
Should there be a space here?
CREATE TABLE FORUM_PM ( , M -------------------------^
instead of
CREATE TABLE FORUM_PM( , M
Podge
Edited by - podge on 14 December 2000 12:13:08 |
 |
|
shamway
New Member

70 Posts |
Posted - 14 December 2000 : 12:52:04
|
when i make the changes in the default.asp as in the readme file i can't see the forum at all.
|
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 14 December 2000 : 13:55:22
|
André,
Did you try to change your connectstring in <b>config.asp</b> to the one I suggested in the pm_readme.txt file? If you need help with that you can e-mail me your config.asp file and I will edit it for you.
The reason you are getting a syntax error is for some reason the M_ID field isn't in the CREATE STATEMENT, between the first <b>(</b> and <b>,</b>
Here is what that statement should look like: (the text in <font color=red>red</font id=red> is what's missing from yours):
CREATE TABLE FORUM_PM( <font color=red>M_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY</font id=red> , M_SUBJECT text (50) NULL , M_FROM int NULL , M_TO int NULL , M_SENT text (50) NULL , M_MESSAGE memo NULL , M_PMCOUNT text (50) NULL , M_READ int NULL , M_MAIL text (50) NULL , M_OUTBOX smallint NULL )
|
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 14 December 2000 : 14:51:45
|
sweetness!
Thx Richard!
<font color=red>Da_Stimulator</font id=red> <font color=red>http://www.cfm-resources.com/s/stimmy/</font id=red> <font color=blue>response.write("I know what you coded last summer!")</font id=blue> http://www.tek-tips.com - The community where computer proffesionals meet and talk. |
 |
|
Hopper
Junior Member
 
192 Posts |
Posted - 14 December 2000 : 15:24:01
|
On private messages, is it possible to set it up so there is a small icon on the posts like the mailto icon to send a private message to whomever wrote the post? Just a thought.
|
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 14 December 2000 : 15:29:50
|
sure, just add a link in topic.asp in the header thingy where all the buttons are to privatesend.asp?mname=<%=strChkName%>
<font color=red>Da_Stimulator</font id=red> <font color=red>http://www.cfm-resources.com/s/stimmy/</font id=red> <font color=blue>response.write("I know what you coded last summer!")</font id=blue> http://www.tek-tips.com - The community where computer proffesionals meet and talk. |
 |
|
Hopper
Junior Member
 
192 Posts |
Posted - 14 December 2000 : 15:35:49
|
you're talking to an ISP illiterate..Im a VB programmer so I can follow it somewhat.. and I want to learn more but its slow going. *smile* I'll tinker with it. heh
|
 |
|
shamway
New Member

70 Posts |
Posted - 14 December 2000 : 15:40:27
|
could any body help me? i just can't change the default.asp file right, what ever i do doesn't work, could someone chack my file or post a default.asp file with the private masege? thank's
Edited by - shamway on 14 December 2000 15:42:09 |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 14 December 2000 : 15:46:24
|
Okey dokey I got the little button to show up in the replies, but not in the topic. I cant find it! its all a big heap of code, very hard to sift through.
<font color=red>Da_Stimulator</font id=red> <font color=red>http://www.cfm-resources.com/s/stimmy/</font id=red> <font color=blue>response.write("I know what you coded last summer!")</font id=blue> http://www.tek-tips.com - The community where computer proffesionals meet and talk. |
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 14 December 2000 : 15:47:57
|
Hopper,
Yes it is possible. It's just not a requirement so I didn't include it in the instructions. I tried to keep the instructions as simple as possible. The less steps to install this the better.
Instructions for adding the PM icon and link to <b>Topic.asp</b> is 2 posts down.
You can see the DEMO on my site: http://richard.cfm-resources.com
Also, check out Tim Teal's site here: http://www.tealnet.com/newforum/
On Tim's site, a link to send a Private Message has been added to the Who's Online page also.
Edited by - Richard Kinser on 14 December 2000 16:04:21 |
 |
|
Da_Stimulator
DEV Team Forum Moderator
    
USA
3373 Posts |
Posted - 14 December 2000 : 15:51:57
|
wow thats wierd... I replied after Richards and his is last...
Unless you deleted your reply then replied agiain...
<font color=red>Da_Stimulator</font id=red> <font color=red>http://www.cfm-resources.com/s/stimmy/</font id=red> <font color=blue>response.write("I know what you coded last summer!")</font id=blue> http://www.tek-tips.com - The community where computer proffesionals meet and talk. |
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 14 December 2000 : 16:02:46
|
Here is a link to instructions on adding a PM icon and link to <b>Topic.asp</b>
http://www1.domaindlx.com/dssdbs/files/pm_topic.txt
<font size=1>Da_Stimulator, that is what happened, I deleted my reply and resent it.</font id=size1> |
 |
|
Topic  |
|