WordPress.org

Support

Support » Multisite » How can I find out the names of database tables a plugin is using?

How can I find out the names of database tables a plugin is using?

Viewing 15 replies - 1 through 15 (of 22 total)
  • Andrea Rennick
    Moderator

    @andrea_r

    If the plugin doesn’t create new tables, you have to read the code (in the plugin) to see which tables the plugin is accessing.

    Sjors01
    Member

    @sjors01

    Thanks for the tip Andrea, but can you show an example of how this would look in the .php file? I don’t have any php knowledge whatsoever.

    See this statement in the plugin you’ve mentioned?

    $optionslist = $wpdb->get_results( "SELECT * FROM $wpdb->options WHERE NOT option_name LIKE '\\_%' ORDER BY option_name" );

    That pulls down a list 🙂 So you’re going to be looking for SQL statements.

    Pull up some PHP/SQL tutorials and settle in for the long haul. http://www.freewebmasterhelp.com/tutorials/phpmysql

    Sjors01
    Member

    @sjors01

    Thanks for the course ipstenu!
    But there’s nothing wrong with the plugin, it works fine. Sorry for the misunderstanding. I did find the code you mentioned, in the plugin itself.

    The plugin gives you a list of options (the settings of your plugins) which you can replicate over all your multi site blogs, but I can’t find a few plugins options. Because the names are different. (the options don’t always show the exact name of the plugin)

    If you still don’t know what I mean you should install it and check it out, it’s a very useful plugin.

    I would like to replicate these plugin options as well, so I need to know the names of the settings (database tables?)

    How can I find this out?

    Andrea Rennick
    Moderator

    @andrea_r

    I would like to replicate these plugin options as well, so I need to know the names of the settings (database tables?)

    How can I find this out?

    then look in the code of those particular plugin’s files. they will all be different.

    There’s a paid plugin that does all this for ya though.

    Sjors01
    Member

    @sjors01

    Okay but can you give me an indication on how I could recognize this code? What’s the name of this paid plugin? Thanks

    http://wpebooks.com/replicator/ I think.

    And as for how you recognize the code… That’s why I showed you an example 🙂 Look for SQL statements.

    Sjors01
    Member

    @sjors01

    Okay, but that code appears in all plugins? I found it in the yd-wpmu-sitewide options plugin, but not in the plugin I wanted the know the database name for.

    Thanks for the link, will contact Andrea about it.:)

    The keyword in my sentence was “example” – Every plugin is different. You’ll have to use your brain and read them on your own.

    And I know that plugin works. Never used it, but I’ve never needed to.

    Sjors01
    Member

    @sjors01

    Andrea, I can’t pm you on these forums. And I can’t use the contact form on your website, so I’m going to ask my questions here:

    Will you have too identify database tables with your plugin? Can it replicate ALL plugin settings, without any problems? Does it automatically activate widgets? Can you save the plugin settings, to implement it to another wpms install?

    If this plugin fits my needs I will definitely buy it, and I might join your affiliate program for it.:)

    Andrea Rennick
    Moderator

    @andrea_r

    Why can’t you use the contact form? If it’s busted I need to fix it. 🙂 I’d rather answer questions there or on twitter.

    But: no, yes, yes and no.

    Sjors01
    Member

    @sjors01

    Please fix your contact form then, or I’ll use twitter but I never used it for personal use before, lol.

    Sjors01
    Member

    @sjors01

    I tweeted you!

    Andrea Rennick
    Moderator

    @andrea_r

    I’m gonna replace the contact form plugin I’m using. probably the worst one I ever tried.

    ydubois
    Participant

    @ydubois

    Hey! If you want to ask questions and get focused answers about my plugin, you’d better post on the official plugin community support page, as explained in the docs:

    http://www.yann.com/en/wp-plugins/yd-wpmu-sitewide-options

    I unfortunately have no time to actively monitor different forums.

    My plugin is free and will always remain so btw 😉

Viewing 15 replies - 1 through 15 (of 22 total)
  • The topic ‘How can I find out the names of database tables a plugin is using?’ is closed to new replies.