New User Welcome PM [v2]

[Dio]

Clicked install!

[nkodengar]

Installed

Appears to be ok with 3.0.4

[joeychgo]

Installed - Again - On my second forum - Thanks for a great hack!!!!!!

[Delphiprogrammi]

this seems to work fine with vb 3.0.5

[lcryan]

i get SQL errors


MySQL retourneerde:


#1062 - Duplicate entry 'regpmon' for key 1


while running this query


INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmon', 'register', '1', '1', 'yesno', 135, 0, 0);


the uninstallation instructions do not help ....

now how can i get rid of it :nervous:
how did you fix this error I am getting this also

[rob_daemon]

how did you fix this error I am getting this also
Use this query:

REPLACE INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmon', 'register', '1', '1', 'yesno', 135, 0, 0);

[Wilt]

For some reason, it didn't send the pm when I tested it, I have checked it over and over again, everything seems good, but it's just not sending...any ideas? I'm using vb 3.0.5

[lanc3lot]

Rob can u remind me, where the pm "text" we send to new user, is stored?

It been ages since i have installed the v1 of this hack, and want to just make a copy of this text, before uninstall it and install it again for v2
:)

Thnx

[pramodha]

Rob can u remind me, where the pm "text" we send to new user, is stored?

It been ages since i have installed the v1 of this hack, and want to just make a copy of this text, before uninstall it and install it again for v2
:)

Thnx

he told you to check them under the >Admin CP > User Registration


read all the threads and u will know whts happening !
:devious:

[rob_daemon]

For some reason, it didn't send the pm when I tested it, I have checked it over and over again, everything seems good, but it's just not sending...any ideas? I'm using vb 3.0.5

Did you upgrade? What version of the hack are you using?

Rob can u remind me, where the pm "text" we send to new user, is stored?

It been ages since i have installed the v1 of this hack, and want to just make a copy of this text, before uninstall it and install it again for v2


Thnx

Like pramodha said, check:

Admin CP --> vBulletin Options --> User Registration Options

[lanc3lot]

Thanks Rob, going to uninstall and install now...:)

[Onkel_Tom]

Just updated to the newest version on 3 Boards and still work fine ;)
thanks Rob https://vborg.vbsupport.ru/external/2005/01/3.gif

[lanc3lot]

Yep it is working....thanks a lot rob:)

[Wilt]

Did you upgrade? What version of the hack are you using?

Doesn't matter, it appears there was an extra } in register.php what didn't throw up an error.

[Challenge]

Can you remove your signature from the message?

[rob_daemon]

Can you remove your signature from the message?

Yes. Open register.php and find:

// Send the new owner a PM
$DB_site->query(
"INSERT INTO " . TABLE_PREFIX . "pmtext
(
fromuserid,
fromusername,
title,
message,
touserarray,
iconid,
dateline,
showsignature,
allowsmilie
)
VALUES
(
$get_pm_from[userid],
'" . addslashes($get_pm_from['username']) . "',
'" . addslashes($pmoptions['regpmtitle']) . "',
'" . addslashes($pmoptions['regpmtext']) . "',
'" . addslashes(serialize(array($userid => $username))) . "',
0,
" . TIMENOW . ",
1,
1
)"
);

Replace with:

// Send the new owner a PM
$DB_site->query(
"INSERT INTO " . TABLE_PREFIX . "pmtext
(
fromuserid,
fromusername,
title,
message,
touserarray,
iconid,
dateline,
showsignature,
allowsmilie
)
VALUES
(
$get_pm_from[userid],
'" . addslashes($get_pm_from['username']) . "',
'" . addslashes($pmoptions['regpmtitle']) . "',
'" . addslashes($pmoptions['regpmtext']) . "',
'" . addslashes(serialize(array($userid => $username))) . "',
0,
" . TIMENOW . ",
0,
1
)"
);

[Challenge]

Thanks a lot :squareeyed:
Smarties ;)

[pingme]

Does it work with VB 3.0.6 ? I would love ti install if it works w/o issues :D

[rob_daemon]

It works on 3.0.x without any issues :).

[OrangeFlea]

Question:

I'm somewhat unfamiliar with installing hacks/mods that involve inputing queries. The instructions you've provided have me at a loss, because I don't know if I'm supposed to collectively paste all those words into the query dialogue box or enter them in individually. Basically -- and I've consulted with the vBulletin manual -- I don't know how to enter queries. It's a dilemma that I've been ignoring 'till I saw this hack, which would help any board tremendously.

Can you or anyone help?

[rob_daemon]

