vb.org Archive

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, 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

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
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?

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
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...

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
"
); 


jluerken 12-11-2004 02:43 PM

This seems to work. Thanks man. Please update your hack according to this!

sabret00the 12-11-2004 03:43 PM

i will update it soon, i just need to get round to adding the other features first :)

i.e. better logging in the task logs rather than just stating it's been done and email to specified user to log the events there also.

nubian 12-12-2004 12:09 AM

i didn't see anything concrete but does this work for 3.0.3?
thanks

sabret00the 12-12-2004 12:50 AM

yes it's working with vb3.0.3 :)

nubian 12-14-2004 03:13 AM

---edit i'm retarded :o

sv1cec 12-16-2004 08:14 AM

I've been using this hack for some time, and it works OK (3.0.3), but I have one question.

From the code, I assume that the cron script checks if a user is in group 3 (waiting activation) and has zero posts, and then it proceeds to check if his activation code is empty (I do not know in which case this happens) when it generates an activation code for those users. If it is not empty, it changes the activation code for the users.

Why do you do that? I mean a user has registered and is send an e-mail with an activation code. He receives it today, and he does not activate for two days. Then he tries to activate, but the script has changed his activation id, to something else, when it was run some time during the evening of the first day. Is this what happens? I would expect a change of activation code, to occur only for those users who have reached the limit of 3, 5 or 8 days, just before the new e-mail is send.

The reason I am asking, is that I have received several problems from users who try to activate and they can't. Then when I send them a new activation code, they activate fine, if they do it immediately (I do not know what happens if they do not do it immediately, haven't discuss it with anyone).

I would appreciate your comments.

Rgds

sabret00the 12-16-2004 09:49 AM

the reason that it was done that way was because, when it tried to extract the initial activation code from the database it would always come up empty, so the fix was making a new one, it was one of the earlier bug fixes by boofo.

nubian 12-18-2004 12:48 PM

i've created a test user who has not been activated via email.
seems like the script works when sending out mail but the mail text body is empty..no subject no text in the body.
somebody please help.
thanks in advance

sabret00the 12-18-2004 01:02 PM

Quote:

Originally Posted by nubian
i've created a test user who has not been activated via email.
seems like the script works when sending out mail but the mail text body is empty..no subject no text in the body.
somebody please help.
thanks in advance

did you install the templates included in the zip?

nubian 12-18-2004 01:06 PM

Quote:

Originally Posted by sabret00the
did you install the templates included in the zip?

i was going to delete what i said.
i did something retarded and added the templates to my default style template and not another template that i'm currently using.
shame on me.
hopefull it'll work
thanks for the speedy reply though

sv1cec 12-18-2004 02:23 PM

Quote:

Originally Posted by sabret00the
the reason that it was done that way was because, when it tried to extract the initial activation code from the database it would always come up empty, so the fix was making a new one, it was one of the earlier bug fixes by boofo.

I am not sure why this was happening, but I just created a test user and I got his activation code fine, from the useractivation table, the same as the one send to him in the e-mail.

But even if for some reason you find the activation code empty, what is the reason for creating a new id for users who have already one?

As far as I am concerned, I am removing the else part from that if.

Rgds

sabret00the 12-18-2004 02:33 PM

fair doo's however i don't get why you're saying it with such attitude? after all this is a free script you're using is it not?

sv1cec 12-18-2004 02:58 PM

Quote:

Originally Posted by sabret00the
fair doo's however i don't get why you're saying it with such attitude? after all this is a free script you're using is it not?

Pardon me, I was not having any attitude, I was just trying to get your experience and expertise on that.

I asked why you are changing the activation code, and you replied to me that you create a new one, because sometimes you find empty ids. I understand that, but I am still puzzled why you are changing the existing codes, when that action prevents users from activating their accounts.

Don't you think that other members who have installed this hack should know that, when users start e-mailing them with questions why they can't activate?

If you don't have an explanation, fine, no problem, I'll do what I think is appropriate, but don't accuse me of an attitude, when all I am doing is trying to understand what you are doing, in this hack. I think I have that right, or am I wrong?

sabret00the 12-18-2004 03:31 PM

