phpBB.de

Code: Alles auswählen

Open: includes/functions_user.php
Find
Tip: This may be a partial find and not the whole line.

Code:Select All
$table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, FORUMS_TRACK_TABLE, PROFILE_FIELDS_DATA_TABLE, MODERATOR_CACHE_TABLE, DRAFTS_TABLE, BOOKMARKS_TABLE);
In-line Find
Tip: This is a partial match of a line for in-line operations.

Code:Select All
);
In-line Add before

Code:Select All
, DL_NOTRAF_TABLE
Find
Tip: This may be a partial find and not the whole line.

Code:Select All
$cache->destroy('sql', MODERATOR_CACHE_TABLE);
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code:Select All
// Delete Download Favorites from this user
$sql = "DELETE FROM " . DL_FAVORITES_TABLE . "
WHERE fav_user_id = $user_id";
$db->sql_query($sql);

Code: Alles auswählen

Open: includes/functions_user.php
Find
Tip: This may be a partial find and not the whole line.

Code:Select All
TOPICS_TABLE			=> array('topic_first_poster_name', 'topic_last_poster_name'),
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code:Select All
		GALLERY_ALBUMS_TABLE	=> array('album_last_username'),
		GALLERY_COMMENTS_TABLE	=> array('comment_username'),
		GALLERY_IMAGES_TABLE	=> array('image_username'),
<< Hide
Find
Tip: This may be a partial find and not the whole line.

Code:Select All
	if ($config['newest_username'] == $old_name)
Add before
Tip: Add these lines on a new blank line before the preceding line(s) to find.

Code:Select All
	$sql = 'UPDATE ' . GALLERY_ALBUMS_TABLE . "
		SET album_name = '" . $db->sql_escape($new_name) . "'
		WHERE album_name = '" . $db->sql_escape($old_name) . "'
			AND album_user_id <> 0
			AND parent_id = 0";
	$db->sql_query($sql);
<< Hide
Find
Tip: This may be a partial find and not the whole line.

Code:Select All
		$sql = 'UPDATE ' . TOPICS_TABLE . " SET topic_last_poster_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'
			WHERE " . $db->sql_in_set('topic_last_poster_id', $user_id_ary);
		$db->sql_query($sql);
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code:Select All
		$sql = 'UPDATE ' . GALLERY_ALBUMS_TABLE . " SET album_last_user_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'
			WHERE " . $db->sql_in_set('album_last_user_id', $user_id_ary);
		$db->sql_query($sql);

		$sql = 'UPDATE ' . GALLERY_COMMENTS_TABLE . " SET comment_user_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'
			WHERE " . $db->sql_in_set('comment_user_id', $user_id_ary);
		$db->sql_query($sql);

		$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . " SET image_user_colour = '" . $db->sql_escape($sql_ary['user_colour']) . "'
			WHERE " . $db->sql_in_set('image_user_id', $user_id_ary);
		$db->sql_query($sql);
<< Hide