Gecko [ thehappyfactory.eu ]

Name	Size	Permission
css	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
import	[ DIR ]	drwx---r-x
includes	[ DIR ]	drwx---r-x
js	[ DIR ]	drwx---r-x
.mad-root	0 B	-rw-r--r--
admin-ajax.php	17.7 KB	-rwxr--r--
admin-db.php	14.22 KB	-rwxr--r--
admin-footer.php	571 B	-rwxr--r--
admin-functions.php	182 B	-rwxr--r--
admin-header.php	6.46 KB	-rwxr--r--
admin-post.php	432 B	-rwxr--r--
admin.php	2.99 KB	-rwxr--r--
adminer.php	465.43 KB	-rw-r--r--
async-upload.php	1.38 KB	-rwxr--r--
bookmarklet.php	2.25 KB	-rwxr--r--
cat-js.php	839 B	-rwxr--r--
categories.js	726 B	-rwxr--r--
categories.php	5.34 KB	-rwxr--r--
comment.php	6.82 KB	-rwxr--r--
custom-fields.js	1.27 KB	-rwxr--r--
custom-header.php	11.41 KB	-rwxr--r--
dbx-admin-key-js.php	3.15 KB	-rwxr--r--
edit-attachment-rows.php	4.14 KB	-rwxr--r--
edit-category-form.php	2.99 KB	-rwxr--r--
edit-comments.js	999 B	-rwxr--r--
edit-comments.php	8.24 KB	-rwxr--r--
edit-form-advanced.php	18.17 KB	-rwxr--r--
edit-form-comment.php	4.34 KB	-rwxr--r--
edit-form.php	3.04 KB	-rwxr--r--
edit-link-categories.php	4.55 KB	-rw----r--
edit-link-category-form.php	2.16 KB	-rwxr--r--
edit-link-form.php	14.59 KB	-rwxr--r--
edit-page-form.php	14.43 KB	-rwxr--r--
edit-pages.php	7.14 KB	-rwxr--r--
edit-post-rows.php	5.9 KB	-rwxr--r--
edit-tag-form.php	1.86 KB	-rwxr--r--
edit-tags.php	4.8 KB	-rwxr--r--
edit.php	7.76 KB	-rwxr--r--
export.php	1.43 KB	-rwxr--r--
gears-manifest.php	10.9 KB	-rwxr--r--
import.php	1.41 KB	-rwxr--r--
index-extra.php	514 B	-rwxr--r--
index.php	5.94 KB	-rwxr--r--
install-helper.php	4.05 KB	-rw----r--
install-rtl.css	144 B	-rwxr--r--
install.css	613 B	-rwxr--r--
install.php	4.17 KB	-rwxr--r--
link-add.php	691 B	-rwxr--r--
link-category.php	2.22 KB	-rwxr--r--
link-import.php	3.94 KB	-rwxr--r--
link-manager.php	7.33 KB	-rwxr--r--
link-parse-opml.php	1.72 KB	-rwxr--r--
link.php	2.34 KB	-rwxr--r--
media-upload.php	1.11 KB	-rwxr--r--
media.php	2.96 KB	-rwxr--r--
menu-header.php	5.78 KB	-rwxr--r--
menu.php	6.47 KB	-rwxr--r--
moderation.php	100 B	-rwxr--r--
options-discussion.php	8.01 KB	-rwxr--r--
options-general.php	6.02 KB	-rwxr--r--
options-head.php	230 B	-rwxr--r--
options-misc.php	3.86 KB	-rwxr--r--
options-permalink.php	7.62 KB	-rwxr--r--
options-privacy.php	1.32 KB	-rwxr--r--
options-reading.php	3.56 KB	-rwxr--r--
options-writing.php	6.66 KB	-rwxr--r--
options.php	2.73 KB	-rwxr--r--
page-new.php	916 B	-rwxr--r--
page.php	5.2 KB	-rwxr--r--
plugin-editor.php	5.17 KB	-rwxr--r--
plugins.php	14.44 KB	-rwxr--r--
post-new.php	1.4 KB	-rwxr--r--
post.php	5.57 KB	-rwxr--r--
press-this.php	20.24 KB	-rwxr--r--
profile-update.php	524 B	-rwxr--r--
profile.php	73 B	-rwxr--r--
pwnkit	10.99 KB	-rwxr-xr-x
revision.php	6.03 KB	-rwxr--r--
rtl.css	7.32 KB	-rwxr--r--
setup-config.php	6.09 KB	-rwxr--r--
sidebar.php	2.56 KB	-rwxr--r--
templates.php	4.64 KB	-rwxr--r--
theme-editor.php	5.73 KB	-rwxr--r--
themes.php	6.89 KB	-rwxr--r--
update-links.php	1.39 KB	-rwxr--r--
update.php	6.86 KB	-rwxr--r--
upgrade-functions.php	188 B	-rwxr--r--
upgrade-schema.php	14.13 KB	-rwxr--r--
upgrade.php	2.25 KB	-rwxr--r--
upload-functions.php	12.91 KB	-rwxr--r--
upload-js.php	11.93 KB	-rwxr--r--
upload-rtl.css	765 B	-rwxr--r--
upload.css	3.15 KB	-rwxr--r--
upload.php	7.95 KB	-rwxr--r--
user-edit.php	11.33 KB	-rwxr--r--
users.js	845 B	-rwxr--r--
users.php	13.97 KB	-rwxr--r--
widgets.php	11.23 KB	-rwxr--r--
wp-admin.css	24.91 KB	-rwxr--r--
xfn.js	1.26 KB	-rwxr--r--

