phpBB.de

Code: Alles auswählen

//
// Switch mode
//
switch ($mode)
{
	case 'add':
		// Link categories dropdown list
		foreach($link_categories as $cat_id => $cat_title)
		{
			$link_cat_option .= "<option value=\"$cat_id\">$cat_title</option>";
		}

		$template->assign_vars(array(
			'PAGE_TITLE' => $lang['Add_link'],
			'PAGE_EXPLAIN' => $lang['Add_link_explain'],
			'PAGE_ACTION' => append_sid ("admin_links.$phpEx?mode=update&action=add"),
			'LINK_ACTIVE_NO' => 'checked="checked"',
			'LINK_CAT_OPTION' => $link_cat_option,
			'L_SUBMIT' => $lang['Add_link']
		));
		break;

	case 'view':
		$template->assign_vars(array(
			'PAGE_TITLE' => $lang['Links'],
			'PAGE_EXPLAIN' => $lang['Links_explain'],
			'U_LINK' => "admin_links.$phpEx",
			'L_EDIT' => $lang['Edit_link'],
			'L_DELETE' => $lang['Delete_link']
		));

		$sql = "SELECT l.*, u.username
			FROM " . LINKS_TABLE . " l, " . USERS_TABLE . " u
			WHERE l.user_id = u.user_id
			ORDER BY link_id DESC";

		if(!$result = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, "Couldn not query links list.", '', __LINE__, __FILE__, $sql);
		}

		if ( $row = $db->sql_fetchrow($result) )
		{
			$i = 0;
			do
			{
				$row_class = !($i % 2) ? $theme['td_class1'] : $theme['td_class2'];
				$link_id = $row['link_id'];
				$link_id .= '&sid=' . $userdata['session_id'] . '';
				$user_id = $row['user_id'];
				$username = $row['username'];

				$template->assign_block_vars("linkrow", array(
					'ROW_CLASS' => $row_class,
					'LINK_ID' => $link_id,
					'LINK_TITLE' => $row['link_title'],
					'LINK_URL' => $row['link_url'],
					'LINK_CATEGORY' => $link_categories[$row['link_category']],
					'U_LINK_USER' => ($user_id != ANONYMOUS ? ("<a href=\"../profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id\" target=\"_blank\">$username</a>") : $username),
					'LINK_JOINED' => create_date($lang['DATE_FORMAT'], $row['link_joined'], $board_config['board_timezone']),
					'LINK_USER_IP' => decode_ip($row['user_ip']),
					'LINK_DESC' => $row['link_desc'],
					'LINK_ACTIVE' => '<font color="' . ($row['link_active'] ? 'green">' . $lang['ON'] : 'red">' . $lang['OFF']) . '</font>',
					'LINK_HITS' => $row['link_hits']
				));
				$i ++;
			}
			while ( $row = $db->sql_fetchrow($result) );
		}

		break;

	case 'edit':
	case 'delete':
		$sql = "SELECT * FROM " . LINKS_TABLE . " WHERE link_id = '$link_id'";

		if(!$result = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, "Couldn't obtain link information.", '', __LINE__, __FILE__, $sql);
		}

		if ( $row = $db->sql_fetchrow($result) )
		{
			// Link categories dropdown list
			foreach($link_categories as $cat_id => $cat_title)
			{
				$link_cat_option .= "<option value=\"$cat_id\"" . ($cat_id == $row['link_category'] ? " selected" : "") . ">$cat_title</option>";
			}

			$link_logo_src = $row['link_logo_src'];

			$template->assign_vars(array(
				'PAGE_TITLE' => ($mode == 'edit' ? $lang['Edit_link'] : $lang['Delete_link']),
				'PAGE_EXPLAIN' => ($mode == 'edit' ? $lang['Edit_link_explain'] . (' <a href="' . append_sid("admin_links.$phpEx?mode=delete&link_id=$link_id") . '">' . $lang['Delete_link'] . '</a>') : $lang['Delete_link_explain'] . (' <a href="' . append_sid("admin_links.$phpEx?mode=edit&link_id=$link_id") . '">' . $lang['Edit_link'] . '</a>')),
				'PAGE_ACTION' => ($mode == 'edit' ? "admin_links.$phpEx?mode=update&action=modify&link_id=$link_id&sid=" . $userdata['session_id'] . "" : "admin_links.$phpEx?mode=update&action=delete&link_id=$link_id&sid=" . $userdata['session_id'] . ""),

				'L_SUBMIT' => ($mode == 'edit' ? $lang['Link_update'] : $lang['Link_delete']),

				'LINK_ID' => $link_id,
				'LINK_TITLE' => $row['link_title'],
				'LINK_DESC' => $row['link_desc'],
				'LINK_URL' => $row['link_url'],
				'LINK_LOGO_SRC' => $row['link_logo_src'],
				'LINK_LOGO_IMG' => '<img src="' . (substr($link_logo_src, 0, 4) == 'http' ? $link_logo_src : "../$link_logo_src") . '" border="0" vspace="10" hspace="10" />',


				'LINK_ACTIVE_YES' => ($row['link_active'] ? 'checked="checked"' : ''),
				'LINK_ACTIVE_NO' => (!$row['link_active'] ? 'checked="checked"' : ''),

				'LINK_CAT_OPTION' => $link_cat_option
			));
		}
		break;
	case 'update':
		$link_title = ( !empty($HTTP_POST_VARS['link_title']) ) ? trim($HTTP_POST_VARS['link_title']) : '';
		$link_desc = ( !empty($HTTP_POST_VARS['link_desc']) ) ? trim($HTTP_POST_VARS['link_desc']) : '';
		$link_category = ( !empty($HTTP_POST_VARS['link_category']) ) ? (is_numeric($HTTP_POST_VARS['link_category']) ? $HTTP_POST_VARS['link_category'] : 0) : 0;
		$link_url = ( !empty($HTTP_POST_VARS['link_url']) ) ? trim($HTTP_POST_VARS['link_url']) : '';
		$link_logo_src = ( !empty($HTTP_POST_VARS['link_logo_src']) ) ? trim($HTTP_POST_VARS['link_logo_src']) : '';
		$link_active = ( !empty($HTTP_POST_VARS['link_active']) ) ? 1 : 0;

		$link_joined = time();
		$user_id = $userdata['user_id'];

		switch ($action)
		{
			case 'add':
				if($link_title && $link_desc && $link_category && $link_url && $link_logo_src)
				{
					$sql = "INSERT INTO " . LINKS_TABLE . " (link_title, link_desc, link_category, link_url, link_logo_src, link_joined, link_active, user_id , user_ip)
						VALUES ('$link_title', '$link_desc', '$link_category', '$link_url', '$link_logo_src', '$link_joined', '$link_active', '$user_id ', '$user_ip')";

					if ( !$db->sql_query($sql) )
					{
						$message = $lang['Link_admin_add_fail'];
					}
					else
					{
						$message = $lang['Link_admin_add_success'];
						$action_success = TRUE;
					}
				}
				else
				{
					$message = $lang['Link_incomplete'];
				}
				break;
			case 'modify':
				if($link_id && $link_title && $link_desc && $link_category && $link_url && $link_logo_src)
				{

					$sql = "UPDATE " . LINKS_TABLE . " SET link_title = '$link_title', link_desc = '$link_desc', link_url = '$link_url',
					       link_logo_src = '$link_logo_src', link_category = '$link_category', link_active = '$link_active' WHERE link_id = '$link_id'";

					if ( !$db->sql_query($sql) )
					{
						$message = $lang['Link_admin_update_fail'];
					}
					else
					{
						$message = $lang['Link_admin_update_success'];
						$action_success = TRUE;
					}
				}
				else
				{
					$message = $lang['Link_incomplete'];
				}
				break;
			case 'delete':

				if($link_id)
				{
					$sql = "DELETE FROM " . LINKS_TABLE . " WHERE link_id = '$link_id'";

					if ( !$db->sql_query($sql) )
					{
						$message = $lang['Link_admin_delete_fail'];
					}
					else
					{
						$message = $lang['Link_admin_delete_success'];
						$action_success = TRUE;
					}
				}
				else
				{
					$message = $lang['Link_admin_delete_fail'];
				}
				break;
		} // Close Update Switch

		if(!$action_success)
		{
			$message .= '<br /><br />' . sprintf($lang['Click_return_lastpage'], '<a href="' . $HTTP_REFERER . '">', '</a>');
		}

		$message .= '<br /><br />' . sprintf($lang['Click_return_admin_links'], '<a href="' . append_sid("admin_links.$phpEx?mode=view") . '">', '</a>');
		message_die(GENERAL_MESSAGE, $message);

		break;
}

$template->pparse("body");

Code: Alles auswählen

//
// Link categories dropdown list
//
foreach ($link_categories as $cat_id => $cat_title)
{
	$link_cat_option .= "<option value=\"$cat_id\">$cat_title</option>";
}

$template->assign_vars(array(
	'PAGINATION' => $pagination,
	'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $linkspp ) + 1 ), ceil( $total_links / $linkspp )),
	'L_GOTO_PAGE' => $lang['Goto_page'],

	'LINK_CAT_OPTION' => $link_cat_option
));

$template->pparse("body");

include('includes/page_tail.'.$phpEx);

Code: Alles auswählen

<a href="" target="_blank"><img src="" width="88" height="31" border="0" alt="Arbeitsplatte" /></a>

Code: Alles auswählen

<!-- BEGIN linkrow -->
			<tr>
				<td valign="top" width="10%"><a href="{linkrow.LINK_URL}" alt="{linkrow.LINK_DESC}" target="_blank"><img src="{linkrow.LINK_LOGO_SRC}" alt="{linkrow.LINK_TITLE}" width="468" height="60" border="1" /></a></td>
				<td class="genmed" valign="top" width="75%"><a href="{linkrow.LINK_URL}" class="genmed" target="_blank">{linkrow.LINK_TITLE}</a><br />{linkrow.LINK_DESC}</td>
				<td nowrap="nowrap" nowrap="nowrap" width="5%">&nbsp;</td>
				<td class="gensmall" valign="top" nowrap="nowrap" width="10%">{L_LINK_CATEGORY}: {linkrow.LINK_CATEGORY}<br />{L_LINK_JOINED}: {linkrow.LINK_JOINED}<br />{L_LINK_HITS}: {linkrow.LINK_HITS}</td>
			</tr>
			<tr>
				<td colspan="4"><hr /></td>
			</tr>
			<!-- END linkrow -->