phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Klar darfsteLechon hat geschrieben:Das icon nehme ich gerne, wenn ich darf.
Ah, okayLechon hat geschrieben:Auf der Hauptseite, werden nur 10 angezeigt, der Link Spieler Ranking, zeigt dann das gesamte Ranking und ein Ranking pro Spieltag.
Also das wäre klasse.Lechon hat geschrieben:Eine Ranking pro Zeitspanne wäre sicherlich als Addon möglich.
Genau!Noch etwas, den Kasten Tipp-Bewertung würde ich ganz rausnehmen, und als reinen Text unterhalb der BuLi Tabelle reinnehmen, aber das kann sich ja auch jeder User selber basteln.
Aber erstmal bin ich auch so schon mehr als sehr zufrieden.Code: Alles auswählen
<?php
/***************************************************************************
* admin_charts.php
* ------------------
*
* copyright : (C) 2003 dzidzius
* email : dzidzius@forumbest.now.pl <http://www.forumbest.now.pl>
*
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', 1);
if( !empty($setmodules) )
{
$file = basename(__FILE__);
$module['General']['Forum Charts'] = $file;
return;
}
//
// Load default header
//
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
//require($phpbb_root_path . 'common.'.$phpEx);
require('./pagestart.' . $phpEx);
include($phpbb_root_path.'language/lang_' . $board_config['default_lang'] . '/lang_charts.'.$phpEx);
if( isset($HTTP_GET_VARS['action']) || isset($HTTP_POST_VARS['action']) )
{
$mode = ($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : $HTTP_POST_VARS['action'];
}
else
{
if( isset($HTTP_POST_VARS['end_week']) )
{
$mode = "end_week";
}
else if( isset($HTTP_POST_VARS['save']) )
{
$mode = "save";
}
else if( isset($HTTP_POST_VARS['reset']) )
{
$mode = "reset";
}
else
{
$mode = "";
}
}
if( $mode != "" )
{
if( $mode == "edit" )
{
$chart_id = ( isset($HTTP_GET_VARS['id']) ) ? $HTTP_GET_VARS['id'] : 0;
$template->set_filenames(array(
"body" => "admin/charts_aedit_body.tpl")
);
$s_hidden_fields = '';
if( $mode == "edit" )
{
if( $chart_id )
{
$sql = "SELECT *
FROM ".CHARTS_TABLE."
WHERE chart_id = $chart_id";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$chart_info = $db->sql_fetchrow($result);
$s_hidden_fields .= '<input type="hidden" name="id" value="' . $chart_id . '" />';
}
else
{
message_die(GENERAL_MESSAGE, $lang['Chart_Choose_Err']);
}
}
$template->assign_vars(array(
"L_PAGE_DESC" => $lang['Chart_Page_Desc'],
"L_PAGE_TITLE" => $lang['Chart_Page_Title'],
"L_ADDING_TITLE" => $lang['Chart_Edit'],
"L_ARTIST" => $lang['Chart_Artist_Name'],
"L_SONG_NAME" => $lang['Chart_Song_Name'],
"L_ALBUM" => $lang['Chart_Album_Name'],
"SONG_NAME" => $chart_info['chart_song_name'],
"ALBUM_NAME" => $chart_info['chart_album'],
"ARTIST_NAME" => $chart_info['chart_artist'],
"L_SAVE" => "Save",
"S_CHARTS_ACTION" => append_sid("admin_charts.$phpEx"),
"S_HIDDEN_FIELDS" => $s_hidden_fields)
);
$template->pparse("body");
include('./page_footer_admin.'.$phpEx);
}
else if( $mode == "save" )
{
$chart_id = ( isset($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : 0;
$song_name = ( isset($HTTP_POST_VARS['song_name']) ) ? trim($HTTP_POST_VARS['song_name']) : "";
$artist_name = ( isset($HTTP_POST_VARS['artist_name']) ) ? trim($HTTP_POST_VARS['artist_name']) : "";
$album_name = ( isset($HTTP_POST_VARS['album_name']) ) ? trim($HTTP_POST_VARS['album_name']) : "";
if($song_name == "" || $artist_name == "" )
{
message_die(GENERAL_MESSAGE, $lang['Chart_Fields_Err']);
}
if( $chart_id )
{
$sql = "UPDATE ".CHARTS_TABLE."
SET chart_song_name = '" . str_replace("\'", "''", $song_name) . "', chart_artist = '" . str_replace("\'", "''", $artist_name) . "', chart_album = '" . str_replace("\'", "''", $album_name) . "'
WHERE chart_id = $chart_id";
$message = $lang['Chart_DBase_Ok'];
}
else
{
message_die(GENERAL_MESSAGE, $lang['Chart_Choose_Err']);
}
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Base_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$message .= "<br /><br />" . sprintf($lang['Chart_Click_Return'], "<a href=\"" . append_sid("admin_charts.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else if( $mode == "delete" )
{
if( isset($HTTP_POST_VARS['id']) || isset($HTTP_GET_VARS['id']) )
{
$chart_id = ( isset($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : $HTTP_GET_VARS['id'];
}
else
{
$chart_id = 0;
}
if( $chart_id )
{
$sql = "DELETE FROM ".CHARTS_VOTERS_TABLE."
WHERE vote_chart_id = $chart_id";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_SQL_Del'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM ".CHARTS_TABLE."
WHERE chart_id = $chart_id";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_SQL_Del'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$message = "Chart deleted" . "<br /><br />" . sprintf($lang['Chart_Click_Return'], "<a href=\"" . append_sid("admin_charts.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else
{
message_die(GENERAL_MESSAGE, $lang['Chart_Choose_Err']);
}
}
else if( $mode == "end_week" )
{
message_die(GENERAL_MESSAGE, '<form method="post" action="' . append_sid('admin_charts.' . $phpEx) . '">' . $lang['Chart_Ask_Week'] . '<br /><br /><input type="submit" name="reset" value="' . $lang['Yes'] . '" class="mainoption" /> <input type="submit" name="" value="' . $lang['No'] . '" class="mainoption" /></form>');
}
else if( $mode == "reset" )
{
$sql = 'SELECT * FROM '.CHARTS_TABLE.' ORDER BY (chart_hot-chart_not) DESC, chart_artist';
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Base_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$rowset = $db->sql_fetchrowset($result);
$db->sql_freeresult($result);
$chart_count = count($rowset);
for($i = 0; $i<$chart_count; $i++)
{
if($i+1 < $rowset[$i]['chart_best_pos'] || $rowset[$i]['chart_best_pos']==0)
$add = ', chart_best_pos = ' . ($i+1);
else
$add = '';
$sql = 'UPDATE '.CHARTS_TABLE.'
SET chart_last_pos = '. ($i+1) . $add . '
WHERE chart_id = ' . $rowset[$i]['chart_id'];
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Base_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
}
$sql = 'UPDATE '.CONFIG_TABLE.'
SET config_value = config_value+1
WHERE config_name = "charts_week_num"';
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR,$lang['Chart_Sql_Base_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$sql = 'DELETE FROM '.CHARTS_VOTERS_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Base_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$redirect_page = append_sid("admin_charts.$phpEx");
$message .= $lang['Chart_DBase_Ok']."<br><br>";
$message .= sprintf($lang['Chart_Click_Return'], '<a href="' . $redirect_page . '">', '</a>');
message_die(GENERAL_MESSAGE,$message);
}
}
else
{
$template->set_filenames(array(
"body" => "admin/charts_alist_body.tpl")
);
$sql = 'SELECT chart_id, chart_song_name, chart_artist, chart_album
FROM '.CHARTS_TABLE;
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$template->assign_vars(array(
"L_PAGE_DESC" => $lang['Chart_Page_Desc'],
"L_PAGE_TITLE" => $lang['Chart_Page_Title'],
"L_ARTIST" => $lang['Chart_Artist_Name'],
"L_TITLE" => $lang['Chart_Song_Name'],
"L_ALBUM" => $lang['Chart_Album_Name'],
"L_EDIT" => $lang['Edit'],
"L_DELETE" => $lang['Delete'],
"L_ACTION" => $lang['Action'],
"S_CHARTS_ACTION" => append_sid("admin_charts.$phpEx"),
"L_END_WEEK" => $lang['Chart_End_Week'],
"S_HIDDEN_FIELDS" => '')
);
while($row = $db->sql_fetchrow($result))
{
$i++;
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('charts', array(
"ROW_COLOR" => "#" . $row_color,
"ROW_CLASS" => $row_class,
"V_ARTIST" => $row['chart_artist'],
"V_TITLE" => $row['chart_song_name'],
"V_ALBUM" => $row['chart_album'],
"U_CHART_EDIT" => append_sid("admin_charts.$phpEx?action=edit&id=".$row['chart_id']),
"U_CHART_DELETE" => append_sid("admin_charts.$phpEx?action=delete&id=".$row['chart_id']))
);
}
}
$template->pparse("body");
include('./page_footer_admin.'.$phpEx);
?>