SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Guru
    Join Date
    Oct 2010
    Location
    Portland, Or
    Posts
    634
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    wp database question and a side question.

    mySql01question01.jpg
    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. #2
    Barefoot on the Moon! silver trophy
    Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,516
    Mentioned
    51 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by pdxSherpa View Post
    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.
    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.
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain

  3. #3
    SitePoint Guru
    Join Date
    Oct 2010
    Location
    Portland, Or
    Posts
    634
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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. #4
    SitePoint Zealot
    Join Date
    Jun 2011
    Location
    Kolding, Denmark
    Posts
    108
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)
    Regarding post revisions, you can configure number of revisions WordPress will keep in wp-config.php
    http://codex.wordpress.org/Editing_w...Post_Revisions

  5. #5
    SitePoint Guru
    Join Date
    Oct 2010
    Location
    Portland, Or
    Posts
    634
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Thank you Ronalds. will check that out as well.
    d

  6. #6
    Barefoot on the Moon! silver trophy
    Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,516
    Mentioned
    51 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by pdxSherpa View Post
    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.
    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.
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain

  7. #7
    SitePoint Guru
    Join Date
    Oct 2010
    Location
    Portland, Or
    Posts
    634
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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. #8
    Barefoot on the Moon! silver trophy
    Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,516
    Mentioned
    51 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by pdxSherpa View Post
    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.
    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.
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain

  9. #9
    SitePoint Guru
    Join Date
    Oct 2010
    Location
    Portland, Or
    Posts
    634
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I think you are right :-) actually.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •