Брояч на потребители?

[SuCcEsS]

Някой може ли да ми напише код за статистика:

Регистрирани: 0
На линия: 0
Регистрирани днес: 0
Регистрирани вчера: 0
Регистрирани този месец: 0

таблицата с потребителите е users и uID е пореден #!

 

[error]

Дай ми таблицата да се ориентирам и ще направя една статистика.

 

[vik96]

Имаш ли поле кога за последно се е логвал? Еми дата на регистриране ? С time() ли за записани?

 

[vik96]

<?

$time = time();

$al = mysql_query("SELECT `id` FROM `users`");
$all = mysql_num_rows($al);

$todaytime = $time - (60*66*24);
$today = mysql_query("SELECT `id` FORM `users` WHERE

`regdate`>'$todaytime'");
$regtoday = mysql_num_rows($today);

$ytime = $time - (60*66*24*2);
$ydaya = mysql_query("SELECT `id` FORM `users` WHERE `regdate`>'$ytime'

AND `regdate`<'$todaytime'");
$yday = mysql_num_rows($ydaya);

$mtime = $time - (60*66*24*30);
$mdaya = mysql_query("SELECT `id` FORM `users` WHERE

`regdate`>'$mtime'");
$mday = mysql_num_rows($mdaya);

echo "Registrirani potrebiteli : $all || dnes : $regtoday || v4era : $yday || za meseca :

$mday";

?>

 

[THE_ANARHIST]

Ето дб

CREATE TABLE `users` (
`uID` int(11) NOT NULL auto_increment,
`uEmail` text collate utf8_bin NOT NULL,
`uLogin` text collate utf8_bin NOT NULL,
`uPassword` text collate utf8_bin NOT NULL,
`uFirstName` text collate utf8_bin NOT NULL,
`uLastName` text collate utf8_bin NOT NULL,
`uGender` varchar(6) collate utf8_bin NOT NULL default '',
`uCode` text collate utf8_bin NOT NULL,
`uRace` smallint(2) NOT NULL default '1',
`uLevel` int(11) NOT NULL default '1',
`uGold` bigint(20) NOT NULL default '0',
`uBank` bigint(20) NOT NULL default '0',
`uCitizens` int(11) NOT NULL default '0',
`uOffensiveMen` int(11) NOT NULL default '0',
`uDefensiveMen` int(11) NOT NULL default '0',
`uMiners` int(11) NOT NULL default '0',
`uType` smallint(1) NOT NULL default '1',
`uTypeDays` int(11) NOT NULL default '90',
`uRank` smallint(1) NOT NULL default '1',
`uProfile` text collate utf8_bin NOT NULL,
`uDeposits` int(11) NOT NULL default '5',
`uDepositsMax` int(11) NOT NULL default '5',
`uInterestRate` smallint(2) NOT NULL default '1',
`uWeapon1` int(11) NOT NULL default '0',
`uWeapon2` int(11) NOT NULL default '0',
`uWeapon3` int(11) NOT NULL default '0',
`uWeapon4` int(11) NOT NULL default '0',
`uWeapon5` int(11) NOT NULL default '0',
`uArmour1` int(11) NOT NULL default '0',
`uArmour2` int(11) NOT NULL default '0',
`uArmour3` int(11) NOT NULL default '0',
`uArmour4` int(11) NOT NULL default '0',
`uArmour5` int(11) NOT NULL default '0',
`uMineLevel` smallint(1) NOT NULL default '1',
`uCastleLevel` smallint(1) NOT NULL default '1',
`uHouseLevel` smallint(1) NOT NULL default '1',
`uWallLevel` smallint(1) NOT NULL default '1',
`uTowersLevel` smallint(1) NOT NULL default '1',
`uEXP` int(11) NOT NULL default '0',
`uNextLevel` int(11) NOT NULL default '1000',
`uOffense` int(11) NOT NULL default '0',
`uDefense` int(11) NOT NULL default '0',
`uWon` int(11) NOT NULL default '0',
`uLost` int(11) NOT NULL default '0',
`uAttackTurns` int(11) NOT NULL default '500',
`uAttackTurnsMax` int(11) NOT NULL default '500',
`uRandomEvents` int(11) NOT NULL default '5',
`uRandomEventsMax` int(11) NOT NULL default '5',
`utime` varchar(255) collate utf8_bin NOT NULL default '*',
`ctime` varchar(255) collate utf8_bin NOT NULL default '*',
`timestart` varchar(255) collate utf8_bin NOT NULL default '0',
`startwork` varchar(255) collate utf8_bin NOT NULL default 'no',
`fortime` varchar(255) collate utf8_bin NOT NULL default '0',
PRIMARY KEY (`uID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;

ето каква е грешката като пробвах скрипта на vik96

Дава това:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\titanwars\count.php on line 6

Warning: mysql_query()

 

[federer_11]

ми направи си връзката с mysql де :lol:

 

[THE_ANARHIST]

Връзката е направена и пак нестава

 

[federer_11]

ако си вкарал връзката в някаква функция - извикай функцията, ако не - значи не си инклуднал файла или просто връзката ти е с грешно въведени данни.

 

[SuCcEsS]

Ето как инклуднах кофиг файла

<?
include ('includes/inc-config.php');

$time = time();

$al = mysql_query("SELECT `id` FROM `users`");
$all = mysql_num_rows($al);

$todaytime = $time - (60*66*24);
$today = mysql_query("SELECT `id` FORM `users` WHERE

`regdate`>'$todaytime'");
$regtoday = mysql_num_rows($today);

$ytime = $time - (60*66*24*2);
$ydaya = mysql_query("SELECT `id` FORM `users` WHERE `regdate`>'$ytime'

AND `regdate`<'$todaytime'");
$yday = mysql_num_rows($ydaya);

$mtime = $time - (60*66*24*30);
$mdaya = mysql_query("SELECT `id` FORM `users` WHERE

`regdate`>'$mtime'");
$mday = mysql_num_rows($mdaya);

echo "Registrirani potrebiteli : $all || dnes : $regtoday || v4era : $yday || za meseca :

$mday";

?>

и грешките които ми даде!

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\titanwars\count.php on line 9

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\titanwars\count.php on line 9

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\titanwars\count.php on line 10

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\titanwars\count.php on line 15

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\titanwars\count.php on line 15

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\titanwars\count.php on line 16

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\titanwars\count.php on line 21

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\titanwars\count.php on line 21

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\titanwars\count.php on line 22

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\titanwars\count.php on line 27

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\titanwars\count.php on line 27

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\titanwars\count.php on line 28
Registrirani potrebiteli : || dnes : || v4era : || za meseca :