function update() { if ($this->enabled == 1) { if (isset($_COOKIE['hfh_disable_counter'])) { return; } global $db; global $login; $ip = getRemoteAdr(); $dur = $this->duration; /* Update usage stat */ $sql = "SELECT * FROM `" . $this->table . "` WHERE `userid`=" . $login->currentUserID() . " OR `ipadress`='" . $ip . "' ORDER BY `timestamp` DESC LIMIT 1;"; $res = $db->query($sql); $r = mysql_fetch_assoc($res); if ($r['last_action'] + $dur < time()) { $sql = "INSERT INTO `" . $this->table . "`\r\n\t\t\t\t\t\t\t(`userid`, `timestamp`, `last_action`, `ipadress`, `referer`, `browseragent`, `os`)\r\n\t\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t\t(" . $login->currentUserID() . ", " . time() . ", " . time() . ", '" . $ip . "', '" . $this->getUserReferer() . "', '" . $this->getUserAgent() . "', '" . $this->getUserOS() . "');"; } else { $sql = "UPDATE `" . $this->table . "` SET `duration`=" . (time() - $r['timestamp']) . ", `last_action`=" . time() . ", `userid`=" . $login->currentUserID() . " WHERE `timestamp`=" . $r['timestamp'] . " AND `ipadress`='" . $ip . "';"; } $db->query($sql); } }
break; } } default: if (isVisible($categoryid)) { $showcategories = true; if ($downloadid > 0) { $dl = getDownload($downloadid); if (isset($_POST['download'])) { increaseDownloadCounter($downloadid); $dl['counter']++; $addr = trim($config->get('media', 'mail-notification-address')); if ($addr != '') { $text = '<p><strong><a href="' . getSelfURL() . '/' . makeURL($mod, array('categoryid' => $categoryid, 'downloadid' => $downloadid)) . '">' . $dl['name'] . '</a></strong></p>'; $text .= '<p>' . $lang->get('timestamp') . ': ' . date('d.m.Y H:i') . '</p>'; $text .= '<p>IP: ' . getRemoteAdr() . '</p>'; $me = $login->currentUser(); if (null != $me) { $text .= '<p>UserID: ' . $me['userid'] . '</p>'; $text .= '<p>' . $lang->get('nickname') . ': ' . $me['nickname'] . '</p>'; $text .= '<p>' . $lang->get('email') . ': ' . $me['email'] . '</p>'; } $eMail->send($lang->get('download_notification'), $text, $addr); } } if ($login->currentUser() !== false) { $smarty->assign('loggedin', true); if (isset($_POST['add'])) { $comments->add($mod, $login->currentUserID(), $_POST['comment'], $downloadid); } }
$all_filled = false; } } $smarty->assign('submit', $submit); if (!$all_filled) { $notify->add($lang->get('form'), $lang->get('required_descr')); } else { $content = '<p style="size:1.3em;"><strong><u>' . $form['title'] . '</u></strong></p>'; foreach ($form['elements'] as $element) { if ($element['type'] > 1) { $content .= '<p><strong>' . $element['title'] . '</strong>:<br />' . $submit[$element['elementid']] . '</p>'; } } switch ($form['action']) { case 'store': $db->insert('formmaker_data', array('formid', 'timestamp', 'ipaddress', 'content'), array($form['formid'], time(), "'" . getRemoteAdr() . "'", "'" . $content . "'")); $notify->add($lang->get('form'), $form['submit_message']); $smarty->assign('submitted', true); break; case 'mail': $addresses = explode(';', $form['address']); $subject = $lang->get('form') . ': ' . $form['title']; foreach ($addresses as $addr) { if (trim($addr) != '') { $eMail->send($subject, $content, trim($addr)); } } $notify->add($lang->get('form'), $form['submit_message']); $smarty->assign('submitted', true); break; }
$smarty->assign('isallowed', $isallowed); $smarty->assign('path', $template_dir . "/default.tpl"); $usr = $login->currentUser(); if ($usr !== false) { $smarty->assign('nickname', $usr['nickname']); } if (isset($_POST['delete']) && $isallowed) { $db->delete($tbl, "`guestbookid`=" . (int) $_POST['guestbookid']); $notify->add($lang->get('guestbook'), $lang->get('deleted')); } if (isset($_POST['add']) && $_POST['email'] == '') { if (trim($_POST['author']) == '' || trim($_POST['message']) == '') { $notify->add($lang->get('guestbook'), $lang->get('fill_all')); } else { if ($ip_blocker_enabled == 1 && $db->num_rows($tbl, "`ipadress`='" . getRemoteAdr() . "' AND `timestamp`>" . (time() - $ip_blocker_limit)) == 0 || $ip_blocker_enabled == 0) { $db->insert($tbl, array('timestamp', 'author', 'message', 'ipadress'), array(time(), "'" . $_POST['author'] . "'", "'" . strip_tags($_POST['message']) . "'", "'" . getRemoteAdr() . "'")); } else { $notify->add($lang->get('guestbook'), $lang->get('ip-blocker')); } } } $messageCount = $db->num_rows($tbl, "1"); $messagesPerPage = $config->get($mod, 'entries-per-page'); @$pages->setValues((int) $_GET['page'], $messagesPerPage, $messageCount); $list = $db->selectList($tbl, "*", "1", "`timestamp` DESC", $pages->currentValue() . ", " . (int) $messagesPerPage); if (count($list) > 0) { foreach ($list as $i => $l) { $list[$i]['time'] = timeElapsed($l['timestamp']); $list[$i]['message'] = $bbcode->parse($l['message']); } }
$u = $login->currentUser(); $makeMeMaster = false; $db->delete('tetris_player', "`nickname`='" . $u['nickname'] . "'"); if ($u) { $nick = $u['nickname']; if ($rights->isAllowed('tetris', 'admin', $u['userid'])) { $makeMeMaster = true; } } else { $nick = "Player" . rand(0, 999); } if ($db->num_rows(MYSQL_TABLE_PREFIX . 'tetris_player', "`master`>0") == 0) { $master = 1; } else { $master = 0; } if ($makeMeMaster) { $master = 2; } $uniquid = uniqid(); $db->insert(MYSQL_TABLE_PREFIX . 'tetris_player', array("nickname", "ipadress", "last_action", "last_real_action", "master", "uniquid"), array("'" . $nick . "'", "'" . getRemoteAdr() . "'", time(), time(), $master, "'" . $uniquid . "'")); $field = array(); for ($y = 0; $y < 19; $y++) { for ($x = 0; $x < 10; $x++) { $field[$y][$x] = $x . "_" . $y; } } $smarty->assign('uniquid', $uniquid); $smarty->assign('nick', urlencode($nick)); $smarty->assign('field', $field); $smarty->assign('path', $template_dir . "/tetris.tpl");
function updateLastSeen() { $sql = "UPDATE `" . $this->user->table . "`\r\n\t\t\t\t\tSET `lastaction`=" . time() . ", `session_id`='" . session_id() . "', `ipadress`='" . getRemoteAdr() . "'\r\n\t\t\t\t\tWHERE `userid`=" . (int) $this->cUser['userid'] . ";"; $this->db->query($sql); }