If you are unable to retrieve the posts through the Database so you can check the tables, try doing a Google Search for the posts. Type the page URL into the Google Search and look for a cached version. This is definitely not the optimal way to recover the posts, but will work in a … Read more
You can switch back and forth between blogs on a multisite with switch_to_blog and restore_current_blog. That should allow you to get anything you’d like and make queries as if you were actually on the other blog. Check them out: http://codex.wordpress.org/WPMU_Functions/switch_to_blog http://codex.wordpress.org/WPMU_Functions/restore_current_blog We did a lot of this with one of our recent sites.
http://wordpress.org/extend/plugins/wp-multisite-mirror/ or http://wordpress.org/extend/plugins/yd-wpmu-sitewide-options/
phpmyadmin as a plugin: WordPress › Portable phpMyAdmin « WordPress Plugins
In general, I’d recommend to read about $wpdb in detail in the Codex. Some notes: Never use the default wp_ prefix. Never set a hard coded prefix. It will be set during installation and should later be added using $wpdb->prefix. But: Prefixes can be changed with the following SQL command. “RENAME table wp_posts TO {$wpdb->prefix}posts;” … Read more
Maybe instead of using a tag, you could use get_post_meta() to retrieve a custom field? Set a meta field like featured and test to see if it’s set to one or something. $featured = get_post_meta($post->ID, ‘featured’, true); if ($featured === ‘yes’) echo ‘selected’; I hope I understood your question the right way and that this … Read more
Custom Post Types are more convinient and easy to implement, so I suggest you use them. Also the Posts will be ready to make a blog section in the future. About optimizing. Use some caching plugin, there are lots of them in WordPress Plugin Directory. Turn off the revisions to save database size: add define … Read more
Another perspective. Instead of using the two custom-post-type ‘team’ and ‘player’. You can use them as a single custom-post-type ‘participant’. Participant itself is a hierarchical post type, teams as the first level and player as it’s child. That way there wouldn’t be a player with more than 1 teams. If you are doing your own … Read more
there are 2 very popular form plugins Gravity Forms – extremely customisable and saves all data to your database (Commercial) Contact Form 7 – also saves everything to your database and easy to use (Free) Both send the data to the Admin panel so you can review inside WordPress. I know that Gravity Forms has … Read more
Error establishing database connection Can Only mean one thing and that is an Error establishing database connection, check your wp-config.php again and see that the database settings is correct and also make sure that your database user as permission on the database server.