OXPUS.de

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)';