Anonymous in memberlist

[lunagang]

Opeens verschijnt er een veld bovenaan in mijn ledenlijst: http://marscards.downfire.com/forum/memberlist.php

Ik heb niks met de ledenlijst geprutst, hoe kan dit? Na de upgrade naar versie 2.0.10 kon ik ook mijn leden niet meer verwijderen via de memberslist.

[WebSiteNet]

Kan je memberlist.php in een .txt bestand zetten, uploaden en de link geven?

Zou je ook naar phpmyadmin willen gaan, in de tabel phpbb_users duiken en een screenshot maken zoals de gebruiker -1 daar staat.

En als laatste, wil je in includes/functions.php een regel zoeken waarin ANONYMOUS voorkomt en die regel hier plaatsen?

Dat is zo'n beetje alles wat ik nodig heb.

[sukkelaap]

ik ehb ook wel eens bij mods waar leden staan dat Anonymous er tussen kotm jah. Das best iri. Vaak gebeurd dat als een mod een gebruikersnaam opslaat en je bent niet ingelogd.

[lunagang]

Functions (ik denk dat je dit stuk bedoeld):

Code: Selecteer alles

function get_db_stat($mode)
{
	global $db;

	switch( $mode )
	{
		case 'usercount':
			$sql = "SELECT COUNT(user_id) AS total
				FROM " . USERS_TABLE . "
				WHERE user_id <> " . ANONYMOUS;
			break;

		case 'newestuser':
			$sql = "SELECT user_id, username
				FROM " . USERS_TABLE . "
				WHERE user_id <> " . ANONYMOUS . "
				ORDER BY user_id DESC
				LIMIT 1";
			break;

		case 'postcount':
		case 'topiccount':
			$sql = "SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total
				FROM " . FORUMS_TABLE;
			break;
	}

	if ( !($result = $db->sql_query($sql)) )
	{
		return false;
	}

	$row = $db->sql_fetchrow($result);

	switch ( $mode )
	{
		case 'usercount':
			return $row['total'];
			break;
		case 'newestuser':
			return $row;
			break;
		case 'postcount':
			return $row['post_total'];
			break;
		case 'topiccount':
			return $row['topic_total'];
			break;
	}

	return false;
}

//
// Get Userdata, $user can be username or user_id. If force_str is true, the username will be forced.
//
function get_userdata($user, $force_str = false)
{
	global $db;

	if (intval($user) == 0 || $force_str)
	{
		$user = trim(htmlspecialchars($user));
		$user = substr(str_replace("\\'", "'", $user), 0, 25);
		$user = str_replace("'", "\\'", $user);
	}
	else
	{
		$user = intval($user);
	}

	$sql = "SELECT *
		FROM " . USERS_TABLE . " 
		WHERE ";
	$sql .= ( ( is_integer($user) ) ? "user_id = $user" : "username = '" .  $user . "'" ) . " AND user_id <> " . ANONYMOUS;
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Tried obtaining data for a non-existent user', '', __LINE__, __FILE__, $sql);
	}

	return ( $row = $db->sql_fetchrow($result) ) ? $row : false;
}

// Start add - XData MOD

//
// Sets a specific XData point for a user to a value.  $user and $which_xdata can be either strings or IDs.
// Use the $force_something parameters to ensure that a numeric string for $user or $which_xdata will be treated
// as such.
//
function set_user_xdata($user, $which_xdata, $value, $force_user_string = false, $force_xd_string = false)
{
	global $db;

//	$value = trim(htmlspecialchars($value));
	$value = str_replace("\\'", "'", $value);
	$value = str_replace("'", "\\'", $value);

	$user_is_name = ((intval($user) == 0) || $force_user_string);
	$xd_is_name = ((intval($which_xdata) == 0) || $force_xd_string);

	if ($user_is_name)
	{
		$user = trim(htmlspecialchars($user));
		$user = substr(str_replace("\\'", "'", $user), 0, 25);
		$user = str_replace("'", "\\'", $user);
	}

	$user_where = ($user_is_name) ? ('u.username = \'' . $user . '\'') : ('u.user_id = ' . $user );
	$field_where = ($xd_is_name) ? ('xf.code_name = \'' . $which_xdata . '\'') : ('xf.field_id = ' . $which_xdata);

	$sql = "SELECT u.user_id, xf.field_id FROM "
		. USERS_TABLE . " AS u, " . XDATA_FIELDS_TABLE . " AS xf
		WHERE " . $user_where . " AND " . $field_where . "
		LIMIT 1";

	if ( !($result = $db->sql_query($sql)) )
	{
    	message_die(GENERAL_ERROR, 'DB error while finding  a user\'s XData field to edit it', '', __LINE__, __FILE__, $sql);
 	}

 	$row = $db->sql_fetchrow($result);

    $sql = "DELETE FROM " . XDATA_DATA_TABLE . "
    	WHERE user_id = " . $row['user_id'] . " AND field_id = " . $row['field_id'] . "
    	LIMIT 1";

	if ( !($db->sql_query($sql)) )
	{
       	message_die(GENERAL_ERROR, 'Could not remove user XData', '', __LINE__, __FILE__, $sql);
	}

	if ($value !== '')
	{
    	$sql = "INSERT INTO " . XDATA_DATA_TABLE . "
			(user_id, field_id, xdata_value)
			VALUES (" . $row['user_id'] . ", " . $row['field_id'] . ", '" . $value . "')";

		if ( !($db->sql_query($sql)) )
		{
       		message_die(GENERAL_ERROR, 'Could not insert user XData', '', __LINE__, __FILE__, $sql);
		}
	}
}

