Code: Alles auswählen
`cont_first_rate` float unsigned default NULL,
`cont_second_rate` float unsigned default NULL,
`cont_third_rate` float unsigned default NULL,
Code: Alles auswählen
`cont_first_rate` float unsigned default NULL,
`cont_second_rate` float unsigned default NULL,
`cont_third_rate` float unsigned default NULL,
Code: Alles auswählen
CREATE TABLE `phpbb_album_contest_ratings` (
`cont_user_id` mediumint(5) unsigned NOT NULL default '0',
`cont_username` varchar(32) default NULL,
`cont_points` mediumint(4) unsigned NOT NULL default '0',
`cont_number_first` tinyint(3) unsigned default '0',
`cont_number_second` tinyint(3) unsigned default '0',
`cont_number_third` tinyint(3) unsigned default '0',
PRIMARY KEY (`cont_user_id`)
);
Code: Alles auswählen
$rpic = $rowl[$zcont]['pic_id'];
$sql = "SELECT rate_pic_id, rate_point, rate_user_id
FROM " . ALBUM_RATE_TABLE . "
WHERE rate_pic_id = $rpic
ORDER BY rate_pic_id DESC";
...
$count_cont = 0;
while ( $row = $db->sql_fetchrow($result) )
{
$con_rate[$zcont][0] = $row['rate_pic_id'];
$con_rate[$zcont][1] += $row['rate_point'];
$count_cont++;
}
Code: Alles auswählen
$con_rate[$zcont][1] = (empty ($count_cont) ? 0 : ($con_rate[$zcont][1] / $count_cont));
Code: Alles auswählen
for($zcont=0; $zcont < $cont_total_pics - 1; $zcont++)
{
for($jcont=0; $jcont < $cont_total_pics-$zcont-1; ++$jcont)
{
if($con_rate[$jcont][1] < $con_rate[$jcont+1][1])
{
$con_help[0] = $con_rate[$jcont][0];
$con_help[1] = $con_rate[$jcont][1];
$con_rate[$jcont][0] = $con_rate[$jcont+1][0];
$con_rate[$jcont][1] = $con_rate[$jcont+1][1];
$con_rate[$jcont+1][0] = $con_help[0];
$con_rate[$jcont+1][1] = $con_help[1];
}
}
}
Code: Alles auswählen
$lang['cont_rankings'] = 'Evaluation: <b>%d</b> Point(s)';
Code: Alles auswählen
$lang['cont_rankings'] = 'Evaluation: <b>%0.2f</b> Point(s)';
Nun müsste es gehen. Zum Ende des Monats weiß ich mehr. Dann ist die Auswertung...ein Mitglied hat geschrieben:Nochmal kurz nachgedacht ... und es macht nur so Sinn
SELECT rate_pic_id, AVG(rate_point) AS rating FROM phpbb_album_rate WHERE rate_pic_id = 2104 GROUP BY rate_pic_id
Bilde eine Liste aller Bildernummern mit dem Mittelwert über die Bewertungen, aber betrachte nur das Bild mit der Nummer...
:-)