4images Forum & Community
4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: IcEcReaM on March 09, 2006, 10:13:39 PM
-
[ Introduction ]
With this mod you have an extra site where some useful informations are provided in statistic form.
[ Features ]
Fully configurable
Depending on which mods you have installed several display options can be turned on/off
[ Changed Files ]
lang/<your language>/main.php
(for some additional infos you have to modify more files)
[ New Files ]
templates/statistics.html
templates/statistics_memberbox.html
templates/statistics_monthbox.html
statistics.php
[ Installation ]
Download the rar archive.
unpack the files.
follow the installation note.
Configuration (important!)
Open the statistics.php and edit/modify in the head of the file your settings,
depending on your installed mods.
If you get sql error messages then you have not configured the settings part probably.
A Demo can be seen here: Demo Link (http://icecreamtest.ic.funpic.de/gallery/statistics.php)
Download here (http://icecreamtest.ic.funpic.de/gallery/categories.php?cat_id=21)
You can register your own account (no email verification is needed)
or login in with 4images/4images.
Have Phun.
Update Version 1.01
Added the mode parameter,
cause for some users the displayed site is too large,
so you can split up the statistics php.
Only the for the needed infos the querys will be executed to save some ressources.
changed files:
statistics.php
statistics.html
From installation note:
you can call the statistics.php with 3 different mode parameters.
e.g. statistics.php?mode=xxx
for xxx there are 3 modes available:
all: show all options
topusers: shows only the topuser statistics
stats: shows only the main statistics
P.S.: Thanks to my Betatesters (JensF,trez,ivan,Vincent,Loda) who provided me some errors which has been fixed now.
14.03.2006 Updated the Archive: dutch language file added (thx to wallpapers)
15.03.2006 Updated statistics.php v1.01 // added mode parameter
16.03.2006 Updated statistics.php v1.01 // added config option: show admin values in top users statistics on/off
-
Thx for the MOD IcEcReaM, its a good to use and easy to install MOD
Just two questions that might be important:
- is there any difference between the latest beta and this release?
- is "useronlinetime" includet in this final version?
good work,
treZ
-
Just two questions that might be important:
- is there any difference between the latest beta and this release?
Just changed some little fixes, and make the templates xhtml conform.
- is "useronlinetime" includet in this final version?
useronlinetime isn't part of this mod,
and have not been released yet.
-
wooow looks really nice!! thanks for this =)
-
Danke IcEcReaM für diesen großartigen MOD und die Arbeit die du damit hattest ... :D
mawenzi
-
Oke i have installed the mod (and many others FOR this mod)
But finily he is online ..... i'm busy with the translation to dutch :lol:
It's a great mod i'm very happy with it thanks :D
The link if you are intrested: http://wallpapers.sexy-picz.com/statistics.php (there can be a sql error i'm busy with some small thinks. :roll:
-
if you want then you can post your durch translations here,
could be interesting for other dutch users.
-
Here is the dutch translation.
If you see a (stupit) fould please replay me ...... my englisch is not so best :roll: sorry for that. :lol:
//-----------------------------------------------------
//--- Statistics Mod-----------------------------------
//-----------------------------------------------------
// altered User Fields
$lang['image_downloads'] = "Afbeelding download teller:"; //Image Download Counter:
$lang['usersendpostcards'] = "Poskaarten verzonden:"; //Postcards Send
$lang['langstats_overview'] = "Website statestieken"; //Board Statistics
$lang['lang_langstats_userstats'] = "Gebruikers statestieken"; //User Statistics
$lang['lang_langstats_votestats'] = "Waardering Statestieken"; //Vote Stats
$lang['lang_langstats_commentstats'] = "Commentaar statestieken"; //Comment Stats
$lang['lang_langstats_imagestats'] = "Afbeelding statestieken"; //Image Stats
$lang['langstats_images'] = "Afbeeldingen"; //Images
$lang['langstats_not_activated_images'] = "Niet geactiveerd"; //not active
$lang['langstats_total_categories'] = "Catagorieen"; //Categories
$lang['langstats_total_images_4u'] = "Zichtbaar voor jou"; //visible for you
$lang['langstats_total_image_hits'] = "Afbeelding Hits"; //Image Hits
$lang['langstats_total_image_votes'] = "Afbeelding waarderingen"; //Image Ratings
$lang['langstats_total_category_hits'] = "Catagorieen Hits"; //Categories Hits
$lang['langstats_total_members'] = "Geregistreerde leden"; //Registered Members
$lang['langstats_total_not_activated_members'] = "Niet geactiveerd"; //not active
$lang['langstats_total_downloads'] = "Afbeelding downloads"; //Image Downloads
$lang['langstats_total_comments'] = "Afbeelding comentaar"; //Image Comments
$lang['langstats_total_images_dirsize'] = "Media dir. groote"; //Media Dir Size
$lang['langstats_total_thumbs_dirsize'] = "Thumbnail dir. groote"; //Thumbnail Dir Size
$lang['langstats_total_db_size'] = "Database groote"; //Database Size
$lang['langstats_total_avg_rating'] = "Gemiddelde afbeelding waardering"; //Average Image Rating
$lang['langstats_total_guestbook_entries'] = "Gastenboek berichten"; //Guestbookentries
$lang['langstats_total_shoutbox_entries'] = "Shoutbox berichten"; //Shoutbox Entries
$lang['langstats_total_postcars'] = "Postkaarten aktief"; //Postcards active
$lang['langstats_total_postcars_send'] = "Gemiddeld postkaarten verzonden"; //Overall Postcards sended
$lang['langstats_userstats_registration'] = "Registraties"; //Registrations
$lang['langstats_userstats_today'] = "Vandaag"; //Today
$lang['langstats_userstats_yesterday'] = "Gisteren"; //Yesterday
$lang['langstats_userstats_this_week'] = "Laatste 7 dagen"; //Last 7 Days
$lang['langstats_userstats_last_week'] = "Laatste 14 dagen"; //Last 14 Days
$lang['langstats_userstats_this_month'] = "Deze Maand"; //This Month
$lang['langstats_userstats_last_month'] = "Vorige Maand"; //Last Month
$lang['langstats_userstats_this_year'] = "Dit Jaar"; //This Year
$lang['langstats_userstats_last_year'] = "Vorig Jaar"; //Last Year
$lang['langstats_userstats_total'] = "Gemiddeld"; //Overall
$lang['langstats_month_overview'] = "Maandelijks overzicht"; //Monthly Overview
$lang['langstats_months'] = array(
"1" => "Januari",
"2" => "Februari",
"3" => "Maart",
"4" => "April",
"5" => "Mei",
"6" => "Juni",
"7" => "Juli",
"8" => "Augustus",
"9" => "September",
"10" => "October",
"11" => "November",
"12" => "December",
);
$lang['lang_langstats_topuploaders'] = "Top Uploaders"; //Top Uploaders
$lang['lang_langstats_topdownloaders'] = "Top Downloaders"; //Top Downloaders
$lang['lang_langstats_topcommenter'] = "Top Commentaar"; //Top Commenter
$lang['lang_langstats_topagegroups'] = "Top leeftijd groepen"; //Top Agegroups
$lang['stats_topagegroups_group'] = "Jaar oud"; //years old
$lang['lang_langstats_topcommented'] = "Top afbeeldinghouders bij commentaren"; //Top Imageowner by commented Images
$lang['lang_langstats_topimageratingsfromuser'] = "Top afbeeldinghouders bij gemiddelde waarderingen"; //Top Imageowner by AVG Image Ratings
$lang['lang_langstats_toppostcardssenduser'] = "Top leden van verzenden van postkaarten"; //Top Users by Sending Postcards
$lang['lang_langstats_toppostcardsfromuser'] = "Top afbeeldinghouder van verzonden postkaarten"; //Top Imageowner by Sended Postcards
$lang['lang_langstats_topimagehitsfromuser'] = "Top afbeeldinghouder van afbeelding waarderingen"; //Top Imageowner by Image Hits
$lang['lang_langstats_topimagevoter'] = "Top waardeer(der)(ster)"; //Top Voter
$lang['lang_langstats_topimagevotedfromuser'] = "Top afbeeldinghouder van afbeelding waarderingen"; //Top Imageowner by Image Votes
$lang['lang_langstats_topusersshouted'] = "Top gebruiker van shoutbox berichten"; //Top Users by Shoutbox Entrys
$lang['lang_langstats_topusersprofilehits'] = "Top gebruiker van profiel hits"; //Top Users by Profile Hits
$lang['lang_langstats_topuserslastaction'] = "Laatste actieve gebruikers"; //Last active Users
$lang['lang_langstats_topusersnewusers'] = "Nieuwe geregistreerde gebruikers"; //New registered Users
$lang['lang_langstats_topusersonlinetime'] = "Top gebruikers van onlinetijd"; //Top Users by Onlinetime
You can call the file: lang_nederlands.txt and you can putt them in the .zip file from IcEcReaM.
You .zip file is complete then. :D
-
thanks, i've updated the archive
-
Links dont work, please, reup.
Many thanks.
-
links should work, but somestimes the server is too busy.
-
Updated the statistcs.php
Just a little modification.
Changes:
if you want to uprade manually from 1.0 to 1.01
search for:
$starttime_statistic = explode(" ", $starttime_statistic);and insert below
$stats_version = "v1.01";
search for:
//-----------------------------------------------------
//--- Stats Start -------------------------------------
//-----------------------------------------------------and insert below:
// Modfication seperated view
if (!$mode) $mode = "all"; // modes available: topusers // all // stats
if ($mode == "stats" || $mode == "all") {
search for:
//-----------------------------------------------------
//--- TOP Uploaders -----------------------------------
//-----------------------------------------------------
and insert above
} // end mode stats
if ($mode == "topusers" || $mode == "all") {
search for:
//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator']."Statistics</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"msg" => $msg,
"clickstream" => $clickstreamand replace with
} // end topusers
//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator']."Statistics</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"stats_version" => $stats_version,
"msg" => $msg,
"clickstream" => $clickstream
and just replace your old statistics.html with the new one.
more informations can be found in the first post.
-
so... if I understand correctly I must install
[MOD] eCard Counter / Postkartenzähler
Save Votes in DB type A
Birthday Mod v1.0
Shoutbox Mod
Profile Hits Mod
Guestbook Mod
[MOD] Member personal photo v1.1.1 by V@no
for this to work ? what happens if I don't install any of these ?
-
you don't need to install any other mods,
you can turn off different statistics options in the config part of the statistics.php.
Just set the value from 1 to 0, if you didn't installed the necessary mod.
-
This is a fantastic mod, thank you very very much :D
Is it possible to get statistics on the top images by hits ?
-
how do you mean that?
There is already an option to show the top images by hits.
or do you mean a monthly stats?
then it is not possible without more modifications,
cause the hits doesn't get count by month.
-
I installed the statistics mod and modified the template. I put everything in two columns everything above each other. Now when I see the statistics.php there is a big space in the right column and I really don't know why. Perhaps you could take a look and help me :-)
The page: http://www.konradin.net/galerie/statistics.php
The template Code:
{header}
<h2>Kategorien</h2>
{categories_list}
</div><!-- divID left -->
<div id="content">
<h2>{site_name}</h2>
<br />
<div class="kasten">
<div>
{if stats_overview}
<h3>{lang_langstats_overview}</h3>
<table width="100%" border="0" cellspacing="3" cellpadding="3" class="row2">
{stats_overview}
</table>
<br />
{endif stats_overview}
<table width="100%">
<tr>
<td width="50%">
{if stats_user_stats}
{lang_langstats_userstats}
{stats_user_stats}
{endif stats_user_stats}
{if stats_commentstats}
{stats_commentstats}
{endif stats_commentstats}
{if stats_topuploaders}
{stats_topuploaders}
{endif stats_topuploaders}
{if stats_topusersnewusers}
{stats_topusersnewusers}
{endif stats_topusersnewusers}
{if stats_toppostcardssenduser}
{stats_toppostcardssenduser}
{endif stats_toppostcardssenduser}
{if stats_topimagehitsfromuser}
{stats_topimagehitsfromuser}
{endif stats_topimagehitsfromuser}
{if stats_topimagevoter}
{stats_topimagevoter}
{endif stats_topimagevoter}
{if stats_topusersshouted}
{stats_topusersshouted}
{endif stats_topusersshouted}
{if stats_topuserslastaction}
{stats_topuserslastaction}
{endif stats_topuserslastaction}
<br />
<br />
</td>
<td width="50%">
{if stats_votestats}
{stats_votestats}
{endif stats_votestats}
{if stats_topagegroups}
{lang_langstats_topagegroups}
{stats_topagegroups}
{endif stats_topagegroups}
{if stats_imagestats}
{stats_imagestats}
{endif stats_imagestats}
{if stats_topdownloaders}
{stats_topdownloaders}
{endif stats_topdownloaders}
{if stats_topcommenter}
{stats_topcommenter}
{endif stats_topcommenter}
{if stats_toppostcardsfromuser}
{stats_toppostcardsfromuser}
{endif stats_toppostcardsfromuser}
{if stats_topimageratingsfromuser}
{stats_topimageratingsfromuser}
{endif stats_topimageratingsfromuser}
{if stats_topimagevotedfromuser}
{stats_topimagevotedfromuser}
{endif stats_topimagevotedfromuser}
{if stats_topusersprofilehits}
{stats_topusersprofilehits}
{endif stats_topusersprofilehits}
{if stats_topcommented}
{stats_topcommented}
{endif stats_topcommented}
</td>
</tr>
</table>
<br />
<br />
<div align="center">Statistics {stats_version} by IcEcReaM</div>
<!-- Please don't remove the copyright -->
<!-- Statistics v1.0 (c)2006 by IcEcReaM -->
</div>
</div>
{copyright}
<br />
</div> <!-- DivID content -->
<div id="right">
{footer}
Bye, thank you very much
-
How can I I show useravatars instead of userimages? Guess most users will use avatars to identify themself on a site instead of using a custom userpic.....
Maybe like.... If no userpic then show useravatar... and if no userpic and no useravatar show nopic
And how can I disable specific users from being counted or shown in the stats?
Would be great if somwone could figure out how to do it...
-
hallo,
wann wird es den mod für die online zeit geben?
mfg timerex
-
Hi
Greate mod
can you tel me how to add in statistics funcion "Display all images added by... " (from member profil) neer user nick?
thx for replay
-
hello,
I've copied all files into the several dictionaries. But when I want to open the statistics.php file, the page makes only a refresh and I can't see the statistics. What could be the problem?
Thanks and Greetz
Chull
-
I installed the mod and it works great but time is not displaying right!
Time is late for 6 hours!
Is there somethnig to modify like time offset or something? :D
Thanks
-
[ Introduction ]
With this mod you have an extra site where some useful informations are provided in statistic form.
[ Features ]
Fully configurable
Depending on which mods you have installed several display options can be turned on/off
[ Changed Files ]
lang/<your language>/main.php
(for some additional infos you have to modify more files)
[ New Files ]
templates/statistics.html
templates/statistics_memberbox.html
templates/statistics_monthbox.html
statistics.php
[ Installation ]
Download the rar archive.
unpack the files.
follow the installation note.
Configuration (important!)
Open the statistics.php and edit/modify in the head of the file your settings,
depending on your installed mods.
If you get sql error messages then you have not configured the settings part probably.
A Demo can be seen here: Demo Link (http://icecreamtest.ic.funpic.de/gallery/statistics.php)
Download here (http://icecreamtest.ic.funpic.de/gallery/categories.php?cat_id=21)
You can register your own account (no email verification is needed)
or login in with 4images/4images.
Have Phun.
Update Version 1.01
Added the mode parameter,
cause for some users the displayed site is too large,
so you can split up the statistics php.
Only the for the needed infos the querys will be executed to save some ressources.
changed files:
statistics.php
statistics.html
From installation note:
you can call the statistics.php with 3 different mode parameters.
e.g. statistics.php?mode=xxx
for xxx there are 3 modes available:
all: show all options
topusers: shows only the topuser statistics
stats: shows only the main statistics
P.S.: Thanks to my Betatesters (JensF,trez,ivan,Vincent,Loda) who provided me some errors which has been fixed now.
14.03.2006 Updated the Archive: dutch language file added (thx to wallpapers)
15.03.2006 Updated statistics.php v1.01 // added mode parameter
16.03.2006 Updated statistics.php v1.01 // added config option: show admin values in top users statistics on/off
Hallo,
kann mir jemand die unktionierende zip Datei senden ?
Die auf der Seite ist kaputt bzw. Fehler beim entpacken.
Danke und Grüße Darkness
-
I installed the mod and it works great but time is not displaying right!
Time is late for 6 hours!
Is there somethnig to modify like time offset or something? :D
Can someone help me? Please? Anyone?!? :cry:
-
It's a great mod i'm very happy with it. I use part of it as a "top users"
It is possible to add top users by average comments/images and top users by average views/images
Im not a PHP coder... I think this features can show well who are the best photographers uploading picture to my site.
thanks!
Sorry by my english...
-
very nice MOD! Thank you!!!! ;-)
-
@ IcEcReaM
erst einmal danke und ein großes Kompliment auch für diesen (Statistic Mod v1.01) tollen MOD von dir !
Meine Frage:
wo bekomme ich den MOD Onlinetime
( define('STATS_SHOW_TOPUSERS_ONLINETIME',0); // displys Top User by Onlinetime spent in Gallery )
dazu her?
Kannst du mir den MOD bitte mit Anleitung posten!
Das wäre sehr nett :-)
Schon mal vorab besten Dank und
Gute Grüße
Jasi
-
@ ivan,
Hallo ivan,
danke dir für die Info, ich hatte leider nicht nachgesehen wann IcEDreaM zuletzt online war!
Vielleicht findet sich ja jemand der den Onlinetime-MOD hat?
THX Jasi
-
hab das jetzt eingebaut und bekomme diese meldung:
DB Error: Bad SQL Query: SELECT COUNT(*) AS count_guestbook_entries FROM GUESTBOOK_TABLE
Table 'wef07.GUESTBOOK_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT COUNT(*) AS count_shoutbox_entries FROM SHOUTBOX_TABLE
Table 'wef07.SHOUTBOX_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT SUM(image_postcards) AS sum FROM 4images_images
Unknown column 'image_postcards' in 'field list'
DB Error: Bad SQL Query: SELECT vote_time FROM VOTED_TABLE WHERE vote_time > 1167606000
Table 'wef07.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT (YEAR(CURRENT_DATE ) - YEAR( birthday)) - ( RIGHT( CURRENT_DATE, 5 ) < RIGHT( birthday, 5 ) ) AS age, COUNT( * ) AS age_hits FROM 4images_users WHERE birthday != '0000-00-00' AND user_id <> -1 GROUP BY age ORDER BY age ASC LIMIT 40
Unknown column 'birthday' in 'field list'
DB Error: Bad SQL Query: SELECT COUNT(i.image_id) AS user_topuploaders, u.user_name, u.user_id ,u.userpic FROM 4images_users u LEFT JOIN 4images_images i ON (i.user_id = u.user_id) WHERE u.user_level > -1 GROUP BY u.user_id ORDER BY user_topuploaders DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'
DB Error: Bad SQL Query: SELECT user_id,user_name,image_downloads ,userpic FROM 4images_users WHERE user_id <> -1 ORDER BY image_downloads DESC, user_id ASC LIMIT 5
Unknown column 'image_downloads' in 'field list'
DB Error: Bad SQL Query: SELECT user_id,user_name,user_comments ,userpic FROM 4images_users WHERE user_id <> -1 ORDER BY user_comments DESC, user_id ASC LIMIT 5
Unknown column 'userpic' in 'field list'
DB Error: Bad SQL Query: SELECT COUNT(c.comment_id) as user_comments,u.user_id,u.user_name ,userpic FROM 4images_comments c LEFT JOIN 4images_images i ON (i.image_id = c.image_id) LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND u.user_level > '-1' GROUP BY u.user_id ORDER BY user_comments DESC LIMIT 5
Unknown column 'userpic' in 'field list'
DB Error: Bad SQL Query: SELECT user_id,user_name,send_postcards ,userpic FROM 4images_users WHERE user_id <> -1 ORDER BY send_postcards DESC, user_id ASC LIMIT 5
Unknown column 'send_postcards' in 'field list'
DB Error: Bad SQL Query: SELECT SUM(i.image_postcards) AS top_postcards, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE i.image_active = 1 AND u.user_level > -1 GROUP BY u.user_id ORDER BY top_postcards DESC, u.user_id ASC LIMIT 5
Unknown column 'i.image_postcards' in 'field list'
DB Error: Bad SQL Query: SELECT SUM(i.image_hits) AS image_hits, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE i.image_active = 1 AND u.user_level > -1 GROUP BY u.user_id ORDER BY image_hits DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'
DB Error: Bad SQL Query: SELECT ROUND(AVG(i.image_rating),2) as avg_rating, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE i.image_rating != 0 AND u.user_level > -1 GROUP BY u.user_id ORDER BY avg_rating DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'
DB Error: Bad SQL Query: SELECT COUNT(v.image_id) AS vote_count, u.user_name, u.user_id ,u.userpic FROM VOTED_TABLE v LEFT JOIN 4images_users u ON (v.user_id = u.user_id) WHERE u.user_level > -1 GROUP BY u.user_id ORDER BY vote_count DESC, u.user_id ASC LIMIT 5
Table 'wef07.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT SUM(i.image_votes) AS vote_sum, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE u.user_level > -1 GROUP BY u.user_id ORDER BY vote_sum DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'
DB Error: Bad SQL Query: SELECT COUNT(s.id) AS shout_count, u.user_name, u.user_id ,u.userpic FROM SHOUTBOX_TABLE s LEFT JOIN 4images_users u ON (s.usrid = u.user_id) WHERE u.user_id > -1 AND s.usrid != 0 GROUP BY u.user_id ORDER BY shout_count DESC, u.user_id ASC LIMIT 5
Table 'wef07.SHOUTBOX_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT SUM(profile_hits) AS profilehits_count, user_name, user_id ,userpic FROM 4images_users WHERE user_id > -1 GROUP BY user_id ORDER BY profilehits_count DESC, user_id ASC LIMIT 5
Unknown column 'profile_hits' in 'field list'
DB Error: Bad SQL Query: SELECT u.user_id, u.user_name, u.user_lastaction ,u.userpic FROM 4images_users u WHERE u.user_id > -1 ORDER BY u.user_lastaction DESC LIMIT 5
Unknown column 'u.userpic' in 'field list'
DB Error: Bad SQL Query: SELECT u.user_id, u.user_name, u.user_joindate ,u.userpic FROM 4images_users u WHERE u.user_id > -1 ORDER BY u.user_joindate DESC LIMIT 5
Unknown column 'u.userpic' in 'field list'
-
Hallo,
ich habe den Mod eingebaut. Funktioniert alles gut... aber nur beim Download von ZIP Dateien zählt der Counter (im folder: Note 2 - User Download Counter Mod) alle Bilder des ZIP doppelt.
Hat jemand eine Idee?
Gruß paule
-
I'd installed this mod, works great, but I've a concern regarding top avg ratings of uploader, right now it is giving top ten of avg ratings of users which is correct but, I want to consider avg ratings only when if users number of votings recved is greater than 100, this way I can present much better uploaders
lets say I've users who got rating like this (x/y, x:avg rating, y:number of ratings), 4/100, 5/1, 5/3, 4.99/200, 3.97/300;
right now this mod sorts this like this 5/3, 5/1, 4.99/200, 4/100, 3.97/300, but this is unfair as users who got toplisted are not really worth
Could somebody please refine the below query to consider avg ratings if number_ratings recved is greater than 100..
if (defined("STATS_SHOW_TOPIMAGE_RATINGS_FROM_USER") && STATS_SHOW_TOPIMAGE_RATINGS_FROM_USER == 1) {
$sql = "SELECT ROUND(AVG(i.image_rating),2) as avg_rating, ".get_user_table_field("u.",user_name).", ".get_user_table_field("u.",user_id).$additional_sql_uuserpic."
FROM ".IMAGES_TABLE." i
LEFT JOIN ".USERS_TABLE." u ON (i.user_id = ".get_user_table_field("u.",user_id).")
WHERE $sql_adminu i.image_rating != 0 AND ".get_user_table_field("u.",user_level)." > ".GUEST."
GROUP BY ".get_user_table_field("u.",user_id)."
ORDER BY avg_rating DESC, ".get_user_table_field("u.",user_id)." ASC
LIMIT ".STATS_TOP_MEMBERS_LIMIT;;
show_topmembers($sql,"topimageratingsfromuser","avg_rating");
}
Thanks.
-
Is it possible to exclude the admin (user id 1) from the stats?
-
Hallo,
@ Paule ich suche diesen Mod ( User Download Counter Mod ) hab es hier irgendwie nicht gefunden. Hast Du ihn noch und kannst ihm senden, oder sagen wo ich ihn find ?
Gruß
Tom
-
Hallo allerseits,
besten Dank für dieses Statistiktool. :thumbup:
@tom69
den "User Download Counter Mod" findest du im Archiv, welches du heruntergeladen hast. Dort findest du die Datei "Note 2 - User Download Counter Mod .txt". ;)
...Vielleicht findet sich ja jemand der den Onlinetime-MOD hat?...
Genau diese MOD suche ich auch. Gibt es denn wirklich niemand hier von den Benutzern dieser Statistik-MOD, der bitte diese Onlinetime-MOD zur Verfügung stellen kann?
Nachtrag:
Eine Frage wäre da noch - was muss in der statistics.php geändert werden, damit die Monate absteigend angezeigt werden? Also Februar 2010, Januar 2010, Dezember 2009 usw.
OK... Dumme Fragen gibt es nie. ;)
ORDER by "Spalte" ASC oder DESC
Freundliche Grüße, Bommel
-
hello, please help me
When I add line in database
ALTER TABLE `4images_voted` ADD `vote_time` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL ;Have problem:
Error
SQL query:
ALTER TABLE `4images_voted` ADD `vote_time` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL
MySQL said: Documentation
#1146 - Table '11.4images_voted' doesn't exist
In my database hadn't table 4images_voted
-
Mod nicht mehr downloadbar!
Wie bekomme ich nur die Zahl ausgegeben wieviele User registriert sind?
-
Download link is not work! Is it possible to find this MOD now?
Thanks!
-
Hat jemand die Downloaddateien? Funktioniert das MOD mit 1.7.9 ?
Freu mich, wenn dieser nette Mod hier einfügt wird!
-
I can't find file. Reupload please.
-
Moving out mods section until someone provides complete package.
-
How download mods Statistics v1.01 by IcEcReaM