Wp database question and a side question

CMS & WordPress
1

I was wondering, how do I avoid getting the extra rows in the wp_post table (the inherit & drafts) or do I just have to go & delete them later.

And if I want to add addy custom databases to my wp theme. like for a game for example or to display a series of images…just add the new table in this database?
thx all & have an awesome day.
d

2

The Better WP Security plugin has a database cleanup utility that can delete autosaves, revision history, and drafts.

But–this isn’t something that’s necessary to do. A database is designed to hold lots of information and read and write to it in a quick manner.

And if I want to add addy custom databases to my wp theme. like for a game for example or to display a series of images…just add the new table in this database?

You really shouldn’t be editing the wordpress database directly.

If you need to include additional data with your posts and pages, you can add custom meta fields.

http://codex.wordpress.org/Custom_Fields

You can also create your own Taxonomies and post types.

http://codex.wordpress.org/Taxonomies
http://codex.wordpress.org/Post_Types

For displaying a series of images, use the media library’s features. Or, if you really need some advanced functionality, the NEXTGen Gallery plugin is reasonably popular.

Wordpress is a very powerful platform…there is very little (if anything) that you actually have to do manually.

3

Thanks Force appreciate the links & info will check them out.
to be a bit more specific. I was thinking of doing a semi “chose your own adventure” site.
so the user would have to login. at the end of each level some items are awared.
so i would need a db or table for the images of the awarded icons. so the user could see it.
one for the level the user is at…
maybe more? still just organizing this.
Open to any advice.

4

Regarding post revisions, you can configure number of revisions WordPress will keep in wp-config.php
http://codex.wordpress.org/Editing_wp-config.php#Post_Revisions

5

Thank you Ronalds. will check that out as well.
d

6

I’ve never encountered a choose-your-own-adventure website, nor had a request for one. So, that’s certainly an unusual endeavor.

As for awards, take a look at this plugin: http://wordpress.org/extend/plugins/simple-badges/

You also might have luck with search for badge plugins, rather than award plugins.

7

I thought it’d be an easy and entertaining way to test php and databases, possible get outside users who wanted to waste a few minutes to test it…I well may be off base.

8

Using wordpress as a platform for this might not be the best for what you have in mind.

You might want to think about tackling this project without using a CMS to build off of.

9

I think you are right :slight_smile: actually.