Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
New User Welcome PM [v2] Details »»
New User Welcome PM [v2]
Mod Version: 2.1.0, by rob_daemon (Coder) rob_daemon is offline
Developer Last Online: Dec 2012 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.0 Rating: (1 vote - 1.00 average) Installs: 200
Released: 01 Apr 2004 Last Update: 06 Dec 2004 Downloads: 32
Not Supported DB Changes  

This hack will send any new users a welcome PM. This will work in vB3 Gold and probably RC versions as well. I will give support for this hack (if it's needed) in this thread.

If you upgraded your vB version and you are using a hack version prior to July 8, 2004:
If you have upgraded vB and your hack version is not July 8, 2004 or newer, run this query (there was a problem with the prior instructions):


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This hack was last updated: Sun December 5, 2004 at 23:00 PDT
This update has a new on/off switch.

Update includes: vB 3.0.2/3.0.3 instructions

To install follow the instructions in the attached file.

Installation Information
Files to Edit: 1
Queries to Run: 11

Upgrade Instructions:

Open ./register.php and remove the hack (to find the old hack see below). And re-add the updated hack found in the Installation Instructions file.

To upgrade to the December 5th release, you'll need to run these three queries:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Uninstall Instructions:

Run the queries in this post, and then remove the hack in register.php (see below).

Look for:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

To configure it after installation, go to: Admin CP --> Options --> vBulletin Options --> User Registration Options

Attached is a screen grab of the PM by default and text instructions. If the file appears corrupt, please see this post.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	Picture 1.jpg
Views:	3776
Size:	134.3 KB
ID:	17795

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Send a Private Message to user (and optional user note) when approved for a usergroup majorxp vBulletin 3.5 Add-ons 41 24 Feb 2014 18:37
Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack) eoc_Jason vBulletin 2.x Full Releases 197 28 Oct 2006 03:08
Only Show IP:Logged if user is admin or supermod, and disable Post report by user Fallout2man vBulletin 2.x Full Releases 32 30 Jul 2002 01:20

  #31  
Old 02 Apr 2004, 01:19
SpeedysWorld SpeedysWorld is offline
 
Join Date: Mar 2004
/me clicks install, great update! works great!

- SpeedysWorld
Reply With Quote
  #32  
Old 02 Apr 2004, 01:24
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Real name: Rob
Originally Posted by Vivi Ornitier
i get this when runnin the first query.

SQL-query :

INSERT INTO `setting`
VALUES (

'regpmfrom', 'register', '1', '1', '', 140, 0, 0
)

MySQL said:


#1136 - Column count doesn't match value count at row 1
Hmm... try running this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #33  
Old 02 Apr 2004, 01:35
blubber12 blubber12 is offline
 
Join Date: Nov 2003
I"m using the updated hack..and have no admcp options in user reg? What have I done wrong?
Reply With Quote
  #34  
Old 02 Apr 2004, 02:08
Vivi Ornitier's Avatar
Vivi Ornitier Vivi Ornitier is offline
 
Join Date: Nov 2001
I'm using that query u gave me rob and i get

INSERT INTO `setting` ( `varname` , `groupttitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` )
VALUES (

'regpmfrom', 'register', '1', '1', '', 140, 0, 0
)

MySQL said:


#1054 - Unknown column 'groupttitle' in 'field list'
Reply With Quote
  #35  
Old 02 Apr 2004, 02:17
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Real name: Rob
Originally Posted by blubber12
I"m using the updated hack..and have no admcp options in user reg? What have I done wrong?
Did you run the queries that were specified in the file?

Vivi Ornitier: My bad.. an extra `t` slipped in:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

You may also need updated queries for the others if that works:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #36  
Old 02 Apr 2004, 02:24
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
You might want to let them know how to turn smilies on for the pms (changing the 0 to 1).

Also, can this be set up to only send the pm on activation? I don't allow pms until they are activated.

Last edited by Boofo : 02 Apr 2004 at 05:20.
Reply With Quote
  #37  
