Email Validation Check

Sergeant Joined: Aug 31, 2003 Posts: 127

Nice I love the concepts you guys have been working on. I am looknig forward to something like this to clean up some of the clutter that is happening of inactive users or inactive emails. I really like theidea of it deleting everything that was related to that one user including his posts. Nice idea's. Again I am glad I have recieved some great fedback here. You guys are fantastic. Looking forward to something to help me out here.

Posted: Sat Nov 01, 2003 9:38 pm

ok heres what i got
http://secretlab.voicesinmyhead.net/admin.php?op=userm
login with Gtest/Gtest

delete user is functional -just dont delete ALL my test users Smile

-if you do add a few back in for others to test with Smile

suspend user isn't implemented yet

i have discovered though if i use nuke_users_temp i have to either modify the structure (and potentially any file that uses that table) or drop all the extra user data (sig, icq, aim, etc) so i think i'm just gonna create a table with the exact structure of nuke_users and call it nuke_users_suspend

that also means i'll have to create a re-activation section for Your_Account
i'll prolly just make it an add in file like
modules.php?name=Your_Account&file=reactiv&code=E4h5G6af

my goal is to have this only add files to nuke rather that hack up exsisting ones (it'll make upgrading nuke easier)

Sergeant Joined: Aug 31, 2003 Posts: 127

I love it!! that is exactly what I am looking for in helping me clean some of the unused space on the site. disgruntledtech you DA MAN!!! I am very excited to see the finished product! Nice JOB! Are you going to place a link for download for us when done?
Boy I am really happy you guys took this project on. Very thankful to all of you! Especially disgruntledtech !! And to the forum Moderator who made this a sticky for me! NukeCops has been very helpful to me for a long time now. I am still a beginner whenit comes to PHP but learning. I cannot stop trying to write though. It is addictive.... HOpefully one day I can become as good as you all... If anyone has any good sies for php tutorials I would be appreciative in some links to be posted here. Surprised

) Again thanks disgruntledtech for spending your time making this for us.

Posted: Sun Nov 02, 2003 12:44 am

Lestat wrote:

thanks disgruntledtech for spending your time making this for us.

no thanks needed really. thanks for letting giving us the idea!

and of course i'll have it for d/l once i get suspend/unsuspend worked in.

the delete option only deletes the user from the usertable eventually i want to add a radio next to delete/suspend for 'purge' whice will wipe all traces of a user from the db
Erased.... from existence! -i dug that one up earlier LOL

i think i could also add an optional portion to notify the user if they try to login to a susended account but it would require editing the exsisting Your_Account module

Sergeant Joined: Aug 31, 2003 Posts: 127

LOL love the wav!! Laughing

Yeah you have come up with some nice ideas. You definitly deserve a thanks for this one. You Da Man! Damn I am so excited!! I cannot wait to see what you have when done. You keep throwing more and more ideas out on this one. I love it...

Sergeant Joined: Aug 31, 2003 Posts: 127

Any luck on a release soon?

Posted: Wed Nov 05, 2003 12:12 pm

Quote:

And to the forum Moderator who made this a sticky for me!

I'm flattered. Wink

Posted: Wed Nov 05, 2003 8:15 pm

sorry im just wrapping up 'my weekend' -im off tuesday/wednesday so i don't get a lot of work done on nuke on those days

Sergeant Joined: Aug 31, 2003 Posts: 127

KO NP!

Posted: Sun Nov 09, 2003 10:49 am

disgruntledtech wrote:

ok heres what i got
http://secretlab.voicesinmyhead.net/admin.php?op=userm
login with Gtest/Gtest

Looks good so far. One feature that would be nice is a 'select all' button to suspend or delete. I were to run it for all accounts last seen 6 months ago, I'd probably get 50 000. Kinda hard to click suspend for each Wink

Posted: Sun Nov 09, 2003 2:38 pm

hamesh wrote:

disgruntledtech wrote:

ok heres what i got
http://secretlab.voicesinmyhead.net/admin.php?op=userm
login with Gtest/Gtest

Looks good so far. One feature that would be nice is a 'select all' button to suspend or delete. I were to run it for all accounts last seen 6 months ago, I'd probably get 50 000. Kinda hard to click suspend for each Wink

yeah that kinda thing is best handled with javascript so i kinda left it out until the end but it will be in the final version.

i haven't laid down much code in the last few days but heres how i've decided to manage users when suspended:

all users data is moved to nuke_users_suspend (which is identical in structure except it has an extra field for suspend date and activation code)

now that will get them suspended. to reactivate a user i'll have to add a reactivate.php so the link in their email will look like modules.php?name=Your_Account&file=reactivate&code=463123379

