daily pastebin goal
41%
SHARE
TWEET

Untitled

a guest Jan 29th, 2018 69 in 20 hours
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function onCampDayUp() {
  2.         try {
  3.             $dbquery = $this->pdo->prepare("UPDATE jumpers j JOIN oncamp o ON o.id_jumper = j.id_jumper SET j.oncamp = 0 WHERE o.day = 7");
  4.             $dbquery->execute();
  5.             $dbquery = $this->pdo->prepare("DELETE FROM oncamp WHERE day = 7");
  6.             $dbquery->execute();
  7.             $dbquery = $this->pdo->prepare("UPDATE oncamp SET day = day + 1");
  8.             $dbquery->execute();
  9.          
  10.         } catch (PDOException $e) {
  11.             error_log($e->getMessage());
  12.         }
  13.     }
RAW Paste Data
Pastebin PRO WINTER Special!
Get 40% OFF Pastebin PRO accounts!
Top