<?php if (isset($_REQUEST['action'])) { if ($_REQUEST['action'] == 'active') { query("UPDATE tbl_video SET video_status='inactive' WHERE video_id='" . $_REQUEST['video_id'] . "'"); } if ($_REQUEST['action'] == 'inactive') { query("UPDATE tbl_video SET video_status='active' WHERE video_id='" . $_REQUEST['video_id'] . "'"); } if ($_REQUEST['action'] == 'delete') { query_delete('tbl_video', "video_id='" . $_REQUEST['video_id'] . "'"); echo "<script language='javascript'> window.location='video.php'; </script>"; exit; } } $sql = query("SELECT * FROM tbl_video ORDER BY video_id DESC"); $count = query_rows($sql);
<?php require 'framework/framework.php'; mysql_connect('omega.db', 'livereload', 'TdDmCHrUhYV4qKrN'); mysql_select_db('livereload'); if ($_GET['pw'] != '3141jopa') { die("Access denied."); } header("Content-type: text/csv"); $rows = query_rows("SELECT date, ip, email FROM subscriptions"); foreach ($rows as $row) { // echo "{$row->date}\t{$row->ip}\t{$row->email}\n"; echo "{$row->email}\n"; }
if ($_REQUEST['type'] == 'manufactures') { $image = $_REQUEST['image']; $data['manufacturers_image'] = ''; query_update('tbl_manufacturers', $data, "manufacturers_id='" . $_REQUEST['id'] . "'"); @unlink('../uploads/manufactures/' . $image); } if ($_REQUEST['type'] == 'category_admindropdown') { ?> <?php $catId = $_GET['catId']; ?> <?php $subcategory = query("SELECT category_id, category_name FROM tbl_category WHERE category_level='2' AND category_status='active' AND category_parent_id='{$catId}' ORDER BY category_name ASC"); ?> <?php if (query_rows($subcategory) > 0) { ?> <select name="subcategory" id="subcategory" > <option value=""> Choose one </option> <?php while ($rowcategory = fetch_array($subcategory)) { ?> <option value="<?php echo $rowcategory['category_id']; ?> "><?php echo $rowcategory['category_name']; ?> </option> <?php }
function stats_before($time) { return query_rows("SELECT ip,\n FROM_UNIXTIME(MIN(time)) start,\n FROM_UNIXTIME(MAX(time)) end,\n (MAX(time)-MIN(time))/(60*60*24) AS active_period,\n ({$time}-MAX(time))/(60*60*24) AS inactive_period,\n ({$time}-MIN(time))/(60*60*24) AS age\n FROM `stats`\n WHERE time <= {$time}\n GROUP BY ip\n ORDER BY active_period DESC"); }