points

Discussion in 'PHP' started by gunmetal, Oct 24, 2010.

0
  1. #1
    Hi
    I make site and i need the code who each user give +points every minute
    every user can be diferent +points

    I think that it is "CREATE EVENT pointer ON SCHEDULE EVERY 1 MINUTE DO UPDATE members SET point=point+1;"

    But it isn't work. :(

    Sory for my English i am from Latvia
    But pleas help me
     
    gunmetal, Oct 24, 2010 IP
  2. ThePHPMaster

    ThePHPMaster Well-Known Member

    Messages:
    737
    Likes Received:
    52
    Best Answers:
    33
    Trophy Points:
    150
    #2
    The syntax is correct, do you have valid MySQL permissions to create events?
     
    ThePHPMaster, Oct 24, 2010 IP
  3. gunmetal

    gunmetal Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I don't know! how can i know that?
     
    gunmetal, Oct 24, 2010 IP
  4. gunmetal

    gunmetal Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Pleas some one help me ;(
     
    gunmetal, Oct 24, 2010 IP
  5. ThePHPMaster

    ThePHPMaster Well-Known Member

    Messages:
    737
    Likes Received:
    52
    Best Answers:
    33
    Trophy Points:
    150
    #5
    Run this query to see the permissions:

    
SHOW GRANTS FOR 'root'@'localhost';
    PHP:
     
    ThePHPMaster, Nov 7, 2010 IP