vb.org Archive
Page 5 of 6 « First 34 5 6
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)

Slave 03-03-2005 01:39 AM
Got this working .. nice hack :)

Am I right in thinking that I should delete the "Activation Reminder Email" cron job?

sabret00the 03-06-2005 07:56 PM
Quote:
Originally Posted by Slave
Got this working .. nice hack :)

Am I right in thinking that I should delete the "Activation Reminder Email" cron job?
yeah, you should. not the file but the cron.

Slave 03-07-2005 08:03 AM
Quote:
Originally Posted by sabret00the
yeah, you should. not the file but the cron.
Ta .. :)

Leeper 03-29-2005 01:04 AM
OK, I've got to disable this thing temporarily until I can get some help. I installed this about two weeks ago and started receiving email that my site was spaming new registraints with up to 700 emails requiring them to click on the link (that was already expired) to activate their account.
I really want to get this thing running but I'm hesitant after pumeling a few of the new users with a ton of email.

Anyone got any ideas on what I might have missed that would cause this to happen?

sabret00the 03-29-2005 08:15 AM
Quote:
Originally Posted by Leeper
OK, I've got to disable this thing temporarily until I can get some help. I installed this about two weeks ago and started receiving email that my site was spaming new registraints with up to 700 emails requiring them to click on the link (that was already expired) to activate their account.
I really want to get this thing running but I'm hesitant after pumeling a few of the new users with a ton of email.

Anyone got any ideas on what I might have missed that would cause this to happen?
my suggestion would be to install it, then register yourself and see just how many you receive.

Leeper 03-29-2005 12:14 PM
Yeah I did that on the first report of this problem and had no problem. Then I had several others report the same problem and the issue seemed to be expanding exponentially. I had installed 5 hacks in the past 2 weeks so I started looking at these individually and when I got to this one I went through the instructions again and it finally dawned on me (I’m a little slow on the up take). I didn’t want to delete the old “activation” cron job until I saw this one working correctly so I just zeroed out all the timed fields in the task and that should do it right… Wrong! The activation was kicking off every minute and resetting the codes as it went on at its feverish pace. I changed the setting to run once a month (on the old cron) and will delete the task in two weeks if no more problems are reported.

Thanks!

Kaishi 04-20-2005 04:46 AM
for some reason, a user's name got reported twice in my email, like this
3 Day Reminder Sent To: Xantrix, Xantrix

also got this when i tried to run the cron manually to test it

Sent 5 Day email to Test1
Sent 5 Day email to McHavoc
Sent 3 Day email to Xantrix
Sent 3 Day email to Xantrix
Sent 3 Day email to Ensui

it's sent out twice to xantrix here too :( , does anyone know what's wrong?

T3MEDIA 04-20-2005 11:18 AM
Quote:
Originally Posted by T3MEDIA
would LOVE a add on that would check to see if the deleted user has a photopost folder and delete that as well.
think this could be an addon?

sabret00the 04-20-2005 11:25 AM
Quote:
Originally Posted by Kaishi
for some reason, a user's name got reported twice in my email, like this
3 Day Reminder Sent To: Xantrix, Xantrix

also got this when i tried to run the cron manually to test it

Sent 5 Day email to Test1
Sent 5 Day email to McHavoc
Sent 3 Day email to Xantrix
Sent 3 Day email to Xantrix
Sent 3 Day email to Ensui

it's sent out twice to xantrix here too :( , does anyone know what's wrong?
is it just that user that's getting special treatment?

sabret00the 04-20-2005 11:26 AM
Quote:
Originally Posted by T3MEDIA
think this could be an addon?
could be but not by me.

Kaishi 04-20-2005 03:47 PM
Quote:
Originally Posted by sabret00the
is it just that user that's getting special treatment?
for now, it seems xantrix is the only one that has his name appear twice.

Cyricx 04-20-2005 04:26 PM
Do you have phpmyadmin?

If so, first to go the admincp -> users -> search for users -> xantrix and then at the top you'll see User: Xantrix (id:XX)

Write that number down, then go into your phpmyadmin and check out the useractivation table

browse it and see if there is multipe entries for that userid.

Not sure how it could have happened, but that's the table this hack gets it's info from as it's the one I clear out when I reload my test site. :)

Kaishi 04-20-2005 07:23 PM
i checked the useractivation table, only 1 entry of xantrix's ID, but there's a duplicate of someone else's id. the person with the same ID appearing 2 times in the table, i had activated myself in admin cp, so i dunno >.<

by the way, is it safe for me to clear out the userids that i have activated manually in the useractivation table?

Kaishi 04-22-2005 04:02 AM
new update. the problem seems to extend past xantrix.

manageActivation Complete;
3 Day Reminder Sent To: Ludin, Shadey, Niell, Niell, Otik, Otik, Beachboy, Beachboy, sunnydolor, sunnydolor.

5 Day Reminder Sent To: Xantrix, Xantrix.

8 Day Reminder Sent To: None.

Users Deleted: No one was deleted.

please help, i love this script, would love to have it work correctly.

Marco van Herwaarden 04-22-2005 05:32 AM
Had a look into this problem and i think i know why some users show up double.

If you send a new activation mail from AdminCP (user contacted you to say they never received the mail??), vB will add a second record for that user into the 'useractivation' table, making this script see 2 waiting activations.

Can you confirm this scenario?

Kaishi 04-22-2005 05:58 AM
Quote:
Originally Posted by MarcoH64
Had a look into this problem and i think i know why some users show up double.

If you send a new activation mail from AdminCP (user contacted you to say they never received the mail??), vB will add a second record for that user into the 'useractivation' table, making this script see 2 waiting activations.

Can you confirm this scenario?
i don't know if the user themselves clicked on resend validation or whatever link it was. but i looked inside the useractivation table and there it was indeed multiple entries of those people's ID's, each with a different activation ID. hope that helps with troubleshooting.

also, is it safe to delete the contents in the useractivation table after this 'bug' have been fixed? or will it be fine to just leave it there as it is?

Marco van Herwaarden 04-22-2005 06:09 AM
The double entries in the useractivation table are not caused by this hack, it is standard vB behaviour. It is only that this hack don't check for double ones, so there should be no reason to manually remove entries from that table.

Kaishi 04-22-2005 06:12 AM
is there a way to intergrate checking for double IDs? i found it strange that close to every user that it sends out reminders to, are getting double.

sabret00the 04-22-2005 09:35 AM
you could try changing
PHP Code:
        SELECT user.username, user.userid, user.email, user.joindate, useractivation.activationid 
to
PHP Code:
        SELECT DISTINCT(user.username), user.userid, user.email, user.joindate, useractivation.activationid 

Marco van Herwaarden 04-22-2005 09:53 AM
Better to edit the manageActivation.php.

Find:
PHP Code:
    $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 
    "); 
And replace by:
PHP Code:
    $userArray=$DB_site->query("
        SELECT username,user.userid,email,joindate,activationid 
            FROM " . TABLE_PREFIX . "useractivation AS useractivation
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=useractivation.userid)
            WHERE dateline = 
                (select MAX(dateline) FROM " . TABLE_PREFIX . "useractivation AS ua2 WHERE ua2.userid = useractivation.userid)
            AND user.usergroupid=3 AND user.posts = 0    "); 
Your code wouldn't work sabe, try it.

PS I not tried my solution, so test it on a testboard first.

Not tested, but i think that would do the trick.

Kaishi 04-22-2005 03:38 PM
marcho your code got me this error, did i copy something wrong?

PHP Code:
Database error in vBulletin 3.0.7:

Invalid SQL: 
        SELECT username,user.userid,email,joindate,activationid
            FROM useractivation AS useractivation
            LEFT JOIN user AS user ON(user.userid=useractivation.userid)
            WHERE dateline =
                (select MAX(dateline) FROM useractivation AS ua2 WHERE ua2.userid = useractivation.userid)
            AND user.usergroupid=3 AND user.posts = 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 'select MAX(dateline) FROM useractivation AS ua2 WHERE ua2.useri

mysql error number: 1064 

Marco van Herwaarden 04-22-2005 04:03 PM
What MySQL version are you using?

Kaishi 04-22-2005 04:06 PM
Quote:
Originally Posted by MarcoH64
What MySQL version are you using?
4.0.22-standard

Marco van Herwaarden 04-22-2005 06:41 PM
Hmm not sure, will look if there are any clauses used that where not allowed in 4.0 a litle bit later.

