[] = * */ function plugin_getmenuitems_filemgmt() { global $_CONF, $LANG_FILEMGMT; $menuitems = array(); $menuitems["{$LANG_FILEMGMT['downloads']}"] = $_CONF['site_url'] . "/filemgmt/index.php"; return $menuitems; } /** * Called by the plugin Editor to display the current plugin code version * This may be different then the version installed and registered currently. * If newer then you may want to run the update */ function plugin_chkVersion_filemgmt() { global $CONF_FM; return $CONF_FM['version']; } /** * Called by the plugin Editor to run the SQL Update for a plugin update */ function plugin_upgrade_filemgmt() { global $_TABLES,$_FM_TABLES,$CONF_FM; $cur_version = DB_getItem($_TABLES['plugins'],'pi_version', "pi_name='filemgmt'"); $gl_version = floatval (VERSION); if ($gl_version >= 1.3) { if ($cur_version == '1.3') { DB_query("ALTER TABLE {$_FM_TABLES['filemgmt_cat']} ADD `grp_access` mediumint(8) DEFAULT '2' NOT NULL AFTER imgurl"); DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '{$CONF_FM['version']}' WHERE pi_name = 'filemgmt'"); DB_query("UPDATE {$_TABLES['plugins']} SET pi_gl_version = '1.4' WHERE pi_name = 'filemgmt'"); // Update all the comment records $result = DB_query("SELECT cid,sid FROM {$_TABLES['comments']} WHERE type='filemgmt'"); while (list($cid,$sid) = DB_fetchArray($result)) { if (strpos($sid,'fileid_') === FALSE) { $sid = "fileid_{$sid}"; DB_query("UPDATE {$_TABLES['comments']} SET sid='$sid' WHERE cid='$cid'"); } } return true; } elseif ($cur_version == '1.5') { DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '{$CONF_FM['version']}' WHERE pi_name = 'filemgmt'"); DB_query("UPDATE {$_TABLES['plugins']} SET pi_gl_version = '1.4' WHERE pi_name = 'filemgmt'"); return true; } elseif ($cur_version == '1.5.1') { DB_query("UPDATE {$_TABLES['plugins']} SET pi_version = '{$CONF_FM['version']}' WHERE pi_name = 'filemgmt'"); return true; } else { return 5; } } else { return 3; } } /** * Include if plugin will be supporting comments * * @author Blaine Lang blaine@portalparts.com * @return boolean true indicates comments are suppported */ function plugin_commentsupport_filemgmt() { // Filemgmt Module will use comments return true; } /** * Plugin function that is called after comment form is submitted. * Needs to atleast save the comment and check return value. * Add any additional logic your plugin may need to perform on comments. * * @author Blaine Lang blaine@portalparts.com * @param string $title Comment title field in comment form * @param string $comment comment text * @param string $id Item id to which $cid belongs * @param int $pid comment parent * @param string $postmode 'html' or 'text' * @return mixed HTML string (redirect?) for success or comment form if failure. */ function plugin_savecomment_filemgmt($title,$comment,$id,$pid,$postmode) { global $_CONF,$_FM_TABLES, $LANG03, $_TABLES; $title = strip_tags ($title); $pid = COM_applyFilter ($pid, true); $postmode = COM_applyFilter ($postmode); $ret = CMT_saveComment ( $title, $comment, $id, $pid, 'filemgmt',$postmode); if ( $ret > 0 ) { // failure return COM_siteHeader() . CMT_commentform ($title, $comment, $id, $pid, 'filemgmt', $LANG03[14], $postmode) . COM_siteFooter(); } else { // success $comments = DB_count ($_TABLES['comments'], 'sid', $id); DB_change($_FM_TABLES['filemgmt_filedetail'],'comments', $comments, 'lid',$id); return (COM_refresh (COM_buildUrl ($_CONF['site_url'] . "/filemgmt/index.php?id=$id")) ); } } /** * Plugin API to delete a comment * * @author Blaine Lang blaine@portalparts.com * @param int $cid Comment to be deleted * @param string $id Item id to which $cid belongs * @return mixed false for failure, HTML string (redirect?) for success */function plugin_deletecomment_filemgmt($cid,$id) { global $_CONF,$_FM_TABLES, $_TABLES; if (SEC_hasRights("filemgmt.edit")) { if (CMT_deleteComment($cid, $id, 'filemgmt') == 0) { // Now redirect the program flow to the view of the file and its comments return (COM_refresh($_CONF['site_url'] . "/filemgmt/index.php?id=$id")); } else { return false; } } else { return false; } } /** * Plugin API to display a specific comment thread * * @author Blaine Lang blaine@portalparts.com * @param string $id Unique idenifier for item comment belongs to * @param int $commentid Comment id to display (possibly including sub-comments) * @param string $title comment title * @param string $order 'ASC' or 'DSC' or blank * @param string $format 'threaded', 'nested', or 'flat' * @param int $page Page number of comments to display * @param boolean $view True to view comment (by cid), false to display (by $pid) * @return mixed results of calling the CMT_userComments function */ function plugin_displaycomment_filemgmt($id,$commentid,$title,$order,$format,$page,$view) { global $LANG_FILEMGMT, $_TABLES, $_FM_TABLES, $_CONF, $LANG01; $id = str_replace('fileid_','',$id); /* Plugin specific code to display relevant content above the comment thread */ /* Example: Display the file details */ include($_CONF['path_html'] ."filemgmt/include/functions.php"); include_once($_CONF[path_html]. "filemgmt/include/xoopstree.php"); include_once($_CONF[path_html]. "filemgmt/include/textsanitizer.php"); $comments = true; // Checked in filemgmt code in dlformat.php $myts = new MyTextSanitizer; // MyTextSanitizer object $mytree = new XoopsTree($_DB_name,$_FM_TABLES['filemgmt_cat'],"cid","pid"); $display = COM_startBlock("". $LANG_FILEMGMT['plugin_name'] .""); $fields = 'd.lid, d.cid, d.title, d.url, d.homepage, d.version, d.size, d.logourl,'; $fields .= 'd.submitter, d.status, d.date, d.hits, d.rating, d.votes, t.description'; $sql = "SELECT $fields FROM {$_FM_TABLES['filemgmt_filedetail']} d, "; $sql .= "{$_FM_TABLES['filemgmt_filedesc']} t "; $sql .= "WHERE d.lid='$id' AND d.lid=t.lid AND status > 0"; $result=DB_query($sql); list($lid, $cid, $dtitle, $url, $homepage, $version, $size, $logourl, $submitter, $status, $time, $hits, $rating, $votes, $description)=DB_fetchARRAY($result); $p = new Template($_CONF['path'] . 'plugins/filemgmt/templates'); $p->set_file (array ( 'page' => 'filelisting.thtml', 'records' => 'filelisting_record.thtml', 'category' => 'filelisting_category.thtml')); $p->set_var ('layout_url', $_CONF['layout_url']); $p->set_var ('site_url',$_CONF['site_url']); $pathstring = ""._MD_MAIN." : "; $nicepath = $mytree->getNicePathFromId($cid, "title", "{$_CONF['site_url']}/filemgmt/viewcat.php?op="); $pathstring .= $nicepath; $p->set_var('category_path_link',$pathstring); $rating = number_format($rating, 2); $dtitle = $myts->makeTboxData4Show($dtitle); $url = $myts->makeTboxData4Show($url); $homepage = $myts->makeTboxData4Show($homepage); $version = $myts->makeTboxData4Show($version); $size = $myts->makeTboxData4Show($size); $platform = $myts->makeTboxData4Show($platform); $logourl = $myts->makeTboxData4Show($logourl); $datetime = formatTimestamp($time); $description = $myts->makeTareaData4Show($description,0); //no html $result2 = DB_query("SELECT username,fullname,photo FROM {$_TABLES['users']} WHERE uid = $submitter"); list ($submitter_name,$submitter_fullname,$photo) = DB_fetchARRAY($result2); $submitter_name = COM_getDisplayName ($submitter, $submitter_name, $submitter_fullname); include($_CONF[path_html] ."/filemgmt/include/dlformat.php"); $p->set_var('cssid',1); $p->parse ('filelisting_records', 'records'); $p->parse ('output', 'page'); $display .= $p->finish ($p->get_var('output')); $display .= COM_endBlock(); /* Get formatted comment thread */ if (SEC_hasRights('filemgmt.edit')) { $delete_option = true; } else { $delete_option = false; } if ($view == 1) { $display .= CMT_userComments ("fileid_$id", $title, 'filemgmt',$order,$format,$commentid,$page,true,$delete_option); } else { $display .= CMT_userComments ("fileid_$id", $title, 'filemgmt',$order,$format,$commentid,$page,false,$delete_option); } return $display; } function plugin_statssummary_filemgmt () { global $_FM_TABLES, $LANG_FILEMGMT; $sql = "SELECT COUNT(*), SUM(hits) FROM {$_FM_TABLES['filemgmt_filedetail']} a "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid "; $sql .= filemgmt_buildAccessSql('WHERE'); list($total_files,$total_downloads) = DB_fetchArray( DB_query($sql)); return array ($LANG_FILEMGMT['nofiles'], COM_numberFormat ($total_files) . '(' . COM_numberFormat ($total_downloads) . ')'); } /** * shows the statistics for the Filemgmot plugin on stats.php. If $showsitestats * is 1 then we are to only print the overall stats in the 'site statistics box' * otherwise we show the detailed stats for the photo album * * @showsitestats int Flag to let us know which stats to get */ function plugin_showstats_filemgmt($showsitestats) { global $LANG_FILEMGMT, $_FM_TABLES, $_CONF; $stat_templates = new Template($_CONF['path_layout'] . 'stats'); $stat_templates->set_file(array('itemstats'=>'itemstatistics.thtml', 'statrow'=>'singlestat.thtml')); if ($showsitestats == 1) { $sql = "SELECT COUNT(*), SUM(hits) FROM {$_FM_TABLES['filemgmt_filedetail']} a "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid "; $sql .= filemgmt_buildAccessSql('WHERE'); list($total_files,$total_downloads) = DB_fetchArray( DB_query($sql)); $retval = ""; $retval .= ""; $retval .= "

" . $LANG_FILEMGMT['nofiles'] . "

" . $total_files . " (" .$total_downloads .")

"; } else { $sql = "SELECT a.lid, a.title, hits from {$_FM_TABLES['filemgmt_filedetail']} a "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid "; $sql .= filemgmt_buildAccessSql('WHERE'); $sql .= " AND hits > 0 ORDER BY hits desc LIMIT 10"; $result = DB_query($sql); $nrows = DB_numRows($result); $retval .= COM_startBlock($LANG_FILEMGMT['StatsMsg1']); if ($nrows > 0) { $stat_templates->set_var('item_label',"Page Title"); $stat_templates->set_var('stat_name',"Hits"); for ($i = 0; $i < $nrows && $i < 10; $i++) { list ($lid, $title,$hits) = DB_fetchARRAY($result); $stat_templates->set_var('item_url', $_CONF[site_url]. "/filemgmt/index.php?id=".$lid); $stat_templates->set_var('item_text', $title); $stat_templates->set_var('item_stat', $hits); $stat_templates->parse('stat_row','statrow',true); } $stat_templates->parse('output','itemstats'); $retval .= $stat_templates->finish($stat_templates->get_var('output')); } else { $retval .= $LANG_FILEMGMT['StatsMsg2']; } $retval .= COM_endBlock(); } return $retval; } /** * Geeklog is asking us to provide any new items that show up in the type drop-down * on search.php. Let's let users search the Filelistings in the Filemgmt Plugin * */ function plugin_searchtypes_filemgmt() { global $LANG_FILEMGMT; $tmp['filemgmt'] = $LANG_FILEMGMT['searchlabel']; return $tmp; } /** * this searches for files matching the user query and returns an array of * for the header and table rows back to search.php where it will be formated and * printed * * @query string Keywords user is looking for * @datestart date/time Start date to get results for * @dateend date/time End date to get results for * @topic string The topic they were searching in * @type string Type of items they are searching * @author string Get all results by this author * */ function plugin_dopluginsearch_filemgmt($query, $datestart, $dateend, $topic, $type, $author) { global $LANG_FILEMGMT, $_TABLES, $_FM_TABLES, $_CONF, $filemgmt_FileStoreURL; $query = addslashes($query); if (empty($type)) { $type = 'all'; } // Bail if we aren't supppose to do our search if ($type <> 'all' AND $type <> 'filemgmt') { $plugin_results = new Plugin(); $plugin_results->plugin_name = $LANG_FILEMGMT['plugin_name']; $plugin_results->searchlabel = $LANG_FILEMGMT['searchlabel']; return $plugin_results; } // Build search SQL $sql = "SELECT a.lid, a.lid, a.cid, a.title, url, submitter, comments, hits, UNIX_TIMESTAMP(date) as day, description "; $sql .= "FROM {$_FM_TABLES['filemgmt_filedetail']} a "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON b.cid=a.cid "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_filedesc']} c ON c.lid=a.lid "; $sql .= filemgmt_buildAccessSql('WHERE'); $sql .= " AND a.status > 0 "; $sql .= "AND ((comments like '%$query%' OR comments like '$query%' OR comments like '%$query') "; $sql .= "OR (a.title like '%$query%' OR a.title like '$query%' OR a.title like '%$query') "; $sql .= "OR (c.description like '%$query%' OR c.description like '$query%' OR c.description like '%$query')) "; if (!empty($datestart) && !empty($dateend)) { $delim = substr($datestart, 4, 1); $DS = explode($delim,$datestart); $DE = explode($delim,$dateend); $startdate = mktime(0,0,0,$DS[1],$DS[2],$DS[0]); $enddate = mktime(0,0,0,$DE[1],$DE[2],$DE[0]) + 3600; $sql .= "AND (UNIX_TIMESTAMP(date) BETWEEN '$startdate' AND '$enddate') "; } if (!empty($author)) { $sql .= "AND (submitter = '$author') "; } $sql .= "ORDER BY date desc"; // Perform search $result = DB_query($sql); // OK, now return coma delmited string of table header labels // Need to use language variables require_once($_CONF['path_system'] . 'classes/plugin.class.php'); $plugin_results = new Plugin(); $plugin_results->plugin_name = 'filemgmt'; $plugin_results->searchlabel = $LANG_FILEMGMT['searchlabel_results']; $plugin_results->addSearchHeading('Title'); $plugin_results->addSearchHeading('Description'); $plugin_results->addSearchHeading('Author'); $plugin_results->addSearchHeading('Downloads'); $plugin_results->num_searchresults = DB_numRows($result); // NOTE if any of your data items need to be links then add them here! // make sure data elements are in an array and in the same order as your // headings above! for ($i = 1; $i <= $plugin_results->num_searchresults; $i++) { $A = DB_fetchArray($result); $thetime = COM_getUserDateTimeFormat($A['day']); $url = $_CONF[site_url]. "/filemgmt/index.php?id=".$A['lid']; $row = array("{$A['title']}", wordwrap($A['description'],70,"
"), COM_getDisplayName($A['submitter']), $A['hits']); $plugin_results->addSearchResult($row); } $plugin_results->num_itemssearched = DB_count($_FM_TABLES['filemgmt_filedetail']); return $plugin_results; } /** * This will put an option for Filemgmt Admin in the command and control block on * moderation.php * */ function plugin_cclabel_filemgmt() { global $LANG_FILEMGMT, $_CONF; if (SEC_hasRights('filemgmt.edit')) { return array($LANG_FILEMGMT['plugin_name'],$_CONF['site_admin_url'] . '/plugins/filemgmt/index.php',$_CONF['site_url'] . '/filemgmt/images/filemgmt.jpg'); } else { return false; } } /** * Setup the user menu options for this plugin * */ function plugin_getuseroption_filemgmt() { global $_CONF, $_FM_TABLES, $LANG_FILEMGMT,$mydownloads_uploadselect; if (SEC_hasRights('filemgmt.upload') OR $mydownloads_uploadselect == 1) { return array($LANG_FILEMGMT['usermenu3'], $_CONF['site_url'] . '/filemgmt/submit.php'); } else { return false; } } /** * returns the administrative option for this plugin * * */ function plugin_getadminoption_filemgmt() { global $_CONF, $_FM_TABLES, $LANG_FILEMGMT; if (SEC_hasRights('filemgmt.edit')) { $result = DB_query("SELECT COUNT(*) FROM {$_FM_TABLES['filemgmt_filedetail']} WHERE status=0"); list($submittedfiles) = DB_fetchARRAY($result); return array($LANG_FILEMGMT['admin_menu'], $_CONF['site_admin_url'] . '/plugins/filemgmt/index.php', $submittedfiles); } } /** * Removes the datastructures for this plugin from the Geeklog database * This may get called by the install routine to undue anything created during the install. * Added check to see that plugin is first disabled. */ function plugin_uninstall_filemgmt($installCheck='') { global $LANG_FM00, $LANG_FILEMGMT, $_TABLES,$_FM_TABLES; $pi_name='filemgmt'; $FEATURES = array ('filemgmt.edit', 'filemgmt.user','filemgmt.upload'); $TABLES = array ('filemgmt_cat','filemgmt_filedetail','filemgmt_filedesc','filemgmt_brokenlinks','filemgmt_votedata','filemgmt_history'); // Check and see if plugin is still enabled - if so display warning and exit if ($installCheck != '' && DB_getItem($_TABLES['plugins'],'pi_enabled', 'pi_name = "' .$pi_name. '"')) { COM_errorLog("Plugin is installed and enabled. Disable first if you want to de-install it",1); $display = COM_siteHeader(); $display .= COM_startBlock($LANG_FM00['warning']); $display .= $LANG_FM00['enabled']; $display .= COM_endBlock(); $display .= COM_siteFooter(); echo $display; exit; } // Ok to proceed and delete plugin - Unregister the plugin with Geeklog COM_errorLog('Attempting to unregister the Forum plugin from Geeklog',1); DB_query("DELETE FROM {$_TABLES['plugins']} WHERE pi_name = 'filemgmt'",1); // Drop tables foreach($TABLES as $table) { $t = $_FM_TABLES["$table"]; COM_errorLog("Removing Table $t",1); DB_query("DROP TABLE $t",1); } // Remove the Admin group definition for this plugin $grp_id = DB_getItem($_TABLES['vars'], 'value', "name = '{$pi_name}_admingrp_id'"); COM_errorLog("Removing $pi_name Admin Group", 1); DB_query("DELETE FROM {$_TABLES['groups']} WHERE grp_id = $grp_id",1); DB_query("DELETE FROM {$_TABLES['vars']} WHERE name = '{$pi_name}_admingrp_id'"); COM_errorLog("Removing root users from Admin Group of $pi_name"); DB_query("DELETE FROM {$_TABLES['group_assignments']} WHERE ug_main_grp_id = $grp_id",1); // Remove User group definition for this plugin $grp_id = DB_getItem($_TABLES['vars'], 'value', "name = '{$pi_name}_usersgrp_id'"); COM_errorLog("Removing $pi_name User Group", 1); DB_query("DELETE FROM {$_TABLES['groups']} WHERE grp_id = $grp_id",1); DB_query("DELETE FROM {$_TABLES['vars']} WHERE name = '{$pi_name}_usersgrp_id'"); COM_errorLog("Removing root users from Users Group of $pi_name"); DB_query("DELETE FROM {$_TABLES['group_assignments']} WHERE ug_main_grp_id = $grp_id",1); // Remove all the associated features - access rights. The feature ID's were stored in the vars table during install. foreach ($FEATURES as $feature) { COM_errorLog("Removing $feature feature and rights to it",1); $feat_id = DB_getItem($_TABLES['features'], 'ft_id', "ft_name = '$feature'"); COM_errorLog("DELETE FROM {$_TABLES['access']} WHERE acc_ft_id = $feat_id"); DB_query("DELETE FROM {$_TABLES['access']} WHERE acc_ft_id = $feat_id",1); DB_query("DELETE FROM {$_TABLES['features']} WHERE ft_id = $feat_id",1); } DB_query("DELETE FROM {$_TABLES['comments']} WHERE type='filemgmt'"); COM_errorLog("Removing all comments for plugin $pi_name"); DB_query("DELETE FROM {$_TABLES['blocks']} WHERE phpblockfn='phpblock_NewDownloads'"); COM_errorLog("Removing block definition for plugin $pi_name"); COM_errorLog('...success',1); return true; } // Common function used to build group access SQL function filemgmt_buildAccessSql($clause='AND') { global $_TABLES,$_USER; if (DB_getItem($_TABLES['plugins'],'pi_version', "pi_name='filemgmt'") != 1.5) { return ''; } if (isset($_USER) AND $_USER['uid'] > 1) { $uid = $_USER['uid']; } else { $uid = 1; } $_GROUPS = SEC_getUserGroups($uid); $groupsql = ''; if (count($_GROUPS) == 1) { $groupsql .= " $clause grp_access = '" . current($_GROUPS) ."'"; } else { $groupsql .= " $clause grp_access IN (" . implode(',',array_values($_GROUPS)) .")"; } return $groupsql; } function plugin_getfeednames_filemgmt () { global $_FM_TABLES; $feeds = array (); $groupsql = filemgmt_buildAccessSql('WHERE'); $result = DB_query ("SELECT cid,title FROM {$_FM_TABLES['filemgmt_cat']} $groupsql ORDER BY title ASC"); $num = DB_numRows ($result); if ($num > 0) { $feeds[] = array ('id' => '0', 'name' => 'all files'); } for ($i = 0; $i < $num; $i++) { $A = DB_fetchArray ($result); $feeds[] = array ('id' => $A['cid'], 'name' => $A['title']); } return $feeds; } function filemgmt_buildSql ($topic, $limits) { $where = ''; if ($topic > 0) { $where = 'cid=' . $topic; } $limitsql = ''; if (!empty ($limits)) { if (substr ($limits, -1) == 'h') { // last xx hours $limitsql = ''; $hours = substr ($limits, 0, -1); if (!empty ($where)) { $where .= ' AND '; } $where .= "date >= DATE_SUB(NOW(),INTERVAL $hours HOUR)"; } else { $limitsql = ' LIMIT ' . $limits; } } else { $limitsql = ' LIMIT 10'; } if (!empty ($where)) { $where = ' WHERE ' . $where; } $sql = $where . $limitsql; return $sql; } function plugin_getfeedcontent_filemgmt ($feed, &$link, &$update) { global $_CONF, $_TABLES, $_FM_TABLES; $content = array (); $lids = array (); $result = DB_query ("SELECT topic,limits FROM {$_TABLES['syndication']} WHERE fid = $feed"); $F = DB_fetchArray ($result); $sql = "SELECT lid,title,submitter,date FROM {$_FM_TABLES['filemgmt_filedetail']}" . filemgmt_buildSql ($F['topic'], $F['limits']); $result = DB_query ($sql); $num = DB_numRows ($result); for ($i = 0; $i < $num; $i++) { $A = DB_fetchArray ($result); $desc = DB_getItem ($_FM_TABLES['filemgmt_filedesc'], 'description', "lid = {$A['lid']}"); $filelink = $_CONF['site_url'] . '/filemgmt/index.php?id=' . $A['lid']; $content[] = array ('title' => $A['title'], 'text' => $desc, 'link' => $filelink, 'uid' => $A['submitter'], 'date' => $A['date'], 'format' => 'text' ); $lids[] = $A['lid']; } if ($F['topic'] == 0) { $link = $_CONF['site_url'] . '/filemgmt/index.php'; } else { $link = $_CONF['site_url'] . '/filemgmt/viewcat.php?cid=' . $F['topic']; } $update = implode (',', $lids); return $content; } function plugin_feedupdatecheck_filemgmt ($feed, $topic, $update_data, $limit) { global $_FM_TABLES; $is_current = true; $sql = "SELECT lid FROM {$_FM_TABLES['filemgmt_filedetail']}" . filemgmt_buildSql ($topic, $limits); $result = DB_query ($sql); $num = DB_numRows ($result); $lids = array (); for ($i = 0; $i < $num; $i++) { $A = DB_fetchArray ($result); $lids[] = $A['lid']; } $current = implode (',', $lids); return ( $current != $update_data ) ? false : true; } /** * Whats New Block API Support * Return the Headline and Byline for the new section in the Whatsnew Block */ function plugin_whatsnewsupported_filemgmt() { global $_CONF, $LANG_FM00,$mydownloads_whatsnew,$filemgmtWhatsNewPeriodDays; if ($mydownloads_whatsnew == 1) { return array( $LANG_FM00['WhatsNewLabel'], sprintf($LANG_FM00['WhatsNewPeriod'], $filemgmtWhatsNewPeriodDays) ); } else { return false; } } /** * API function provides the content of our "What's New" feed */ function plugin_getwhatsnew_filemgmt() { global $_TABLES, $_FM_TABLES, $_CONF, $LANG_FILEMGMT, $LANG01; global $filemgmtWhatsNewTitleLength,$filemgmtWhatsNewPeriodDays,$filemgmt_showWhatsNewComments; $items = array(); if (SEC_hasRights('filemgmt.user') OR $mydownloads_publicpriv == 1) { $sql = "SELECT a.lid, a.title FROM {$_FM_TABLES['filemgmt_filedetail']} a "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid "; $sql .= "WHERE date >= UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL $filemgmtWhatsNewPeriodDays DAY )) "; $sql .= filemgmt_buildAccessSql(); $sql .= "AND STATUS=1 ORDER BY date DESC LIMIT 15 "; $result = DB_query( $sql ); $nrows1 = DB_numRows( $result ); if( $nrows1 == 0 ) { $retval .= $LANG_FILEMGMT['no_new_files'] . '
' . LB; } else { for( $i = 0; $i < $nrows1; $i++ ) { list($lid, $title) = DB_fetchArray( $result ); $str = ""; $str .= stripslashes(substr($title,0,$filemgmtWhatsNewTitleLength)); $str .= ''; $items[] = $str; } } if ($filemgmt_showWhatsNewComments) { // Search for new comments $sql = "SELECT a.lid,c.title FROM {$_FM_TABLES['filemgmt_filedetail']} a "; $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid "; $sql .= "LEFT JOIN {$_TABLES['comments']} c ON c.sid = concat('fileid_' ,a.lid )"; $sql .= filemgmt_buildAccessSql('WHERE'); $sql .= " AND c.date >= DATE_SUB(NOW(), INTERVAL $filemgmtWhatsNewPeriodDays DAY ) AND c.type='filemgmt' "; $sql .= "GROUP BY c.sid ORDER BY c.date DESC LIMIT 15 "; $result = DB_query($sql); $nrows2 = DB_numRows( $result ); if( $nrows2 == 0 ) { $retval .= $LANG_FILEMGMT['no_comments'] . '
' . LB; } else { for( $i = 0; $i < $nrows2; $i++ ) { list($lid, $title) = DB_fetchArray( $result ); $titleLength = $filemgmtWhatsNewTitleLength + 13; // Compensate for the added HTML $title = "C: ".$title; $str = ""; $str .= stripslashes(substr($title,0,$titleLength)); $str .= ''; $items[] = $str; } } } if ($nrows1 == 0 and $nrows2 == 0) { return $retval; } else { return $items; } } else { return $items; } } /** * Implements the [file:] autotag. * */ function plugin_autotags_filemgmt ($op, $content = '', $autotag = '') { global $_CONF, $_FM_TABLES; if ($op == 'tagname' ) { return 'file'; } else if ($op == 'parse') { $file_id = COM_applyFilter ($autotag['parm1']); $url = COM_buildUrl ($_CONF['site_url'] . '/filemgmt/index.php?id=' . $file_id); if (empty ($autotag['parm2'])) { $linktext = stripslashes (DB_getItem ($_FM_TABLES['filemgmt_filedetail'], 'title', "lid = '$file_id'")); } else { $linktext = $autotag['parm2']; } $link = '' . $linktext . ''; $content = str_replace ($autotag['tagstr'], $link, $content); return $content; } } /* GLMENU USE ONLY API FUNCTIONS */ /* Function can be used in a Menuitem of type "PHP Function" * It will generate the menuitems and submenus for your filemgmt plugin * Works with the function plugin_glMenuCreateMenus_filemgmt() */ function glmenu_filemgmt() { global $_CONF,$_FM_TABLES,$CONF_FILEMGMT; $menu_location = $CONF_FILEMGMT['glmenutype']; $retval = ''; $sql = "SELECT cid,pid,title FROM {$_FM_TABLES['filemgmt_cat']} WHERE pid = 0 "; $sql .= filemgmt_buildAccessSql('AND') . ' ORDER BY cid'; $q1 = DB_query($sql); while (list($cid,$pid,$title) = DB_fetchArray($q1)) { $retval .= 'aI("image='.$_CONF['layout_url'] .'/glmenu/images/folder.gif;text='.$title.';showmenu=filemgmt-'.$cid.';url='.$_CONF['site_url'].'/filemgmt/viewcat.php?cid='.$cid.';");'; } return $retval; } /* GL-Menu API function to generate requires Milonic Javascript functions */ function plugin_glMenuCreateMenus_filemgmt() { global $_CONF,$_FM_TABLES,$CONF_GLMENU,$CONF_FILEMGMT,$_FMDOWNLOAD; /* Generate the JS Menu Functions that are needed for the Content Editor submenus */ $menu_location = $CONF_FILEMGMT['glmenutype']; $retval .= ''; $groupsql = filemgmt_buildAccessSql('WHERE'); $sql = "SELECT cid,pid,title FROM {$_FM_TABLES['filemgmt_cat']} $groupsql ORDER BY cid"; $q1 = DB_query($sql); while (list($cid,$pid,$title) = DB_fetchArray($q1)) { $menudata = ''; $retval .= ' with(milonic=new menuname("filemgmt-'.$cid.'")) {'; if ($menu_location == 'block') { $retval .= 'style='.$CONF_GLMENU['blockmenustyle'] .';'; } else { $retval .= 'style='.$CONF_GLMENU['headersubmenustyle'] .';'; } /* Find and sub categories - that will be submenus */ $q2 = DB_query("SELECT cid,pid,title FROM {$_FM_TABLES['filemgmt_cat']} $groupsql AND pid='{$cid}' "); while (list ($subcid,$subpid,$subtitle) = DB_fetchArray($q2)) { $menudata .= 'aI("image='.$_CONF['layout_url'] .'/glmenu/images/folder.gif;text='.$subtitle.';showmenu=filemgmt-'.$subcid.';url='.$_CONF['site_url'].'/filemgmt/viewcat.php?cid='.$subcid.';");'; } /* Show any links for files that are in this category */ $q3 = DB_query("SELECT lid,title,url FROM {$_FM_TABLES['filemgmt_filedetail']} WHERE cid='{$cid}'"); while (list ($fileid,$filename,$url) = DB_fetchArray($q3)) { $pos = strrpos($url,'.') + 1; $ext = strtolower(substr($url, $pos)); if (array_key_exists($ext, $_FMDOWNLOAD['inconlib'] )) { $icon = "{$_CONF['layout_url']}/glmenu/images/{$_FMDOWNLOAD['inconlib'][$ext]}"; } else { $icon = "{$_CONF['layout_url']}/glmenu/images/{$_FMDOWNLOAD['inconlib']['none']}"; } $menudata .= 'aI("image='.$icon.';text='.$filename.';url='.$_CONF['site_url'].'/filemgmt/singlefile.php?lid='.$fileid.';");'; } if ($menudata != '') { $retval .= $menudata; } $retval .= '}'; } return $retval; } ?>