1
Mods & Plugins (Releases & Support) / Re: [MOD] Download Counter User Images in Profile
« on: February 05, 2009, 01:31:39 AM »
First of all thank you so much...is there a copy of this in english?
//--- Ab hier zusätzliche Infos im Benutzerprofil -----------------------------------------
//--- Download von Bildern des Users im Profil , von mawenzi , 10.07.2008 -----------------
$sql = "SELECT SUM(image_downloads) AS sum_downloads
FROM ".IMAGES_TABLE."
WHERE ".get_user_table_field("", "user_id")." = ".$user_id."";
$row = $site_db->query_firstrow($sql);
$sum_downloads = (isset($row['sum_downloads'])) ? $row['sum_downloads'] : 0;
$sql = "SELECT COUNT(*) AS count_downloads
FROM ".IMAGES_TABLE."
WHERE ".get_user_table_field("", "user_id")." = ".$user_id."
AND image_downloads > 0";
$row = $site_db->query_firstrow($sql);
$count_downloads = (isset($row['count_downloads'])) ? $row['count_downloads'] : 0;
$lang['lang_downloads'] = "Download von Bildern des Users:";
$lang['lang_downloads_1'] = "gesamt";
if ($sum_downloads == 1) {
$lang['lang_downloads_2'] = "Download von";
} else {
$lang['lang_downloads_2'] = "Downloads von";
}
if ($count_downloads == 1) {
$lang['lang_downloads_3'] = "Bild";
} else {
$lang['lang_downloads_3'] = "Bildern";
}
$site_template->register_vars(array(
"lang_downloads" => $lang['lang_downloads'],
"sum_downloads" => $lang['lang_downloads_1']." ".$sum_downloads." ".$lang['lang_downloads_2']." ".$count_downloads." ".$lang['lang_downloads_3'],
));
//--- Download von Bildern des Users im Profil , von mawenzi , 10.07.2008 -----------------
//--- Ab hier zusätzliche Infos im Benutzerprofil -----------------------------------------
//--- Download von Bildern des Users im Profil , von mawenzi , 10.07.2008 -----------------
$sql = "SELECT SUM(image_downloads) AS sum_downloads
FROM ".IMAGES_TABLE."
WHERE ".get_user_table_field("", "user_id")." = ".$user_id."";
$row = $site_db->query_firstrow($sql);
$sum_downloads = (isset($row['sum_downloads'])) ? $row['sum_downloads'] : 0;
$sql = "SELECT COUNT(*) AS count_downloads
FROM ".IMAGES_TABLE."
WHERE ".get_user_table_field("", "user_id")." = ".$user_id."
AND image_downloads > 0";
$row = $site_db->query_firstrow($sql);
$count_downloads = (isset($row['count_downloads'])) ? $row['count_downloads'] : 0;
$lang['lang_downloads'] = "Download von Bildern des Users:";
$lang['lang_downloads_1'] = "gesamt";
if ($sum_downloads == 1) {
$lang['lang_downloads_2'] = "Download von";
} else {
$lang['lang_downloads_2'] = "Downloads von";
}
if ($count_downloads == 1) {
$lang['lang_downloads_3'] = "Bild";
} else {
$lang['lang_downloads_3'] = "Bildern";
}
$site_template->register_vars(array(
"lang_downloads" => $lang['lang_downloads'],
"sum_downloads" => $lang['lang_downloads_1']." ".$sum_downloads." ".$lang['lang_downloads_2']." ".$count_downloads." ".$lang['lang_downloads_3'],
));
//--- Download von Bildern des Users im Profil , von mawenzi , 10.07.2008 -----------------