Quote:

Originally Posted by sv1cec
Pardon me, I was not having any attitude, I was just trying to get your experience and expertise on that.

I asked why you are changing the activation code, and you replied to me that you create a new one, because sometimes you find empty ids. I understand that, but I am still puzzled why you are changing the existing codes, when that action prevents users from activating their accounts.

Don't you think that other members who have installed this hack should know that, when users start e-mailing them with questions why they can't activate?

If you don't have an explanation, fine, no problem, I'll do what I think is appropriate, but don't accuse me of an attitude, when all I am doing is trying to understand what you are doing, in this hack. I think I have that right, or am I wrong?

ok to explain this, the original hack was ported from vb2 and set to run instead of activate.php in the crons directory, at that point when first released boofo ran it on his server and reported the bug that no id was being sent, i confirmed this via my server, under both tests there no. infact sorry afrer re-reading the thread it was bryan that reported it and it was fixed by Pscio https://vborg.vbsupport.ru/showpost....5&postcount=29 at that point everyone was happy and it was a great triumph for an open source project such as this one, don't get me wrong i understand why you'd not like the id reset but
Quote:

As far as I am concerned, I am removing the else part from that if.
the tone in your original post was offensive to me being someone that's ported this from vb2 and supported it to the best of my ability since then.

it's a saturday afternoon i have a hangover and and don't even have time to do such leisurly things as updating the hack yet i find time to do support i'm just stating that i didn't like your tone (attitude) i do beleive i have the right to do that or am i wrong?

sabret00the 12-18-2004 04:22 PM

[high]version 2.4 has been released[/high]

sv1cec 12-18-2004 05:06 PM

Quote:

Originally Posted by sabret00the
ok to explain this, the original hack was ported from vb2 and set to run instead of activate.php in the crons directory, at that point when first released boofo ran it on his server and reported the bug that no id was being sent, i confirmed this via my server, under both tests there no. infact sorry afrer re-reading the thread it was bryan that reported it and it was fixed by Pscio https://vborg.vbsupport.ru/showpost....5&postcount=29 at that point everyone was happy and it was a great triumph for an open source project such as this one, don't get me wrong i understand why you'd not like the id reset but the tone in your original post was offensive to me being someone that's ported this from vb2 and supported it to the best of my ability since then.

it's a saturday afternoon i have a hangover and and don't even have time to do such leisurly things as updating the hack yet i find time to do support i'm just stating that i didn't like your tone (attitude) i do beleive i have the right to do that or am i wrong?

It seems that your hangover made you grumpy.

The quote you mention was not meant in any attitude.

I believe that the role of us here, is to help users of our hacks. So, I asked a question and I didn't get an answer, so the least I can do is to inform other users that there is a problem here. And I did it in a very polite way, by just saying what I am going to do. I didn't suggest others to do the same, I didn't emphasize the problem.

