View file social/user/love/count.php

File size: 1.09Kb
<?




	$cel = "(




	`ank_lov_1` = '1' OR 




	`ank_lov_2` = '1' OR 




	`ank_lov_3` = '1' OR 




	`ank_lov_4` = '1' OR 




	`ank_lov_5` = '1' OR 




	`ank_lov_6` = '1' OR 




	`ank_lov_7` = '1' OR 




	`ank_lov_8` = '1' OR 




	`ank_lov_9` = '1' OR 




	`ank_lov_10` = '1' OR 




	`ank_lov_11` = '1' OR 




	`ank_lov_12` = '1' OR 




	`ank_lov_13` = '1' OR 




	`ank_lov_14` = '1'




	)";




	$orien = "(




	`ank_orien` = '1' OR 




	`ank_orien` = '2' OR 




	`ank_orien` = '3'




	)";




	$opar = "(




	`ank_o_par` IS NOT NULL 




	)";




	$osebe = "(




	`ank_o_sebe` IS NOT NULL 




	)";









$k_p = mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE $cel AND $orien AND $opar AND $osebe AND `date_last` > '".(time()-259200)."'"), 0);









$k_n = mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE $cel AND $orien AND $opar AND $osebe AND `date_reg` > '".(time()-8600)."'"), 0);









if ($k_n == 0)$k_n = NULL;









else $k_n = '+' . $k_n;









echo '(' . $k_p . ') <font color="red">' . $k_n . '</font>';




?>