Print Page | Close Window

Welcome private message

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7185
Printed Date: 06 April 2026 at 7:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Welcome private message
Posted By: Vinay
Subject: Welcome private message
Date Posted: 12 November 2003 at 4:25am

Is it possible to send a private message from the Admin/Site to all new members upon a successful registration. I know that you can use the email facility, but I think that a PM would show some of the features of the forum and be a nice instant welcome message.

Look forward to your help.

 

Vin




Replies:
Posted By: Scotty32
Date Posted: 12 November 2003 at 4:43am

you could edit the "register.asp" and put sumfin like

if mode = "new" then

code here

end if

and put where it "code here" the code to make a "Private Message" (look at the file to send a Private Message) and make the sender id "1" so its from the Admin

i dont think it would be very hard

you'll need to know ASP for it though

if your lucky sumone might of made a mod



Posted By: thekiwi
Date Posted: 13 December 2003 at 12:36pm
Originally posted by Scotty_32 Scotty_32 wrote:

you could edit the "register.asp" and put sumfin like

if mode = "new" then

code here

end if

and put where it "code here" the code to make a "Private Message" (look at the file to send a Private Message) and make the sender id "1" so its from the Admin

i dont think it would be very hard

you'll need to know ASP for it though

if your lucky sumone might of made a mod

And if using SQL Server .... add a trigger based on adding a new user ... and that trigger can call a stored procedure (or do it itself) which adds a record to strDbTable & PMMessage

and set the fields to

   .Fields("Author_ID") = 'who it is being sent to
   .Fields("From_ID") = 1
   .Fields("PM_Tittle") = 'Your default Subject
   .Fields("PM_Message") = 'Your default message which could be customised as well
   .Fields("PM_Message_Date") = Now()
   .Fields("Email_notify") = 0



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting


Posted By: thekiwi
Date Posted: 13 December 2003 at 1:09pm

Here is a couple of bits of code if you are using SQL Server:

Change wwf to your table prefix

CREATE TRIGGER Add_Welcome_PM ON [dbo].[wwfAuthor]
FOR INSERT
AS
declare @AuthorId int
select @AuthorID = Author_ID from inserted
execute wwfSpSendPM @AuthorID,1

 

CREATE PROCEDURE wwfSpSendPM
(
 @AuthorID int,
 @ForumID int
)
AS

declare @PM_Message varchar(200)
declare @PM_Subject varchar(50)
select @PM_Subject = 'This is a welcome Message'
select @PM_Message = 'Welcome to our forum, we trust you enjoy your stay'
select @ForumID = 1

insert into wwfPMMessage (Author_ID, From_ID, PM_Tittle, PM_Message, PM_Message_Date, Email_notify)
 values (@AuthorID, @ForumID, @PM_Subject, @PM_Message, getdate(), 0)
GO

 

 



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting


Posted By: Scotty32
Date Posted: 13 December 2003 at 1:11pm

isnt the Table Prefix by Default "tbl"

and the Cookies are "wwf" ??



-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .


Posted By: thekiwi
Date Posted: 13 December 2003 at 1:46pm
Originally posted by Scotty_32 Scotty_32 wrote:

isnt the Table Prefix by Default "tbl"

and the Cookies are "wwf" ??

Yes ... but Ive changed the default, hence change it to whatever you have used.  Check the config file ... you can change it at the time you create the tables and SP's.  I changed mine so that it differentiates the tables from my main site.



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net