vb.org Archive
Page 24 of 34 « First 142223 24 2526 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   New User Welcome PM [v2] (https://vborg.vbsupport.ru/showthread.php?t=63269)

Kwak 10-22-2004 04:55 AM
I just love this hack. :cool: Props to the hacker.

Wifey 10-24-2004 11:18 PM
[high]* Wifey clicks install
[/high]

GREAT hack! It works out really well with another hack I have installed in order to let people know how to check what usergroup they were sorted into. It also keeps another group of special members that I have who welcome new members to their clique with work :)

Thank you so much!

NightWalk8r 11-22-2004 06:31 AM
I got this error when i try 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text

Please help

rob_daemon 11-22-2004 09:06 PM
Quote:
Originally Posted by NightWalk8r
I got this error when i try 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text

Please help
Can you please paste the whole query here so I can try to trouble shoot it?

NightWalk8r 11-25-2004 12:07 AM
I used this because my DB uses the vb3_ prefix.


Quote:
INSERT INTO `vb3_setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmfrom', 'register', '1', '1', '', 140, 0, 0);
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmfrom_title', 'User Who Sends Automatic PM Upon Registration', '5000');
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmfrom_desc', 'Enter the user ID of the person whose account you\'d like to be used when sending new users a welcome PM upon registering.', '5000');


INSERT INTO `vb3_setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) 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, 0);
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtext_title', 'Welcome PM Text', '5000');
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtext_desc', 'Set the text of the PM sent to all new users.<br />\r<br />\rNote: You can use the following variables to specify the <b>user\'s</b> information: $username, $userid, $email. And you can use the $bbtitle to specify the board\'s name.', '5000');


INSERT INTO `vb3_setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmtitle', 'register', 'Welcome to $bbtitle!', 'Welcome to $bbtitle!', '', 160, 0, 0);
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtitle_title', 'Title Of the PM That is Automatically Sent to New Users', '5000');
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtitle_desc', 'Set the title of the PM that is sent to all new users automatically. You can use the same variables as the ones that you can use for the PM text (see above).', '5000')
This is the error i keep getting =/

Quote:
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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text

rob_daemon 11-25-2004 03:22 AM
I just ran all of those queries without problem. Try running each one individually to see where the problem occurs.

NightWalk8r 11-25-2004 03:33 PM
wow!!! it works!!!! hmm.........i wonder why? -_-
Thank you soooo much =)

rob_daemon 11-25-2004 11:53 PM
Very odd. Where were you running the queries? Command line, phpMyAdmin, vB Admin CP?

mtha 11-29-2004 09:13 PM
Quote:
Originally Posted by mtha
Seem like the function wasnt implemented, so I gave it a shot.
If you already install the hack, do the followings

run this querry to add another option (turn on/off) to your "vB Registration Options

Code:
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmactive', 'register', '1', '1', '', 139, 0, 0);
 INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmactive_title', 'Send default PM to new users?', '5000');
 INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmactive_desc', '', '5000');
In registration.php

Look for

Code:
          $pmoptions['regpmtext'] = $vboptions['regpmtext'];
add above:

Code:
                $pmoptions['regpmactive'] = $vboptions['regpmactive'];
Look for:

Code:
                // Send the new owner a PM
                $DB_site->query(
Add above:

Code:
if ($pmoptions['regpmactive']) {

LOOK FOR

Code:
                // ###################################################################
                // # END WELCOME PM HACK
                // ###################################################################
ADD ABOVE:

Code:
}
Rob, do you want to add this option to turn ON/OFF the welcome PM into your hack?

I think I'd be very handy for users

rob_daemon 11-30-2004 03:45 AM
Quote:
Originally Posted by mtha
Rob, do you want to add this option to turn ON/OFF the welcome PM into your hack?

I think I'd be very handy for users
It's in the version in CVS, I've just been busy writing my term papers and other things to clean it up and update all the instructions. I'm hoping to get new versions of my three hacks out next weekend.


All times are GMT. The time now is 03:57 PM.
Page 24 of 34 « First 142223 24 2526 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01214 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete