function cpgUserLastComment($uid) { global $CONFIG; $result = cpg_db_query("SELECT count(*), MAX(msg_id) FROM {$CONFIG['TABLE_COMMENTS']} as c, {$CONFIG['TABLE_PICTURES']} as p WHERE c.pid = p.pid AND approval='YES' AND author_id = '{$uid}' {$FORBIDDEN_SET}"); $nbEnr = mysql_fetch_array($result); $comment_count = $nbEnr[0]; $lastcom_id = $nbEnr[1]; mysql_free_result($result); $lastcom = ''; if ($comment_count) { $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight, msg_author, UNIX_TIMESTAMP(msg_date) as msg_date, msg_body, approval " . "FROM {$CONFIG['TABLE_COMMENTS']} AS c, {$CONFIG['TABLE_PICTURES']} AS p " . "WHERE msg_id='" . $lastcom_id . "' AND approval = 'YES' AND c.pid = p.pid"; $result = cpg_db_query($sql); if (mysql_num_rows($result)) { $row = mysql_fetch_array($result); mysql_free_result($result); $pic_url = get_pic_url($row, 'thumb'); if (!is_image($row['filename'])) { $image_info = cpg_getimagesize(urldecode($pic_url)); $row['pwidth'] = $image_info[0]; $row['pheight'] = $image_info[1]; } $image_size = compute_img_size($row['pwidth'], $row['pheight'], $CONFIG['thumb_width']); $mime_content = cpg_get_type($row['filename']); $lastcom = '<img src="' . $pic_url . '" class="image"' . $image_size['geom'] . ' border="0" alt="" />'; } } $lastComArray = array(); $lastComArray['thumb'] = $lastcom; $lastComArray['comment'] = $row['msg_body']; $lastComArray['msg_date'] = $row['msg_date']; $lastComArray['count'] = $comment_count; return $lastComArray; }
function quick_tag_page_html($html) { global $CONFIG; $num_keywords = 10; $keywords_array = array(); $keyword_count = array(); $result = cpg_db_query("SELECT keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> ''"); if (mysql_num_rows($result)) { while (list($keywords) = mysql_fetch_row($result)) { $array = explode($CONFIG['keyword_separator'], html_entity_decode($keywords)); foreach ($array as $word) { if (!trim($word)) { continue; } if (!in_array($word = utf_strtolower($word), $keywords_array)) { $keywords_array[] = $word; $keyword_count[$word] = 1; } else { $keyword_count[$word]++; } } } arsort($keyword_count); } $i = 0; $buttons = ''; foreach ($keyword_count as $keyword => $count) { if ($i++ >= $num_keywords) { break; } $buttons .= "<span class=\"admin_menu\" style=\"white-space: nowrap;\" onclick=\"jQuery('#keywords\\1').focus(); jQuery('#keywords\\1').val(jQuery('#keywords\\1').val() + '{$CONFIG['keyword_separator']}{$keyword}{$CONFIG['keyword_separator']}');\">{$keyword}</span> "; } $html = preg_replace('/<input type="text" style="width: 100%" name="keywords([0-9]+)?".* \\/>/U', "\\0<p></p>" . $buttons, $html); return $html; }
function album_share_codes_main() { $superCage = Inspekt::makeSuperCage(); if ($superCage->get->testInt('album')) { global $CONFIG; $aid = $superCage->get->getInt('album'); $result = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '{$aid}'"); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $url = $CONFIG['ecards_more_pic_target'] . 'displayimage.php?pid=' . $row['pid']; $thumb = $CONFIG['ecards_more_pic_target'] . get_pic_url($row, 'thumb'); $content1 .= '[url=' . $url . '][img]' . $thumb . '[/img][/url]' . "\n"; $content2 .= '<a href="' . $url . '"><img src="' . $thumb . ' /></a>' . "\n"; } starttable(-1, 'Share codes for <i>all files</i> in this album'); echo <<<EOT <tr> <td class="tableb"> <tt>[url][img][/url]</tt>: <textarea onfocus="this.select();" onclick="this.select();" class="textinput" rows="1" cols="64" wrap="off" style="overflow:hidden; height:15px;">{$content1}</textarea> <br /> <tt><a><img></a></tt>: <textarea onfocus="this.select();" onclick="this.select();" class="textinput" rows="1" cols="64" wrap="off" style="overflow:hidden; height:15px;">{$content2}</textarea> </td> </tr> EOT; endtable(); } } }
/** * alb_get_subcat_data() * * @param integer $parent * @param string $ident **/ function alb_get_subcat_data($parent, $ident = '') { global $CONFIG, $CAT_LIST, $USER_DATA; // select cats where the users can change the albums $groups = ''; foreach ($USER_DATA['groups'] as $group) { $groups .= "group_id = '{$group}' OR "; } $groups .= "0"; $result = cpg_db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '{$parent}' AND cid != 1 ORDER BY pos"); if ($result->numRows() > 0) { $rowset = cpg_db_fetch_rowset($result); foreach ($rowset as $subcat) { if (!GALLERY_ADMIN_MODE) { $check_group = cpg_db_query("SELECT group_id FROM {$CONFIG['TABLE_CATMAP']} WHERE ({$groups}) AND cid = " . $subcat['cid']); $check_group_rowset = cpg_db_fetch_rowset($check_group); if ($check_group_rowset) { $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']); } } else { $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']); } alb_get_subcat_data($subcat['cid'], $ident . ' '); } } }
function create_hist_table() { global $CONFIG; $tabname = $CONFIG['TABLE_PREFIX'] . "fullsize_hist"; $query = "CREATE TABLE IF NOT EXISTS " . $tabname . " (" . "`id` int(10) unsigned NOT NULL auto_increment," . "`uid` int(10) unsigned NOT NULL default '0'," . "`tstamp` datetime NOT NULL default '0000-00-00 00:00:00'," . "`picname` varchar(255) NOT NULL default ''," . "`ip` varchar(20) NOT NULL default ''," . "PRIMARY KEY (`id`)," . "UNIQUE KEY `multi` (`uid`,`picname`)" . ") ENGINE=MyISAM"; cpg_db_query($query); }
function photo_shop_fetch_user($oid) { global $CONFIG, $udb_var; $sql = "SELECT s.*, u.{$udb_var['field']['username']}, u.{$udb_var['field']['email']} FROM {$CONFIG['TABLE_SHOP']} AS s LEFT JOIN {$udb_var['usertable']} as u ON u.{$udb_var['field']['user_id']} = s.uid WHERE oid=" . $oid . " AND cd=1 AND s.uid=" . USER_ID . " LIMIT 1"; $result = cpg_db_query($sql, $this->link_id); return $result; }
function cpgUserLastComment($uid) { global $CONFIG, $FORBIDDEN_SET; $result = cpg_db_query("SELECT COUNT(*), MAX(msg_id) FROM {$CONFIG['TABLE_COMMENTS']} AS c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.pid = c.pid WHERE approval = 'YES' AND author_id = '{$uid}' {$FORBIDDEN_SET}"); list($comment_count, $lastcom_id) = mysql_fetch_row($result); mysql_free_result($result); $lastComArray = array('count' => 0); if ($comment_count) { $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight, msg_author, UNIX_TIMESTAMP(msg_date) as msg_date, msg_body FROM {$CONFIG['TABLE_COMMENTS']} AS c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.pid = c.pid WHERE msg_id = {$lastcom_id}"; $result = cpg_db_query($sql); if (mysql_num_rows($result)) { $row = mysql_fetch_assoc($result); $pic_url = get_pic_url($row, 'thumb'); if (!is_image($row['filename'])) { $image_info = cpg_getimagesize(urldecode($pic_url)); $row['pwidth'] = $image_info[0]; $row['pheight'] = $image_info[1]; } $image_size = compute_img_size($row['pwidth'], $row['pheight'], $CONFIG['thumb_width']); $lastcom = '<img src="' . $pic_url . '" class="image"' . $image_size['geom'] . ' border="0" alt="" />'; $lastComArray = array('thumb' => $lastcom, 'comment' => $row['msg_body'], 'msg_date' => $row['msg_date'], 'count' => $comment_count); } mysql_free_result($result); } return $lastComArray; }
function getDateLink($day, $month, $year) { global $CONFIG, $lang_calendar_php; $superCage = Inspekt::makeSuperCage(); $date = sprintf('%s-%02s-%02s', $year, $month, $day); $query = "SELECT COUNT(pid) from {$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' AND substring(from_unixtime(ctime),1,10) = '" . substr($date, 0, 10) . "' {$META_ALBUM_SET}"; $result = cpg_db_query($query); $nb_pics = mysql_result($result, 0, 0); if ($matches = $superCage->get->getMatched('action', '/^[a-z]+$/')) { $action = $matches[0]; } elseif ($matches = $superCage->post->getMatched('action', '/^[a-z]+$/')) { $action = $matches[0]; } else { $action = ''; } if ($action == 'browsebydate') { if ($nb_pics) { $link = '<a href="#" onclick="sendDate(\'' . $month . '\', \'' . $day . '\', \'' . $year . '\');" class="user_thumb_infobox" title="' . $nb_pics . ' ' . $lang_calendar_php['files'] . '">'; } else { $link = ''; } } else { $link = "<a href=\"#\" onclick=\"sendDate('" . $month . "', '" . $day . "', '" . $year . "');\" class=\"user_thumb_infobox\" >"; } return $link; }
function plugin_dst_datetime_update($dst_array) { global $CONFIG; foreach ($dst_array as $value) { if ($CONFIG['plugin_dst_country'] == $value['country']) { $datetime = date('Y-m-d H:i:s'); $previoustime = ''; foreach ($value['data'] as $selected_array) { $starttime = current($selected_array); $endtime = next($selected_array); if ($datetime >= $starttime && $datetime <= $endtime) { // We have a winner - it's currently DST and we have a time zone difference $CONFIG['plugin_dst_datetime'] = $endtime; $CONFIG['plugin_dst_on'] = '1'; } elseif ($datetime > $previoustime && $datetime < $starttime) { // We're out of the DST time range, i.e. in winter on the norther hemisphere $CONFIG['plugin_dst_datetime'] = $starttime; $CONFIG['plugin_dst_on'] = '0'; } $previoustime = $endtime; } cpg_db_query("UPDATE {$CONFIG['TABLE_CONFIG']} SET value='{$CONFIG['plugin_dst_datetime']}' WHERE name='plugin_dst_datetime'"); cpg_db_query("UPDATE {$CONFIG['TABLE_CONFIG']} SET value='{$CONFIG['plugin_dst_on']}' WHERE name='plugin_dst_on'"); } } }
function minicms($content = '') { global $MINICMS, $CONFIG, $cat, $album, $REFERER, $lang_minicms, $HTML_SUBST_DECODE, $cms_array; if ($MINICMS['dbver'] != MINICMS_DBVER) { echo "<h2>{$lang_minicms['minicms_full']} {$MINICMS['dbver']}</h2><br />{$lang_minicms['dbver_nomatch']}: " . MINICMS_DBVER . "<br />"; minicms_configure(false); //auto-updater and dont print the "go" button } $where = isset($MINICMS['ID']) ? "ID='{$MINICMS['ID']}'" : "conid='{$MINICMS['conid']}' AND type='{$MINICMS['type']}'"; $query = "SELECT * FROM {$CONFIG['TABLE_CMS']} WHERE {$where} ORDER BY cpos"; $result = cpg_db_query($query); $cms_array = cpg_db_fetch_rowset($result); $counter = 0; foreach ($cms_array as $key => $cms) { $cms_array[$key]['next_ID'] = $counter < count($cms_array) - 1 && $cms['type'] == $cms_array[$counter + 1]['type'] && $cms['conid'] == $cms_array[$counter + 1]['conid'] ? '&id2=' . $cms_array[$counter + 1]['ID'] : ''; $cms_array[$key]['prev_ID'] = $counter > 0 && $cms['type'] == $cms_array[$counter - 1]['type'] && $cms['conid'] == $cms_array[$counter - 1]['conid'] ? '&id2=' . $cms_array[$counter - 1]['ID'] : ''; $cms_array[$key]['content'] = html_entity_decode(stripslashes($cms['content'])); $counter++; } ob_start(); theme_minicms($cms_array); //$content.=ob_get_clean(); $content = ob_get_clean(); return $content; }
function edit_pic_views_after_edit_file($pid) { global $CONFIG; $hits = get_post_var('hits', $pid); if (is_numeric($hits) && $hits >= 0) { cpg_db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET hits = '{$hits}' WHERE pid = {$pid} LIMIT 1"); } }
function check_files_uninstall() { global $CONFIG; cpg_db_query("DROP TABLE IF EXISTS {$CONFIG['TABLE_PREFIX']}plugin_check_files_additional"); cpg_db_query("DROP TABLE IF EXISTS {$CONFIG['TABLE_PREFIX']}plugin_check_files_dirs"); cpg_db_query("DROP TABLE IF EXISTS {$CONFIG['TABLE_PREFIX']}plugin_check_files_missing"); cpg_db_query("DELETE FROM {$CONFIG['TABLE_CONFIG']} WHERE name LIKE 'plugin_check_files_%'"); return true; }
function exif_parse_file($filename) { global $CONFIG, $lang_picinfo; //String containing all the available exif tags. $exif_info = "AFFocusPosition|Adapter|ColorMode|ColorSpace|ComponentsConfiguration|CompressedBitsPerPixel|Contrast|CustomerRender|DateTimeOriginal|DateTimedigitized|DigitalZoom|DigitalZoomRatio|ExifImageHeight|ExifImageWidth|ExifInteroperabilityOffset|ExifOffset|ExifVersion|ExposureBiasValue|ExposureMode|ExposureProgram|ExposureTime|FNumber|FileSource|Flash|FlashPixVersion|FlashSetting|FocalLength|FocusMode|GainControl|IFD1Offset|ISOSelection|ISOSetting|ISOSpeedRatings|ImageAdjustment|ImageDescription|ImageSharpening|LightSource|Make|ManualFocusDistance|MaxApertureValue|MeteringMode|Model|NoiseReduction|Orientation|Quality|ResolutionUnit|Saturation|SceneCaptureMode|SceneType|Sharpness|Software|WhiteBalance|YCbCrPositioning|xResolution|yResolution"; if (!is_readable($filename)) { return false; } $size = @getimagesize($filename); if ($size[2] != 2) { return false; } // Not a JPEG file $exifRawData = explode("|", $exif_info); $exifCurrentData = explode("|", $CONFIG['show_which_exif']); //Let's build the string of current exif values to be shown $showExifStr = ""; foreach ($exifRawData as $key => $val) { if ($exifCurrentData[$key] == 1) { $showExifStr .= "|" . $val; } } //Check if we have the data of the said file in the table $sql = "SELECT * FROM {$CONFIG['TABLE_EXIF']} " . "WHERE filename='" . addslashes($filename) . "'"; $result = cpg_db_query($sql); if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result); mysql_free_result($result); $exifRawData = unserialize($row["exifData"]); } else { // No data in the table - read it from the image file $exifRawData = read_exif_data_raw($filename, 0); // Insert it into table for future reference $sql = "INSERT INTO {$CONFIG['TABLE_EXIF']} " . "VALUES ('" . addslashes($filename) . "', '" . addslashes(serialize($exifRawData)) . "')"; $result = cpg_db_query($sql); } $exif = array(); if (is_array($exifRawData['IFD0'])) { $exif = array_merge($exif, $exifRawData['IFD0']); } if (is_array($exifRawData['SubIFD'])) { $exif = array_merge($exif, $exifRawData['SubIFD']); } if (is_array($exifRawData['SubIFD']['MakerNote'])) { $exif = array_merge($exif, $exifRawData['SubIFD']['MakerNote']); } $exif['IFD1OffSet'] = $exifRawData['IFD1OffSet']; $exifParsed = array(); foreach ($exif as $key => $val) { if (strpos($showExifStr, "|" . $key) && isset($val)) { $exifParsed[$lang_picinfo[$key]] = $val; //$exifParsed[$key] = $val; } } ksort($exifParsed); return $exifParsed; }
function cpgpicdownload_configure() { global $CONFIG; if (!isset($CONFIG['cpgpicdownload'])) { $setting = 'anonymous'; $sql = "INSERT INTO {$CONFIG['TABLE_CONFIG']} VALUES ('cpgpicdownload','{$setting}');"; $CONFIG['cpgpicdownload'] = $setting; cpg_db_query($sql); } }
function iframe_upload_uninstall() { global $CONFIG; $CONFIG['allowed_doc_types'] = str_replace('/iframe', $CONFIG['allowed_doc_types']); $CONFIG['allowed_doc_types'] = str_replace('iframe/', '', $CONFIG['allowed_doc_types']); $CONFIG['allowed_doc_types'] = str_replace('iframe', '', $CONFIG['allowed_doc_types']); cpg_db_query("UPDATE {$CONFIG['TABLE_CONFIG']} SET value = '{$CONFIG['allowed_doc_types']}' WHERE name = 'allowed_doc_types'"); cpg_db_query("DELETE FROM {$CONFIG['TABLE_FILETYPES']} WHERE extension = 'iframe'"); return true; }
function auto_tag_after_edit_file($pid) { global $CONFIG; static $keywords_array = null; if ($keywords_array === null) { $keywords_array = array(); $result = cpg_db_query("SELECT keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> ''"); if (mysql_num_rows($result)) { while (list($keywords) = mysql_fetch_row($result)) { $array = explode($CONFIG['keyword_separator'], html_entity_decode($keywords)); foreach ($array as $word) { if (!in_array($word = utf_strtolower($word), $keywords_array) && trim($word)) { $keywords_array[] = $word; } } } } } if (!count($keywords_array)) { return; } $result = cpg_db_query("SELECT title, caption, keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE pid = {$pid} LIMIT 1"); if (!mysql_num_rows($result)) { return; } $picture = mysql_fetch_assoc($result); if (!$picture['title'] && !$picture['caption']) { return; } preg_match_all('/[\\w]+/', $picture['title'], $matches_title); preg_match_all('/[\\w]+/', $picture['caption'], $matches_caption); $word_array = array_merge($matches_title[0], $matches_caption[0]); if ($picture['keywords']) { $keyword_array = array(); $keyword_array_lowercase = array(); $array = explode($CONFIG['keyword_separator'], html_entity_decode($picture['keywords'])); foreach ($array as $word) { if (!in_array(utf_strtolower($word), $keyword_array_lowercase) && trim($word)) { $keyword_array[] = $word; $keyword_array_lowercase[] = utf_strtolower($word); } } } $new_keyword = false; foreach ($word_array as $word) { if (!in_array(utf_strtolower($word), $keyword_array_lowercase) && in_array(utf_strtolower($word), $keywords_array)) { $new_keyword = true; $keyword_array[] = $word; $keyword_array_lowercase[] = utf_strtolower($word); } } if ($new_keyword) { cpg_db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET keywords = '" . implode($CONFIG['keyword_separator'], $keyword_array) . "' WHERE pid = {$pid} LIMIT 1"); } }
/** * create_banlist() * * @return **/ function create_banlist() { global $CONFIG, $lang_banning_php, $album_date_fmt; //$PHP_SELF, $result = cpg_db_query("SELECT *, UNIX_TIMESTAMP(expiry) AS expiry FROM {$CONFIG['TABLE_BANNED']} WHERE brute_force=0"); $count = mysql_num_rows($result); if ($count > 0) { echo <<<EOHEAD <tr> <th align="center" class="tableh2">{$lang_banning_php['user_name']}</th> <th align="center" class="tableh2">{$lang_banning_php['ip_address']}</th> <th align="center" class="tableh2">{$lang_banning_php['expiry']}</th> <th align="center" class="tableh2"></th> </tr> EOHEAD; $row_counter = 0; while ($row = mysql_fetch_array($result)) { if ($row['user_id']) { $username = get_username($row['user_id']); } else { $username = ''; } if ($row['expiry']) { $expiry = localised_date($row['expiry'], '%Y-%m-%d'); } else { $expiry = ''; } echo <<<EOROW <tr> <form action="{$_SERVER['PHP_SELF']}" method="post" name="banlist{$row_counter}"> <td width="20%" class="tableb" valign="middle"> <input type="hidden" name="ban_id" value="{$row['ban_id']}" /> <input type="text" class="textinput" style="width: 100%" name="edit_ban_user_name" value="{$username}" /> </td> <td class="tableb" valign="middle"> <input type="text" class="textinput" size="15" name="edit_ban_ip_addr" value="{$row['ip_addr']}" /> </td> <td class="tableb" valign="middle"> <input type="text" class="listbox_lang" size="20" name="edit_ban_expires" value="{$expiry}" readonly="readonly" title="{$lang_banning_php['select_date']}" /> <a href="javascript:;" onclick="return getCalendar(document.banlist{$row_counter}.edit_ban_expires);" title="{$lang_banning_php['select_date']}"><img src="images/calendar.gif" width="16" height="16" border="0" alt="" /></a> </td> <td class="tableb" valign="middle"> <input type="submit" class="button" name="edit_ban" value="{$lang_banning_php['edit_ban']}" /> <input type="submit" class="button" name="delete_ban" value="{$lang_banning_php['delete_ban']}" /> </td> </form> </tr> EOROW; $row_counter++; } } mysql_free_result($result); }
function log_fullsize_access_fullsize_html($fullsize_html) { global $CONFIG, $pid, $USER_DATA; if ($pid) { cpg_db_query("INSERT INTO {$CONFIG['TABLE_PREFIX']}plugin_log_fullsize_access (pid, user_id, timestamp) VALUES ('{$pid}', '" . USER_ID . "', UNIX_TIMESTAMP())"); if ($CONFIG['plugin_log_fullsize_access_email']) { preg_match('/alt="(.*)"/U', $fullsize_html, $matches); cpg_mail($CONFIG['gallery_admin_email'], 'Fullsize access', $USER_DATA['user_name'] . "\t" . $matches[1]); } } return $fullsize_html; }
function plugin_geoip_uninstall() { global $CONFIG; $superCage = Inspekt::makeSuperCage(); if (!checkFormToken()) { global $lang_errors; cpg_die(ERROR, $lang_errors['invalid_form_token'], __FILE__, __LINE__); } // Delete the plugin config records cpg_db_query("DELETE FROM {$CONFIG['TABLE_CONFIG']} WHERE name = 'plugin_geoip_scope'"); return true; }
function hs_uninstall() { global $CONFIG, $thisplugin; if (!isset($_POST['drop'])) { return 1; } if ($_POST['drop']) { cpg_db_query("DROP TABLE IF EXISTS {$CONFIG['TABLE_HIGHSLIDE_CONFIG']}"); cpg_db_query("DELETE FROM {$CONFIG['TABLE_CONFIG']} WHERE name='highslide_enable';"); } return true; }
function get_album_data($category, $ident) { global $CONFIG, $catStr, $ALBUM_SET; $sql = "SELECT aid,title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = {$category} " . $ALBUM_SET; $result = cpg_db_query($sql); if (($cat_count = mysql_num_rows($result)) > 0) { $rowset = cpg_db_fetch_rowset($result); foreach ($rowset as $subcat) { $catStr .= "\n {$ident}<album>\n {$ident}<id>{$subcat['aid']}</id>\n {$ident}<name>{$subcat['title']}</name>\n {$ident}</album>"; } } }
/** * alb_get_subcat_data() * * @param integer $parent * @param string $ident **/ function alb_get_subcat_data($parent, $ident = '') { global $CONFIG, $CAT_LIST; $result = cpg_db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '{$parent}' AND cid != 1 ORDER BY pos"); if (mysql_num_rows($result) > 0) { $rowset = cpg_db_fetch_rowset($result); foreach ($rowset as $subcat) { $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']); alb_get_subcat_data($subcat['cid'], $ident . ' '); } } }
function session_extraction() { $row = false; //array('id' => 0, 'username' => 'Guest', 'status' => -1); if (isset($_COOKIE[$this->cookie_name])) { list($username, $pass_hash) = unserialize($_COOKIE[$this->cookie_name]); if (strcasecmp($username, 'Guest')) { $result = cpg_db_query("SELECT id, username, status+100 AS status FROM {$this->usertable} WHERE username = '******' AND password = '******'", $this->link_id); $row = mysql_fetch_assoc($result); } } return $row; }
function panorama_viewer_is_360_degree_panorama() { global $CONFIG, $CURRENT_PIC_DATA; if (!isset($CONFIG['plugin_panorama_viewer_360_degree'])) { $CONFIG['plugin_panorama_viewer_360_degree'] = '_360pano.jp'; cpg_db_query("INSERT INTO {$CONFIG['TABLE_CONFIG']} (name, value) VALUES ('plugin_panorama_viewer_360_degree', '{$CONFIG['plugin_panorama_viewer_360_degree']}')"); } if (stripos($CURRENT_PIC_DATA['filename'], $CONFIG['plugin_panorama_viewer_360_degree']) !== false) { return true; } else { return false; } }
function panorama_viewer_save_config_value($name) { global $CONFIG; $superCage = Inspekt::makeSuperCage(); $new_value = $superCage->post->getRaw($name); if (!isset($CONFIG[$name])) { cpg_db_query("INSERT INTO {$CONFIG['TABLE_CONFIG']} (name, value) VALUES('{$name}', '{$new_value}')"); $CONFIG[$name] = $new_value; } elseif ($new_value != $CONFIG[$name]) { cpg_db_query("UPDATE {$CONFIG['TABLE_CONFIG']} SET value = '{$new_value}' WHERE name = '{$name}'"); $CONFIG[$name] = $new_value; } }
function session_extraction() { if (isset($_COOKIE['session_id'])) { $session_id = addslashes($_COOKIE['session_id']); $sql = "SELECT member_id , member_login_key FROM {$this->sessionstable} AS s INNER JOIN {$this->usertable} AS u ON s.member_id = u.id WHERE s.id = '{$session_id}'"; $result = cpg_db_query($sql, $this->link_id); if (mysql_num_rows($result)) { $row = mysql_fetch_array($result); return $row; } } else { return false; } }
function avmaker_uninstall() { global $CONFIG; if (!isset($_POST['drop'])) { return 1; } if ($_POST['drop']) { //remove - config cpg_db_query("DELETE FROM `{$CONFIG['TABLE_CONFIG']}` WHERE name = 'avmk_enabled' OR name = 'avmk_df_width' OR name = 'avmk_df_height' OR name = 'avmk_jpeg_quality' OR name = 'avmk_time';"); // drop a table cpg_db_query("DROP TABLE `{$CONFIG['TABLE_PREFIX']}av_temp`;"); } return true; }
function getDateLink($day, $month, $year) { global $CONFIG, $lang_calendar_php, $FORBIDDEN_SET; $date = sprintf('%d-%02d-%02d', $year, $month, $day); $sql = "SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE approved = 'YES' AND DATE(FROM_UNIXTIME(ctime)) = '{$date}' {$FORBIDDEN_SET}"; $result = cpg_db_query($sql); list($nb_pics) = mysql_fetch_row($result); if ($nb_pics) { $link = '<a href="#" onclick="sendDate(\'' . $month . '\', \'' . $day . '\', \'' . $year . '\');" class="user_thumb_infobox" title="' . $nb_pics . ' ' . $lang_calendar_php['files'] . '">'; } else { $link = ''; } return $link; }
function session_extraction() { $superCage = Inspekt::makeSuperCage(); if ($superCage->cookie->keyExists('session_id')) { $session_id = $superCage->cookie->getEscaped('session_id'); $sql = "SELECT member_id, member_login_key FROM {$this->sessionstable} AS s INNER JOIN {$this->usertable} AS u ON s.member_id = u.id WHERE s.id = '{$session_id}'"; $result = cpg_db_query($sql, $this->link_id); if (mysql_num_rows($result)) { $row = mysql_fetch_row($result); return $row; } } else { return false; } }
function session_extraction() { if (isset($_COOKIE[$this->cookie_name . '_sid'])) { $session_id = addslashes($_COOKIE[$this->cookie_name . '_sid']); $sql = "SELECT user_id, username, group_id FROM {$this->sessionstable} INNER JOIN {$this->usertable} ON session_user_id = user_id WHERE session_id='{$session_id}';"; // AND session_user_id ='$cookie_id'"; (Maybe session_id is unique enough?) $result = cpg_db_query($sql, $this->link_id); if (mysql_num_rows($result)) { $row = mysql_fetch_array($result); return $row; } else { return false; } } }