Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Database walk through

CaioCaio
edited April 2012 in Vanilla 2.0 - 2.8

I found something about databases here for the bbcode, can anyone walk me through this as I understand nothing about databases (other than to make them)? Also, please use the newest phpMyAdmin version.

Best Answer

  • peregrineperegrine MVP
    edited April 2012 Answer ✓

    In PhpMyadmin to view the column format in the

    GDN_Discussion

    click on the vanilla database.
    then click on GDN_Discussion
    then click on browse.
    it will show you the whole table.

    you could go in to sql (top center button) click it and enter your command.
    e.g. view a single column for the firs 500 entries.

    SELECT Format FROM GDN_Discussion Limit 500;

    I believe there is a phpmyadmin

    tutorial

    looked like a video and a bunch of sites.

    the best way to learn is create a databases and play with the command.
    The update command would change things.
    But you better back up your database before you play with the live vanilla (there is an export button).

    I suggest you read the tutorial
    http://www.w3schools.com/sql/default.asp

    http://vanillawiki.homebrewforums.net/index.php/Database_&_Query_Building

    http://vanillawiki.homebrewforums.net/index.php/Database_Objects

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Answers

  • peregrineperegrine MVP
    edited April 2012

    what do you want to know? :) That's a pretty broad question.

    http://www.w3schools.com/sql/default.asp

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • CaioCaio
    edited April 2012

    Todd states something about changing the values in GDN_Discussion and GDN_Comments to "BBCode", I was wondering how to do that with phpMyAdmin, because I can't find the values. (It's Todd's 2nd comment, part 2)

  • CaioCaio
    edited April 2012

    peregrine said:
    That's a pretty broad question.

    Lol, I'm still working on being more descriptive

  • peregrineperegrine MVP
    edited April 2012 Answer ✓

    In PhpMyadmin to view the column format in the

    GDN_Discussion

    click on the vanilla database.
    then click on GDN_Discussion
    then click on browse.
    it will show you the whole table.

    you could go in to sql (top center button) click it and enter your command.
    e.g. view a single column for the firs 500 entries.

    SELECT Format FROM GDN_Discussion Limit 500;

    I believe there is a phpmyadmin

    tutorial

    looked like a video and a bunch of sites.

    the best way to learn is create a databases and play with the command.
    The update command would change things.
    But you better back up your database before you play with the live vanilla (there is an export button).

    I suggest you read the tutorial
    http://www.w3schools.com/sql/default.asp

    http://vanillawiki.homebrewforums.net/index.php/Database_&_Query_Building

    http://vanillawiki.homebrewforums.net/index.php/Database_Objects

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Sign In or Register to comment.