0007680: Successful Sign up should set login count to 1

ID	Project	Category	View Status	Date Submitted	Last Update
0007680	mantisbt	signup	public	2006-12-21 21:01	2012-06-13 05:31

Reporter	vboctor	Assigned To	vboctor
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	fixed
Product Version	1.1.0a2
Target Version	1.1.0	Fixed in Version	1.1.0a3

Summary	0007680: Successful Sign up should set login count to 1
Description	Users who sign up and visit the site to set the password and visit the rest of the site are reported as never logged in and can potentially be pruned by the administrator if they don't login again. The query to fix those instances is: UPDATE `mantis_user_table` SET LOGIN_COUNT = 1 WHERE `date_created` <> `last_visit` Also the query that retrieves the users who have never logged in can be changed to include two checks: ( login_count = 0 ) AND ( date_created = last_visit )
Tags	No tags attached.

exk72 2006-12-22 00:44 reporter ~0013857 Last edited: 2006-12-22 01:17	why not add user_increment_login_count to verify.php may want the ability to also prune accounts that have only logged in once may want to alter the above SQL to include in the WHERE clause an AND LOGIN_COUNT = 0

vboctor 2006-12-22 01:56 manager ~0013858	Yep, the main fix planned for this feature is to increment the login count when the users verifies the email address. However, the other information was included in order to document solutions for handling existing users who are currently marked as never logged in although they did. This may not be a common scenario, but it was a common scenario for the Mantis demo bug tracker.

vboctor 2007-02-19 23:45 manager ~0014066	The fix included the following: Fixed the SQL query that prunes accounts that never logged in and has been registered for more than a week. Fixed the query that shows the users who never logged in to also check that last login time != registration time. Fixed the verify script to increment the login count.

MantisBT: master d306af51 2007-02-20 00:43 vboctor Details Diff	Fixed 0007680: Successful Sign up should set login count to 1. git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@4276 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9	Affected Issues 0007680
	mod - manage_user_page.php	Diff File
	mod - verify.php	Diff File
	mod - manage_user_prune.php	Diff File