but that will allow a user account to stay in suspend forever so i'll have to write a section that we can add to any file that is view frequently that clears 'dead' users from the db if they are past thier reactivation time.

but what do we do about users who dont check their mail?
should the login process be modified to tell a user 'your un/pw is correct but your account has been deactivated please check your email at superguy@hotmail.com for your reactivation instructions' or should we just modify it so that if they login their account becomes unsuspended.

thoughts?

Sergeant Joined: Aug 31, 2003 Posts: 127

Hmm good question considering not all emails go out to hotmail, yahoo, aol, and others all the time. I currently use resend email module to resend these type of emails not going out. I have to check daily.

Code:

<?php
/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
/************************************************************************/
/* Module by Gaylen Fraley */
/* http://gaylenandmargie.com/phpwebsite */
/* For use with nuke 6.5 - it may work on 6.0 though. */
/* 05/09/2003 - Released */
/* 05/18/2003 - Fixed password display in email and added hyperlink */
/* to the display to allow the Admin to activate the user */
/* right from the module. The password will now be changed */
/* when resending the email. */
/* 05/19/2003 - Added Modification facility to allow the Admin to make */
/* selected modifications to the temporary record. */
/************************************************************************/

if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
die ("You can't access this file directly...");
}

require_once("mainfile.php");
if (!is_admin($admin)) die ("Access Denied");
$module_name = basename(dirname(__FILE__));
get_lang("Your_Account");
$userpage = 1;

include("header.php");
include("config.php");
OpenTable();
title("$sitename: "._USERREGLOGIN."");
extract($HTTP_POST_VARS);

if (isset($submit) && $submit = 'Resend') {
$cons = "bcdfghjklmnpqrstvwxyz";
$vocs = "aeiou";
for ($x=0; $x < 6; $x++) {
   mt_srand ((double) microtime() * 1000000);
   $con[$x] = substr($cons, mt_rand(0, strlen($cons)-1), 1);
   $voc[$x] = substr($vocs, mt_rand(0, strlen($vocs)-1), 1);
}
$makepass = $con[0] . $voc[0] .$con[2] . $con[1] . $voc[1] . $con[3] . $voc[3] . $con[4];
$result = sql_query("select * from ".$user_prefix."_users_temp where user_id=".$rsid,$dbi);
if(!$result) die(_ERROR."<br>");
list($user_id, $username, $user_email, $user_password, $user_regdate, $check_num, $time) = sql_fetch_row($result, $dbi);
$finishlink = "$nukeurl/modules.php?name=Your_Account&op=activate&username=$username&check_num=$check_num";
$message = ""._WELCOMETO." $sitename!\n\n"._YOUUSEDEMAIL." ($user_email) "._TOREGISTER." $sitename.\n\n "._TOFINISHUSER."\n\n $finishlink\n\n "._FOLLOWINGMEM."\n\n"._UNICKNAME." $username\n"._UPASSWORD." $makepass";
$subject = ""._ACTIVATIONSUB."";
$from = "$adminmail";
$rc_email = mail($user_email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion());
if (FALSE!==$rc_email) {
   echo "The activation email for ".$username." has been sent.";
   $result = sql_query("update ".$user_prefix."_users_temp set user_password='".md5($makepass)."' where user_id=".$rsid,$dbi);
   echo "<form method=\"post\" action=\"modules.php?name=".$module_name."\"><input type=\"submit\" value=\"Back\"></form>";
}
else echo "An error ocurred while trying to send the email.";
}
elseif (isset($delete) && $delete = 'Delete') {
$result = sql_query("delete from ".$user_prefix."_users_temp where user_id=".$rsid,$dbi);
if(!$result) die(_ERROR."<br>");
echo "Temporary user record deleted.";
echo "<form method=\"post\" action=\"modules.php?name=".$module_name."\"><input type=\"submit\" value=\"Back\"></form>";
}
elseif (isset($update) && $update = 'Update') {
$result = sql_query("select * from ".$user_prefix."_users_temp where user_id=".$rsid,$dbi);
if(!$result) die(_ERROR."<br>");
$result = sql_query("update ".$user_prefix."_users_temp set username='".$username."', user_email='".$user_email."', user_regdate='".$user_regdate."', check_num='".$check_num."', time='".$time."' where user_id=".$rsid,$dbi);
if(!$result) die(_ERROR."<br>");
echo "Temporary user record modified.";
echo "<form method=\"post\" action=\"modules.php?name=".$module_name."\"><input type=\"submit\" value=\"Back\"></form>";
}
elseif (isset($modify) && $modify = 'Modify') {
$result = sql_query("select * from ".$user_prefix."_users_temp where user_id=".$rsid,$dbi);
if(!$result) die(_ERROR."<br>");
list($user_id, $username, $user_email, $user_password, $user_regdate, $check_num, $time) = sql_fetch_row($result, $dbi);
echo "<form method=\"post\" action=\"modules.php?name=$module_name&file=index&action=modify&rsid=$user_id\" name=\"modifyform$rsid\">";
echo '<table width="50%">';
echo '<tr><td align="right">User ID</td><td>'.$user_id.'</td></tr>';
echo '<tr><td align="right">User Name</td><td><input name="username" value="'.$username.'"></td></tr>';
echo '<tr><td align="right">User Email</td><td><input name="user_email" value="'.$user_email.'"></td></tr>';
echo '<tr><td align="right">User Password</td><td>'.$user_password.'</td></tr>';
echo '<tr><td align="right">User RegDate</td><td><input name="user_regdate" value="'.$user_regdate.'"></td></tr>';
echo '<tr><td align="right">CheckNum</td><td><input name="check_num" value="'.$check_num.'"></td></tr>';
echo '<tr><td align="right">Time</td><td><input name="time" value="'.$time.'"></td></tr>';
echo '<tr><td colspan=2><input type="submit" name="update" value="Update"></td></tr>';
echo '</table></form>';
}
else {
$result = sql_query("select * from ".$user_prefix."_users_temp",$dbi);
if(!$result) die(_ERROR."<br>");
while (list($user_id, $username, $user_email, $user_password, $user_regdate, $check_num, $time) = sql_fetch_row($result, $dbi)) {
   $finishlink = "<a href=\"$nukeurl/modules.php?name=Your_Account&op=activate&username=$username&check_num=$check_num\" target=\"_blank\">$nukeurl/modules.php?name=Your_Account&op=activate&username=$username&check_num=$check_num</a>";
   echo "<form method=\"post\" action=\"modules.php?name=$module_name&file=index&action=resend&rsid=$user_id\" name=\"resendform$rsid\">";
   echo "<table><tr><td>User Name</td><td>".$username."</td></tr><tr><td>User Email</td><td>".$user_email."</td></tr><tr><td>User regDate</td><td>".$user_regdate."</td></tr><tr><td>Activation Link</td><td>".$finishlink."</td></tr><tr><td><input type=\"submit\" name=\"submit\" value=\"Resend\">  <input type=\"submit\" name=\"modify\" value=\"Modify\">  <input type=\"submit\" name=\"delete\" value=\"Delete\"></td></tr></table>";
   echo "</form>";
}
}
CloseTable();
include("footer.php");
?>

