Advertisement
Guest User

gift function

a guest
Feb 20th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. public function setGift()
  2. {
  3. $db = Environment::getDatabase();
  4. $error = "Je hebt vandaag al je cadeau gekregen!";
  5.  
  6.  
  7. if(isset($_POST['submit_gift']))
  8. {
  9. $query = $db->query("SELECT * FROM gifts WHERE user_id = '". intval($this->_id) . "'AND date = '" . date("d-m-Y") . "' LIMIT 1");
  10.  
  11. if(mysqli_num_rows($query) != 0)
  12. {
  13. return $error;
  14. } else {
  15.  
  16. Util::Gift();
  17.  
  18. $db->query("INSERT INTO gifts (user_id,date) VALUES ('". intval($this->_id)"', '" . date("d-m-Y") ."' )");
  19. $db->query("UPDATE users SET $gift = $gift + $value WHERE id = '". intval($this->_id)"' LIMIT 1") or die(Environment::getDatabase()->error);
  20. }
  21.  
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement