public static function init()
{
if (config_essence::get('host', 'database') and config_essence::get('user', 'database') and config_essence::get('name', 'database')) {
self::$db = mysql_connect(config_essence::get('host', 'database'), config_essence::get('user', 'database'), config_essence::get('password', 'database'));
if (self::$db) {
if (mysql_select_db(config_essence::get('name', 'database'))) {
mysql_query("set character_set_client='utf8'");
mysql_query("set character_set_results='utf8'");
mysql_query("set collation_connection='utf8_general_ci'");
return true;
}
}
}
return false;
}
public static function get_total_comments($file_id = 0)
{
$sql = "SELECT COUNT(*) FROM `comments` ";
if (is_numeric($file_id) && $file_id > 0) {
$sql .= "WHERE `file_id` = " . database_essence::prepare($file_id);
}
if ($data = database_essence::get_one($sql)) {
return $data;
}
return null;
}
public static function get_total_users()
{
$sql = "SELECT COUNT(*) FROM `users`";
if ($data = database_essence::get_one($sql)) {
return $data;
}
return null;
}