If you are going to use phpMyAdmin to run the queries, then you can just copy and paste the entire set of queries and run them without having to break them up.

If you are going to be running them through the Admin CP, you'll need to break up each non word-wrapped line of queries and run them individually.

[OrangeFlea]

Thank you, works wonderfully. My favorite hack thus far!

One more thing: How do I include links into the PM message? I tried HTML but it only shows code in the messages new users receive. I want to link them to specific areas of the board.

[OrangeFlea]

Nevermind, uses BB code. THANKS AGAIN!

[Kalomax]

Sorry, I cant read 17 pages, too long !
I just want to ask how do I do with 3.0.7 ? Any change ? I have'nt install yet, now how can i do ?

[rob_daemon]

Just the previous page: https://vborg.vbsupport.ru/showpost.php?p=606476&postcount=269

It works on 3.0.x without any issues :).

[intrigue]

doesnt seem to work for me :'(

[Delphiprogrammi]

this works fine with 3.0.7 (and lower) f it doesn't work for you something is wrong on your end

[greenhybrid]

I can't seem to get mine to work. Perhaps it is because the code in my file is different than the two possibilities you provided. Mine is:

if ($vboptions['newuseremail'] != '')
{
if ($havefields)
{
$DB_site->data_seek(0, $profilefields);
while ($profilefield = $DB_site->fetch_array($profilefields))
{
$cfield = '';
$varname = "field$profilefield[profilefieldid]";

if ($profilefield['type'] == 'checkbox' OR $profilefield['type'] == 'select_multiple')
{
$data = unserialize($profilefield['data']);

foreach ($data AS $key => $value)
{
$pow = pow(2, $key);
if (pow(2, $key) & $$varname)
{
$cfield .= (!empty($cfield) ? ', ' : '') . $data["$key"];
}
}
}
else
{
$cfield = $$varname;
}
$customfields .= "$profilefield[title] : $cfield\n";
}
}

$username = $_POST['username'];
$email = $_POST['email'];
eval(fetch_email_phrases('newuser', 0));

$newemails = explode(' ', $vboptions['newuseremail']);
foreach ($newemails AS $toemail)
{
if (trim($toemail))
{
vbmail($toemail, $subject, $message);
}
}
}I added your code after this, but it doesn't work!

[MauriceReed]

got ours working fine!!

(3.0.6)

[tormodg]

Working fine here on 3.0.7, just like it was with 3.0.5 and 3.0.6.

[rob_daemon]

I can't seem to get mine to work. Perhaps it is because the code in my file is different than the two possibilities you provided. Mine is:

if ($vboptions['newuseremail'] != '')
{
if ($havefields)
{
$DB_site->data_seek(0, $profilefields);
while ($profilefield = $DB_site->fetch_array($profilefields))
{
$cfield = '';
$varname = "field$profilefield[profilefieldid]";

if ($profilefield['type'] == 'checkbox' OR $profilefield['type'] == 'select_multiple')
{
$data = unserialize($profilefield['data']);

foreach ($data AS $key => $value)
{
$pow = pow(2, $key);
if (pow(2, $key) & $$varname)
{
$cfield .= (!empty($cfield) ? ', ' : '') . $data["$key"];
}
}
}
else
{
$cfield = $$varname;
}
$customfields .= "$profilefield[title] : $cfield\n";
}
}

$username = $_POST['username'];
$email = $_POST['email'];
eval(fetch_email_phrases('newuser', 0));

$newemails = explode(' ', $vboptions['newuseremail']);
foreach ($newemails AS $toemail)
{
if (trim($toemail))
{
vbmail($toemail, $subject, $message);
}
}
}I added your code after this, but it doesn't work!
What version of vBulletin are you running?

[rrr]

This might be a bit much to ask, but would it be possible to add an if/then to the PM depending on which usergroup the person chooses at signup.

I've added this hack to my forum:
https://vborg.vbsupport.ru/showthread.php?t=75130

Which allows the user to choose between "buyer" and "seller" when they register.

Is there a way I could a different PM for buyers and a different PM for sellers (so they each can have a specific welcome)?

[hollyboy]

we should have a version working with vb 3.07

[Delphiprogrammi]

we should have a version working with vb 3.07

the one downloadble right now works fine with 3.0.7 i'm using it

[greenhybrid]

What version of vBulletin are you running?

3.0.6 with a patch for a security hole. To be hoenst I'm not sure how the whole upgrade thing works. But, the board says 3.0.6

[Delphiprogrammi]

3.0.6 with a patch for a security hole. To be hoenst I'm not sure how the whole upgrade thing works. But, the board says 3.0.6

simple,

