<?php
/***************************************************************************
* usercars.php
* -------------------
* begin : Sunday, Oct. 12, 2003
* copyright : (C) 2003 AWSW
* url :
http://www.awsw.de
* $Id: usercars.php,v 2.5.0 2003/10/12 11:00:00 AWSW 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', true);
$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);
// SESSION MANAGEMENT START
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
// SESSION MANAGEMENT END
// UPLOADDIRECTORY !!! START
// If your server does´nt work with this code use the following line:
// $phpbb_domain_path = "
http://www.domain.com/phpbb2/usercars/";
// Wenn Dein Server diesen Code nicht nutzen kann, dann verwende die folgende Zeile:
// $phpbb_domain_path = "
http://www.domain.de/phpbb2/usercars/";
$phpbb_domain_path = "http://" . $_SERVER['HTTP_HOST'] . $board_config['script_path'] . "usercars/";
$phpbb_domain_uploaddir = "usercars/";
// UPLOADDIRECTORY !!! END
// MAX UPLOADS START
$maxuploads = $board_config['usercars_max_uploads'];
// MAX UPLOADS END
// USER LOGGED IN ? START
if( !$userdata['session_logged_in'] )
{
header("Location: " . append_sid("login.$phpEx?redirect=usercars.$phpEx", true));
exit;
}
// USER LOGGED IN ? END
$submit_update = $HTTP_POST_VARS['submit_update'];
$submit_edit = $HTTP_POST_VARS['submit_edit'];
// DELETE ENTRY START
if ( isset($HTTP_GET_VARS['mode']) )
{
$mode = ($HTTP_GET_VARS['mode']);
}
if ( $mode == 'remove' )
{
if ( isset($HTTP_GET_VARS['t']))
{
$usercars_id = (intval($HTTP_GET_VARS['t']));
$user_id = ($userdata['user_id']);
// DELETE PICTURE START
$sql = "SELECT usercars_pic FROM " . $table_prefix . "usercars WHERE usercars_id = " . $usercars_id;
if ( ($result = $db->sql_query($sql)) )
{
while ( $row = $db->sql_fetchrow($result) )
{
unlink("./".$row['usercars_pic']);
}
}
// DELETE PICTURE END
$sql = "DELETE FROM " . $table_prefix . "usercars WHERE user_id = '$user_id' AND usercars_id = '$usercars_id'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, $lang['L_remove_usercars_data'], '', __LINE__, __FILE__, $sql);
}
}
if ( !(isset($HTTP_GET_VARS['t'])) )
{
message_die(GENERAL_MESSAGE, $lang['L_no_usercars_id']);
exit;
}
$header_location = ( @preg_match("/Microsoft|WebSTAR|Xitami/", getenv("SERVER_SOFTWARE")) ) ? "Refresh: 0; URL=" : "Location: ";
header($header_location . append_sid("usercars." . $phpEx, true));
exit;
}
else
{
define('SHOW_ONLINE', true);
$page_title = $lang['L_USERCARS'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$user_id = ($userdata['user_id']);
// DELETE ENTRY END
$template->set_filenames(array(
'body' => 'usercars_body.tpl')
);
if ($mode == 'edit' )
{
$t = ($HTTP_GET_VARS['t']);
$edit = true;
$template->assign_block_vars('switch_show_pic', array());
$sql = "SELECT * FROM " . $table_prefix . "usercars fe
WHERE fe.user_id = '" . $userdata['user_id'] . "'
AND fe.usercars_id = " . $t;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD2'], '', __LINE__, __FILE__, $sql);
}
$editrow = $db->sql_fetchrow($result);
$template->assign_vars(array(
'usercars_id_edit' => $editrow['usercars_id'],
'user_id_edit' => $editrow['user_id'],
'usercars_pic_edit' => $editrow['usercars_pic'],
'usercars_carname_edit' => $editrow['usercars_carname'],
'usercars_mods_edit' => $editrow['usercars_mods'],
'usercars_cylinders_edit' => $editrow['usercars_cylinders'],
'usercars_desc_edit' => $editrow['usercars_desc'],
'usercars_exhaust_edit' => $editrow['usercars_exhaust'],
'usercars_power_edit' => $editrow['usercars_power'],
'usercars_topspeed_edit' => $editrow['usercars_topspeed'])
);
}
// ADD ENTRY START
if (($submit_update) || ($submit_edit))
{
if ($HTTP_POST_VARS['usercars_carname'] == '')
{
$message = $lang['L_USERCARSS_MOD8'] . '<br /><br />[ <a href="'. append_sid("usercars.$phpEx") .'" class="gensmall">' . $lang['Usercars'] . '</a> ]<br />';
message_die(GENERAL_MESSAGE, $message);
}
}
$usercars_carname = $HTTP_POST_VARS['usercars_carname'];
$usercars_mods = $HTTP_POST_VARS['usercars_mods'];
$usercars_cylinders = $HTTP_POST_VARS['usercars_cylinders'];
$usercars_desc = $HTTP_POST_VARS['usercars_desc'];
$usercars_exhaust = $HTTP_POST_VARS['usercars_exhaust'];
$usercars_power = $HTTP_POST_VARS['usercars_power'];
$usercars_topspeed = $HTTP_POST_VARS['usercars_topspeed'];
if ($submit_update)
{
// UPLOAD PICTURE START
if($HTTP_POST_FILES["datei"]["name"] == "")
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD3']);
exit;
}
if($HTTP_POST_FILES["datei"]["tmp_name"] == "")
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD4']);
exit;
}
if($HTTP_POST_FILES["datei"]["size"] == 0)
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD5']);
exit;
}
if($HTTP_POST_FILES["datei"]["size"] > 131072)
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD4']);
exit;
}
if($HTTP_POST_FILES["datei"]["type"] == "image/jpg")
{
$extension = "jpg";
}
elseif($HTTP_POST_FILES["datei"]["type"] == "image/jpeg")
{
$extension = "jpg";
}
elseif($_FILES["datei"]["type"] == "image/gif")
{
$extension = "gif";
}
elseif($HTTP_POST_FILES["datei"]["type"] == "image/pjpeg")
{
$extension = "jpg";
}
else
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD6']);
exit;
}
// RENAME FILE START
$current_user_date_time = $userdata['user_id'] . "_" . date(ymd) . "_" . time() . "." . $extension;
$HTTP_POST_FILES["datei"]["name"] = $current_user_date_time;
// RENAME FILE END
move_uploaded_file($HTTP_POST_FILES["datei"]["tmp_name"], $phpbb_domain_uploaddir . $HTTP_POST_FILES["datei"]["name"]);
// UPLOAD PICTURE END
$usercars_pic = $phpbb_domain_uploaddir . $HTTP_POST_FILES["datei"]["name"];
chmod ("$usercars_pic",0644);
$user_id = ($userdata['user_id']);
$sql = "INSERT INTO " . $table_prefix . "usercars (usercars_id, user_id, usercars_pic, usercars_carname, usercars_mods, usercars_cylinders, usercars_desc, usercars_exhaust, usercars_power, usercars_topspeed) VALUES (NULL, '$user_id', '$usercars_pic', '$usercars_carname', '$usercars_mods', '$usercars_cylinders', '$usercars_desc', '$usercars_exhaust', '$usercars_power', '$usercars_topspeed')";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, $lang['L_USERCARS_MOD1'], '', __LINE__, __FILE__, $sql);
}
}
// ADD ENTRY END
// EDIT ENTRY START
else if ($submit_edit)
{
if ($HTTP_POST_FILES["datei"]["name"] == '')
{
if ($HTTP_POST_VARS['deletepic'])
{
// DELETE PIC
unlink("./" . $HTTP_POST_VARS['usercars_pic_edit']);
$usercars_pic = '';
}
else
{
$usercars_pic = $HTTP_POST_VARS['usercars_pic_edit'];
}
}
else
{
if($HTTP_POST_FILES["datei"]["tmp_name"] == "")
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD4']);
exit;
}
if($HTTP_POST_FILES["datei"]["size"] == 0)
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD5']);
exit;
}
if($HTTP_POST_FILES["datei"]["size"] > 131072)
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD4']);
exit;
}
if($HTTP_POST_FILES["datei"]["type"] == "image/jpg")
{
$extension = "jpg";
}
elseif($HTTP_POST_FILES["datei"]["type"] == "image/jpeg")
{
$extension = "jpg";
}
elseif($_FILES["datei"]["type"] == "image/gif")
{
$extension = "gif";
}
elseif($HTTP_POST_FILES["datei"]["type"] == "image/pjpeg")
{
$extension = "jpg";
}
else
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD6']);
exit;
}
// RENAME FILE START
$current_user_date_time = $userdata['user_id'] . "_" . date(ymd) . "_" . time() . "." . $extension;
$HTTP_POST_FILES["datei"]["name"] = $current_user_date_time;
// RENAME FILE END
move_uploaded_file($HTTP_POST_FILES["datei"]["tmp_name"], $phpbb_domain_uploaddir . $HTTP_POST_FILES["datei"]["name"]);
chmod ($phpbb_domain_uploaddir . $HTTP_POST_FILES["datei"]["name"],0644);
// UPLOAD PICTURE END
// DELETE OLD PIC
if ($HTTP_POST_VARS['usercars_pic_edit'] != '')
{
unlink("./" . $HTTP_POST_VARS['usercars_pic_edit']);
}
$usercars_pic = $phpbb_domain_uploaddir . $HTTP_POST_FILES["datei"]["name"];
}
$user_id = ($userdata['user_id']);
$sql= "UPDATE " . $table_prefix . "usercars SET usercars_pic = '$usercars_pic', usercars_carname = '$usercars_carname', usercars_mods = '$usercars_mods', usercars_cylinders = '$usercars_cylinders', usercars_desc = '$usercars_desc', usercars_exhaust = '$usercars_exhaust', usercars_power = '$usercars_power', usercars_topspeed = '$usercars_topspeed'
WHERE usercars_id = " . $HTTP_POST_VARS['usercars_edit_id'];
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, $lang['L_USERCARS_MOD1'], '', __LINE__, __FILE__, $sql);
}
else
{
$message = $lang['Edited_entry'].'<br /><br />[ <a href="'. append_sid("usercars.$phpEx") .'" class="gensmall">'.$lang['Usercars'].'</a> ]<br />';
message_die(GENERAL_MESSAGE, $message);
exit;
}
}
// EDIT ENTRY END
//
// HTML toggle selection
//
$html_status = $lang['HTML_is_OFF'];
//
// BBCode toggle selection
//
$bbcode_status = $lang['BBCode_is_ON'];
//
// Smilies toggle selection
//
$smilies_status = $lang['Smilies_are_ON'];
$template->assign_vars(array(
"usercars_id" => $usercars_id,
"user_id" => $user_id,
"usercars_pic" => $usercars_pic,
"usercars_carname" => $usercars_carname,
"usercars_mods" => $usercars_mods,
"usercars_cylinders" => $usercars_cylinders,
"usercars_desc" => $usercars_desc,
"usercars_exhaust" => $usercars_exhaust,
"usercars_power" => $usercars_power,
"usercars_topspeed" => $usercars_topspeed,
'L_USERCARS' => $lang['L_USERCARS'],
"L_usercars_carname" => $lang['usercars_carname'],
"L_usercars_desc" => $lang['usercars_desc'],
"L_usercars_mods" => $lang['usercars_mods'],
"L_usercars_cylinders" => $lang['usercars_cylinders'],
"L_usercars_exhaust" => $lang['usercars_exhaust'],
"L_usercars_power" => $lang['usercars_power'],
"L_usercars_topspeed" => $lang['usercars_topspeed'],
"L_usercars_pic" => $lang['L_usercars_pic'],
"L_add_edit_entry" => $edit ? $lang['L_edit_entry'] : $lang['L_add_entry'],
"L_max_uploads" => $lang['L_max_uploads'],
'HTML_STATUS' => $html_status,
'BBCODE_STATUS' => sprintf($bbcode_status, '<a href="' . append_sid("faq.$phpEx?mode=bbcode") . '" target="_phpbbcode">', '</a>'),
'SMILIES_STATUS' => $smilies_status,
"S_SUBMIT" => $edit ? 'submit_edit' : 'submit_update',
'show_pic' => $edit ? ($editrow['usercars_pic'] == '') ? "<td width='20%' rowspan='8' class='row1' align='center' valign='center'><span class='gensmall'>" . $lang['noimage'] . "</span></td>" : "<td width='20%' rowspan='8' class='row1' align='center' valign='middle'><img src=" . $editrow['usercars_pic'] . " width='150px' border='1' /><br><br><span class='gensmall'>" . $lang['deletepic'] . " </span><input type='checkbox' name='deletepic' /></td>" : '',
"L_SUBMIT" => $lang['Submit'],
"L_EDIT" => $lang['L_edit_entry'],
'L_DELETEPIC' => $lang['deletepic'],
'L_DELETE' => $lang['Delete'])
);
// MAX UPLOADS START
$user_id = ($userdata['user_id']);
$sql = "SELECT COUNT(*) AS total FROM " . $table_prefix . "usercars WHERE user_id = " . $user_id;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD2'], '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
if ( ($row['total'] > ($maxuploads - "1")) && ($mode != 'edit') )
{
$template->assign_block_vars('switch_max_uploads', array());
}
elseif (($mode == 'add') || ($mode == 'edit'))
{
$template->assign_block_vars('switch_upload_active', array());
}
// MAX UPLOADS END
// SHOW ENTRY START
$sql = "SELECT * FROM " . $table_prefix . "usercars fe WHERE fe.user_id = '" . $userdata['user_id'] . "' ORDER BY usercars_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD2'], '', __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) )
{
$html_on = 0;
$bbcode_on = 1;
$smilies_on = 1;
$bbcode_uid = make_bbcode_uid();
$row['usercars_desc'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_desc'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_desc'] = bbencode_first_pass($row['usercars_desc'], $bbcode_uid);
$row['usercars_desc'] = bbencode_second_pass($row['usercars_desc'], $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_mods'] = stripslashes(prepare_message(addslashes(unprepare_message($row['usercars_mods'])), $html_on, $bbcode_on, $smilies_on, $bbcode_uid));
$row['usercars_mods'] = bbencode_first_pass($row['usercars_mods'], $bbcode_uid);
$row['usercars_mods'] = bbencode_second_pass($row['usercars_mods'], $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);
$template->assign_block_vars("usercarsrow", array(
'usercars_id' => $row['usercars_id'],
'user_id' => $row['user_id'],
'usercars_pic' => ($row['usercars_pic'] == '') ? "<td colspan='2' height='21' class='row1' align='center'><span class='genmed'>" . $lang['noimage'] . "</span></td>" : "<td colspan='2' height='21' class='row1' align='center'><span class='genmed'><a href='" . $row['usercars_pic'] . "' target='_blank'><img src='" . $row['usercars_pic'] . "' width='350px' border='1' /></a></span></td>",
'usercars_carname' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_carname']))),
'usercars_mods' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_mods']))),
'usercars_cylinders' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_cylinders']))),
'usercars_desc' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_desc']))),
'usercars_exhaust' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_exhaust']))),
'usercars_power' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_power']))),
'usercars_topspeed' => str_replace("\n", "\n<br />\n", make_clickable(smilies_pass($row['usercars_topspeed']))),
'U_EDIT' => append_sid("usercars.$phpEx?mode=edit&t=" . $row['usercars_id']),
'U_DELETE' => append_sid("usercars.$phpEx?mode=remove&t=" . $row['usercars_id']),
'L_EDIT' => $lang['usercars_edit'],
'L_REMOVE' => $lang['Delete'],
'U_REMOVE' => append_sid("usercars.$phpEx?mode=remove&t=" . $row['usercars_id']))
);
}
// SHOW ENTRY END
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
?>