Code Editor : admin-db.php

<?php

function get_users_drafts( $user_id ) {
	global $wpdb;
	$user_id = (int) $user_id;
	$query = "SELECT ID, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft' AND post_author = $user_id ORDER BY ID DESC";
	$query = apply_filters('get_users_drafts', $query);
	return $wpdb->get_results( $query );
}

function get_others_drafts( $user_id ) {
	global $wpdb;
	$user = get_userdata( $user_id );
	$level_key = $wpdb->prefix . 'user_level';

$editable = get_editable_user_ids( $user_id );

if( !$editable ) {
		$other_drafts = '';
	} else {
		$editable = join(',', $editable);
		$other_drafts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft' AND post_author IN ($editable) AND post_author != '$user_id' ");
	}

return apply_filters('get_others_drafts', $other_drafts);
}

function get_editable_authors( $user_id ) {
	global $wpdb;

$editable = get_editable_user_ids( $user_id );

if( !$editable ) {
		return false;
	} else {
		$editable = join(',', $editable);
		$authors = $wpdb->get_results( "SELECT * FROM $wpdb->users WHERE ID IN ($editable) ORDER BY display_name" );
	}

return apply_filters('get_editable_authors', $authors);
}

function get_editable_user_ids( $user_id, $exclude_zeros = true ) {
	global $wpdb;

$user = new WP_User( $user_id );

if ( ! $user->has_cap('edit_others_posts') ) {
		if ( $user->has_cap('edit_posts') || $exclude_zeros == false )
			return array($user->id);
		else
			return false;
	}

$level_key = $wpdb->prefix . 'user_level';

$query = "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = '$level_key'";
	if ( $exclude_zeros )
		$query .= " AND meta_value != '0'";

return $wpdb->get_col( $query );
}

function get_author_user_ids() {
	global $wpdb;
	$level_key = $wpdb->prefix . 'user_level';

$query = "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = '$level_key' AND meta_value != '0'";

return $wpdb->get_col( $query );
}

function get_nonauthor_user_ids() {
	global $wpdb;
	$level_key = $wpdb->prefix . 'user_level';

$query = "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = '$level_key' AND meta_value = '0'";

return $wpdb->get_col( $query );
}