1) download the new vbulletin package from the membersarea
2) unzip it
3) upload all files except install.php (keep the same directory structore)
4)point your browser to http://www.yoursite.com/forum/install/upgrade.php

vbulletin will automatically redirect you to the upgrade script you need enter your customer number (username on vbulletin.com/members/) and follow the onscreen steps

all hacks neds to be reinstalled but only the sourcefile edits the database modifications are already there.

[greenhybrid]

Yeah the part about reinstalling the mods is the part I don't like ;) I don't think I'll be upgrading at every single minor version. They come out so often!

[computer1]

Dus this work to vb 3.0.7 board ??

[Delphiprogrammi]

Dus this work to vb 3.0.7 board ??

yes it does

[computer1]

I have install this nowe and I have create new account but
I cant se eny pm when I have login whit that account what hace I do wrong ??

try here
http://forum.tanakawebb.com

[Delphiprogrammi]

I have install this nowe and I have create new account but
I cant se eny pm when I have login whit that account what hace I do wrong ??

try here
http://forum.tanakawebb.com


your hack works fine i just regged an account named "pmtester" and i received a pm from a moderator named "peter" people can disable pm's ...

[computer1]

Howe can I changes so that messages com from administratorn ??

and howe can I change this disable pm's

[Delphiprogrammi]

Howe can I changes so that messages com from administratorn ??

and howe can I change this disable pm's

in the admincp you can edit this under "users" remember users can turn it off themself

[hollyboy]

Dus this work to vb 3.0.7 board ??


following instruction of the 1st post?

[rob_daemon]

The instructions file attached to the first post does indeed work.

[Challenge]

Hello.
I use 3.0.7, and when the hack is installed, every time i get a new PM, i get a the PM-popup. (even though it is unchecked in the porfile page) How can i do so it dosn't show up always, only when "New PM popup" is checked?

Regards,

Challenge

[rob_daemon]

This only affects registration PM's. I'm not sure why this would be happening.

[angelicGrace]

Can I make a simple request.

I would realy love to install this hack, but the formatting of the text instruction file is so jumbled I can't for the life of me make heads or tails of it. Anyone care to clean the formatting of it? I would be very thankful.

[rob_daemon]

Can I make a simple request.

I would realy love to install this hack, but the formatting of the text instruction file is so jumbled I can't for the life of me make heads or tails of it. Anyone care to clean the formatting of it? I would be very thankful.
See the first post:

If the file appears corrupt, please see this (https://vborg.vbsupport.ru/showpost.php?p=510494&postcount=116) post.

[SRuvbnhad]

For some reason NotePad will not display the file correctly. Right click on it and open with WordPad. Works fine.

Also getting an error when trying to run the queries:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALU' at line 1

[dsboyce8624]

For some reason NotePad will not display the file correctly. Right click on it and open with WordPad. Works fine.

Also getting an error when trying to run the queries:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALU' at line 1

Try pasting one query at a time, usually the CR/LF at the end will mess them up if you do 'em all at once.

[gonecountry]

I just installed and it worked great, but I have one small question and I may have missed the answer in this thread, where do I change the user id of who is sending the pm. ie defaults to user id #1 want to be user id # 5.

[rob_daemon]

I just installed and it worked great, but I have one small question and I may have missed the answer in this thread, where do I change the user id of who is sending the pm. ie defaults to user id #1 want to be user id # 5.
Go to:

Admin CP --> Options --> vBulletin Options --> User Registration Options

And you'll find the setting for this there.

[gonecountry]

Thank you

[cmiller1014]

Will it work on 3.0.7?

[Mijae]

Will it work on 3.0.7?
It does.

[mcyates]

I've got a problem, the new pms are getting sent out 8 times instead of just 1. Is there anything i can do about this?

[rob_daemon]

I've got a problem, the new pms are getting sent out 8 times instead of just 1. Is there anything i can do about this?
I have no idea why this would be happening. Does the happen every time? Try uploading the original register.php and then rehacking it.

[Megareus Rex]

Whenever I try to open the .txt instructions, it erases all of the line breaks, so its all one big jumble of unintellgible text. I managed to seperate the queries out of it, but I can't do the php like that.

Is there something wrong with the instruction file?

EDIT: Nevermind, my comp was just being stupid.

[ManagerJosh]

Sigh

Rob, here got that error for you


Invalid SQL: INSERT INTO pmtext ( fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie ) VALUES ( 1, 'ManagerJosh', 'Welcome to WorldSims Forums!', 'Hello it\'s_like_that, and Welcome to WorldSims Forums!We appreciate you taking the time to register on our site. We hope you will enjoy your stay here and become an active part of this outgrowing community.If you have any questions please feel free to contact any person of our http://forums.worldsims.org/showgroups.php (team.We hope to see you around.Have Fun!The WorldSims.org Team', 'a:1:{i:15876;s:14:"it's_like_that";}', 0, 1119734548, 0, 0 )mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's_like_that";}', 0, 1119734548, 0, 0 )' at lmysql error number: 1064

[rob_daemon]

Sigh

Rob, here got that error for you
Very odd; what are your magic quote settings for GPC? Hopefully this will be fixed in the next version which will have some other major improvements. I've been away for two weeks and I'm busy next week but the new version (which uses hooks) should be ready in about a week.

[mustang_lex]

This is a great hack. Couple things I like to change

1) Can I have the new member receive the PM after he/she has activated their account via email?

