hello friends i am from india and i am fan of john cms i just know little bit russian .
I have updated my site to john cms 3.0 , now i had my dating site based on john cms now i have problem in showing seperate male and female online list . I am unable to create online list for it . I have created another
sex1 field in my database with value man and woman
Now i want to show separate online list of male users and female users
So please help me dear friends
Thanks in advance
Кароче народ, человек хочет иметь 2 онлайн листа, но чтобы в одном был список онлайн девушек, а в другом парней
dhruva, Our masters coming soon...
Гг, эт типа он по нашему не фурычет?! You must find good coder and on this site a many good mans and they can help you
.gif)
here is the previous john cms 2.40 separate online online list for male and female users
require_once ("../incfiles/core.php");
require_once ("../incfiles/head.php");
echo '<div class="phdr">Whos online?</div>';
$onltime = $realtime - 5000;
$q = @mysql_query("select * from `users` where lastdate>='" . intval($onltime) . "' and sex1 ='man' and sex ='m';");
$count = mysql_num_rows($q);
but how to change in in johncms 3.0
$onltime = $realtime - 300;
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `" . ($act == 'guest' ? 'cms_guests' : 'users') . "` WHERE `lastdate` > '$onltime'"), 0);
if ($total) {
$req = mysql_query("SELECT * FROM `" . ($act == 'guest' ? 'cms_guests' : 'users') . "` WHERE `lastdate` > '$onltime' ORDER BY " . ($act == 'guest' ? "`movings` DESC" : "`name` ASC") . " LIMIT $start,$kmess");
while ($res = mysql_fetch_assoc($req)) {
тханкс пелиа анд мастертман фор реплыинг ме
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `" . ($act == 'guest' ? 'cms_guests' : 'users') . "` WHERE `lastdate` > '$onltime' and sex1 ='man' and sex ='m'"), 0);
и хаве доне тхе саме бут итс нот шоркинг @арчангел
тханкс фор ёу реплы
ok friends, i thanks to archangel.