This is the resend module I have to use every day and check on what is sitting the nuke_users_temp . So this question you ask is a tough one......

Posted: Sat Nov 15, 2003 2:42 am

alrighty heres a progress update:
there are now 3 types of searches:
missing information
last seen
suspended

step 2 now has nifty javascript for select all/unselect one
suspend is functional (no email sent yet)
all users info is backed up in nuke_users_suspend when suspended
unsuspend by user using modules.php?name=Your_Account&file=reactivate&username=whatever&code=jf45g64g6d6 (should work regardless of any changes to the Your_Account module) Very Happy

todo before release:
do send email when account is suspended
do send email when account is deleted (as an option)
add date suspended to _suspend
do unsuspend by admin
currently all fields are deactivated then activated by javascript. once the format is done i'll deactivate them with an onload event (to ensure compatibility for non javascript browsers)
do activate users in _temp

added after initial release:
search types for "unactivated" and "information matches(email contains @hotmail.com, sig is too big, etc)"
add search type for dead avatar(and an action to reset it)
add "super delete" or "purge" option -remove everything associated with a user -posts, PMs, journals, etc
user table backup/export
user table restore/import

NOTE: the script makes use of simple javascript to help understand the form and prevent mistakes but it will NOT rely on it

i still havn't figured out how i want to handle a user logging in but being in the suspend table -currently it'll just give them a bad user/pass error -might have to hack an option to change email/resend email to when a suspended user logs in.

see it at:
http://secretlab.voicesinmyhead.net/admin.php?op=userm

Posted: Sat Nov 15, 2003 10:13 am

Wow. Interface is much cleaner. Nice job on the select-all function. I was thinking the same thing for when a suspended user tries to login. Probably need to hack the Your_Account login so it checks nuke_users_suspend and if user is in table, display a message like 'this account has been suspended. Click here to sent activation email' or maybe just 'email admin to re-activate account' or something like that.

Sergeant Joined: Aug 31, 2003 Posts: 127

AWESOME job! I am salavating over here! Looking forward to your release once done. Well done Disgruntletech!