Phpbb Board Db And Prefix

Discussion in 'Integration' started by lacentrix, Sep 2, 2003.

  1. lacentrix

    lacentrix Guest

    ok, im clueless as to waht im suppose to put here,. ive tried numerous things. my database is names phpdb and im using mysql on a NT server

    any help appreciated

    Myke
  2. pilot

    pilot New Member

    Joined:
    May 24, 2003
    Messages:
    178
    Do you mean you are trying to connect to your mysql ?

    You will need

    database name = name_you_gave_db
    database password = your_password
    database server = usually is localhost ( could be different for nt server )

    if you are trying to configure your phpBB2 plugin you will need these
  3. lacentrix

    lacentrix Guest

    i have all that info, im just stuck on the plugin config for phpbb im not sure waht to enter into the field box for it within amember, it calls for an example like phpbb.w3t_

    Myke
  4. pilot

    pilot New Member

    Joined:
    May 24, 2003
    Messages:
    178
    You put in your database name in there plus any prefixes you may have :

    So if you have a name for your database called mydatabasedb
    you could have a prefix in your fields like phpBB_

    so you put in mydatabasedb.phpBB_

    and press the button twice.
  5. lacentrix

    lacentrix Guest

    im still confused, where do i find my prefix at?


    i think im getting in wayyy over my head here

    Myke
  6. pilot

    pilot New Member

    Joined:
    May 24, 2003
    Messages:
    178
    If you need some help here, and you have purchased AmemberPro and the phpBB plugin, do'nt worry email Alex at support. He will help you.

    The prefix is how your database fields have been named, you can see this if you use a program like phpMyAdmin

    Your database will have a name = databasenamedb

    then the fields of the database will have names like
    phpBB_users the phBB_ is the prefix
  7. alex-adm

    alex-adm Guest

    Yes, Myke, feel free to ask us : support@cgi-central.net

    Try to set it to
    YOUR_PHPBB_DATABASE.phpbb_
  8. Epsilon

    Epsilon Guest

    lacentrix, you don't 'find' the prefix anywhere. You can make up your own prefix. The only important thing is that you specify the exact same prefix in both your PHPBB configuration and your aMember PHPBB plugin settings.

    The reason you need prefixes is because different programs sharing the same database might try to write to the same table. For example, both aMember and PHPBB have tables named 'config'. You can imagine the problems if both of them tried to write their own data to the same table (Anarchy! :eek: ). But with the prefixes added you have tables named 'amember_config' and 'phpbb_config', and you have no problems because they are completely separate within the same database.

    That being said, the default prefix for PHPBB tables is 'phpbb_', and there's really no reason to change it. Then let's assume the name of the database where you're keeping all this info is 'mykesdb'. In the PHPBB config section within aMember, you would type 'mykesdb.phpbb_' (without the quotes, of course) and all should work fine.

    I actually have aMember Pro, PHPBB, Voodoo Chat, and custom fields, with the respective prefixes amember_, phpbb_, voc_, and mycust_ all running nicely within one database.

Share This Page