// ******************************************************************* // admin/main.php // ******************************************************************* include("../include/config.php"); include("../include/functions.php"); include("../include/common.php"); $language = $gl["Language"]; include("../include/lang/$language.php"); include("../include/session.php"); session_start(); $temp = sql_query(" select * from $tb_temp "); $reviews = sql_query(" select * from $tb_reviews where Status='New' "); $sites = sql_query(" select count(*) as count from $tb_links "); $sites_array = sql_fetch_array($sites); $categories = sql_query(" select count(*) as count from $tb_categories "); $categories_array = sql_fetch_array($categories); ?>
| Main Page |
|
You have =sql_num_rows($temp)?> new sites to validate.
You have =sql_num_rows($reviews)?> new site reviews to validate. You have =$sites_array["count"]?> total sites. Edit Sites. You have =$categories_array["count"]?> total categories. Edit Categories. $rel_query = sql_query(" select $tb_categories.ID as cat_id from $tb_categories left join $tb_related on $tb_categories.ID=$tb_related.cat_id where $tb_related.cat_id is null and $tb_categories.PID != '0' order by $tb_categories.ID "); $rel_count = sql_num_rows($rel_query); ?> if($rel_count>0){?>You have =($rel_count+0)?> unrelated categorie if($rel_count != 1){ echo "s";}?>. }?> $sql = sql_query(" select count(*) as count from $tb_sessions where expire > UNIX_TIMESTAMP() - 300 "); $rows = sql_fetch_array($sql); ?> There if($rows["count"] != 1 ){ echo "are";} else { echo "is"; }?> =($rows["count"]+0)?> visitor if($rows["count"]!=1){ echo "s";}?> online including yourself. |
| Help fund phpLinks development: |