Dachte ich auch erst, aber leider ist dies nicht der Fall.
Code: Alles auswählen
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Der Titel</title>
<meta name="Keywords" content="Suchworte">
<meta name="Description" content="Beschreibung">
<meta name="Author" content="Name">
<meta name="Copyright" content="Copyright 2002 - 2005">
<meta name="Publisher" content="Name">
<meta name="Robots" content="INDEX,FOLLOW">
<meta name="Audience" content="Alle">
<meta name="revisit-after" content="2 days">
<meta name="Content-language" content="DE">
<meta http-equiv="expires" content="3600">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="shortcut icon" href="../favicon.ico" >
<meta http-equiv="imagetoolbar" content="no">
<link href="../../css/blau.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="728" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="layouttabelle">
<tr>
<td height="197"><div id="logo">
<h1>Seitenname</h1>
</div>
<div id="werbung">
<?php include("werbung.php"); ?>
</div>
<div id="unterwerbung"> </div>
<div id="uebernewsletter"> </div>
<div id="uebernavi"> </div>
<div id="newsletter">
<form action="../../newsletter/eintragen.php" method="post" target="_blank">
<span align="center">
<input name="Aktion" type="radio" value="Anmelden" checked="checked" />
Anmelden
<input type="radio" name="Aktion" value="Abmelden" />
Abmelden
<input name="email" type="text" class="newsletterbutton" value="" size="30" maxlength="100" />
<input name="Input2" type="submit" class="newsletterbutton" value="Abschicken" />
</span>
</form>
</div>
<div id="kalender">
<?php include("../ncevecal/calendar.php"); ?>
</div><div id="navigationkomplett">
<div id="navigation">
<ul>
<li><a href="../../index.php">Startseite</a></li>
<li><a href="../../inhalt.php?site=events">Partydates</a></li>
<li><a href="../forum">Forum</a></li>
<li><a href="../der%20chat" target="_blank">Chat</a></li>
<li><a href="../../inhalt.php?site=links">Links</a></li>
<li><a href="../../inhalt.php?site=kontakt">Kontakt</a></li>
</ul>
</div>
<div id="bildnebennavi"></div></td>
</tr>
<tr>
<td valign="top"> <div id="inhalt">
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_PROFILE);
init_userprefs($userdata);
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['save']) )
{
$mode = "save";
}
else
{
$mode = "";
}
}
if( $mode != "" )
{
if( $mode == "list" || $mode == "all_list" )
{
$list_type = ($mode=="list")?"all_list":"list";
$template->set_filenames(array(
"body" => "charts_list_body.tpl")
);
$v_num = ($mode == "list")?10:30;
$template->assign_vars(array(
"V_WEEK_NUM" => $board_config['charts_week_num'],
"U_SHOW_LIST" => append_sid("charts.$phpEx?action=".$list_type),
"L_SHOW_LIST" => ($mode == "list")?$lang['All_Charts']:$lang['Top_Ten'],
"U_ADD_CHART" => append_sid("charts.$phpEx?action=new"),
"L_WEEK" => $lang['Chart_Week'],
"L_CHART_NAME" => $lang['Chart_Name'],
"L_POSITION" => $lang['Chart_Curr_Pos'],
"L_LAST_WEEK" => $lang['Chart_Last_Pos'],
"L_SONG_ARTIST" => $lang['Chart_Song_Artist'],
"L_ALBUM" => $lang['Chart_Album_Name'],
"L_ADDED" => $lang['Chart_Added_By'],
"L_INFO" => $lang['Chart_Info'],
"L_RATE" => $lang['Chart_Rate'],
"L_RESULT" => $lang['Chart_Result'],
"L_ADD_CHART" => $lang['New_Song'],
"L_SONG_TITLE" => $lang['Song_Title'],
"L_ARTIST" => $lang['Artist']
)
);
$db->sql_freeresult($result);
$sql = 'SELECT chart_id, chart_hot, chart_not, chart_song_name, chart_artist, chart_album, chart_last_pos, chart_best_pos, username FROM '.CHARTS_TABLE.', '.USERS_TABLE.' WHERE chart_poster_id=user_id ORDER BY (chart_hot-chart_not) DESC, chart_artist LIMIT 0,'.$v_num;
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['Chart_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
while($row = $db->sql_fetchrow($result))
{
$chart_counter++;
$template->assign_block_vars('chart_block', array(
"CHART_SONG" => $row['chart_song_name'],
"CHART_ARTIST" => $row['chart_artist'],
"CHART_ALBUM" => ($row['chart_album']=="NULL")?"":$row['chart_album'],
"CHART_POSTER" => $row['username'],
"CHART_LAST" => ($row['chart_last_pos']==0)?('<img src="images/new.gif"></img>'):"(#".$row['chart_last_pos'].")",
"CHART_HOT_NOT" => "(".$lang['Chart_Hot'].": ".$row['chart_hot']." - ".$lang['Chart_Not'].": ".$row['chart_not'].")",
"L_CHART_HOT" => '<img src="images/daumen1.gif"></img>',
"L_CHART_NOT" => '<img src="images/daumen5.gif"></img>',
"U_CHART_HOT" => append_sid("charts.$phpEx?action=vote&rate=1&id=".$row['chart_id']),
"U_CHART_NOT" => append_sid("charts.$phpEx?action=vote&rate=2&id=".$row['chart_id']),
"CHART_POS" => $chart_counter
)
);
}
$db->sql_freeresult($result);
$template->pparse('body');
}
else if( $mode == "vote" )
{
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)
{
if( isset($HTTP_POST_VARS['rate']) || isset($HTTP_GET_VARS['rate']) )
{
$rate = ( isset($HTTP_POST_VARS['rate']) ) ? $HTTP_POST_VARS['rate'] : $HTTP_GET_VARS['rate'];
}
else
{
$rate = 0;
}
if($rate==1||$rate==2)
{
if($userdata['session_logged_in'])
{
$sql = 'SELECT count(*) as counter FROM '.CHARTS_VOTERS_TABLE.' WHERE vote_chart_id = '.$chart_id.' AND vote_user_id = '.$userdata['user_id'];
if( !$result = $db->sql_query($sql) )
message_die(GENERAL_ERROR, $lang['Chart_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if(!$row['counter'])
{
$sql = 'INSERT INTO '.CHARTS_VOTERS_TABLE.'(vote_user_id, vote_chart_id, vote_rate)
VALUES('.$userdata['user_id'].','.$chart_id.','.$rate.')';
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Base_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
if($rate==1)
$sql = 'UPDATE '.CHARTS_TABLE.'
SET chart_hot=chart_hot+1
WHERE chart_id = '.$chart_id;
else
$sql = 'UPDATE '.CHARTS_TABLE.'
SET chart_not=chart_not+1
WHERE chart_id = '.$chart_id;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['Chart_Sql_Error'], $lang['Error'], __LINE__, __FILE__, $sql);
}
$message = $lang['Chart_vote_add'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=all_list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
else
{
$message = $lang['Chart_Rate_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=all_list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
}
else
{
$message = $lang['Chart_Login_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=all_list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
}
else
{
$message = $lang['Chart_Vote_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=all_list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
}
else
{
$message = $lang['Chart_Choose_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=all_list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
}
else if( $mode == "new" )
{
if($userdata['session_logged_in'])
{
$s_hidden_fields = '';
$template->set_filenames(array(
"body" => "charts_new_body.tpl")
);
$template->assign_vars(array(
"L_ADDING_TITLE" => $lang['New_Song'],
"L_SONG_NAME" => $lang['Chart_Song_Name'],
"L_ARTIST" => $lang['Chart_Artist_Name'],
"L_ALBUM" => $lang['Chart_Album_Name'],
"L_ADD_SONG" => $lang['New_Song'],
"S_HIDDEN_FIELDS" => $s_hidden_fields,
"S_CHART_ACTION" => append_sid("charts.$phpEx"),
"L_SHOW_LIST" => $lang['Title'],
"U_SHOW_LIST" => append_sid("charts.$phpEx?action=list")
)
);
$template->pparse('body');
}
else
{
$message = $lang['Chart_VLogin_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
}
else if( $mode == "save" )
{
if($userdata['session_logged_in'])
{
$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( $artist_name == "" || $song_name == "")
{
$message = $lang['Chart_Fields_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
$sql = "INSERT INTO ".CHARTS_TABLE."(chart_song_name, chart_artist, chart_album, chart_poster_id)
VALUES('".$song_name."','".$artist_name."','".$album_name."',".$userdata['user_id'].")";
if(!$result = $db->sql_query($sql))
{
$message = $lang['Chart_Song_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_ERROR, $message);
}
$message = $lang['Chart_Song_Add'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
else
{
$message = $lang['Chart_SLog_Err'];
$message .= "<br /><br />" . sprintf($lang['Chart_click_link'], "<a href=\"" . append_sid("charts.$phpEx?action=list") . "\">", "</a>") . "<br /><br />";
message_die(GENERAL_MESSAGE, $message);
}
}
}
else
{
message_die(GENERAL_MESSAGE, $lang['Chart_No_Arguments']);
}
?>
</div></td>
</tr>
<tr>
<td height="40"><div id="footerkomplett">
<div id="unterenavi">
<div id="unterenavitrenner"> </div>
<br /><b>
<a href="../../index.php">Startseite</a>
| <a href="../../inhalt.php?site=events">Partydates</a>
| <a href="../forum">Forum</a>
| <a href="../der%20chat" target="_blank">Chat</a>
| <a href="../../inhalt.php?site=links">Links</a>
| <a href="../../inhalt.php?site=kontakt">Kontakt</a>
| <a href="../../inhalt.php?site=werbungbuchen">Werbung
buchen</a><br />
<?php include('../counter/counter.php');?>
</div>
</div></td>
</tr>
<tr>
<td>
<?php include("../werbungunten.php"); ?>
</td>
</tr>
</table>
</body>
</html>