WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Explain these DB values (4 posts)

  1. ThorHammer
    Member
    Posted 1 year ago #

    I run a multisite and believe some uninstalled plugins are messing up my users roles. The code beneath is from "user_roles" under a blogs OPTIONS table.
    I understand that this is the settings for what the user roles on this blog is, but what on earth does: "a:x" "b:x" "s:x" mean??
    (This "user_roles" value contains 6497 letters...)

    a:10:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:65:{s:13:"switch_themes";b:1;s:11:"edit_themes";b:1;s:16:"activate_plugins";b:1;s:12:"edit_plugins";b:1;s:10:"edit_users";b:1;s:10:"edit_files";b:1;s:14:"manage_options";b:1;s:17:"moderate_comments"; ... etc. etc.

    And some of these data MUST be remains from my uninstalled buddypress?:
    s:10:"Key Master";s:12:"capabilities";a:37:{s:8:"use_keys";b:1;s:12:"administrate";b:1;s:8:"moderate";b:1;s:11:"participate";b:1;s:9:"keep_gate";b:1;s:13:"import_export";b:1;s:7:"recount";b:1;s:14:"manage_options";b:1;s:13:"manage_themes";b:1;s:14:"manage_plugins";b:1;s:10:"edit_users";b:1;s:11:"manage_tags";b:1;s:21:"edit_others_favorites";b:1;s:13:"manage_forums";b:1;s:13:"delete_forums";b:1;s:13:"delete_topics";b:1;s:12:"close_topics";b:1;s:12:"stick_topics";b:1;s:11:"move_topics";b:1;s:10:"view_by_ip";b:1;s:11:"edit_closed"; etc. etc.

  2. Chris
    Member
    Posted 1 year ago #

    You're looking at serialized strings of data. You can unserialize them with PHP and take a look at them in a human readable form, so to speak. But the string you're transforming has to be complete (with all the "etc etc" stuff)

    $unserializedData = ( unserialize( $theStringYourTalkingAbout );
    var_dump( $$unserializedData );
  3. ThorHammer
    Member
    Posted 1 year ago #

    Thank you so much!

    Now I am really excited to see what this novel is all about :-)

  4. ThorHammer
    Member
    Posted 1 year ago #

    ... huge loads of buddypress settings is inside all user_roles settings in all my OPTIONS tables...

Topic Closed

This topic has been closed to new replies.

About this Topic