vb.org Archive - Un-Activated User Management

Page 9 of 21

« First

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)

- - Un-Activated User Management (https://vborg.vbsupport.ru/showthread.php?t=65845)

djroketboy

11-19-2004 09:04 PM

Quote:

Originally Posted by sabret00the

your line 21 should read

PHP Code:


		
			
chdir('/home/hpoa/public_html/community/'); //change to your vbulletin path

can you let me know if it say that please :)

ok, i missed that, it wasn't in the directions :cheeky:

I still get this error:
Warning: Cannot modify header information - headers already sent by (output started at /home/hpoa/public_html/community/includes/adminfunctions.php:223) in /home/hpoa/public_html/community/includes/functions.php on line 2714

djroketboy

11-19-2004 09:17 PM

Quote:

Originally Posted by djroketboy

ok well, since i've had more time today, i figured it out... i removed this line:
require_once('./global.php');

and now i get no errors, and it works ;)

thanks guys!!
djroketboy clicks install!

EDIT: ohh, i do still have one more question though, how can i by pass the default original sent email by vbulletin, and use your method, your method does NOT go into the junkmail folders for hotmail and yahoo (atleast for my test emails)...

it would save me sooo much headache if the original activation email was sent like yours...

Kwikms

11-24-2004 11:54 PM

Nice :)

It's been asked here before, but I couldnt find an answer. How about an "Un-Active User Management"? Same thing, but for users who didnt do a log-in for about xy days. They get an email "You did not visit the forum for xy days. If you do not click this link your account will be deleted in 14 days" or so.

Or is there a hack like this available?

sabret00the

11-29-2004 01:10 PM

Quote:

Originally Posted by Kwikms

it shouldn't be too hard, it's just a matter of editing the queries. however surely your users wouldn't be too happy if they went on holiday and came back to find their account deleted?

sabret00the

11-29-2004 01:10 PM

Quote:

Originally Posted by djroketboy

i have no idea how this differs from the default sorry :(

Kwikms

11-29-2004 01:30 PM

Quote:

Originally Posted by sabret00the

it shouldn't be too hard, it's just a matter of editing the queries. however surely your users wouldn't be too happy if they went on holiday and came back to find their account deleted?

Thats why they should first get an email "if you do not login within the next xx days (lets say 21) your account will be deleted. And this email will be send to people which did not log in for lets say 365 days.

So I think it is not just to edit some querys, isnt it? And in that case I dont mind if people who didnt visit my board for a year and are on a over three week vacation will be deleted :rolleyes:

jluerken

12-11-2004 01:53 PM

Quote:

// Get all users who have not activated their accounts.
$userArray=$DB_site->query("
SELECT username,user.userid,email,joindate,activationid
FROM user
LEFT JOIN useractivation ON (user.userid=useractivation.userid)
WHERE user.usergroupid=3 AND user.posts = 0
");

This part is not working when using table prefixes. Could this be updated please?

I also only want to have an email as admin which users can be deleted. I don't want the script to do so.

sabret00the

12-11-2004 02:17 PM

PHP Code:


		
			
 // Get all users who have not activated their accounts.

$userArray=$DB_site->query("

SELECT username,user.userid,email,joindate,activationid

FROM  " . TABLE_PREFIX . "user

LEFT JOIN useractivation ON (user.userid=useractivation.userid)

WHERE user.usergroupid=3 AND user.posts = 0

");

is the fix you need

the second part of the script is a bit much for me right now although not a big task, just my heads in something else, but i'll remember and hopefully get it out by the end of the month :)

jluerken

12-11-2004 02:30 PM

No this is not working.

I also tried

Quote:

// Get all users who have not activated their accounts.
$userArray=$DB_site->query("
SELECT username,user.userid,email,joindate,activationid
FROM " . TABLE_PREFIX . "user
LEFT JOIN " . TABLE_PREFIX . "useractivation ON (user.userid=useractivation.userid)
WHERE user.usergroupid=3 AND user.posts = 0
");

but then I get:

Quote:

Invalid SQL:
SELECT username,user.userid,email,joindate,activationid
FROM vb3_user
LEFT JOIN vb3_useractivation ON (user.userid=useractivation.userid)
WHERE user.usergroupid=3 AND user.posts = 0

mysql error: Unknown table 'user' in field list

sabret00the

12-11-2004 02:37 PM

ok try this, it's stupid and shouldn't work but let me know

PHP Code:


		
			
// Get all users who have not activated their accounts.

$userArray=$DB_site->query("

SELECT username," . TABLE_PREFIX . "user.userid,email,joindate,activationid

FROM  " . TABLE_PREFIX . "user

LEFT JOIN " . TABLE_PREFIX . "useractivation ON (" . TABLE_PREFIX . "user.userid=" . TABLE_PREFIX . "useractivation.userid)

WHERE " . TABLE_PREFIX . "user.usergroupid=3 AND " . TABLE_PREFIX . "user.posts = 0

");

All times are GMT. The time now is 03:34 PM.

Page 9 of 21

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01320 seconds Memory Usage 1,760KB 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 (3)bbcode_php_printable (8)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
Messages: