phpBB.nl

Code: Selecteer alles

<?php
   define('IN_PHPBB', true);
   $phpbb_root_path = './';
   include($phpbb_root_path . 'extension.inc');
   include($phpbb_root_path . 'common.'.$phpEx);


	$server_list = $_SERVER['PHP_SELF'];
	$db_table = $table_prefix . 'users';
	$list_username = $users->username;
					
	//
	// Start session management
	//
	$userdata = session_pagestart($user_ip, PAGE_INDEX);
	init_userprefs($userdata);
	//
	// End session management
	//

	$gen_simple_header = TRUE;

	if(!isset($userdata['session_logged_in'])) {
	   @header("Location: " . append_sid($phpbb_web_path . "login." . $phpEx . "?redirect=" . $_SERVER['PHP_SELF']));
	}

	$page_title = $lang['Page_Title'];
	@include("includes/page_header.$phpEx");

	$template->set_filenames(array(
		'Body' => 'list_usernames.tpl'
	));

	$template->assign_vars(array(
		'L_HEADER' => 'Select a Username',
		'L_COPY' => '&copy; 2003, <a href="http://www.digiserv.net/" target="_blank">digiServ Network</a>.',
		'L_PCV_COPY' => 'Released via <a href="http://www.pcvillageforums.com/" target="_blank">PC Village Forums</a>.<br />
						Get support and more mods <a href="http://www.pcvillageforums.com/" target="_blank">here</a>.',
		'U_FORM_ACTION' => $_SERVER['PHP_SELF']
	));

	$db_table = $table_prefix . 'users';
	$sql = "
		SELECT	username
		FROM	$db->dbname.$db_table
		WHERE	user_active = '1'
		ORDER	BY username
				ASC
	";

	if (!$result = $db->sql_query($sql)) {
		message_die(GENERAL_ERROR, $sql, 'Error Querying Database', __LINE__, __FILE__, $sql);
	}

	if ($row = $db->sql_fetchrow($result)) {
		$i = 0;

		do {
			$template->assign_block_vars('user_block', array(
				'L_USERNAME' => $row['username']
			));

			$i++;
		}
		while ($row = $db->sql_fetchrow($result));
	}

	$db->sql_freeresult($result);
	$template->pparse('Body');
	@include("includes/page_tail.$phpEx");
?>

Code: Selecteer alles

      FROM   $db->dbname.$db_table

Code: Selecteer alles

      FROM   $db_table