Need help creating my database

Discussion in 'MySQL' started by FPR, Feb 24, 2007.

  1. #1
    Hi All

    I own a poker affiliate site and was wanting to be able to offer my players rake back. For those that don't know, this means I will be paying my players a % of the income I have earned from their play.

    Of course I would like them to be able to log in to my website and check their account, to be able to see exactly how much they have earned.

    Obviously I need a database to set this up but I have absolutely no idea how to do it.

    I would also need a log in page that would enable them to see there own stats only but no one elses but again I wouldn't have a clue where to start.

    Can any one help me?

    Cheers
     
    FPR, Feb 24, 2007 IP
  2. minute

    minute Peon

    Messages:
    443
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #2
    you need a php/mysql coder and a way of getting their spend into the database in the first place. Ideally you would want to do this automatically. That's the interesting bit - after that it's pretty standard.

    I can't do it though, but just thought that would give you a bit more info.
     
    minute, Feb 24, 2007 IP
  3. LeopardAt1

    LeopardAt1 Well-Known Member

    Messages:
    880
    Likes Received:
    126
    Best Answers:
    0
    Trophy Points:
    135
    #3
    This sounds like a part db and part programming question to me.

    Hire a freelancer..but then you'll need to trust him to work w/you until you have your script for members working 100%

    Either that or you'll have to learn how to build this custom script yourself (will take you lots of hard work to get it efficient and secure).
     
    LeopardAt1, Feb 25, 2007 IP
  4. JEET

    JEET Notable Member

    Messages:
    3,832
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #4
    It's not just a DB creation, you also need to keep deleting older entries (ones you have paid), add new ones (ones pending), for every month/ payout time.

    DB creation, Login, adding entries at start are the easy part in the script. Payment calculation/tracking is the actual head scratcher...
     
    JEET, Feb 25, 2007 IP