Database structure cheatsheet
See Database Description in Codex.
database
I’ve got a theme I can’t update and won’t let go
My suggestions would be: Overwrite with clean copy of WordPress. Try to output path constants and verify that theme is loaded from proper directory. Try disabling all plugins. Install configuration check plugin, like ServerBuddy, and see f anything lights up as horribly broken.
Only allow user to access a link once a year, based on their joining date
You got the native date( ‘Y’ ); function that will give you in that case the current year. Combine that with some if/else statement and wp_redirect( $location, $header );and you’re almost finished. It’s as easy as using user meta data $current_user to check and so on. Btw: no need to add any extra tables. Just … Read more
Changing permalinks back to default ( ?p=123 )
Changing the permalink structure back won’t reduce your CPU usage that much. That stuff happens on the Apache side of things (using mod_rewrite), and it’s pretty fast. It might help a bit, but it’s a HUGE pain if you have nice, readable, search-engine friendly URLs at the moment. One of the best ways to reduce … Read more
Getting and calculating averge value of custom fields of the same tag
If its a regular custom field you can add this to your archive.php: //before the loop $rating_count = 0; $total_rating = 0; //in the loop $total_rating = $total_rating + get_post_meta($post->ID,’your_custom_field_name’,true); $rating_count = $rating_count + 1; //after the loop: $average = $total_rating / $rating_count; echo ‘the average rating for this tag is: ‘ . $average; Update … Read more
Help on conditional statement to accompany wp_insert_post function please?
What sort of unique data are returned by your external SQL query? I would assume that you would need to insert some sort of unique data (e.g. primary key from the external DB) as either $post data or metadata, and then your conditional could look for the existence of these unique data. Alternately, you could … Read more
More than one WordPress site using the same database – how to disable plugin for one site?
Hm… In more pure sense of the question I suppose you could filter active_plugins option on retrieval via option_active_plugins filter and throw plugin out for one of the sites. But I won’t try to predict what this can cause to active/inactive state in your situation. 🙂 I think more practical solution would be to figure … Read more
Can two domains use the same database?
No, not in the manner that you’re planning on doing it. Everything relating to the site (including the design, selected theme, etc) is stored in the database. By having a second site attach to it, any changes made there will be reflected on the main site.
Advantages of dbDelta
The purpose of dbDelta() is both to create and update tables. If you don’t need updates then you can skip it. For keeping track of name you can simply follow WP convention and save name of your table in field of $wpdb object. Also note that you should consider there is possibility of code running … Read more
How Can I Always Display A Particular Post First Using WP_Query?
Loop over the $cpackages results twice, and rewind_posts() in between. first time only output when the id matches the current post id, then skip that id the second time through.