MYSQL Dump of KJV - Wordpress Plugin Started

I personally would love the ability to quote the bible on my website automatically without running into all types of restrictions on number of queries per day, etc; simply by referencing the passage. While I found a great plug-in for Wordpress that does much of what I wanted it relies on ESV’s website which has a number of restrictions on the use of passages. While my website meets the license restrictions for use, I’m not sure if I always will. As a result I wanted a more robust solution that I could always use. Since I couldn’t find one, I figured I’d make one myself ;-).

Since the KJV is in the public domain and freely available on the net (and it happens to be one of my favorite versions), I figured I’d start with that. While I was prepared to convert the KJV from text to a format my MYSQL database could play with, I fortunately found someone who had already done that. As a result he saved me a ton of time ;-). Look here in the coming days for a cool new Wordpress plug-in. It shouldn’t take me TOO long to get a simple version running. (I suppose those are probably famous last words).

7 Responses to “MYSQL Dump of KJV - Wordpress Plugin Started”

  1. dlogan Says:

    Well, I’m about 90% done with the plugin already ;-). I hopefully should have something posted by midnight tomorrow!! I found a quick guide to making a Wordpress plugin which was exactly what I needed to get the syntax to get started. :-)

  2. Chris Roberts Says:

    Sounds like a good idea! I didn’t think of trying to tie the plugin to a local copy of the KJV, that should work nicely. Feel free to rip any code you like from the ESV plugin if you think it would be helpful.

  3. dlogan Says:

    To test my new plugin :-) John 3:16

  4. dlogan Says:

    Not quite working right yet… I’ll have to trouble-shoot later.

  5. dlogan Says:

    Status of the Plugin thus far:
    1) Finds all entries in comments and content of the format book ch:verse or book ch:stverse-endverse
    2) Pulls Appropriate Entries From the KJV
    3) Formats this text according to a template entry and outputs (Creating and outputting needed CSS.

    Issues:
    1) Something in the main CSS is conclicting with the added CSS to prevent CSS hover over popups (removing all other CSS shows the link working properly).
    2) Running the plugin causes some parts of entries to fail to show up. (Again I think is associated with conflicting CSS from main CSS since all tags are closed properly).
    3) I still don’t have a name for the plugin. Any ideas?

  6. dlogan Says:

    As you can see my plugin is working ;-). I still need to write the options page for Wordpress, and the database load script for the install and we should be good to go!

  7. dlogan Says:

    Just type a verse, and it will automatically quote it. It takes pretty much any standard abbreviation and format ;-)
    John 14:12 Philippians 1:9-10 1 Cor 13:1-13

Leave a Reply