function checkAction($chkVal) { $w = "chkVal='" . $chkVal . "'"; if (isset($_SESSION['config']) && $_SESSION['config']->CURRENTUSER->USERID != null) { $w .= " and user_id=" . $_SESSION['config']->CURRENTUSER->USERID; } $dbTblTest = new DbTable($_SESSION['config']->DBCONNECT, "chkActions", array("*"), "", "", "id desc", $w); if ($dbTblTest->getRowCount() > 0) { $r = $dbTblTest->getRow(1); if ($r->getNamedAttribute("chkVal") == $chkVal) { return false; } } $r = $dbTblTest->createRow(); $r->setNamedAttribute("user_id", $_SESSION['config']->CURRENTUSER->USERID); $r->setNamedAttribute("chkVal", $chkVal); $r->insertIntoDB(); return true; }
function addFriendRequest($userId, $friendId) { $dbTblFriends = new DbTable($_SESSION['config']->DBCONNECT, "freundesliste", array("user_id", "friend_id", "accepted"), "", "accepted = 'N'", "", "user_id=" . $userId . " AND friend_id=" . $friendId); if ($dbTblFriends->getRowCount() > 0) { echo "Dieser Benutzer ist bereits in Ihrer Freundesliste, oder Sie haben bereits eine Anfrage gestellt."; return; } $dbRowNewFriend = $dbTblFriends->createRow(); $dbRowNewFriend->setNamedAttribute("user_id", $userId); $dbRowNewFriend->setNamedAttribute("friend_id", $friendId); $dbRowNewFriend->setNamedAttribute("accepted", "N"); $dbRowNewFriend->insertIntoDB(); echo "Freundesanfrage gesendet"; }
function checkSwitch() { if (isset($_REQUEST['schalte']) && $_REQUEST['schalte'] != 0) { $dbActionLog = new DbTable($_SESSION['config']->DBCONNECT, "action_log", array("sessionid", "userid", "zeit"), "Session, Benutzer, Timestamp", "", "geaendert desc", "sessionid='?schalte=" . $_REQUEST['schalte'] . "'" . (strlen($_REQUEST['dimmer']) > 0 ? "-" . $_REQUEST['dimmer'] : "") . (strlen($_REQUEST['tmstmp']) > 0 ? " AND zeit=" . $_REQUEST['tmstmp'] : "")); if (count($dbActionLog->ROWS) == 0) { if (strlen($_REQUEST['tmstmp']) <= 0) { $_REQUEST['tmstmp'] = time(); } $actionLogRow = $dbActionLog->createRow(); $actionLogRow->setNamedAttribute("sessionid", "?schalte=" . $_REQUEST['schalte']); $actionLogRow->setNamedAttribute("userid", $_SESSION['config']->CURRENTUSER->USERID); $actionLogRow->setNamedAttribute("zeit", $_REQUEST['tmstmp']); $actionLogRow->insertIntoDB(); //echo "Dimmer: ".$_REQUEST['dimmer']; $dayInMillis = 86400000; $dbActionLog->setWhere("zeit is null or zeit < " . ($_REQUEST['tmstmp'] - $dayInMillis)); $dbActionLog->refresh(); foreach ($dbActionLog->ROWS as $r) { $r->deleteFromDb(); } $this->switchObject($_REQUEST['schalte'] > 0 ? $_REQUEST['schalte'] : -$_REQUEST['schalte'], $_REQUEST['schalte'] > 0 ? "on" : "off", $_REQUEST['dimmer']); } } }