Marco van Herwaarden 04-22-2005 07:51 PM
Just checked this subquery is not allowed in MySQL 4.0. :(

Will have to rewrite it using LEFT JOINs. Will be a tough one. Will try if i can have a look this weekend.

Kaishi 04-23-2005 03:07 AM
Quote:
Originally Posted by MarcoH64
Just checked this subquery is not allowed in MySQL 4.0. :(

Will have to rewrite it using LEFT JOINs. Will be a tough one. Will try if i can have a look this weekend.
i really appreciate it! thanks alot in advance. i love this vb.org community, i couldn't get help with stuff anywhere else for some reason.

Kaishi 04-28-2005 04:39 PM
i hope you guys didn't forget about me :(

Marco van Herwaarden 04-28-2005 07:28 PM
Quote:
Originally Posted by Kaishi
i hope you guys didn't forget about me :(
Actually i did. :(

Is a bit hectic these days and i can't spend as much time as i would like on vB. Will try to find some time to have a look at your problem in the next days i hope.

Kaishi 04-28-2005 07:33 PM
:D ok

Kaishi 05-05-2005 04:24 AM
another problem kinda. sometimes it would send a 3/5/8 day reminder to someone, then the next day it would send the same reminder again. for example, today user x got a 3 day reminder, tomorrow, he gets a 3 day reminder again.

sabret00the 05-05-2005 07:02 PM
Quote:
Originally Posted by Kaishi
another problem kinda. sometimes it would send a 3/5/8 day reminder to someone, then the next day it would send the same reminder again. for example, today user x got a 3 day reminder, tomorrow, he gets a 3 day reminder again.
i've never got this myself but am testing it with today and tomorrow's mailout.

Kaishi 05-07-2005 04:09 AM
on the http://www.ebslive.com/confessions/?do=confess page, somehow

the vboptions[hometitle] confession box is about relief...

the vbtoptions[hometitle] didn't parse, or that u forgot a $. that's on your site btw lol

edit: i'm such a dumb ass sometimes, i posted on the wrong thread! lol

kall 05-19-2005 11:16 PM
I might just be really stupid but... do we delete the existing Manage Activation cron task?

I have a test account that keeps getting the standard one..minus the 'we will delete you in 2 days' and stuff.

Sadie Frost 06-14-2005 01:25 AM
Does anyone know if this will still work with 3.5? (since it did not require file edits) :)

ADM 06-28-2005 03:45 AM
hmm I also have that problem where it sends a notice to the same users who received one the day before.

For example:

June 27th:
Quote:
manageActivation Complete;
3 Day Reminder Sent To: tit24, Dragontalin, Jonny, William Of Occam, Musopticon?, jolepros.

5 Day Reminder Sent To: Taiwnoser, Razier, Clnqt, trigun0006, crusaderqb207, kmcqb207, Kill Switch.

8 Day Reminder Sent To: Ghast.

Users Deleted: No one was deleted.
June 28th:
Quote:
manageActivation Complete;
3 Day Reminder Sent To: QwNtacular, tit24, Dragontalin, Jonny.

5 Day Reminder Sent To: Clnqt, trigun0006, crusaderqb207, kmcqb207, Kill Switch, William Of Occam, Musopticon?, jolepros.

8 Day Reminder Sent To: Ghast.

Users Deleted: MaxPayne.

sabret00the 06-28-2005 08:06 AM
Quote:
Originally Posted by kall
I might just be really stupid but... do we delete the existing Manage Activation cron task?

I have a test account that keeps getting the standard one..minus the 'we will delete you in 2 days' and stuff.
just don't run it, so yes delete the cron but not the file.


Quote:
Originally Posted by Sadie Frost
Does anyone know if this will still work with 3.5? (since it did not require file edits)
not at present but when it goes gold i will update the hack.


Quote:
Originally Posted by ADoomedMarine
hmm I also have that problem where it sends a notice to the same users who received one the day before.
i'm still to receive this problem, however i'm sure marco said at some stage that it may be due to that user activating twice, or something similar.

ADM 06-28-2005 04:08 PM
I've just had a user receive an 8 day notice 3 days in a row.

Is there any way I can fix this? This is happening quite frequently on my setup.

okc 07-27-2005 07:31 AM
I like the hack, but I've got a problem - I set up a dummy account to see if it was working properly and while it said it emailed me for being 3 days delinquent (which was right), I never got the email (problem). I checked & I can email from vB OK, the hack just doesn't get the email there - any ideas?

thx

sabret00the 07-27-2005 08:09 AM
Quote:
Originally Posted by okc
I like the hack, but I've got a problem - I set up a dummy account to see if it was working properly and while it said it emailed me for being 3 days delinquent (which was right), I never got the email (problem). I checked & I can email from vB OK, the hack just doesn't get the email there - any ideas?

thx
you can receieve emails on the same installation via the admincp but not the cron?

okc 07-27-2005 03:30 PM
Problem 1 - I get the status/notification email, which says it sent a reminder to my test account email, but I never get that email at my test account. Somehow the email reminder does not go out.

Should the chdir line look something like this?
chdir('/home/public_html/forums/')

Problem 2 - I'm getting about 100 emails giving me status/notification (3 day users notified, etc) - a few every few minutes - I'd like to fix this.


All times are GMT. The time now is 07:38 PM.
Page 5 of 6 « First 34 5 6
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.01401 seconds
  • Memory Usage 1,857KB
  • 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
  • (5)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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