示例#1
0
  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License version 3
  as published by the Free Software Foundation.

  ********************************************
  Coppermine version: 1.5.30
  $HeadURL: https://svn.code.sf.net/p/coppermine/code/trunk/cpg1.5.x/keyword_select.php $
  $Revision: 8721 $
**********************************************/
define('IN_COPPERMINE', true);
define('UPLOAD_PHP', true);
require 'include/init.inc.php';
if (!USER_CAN_UPLOAD_PICTURES) {
    cpg_die(ERROR, $lang_errors['perm_denied'], __FILE__, __LINE__);
}
pageheader_mini($lang_upload_php['keywords_sel']);
$query = "SELECT keyword FROM {$CONFIG['TABLE_DICT']} ORDER BY keyword";
$result = cpg_db_query($query);
$keywords = array();
while ($row = mysql_fetch_assoc($result)) {
    $keywords[] = $row['keyword'];
}
$total = mysql_num_rows($result);
mysql_free_result($result);
if ($superCage->get->keyExists('id')) {
    $formFieldId = $superCage->get->getInt('id');
}
echo '<form name="keywordform" action="">' . $LINEBREAK;
starttable("100%", $lang_upload_php['keywords_sel'], 3);
$keyword_separator = $CONFIG['keyword_separator'];
if ($total > 0) {
    {
        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;
    }
}
js_include('js/calendar.js');
pageheader_mini($lang_calendar_php['title'], true);
$today = getdate();
if ($superCage->get->testInt('month')) {
    $month = $superCage->get->getInt('month');
} else {
    $month = $today['mon'];
}
if ($superCage->get->testInt('year')) {
    $year = $superCage->get->getInt('year');
} else {
    $year = $today['year'];
}
$cal = new MyCalendar();
$cal->setMonthNames($lang_month);
$cal->setDayNames($lang_day_of_week);
$cal->setStartDay(1);
  as published by the Free Software Foundation.

  ********************************************
  Coppermine version: 1.5.40
  $HeadURL: https://svn.code.sf.net/p/coppermine/code/trunk/cpg1.5.x/keyword_create_dict.php $
  $Revision: 8830 $
**********************************************/
define('IN_COPPERMINE', true);
define('EDITPICS_PHP', true);
require 'include/init.inc.php';
if (!GALLERY_ADMIN_MODE) {
    cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);
}
$output = $CPG_REFERER != 'keyword_select.php';
if ($output) {
    pageheader_mini($lang_gallery_admin_menu['key_lnk']);
}
$query = "SELECT keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> ''";
$result = cpg_db_query($query);
$i = 0;
if (mysql_num_rows($result)) {
    if ($output) {
        starttable('100%', $lang_gallery_admin_menu['key_lnk']);
    }
    cpg_db_query("TRUNCATE TABLE {$CONFIG['TABLE_DICT']}");
    while ($row = mysql_fetch_assoc($result)) {
        $keyArr = explode($CONFIG['keyword_separator'], $row['keywords']);
        foreach ($keyArr as $keyword) {
            $keyword = trim($keyword);
            if (empty($keyword)) {
                continue;