Highscore im Portal

Öffene Portal.php
Finde:

// LAST TOPICS END

Füge Darunter ein:

// Tippspiel Begin
$sql = "SELECT config_value from phpbb_config where config_name = 'tippspiel_meldung'";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))
{

$meldung[] = $row['config_value'];

}


$sql = "SELECT user_id, username, tipp_punkte, tipp_treffer, tipp_getippt, tipp_lastpos, tipp_meister, user_avatar, user_avatar_type, user_allowavatar FROM ". USERS_TABLE ." WHERE tipp_spieltagtipps = 1 ORDER BY tipp_punkte DESC, tipp_treffer DESC";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))
{
$pos_counter++;



if (($u_punktecheck == $row['tipp_punkte']) && ($u_treffercheck == $row['tipp_treffer']))
{$poscheck++; $pos_count = $pos_counter - $poscheck;}
else{$pos_count = $pos_counter;$poscheck = 0;}

$posbefore[] = $row['tipp_lastpos'];
$userid[] = $row['user_id'];
$username[] = $row['username'];
$gesamtpunkte[] = $row['tipp_punkte'];
$gesamttipps[] = $row['tipp_getippt'];
$treffer[]= $row['tipp_treffer'];
$userpos[] = $pos_count;
$meisterid[] = $row['tipp_meister'];
$first[] = $row['username'];
$username2[] = $row['username'];
$Avatar[] = $row['user_avatar'];
$Avatartyp[] = $row['user_avatar_type'];
$Avatarallow[] = $row['user_allowavatar'];

$u_punktecheck = $row['tipp_punkte'];
$u_treffercheck = $row['tipp_treffer'];
}

$actDate = time();
$nextdate = time();
$heim = 'n.a.';
$auswarts = 'n.a.';
$sql = "select min(datumzeit) as datumzeit,heim,auswarts from tippspiel_spieltage where datumzeit > $actDate group by heim,auswarts order by datumzeit asc limit 0,1";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))
{
$nextdate = $row['datumzeit'];
$heim = $row['heim'];
$auswarts = $row['auswarts'];
}
//$format = ("Y,n,d,G,i,s");
//$nextdate = create_date($format, $tippzeitraw[$i], $board_config['board_timezone']);
$mydate = explode(",",$nextdate);
$Jahr="$mydate[0].";
$Monat="$mydate[1].";
$Tag="$mydate[2].";
$Stunde="$mydate[3].";
$Minute="$mydate[4].";
$Sekunde="$mydate[5].";




$newDate = $nextdate;
$actDate = time();
$diffDate = ($newDate-$actDate);
$days = floor($diffDate / 24 / 60 / 60 );
$diffDate = $diffDate - ($days*24*60*60);
$hours = floor($diffDate / 60 / 60);
$diffDate = ($diffDate - ($hours*60*60));
$minutes = floor($diffDate/60);
$diffDate = $diffDate - ($minutes*60);
$seconds = floor($diffDate);
if ($days == "1")($Tag = "Tag"); else ($Tag = "Tagen");
if ($minutes == "1")($Minute = "Minute"); else ($Minute = "Minuten");
if ($hours == "1")($Stunde = "Stunde"); else ($Stunde = "Stunden");


$actDate = time();
$extranextdate = time();
$extraheim = 'n.a.';
$extraauswarts = 'n.a.';
$sql = "select min(zeit) as datumzeit, heim, auswarts from tippspiel_extraspiele where zeit > $actDate group by heim, auswarts order by zeit asc limit 0,1";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))
{
$extranextdate = $row['datumzeit'];
$extraheim = $row['heim'];
$extraauswarts = $row['auswarts'];

}
$extranewDate = $extranextdate;
$actDate = time();
$extradiffDate = ($extranewDate-$actDate);
$extradays = floor($extradiffDate / 24 / 60 / 60 );
$extradiffDate = $extradiffDate - ($extradays*24*60*60);
$extrahours = floor($extradiffDate / 60 / 60);
$extradiffDate = ($extradiffDate - ($extrahours*60*60));
$extraminutes = floor($extradiffDate/60);
$extradiffDate = $extradiffDate - ($extraminutes*60);
$extraseconds = floor($extradiffDate);
if ($extradays == "1")($extraTag = "Tag"); else ($extraTag = "Tagen");
if ($extraminutes == "1")($extraMinute = "Minute"); else ($extraMinute = "Minuten");
if ($extrahours == "1")($extraStunde = "Stunde"); else ($extraStunde = "Stunden");