Old 02 Apr 2004, 05:50
Hobbes's Avatar
Hobbes Hobbes is offline
 
Join Date: Dec 2002
Real name: Tyler
Originally Posted by Vivi Ornitier
I'm using that query u gave me rob and i get

INSERT INTO `setting` ( `varname` , `groupttitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` )
VALUES (

'regpmfrom', 'register', '1', '1', '', 140, 0, 0
)

MySQL said:


#1054 - Unknown column 'groupttitle' in 'field list'
I think these errors might have t odo with left over vb2 tables from the hacks on that site. dunno though
Reply With Quote
  #38  
Old 02 Apr 2004, 05:54
Vivi Ornitier's Avatar
Vivi Ornitier Vivi Ornitier is offline
 
Join Date: Nov 2001
Those all worked rob, yet when i run the 4th query from the install file it gives me

SQL-query :

INSERT INTO `setting`
VALUES (

'regpmtext', 'register', 'Hi $username and welcome to $bbtitle!\r\n\r\nWe appreciate you taking the time to register on our site and we hope you enjoy your stay.\r\n\r\nIf you have any questions, you can ask an administrator for assistance.\r\n\r\nWe hope to see you around.\r\n\r\nSincerely,\r\nThe $bbtitle staff', 'Hi $username and welcome to $bbtitle!\r\n\r\nWe appreciate you taking the time to register on our site and we hope you enjoy your stay.\r\n\r\nIf you have any questions, you can ask an administrator for assistance.\r\n\r\nWe hope to see you around.\r\n\r\nSincerely,\r\nThe $bbtitle staff', 'textarea', 150, 0, 1
)

MySQL said:


#1136 - Column count doesn't match value count at row 1
Reply With Quote
  #39  
Old 02 Apr 2004, 06:21
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
i ran all the queries, have no settings in the ACP under 'User Registration Options'.
Reply With Quote
  #40  
Old 02 Apr 2004, 06:34
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
and now, after saving the settings even though the new ones were not there we have this when trying to register:

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT username,userid FROM user WHERE userid=register
mysql error: Unknown column 'register' in 'where clause'

mysql error number: 1054

Date: Friday 02nd of April 2004 02:54:23 AM
Script: http://www.gamers-gateway.com/vb/register.php
Referer: http://www.gamers-gateway.com/vb/register.php

i have had to shut my board because of this, i trust somebody will be kind enough to help....
Reply With Quote
  #41  
Old 02 Apr 2004, 09:23
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Originally Posted by nemesis01
and now, after saving the settings even though the new ones were not there we have this when trying to register:

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT username,userid FROM user WHERE userid=register
mysql error: Unknown column 'register' in 'where clause'

mysql error number: 1054

Date: Friday 02nd of April 2004 02:54:23 AM
Script: http://www.gamers-gateway.com/vb/register.php
Referer: http://www.gamers-gateway.com/vb/register.php

i have had to shut my board because of this, i trust somebody will be kind enough to help....
there was a little part in the instructions that told you to go to registration options and press save once otherwise you will get sql errors
Reply With Quote
  #42  
Old 02 Apr 2004, 09:33
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
and if you had read my post properly you will see i did that, even though after running the queries that were supposed to insert those options didn't work.
Reply With Quote
  #43  
Old 02 Apr 2004, 09:40
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Originally Posted by nemesis01
and if you had read my post properly you will see i did that, even though after running the queries that were supposed to insert those options didn't work.
have you got any other hacks in register.php
because if u make a tiny mistake it can throw the whole forum off
Reply With Quote
  #44  
Old 02 Apr 2004, 09:41
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
nope, it is a virgin file.
Reply With Quote
  #45  
Old 02 Apr 2004, 09:43
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Originally Posted by nemesis01
nope, it is a virgin file.
try getting a default register php and rehacking it

EDIT just registered at your site and it seems u have private messages turned off for users awaiting email activation try turning it on

Last edited by msimplay : 02 Apr 2004 at 09:45.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 07:05.

Layout Options | Width: Wide Color: