source: extensions/stripped-galleria/save_history.php @ 20729

Last change on this file since 20729 was 13089, checked in by Zaphod, 13 years ago

version 1.3.0

File size: 1.5 KB
RevLine 
[13089]1<?php
2
3define('PHPWG_ROOT_PATH','../../');
4include_once(PHPWG_ROOT_PATH.'include/common.inc.php');
5include_once(PHPWG_ROOT_PATH.'include/functions_picture.inc.php');
6
7check_status(ACCESS_GUEST);
8
9if (!isset($_POST['imgid'])
10  or !($imgid = explode('img-', $_POST['imgid']))
11  or !is_numeric(@$imgid[1]))
12{
13  die;
14}
15
16$image_id = mysql_real_escape_string($imgid[1]);
17
18$query = 'UPDATE '.IMAGES_TABLE.' SET hit=hit+1 WHERE id = '.$image_id.';';
19pwg_query($query);
20
21$do_log = $conf['log'];
22if (is_admin())
23{
24  $do_log = $conf['history_admin'];
25}
26if (is_a_guest())
27{
28  $do_log = $conf['history_guest'];
29}
30
31if (!$do_log)
32{
33  exit();
34}
35
36if (!empty($_POST['section']))
37{
38  $page['section'] = mysql_real_escape_string($_POST['section']);
39}
40if (!empty($_POST['catid']))
41{
42  $page['category']['id'] = mysql_real_escape_string($_POST['catid']);
43}
44if ('tags'==@$page['section'] and !empty($_POST['tagids']))
45{
46  $tags_string = mysql_real_escape_string($_POST['tagids']);
47}
48
49  $query = '
50INSERT INTO '.HISTORY_TABLE.'
51  (
52    date,
53    time,
54    user_id,
55    IP,
56    section,
57    category_id,
58    image_id,
59    image_type,
60    tag_ids
61  )
62  VALUES
63  (
64    CURDATE(),
65    CURTIME(),
66    '.$user['id'].',
67    \''.$_SERVER['REMOTE_ADDR'].'\',
68    '.(isset($page['section']) ? "'".$page['section']."'" : 'NULL').',
69    '.(isset($page['category']['id']) ? $page['category']['id'] : 'NULL').',
70    '.$image_id.',
71    "picture",
72    '.(isset($tags_string) ? "'".$tags_string."'" : 'NULL').'
73  )
74;';
75
76pwg_query($query);
77
78?>
Note: See TracBrowser for help on using the repository browser.