$sql = "SELECT user_id, username,((case when b.punkte is Null then 0 else b.punkte end)+(case when extrapunkte is Null then 0 else extrapunkte end)) as tipp_punkte, "
. " ((case when b.treffer is Null then 0 else b.treffer end)+(case when e.treffer is Null then 0 else e.treffer end)) as tipp_treffer, "
. " ((case when e.spiele is Null then 0 else e.spiele end)+(case when b.spiele is Null then 0 else b.spiele end)) as tipp_getippt, "
. " tipp_lastpos, tipp_meister, user_avatar, user_avatar_type, user_allowavatar, (case when tagessiege is Null then 0 else tagessiege end) as tagessiege, "
. " (case when extrapunkte is Null then 0 else extrapunkte end) as extrapunkte FROM phpbb_users "
. " left join (select userid, sum(bewertet) as punkte, count(bewertet) as spiele, sum((case when bewertet = 3 then 1 else 0 end)) as Treffer from tippspiel_usertips where tabelle = 1 and spieltag > 17 group by userid) b on b.userid = user_id "
. " left join (select userid, sum(bewertet) as extrapunkte, count(bewertet) as spiele, sum((case when bewertet = 3 then 1 else 0 end)) as Treffer from tippspiel_extraspieleusertips where tabelle = 1 and tippzeit > (select min(datumzeit) from tippspiel_spieltage where spieltag = 18 limit 0,1) group by userid) e on e.userid = user_id "
. " left join (SELECT userid, sum(tagessieg) as tagessiege FROM tippspiel_user_spieltage WHERE spieltag > 17 group by userid) s on s.userid = user_id "
. " WHERE tipp_spieltagtipps = 1 ORDER BY tipp_punkte DESC, tipp_treffer DESC";
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['tipp_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))
{
$pos_counter++;


if (($u_punktecheck == $row['tipp_punkte']) && ($u_treffercheck == $row['tipp_treffer']))
{$poscheck++; $pos_count = $pos_counter - $poscheck;}
else{$pos_count = $pos_counter;$poscheck = 0;}

$rposbefore[] = $row['tipp_lastpos'];
$ruserid[] = $row['user_id'];
$rusername[] = $row['username'];
$rgesamtpunkte[] = $row['tipp_punkte'];
$rgesamttipps[] = $row['tipp_getippt'];
$rtreffer[]= $row['tipp_treffer'];
$ruserpos[] = $pos_count;
$rmeisterid[] = $row['tipp_meister'];
$rusername2[] = $row['username'];
$rfirst[] = $row['username'];
$rAvatar[] = $row['user_avatar'];
$rAvatartyp[] = $row['user_avatar_type'];
$rAvatarallow[] = $row['user_allowavatar'];
$rextrapointssum2[] = $row['extrapunkte'];
$rtagessiege[] = $row['tagessiege'];


$u_punktecheck = $row['tipp_punkte'];
$u_treffercheck = $row['tipp_treffer'];
}





for ($i = 0; $i <>
$Avatar2 = '';
if ( $Avatartyp[$i] && $Avatarallow[$i] )
{
switch( $Avatartyp[$i] )
{
case USER_AVATAR_UPLOAD:
$Avatar2 = ( $board_config['allow_avatar_upload'] ) ? '' : '';
break;
case USER_AVATAR_REMOTE:
$Avatar2 = ( $board_config['allow_avatar_remote'] ) ? '' : '';
break;
case USER_AVATAR_GALLERY:
$Avatar2 = ( $board_config['allow_avatar_local'] ) ? '' : '';
break;
}
}

$template->assign_block_vars('statistik_block_avatar', array(
"NAME" => ($userdata['username'] == $username2[$i]) ? ''.$username2[$i].'' : $username2[$i],
"AVATAR" => $Avatar2,
"GESPUNKTE" => ($userdata['username'] == $username2[$i]) ? ''.$gesamtpunkte[$i].'' : $gesamtpunkte[$i],
"RANG" => $i + 1 ,

"TREFFER" => ($userdata['username'] == $username2[$i]) ? ''.$treffer[$i].'' : $treffer[$i]
)
);

}

for ($i = 0; $i <>


$template->assign_block_vars('statistik_block_avatar2', array(
"RNAME" => ($userdata['username'] == $rusername2[$i]) ? ''.$rusername2[$i].'' : $rusername2[$i],
"RAVATAR" => $rAvatar2,
"RGESPUNKTE" => ($userdata['username'] == $rusername2[$i]) ? ''.$rgesamtpunkte[$i].'' : $rgesamtpunkte[$i] ,
"RRANG" => $i + 1,

"RTREFFER" => ($userdata['username'] == $rusername2[$i]) ? ''.$rtreffer[$i].'' : $rtreffer[$i]
)
);

}



$template->assign_block_vars('tippspielmeldung', array(
"NAME" => $username2[$i],
"MELDUNG" => $meldung[0],
"TAGE" => $days,
"STUNDEN" => $hours,
"MINUTENVAR" => $Minute,
"TAGEVAR" => $Tag,
"STUNDENVAR" => $Stunde,
"MINUTEN" => $minutes,
"HEIM" => $heim,
"AUSWARTS" => $auswarts,
"extraTAGE" => $extradays,
"extraSTUNDEN" => $extrahours,
"extraMINUTENVAR" => $extraMinute,
"extraTAGEVAR" => $extraTag,
"extraSTUNDENVAR" => $extraStunde,
"extraMINUTEN" => $extraminutes,
"extraHEIM" => $extraauswarts,
"extraAUSWARTS" => $extraheim
));


// Tippspiel END

Öffene die Portal_body.tpl
und führe die schritte der .txt aus