First of all you probably created an isolated file that is not under the umbrella of WP files. That’s why you are not getting $wpdb. I guess you may not following the general rules/conventions of theme development. my question is now how are you accessing the file? whatever, if you include the wp_config.php in your … Read more
You should avoid creating more tables. Just do it if you really have a good reason to. Note that wp_postmeta can store practically any kind of data, and simply using the get_post_meta function can do all the job in most cases. But if you must use another table, and taking it generally, then you’re looking … Read more
I’ll try to explain how it might be done, but not sure it will work: Install 2nd website with single db (2 copies). Create new table in your db. Call it wp_options2 and copy everything from wp_options into the new table in second install in wp-config.php, before if ( !defined(‘ABSPATH’) ) add define( ‘M7_OPTIONS_TABLE’, ‘wp_options2’ … Read more
The post that an attachment is related to is determined by the post_parent column on the wp_posts table (depending on your database prefix). Set it to the post_ID of the parent post.
You can use “W3 Total Cache” which isn’t a static file cache system. It however uses stuff such as opcode caching, memcached, and object caching to decrease page load time. APC, or another opcache, would be a good addition to your server, as well as using a lightweight httpd instead of bloated Apache. Forcing GZIP … Read more
Use bcrypt. http://codahale.com/how-to-safely-store-a-password/
Unless there is a core WordPress import filter available for your CMS ( see http://codex.wordpress.org/Importing_Content ) or a plugin for a CMS not covered by core WP ( see http://wordpress.org/extend/plugins/search.php?q=import ), or a Google search for your database schema doesn’t reveal anything, you need to roll your own importer. The best way is to write … Read more
None that don’t involve a backup. If you have a backup, you’ll have to do some work to restore only a certain user’s data without resetting everything to that point. I’d say import the backup into an empty database, then copy data over either with SQL (INSERT INTO wp_posts SELECT FROM otherdb.wp_posts WHERE post_author = … Read more
There are functions for saving and retrieving network-wide options: add_network_option(); update_network_option(); get_network_option(); The values of these options are stored in wp_sitemeta.
The function is update_recently_edited in wp-admin/includes/misc.php. unfortunately it is fixed at 5: function update_recently_edited( $file ) { $oldfiles = (array) get_option( ‘recently_edited’ ); if ( $oldfiles ) { $oldfiles = array_reverse( $oldfiles ); $oldfiles[] = $file; $oldfiles = array_reverse( $oldfiles ); $oldfiles = array_unique( $oldfiles ); if ( 5 < count( $oldfiles )) array_pop( $oldfiles … Read more