ProShell v2.0
Dashboard
Server Info
Server: 158.106.128.192
PHP: 8.2.33
home
planet5
public_html
bansibaba.com
2026-09-12 15:24:51
Editing: AffClick.php
Cancel
Save Changes
<?php /** * Class represents records from table aff_clicks * {autogenerated} * @property int $log_id * @property int $aff_id * @property int $banner_id * @property datetime $time * @property string $url * @property string $remote_addr * @property string $referer * @see Am_Table */ class AffClick extends Am_Record { } class AffClickTable extends Am_Table { protected $_key = 'log_id'; protected $_table = '?_aff_click'; protected $_recordClass = 'AffClick'; public function insert(array $values, $returnInserted = false) { if (empty($values['time'])) $values['time'] = $this->getDi()->sqlDateTime; return parent::insert($values, $returnInserted); } function log(User $aff, AffBanner $banner = null) { $this->_db->query("INSERT INTO ?_aff_click SET aff_id=?d, time=?, banner_id=?d, remote_addr=?, referer=? ", $aff->pk(), $this->getDi()->sqlDateTime, $banner ? $banner->pk() : null, $_SERVER['REMOTE_ADDR'], $_SERVER['HTTP_REFERER'] ); return $this->_db->selectCell("SELECT LAST_INSERT_ID()"); } function fetchByDate($date, $aff_id=null) { return $this->selectObjects( "SELECT * FROM ?_aff_click WHERE time BETWEEN ? AND ? { AND aff_id=?d}", date('Y-m-d 00:00:00', amstrtotime($date)), date('Y-m-d 23:59:59', amstrtotime($date)), $aff_id === null ? DBSIMPLE_SKIP : $aff_id); } /** * Find affililate by IP address if cookie is empty * @param type $ip * @return last aff_id in record with matching IP */ function findAffIdByIp($ip) { $startTm = sqlTime($this->getDi()->time - $this->getDi()->config->get('aff.cookie_lifetime', 365) * 24 * 3600); return $this->_db->selectCell("SELECT CONCAT(aff_id, '-', IFNULL(banner_id, '')) FROM $this->_table WHERE time >= ? AND remote_addr=? AND aff_id>0 ORDER BY time DESC LIMIT 1", $startTm, $ip); } }
Upload Files
Cancel
Upload
Create New
Cancel
Create
Change Permissions
Cancel
Save
Change Date
Cancel
Save
Rename Item
Cancel
Save
Confirm Delete
Are you sure you want to delete the selected items?
Cancel
Delete