vb.org Archive
Page 23 of 34 « First 132122 23 242533 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)

tbroush 09-25-2004 04:51 PM
Awesome hack and very easy to install.

Carlos

joergh 10-03-2004 12:00 AM
Very nice hack :nervous: :ninja:

joergh

mtha 10-14-2004 05:18 AM
Quote:
Originally Posted by msimplay
what about turning it on and off ?
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:
}

taffy056 10-14-2004 10:02 AM
Hi,

I would like to add this on, but I am having a problem with phpMyAdmin, the problem is I have no real idea how to work it, can someone tell me in English how to to do these queries etc for this hack, I simply have no idea.

Thanks

taffy

rob_daemon 10-14-2004 01:41 PM
The easiest way to run queries is through the Admin CP. You can find the documentation about it here

zendiver 10-14-2004 04:17 PM
One small thing to add for the more inexperienced members trying to install this hack. If you are following the updated version of the hack "Weclome PM Hack [Oct 14 2004]" and you open up phpMyAdmin to run the queries and you get the following error:
PHP Code:
Error

SQL-query :  

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

'regpmactive', 'register', '1', '1', '', 139, 0, 0
) 

MySQL said: 


Table 'database_name.setting' doesn't exist 
it is because you have a prefix on your tables in your database.

To fix this problem, go back into the instructions and everwhere it says:
INSERT INTO `setting`
and
INSERT INTO phrase

make sure you add the prefix for your tables:

Example: My tables have vb3_ as the prefix so I added it to look like the following:
INSERT INTO `vb3_setting`
and
INSERT INTO vb3_phrase


Hope this helps
-Robert

mtha 10-14-2004 05:51 PM
Quote:
Originally Posted by zendiver
One small thing to add for the more inexperienced members trying to install this hack. If you are following the updated version of the hack "Weclome PM Hack [Oct 14 2004]" and you open up phpMyAdmin to run the queries and you get the following error:
PHP Code:
Error
 
 SQL-query :  
 
 INSERT INTO `setting` ( `varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` ) 
 VALUES (
 
 'regpmactive', 'register', '1', '1', '', 139, 0, 0
 ) 
 
 MySQL said: 
 
 
 Table 'database_name.setting' doesn't exist 
it is because you have a prefix on your tables in your database.

To fix this problem, go back into the instructions and everwhere it says:
INSERT INTO `setting`
and
INSERT INTO phrase

make sure you add the prefix for your tables:

Example: My tables have vb3_ as the prefix so I added it to look like the following:
INSERT INTO `vb3_setting`
and
INSERT INTO vb3_phrase


Hope this helps
-Robert
:) yeah, I just copy the original one over.

anyway, there's a fun way to do this:turn on debug mod, and add directly from ACP/vB Options :) but ... you have to know what you are doing, or you will distroy your board.

ManagerJosh 10-17-2004 07:18 AM
Quote:
Originally Posted by shadesvn
Just like KW802 said above ... and I got no problems 222 .. thanks for your confirmation mate .. !

Actually, don't change the original queries, MJosh .. you can change the PM's content in ACP later.
Shades, if you read the SQL error in more detail, the error was about the hacking being unable to support apostrophes within the usernames, causing the insert in the PM text to break down.

Yes I know i can edit it manually, however it is just frustrating sometimes and well, annoying.

alwafi 10-19-2004 12:23 AM
nice thanks

FleaBag 10-21-2004 01:33 PM
I finally got around to installing this - used to use it on vB2. Thanks a lot. :)


All times are GMT. The time now is 09:56 AM.
Page 23 of 34 « First 132122 23 242533 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.01502 seconds
  • Memory Usage 1,759KB
  • 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
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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