2) Get rid of the pop up message saying theres a new message. I have it disbaled in AdminCP but still pops up :ermm:

Thank you

[rob_daemon]

This is a great hack. Couple things I like to change

1) Can I have the new member receive the PM after he/she has activated their account via email?

2) Get rid of the pop up message saying theres a new message. I have it disbaled in AdminCP but still pops up :ermm:

Thank you
Both of those will be available in the new version of the hack in vB 3.5. Development of it is currently nearing completion.

[mustang_lex]

Will the new version be 3.0.7 friendly?

[cmiller1014]

This is already built into 3.5

[rob_daemon]

No, the new version will not be 3.0.7 friendly; it's too much work because the new version uses data-managers and plugins, not code hacks.

And cmiller, it is? Where?

[mustang_lex]

Ok is there a way just to stop the popups?

[cmiller1014]

And cmiller, it is? Where?


You know what... I upgraded so maybe this hack just came over with the upgrade. It's a database thing right, no code mods? I can't remember what I did to install it, but when I upgraded I didn't make any of my code mods again and this is in there.

[Andreas]

The vBulletin Options will stay, as they are set to volatile=0, eg. vBulletin Update-Scripts will not delete them.
But they have no effect as the Code isn't there :)

[paul41598]

Ok is there a way just to stop the popups?



In register.php

find:
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET pmtotal = pmtotal + 1, pmunread = pmunread + 1, pmpopup = 2 WHERE userid = $userid");

replace with:
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET pmtotal = pmtotal + 1, pmunread = pmunread + 1, pmpopup = 1 WHERE userid = $userid");

[rob_daemon]

In register.php

find:
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET pmtotal = pmtotal + 1, pmunread = pmunread + 1, pmpopup = 2 WHERE userid = $userid");

replace with:
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET pmtotal = pmtotal + 1, pmunread = pmunread + 1, pmpopup = 1 WHERE userid = $userid");

... which will be an option in the new version :).

[ManagerJosh]

... which will be an option in the new version :).

So where's the 3.5 version Rob :p

[rob_daemon]

It's slowly on its way. I'd expect it when RC1 is out because that's when my site is going live. Plus, I found a lovely bug regarding serialize() hat I can't reproduce all the time (which I think is related to your problem). I'm seeing if I can't fix it. Also I need to find out if I'm supposed to set the "product" fields for phrases and settings.

[mustang_lex]

Thank you rob

[o0Hubba0o]

Thank you rob

I have been searching for this one for so long, someone finally pointed me in the right direction. I had the welcome thread, but it was waste welcoming people in public if they register then never come back or post themselves.

When 3.5 goes gold I'll looking for the next version, so many hacks that should be default options in vB.

[Hornstar]

This is what i have been looking for, now I can find let them know of the rules of the site, and hopefully get feedeback from each new member of how they found the site, props

[nnjj.net]

is it working on 3.0.9??

[rob_daemon]

It should work without issue on 3.0.9.

[lefthome]

is it working on 3.0.9??works fine in 3.07, 3.08, 3.09 but what about 3.5. Come on guy and get it working....

[MajorFm.com]

Great hack, worked without any issues!

[ztempuser]

this is a very good way to make users read the rules of ur forum:)
thanks very much for this hack
but does it work with vbullitin 3.5.1?

[computer1]

I ned this to :)

[ztempuser]

this works on version 3.5.1 thanks

[criscokid]

this works on version 3.5.1 thanks
Is that a confirmation that this mod works on vB3.5.x?

[rob_daemon]

No. This only works for 3.0.x.

[MediaHound]

Anyone have this for 3.6.0?

[MediaHound]

bump

[MediaHound]

whoops it's built into
vbulletin options => user registration options => Welcome Private Message