Instead of thanking me for locating a serious problem in your code, you accused me of having an attitude. Of course and you have the right to not like my tone (I assume you mean "my writings", because you can't hear my tone), but since you agreed to provide support from this hack, you'd better answer your user's questions, before criticizing their attitude.

Boofo 12-18-2004 05:51 PM

Quote:

Originally Posted by sv1cec
It seems that your hangover made you grumpy.

That was a cheap shot.

Quote:

Originally Posted by sv1cec
but since you agreed to provide support from this hack, you'd better answer your user's questions, before criticizing their attitude.

Just because an author "agrees" to provide support for a hack, doesn't mean he/she has to drop everything and run to it the second there is a problem. Authors DO have private lives, too. They are sharing something with everyone, not getting paid or reimbursed in any way for it. telling someone they'd "better answer their your user's questions, before criticizing their attitude" isn't going to make the author want to run to help anyone. You get more flies with honey. Something to think about. ;)

sv1cec 12-18-2004 06:17 PM

Quote:

Originally Posted by Boofo
Just because an author "agrees" to provide support for a hack, doesn't mean he/she has to drop everything and run to it the second there is a problem. Authors DO have private lives, too. They are sharing something with everyone, not getting paid or reimbursed in any way for it. telling someone they'd "better answer their your user's questions, before criticizing their attitude" isn't going to make the author want to run to help anyone. You get more flies with honey. Something to think about. ;)

I didn't expect you to leave your life and answer my question. I posted the initial question on 16. Dec 2004, 13:14, and I came back to check the answer one day and several hours later.

So stop making accusations for non-existing things. Nobody asked you to leave whatever you were doing and come to answer.

But when you decide to answer, you'd better answer the asked question. And you didn't, for whatever reasons, I do not care. And I tried, as politely as I could, to draw your attention to the fact that this was a serious problem. If you want, I can forward to you the e-mails I've received from people who couldn't activate, because of your code. And I didn't complain, I didn't accuse you of anything, I just tried to get your attention, and the attention of other people who are using your hack, by simply stating what I am going to do. And you got angry about it, and accused me of having an attitude.

And if honey gets you more flies, so what? What was I supposed to do? Be apologetic? For what? For your luck of answer? From what I saw, you issued a new version of your hack, to correct the problem I noticed. If I were not as persistent, I am sure the hack will continue like that for who knows how long (because coders have lives as you say, and don't have time to support their users), causing admins headaches from users who wouldn't be able to activate, one day after they received the activation e-mail.

In any case, I deny to continue this confrontation. Case closed for me.

sabret00the 12-18-2004 08:17 PM

none of it matters, lets just enjoy the hack and community :)

sv1cec 12-19-2004 04:28 AM

Quote:

Originally Posted by sabret00the
none of it matters, lets just enjoy the hack and community :)

My point exactly. Have a great Sunday.

Goodday to you.

qhoa 12-20-2004 11:00 PM

i tried installed the ver 2.4 and i got this error
Quote:

Manage Activation
Fatal error: Cannot redeclare convert_short_varnames() (previously declared in C:\VBB\forums\includes\init.php:118) in C:\vbb\forums\includes\init.php on line 118
What wrong i did
thanks

sabret00the 12-21-2004 08:18 AM

did you edit the file qhoa?

qhoa 12-21-2004 10:38 AM

yes sab....
I already did follow the intruction
chdir("K:/Network/xampp/htdocs/forums/"); //change to my vbulletin path
that's all i did
upload this file into include/cron then going to schedule tasks set it up
when i run it i got that error

sabret00the 12-21-2004 11:43 AM

chdir("K:/Network/xampp/htdocs/forums/"); //change to my vbulletin path

that line should read something like
chdir("/home/SITENAME/public_html/forums/"); //change to my vbulletin path

by teh time you finished with it.

qhoa 12-21-2004 12:05 PM

yeah i did
i change my VB path

sabret00the 12-21-2004 12:13 PM

then sadly i have no idea why it's not working, especially as i'm not asking it declare short names in the first place :(

qhoa 12-21-2004 12:14 PM

before i install this hack i already read all the post in this thread
in this case i feel something wrong in the db query code inside of .php file
but i unable to find out by my self and i think i can't done this without all you guy
please help
oh because my site it's non english thatwhy i'm not giving you a link but i thought it's not needed to you
anotherwords, in line 118 of the init.php is
118 function convert_short_varnames(&$array, $add_to_REQUEST = false)
i hope it enought info for you

qhoa 12-21-2004 12:27 PM

i tried to install it with my localhost (my lab) i have the same error too

qhoa 12-21-2004 12:31 PM

oh i found it thank you thank you
in the manageActivation.php
i add the code
if (!is_object($DB_site))
{
exit;
}
below the
error_reporting(E_ALL & ~E_NOTICE);

then line require_once("./global.php");
i replace with //require_once("./global.php");
anh it work on me
but i still thank you to you Sa... to try help me
you have a greate day Sa....

qhoa 12-21-2004 12:41 PM

but it is not clearn the member has none active after 10 days from reg date
you have any idea
i tried to run manual (by click run now button)
and i got this message
Manage Activation

Done

that's all
i check my member list they still there
sorry guy i really don't know what wrong with it


All times are GMT. The time now is 06:09 AM.

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.01612 seconds
  • Memory Usage 1,863KB
  • 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
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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