//
// Like get_userdata(), but gives the extra data from the MOD.
//
function get_user_xdata($user, $force_str = false)
{
 	global $db;

	$is_name = ((intval($user) == 0) || $force_str);

	if ($is_name)
	{
		$user = trim(htmlspecialchars($user));
		$user = substr(str_replace("\\'", "'", $user), 0, 25);
		$user = str_replace("'", "\\'", $user);

		$sql = "SELECT xf.code_name, xd.xdata_value FROM " . XDATA_DATA_TABLE . " xd, " . USERS_TABLE . " u, " . XDATA_FIELDS_TABLE . " xf
 			WHERE xf.field_id = xd.field_id AND xd.user_id = u.user_id AND u.username = '" . $user . "'";
	}
	else
	{
		$user = intval($user);

		$sql = "SELECT xf.code_name, xd.xdata_value FROM " . XDATA_DATA_TABLE . " xd, " . XDATA_FIELDS_TABLE . " xf
			WHERE xf.field_id = xd.field_id AND xd.user_id = " . $user;
	}

	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Tried obtaining XData for a non-existent user', '', __LINE__, __FILE__, $sql);
	}

	$data = array();
	while ( $row = $db->sql_fetchrow($result) )
	{
    	$data[$row['code_name']] = $row['xdata_value'];
	}

	return $data;
}

//
// Returns data about the existing extra fields as an array keyed by the code_name
// and sorted in the admin-specified order.
//

Memberlist: http://members.lycos.nl/lunagangclan/memberlist.txt
Memberlist.tpl: http://members.lycos.nl/lunagangclan/memberlist_tpl.txt (bron)
functions.php: http://members.lycos.nl/lunagangclan/functions.txt

Screenshot: http://members.lycos.nl/lunagangclan/phpbb.gif

In mijn PHPmyAdmin heb ik wel geknoeid, omdat ik hem uit de ledenlijst wilde halen. Later heb ik Anonymous maar weer terug gezet, omdat anders me leden zicht niet meer konden aanmelden Misschien heb ik hem er weer fout in terug gezet, maar het probleem was er al voor.

[WebSiteNet]

Hier is zo te zien niks mis mee.

Maar ik bedoelde zelf includes/contants.php en niet functions.php.

Dat typte ik automatisch in op een of andere manier. (ook nu weer bijna)

[lunagang]

Code: Selecteer alles

define('ANONYMOUS', -1);

Code: Selecteer alles

<?php
/***************************************************************************
 *                               constants.php
 *                            -------------------
 *   begin                : Saturday', Feb 13', 2001
 *   copyright            : ('C) 2001 The phpBB Group
 *   email                : support@phpbb.com
 *
 *   $Id: constants.php,v 1.47.2.4 2003/06/10 00:39:51 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.
 *
 ***************************************************************************/

if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}

// Debug Level
//define('DEBUG', 1); // Debugging on
define('DEBUG', 1); // Debugging off


// User Levels <- Do not change the values of USER or ADMIN
define('DELETED', -1);
define('ANONYMOUS', -1);

define('USER', 0);
define('ADMIN', 1);
define('MOD', 2);


// User related
define('USER_ACTIVATION_NONE', 0);
define('USER_ACTIVATION_SELF', 1);
define('USER_ACTIVATION_ADMIN', 2);

define('USER_AVATAR_NONE', 0);
define('USER_AVATAR_UPLOAD', 1);
define('USER_AVATAR_REMOTE', 2);
define('USER_AVATAR_GALLERY', 3);


// Group settings
define('GROUP_OPEN', 0);
define('GROUP_CLOSED', 1);
define('GROUP_HIDDEN', 2);


// Forum state
define('FORUM_UNLOCKED', 0);
define('FORUM_LOCKED', 1);


// Topic status
define('TOPIC_UNLOCKED', 0);
define('TOPIC_LOCKED', 1);
define('TOPIC_MOVED', 2);
define('TOPIC_WATCH_NOTIFIED', 1);
define('TOPIC_WATCH_UN_NOTIFIED', 0);


// Topic types
define('POST_NORMAL', 0);
define('POST_STICKY', 1);
define('POST_ANNOUNCE', 2);
define('POST_GLOBAL_ANNOUNCE', 3);


// SQL codes
define('BEGIN_TRANSACTION', 1);
define('END_TRANSACTION', 2);


// Error codes
define('GENERAL_MESSAGE', 200);
define('GENERAL_ERROR', 202);
define('CRITICAL_MESSAGE', 203);
define('CRITICAL_ERROR', 204);


// Private messaging
define('PRIVMSGS_READ_MAIL', 0);
define('PRIVMSGS_NEW_MAIL', 1);
define('PRIVMSGS_SENT_MAIL', 2);
define('PRIVMSGS_SAVED_IN_MAIL', 3);
define('PRIVMSGS_SAVED_OUT_MAIL', 4);
define('PRIVMSGS_UNREAD_MAIL', 5);


// URL PARAMETERS
define('POST_TOPIC_URL', 't');
define('POST_CAT_URL', 'c');
define('POST_FORUM_URL', 'f');
define('POST_USERS_URL', 'u');
define('POST_POST_URL', 'p');
define('POST_GROUPS_URL', 'g');

// Session parameters
define('SESSION_METHOD_COOKIE', 100);
define('SESSION_METHOD_GET', 101);


// Page numbers for session handling
define('PAGE_INDEX', 0);
define('PAGE_LOGIN', -1);
define('PAGE_SEARCH', -2);
define('PAGE_REGISTER', -3);
define('PAGE_PROFILE', -4);
define('PAGE_VIEWONLINE', -6);
define('PAGE_VIEWMEMBERS', -7);
define('PAGE_FAQ', -8);
define('PAGE_POSTING', -9);
define('PAGE_PRIVMSGS', -10);
define('PAGE_GROUPCP', -11);
define('PAGE_STAFF', -22);
define('PAGE_TOPIC_OFFSET', 5000);


// Auth settings
define('AUTH_LIST_ALL', 0);
define('AUTH_ALL', 0);

define('AUTH_REG', 1);
define('AUTH_ACL', 2);
define('AUTH_MOD', 3);
define('AUTH_ADMIN', 5);

define('AUTH_VIEW', 1);
define('AUTH_READ', 2);
define('AUTH_POST', 3);
define('AUTH_REPLY', 4);
define('AUTH_EDIT', 5);
define('AUTH_DELETE', 6);
define('AUTH_ANNOUNCE', 7);
define('AUTH_STICKY', 8);
define('AUTH_POLLCREATE', 9);
define('AUTH_VOTE', 10);
define('AUTH_ATTACH', 11);


// Table names
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
define('BANLIST_TABLE', $table_prefix.'banlist');
define('CATEGORIES_TABLE', $table_prefix.'categories');

define('COLOR_GROUPS_TABLE', $table_prefix.'color_groups');
define('CONFIG_TABLE', $table_prefix.'config');
define('DISALLOW_TABLE', $table_prefix.'disallow');
define('FORUMS_TABLE', $table_prefix.'forums');
define('GROUPS_TABLE', $table_prefix.'groups');
define('POSTS_TABLE', $table_prefix.'posts');
define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
define('PRUNE_TABLE', $table_prefix.'forum_prune');
define('RANKS_TABLE', $table_prefix.'ranks');
define('SEARCH_TABLE', $table_prefix.'search_results');
define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SMILIES_TABLE', $table_prefix.'smilies');
define('THEMES_TABLE', $table_prefix.'themes');
define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
define('TOPICS_TABLE', $table_prefix.'topics');
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');
define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
/* XData MOD :: START */
define('XDATA_FIELDS_TABLE', $table_prefix.'xdata_fields');
define('XDATA_DATA_TABLE', $table_prefix.'xdata_data');
define('XDATA_AUTH_TABLE', $table_prefix.'xdata_auth');

define('XD_AUTH_ALLOW', 1);
define('XD_AUTH_DENY', 0);
define('XD_AUTH_DEFAULT', 2);

define('XD_DISPLAY_NORMAL', 1);
define('XD_DISPLAY_ROOT', 2);
define('XD_DISPLAY_NONE', 0);
/* XData MOD :: END */
?>

[WebSiteNet]

Vreemd, dan moet iets anders de oorzaak zijn.

Het enigste wat ik nog kan verzinnen is dat anonymous 2 keer in de db staat.

Je zei dat je geupgraded was naar 2.0.10 en dan je sinds toen geen leden meer kan verwijderen door de gebruikerslijst. Had je een premodded versie ofzo? normaal kan je geen leden verwijderen via de ledenlijst.

[lunagang]

Daar kwam ik net ook achter Ik had de prune users mod geinstalleerd, maar ik had de gewijzigde versies geupload naar PHPBB 2.0.10. Nu heb ik de prune users mod opnieuw geinstalleerd en nu kan het weer.

Hij stond er toch 2 keer in, op de volgende pagina, die had ik nog niet bekeken. UserID 0