Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Welcome private message
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Welcome private message

 Post Reply Post Reply
Author
Vinay View Drop Down
Newbie
Newbie
Avatar

Joined: 23 November 2002
Location: United Kingdom
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vinay Quote  Post ReplyReply Direct Link To This Post Topic: Welcome private message
    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

Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post 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



Edited by thekiwi
Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post 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

 

 

Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 13 December 2003 at 1:11pm

isnt the Table Prefix by Default "tbl"

and the Cookies are "wwf" ??

S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post 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.



Edited by thekiwi
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.