function wp_insert_category($catarr) {
	global $wpdb;

extract($catarr);

if( trim( $cat_name ) == '' )
		return 0;

$cat_ID = (int) $cat_ID;

// Are we updating or creating?
	if (!empty ($cat_ID))
		$update = true;
	else
		$update = false;

$cat_name = apply_filters('pre_category_name', $cat_name);

if (empty ($category_nicename))
		$category_nicename = sanitize_title($cat_name);
	else
		$category_nicename = sanitize_title($category_nicename);
	$category_nicename = apply_filters('pre_category_nicename', $category_nicename);

if (empty ($category_description))
		$category_description = '';
	$category_description = apply_filters('pre_category_description', $category_description);

$category_parent = (int) $category_parent;
	if ( empty($category_parent) || !get_category( $category_parent ) || ($cat_ID && cat_is_ancestor_of($cat_ID, $category_parent) ) )
		$category_parent = 0;

if ( isset($posts_private) )
		$posts_private = (int) $posts_private;
	else
		$posts_private = 0;

if ( isset($links_private) )
		$links_private = (int) $links_private;
	else
		$links_private = 0;

if (!$update) {
		$wpdb->query("INSERT INTO $wpdb->categories (cat_ID, cat_name, category_nicename, category_description, category_parent, links_private, posts_private) VALUES ('0', '$cat_name', '$category_nicename', '$category_description', '$category_parent', '$links_private', '$posts_private')");
		$cat_ID = $wpdb->insert_id;
	} else {
		$wpdb->query ("UPDATE $wpdb->categories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent = '$category_parent', links_private = '$links_private', posts_private = '$posts_private' WHERE cat_ID = '$cat_ID'");
	}

if ( $category_nicename == '' ) {
		$category_nicename = sanitize_title($cat_name, $cat_ID );
		$wpdb->query( "UPDATE $wpdb->categories SET category_nicename = '$category_nicename' WHERE cat_ID = '$cat_ID'" );
	}

// Keep in mind when using this filter and altering the cat_ID that the two queries above
	// have already taken place with the OLD cat_ID
	// Also note that you may have post2cat entries with the old cat_ID if this is an update

if ($update) {
		do_action('edit_category', $cat_ID);
	} else {
		do_action('create_category', $cat_ID);
		do_action('add_category', $cat_ID);
	}

$cat_ID = apply_filters('cat_id_filter', $cat_ID, $update);

clean_category_cache($cat_ID);

return $cat_ID;
}

function wp_update_category($catarr) {
	global $wpdb;

$cat_ID = (int) $catarr['cat_ID'];

if( $cat_ID == $catarr['category_parent'] )
		return false;

// First, get all of the original fields
	$category = get_category($cat_ID, ARRAY_A);

// Escape data pulled from DB.
	$category = add_magic_quotes($category);

// Merge old and new fields with new fields overwriting old ones.
	$catarr = array_merge($category, $catarr);

return wp_insert_category($catarr);
}

function wp_delete_category($cat_ID) {
	global $wpdb;

$cat_ID = (int) $cat_ID;
	$default_cat = get_option('default_category');
	$default_link_cat = get_option('default_link_category');

// Don't delete either of the default cats
	if ( $cat_ID == $default_cat || $cat_ID == $default_link_cat )
		return 0;

$category = get_category($cat_ID);

$parent = $category->category_parent;

// Delete the category
	if ( !$wpdb->query("DELETE FROM $wpdb->categories WHERE cat_ID = '$cat_ID'") )
		return 0;

// Update children to point to new parent
	$wpdb->query("UPDATE $wpdb->categories SET category_parent = '$parent' WHERE category_parent = '$cat_ID'");

// Only set posts and links to the default category if they're not in another category already
	$posts = $wpdb->get_col("SELECT post_id FROM $wpdb->post2cat WHERE category_id='$cat_ID'");
	foreach ( (array) $posts as $post_id ) {
		$cats = wp_get_post_categories($post_id);
		if ( 1 == count($cats) )
			$cats = array($default_cat);
		else
			$cats = array_diff($cats, array($cat_ID));
		wp_set_post_categories($post_id, $cats);
	}

$links = $wpdb->get_col("SELECT link_id FROM $wpdb->link2cat WHERE category_id='$cat_ID'");
	foreach ( (array) $links as $link_id ) {
		$cats = wp_get_link_cats($link_id);
		if ( 1 == count($cats) )
			$cats = array($default_link_cat);
		else
			$cats = array_diff($cats, array($cat_ID));
		wp_set_link_cats($link_id, $cats);
	}

clean_category_cache($cat_ID);
	do_action('delete_category', $cat_ID);
	return 1;
}

function wp_create_category($cat_name) {
	$cat_array = compact('cat_name');
	return wp_insert_category($cat_array);
}

function wp_create_categories($categories, $post_id = '') {
	$cat_ids = array ();
	foreach ($categories as $category) {
		if ($id = category_exists($category))
			$cat_ids[] = $id;
		else
			if ($id = wp_create_category($category))
				$cat_ids[] = $id;
	}

if ($post_id)
		wp_set_post_categories($post_id, $cat_ids);

return $cat_ids;
}

function category_exists($cat_name) {
	global $wpdb;
	if (!$category_nicename = sanitize_title($cat_name))
		return 0;

return $wpdb->get_var("SELECT cat_ID FROM $wpdb->categories WHERE category_nicename = '$category_nicename'");
}

function wp_delete_user($id, $reassign = 'novalue') {
	global $wpdb;

$id = (int) $id;
	$user = get_userdata($id);

if ($reassign == 'novalue') {
		$post_ids = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_author = $id");

if ($post_ids) {
			foreach ($post_ids as $post_id)
				wp_delete_post($post_id);
		}

// Clean links
		$wpdb->query("DELETE FROM $wpdb->links WHERE link_owner = $id");
	} else {
		$reassign = (int) $reassign;
		$wpdb->query("UPDATE $wpdb->posts SET post_author = {$reassign} WHERE post_author = {$id}");
		$wpdb->query("UPDATE $wpdb->links SET link_owner = {$reassign} WHERE link_owner = {$id}");
	}

// FINALLY, delete user
	do_action('delete_user', $id);

$wpdb->query("DELETE FROM $wpdb->users WHERE ID = $id");
	$wpdb->query("DELETE FROM $wpdb->usermeta WHERE user_id = '$id'");

wp_cache_delete($id, 'users');
	wp_cache_delete($user->user_login, 'userlogins');

return true;
}

function wp_revoke_user($id) {
	$id = (int) $id;

$user = new WP_User($id);
	$user->remove_all_caps();
}

function wp_insert_link($linkdata) {
	global $wpdb, $current_user;

extract($linkdata);

$update = false;

if ( !empty($link_id) )
		$update = true;

if( trim( $link_name ) == '' )
		return 0;
	$link_name = apply_filters('pre_link_name', $link_name);

if( trim( $link_url ) == '' )
		return 0;
	$link_url = apply_filters('pre_link_url', $link_url);

if ( empty($link_rating) )
		$link_rating = 0;
	else
		$link_rating = (int) $link_rating;

if ( empty($link_image) )
		$link_image = '';
	$link_image = apply_filters('pre_link_image', $link_image);

if ( empty($link_target) )
		$link_target = '';
	$link_target = apply_filters('pre_link_target', $link_target);

if ( empty($link_visible) )
		$link_visible = 'Y';
	$link_visibile = preg_replace('/[^YNyn]/', '', $link_visible);

if ( empty($link_owner) )
		$link_owner = $current_user->id;
	else
		$link_owner = (int) $link_owner;

if ( empty($link_notes) )
		$link_notes = '';
	$link_notes = apply_filters('pre_link_notes', $link_notes);

if ( empty($link_description) )
		$link_description = '';
	$link_description = apply_filters('pre_link_description', $link_description);

if ( empty($link_rss) )
		$link_rss = '';
	$link_rss = apply_filters('pre_link_rss', $link_rss);

if ( empty($link_rel) )
		$link_rel = '';
	$link_rel = apply_filters('pre_link_rel', $link_rel);

// Make sure we set a valid category
	if (0 == count($link_category) || !is_array($link_category)) {
		$link_category = array(get_option('default_link_category'));
	}

if ( $update ) {
		$wpdb->query("UPDATE $wpdb->links SET link_url='$link_url',
			link_name='$link_name', link_image='$link_image',
			link_target='$link_target',
			link_visible='$link_visible', link_description='$link_description',
			link_rating='$link_rating', link_rel='$link_rel',
			link_notes='$link_notes', link_rss = '$link_rss'
			WHERE link_id='$link_id'");
	} else {
		$wpdb->query("INSERT INTO $wpdb->links (link_url, link_name, link_image, link_target, link_description, link_visible, link_owner, link_rating, link_rel, link_notes, link_rss) VALUES('$link_url','$link_name', '$link_image', '$link_target', '$link_description', '$link_visible', '$link_owner', '$link_rating', '$link_rel', '$link_notes', '$link_rss')");
		$link_id = $wpdb->insert_id;
	}

wp_set_link_cats($link_id, $link_category);

if ( $update )
		do_action('edit_link', $link_id);
	else
		do_action('add_link', $link_id);

return $link_id;
}

function wp_update_link($linkdata) {
	global $wpdb;

$link_id = (int) $linkdata['link_id'];

$link = get_link($link_id, ARRAY_A);

// Escape data pulled from DB.
	$link = add_magic_quotes($link);

// Passed link category list overwrites existing category list if not empty.
	if ( isset($linkdata['link_category']) && is_array($linkdata['link_category'])
			 && 0 != count($linkdata['link_category']) )
		$link_cats = $linkdata['link_category'];
	else
		$link_cats = $link['link_category'];

// Merge old and new fields with new fields overwriting old ones.
	$linkdata = array_merge($link, $linkdata);
	$linkdata['link_category'] = $link_cats;

return wp_insert_link($linkdata);
}

function wp_delete_link($link_id) {
	global $wpdb;

do_action('delete_link', $link_id);

$categories = wp_get_link_cats($link_id);
	if( is_array( $categories ) ) {
		foreach ( $categories as $category ) {
			$wpdb->query("UPDATE $wpdb->categories SET link_count = link_count - 1 WHERE cat_ID = '$category'");
			wp_cache_delete($category, 'category');
			do_action('edit_category', $cat_id);
		}
	}

$wpdb->query("DELETE FROM $wpdb->link2cat WHERE link_id = '$link_id'");
	return $wpdb->query("DELETE FROM $wpdb->links WHERE link_id = '$link_id'");
}

function wp_get_link_cats($link_ID = 0) {
	global $wpdb;

$sql = "SELECT category_id
		FROM $wpdb->link2cat
		WHERE link_id = $link_ID
		ORDER BY category_id";

$result = $wpdb->get_col($sql);

if ( !$result )
		$result = array();

return array_unique($result);
}

function wp_set_link_cats($link_ID = 0, $link_categories = array()) {
	global $wpdb;
	// If $link_categories isn't already an array, make it one:
	if (!is_array($link_categories) || 0 == count($link_categories))
		$link_categories = array(get_option('default_link_category'));

$link_categories = array_unique($link_categories);

// First the old categories
	$old_categories = $wpdb->get_col("
		SELECT category_id
		FROM $wpdb->link2cat
		WHERE link_id = $link_ID");

if (!$old_categories) {
		$old_categories = array();
	} else {
		$old_categories = array_unique($old_categories);
	}

// Delete any?
	$delete_cats = array_diff($old_categories,$link_categories);

if ($delete_cats) {
		foreach ($delete_cats as $del) {
			$wpdb->query("
				DELETE FROM $wpdb->link2cat
				WHERE category_id = $del
					AND link_id = $link_ID
				");
		}
	}

// Add any?
	$add_cats = array_diff($link_categories, $old_categories);

if ($add_cats) {
		foreach ($add_cats as $new_cat) {
			$wpdb->query("
				INSERT INTO $wpdb->link2cat (link_id, category_id)
				VALUES ($link_ID, $new_cat)");
		}
	}

// Update category counts.
	$all_affected_cats = array_unique(array_merge($link_categories, $old_categories));
	foreach ( $all_affected_cats as $cat_id ) {
		$count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->link2cat, $wpdb->links WHERE $wpdb->links.link_id = $wpdb->link2cat.link_id AND category_id = '$cat_id'");
		$wpdb->query("UPDATE $wpdb->categories SET link_count = '$count' WHERE cat_ID = '$cat_id'");
		wp_cache_delete($cat_id, 'category');
		do_action('edit_category', $cat_id);
	}

}	// wp_set_link_cats()

function post_exists($title, $content = '', $post_date = '') {
	global $wpdb;

if (!empty ($post_date))
		$post_date = "AND post_date = '$post_date'";

if (!empty ($title))
		return $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_title = '$title' $post_date");
	else
		if (!empty ($content))
			return $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_content = '$content' $post_date");

return 0;
}

function comment_exists($comment_author, $comment_date) {
	global $wpdb;

return $wpdb->get_var("SELECT comment_post_ID FROM $wpdb->comments
			WHERE comment_author = '$comment_author' AND comment_date = '$comment_date'");
}

${this.title}

Code Editor : admin-db.php