| Topic Archived |
View previous topic :: View next topic |
| Author |
Message |
secureaspects Silver Supporter


Offline Joined: Sep 22, 2006 Posts: 26
|
Posted: Tue Jan 09, 2007 4:20 am Post subject: 3rd party userinfo block not counting reg users - 9.1.1 |
|
I was not sure if this goes here or in the installation forum. Well here it goes I upgraded to 9.1.1 and it went flawless, the only problem I have is, in my user info block the new registers today and new resgisters yesterday does not reflect it only shows 0. Any help would be appreciated please find th eexisting block code below.
| Quote:: |
// number of members
list($numusers) = $db->sql_ufetchrow('SELECT COUNT(*) FROM '.$user_prefix."_users WHERE user_id > 1 AND user_level > 0",SQL_NUM);
// users registered today
$day = L10NTime::tolocal((mktime(0,0,0,date('n'),date('j'),date('Y'))-date('Z')), $userinfo['user_dst'], $userinfo['user_timezone']);
list($userCount[0]) = $db->sql_ufetchrow("SELECT COUNT(*) FROM ".$user_prefix."_users WHERE user_regdate>='".$day."'", SQL_NUM);
// users registered yesterday
list($userCount[1]) = $db->sql_ufetchrow("SELECT COUNT(*) FROM ".$user_prefix."_users WHERE user_regdate<'".$day."' AND user_regdate>='".($day-86400)."'", SQL_NUM);
// latest member
|
secureaspects's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) 9.1
|
|
| Back to top |
|
 |
Phoenix • Many Posts •


Offline Joined: Apr 19, 2004 Posts: 8799 Location: Netizen
|
Posted: Tue Jan 09, 2007 6:02 am Post subject: Re: No new user count after upgrade. |
|
Which version did you upgrade from?
And, can you check your cms_users table and verify your user_regdate fields have valid (not 0) data?
Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
|
|
| Back to top |
|
 |
secureaspects Silver Supporter


Offline Joined: Sep 22, 2006 Posts: 26
|
Posted: Tue Jan 09, 2007 3:25 pm Post subject: Re: No new user count after upgrade. |
|
I upgraded from the latest version 9.0.6.1 and the cms_users table is showing ok everything in regards to the site is working except on the counter does not show new users today or yesterday. The new user gets onto the site and signed up properly. Thanks for your help on this.
secureaspects's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) 9.1
|
|
| Back to top |
|
 |
Phoenix • Many Posts •


Offline Joined: Apr 19, 2004 Posts: 8799 Location: Netizen
|
Posted: Tue Jan 09, 2007 3:36 pm Post subject: Re: No new user count after upgrade. |
|
okay, is the user_regdate field an integer, something like '1156784637'?
nm, you're not using the DragonflyCMS user info block.
_________________ • DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin •
Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
|
|
| Back to top |
|
 |
Sekki Nice poster


Offline Joined: Jun 18, 2005 Posts: 50 Location: Novi pazar
|
Posted: Tue Jan 09, 2007 6:52 pm Post subject: 3rd party userinfo block not counting registered users |
|
i`am update new version to DF...
and have problem...
Userinfo no view new user register today
Sekki's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux / MySQL Version 4.0.27-standard / PHP Version 4.4.2 / CMS Version 9.0.6.1
|
|
| Back to top |
|
 |
Eestlane I18N / L10N Lead Dev


Offline Joined: Apr 06, 2005 Posts: 1404 Location: Estonia
|
Posted: Tue Jan 09, 2007 7:08 pm Post subject: Re: have problems to DF |
|
But should there be any?
Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/2.0.63/5.0.67/5.2.8/9.2.1
|
|
| Back to top |
|
 |
BrokenCrust 500+ Posts Club


Offline Joined: Sep 06, 2004 Posts: 503
|
Posted: Tue Jan 09, 2007 7:45 pm Post subject: Re: have problems to DF |
|
38773 registered users?  That must be the biggest DF site out there!
I guess a time never went by before when no-one signed up for two days.
BrokenCrust please enter your server specs in your user profile!
|
|
| Back to top |
|
 |
Eestlane I18N / L10N Lead Dev


Offline Joined: Apr 06, 2005 Posts: 1404 Location: Estonia
|
Posted: Tue Jan 09, 2007 7:48 pm Post subject: Re: have problems to DF |
|
Oh, it's that user menu, I remember I had to do some updates for it to work with DF 9.1
Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/2.0.63/5.0.67/5.2.8/9.2.1
|
|
| Back to top |
|
 |
norbie Silver Supporter


Offline Joined: Jun 29, 2004 Posts: 737 Location: Norbie's World
|
Posted: Tue Jan 09, 2007 8:49 pm Post subject: Re: have problems to DF |
|
| Eestlane wrote: |
| Oh, it's that user menu, I remember I had to do some updates for it to work with DF 9.1 |
I think you robbed a copy off me didnt you?
Download the latest version of that block here:
dragonflycms.no/Downlo...=1535.html
_________________ Norbie

www.norbiesworld.co.uk
norbie's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux / Apache Custom Version / 4.0.26-standard (client: 5.0.15) / 4.4.4 / 9.1.1
|
|
| Back to top |
|
 |
NanoCaiordo Developer


Offline Joined: Jun 29, 2004 Posts: 3878 Location: Melbourne, AU
|
Posted: Tue Jan 09, 2007 9:44 pm Post subject: Re: No new user count after upgrade. |
|
| Phoenix wrote: |
| nm, you're not using the DragonflyCMS user info block. |
yeah seems that there is a 3rd party user info block that doesn't work with 9.1.1
_________________ .:: I met php the 03 December 2003 :: Unforgettable day! ::.
Linux 64bit / Apache 2.2 / PHP 5.4 / MySQL 5.5.22 / v9, v10
Linux 32bit / Apache 2.2 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
Windows 64bit / IIS 7.5 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) mixed
|
|
| Back to top |
|
 |
Sekki Nice poster


Offline Joined: Jun 18, 2005 Posts: 50 Location: Novi pazar
|
Posted: Tue Jan 09, 2007 9:49 pm Post subject: Re: have problems to DF |
|
Thanks Problem is fix ;D
Sekki's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux / MySQL Version 4.0.27-standard / PHP Version 4.4.2 / CMS Version 9.0.6.1
|
|
| Back to top |
|
 |
NanoCaiordo Developer


Offline Joined: Jun 29, 2004 Posts: 3878 Location: Melbourne, AU
|
Posted: Tue Jan 09, 2007 9:58 pm Post subject: Re: 3rd party userinfo block not counting registered users |
|
topics merged
_________________ .:: I met php the 03 December 2003 :: Unforgettable day! ::.
Linux 64bit / Apache 2.2 / PHP 5.4 / MySQL 5.5.22 / v9, v10
Linux 32bit / Apache 2.2 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
Windows 64bit / IIS 7.5 / PHP 5.3.10 / MySQL 5.5.22 / v9, v10
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) mixed
|
|
| Back to top |
|
 |
albiurs Nice poster


Offline Joined: Sep 12, 2005 Posts: 77
|
Posted: Tue Jan 09, 2007 10:30 pm Post subject: Re: 3rd party userinfo block not counting registered users |
|
albiurs's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/Apache/MySQL 5.0.45/PHP 5.2.2/DF 9.2.1
|
|
| Back to top |
|
 |
Eestlane I18N / L10N Lead Dev


Offline Joined: Apr 06, 2005 Posts: 1404 Location: Estonia
|
|
| Back to top |
|
 |
|
|