Code: Alles auswählen
<?php
/***************************************************************************
* usercars_list.php
* -------------------
* begin : Friday, May 11, 2001
* copyright : (C) 2001 The phpBB Group
* email : support@phpbb.com
*
* $Id: memberlist.php,v 1.36.2.8 2003/06/09 13:06:19 psotfx Exp $
*
***************************************************************************/
/***************************************************************************
*
* 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);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
include($phpbb_root_path . 'includes/functions_post.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_USERCARS_LIST);
init_userprefs($userdata);
//
// End session management
//
if( !$userdata['session_logged_in'] )
{
header("Location: " . append_sid("login.$phpEx?redirect=usercars_list.$phpEx", true));
exit;
}
// Check GD Version
// GD1: ImageCreate + ImageCopyResized
// GD2: ImageCreateTrueColor + ImageCopyResampled
if ((function_exists(imagecreatetruecolor)) && (function_exists(imagecopyresampled)))
{
$gdversion = 2;
}
elseif ((function_exists(imagecreate)) && (function_exists(imagecopyresized)))
{
$gdversion = 1;
}
else
{
$gdversion = 0;
}
function makeThumbnail($o_file, $t_file, $t_ht = 80)
{
$size = getimagesize($o_file);
if ($size[2] == 2)
{
$o_im = imagecreatefromjpeg($o_file);
}
else if ($size[2] == 3)
{
$o_im = imagecreatefrompng($o_file);
}
$o_wd = $size[0];
$o_ht = $size[1];
// thumbnail width = target * original width / original height
$t_wd = ($o_wd * $t_ht / $o_ht);
if ($gdversion = 2)
{
$t_im = imagecreatetruecolor($t_wd, $t_ht);
imagecopyresampled($t_im, $o_im, 0, 0, 0, 0, $t_wd, $t_ht, $o_wd, $o_ht);
}
elseif ($gdversion = 1)
{
$t_im = imagecreate($t_wd, $t_ht);
imagecopyresized($t_im, $o_im, 0, 0, 0, 0, $t_wd, $t_ht, $o_wd, $o_ht);
}
imagejpeg($t_im,$t_file);
imagedestroy($o_im);
imagedestroy($t_im);
}
$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
if ( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
$mode = ( isset($HTTP_POST_VARS['mode']) ) ? htmlspecialchars($HTTP_POST_VARS['mode']) : htmlspecialchars($HTTP_GET_VARS['mode']);
}
else
{
$mode = 'username';
}
if(isset($HTTP_POST_VARS['order']))
{
$sort_order = ($HTTP_POST_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
}
else if(isset($HTTP_GET_VARS['order']))
{
$sort_order = ($HTTP_GET_VARS['order'] == 'ASC') ? 'ASC' : 'DESC';
}
else
{
$sort_order = 'ASC';
}
//
// Usercar_list sorting
//
$mode_types_text = array($lang['usercars_carname'], $lang['Sort_Username'], $lang['usercars_cylinders'], $lang['usercars_exhaust'], $lang['usercars_power'], $lang['usercars_topspeed']);
$mode_types = array('carname', 'username', 'cylinders', 'exhaust', 'power', 'topspeed');
$select_sort_mode = '<select name="mode">';
for($i = 0; $i < count($mode_types_text); $i++)
{
$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
$select_sort_mode .= '<option value="' . $mode_types[$i] . '"' . $selected . '>' . $mode_types_text[$i] . '</option>';
}
$select_sort_mode .= '</select>';
$select_sort_order = '<select name="order">';
if($sort_order == 'ASC')
{
$select_sort_order .= '<option value="ASC" selected="selected">' . $lang['Sort_Ascending'] . '</option><option value="DESC">' . $lang['Sort_Descending'] . '</option>';
}
else
{
$select_sort_order .= '<option value="ASC">' . $lang['Sort_Ascending'] . '</option><option value="DESC" selected="selected">' . $lang['Sort_Descending'] . '</option>';
}
$select_sort_order .= '</select>';
//
// Generate page
//
$page_title = $lang['L_USERCARS'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array(
'body' => 'usercarslist_body.tpl')
);
make_jumpbox('viewforum.'.$phpEx);
$template->assign_vars(array(
'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
'L_CARNAME' => $lang['usercars_carname'],
'L_CYLINDERS' => $lang['usercars_cylinders'],
'L_EXHAUST' => $lang['usercars_exhaust'],
'L_POWER' => $lang['usercars_power'],
'L_TOPSPEED' => $lang['usercars_topspeed'],
'L_PIC' => $lang['L_usercars_pic'],
'L_SUBMIT' => $lang['Sort'],
'L_USERCARS_LIST' => $lang['L_USERCARS_LIST'],
'U_ADD_EDIT' => append_sid("usercars.$phpEx"),
'S_MODE_SELECT' => $select_sort_mode,
'S_ORDER_SELECT' => $select_sort_order,
'S_MODE_ACTION' => append_sid("usercars_list.$phpEx"))
);
switch( $mode )
{
case 'carname':
$order_by = "usercars_carname $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'username':
$order_by = "u.username $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'cylinders':
$order_by = "usercars_cylinders $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'exhaust':
$order_by = "usercars_exhaust $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'power':
$order_by = "usercars_power $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
case 'topspeed':
$order_by = "usercars_topspeed $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
default:
$order_by = "u.username $sort_order LIMIT $start, " . $board_config['topics_per_page'];
break;
}
$sql = "SELECT c.usercars_id, c.user_id, c.usercars_pic, c.usercars_carname, c.usercars_cylinders, c.usercars_exhaust, c.usercars_power, c.usercars_topspeed, u.username, u.user_id
FROM " . $table_prefix . "usercars AS c
LEFT JOIN " . USERS_TABLE . " AS u ON c.user_id = u.user_id
WHERE c.user_id <> ''
ORDER BY $order_by";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query usercars', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
$username = $row['username'];
$user_id = $row['user_id'];
$html_on = 0;
$bbcode_on = 1;
$smilies_on = 0;
$bbcode_uid = make_bbcode_uid();
$row['usercars_carname'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_carname'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_carname'] = bbencode_first_pass($row['usercars_carname'], $bbcode_uid);
$row['usercars_carname'] = bbencode_second_pass($row['usercars_carname'], $bbcode_uid);
$row['usercars_cylinders'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_cylinders'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_cylinders'] = bbencode_first_pass($row['usercars_cylinders'], $bbcode_uid);
$row['usercars_cylinders'] = bbencode_second_pass($row['usercars_cylinders'], $bbcode_uid);
$row['usercars_exhaust'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_exhaust'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_exhaust'] = bbencode_first_pass($row['usercars_exhaust'], $bbcode_uid);
$row['usercars_exhaust'] = bbencode_second_pass($row['usercars_exhaust'], $bbcode_uid);
$row['usercars_power'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_power'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_power'] = bbencode_first_pass($row['usercars_power'], $bbcode_uid);
$row['usercars_power'] = bbencode_second_pass($row['usercars_power'], $bbcode_uid);
$row['usercars_topspeed'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_topspeed'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_topspeed'] = bbencode_first_pass($row['usercars_topspeed'], $bbcode_uid);
$row['usercars_topspeed'] = bbencode_second_pass($row['usercars_topspeed'], $bbcode_uid);
$carname = ( !empty($row['usercars_carname']) ) ? (strlen($row['usercars_carname'])>80) ? substr($row['usercars_carname'], 0, 80)."..." : $row['usercars_carname'] : ' ';
$cylinders = ( !empty($row['usercars_cylinders']) ) ? (strlen($row['usercars_cylinders'])>80) ? substr($row['usercars_cylinders'], 0, 80)."..." : $row['usercars_cylinders'] : ' ';
$exhaust = ( !empty($row['usercars_exhaust']) ) ? (strlen($row['usercars_exhaust'])>80) ? substr($row['usercars_exhaust'], 0, 80)."..." : $row['usercars_exhaust'] : ' ';
$power = ( !empty($row['usercars_power']) ) ? (strlen($row['usercars_power'])>80) ? substr($row['usercars_power'], 0, 80)."..." : $row['usercars_power'] : ' ';
$topspeed = ( !empty($row['usercars_topspeed']) ) ? (strlen($row['usercars_topspeed'])>80) ? substr($row['usercars_topspeed'], 0, 80)."..." : $row['usercars_topspeed'] : ' ';
if (!empty($row['usercars_pic']))
{
$filetype = getimagesize($row['usercars_pic']);
if ( ($gdversion > 0) && ($filetype[2] != 1) ) // Does GD-Lib exist & uploaded file is not GIF
{
list ($path, $picname) = split('/', $row['usercars_pic']);
$thumbpath = $path . '/' . 'thumbs/';
if (!file_exists($thumbpath . $picname))
{
makeThumbnail($row['usercars_pic'], $thumbpath . $picname);
}
$pic = "<a href='" . $row['usercars_pic'] . "' target='_blank'><img src='" . $thumbpath . $picname . "' border='0' /></a>";
}
else // No GD-Lib installed or cannot create thumb because of uploaded file is GIF
{
$pic = "<a href='" . $row['usercars_pic'] . "' target='_blank'><img src='" . $row['usercars_pic'] . "' border='0' height='80' /></a>";
}
}
else
{
$pic = "<span class='gensmall'>" . $lang['noimage'] . "</span>";
}
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('usercars_row', array(
'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ),
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'USERNAME' => $username,
'CARNAME' => $carname,
'CYLINDERS' => $cylinders,
'EXHAUST' => $exhaust,
'POWER' => $power,
'TOPSPEED' => $topspeed,
'PIC' => $pic,
'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
);
$i++;
}
while ( $row = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);
}
if ( $board_config['topics_per_page'] > 10 )
{
$sql = "SELECT count(*) AS total
FROM " . $table_prefix . "usercars";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error getting total entries', '', __LINE__, __FILE__, $sql);
}
if ( $total = $db->sql_fetchrow($result) )
{
$total_usercar_entries = $total['total'];
$pagination = generate_pagination("usercars_list.$phpEx?mode=$mode&order=$sort_order", $total_usercar_entries, $board_config['topics_per_page'], $start). ' ';
}
$db->sql_freeresult($result);
}
else
{
$pagination = ' ';
$total_usercar_entries = 10;
}
$template->assign_vars(array(
'PAGINATION' => $pagination,
'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['topics_per_page'] ) + 1 ), ceil( $total_usercar_entries / $board_config['topics_per_page'] )),
'L_GOTO_PAGE' => $lang['Goto_page'])
);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Also derzeit nutzen 13 User den Mod. Stell ich nun im ACP in der allg. Konfig auf "Anzeige von 10 Themen je Seite" werden auch nur 10 User in der Usercars-Liste angezeigt. In den Profilen sind die Daten schon vorhanden, nur eben nicht in der Liste.