source: extensions/lightbox/save_history.php @ 11516

Last change on this file since 11516 was 5734, checked in by patdenice, 14 years ago

Update jQuery to 1.4.2 and colorbox to 1.3.6.
Increase column hit in images table when viewing picture.

File size: 1.5 KB
Line 
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    lightbox
62  )
63  VALUES
64  (
65    CURDATE(),
66    CURTIME(),
67    '.$user['id'].',
68    \''.$_SERVER['REMOTE_ADDR'].'\',
69    '.(isset($page['section']) ? "'".$page['section']."'" : 'NULL').',
70    '.(isset($page['category']['id']) ? $page['category']['id'] : 'NULL').',
71    '.$image_id.',
72    "picture",
73    '.(isset($tags_string) ? "'".$tags_string."'" : 'NULL').',
74    "true"
75  )
76;';
77
78pwg_query($query);
79
80?>
Note: See TracBrowser for help on using the repository browser.