+ Reply to Thread (include dating software, release, and patch number!)
Results 1 to 7 of 7

Thread: Database Layout

  1. #1
    Prinel01
    Guest

    Cool Database Layout

    I am a newbie to Dolphin. I have create new fields which I want when a new user join.

    I assume Dolphin store all these type of info in a MySql database. Can anyone tell me how to get the layout of the db's - what db is used for what info etc?

    I want to query the db i.e. looking for all members who sex is male.

    Thanks

  2. #2
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,642
    Blog Entries
    5

    Default

    The users gender (sex) is stored in the Profiles table, in the database.

    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  3. #3
    Prinel01
    Guest

    Smile database layout

    Thanks for your reply... seems to me at last I did get someone on the DB side of Dolphin!

    Is there a doc available explain the db layouts.
    What happen to the custom fields I create?
    can I use a util like PhPAdmin to work on the db's?

    I want to use the db's to create custom reports - but again - is the data in MySql, and layout.

    Thanks again - I hope I get somewhere!!

  4. #4
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,642
    Blog Entries
    5

    Default

    Sure - use PhpMydmin - and take a look around - I think you will be able to figure out most of it pretty fast... like, the "Messages" table store the messages... the "Transactions" table stores the payment transactions, and so on.

    I don't think there is anything to replace spending the time looking at the different tables and fields - you have to study to understand - this is true with anything.

    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  5. #5
    Prinel01
    Guest

    Smile let's give it a go

    Thanks - I will - and yes - you are right ... as with db's always ... dig deep... I was hoping there is some sort of doc availbale as starter to pint you. is there a specific table for custom fields I add, or will that be as well ???

  6. #6
    bigal0228's Avatar
    Join Date
    Sep 2007
    Posts
    409
    Blog Entries
    1

    Default If all else fails...

    Look at the actual page code for the pages you are making changes to, in that code will be references to the database tables they update and refer from, so you can then look at the associated tables to find your items there.

    There isn't any type of document for Dolphin Database design. It's a learn as you go type of operation, so looking at a lot of lines of code is in your future unless you have someone do the work for you.

    Also, you need to be aware that some items are stored in cache files in your /inc/dbcache folder. These files get updated from your database and stored there.
    If at first you don't succeed, go to a forum and ask like hell. (Using Joomla 1.5.18, JomSocial 1.6.12, Fully Customized)
    <div>

<a href="http://www.fancamtastic.com/?idAff=5"><img src="http://www.fancamtastic.com/media/images/banners/Banner6.gif" width="445" height="49" border="0"></a><br />
<a href="http://www.fancamtastic.com/?idAff=5"></a>

</div>

  7. #7
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,642
    Blog Entries
    5

    Default

    Quote Originally Posted by Prinel01 View Post
    Thanks - I will - and yes - you are right ... as with db's always ... dig deep... I was hoping there is some sort of doc availbale as starter to pint you. is there a specific table for custom fields I add, or will that be as well ???
    A good read is the .sql file in the /install folder's.

    Smoge
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

+ Reply to Thread (include dating software, release, and patch number!)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Similar Threads

  1. Orca Forum layout
    By sairah in forum General Troubleshooting
    Replies: 0
    Last Post: 05-28-2010, 11:10 PM
  2. Need help with layout
    By MuckSpace in forum Boonex Dolphin 7
    Replies: 3
    Last Post: 12-11-2009, 09:39 AM
  3. Article Layout
    By ginger76 in forum Dolphin General Discussion v6.00 and above
    Replies: 3
    Last Post: 02-12-2008, 02:39 PM
  4. css layout alterations
    By claritydigital in forum Graphics / Templates
    Replies: 3
    Last Post: 10-12-2007, 08:12 AM
  5. How to edit the layout of the profile/site?
    By djyox in forum General Issues, Comments, Questions
    Replies: 1
    Last Post: 11-14-2006, 02:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts