WordPress.org

Ready to get started?Download WordPress

Forums

Multisite Language Switcher
[resolved] Are relations stored in DB and if so, which table? (7 posts)

  1. JpFayolle
    Member
    Posted 1 year ago #

    Hello,

    I am currently migrating my blog from Qtranslate to a multisite new installation, that is located under a subdomain dev.example.com corresponding to a sub-directory public_htmel/dev, with 3 sites dev/fr/, dev/en/, dev/es.

    I have installed the plugin and began to migrate posts so that each post is like: dev/example.com/fr/mypost that links to dev/example.com/en/mypost and dev/example.com/fr/mypost.

    When the migration will be completed, I will have to copy dev/ directly to public_html so that the previous links will become example.com/fr/mypost & /example.com/en/mypost & /example.com/fr/mypost.

    My question is: are these url stored into the DB and if so, in which table?

    I suppose I will have to make an update of the DB to keep the relations correct, no?

    Do not hesitate to ask for further precisions.
    Regards
    JP

    http://wordpress.org/extend/plugins/multisite-language-switcher/

  2. realloc
    Member
    Plugin Author

    Posted 1 year ago #

    This should be no problem. All relations are stored in {$wpdb->options}.

  3. JpFayolle
    Member
    Posted 1 year ago #

    Ok.
    To be sure I understand correctly, I see 3 wp_x_options tables in the DB each one with a record 'option_name' = 'siteurl' and 'option_value' = the url of each site (dev.example.com/fr, etc).

    So I just have to update this url for this record in each 3 wp_options tables and the relations will be Ok.
    I mean, the relations are based on the url and there is not a record for each relation.

    Is that correct?
    JP

  4. realloc
    Member
    Plugin Author

    Posted 1 year ago #

    No, there are not just these entries. There are (a lot of) msls_%-entries in these tables. If I remember well, you'll have all these relations in the xml-files, if you decide to use the export-functionality.

  5. lexxlevi
    Member
    Posted 1 year ago #

    hi all, hi realloc

    great plugin!

    I ´m not so good to handle with data tables. is there any other possibility to get an direct relation between for example three language- buttons EN, DE, CN? maybe with a function?

    this would be great!

  6. realloc
    Member
    Plugin Author

    Posted 1 year ago #

    @lexxlevi You don't have to handle those relations in that way. You can use the widget or a few lines of code. Read on here: https://github.com/lloc/Multisite-Language-Switcher/wiki

  7. lexxlevi
    Member
    Posted 1 year ago #

    ooooooooooopps sorry I didn´t seen that

    Thank you, that is wonderful!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic