|
Re: Ajouter un champ au module News |
|
Semi pro
Inscrit: 10/11/2004 13:40
|
Bonjour Irishcofee,
as tu réussi à rajouter le champ souhaité ?
Posté le : 14/12/2009 16:13
|
PS : Toujours faire une sauvegarde des fichiers avant de les modifier !------------------------------------------- http://www.aideordi.com
|
|
Re: Ajouter un champ au module News |
|
Régulier
Inscrit: 22/03/2006 10:49
|
et non :( je vais lacher l'affaire et mettre en ligne ma rubrique sans ca pour l'instant.
mais si quelqu'un trouve la solution, je suis preneur
Posté le : 23/12/2009 14:36
|
|
|
Re: Ajouter un champ au module News |
|
Semi pro
Inscrit: 10/11/2004 13:40
|
Salut Irishcofee peut être ça pourra t'aider, j'ai rajouté le champ price dans la bdd à la fin de la table, je te mets les fichiers complets modifiés, tu recherches l'occurence price pour voir où sont les modifs, testes bien la soumission , l'édition etc... regardes bien du coté de la table que les enregistrements soient bien faits modules/news/article.php
<?php
// $Id: article.php,v 1.15 2004/09/02 17:04:07 hthouzard Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> ... nbsp; //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
/**
* Article's page
*
* This page is used to see an article (or story) and is mainly called from
* the module's index page.
*
* If no story Id has been placed on the URL or if the story is not yet published
* then the page will redirect user to the module's index.
* If the user does not have the permissions to see the article, he is also redirected
* to the module's index page but with a error message saying :
* "Sorry, you don't have the permission to access this area"
*
* Each time a page is seen, and only if we are on the first page, its counter of hits is
* updated
*
* Each file(s) attached to the article is visible at the bottom of the article and can
* be downloaded
*
* Notes :
* - To create more than one page in your story, use the tag [pagebreak]
* - If you are a module's admin, you have the possibility to see two links at the bottom
* of the article, "Edit & Delete"
*
* @package News
* @author Xoops Modules Dev Team
* @copyright (c) The Xoops Project - www.xoops.org
*
* Parameters received by this page :
* @param int storyid Id of the story we want to see
* @param int page page's number (in the case where there are more than one page)
*
* @page_title Article's title - Topic's title - Module's name
*
* @template_name news_article.html wich will call news_item.html
*
* Template's variables :
* @template_var string pagenav some links to navigate thru pages
* @template_var array story Contains all the information about the story
* Structure :
* @template_var int id Story's ID
* @template_var string posttime Story's date of publication
* @template_var string title A link to go and see all the articles in the same topic and the story's title
* @template_var string news_title Just the news title
* @template_var string topic_title Just the topic's title
* @template_var string text Defined as "The scoop"
* @template_var string poster A link to see the author's profil and his name or "Anonymous"
* @template_var int posterid Author's uid (or 0 if it's an anonymous or a user wich does not exist any more)
* @template_var string morelink Never used ???? May be it could be deleted
* @template_var string adminlink A link to Edit or Delete the story or a blank string if you are not the module's admin
* @template_var string topicid News topic's Id
* @template_var string topic_color Topic's color
* @template_var string imglink A link to go and see the topic of the story with the topic's picture (if it exists)
* @template_var string align Topic's image alignement
* @template_var int hits Story's counter of visits
* @template_var string mail_link A link (with a mailto) to email the story's URL to someone
* @template_var string lang_printerpage Used in the link and picture to have a "printable version" (fixed text)
* @template_var string lang_on Fixed text "On" ("published on")
* @template_var string lang_postedby Fixed text "Posted by"
* @template_var string lang_reads Fixed text "Reads"
* @template_var string news_by_the_same_author_link According the the module's option named "newsbythisauthor", it contains a link to see all the article's stories
* @template_var int summary_count Number of stories really visibles in the summary table
* @template_var boolean showsummary According to the module's option named "showsummarytable", this contains "True" of "False"
* @template_var array summary Contains the required information to create a summary table at the bottom of the article. Note, we use the module's option "storyhome" to determine the maximum number of stories visibles in this summary table
* Structure :
* @template_var int story_id Story's ID
* @template_var string story_title Story's title
* @template_var int story_hits Counter of hits
* @template_var string story_published Story's date of creation
* @template_var string lang_attached_files Fixed text "Attached Files:"
* @template_var int attached_files_count Number of files attached to the story
* @template_var array attached_files Contains the list of all the files attached to the story
* Structure :
* @template_var int file_id File's ID
* @template_var string visitlink Link to download the file
* @template_var string file_realname Original filename (not the real one use to store the file but the one it have when it was on the user hard disk)
* @template_var string file_attacheddate Date to wich the file was attached to the story (in general that's equal to the article's creation date)
* @template_var string file_mimetype File's mime type
* @template_var string file_downloadname Real name of the file on the webserver's disk (changed by the module)
* @template_var boolean nav_links According to the module's option named "showprevnextlink" it contains "True" or "False" to know if we have to show two links to go to the previous and next article
* @template_var int previous_story_id Id of the previous story (according to the published date and to the perms)
* @template_var int next_story_id Id of the next story (according to the published date and to the perms)
* @template_var string previous_story_title Title of the previous story
* @template_var string next_story_title Title of the next story
* @template_var string lang_previous_story Fixed text "Previous article"
* @template_var string lang_next_story Fixed text "Next article"
* @template_var string lang_other_story Fixed text "Other articles"
* @template_var boolean rates To know if rating is enable or not
* @template_var string lang_ratingc Fixed text "Rating: "
* @template_var string lang_ratethisnews Fixed text "Rate this News"
* @template_var float rating Article's rating
* @template_var string votes "1 vote" or "X votes"
* @template_var string topic_path A path from the root to the current topic (of the current news)
*/
include_once '../../mainfile.php';
include_once XOOPS_ROOT_PATH.'/modules/news/class/class.newsstory.php';
include_once XOOPS_ROOT_PATH.'/modules/news/class/class.sfiles.php';
include_once XOOPS_ROOT_PATH.'/class/xoopstree.php';
include_once XOOPS_ROOT_PATH.'/modules/news/include/functions.php';
include_once XOOPS_ROOT_PATH.'/modules/news/class/class.newstopic.php';
include_once XOOPS_ROOT_PATH.'/modules/news/class/keyhighlighter.class.php';
include_once XOOPS_ROOT_PATH.'/modules/news/config.php';
$storyid = (isset($_GET['storyid'])) ? intval($_GET['storyid']) : 0;
if (empty($storyid)) {
redirect_header(XOOPS_URL.'/modules/news/index.php',2,_NW_NOSTORY);
exit();
}
$myts =& MyTextSanitizer::getInstance();
// Not yet published
$article = new NewsStory($storyid);
if ( $article->published() == 0 || $article->published() > time() ) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 2, _NW_NOTYETSTORY);
exit();
}
// Expired
if ( $article->expired() != 0 && $article->expired() < time() ) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 2, _NW_NOSTORY);
exit();
}
$gperm_handler =& xoops_gethandler('groupperm');
if (is_object($xoopsUser)) {
$groups = $xoopsUser->getGroups();
} else {
$groups = XOOPS_GROUP_ANONYMOUS;
}
if (!$gperm_handler->checkRight('news_view', $article->topicid(), $groups, $xoopsModule->getVar('mid'))) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 3, _NOPERM);
exit();
}
$storypage = isset($_GET['page']) ? intval($_GET['page']) : 0;
$dateformat = news_getmoduleoption('dateformat');
$hcontent='';
/**
* update counter only when viewing top page and when you are not the author or an admin
*/
if (empty($_GET['com_id']) && $storypage == 0) {
if(is_object($xoopsUser)) {
if( ($xoopsUser->getVar('uid')==$article->uid()) || news_is_admin_group()) {
// nothing ! ;-)
} else {
$article->updateCounter();
}
} else {
$article->updateCounter();
}
}
$xoopsOption['template_main'] = 'news_article.html';
include_once XOOPS_ROOT_PATH.'/header.php';
//ajout champ price
$story['price'] = $article->price();
$story['id'] = $storyid;
$story['posttime'] = formatTimestamp($article->published(),$dateformat);
$story['news_title'] = $article->title();
$story['title'] = $article->textlink().' : '.$article->title();
$story['topic_title'] = $article->textlink();
$story['text'] = $article->hometext();
$bodytext = $article->bodytext();
if (xoops_trim($bodytext) != '') {
$articletext = array();
if(news_getmoduleoption('enhanced_pagenav')) {
$articletext = preg_split('/([pagebreak:|[pagebreak)(.*)(])/iU', $bodytext);
$arr_titles = array();
$auto_summary = $article->auto_summary($bodytext, $arr_titles);
$bodytext = str_replace('[summary]', $auto_summary, $bodytext);
$articletext[$storypage] = str_replace('[summary]', $auto_summary, $articletext[$storypage]);
$story['text'] = str_replace('[summary]', $auto_summary, $story['text']);
} else {
$articletext = explode('[pagebreak]', $bodytext);
}
$story_pages = count($articletext);
if ($story_pages > 1) {
include_once XOOPS_ROOT_PATH.'/modules/news/include/pagenav.php';
$pagenav = new XoopsPageNav($story_pages, 1, $storypage, 'page', 'storyid='.$storyid);
if(news_isbot()) { // A bot is reading the articles, we are going to show him all the links to the pages
$xoopsTpl->assign('pagenav', $pagenav->renderNav($story_pages));
} else {
if(news_getmoduleoption('enhanced_pagenav')) {
$xoopsTpl->assign('pagenav', $pagenav->renderEnhancedSelect(true, $arr_titles));
} else {
$xoopsTpl->assign('pagenav', $pagenav->renderNav());
}
}
if ($storypage == 0) {
$story['text'] = $story['text'].'<br />'.news_getmoduleoption('advertisement').'<br />'.$articletext[$storypage];
} else {
$story['text'] = $articletext[$storypage];
}
} else {
$story['text'] = $story['text'].'<br />'.news_getmoduleoption('advertisement').'<br />'.$bodytext;
}
}
// Publicité
$xoopsTpl->assign('advertisement', news_getmoduleoption('advertisement'));
// ****************************************************************************************************************
function my_highlighter ($matches) {
$color = news_getmoduleoption('highlightcolor');
if(substr($color,0,1)!='#') {
$color='#'.$color;
}
return '<span style="font-weight: bolder; background-color: '.$color.';">' . $matches[0] . '</span>';
}
$highlight = false;
$highlight = news_getmoduleoption('keywordshighlight');
if($highlight && isset($_GET['keywords']))
{
$keywords=$myts->htmlSpecialChars(trim(urldecode($_GET['keywords'])));
$h= new keyhighlighter ($keywords, true , 'my_highlighter');
$story['text'] = $h->highlight($story['text']);
}
// ****************************************************************************************************************
$story['poster'] = $article->uname();
if ( $story['poster'] ) {
$story['posterid'] = $article->uid();
$story['poster'] = '<a href="'.XOOPS_URL.'/userinfo.php?uid='.$story['posterid'].'">'.$story['poster'].'</a>';
$tmp_user = new XoopsUser($article->uid());
$story['poster_avatar'] = XOOPS_UPLOAD_URL.'/'.$tmp_user->getVar('user_avatar');
$story['poster_signature'] = $tmp_user->getVar('user_sig');
$story['poster_email'] = $tmp_user->getVar('email');
$story['poster_url'] = $tmp_user->getVar('url');
$story['poster_from'] = $tmp_user->getVar('user_from');
unset($tmp_user);
} else {
$story['poster'] = '';
$story['posterid'] = 0;
$story['poster_avatar'] = '';
$story['poster_signature'] = '';
$story['poster_email'] = '';
$story['poster_url'] = '';
$story['poster_from'] = '';
if(news_getmoduleoption('displayname')!=3) {
$story['poster'] = $xoopsConfig['anonymous'];
}
}
$story['morelink'] = '';
$story['adminlink'] = '';
unset($isadmin);
if(is_object($xoopsUser)) {
if( $xoopsUser->isAdmin($xoopsModule->getVar('mid')) || (news_getmoduleoption('authoredit') && $article->uid() == $xoopsUser->getVar('uid')) ) {
$isadmin = true;
$story['adminlink'] = $article->adminlink();
}
}
$story['topicid'] = $article->topicid();
$story['topic_color'] = '#'.$myts->displayTarea($article->topic_color);
$story['imglink'] = '';
$story['align'] = '';
if ( $article->topicdisplay() ) {
$story['imglink'] = $article->imglink();
$story['align'] = $article->topicalign();
}
$story['hits'] = $article->counter();
$story['mail_link'] = 'mailto:?subject='.sprintf(_NW_INTARTICLE,$xoopsConfig['sitename']).'&body='.sprintf(_NW_INTARTFOUND, $xoopsConfig['sitename']).': '.XOOPS_URL.'/modules/news/article.php?storyid='.$article->storyid();
$xoopsTpl->assign('lang_printerpage', _NW_PRINTERFRIENDLY);
$xoopsTpl->assign('lang_sendstory', _NW_SENDSTORY);
$xoopsTpl->assign('lang_pdfstory', _NW_MAKEPDF);
$xoopsTpl->assign('lang_on', _ON);
$xoopsTpl->assign('lang_postedby', _POSTEDBY);
$xoopsTpl->assign('lang_reads', _READS);
$xoopsTpl->assign('mail_link', 'mailto:?subject='.sprintf(_NW_INTARTICLE,$xoopsConfig['sitename']).'&body='.sprintf(_NW_INTARTFOUND, $xoopsConfig['sitename']).': '.XOOPS_URL.'/modules/news/article.php?storyid='.$article->storyid());
$xoopsTpl->assign('lang_attached_files',_NW_ATTACHEDFILES);
$sfiles = new sFiles();
$filesarr = $newsfiles = array();
$filesarr=$sfiles->getAllbyStory($storyid);
$filescount=count($filesarr);
$xoopsTpl->assign('attached_files_count',$filescount);
if($filescount>0) {
foreach ($filesarr as $onefile) {
$newsfiles[]=Array('file_id'=>$onefile->getFileid(), 'visitlink' => XOOPS_URL.'/modules/news/visit.php?fileid='.$onefile->getFileid(),'file_realname'=>$onefile->getFileRealName(), 'file_attacheddate'=>formatTimestamp($onefile->getDate(),$dateformat), 'file_mimetype'=>$onefile->getMimetype(), 'file_downloadname'=>XOOPS_UPLOAD_URL.'/'.$onefile->getDownloadname());
}
$xoopsTpl->assign('attached_files',$newsfiles);
}
/**
* Create page's title
*/
$complement = '';
if(news_getmoduleoption('enhanced_pagenav') && (isset($arr_titles) && is_array($arr_titles) && isset($arr_titles,$storypage) && $storypage>0)) {
$complement = ' - '.$arr_titles[$storypage];
}
$xoopsTpl->assign('xoops_pagetitle', $article->title() . $complement. ' - ' . $article->topic_title() . ' - ' . $myts->htmlSpecialChars($xoopsModule->name()));
if(news_getmoduleoption('newsbythisauthor')) {
$xoopsTpl->assign('news_by_the_same_author_link',sprintf("<a href='%s?uid=%d'>%s</a>",XOOPS_URL.'/modules/news/newsbythisauthor.php',$article->uid(),_NW_NEWSSAMEAUTHORLINK));
}
/**
* Create a clickable path from the root to the current topic (if we are viewing a topic)
* Actually this is not used in the default's templates but you can use it as you want
* Uncomment the code to be able to use it
*/
if($cfg['create_clickable_path']) {
$mytree = new XoopsTree($xoopsDB->prefix('topics'),'topic_id','topic_pid');
$topicpath = $mytree->getNicePathFromId($article->topicid(), 'topic_title', 'index.php?op=1');
$xoopsTpl->assign('topic_path', $topicpath);
unset($mytree);
}
/**
* Summary table
*
* When you are viewing an article, you can see a summary table containing
* the first n links to the last published news.
* This summary table is visible according to a module's option (showsummarytable)
* The number of items is equal to the module's option "storyhome" ("Select the number
* of news items to display on top page")
* We also use the module's option "restrictindex" ("Restrict Topics on Index Page"), like
* this you (the webmaster) select if users can see restricted stories or not.
*/
if (news_getmoduleoption('showsummarytable')) {
$xoopsTpl->assign('showsummary', true);
$xoopsTpl->assign('lang_other_story',_NW_OTHER_ARTICLES);
$count=0;
$tmparticle = new NewsStory();
$infotips=news_getmoduleoption('infotips');
$sarray = $tmparticle->getAllPublished($cfg['article_summary_items_count'], 0, $xoopsModuleConfig['restrictindex']);
if(count($sarray)>0) {
foreach ($sarray as $onearticle) {
$count++;
$htmltitle='';
$tooltips='';
$htmltitle='';
if($infotips>0) {
$tooltips = news_make_infotips($onearticle->hometext());
$htmltitle=' title="'.$tooltips.'"';
}
$xoopsTpl->append('summary', array('story_id'=>$onearticle->storyid(), 'htmltitle'=>$htmltitle, 'infotips'=>$tooltips, 'story_title'=>$onearticle->title(), 'story_titleurl'=>elimina_acentos($onearticle->title()), 'story_hits'=>$onearticle->counter(), 'story_published'=>formatTimestamp($onearticle->published,$dateformat)));
}
}
$xoopsTpl->assign('summary_count',$count);
unset($tmparticle);
} else {
$xoopsTpl->assign('showsummary', false);
}
/**
* Show a link to go to the previous article and to the next article
*
* According to a module's option "showprevnextlink" ("Show Previous and Next link ?")
* you can display, at the bottom of each article, two links used to navigate thru stories.
* This feature uses the module's option "restrictindex" so that we can, or can't see
* restricted stories
*/
if (news_getmoduleoption('showprevnextlink')) {
$xoopsTpl->assign('nav_links', true);
$tmparticle = new NewsStory();
$nextId = $previousId = -1;
$next = $previous = array();
$previousTitle = $nextTitle = '';
$next = $tmparticle->getNextArticle($storyid, $xoopsModuleConfig['restrictindex']);
if(count($next) > 0) {
$nextId = $next['storyid'];
$nextTitle = $next['title'];
}
$previous = $tmparticle->getPreviousArticle($storyid, $xoopsModuleConfig['restrictindex']);
if(count($previous) > 0) {
$previousId = $previous['storyid'];
$previousTitle = $previous['title'];
}
$xoopsTpl->assign('previous_story_id',$previousId);
$xoopsTpl->assign('next_story_id',$nextId);
if($previousId > 0) {
$xoopsTpl->assign('previous_story_title',$previousTitle);
$hcontent.=sprintf("<link rel="Prev" title="%s" href="%s/" />n", $previousTitle,XOOPS_URL.'/modules/news/article.php?storyid='.$previousId);
}
if($nextId > 0) {
$xoopsTpl->assign('next_story_title',$nextTitle);
$hcontent.=sprintf("<link rel="Next" title="%s" href="%s/" />n", $nextTitle,XOOPS_URL.'/modules/news/article.php?storyid='.$nextId);
}
$xoopsTpl->assign('lang_previous_story',_NW_PREVIOUS_ARTICLE);
$xoopsTpl->assign('lang_next_story',_NW_NEXT_ARTICLE);
unset($tmparticle);
} else {
$xoopsTpl->assign('nav_links', false);
}
/**
* Manage all the meta datas
*/
news_CreateMetaDatas($article);
/**
* Show a "Bookmark this article at these sites" block ?
*/
if(news_getmoduleoption('bookmarkme')) {
$xoopsTpl->assign('bookmarkme', true);
$xoopsTpl->assign('encoded_title', rawurlencode($article->title()));
} else {
$xoopsTpl->assign('bookmarkme', false);
}
/**
* Enable users to vote
*
* According to a module's option, "ratenews", you can display a link to rate the current news
* The actual rate in showed (and the number of votes)
* Possible modification, restrict votes to registred users
*/
$other_test = true;
if($cfg['config_rating_registred_only']) {
if(isset($xoopsUser) && is_object($xoopsUser)) {
$other_test = true;
} else {
$other_test = false;
}
}
if (news_getmoduleoption('ratenews') && $other_test) {
$xoopsTpl->assign('rates', true);
$xoopsTpl->assign('lang_ratingc', _NW_RATINGC);
$xoopsTpl->assign('lang_ratethisnews', _NW_RATETHISNEWS);
$story['rating'] = number_format($article->rating(), 2);
if ($article->votes == 1) {
$story['votes'] = _NW_ONEVOTE;
} else {
$story['votes'] = sprintf(_NW_NUMVOTES,$article->votes);
}
} else {
$xoopsTpl->assign('rates', false);
}
$xoopsTpl->assign('story', $story);
if ( strpos( $_SERVER['HTTP_USER_AGENT'], 'Googlebot' ) !== false )
{
$xoopsTpl->assign('newsbot',"true");
}
///////////
if (defined('news_seo_enable')) {
$xoopsTpl->assign('urlrewrite', true);
$direurl = elimina_acentos($article->title());
$previousurl = elimina_acentos($previous['title']);
$nexturl = elimina_acentos($next['title']);
$xoopsTpl->assign('direurl', $direurl);
$xoopsTpl->assign('previousdireurl', $previousurl);
$xoopsTpl->assign('nextdireurl', $nexturl);
//$xoopsTpl->assign('story_title', $onearticle->title());
} else {
$xoopsTpl->assign('urlrewrite', false);
}
/////////////////////
// Added in version 1.63, TAGS
if(news_getmoduleoption('tags')) {
require_once XOOPS_ROOT_PATH.'/modules/tag/include/tagbar.php';
$xoopsTpl->assign('tags', true);
$xoopsTpl->assign('tagbar', tagBar($storyid, 0));
} else {
$xoopsTpl->assign('tags', false);
}
include_once XOOPS_ROOT_PATH.'/include/comment_view.php';
$NEWS_URL = XOOPS_URL.'/modules/news/';
$xoopsTpl->assign(array('editcomment_link' => XOOPS_URL.'/modules/news/' . 'comment_edit.php?com_itemid='.$com_itemid.'&com_order='.$com_order.'&com_mode='.$com_mode.''.$link_extra, 'deletecomment_link' => XOOPS_URL.'/modules/news/' . 'comment_delete.php?com_itemid='.$com_itemid.'&com_order='.$com_order.'&com_mode='.$com_mode.''.$link_extra, 'replycomment_link' => XOOPS_URL.'/modules/news/' . 'comment_reply.php?com_itemid='.$com_itemid.'&com_order='.$com_order.'&com_mode='.$com_mode.''.$link_extra));
$xoopsTpl->_tpl_vars['commentsnav'] = str_replace("self.location.href='", "self.location.href='" . $NEWS_URL, $xoopsTpl->_tpl_vars['commentsnav']);
$xoopsTpl->_tpl_vars['commentsnav'] = str_replace("article.php", $NEWS_URL. "article.php" , $xoopsTpl->_tpl_vars['commentsnav']);
include_once XOOPS_ROOT_PATH.'/footer.php';
?>
Posté le : 23/12/2009 15:40
|
PS : Toujours faire une sauvegarde des fichiers avant de les modifier !------------------------------------------- http://www.aideordi.com
|
|
Re: Ajouter un champ au module News |
|
Semi pro
Inscrit: 10/11/2004 13:40
|
modules/news/submit.php
<?php
// $Id: submit.php,v 1.23 2004/09/01 17:48:07 hthouzard Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> ... nbsp; //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
if (!defined('XOOPS_ROOT_PATH')) {
include_once '../../mainfile.php';
}
include_once XOOPS_ROOT_PATH.'/modules/news/class/class.newsstory.php';
include_once XOOPS_ROOT_PATH.'/modules/news/class/class.sfiles.php';
include_once XOOPS_ROOT_PATH.'/modules/news/class/class.newstopic.php';
include_once XOOPS_ROOT_PATH.'/class/uploader.php';
include_once XOOPS_ROOT_PATH.'/header.php';
include_once XOOPS_ROOT_PATH.'/modules/news/include/functions.php';
if (file_exists(XOOPS_ROOT_PATH.'/modules/news/language/'.$xoopsConfig['language'].'/admin.php')) {
include_once XOOPS_ROOT_PATH.'/modules/news/language/'.$xoopsConfig['language'].'/admin.php';
} else {
include_once XOOPS_ROOT_PATH.'/modules/news/language/english/admin.php';
}
$myts =& MyTextSanitizer::getInstance();
$module_id = $xoopsModule->getVar('mid');
$storyid=0;
if (is_object($xoopsUser)) {
$groups = $xoopsUser->getGroups();
} else {
$groups = XOOPS_GROUP_ANONYMOUS;
}
$gperm_handler =& xoops_gethandler('groupperm');
if (isset($_POST['topic_id'])) {
$perm_itemid = intval($_POST['topic_id']);
} else {
$perm_itemid = 0;
}
//If no access
if (!$gperm_handler->checkRight('news_submit', $perm_itemid, $groups, $module_id)) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 3, _NOPERM);
exit();
}
$op = 'form';
//If approve privileges
$approveprivilege = 0;
if (is_object($xoopsUser) && $gperm_handler->checkRight('news_approve', $perm_itemid, $groups, $module_id)) {
$approveprivilege = 1;
}
if (isset($_POST['preview'])) {
$op = 'preview';
} elseif (isset($_POST['post'])) {
$op = 'post';
}
elseif ( isset($_GET['op']) && isset($_GET['storyid'])) {
// Verify that the user can edit or delete an article
if( $_GET['op'] == 'edit' || $_GET['op'] == 'delete' ) {
if($xoopsModuleConfig['authoredit']==1) {
$tmpstory = new NewsStory(intval($_GET['storyid']));
if(is_object($xoopsUser) && $xoopsUser->getVar('uid')!=$tmpstory->uid() && !news_is_admin_group()) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 3, _NOPERM);
exit();
}
} else { // Users can't edit their articles
if(!news_is_admin_group()) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 3, _NOPERM);
exit();
}
}
}
if ($approveprivilege && $_GET['op'] == 'edit') {
$op = 'edit';
$storyid = intval($_GET['storyid']);
}
elseif ($approveprivilege && $_GET['op'] == 'delete') {
$op = 'delete';
$storyid = intval($_GET['storyid']);
}
else {
if(news_getmoduleoption('authoredit') && is_object($xoopsUser) && isset($_GET['storyid']) && ($_GET['op']=='edit' || $_POST['op']=='preview' || $_POST['op']=='post')) {
$storyid=0;
$storyid = isset($_GET['storyid']) ? intval($_GET['storyid']) : intval($_POST['storyid']);
if(!empty($storyid)) {
$tmpstory = new NewsStory($storyid);
if($tmpstory->uid()==$xoopsUser->getVar('uid')) {
$op= isset($_GET['op']) ? $_GET['op'] : $_POST['post'];
unset($tmpstory);
$approveprivilege=1;
} else {
unset($tmpstory);
if(!news_is_admin_group()) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 3, _NOPERM);
exit();
} else {
$approveprivilege=1;
}
}
}
} else {
if(!news_is_admin_group()) {
unset($tmpstory);
redirect_header(XOOPS_URL.'/modules/news/index.php', 3, _NOPERM);
exit();
} else {
$approveprivilege=1;
}
}
}
}
switch ($op) {
case 'edit':
if (!$approveprivilege) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 0, _NOPERM);
exit();
break;
}
//if($storyid==0 && isset($_POST['storyid'])) {
// $storyid=intval($_POST['storyid']);
//}
$story = new NewsStory($storyid);
if (!$gperm_handler->checkRight('news_view', $story->topicid(), $groups, $module_id)) {
redirect_header(XOOPS_URL.'/modules/news/index.php', 0, _NOPERM);
exit();
}
echo"<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class="odd">";
echo '<h4>' . _AM_EDITARTICLE . '</h4>';
$title = $story->title('Edit');
$hometext = $story->hometext('Edit');
$bodytext = $story->bodytext('Edit');
$nohtml = $story->nohtml();
$nosmiley = $story->nosmiley();
$description = $story->description();
$keywords = $story->keywords();
//ajout champ price
$price = $story->price('Edit');
$ihome = $story->ihome();
$newsauthor=$story->uid();
$topicid = $story->topicid();
$notifypub=$story->notifypub();
$approve = 0;
$published = $story->published();
if (isset($published) && $published > 0) {
$approve = 1;
}
if ( $story -> published() != 0) {
$published = $story->published();
}
if ( $story -> expired() != 0) {
$expired = $story->expired();
} else {
$expired = 0;
}
$type = $story -> type();
$topicdisplay = $story -> topicdisplay();
$topicalign = $story -> topicalign( false );
include_once XOOPS_ROOT_PATH.'/modules/news/include/storyform.inc.php';
echo'</td></tr></table>';
break;
case 'preview':
$topic_id = intval($_POST['topic_id']);
$xt = new NewsTopic($topic_id);
if(isset($_GET['storyid'])) {
$storyid=intval($_GET['storyid']);
} else {
if(isset($_POST['storyid'])) {
$storyid=intval($_POST['storyid']);
} else {
$storyid=0;
}
}
if (!empty($storyid)) {
$story = new NewsStory($storyid);
$published = $story -> published();
$expired = $story -> expired();
} else {
$story = new NewsStory();
$published = isset($_POST['publish_date']) ? $_POST['publish_date'] : 0;
if(!empty($published) && isset($_POST['autodate']) && intval($_POST['autodate']==1)) {
$published=strtotime($published['date']) + $published['time'];
} else {
$published=0;
}
$expired= isset($_POST['expiry_date']) ? $_POST['expiry_date'] : 0;
if(!empty($expired) && isset($_POST['autoexpdate']) && intval($_POST['autoexpdate']==1)) {
$expired=strtotime($expired['date']) + $expired['time'];
} else {
$expired=0;
}
}
$topicid = $topic_id;
if(isset($_POST['topicdisplay'])) {
$topicdisplay=intval($_POST['topicdisplay']);
} else {
$topicdisplay=1;
}
$approve = isset($_POST['approve']) ? intval($_POST['approve']) : 0;
$topicalign = 'R';
if(isset($_POST['topicalign'])) {
$topicalign=$_POST['topicalign'];
}
$story->setTitle($_POST['title']);
$story->setHometext($_POST['hometext']);
if ($approveprivilege) {
$story->setTopicdisplay($topicdisplay);
$story->setTopicalign($topicalign);
$story->setBodytext($_POST['bodytext']);
if(news_getmoduleoption('metadata')) {
$story->Setkeywords($_POST['keywords']);
$story->Setdescription($_POST['description']);
$story->setIhome(intval($_POST['ihome']));
}
} else {
$noname = isset($_POST['noname']) ? intval($_POST['noname']) : 0;
}
//ajout champ price
$story->setprice($_POST['price']);
if ($approveprivilege || (is_object($xoopsUser) && $xoopsUser->isAdmin($xoopsModule->mid()))) {
if(isset($_POST['author'])) {
$story->setUid(intval($_POST['author']));
}
}
$notifypub = isset($_POST['notifypub']) ? intval($_POST['notifypub']) : 0;
$nosmiley=isset($_POST['nosmiley']) ? intval($_POST['nosmiley']) : 0;
if (isset($nosmiley) && ($nosmiley == 0 || $nosmiley == 1)) {
$story -> setNosmiley($nosmiley);
} else {
$nosmiley = 0;
}
if ($approveprivilege) {
$nohtml = isset($_POST['nohtml']) ? intval($_POST['nohtml']) : 0;
$story->setNohtml($nohtml);
if (!isset($_POST['approve'])) {
$approve = 0;
}
} else {
$story->setNohtml = 1;
}
$title = $story->title('InForm');
$hometext = $story->hometext('InForm');
//ajout champ price
$price = $story->price('InForm');
if ($approveprivilege) {
$bodytext = $story->bodytext('InForm');
$ihome = $story -> ihome();
$description = $story->description('E');
$keywords = $story->keywords('E');
}
//Display post preview
$newsauthor=$story->uid();
$p_title = $story->title('Preview');
$p_hometext = $story->hometext('Preview');
if ($approveprivilege) {
$p_bodytext = $story->bodytext('Preview');
$p_hometext .= '<br /><br />'.$p_bodytext;
}
$topicalign2 = isset($story->topicalign) ? 'align="'.$story->topicalign().'"' : '';
$p_hometext = (($xt->topic_imgurl() != '') && $topicdisplay) ? '<img src="images/topics/'.$xt->topic_imgurl().'" '.$topicalign2.' alt="" />'.$p_hometext : $p_hometext;
themecenterposts($p_title, $p_hometext);
//Display post edit form
$returnside=intval($_POST['returnside']);
include_once XOOPS_ROOT_PATH.'/modules/news/include/storyform.inc.php';
break;
case 'post':
$nohtml_db = isset($_POST['nohtml']) ? $_POST['nohtml'] : 1;
if (is_object($xoopsUser) ) {
$uid = $xoopsUser->getVar('uid');
if ($approveprivilege) {
$nohtml_db = empty($_POST['nohtml']) ? 0 : 1;
}
if (isset($_POST['author']) && ($approveprivilege || $xoopsUser->isAdmin($xoopsModule->mid())) ) {
$uid=intval($_POST['author']);
}
} else {
$uid = 0;
}
if(isset($_GET['storyid'])) {
$storyid=intval($_GET['storyid']);
} else {
if(isset($_POST['storyid'])) {
$storyid=intval($_POST['storyid']);
} else {
$storyid=0;
}
}
if (empty($storyid)) {
$story = new NewsStory();
$editmode = false;
} else {
$story = new NewsStory($storyid);
$editmode = true;
}
$story->setUid($uid);
$story->setTitle($_POST['title']);
$story->setHometext($_POST['hometext']);
$story->setTopicId(intval($_POST['topic_id']));
$story->setHostname(xoops_getenv('REMOTE_ADDR'));
$story->setNohtml($nohtml_db);
$nosmiley = isset($_POST['nosmiley']) ? intval($_POST['nosmiley']) : 0;
$story->setNosmiley($nosmiley);
$notifypub = isset($_POST['notifypub']) ? intval($_POST['notifypub']) : 0;
$story->setNotifyPub($notifypub);
$story->setType($_POST['type']);
if (!empty( $_POST['autodate'] ) && $approveprivilege) {
$publish_date=$_POST['publish_date'];
$pubdate = strtotime($publish_date['date']) + $publish_date['time'];
//$offset = $xoopsUser -> timezone() - $xoopsConfig['server_TZ'];
//$pubdate = $pubdate - ( $offset * 3600 );
$story -> setPublished( $pubdate );
}
if (!empty( $_POST['autoexpdate'] ) && $approveprivilege) {
$expiry_date=$_POST['expiry_date'];
$expiry_date = strtotime($expiry_date['date']) + $expiry_date['time'];
$offset = $xoopsUser -> timezone() - $xoopsConfig['server_TZ'];
$expiry_date = $expiry_date - ( $offset * 3600 );
$story -> setExpired( $expiry_date );
} else {
$story -> setExpired( 0 );
}
//ajout champ price
$story->setprice($_POST['price']);
if ($approveprivilege) {
if(news_getmoduleoption('metadata')) {
$story->Setdescription($_POST['description']);
$story->Setkeywords($_POST['keywords']);
}
$story->setTopicdisplay($_POST['topicdisplay']); // Display Topic Image ? (Yes or No)
$story->setTopicalign($_POST['topicalign']); // Topic Align, 'Right' or 'Left'
$story->setIhome($_POST['ihome']); // Publish in home ? (Yes or No)
if (isset($_POST['bodytext'])) {
$story->setBodytext($_POST['bodytext']);
} else {
$story->setBodytext(' ');
}
$approve = isset($_POST['approve']) ? intval($_POST['approve']) : 0;
if (!$story->published() && $approve) {
$story->setPublished(time());
}
if (!$story->expired()) {
$story->setExpired(0);
}
if(!$approve) {
$story->setPublished(0);
}
} elseif ( $xoopsModuleConfig['autoapprove'] == 1 && !$approveprivilege) {
if (empty($storyid)) {
$approve = 1;
} else {
$approve = isset($_POST['approve']) ? intval($_POST['approve']) : 0;
}
if($approve) {
$story->setPublished(time());
} else {
$story->setPublished(0);
}
$story->setExpired(0);
$story->setTopicalign('R');
} else {
$approve = 0;
}
$story->setApproved($approve);
if($approve) {
news_updateCache();
}
// Increment author's posts count (only if it's a new article)
// First case, it's not an anonyous, the story is approved and it's a new story
if($uid && $approve && empty($storyid)) {
$tmpuser=new xoopsUser($uid);
$member_handler =& xoops_gethandler('member');
$member_handler->updateUserByField($tmpuser, 'posts', $tmpuser->getVar('posts') + 1);
}
// Second case, it's not an anonymous, the story is NOT approved and it's NOT a new story (typical when someone is approving a submited story)
if(is_object($xoopsUser) && $approve && !empty($storyid)) {
$storytemp = new NewsStory( $storyid );
if(!$storytemp->published() && $storytemp->uid()>0) { // the article has been submited but not approved
$tmpuser=new xoopsUser($storytemp->uid());
$member_handler =& xoops_gethandler('member');
$member_handler->updateUserByField($tmpuser, 'posts', $tmpuser->getVar('posts') + 1);
}
unset($storytemp);
}
$result = $story->store();
if ($result) {
if ($approveprivilege && news_getmoduleoption('tags')) {
$tag_handler = xoops_getmodulehandler('tag', 'tag');
$tag_handler->updateByItem($_POST['item_tag'], $story->storyid(), $xoopsModule->getVar('dirname'), 0);
}
if(!$editmode) {
// Notification
// TODO: modifier afin qu'en cas de prépublication, la notification ne se fasse pas
$notification_handler =& xoops_gethandler('notification');
$tags = array();
$tags['STORY_NAME'] = $story->title();
$tags['STORY_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/article.php?storyid=' . $story->storyid();
// If notify checkbox is set, add subscription for approve
if ($notifypub && $approve) {
include_once XOOPS_ROOT_PATH . '/include/notification_constants.php';
$notification_handler->subscribe('story', $story->storyid(), 'approve', XOOPS_NOTIFICATION_MODE_SENDONCETHENDELETE,$xoopsModule->getVar('mid'),$story->uid());
}
if ($approve == 1) {
$notification_handler->triggerEvent('global', 0, 'new_story', $tags);
$notification_handler->triggerEvent('story', $story->storyid(), 'approve', $tags);
// Added by Lankford on 2007/3/23
$notification_handler->triggerEvent('category', $story->topicid(), 'new_story', $tags);
} else {
$tags['WAITINGSTORIES_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/admin/index.php?op=newarticle';
$notification_handler->triggerEvent('global', 0, 'story_submit', $tags);
}
}
$allowupload = false;
switch ($xoopsModuleConfig['uploadgroups']) {
case 1: //Submitters and Approvers
$allowupload = true;
break;
case 2: //Approvers only
$allowupload = $approveprivilege ? true : false;
break;
case 3: //Upload Disabled
$allowupload = false;
break;
}
if($allowupload) {
// Manage upload(s)
if(isset($_POST['delupload']) && count($_POST['delupload'])>0) {
foreach ($_POST['delupload'] as $onefile) {
$sfiles = new sFiles($onefile);
$sfiles->delete();
}
}
if(isset($_POST['xoops_upload_file'])) {
$fldname = $_FILES[$_POST['xoops_upload_file'][0]];
$fldname = (get_magic_quotes_gpc()) ? stripslashes($fldname['name']) : $fldname['name'];
if(xoops_trim($fldname!='')) {
$sfiles = new sFiles();
$destname=$sfiles->createUploadName(XOOPS_UPLOAD_PATH,$fldname);
/**
* You can attach files to your news
*/
$permittedtypes = explode("n",str_replace("r",'',news_getmoduleoption('mimetypes')));
array_walk($permittedtypes, 'trim');
$uploader = new XoopsMediaUploader( XOOPS_UPLOAD_PATH, $permittedtypes, $xoopsModuleConfig['maxuploadsize']);
$uploader->setTargetFileName($destname);
if ($uploader->fetchMedia($_POST['xoops_upload_file'][0])) {
if ($uploader->upload()) {
$sfiles->setFileRealName($uploader->getMediaName());
$sfiles->setStoryid($story->storyid());
$sfiles->setMimetype($sfiles->giveMimetype(XOOPS_UPLOAD_PATH.'/'.$uploader->getMediaName()));
$sfiles->setDownloadname($destname);
if(!$sfiles->store()) {
echo _AM_UPLOAD_DBERROR_SAVE;
}
} else {
echo _AM_UPLOAD_ERROR. ' ' . $uploader->getErrors();
}
} else {
echo $uploader->getErrors();
}
}
}
}
} else {
echo _ERRORS;
}
$returnside = isset($_POST['returnside']) ? intval($_POST['returnside']) : 0;
if(!$returnside) {
redirect_header(XOOPS_URL.'/modules/news/index.php',2,_NW_THANKS);
exit();
} else {
redirect_header(XOOPS_URL.'/modules/news/admin/index.php?op=newarticle',2,_NW_THANKS);
exit();
}
break;
case 'form':
$xt = new NewsTopic();
$title = '';
$hometext = '';
$noname = 0;
$nohtml = 0;
$nosmiley = 0;
$notifypub = 1;
$topicid = 0;
if ($approveprivilege) {
$description='';
$keywords='';
$price='';//ajout champ price
$topicdisplay = 0;
$topicalign = 'R';
$ihome = 0;
$bodytext = '';
$approve = 0;
$autodate = '';
$expired = 0;
$published = 0;
}
if($xoopsModuleConfig['autoapprove'] == 1) {
$approve=1;
}
include_once XOOPS_ROOT_PATH.'/modules/news/include/storyform.inc.php';
break;
}
include_once XOOPS_ROOT_PATH.'/footer.php';
?>
Posté le : 23/12/2009 15:41
|
PS : Toujours faire une sauvegarde des fichiers avant de les modifier !------------------------------------------- http://www.aideordi.com
|
|
Re: Ajouter un champ au module News |
|
Semi pro
Inscrit: 10/11/2004 13:40
|
modules/news/class/class.newsstory.php
<?php
// $Id: class.newsstory.php,v 1.29 2004/09/02 17:04:08 hthouzard Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> ... nbsp; //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------- //
if (!defined('XOOPS_ROOT_PATH')) {
die('XOOPS root path not defined');
}
include_once XOOPS_ROOT_PATH.'/class/xoopsstory.php';
include_once XOOPS_ROOT_PATH.'/include/comment_constants.php';
include_once XOOPS_ROOT_PATH.'/modules/news/include/functions.php';
class NewsStory extends XoopsStory
{
var $newstopic; // XoopsTopic object
var $rating; // News rating
var $votes; // Number of votes
var $description; // META, desciption
var $keywords; // META, keywords
var $topic_imgurl;
var $topic_title;
/**
* Constructor
*/
function NewsStory($storyid=-1)
{
$this->db =& Database::getInstance();
$this->table = $this->db->prefix('stories');
$this->topicstable = $this->db->prefix('topics');
if (is_array($storyid)) {
$this->makeStory($storyid);
} elseif($storyid != -1) {
$this->getStory(intval($storyid));
}
}
/**
* Returns the number of stories published before a date
*/
function GetCountStoriesPublishedBefore($timestamp, $expired, $topicslist='')
{
$db =& Database::getInstance();
$sql = 'SELECT count(*) as cpt FROM '.$db->prefix('stories').' WHERE published <=' . $timestamp;
if($expired) {
$sql .=' AND (expired>0 AND expired<='.time().')';
}
if(strlen(trim($topicslist))>0) {
$sql .=' AND topicid IN ('.$topicslist.')';
}
$result = $db->query($sql);
list($count) = $db->fetchRow($result);
return $count;
}
/**
* Load the specified story from the database
*/
function getStory($storyid)
{
$sql = 'SELECT s.*, t.* FROM '.$this->table.' s, '.$this->db->prefix('topics').' t WHERE (storyid='.intval($storyid).') AND (s.topicid=t.topic_id)';
$array = $this->db->fetchArray($this->db->query($sql));
$this->makeStory($array);
}
/**
* Delete stories that were published before a given date
*/
function DeleteBeforeDate($timestamp, $expired, $topicslist='')
{
global $xoopsModule;
$mid= $xoopsModule->getVar('mid');
$db =& Database::getInstance();
$prefix = $db->prefix('stories');
$vote_prefix = $db->prefix('stories_votedata');
$files_prefix = $db->prefix('stories_files');
$sql = 'SELECT storyid FROM '.$prefix.' WHERE published <=' . $timestamp;
if($expired) {
$sql .=' (AND expired>0 AND expired<='.time().')';
}
if(strlen(trim($topicslist))>0) {
$sql .=' AND topicid IN ('.$topicslist.')';
}
$result = $db->query($sql);
while ($myrow = $db->fetchArray($result)) {
xoops_comment_delete($mid, $myrow['storyid']); // Delete comments
xoops_notification_deletebyitem($mid, 'story', $myrow['storyid']); // Delete notifications
$db->queryF('DELETE FROM '.$vote_prefix.' WHERE storyid='.$myrow['storyid']); // Delete votes
// Remove files and records related to the files
$result2 = $db->query('SELECT * FROM '.$files_prefix.' WHERE storyid='.$myrow['storyid']);
while ($myrow2 = $db->fetchArray($result2)) {
$name = XOOPS_ROOT_PATH.'/uploads/'.$myrow2['downloadname'];
if(file_exists($name)) {
unlink($name);
}
$db->query('DELETE FROM '.$files_prefix.' WHERE fileid='.$myrow2['fileid']);
}
$db->queryF('DELETE FROM '.$prefix.' WHERE storyid='.$myrow['storyid']); // Delete the story
}
return true;
}
function _searchPreviousOrNextArticle($storyid, $next = true, $checkRight = false)
{
$db =& Database::getInstance();
$ret = array();
$storyid = intval($storyid);
if($next) {
$sql = 'SELECT storyid, title FROM '.$db->prefix('stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().') AND storyid > '.$storyid;
$orderBy = ' ORDER BY storyid ASC';
} else {
$sql = 'SELECT storyid, title FROM '.$db->prefix('stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().') AND storyid < '.$storyid;
$orderBy = ' ORDER BY storyid DESC';
}
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics) > 0) {
$sql .= ' AND topicid IN ('.implode(',', $topics).')';
} else {
return null;
}
}
$sql .= $orderBy;
$db =& Database::getInstance();
$result = $db->query($sql, 1);
if($result) {
$myts =& MyTextSanitizer::getInstance();
while ( $row = $db->fetchArray($result) ) {
$ret = array('storyid' => $row['storyid'], 'title' => $myts->htmlSpecialChars($row['title']));
}
}
return $ret;
}
function getNextArticle($storyid, $checkRight=false)
{
return $this->_searchPreviousOrNextArticle($storyid, true, $checkRight);
}
function getPreviousArticle($storyid, $checkRight=false)
{
return $this->_searchPreviousOrNextArticle($storyid, false, $checkRight);
}
/**
* Returns published stories according to some options
*/
function getAllPublished($limit=0, $start=0, $checkRight=false, $topic=0, $ihome=0, $asobject=true, $order = 'published', $topic_frontpage=false)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = 'SELECT s.*, t.* FROM '.$db->prefix('stories').' s, '. $db->prefix('topics').' t WHERE (s.published > 0 AND s.published <= '.time().') AND (s.expired = 0 OR s.expired > '.time().') AND (s.topicid=t.topic_id) ';
if ($topic != 0) {
if (!is_array($topic)) {
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(!in_array ($topic,$topics)) {
return null;
} else {
$sql .= ' AND s.topicid='.intval($topic).' AND (s.ihome=1 OR s.ihome=0)';
}
} else {
$sql .= ' AND s.topicid='.intval($topic).' AND (s.ihome=1 OR s.ihome=0)';
}
} else {
if($checkRight) {
$topics = news_MygetItemIds('news_view');
$topic = array_intersect($topic,$topics);
}
if(count($topic)>0) {
$sql .= ' AND s.topicid IN ('.implode(',', $topic).')';
} else {
return null;
}
}
} else {
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND s.topicid IN ('.$topics.')';
} else {
return null;
}
}
if (intval($ihome) == 0) {
$sql .= ' AND s.ihome=0';
}
}
if($topic_frontpage) {
$sql .=' AND t.topic_frontpage=1';
}
$sql .= " ORDER BY s.$order DESC";
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ($asobject) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Retourne la liste des articles aux archives (pour une période donnée)
*/
function getArchive($publish_start, $publish_end, $checkRight=false, $asobject=true, $order = 'published')
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = 'SELECT s.*, t.* FROM '.$db->prefix('stories').' s, ' .$db->prefix('topics').' t WHERE (s.topicid=t.topic_id) AND (s.published > ' . $publish_start . ' AND s.published <= ' . $publish_end . ') AND (expired = 0 OR expired > '.time().') ';
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND topicid IN ('.$topics.')';
} else {
return null;
}
}
$sql .= " ORDER BY $order DESC";
$result = $db->query($sql);
while ( $myrow = $db->fetchArray($result) ) {
if ($asobject) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Get the today's most readed article
*
* @param int $limit records limit
* @param int $start starting record
* @param boolean $checkRight Do we need to check permissions (by topics) ?
* @param int $topic limit the job to one topic
* @param int $ihome Limit to articles published in home page only ?
* @param boolean $asobject Do we have to return an array of objects or a simple array ?
* @param string $order Fields to sort on
*/
function getBigStory($limit=0, $start=0, $checkRight=false, $topic=0, $ihome=0, $asobject=true, $order = 'counter')
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$tdate = mktime(0,0,0,date('n'),date('j'),date('Y'));
$sql = 'SELECT s.*, t.* FROM '.$db->prefix('stories').' s, '. $db->prefix('topics').' t WHERE (s.topicid=t.topic_id) AND (published > '.$tdate.' AND published < '.time().') AND (expired > '.time().' OR expired = 0) ';
if ( intval($topic) != 0 ) {
if (!is_array($topic)) {
$sql .= ' AND topicid='.intval($topic).' AND (ihome=1 OR ihome=0)';
}
else {
if(count($topic)>0) {
$sql .= ' AND topicid IN ('.implode(',', $topic).')';
} else {
return null;
}
}
} else {
if ($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND topicid IN ('.$topics.')';
} else {
return null;
}
}
if ( intval($ihome) == 0 ) {
$sql .= ' AND ihome=0';
}
}
$sql .= " ORDER BY $order DESC";
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ( $asobject ) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
if (defined('news_seo_enable')) {
$xoopsTpl->assign('urlrewrite', true);
} else {
$xoopsTpl->assign('urlrewrite', false);
}
}
/**
* Get all articles published by an author
*
* @param int $uid author's id
* @param boolean $checkRight whether to check the user's rights to topics
*/
function getAllPublishedByAuthor($uid, $checkRight=false, $asobject=true)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$tblstory=$db->prefix('stories');
$tbltopics=$db->prefix('topics');
$sql = 'SELECT ' . $tblstory . '.*, '. $tbltopics . '.topic_title, '.$tbltopics.'.topic_color FROM '.$tblstory.','.$tbltopics .' WHERE ('.$tblstory.'.topicid='.$tbltopics.'.topic_id) AND (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
$sql .= ' AND uid='.intval($uid);
if ($checkRight) {
$topics = news_MygetItemIds('news_view');
$topics = implode(',', $topics);
if(xoops_trim($topics)!='') {
$sql .= ' AND topicid IN ('.$topics.')';
}
}
$sql .= ' ORDER BY '.$tbltopics.'.topic_title ASC, '.$tblstory.'.published DESC';
$result = $db->query($sql);
while ( $myrow = $db->fetchArray($result) )
{
if ( $asobject ) {
$ret[] = new NewsStory($myrow);
} else {
if ( $myrow['nohtml'] ) {
$html = 0;
} else {
$html = 1;
}
if ( $myrow['nosmiley'] ) {
$smiley = 0;
} else {
$smiley = 1;
}
$ret[$myrow['storyid']] = array('title'=>$myts->displayTarea($myrow['title'],$html,$smiley,1),
'topicid'=>intval($myrow['topicid']),
'storyid'=>intval($myrow['storyid']),
'hometext'=>$myts->displayTarea($myrow['hometext'],$html,$smiley,1),
'counter'=>intval($myrow['counter']),
'created'=>intval($myrow['created']),
'topic_title'=>$myts->displayTarea($myrow['topic_title'],$html,$smiley,1),
'topic_color'=>$myts->displayTarea($myrow['topic_color']),
'published'=>intval($myrow['published']),
'rating'=>(float)$myrow['rating'],
'votes'=>intval($myrow['votes']));
}
}
return $ret;
}
/**
* Get all expired stories
*/
function getAllExpired($limit=0, $start=0, $topic=0, $ihome=0, $asobject=true)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = 'SELECT * FROM '.$db->prefix('stories').' WHERE expired <= '.time().' AND expired > 0';
if ( !empty($topic) ) {
$sql .= ' AND topicid='.intval($topic).' AND (ihome=1 OR ihome=0)';
} else {
if ( intval($ihome) == 0 ) {
$sql .= ' AND ihome=0';
}
}
$sql .= ' ORDER BY expired DESC';
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ($asobject) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Returns an array of object containing all the news to be automatically published.
*/
function getAllAutoStory($limit=0, $asobject=true, $start=0)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = 'SELECT * FROM '.$db->prefix('stories').' WHERE published > '.time().' ORDER BY published ASC';
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ( $asobject ) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Get all submitted stories awaiting approval
*
* @param int $limit Denotes where to start the query
* @param boolean $asobject true will returns the stories as an array of objects, false will return storyid => title
* @param boolean $checkRight whether to check the user's rights to topics
*/
function getAllSubmitted($limit=0, $asobject=true, $checkRight = false, $start=0)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$criteria = new CriteriaCompo(new Criteria('published', 0));
if ($checkRight) {
global $xoopsUser;
if (!is_object($xoopsUser)) {
return $ret;
}
$allowedtopics = news_MygetItemIds('news_approve');
$criteria2 = new CriteriaCompo();
foreach ($allowedtopics as $key => $topicid) {
$criteria2->add(new Criteria('topicid', $topicid), 'OR');
}
$criteria->add($criteria2);
}
$sql = 'SELECT s.*, t.* FROM '.$db->prefix('stories').' s, '.$db->prefix('topics').' t ';
$sql .= ' '.$criteria->renderWhere().' AND (s.topicid=t.topic_id) ORDER BY created DESC';
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ( $asobject ) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Used in the module's admin to know the number of expired, automated or pubilshed news
*
* @param int $storytype 1=Expired, 2=Automated, 3=New submissions, 4=Last published stories
* @param bool $checkRight verify permissions or not ?
*/
function getAllStoriesCount($storytype=1, $checkRight = false)
{
$db =& Database::getInstance();
$sql = 'SELECT count(*) as cpt FROM '.$db->prefix('stories').' WHERE ';
switch($storytype) {
case 1: // Expired
$sql .='(expired <= '.time().' AND expired >0)';
break;
case 2: // Automated
$sql .='(published > '.time().')';
break;
case 3: // New submissions
$sql .='(published = 0)';
break;
case 4: // Last published stories
$sql .='(published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
break;
}
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND topicid IN ('.$topics.')';
} else {
return 0;
}
}
$result = $db->query($sql);
$myrow = $db->fetchArray($result);
return $myrow['cpt'];
}
/**
* Get a list of stories (as objects) related to a specific topic
*/
function getByTopic($topicid, $limit=0)
{
$ret = array();
$db =& Database::getInstance();
$sql = 'SELECT * FROM '.$db->prefix('stories').' WHERE topicid='.intval($topicid).' ORDER BY published DESC';
$result = $db->query($sql, intval($limit), 0);
while( $myrow = $db->fetchArray($result) ){
$ret[] = new NewsStory($myrow);
}
return $ret;
}
/**
* Count the number of news published for a specific topic
*/
function countPublishedByTopic($topicid=0, $checkRight = false)
{
$db =& Database::getInstance();
$sql = 'SELECT COUNT(*) FROM '.$db->prefix('stories').' WHERE published > 0 AND published <= '.time().' AND (expired = 0 OR expired > '.time().')';
if ( !empty($topicid) ) {
$sql .= ' AND topicid='.intval($topicid);
} else {
$sql .= ' AND ihome=0';
if ($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND topicid IN ('.$topics.')';
} else {
return null;
}
}
}
$result = $db->query($sql);
list($count) = $db->fetchRow($result);
return $count;
}
/**
* Internal function
*/
function adminlink()
{
$ret = " [ <a href='".XOOPS_URL."/modules/news/submit.php?op=edit&storyid=".$this->storyid()."'>"._EDIT."</a> | <a href='".XOOPS_URL."/modules/news/admin/index.php?op=delete&storyid=".$this->storyid()."'>"._DELETE."</a> ] ";
return $ret;
}
/**
* Get the topic image url
*/
function topic_imgurl($format='S')
{
if(trim($this->topic_imgurl)=='') {
$this->topic_imgurl='blank.png';
}
$myts =& MyTextSanitizer::getInstance();
switch($format){
case 'S':
$imgurl= $myts->htmlSpecialChars($this->topic_imgurl);
break;
case 'E':
$imgurl = $myts->htmlSpecialChars($this->topic_imgurl);
break;
case 'P':
$imgurl = $myts->stripSlashesGPC($this->topic_imgurl);
$imgurl = $myts->htmlSpecialChars($imgurl);
break;
case 'F':
$imgurl = $myts->stripSlashesGPC($this->topic_imgurl);
$imgurl = $myts->htmlSpecialChars($imgurl);
break;
}
return $imgurl;
}
function topic_title($format='S')
{
$myts =& MyTextSanitizer::getInstance();
switch($format){
case 'S':
$title = $myts->htmlSpecialChars($this->topic_title);
break;
case 'E':
$title = $myts->htmlSpecialChars($this->topic_title);
break;
case 'P':
$title = $myts->stripSlashesGPC($this->topic_title);
$title = $myts->htmlSpecialChars($title);
break;
case 'F':
$title = $myts->stripSlashesGPC($this->topic_title);
$title = $myts->htmlSpecialChars($title);
break;
}
return $title;
}
function imglink()
{
if (defined('news_seo_enable')) {
$ret = '';
if ($this->topic_imgurl() != '' && file_exists(XOOPS_ROOT_PATH.'/modules/news/images/topics/'.$this->topic_imgurl())) {
$cat_path = elimina_acentos($this->topic_title());
$ret = "<a href='".XOOPS_URL."/article.cat.".$this->topicid()."/$cat_path'><img src='".XOOPS_URL."/modules/news/images/topics/".$this->topic_imgurl()."' alt='".$this->topic_title()."' hspace='10' vspace='10' align='".$this->topicalign()."' /></a>"; }
}
else
{
$ret = '';
if ($this->topic_imgurl() != '' && file_exists(XOOPS_ROOT_PATH.'/modules/news/images/topics/'.$this->topic_imgurl())) {
$ret = "<a href='".XOOPS_URL."/modules/news/index.php?storytopic=".$this->topicid()."'><img src='".XOOPS_URL."/modules/news/images/topics/".$this->topic_imgurl()."' alt='".$this->topic_title()."' hspace='10' vspace='10' align='".$this->topicalign()."' /></a>";
}
}
return $ret;
}
function textlink()
{
if (defined('news_seo_enable')) {
$cat_path = elimina_acentos($this->topic_title());
$ret = "<a href='".XOOPS_URL."/article.cat.".$this->topicid()."/$cat_path'>".$this->topic_title()."</a>";
return $ret;
}
else {
$ret = "<a href='".XOOPS_URL."/modules/news/index.php?storytopic=".$this->topicid()."'>".$this->topic_title()."</a>";
return $ret;
}
}
/**
* Function used to prepare an article to be showned
*/
function prepare2show($filescount)
{
include_once XOOPS_ROOT_PATH.'/modules/news/include/functions.php';
global $xoopsUser, $xoopsConfig, $xoopsModuleConfig;
$myts =& MyTextSanitizer::getInstance();
$infotips = news_getmoduleoption('infotips');
$story = array();
$story['id'] = $this->storyid();
$story['poster'] = $this->uname();
$story['author_name'] = $this->uname();
$story['author_uid'] = $this->uid();
if ( $story['poster'] != false ) {
$story['poster'] = "<a href='".XOOPS_URL."/userinfo.php?uid=".$this->uid()."'>".$story['poster']."</a>";
} else {
if($xoopsModuleConfig['displayname']!=3) {
$story['poster'] = $xoopsConfig['anonymous'];
}
}
if ($xoopsModuleConfig['ratenews']) {
$story['rating'] = number_format($this->rating(), 2);
if ($this->votes == 1) {
$story['votes'] = _NW_ONEVOTE;
} else {
$story['votes'] = sprintf(_NW_NUMVOTES,$this->votes);
}
}
$story['posttimestamp'] = $this->published();
$story['posttime'] = formatTimestamp($story['posttimestamp'],news_getmoduleoption('dateformat'));
$story['topic_description'] = $myts->displayTarea($this->topic_description);
$auto_summary = '';
$tmp = '';
$auto_summary = $this->auto_summary($this->bodytext(),$tmp);
$story['text'] = $this->hometext();
$story['text'] = str_replace('[summary]', $auto_summary, $story['text']);
$introcount = strlen($story['text']);
$fullcount = strlen($this->bodytext());
$totalcount = $introcount + $fullcount;
$morelink = '';
if ( $fullcount > 1 ) {
if (defined('news_seo_enable')) {
$story_path = elimina_acentos($this->title());
$morelink .= '<a href="'.XOOPS_URL.'/article.item.'.$this->storyid().'/'.$story_path.'';
} else {
$morelink .= '<a href="'.XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid().'';
}
$morelink .= '">'._NW_READMORE.'</a>';
$morelink .= ' | '.sprintf(_NW_BYTESMORE,$totalcount);
if (XOOPS_COMMENT_APPROVENONE != $xoopsModuleConfig['com_rule']) {
$morelink .= ' | ';
}
}
if (XOOPS_COMMENT_APPROVENONE != $xoopsModuleConfig['com_rule']) {
$ccount = $this->comments();
if (defined('news_seo_enable')) {
$storyurl = elimina_acentos($this->title());
$morelink .= '<a href="'.XOOPS_URL.'/article.item.'.$this->storyid().'/'.$storyurl.'';
$morelink2 = '<a href="'.XOOPS_URL.'/article.item.'.$this->storyid().'/'.$storyurl.'';
} else {
$morelink .= '<a href="'.XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid().'';
$morelink2 = '<a href="'.XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid().'';
}
if ( $ccount == 0 ) {
$morelink .= '">'._NW_COMMENTS.'</a>';
} else {
if ( $fullcount < 1 ) {
if ( $ccount == 1 ) {
$morelink .= '">'._NW_READMORE.'</a> | '.$morelink2.'">'._NW_ONECOMMENT.'</a>';
} else {
$morelink .= '">'._NW_READMORE.'</a> | '.$morelink2.'">';
$morelink .= sprintf(_NW_NUMCOMMENTS, $ccount);
$morelink .= '</a>';
}
} else {
if ( $ccount == 1 ) {
$morelink .= '">'._NW_ONECOMMENT.'</a>';
} else {
$morelink .= '">';
$morelink .= sprintf(_NW_NUMCOMMENTS, $ccount);
$morelink .= '</a>';
}
}
}
}
$story['morelink'] = $morelink;
$story['adminlink'] = '';
$approveprivilege = 0;
if(news_is_admin_group()) {
$approveprivilege = 1;
}
if($xoopsModuleConfig['authoredit']==1 && (is_object($xoopsUser) && $xoopsUser->getVar('uid')==$this->uid())) {
$approveprivilege = 1;
}
if ($approveprivilege) {
$story['adminlink'] = $this->adminlink();
}
$story['mail_link'] = 'mailto:?subject='.sprintf(_NW_INTARTICLE,$xoopsConfig['sitename']).'&body='.sprintf(_NW_INTARTFOUND, $xoopsConfig['sitename']).': '.XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid();
$story['imglink'] = '';
$story['align'] = '';
if ( $this->topicdisplay() ) {
$story['imglink'] = $this->imglink();
$story['align'] = $this->topicalign();
}
if($infotips>0) {
$story['infotips'] = ' title="'.news_make_infotips($this->hometext()).'"';
} else {
$story['infotips'] = '';
}
if (defined('news_seo_enable')) {
$story_path = elimina_acentos($this->title());
$story['title'] = "<a href='".XOOPS_URL."/article.item.$this->storyid/$story_path'>".$this->title()."</a>";
} else {
$story['title'] = "<a href='".XOOPS_URL."/modules/news/article.php?storyid=".$this->storyid()."'".$story['infotips'].">".$this->title()."</a>";
}
$story['hits'] = $this->counter();
if($filescount>0) {
$story['files_attached']= true;
$story['attached_link']="<a href='".XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid()."' title='"._NW_ATTACHEDLIB."'><img src='".XOOPS_URL.'/modules/news/images/attach.gif'."' title='"._NW_ATTACHEDLIB."'></a>";
} else {
$story['files_attached']= false;
$story['attached_link']='';
}
return $story;
}
/**
* Returns the user's name of the current story according to the module's option "displayname"
*/
function uname($uid=0)
{
global $xoopsConfig;
include_once XOOPS_ROOT_PATH.'/modules/news/include/functions.php';
static $tblusers = array();
$option=-1;
if($uid == 0) {
$uid=$this->uid();
}
if(is_array($tblusers) && array_key_exists($uid,$tblusers)) {
return $tblusers[$uid];
}
$option = news_getmoduleoption('displayname');
if (!$option) {
$option=1;
}
switch($option) {
case 1: // Username
$tblusers[$uid]=XoopsUser::getUnameFromId($uid);
return $tblusers[$uid];
case 2: // Display full name (if it is not empty)
$member_handler =& xoops_gethandler('member');
$thisuser = $member_handler->getUser($uid);
if (is_object($thisuser)) {
$return = $thisuser->getVar('name');
if ($return == '') {
$return=$thisuser->getVar('uname');
}
} else {
$return=$xoopsConfig['anonymous'];
}
$tblusers[$uid]=$return;
return $return;
case 3: // Nothing
$tblusers[$uid]='';
return '';
}
}
/**
* Function used to export news (in xml) and eventually the topics definitions
* Warning, permissions are not exported !
* @param int $fromdate Starting date
* @param int $todate Ending date
* @param string $topiclist If not empty, a list of topics to limit to
* @param boolean $usetopicsdef Should we also export topics definitions ?
* @param boolean $asobject Return values as an object or not ?
*/
function NewsExport($fromdate, $todate, $topicslist='', $usetopicsdef=0, &$tbltopics, $asobject=true, $order = 'published')
{
$ret=Array();
$myts =& MyTextSanitizer::getInstance();
if($usetopicsdef) { // We firt begin by exporting topics definitions
// Before all we must know wich topics to export
$sql = 'SELECT distinct topicid FROM '.$this->db->prefix('stories').' WHERE (published >=' . $fromdate . ' AND published <= ' . $todate .')';
if(strlen(trim($topicslist))>0) {
$sql .=' AND topicid IN ('.$topicslist.')';
}
$result = $this->db->query($sql);
while ( $myrow = $this->db->fetchArray($result) ) {
$tbltopics[]=$myrow['topicid'];
}
}
// Now we can search for the stories
$sql = 'SELECT s.*, t.* FROM '.$this->table.' s, '.$this->db->prefix('topics').' t WHERE (s.topicid=t.topic_id) AND (s.published >=' . $fromdate . ' AND s.published <= ' . $todate .')';
if(strlen(trim($topicslist))>0) {
$sql .=' AND topicid IN ('.$topicslist.')';
}
$sql .= " ORDER BY $order DESC";
$result = $this->db->query($sql);
while ($myrow = $this->db->fetchArray($result)) {
if ($asobject) {
$ret[] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Create or update an article
*/
function store($approved=false)
{
$myts =& MyTextSanitizer::getInstance();
$counter = isset($this->counter) ? $this->counter : 0;
$title =$myts->censorString($this->title);
$title = $myts->addSlashes($title);
$hostname=$myts->addSlashes($this->hostname);
$type=$myts->addSlashes($this->type);
$hometext =$myts->addSlashes($myts->censorString($this->hometext));
$bodytext =$myts->addSlashes($myts->censorString($this->bodytext));
$description =$myts->addSlashes($myts->censorString($this->description));
$keywords =$myts->addSlashes($myts->censorString($this->keywords));
// ajout champ price
$price =$myts->censorString($this->price);
$votes= intval($this->votes);
$rating = (float)($this->rating);
if (!isset($this->nohtml) || $this->nohtml != 1) {
$this->nohtml = 0;
}
if (!isset($this->nosmiley) || $this->nosmiley != 1) {
$this->nosmiley = 0;
}
if (!isset($this->notifypub) || $this->notifypub != 1) {
$this->notifypub = 0;
}
if(!isset($this->topicdisplay) || $this->topicdisplay != 0) {
$this->topicdisplay = 1;
}
$expired = !empty($this->expired) ? $this->expired : 0;
if (!isset($this->storyid)) {
//$newpost = 1;
$newstoryid = $this->db->genId($this->table.'_storyid_seq');
$created = time();
$published = ( $this->approved ) ? intval($this->published) : 0;
$sql = sprintf("INSERT INTO %s (storyid, uid, title, created, published, expired, hostname, nohtml, nosmiley, hometext, bodytext, counter, topicid, ihome, notifypub, story_type, topicdisplay, topicalign, comments, rating, votes, description, keywords, price) VALUES (%u, %u, '%s', %u, %u, %u, '%s', %u, %u, '%s', '%s', %u, %u, %u, %u, '%s', %u, '%s', %u, %u, %u, '%s', '%s', '%s')", $this->table, $newstoryid, intval($this->uid()), $title, $created, $published, $expired, $hostname, intval($this->nohtml()), intval($this->nosmiley()), $hometext, $bodytext, $counter, intval($this->topicid()), intval($this->ihome()), intval($this->notifypub()), $type, intval($this->topicdisplay()), $this->topicalign, intval($this->comments()), $rating, $votes, $description, $keywords, $price);
} else {
$sql = sprintf("UPDATE %s SET title='%s', published=%u, expired=%u, nohtml=%u, nosmiley=%u, hometext='%s', bodytext='%s', topicid=%u, ihome=%u, topicdisplay=%u, topicalign='%s', comments=%u, rating=%u, votes=%u, uid=%u, description='%s', keywords='%s', price='%s' WHERE storyid = %u", $this->table, $title, intval($this->published()), $expired, intval($this->nohtml()), intval($this->nosmiley()), $hometext, $bodytext, intval($this->topicid()), intval($this->ihome()), intval($this->topicdisplay()), $this->topicalign, intval($this->comments()), $rating, $votes, intval($this->uid()), $description, $keywords, $price, intval($this->storyid()));
$newstoryid = intval($this->storyid());
}
if (!$this->db->queryF($sql)) {
return false;
}
if (empty($newstoryid)) {
$newstoryid = $this->db->getInsertId();
$this->storyid = $newstoryid;
}
return $newstoryid;
}
//ajout champ price
function setprice($value)
{
$this->price=$value;
}
function price()
{
return $this->price;
}
//fin ajout champ price
function rating()
{
return $this->rating;
}
function votes()
{
return $this->votes;
}
function Setdescription($data)
{
$this->description=$data;
}
function Setkeywords($data)
{
$this->keywords=$data;
}
function description($format='S')
{
$myts =& MyTextSanitizer::getInstance();
switch(strtoupper($format)) {
case 'S':
$description= $myts->htmlSpecialChars($this->description);
break;
case 'P':
case 'F':
$description = $myts->htmlSpecialChars($myts->stripSlashesGPC($this->description));
break;
case 'E':
$description = $myts->htmlSpecialChars($this->description);
break;
}
return $description;
}
function keywords($format='S')
{
$myts =& MyTextSanitizer::getInstance();
switch(strtoupper($format)) {
case 'S':
$keywords= $myts->htmlSpecialChars($this->keywords);
break;
case 'P':
case 'F':
$keywords = $myts->htmlSpecialChars($myts->stripSlashesGPC($this->keywords));
break;
case 'E':
$keywords = $myts->htmlSpecialChars($this->keywords);
break;
}
return $keywords;
}
/**
* Returns a random number of news
*/
function getRandomNews($limit=0, $start=0, $checkRight=false, $topic=0, $ihome=0, $order='published', $topic_frontpage=false)
{
$db =& Database::getInstance();
$ret = $rand_keys = $ret3 = array();
$sql = 'SELECT storyid FROM '.$db->prefix('stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
if ($topic != 0) {
if (!is_array($topic)) {
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(!in_array ($topic,$topics)) {
return null;
} else {
$sql .= ' AND topicid='.intval($topic).' AND (ihome=1 OR ihome=0)';
}
} else {
$sql .= ' AND topicid='.intval($topic).' AND (ihome=1 OR ihome=0)';
}
} else {
if(count($topic)>0) {
$sql .= ' AND topicid IN ('.implode(',', $topic).')';
} else {
return null;
}
}
} else {
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND topicid IN ('.$topics.')';
} else {
return null;
}
}
if (intval($ihome) == 0) {
$sql .= ' AND ihome=0';
}
}
if($topic_frontpage) {
$sql .=' AND t.topic_frontpage=1';
}
$sql .= " ORDER BY $order DESC";
$result = $db->query($sql);
while ( $myrow = $db->fetchArray($result) ) {
$ret[] = $myrow['storyid'];
}
$cnt=count($ret);
if($cnt) {
srand ((double) microtime() * 10000000);
if($limit>$cnt) {
$limit=$cnt;
}
$rand_keys = array_rand($ret, $limit);
if($limit>1) {
for($i=0;$i<$limit;$i++) {
$onestory=$ret[$rand_keys[$i]];
$ret3[]= new NewsStory($onestory);
}
} else {
$ret3[]= new NewsStory($ret[$rand_keys]);
}
}
return $ret3;
}
/**
* Returns statistics about the stories and topics
*/
function GetStats($limit)
{
$ret=array();
$db =& Database::getInstance();
$tbls=$db->prefix('stories');
$tblt=$db->prefix('topics');
$tblf=$db->prefix('stories_files');
$db =& Database::getInstance();
// Number of stories per topic, including expired and non published stories
$ret2=array();
$sql="SELECT count(s.storyid) as cpt, s.topicid, t.topic_title FROM $tbls s, $tblt t WHERE s.topicid=t.topic_id GROUP BY s.topicid ORDER BY t.topic_title";
$result = $db->query($sql);
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['topicid']]=$myrow;
}
$ret['storiespertopic']=$ret2;
unset($ret2);
// Total of reads per topic
$ret2=array();
$sql="SELECT Sum(counter) as cpt, topicid FROM $tbls GROUP BY topicid ORDER BY topicid";
$result = $db->query($sql);
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['topicid']]=$myrow['cpt'];
}
$ret['readspertopic']=$ret2;
unset($ret2);
// Attached files per topic
$ret2=array();
$sql="SELECT Count(*) as cpt, s.topicid FROM $tblf f, $tbls s WHERE f.storyid=s.storyid GROUP BY s.topicid ORDER BY s.topicid";
$result = $db->query($sql);
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['topicid']]=$myrow['cpt'];
}
$ret['filespertopic']=$ret2;
unset($ret2);
// Expired articles per topic
$ret2=array();
$sql="SELECT Count(storyid) as cpt, topicid FROM $tbls WHERE expired>0 AND expired<=".time()." GROUP BY topicid ORDER BY topicid";
$result = $db->query($sql);
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['topicid']]=$myrow['cpt'];
}
$ret['expiredpertopic']=$ret2;
unset($ret2);
// Number of unique authors per topic
$ret2=array();
$sql="SELECT Count(Distinct(uid)) as cpt, topicid FROM $tbls GROUP BY topicid ORDER BY topicid";
$result = $db->query($sql);
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['topicid']]=$myrow['cpt'];
}
$ret['authorspertopic']=$ret2;
unset($ret2);
// Most readed articles
$ret2=array();
$sql="SELECT s.storyid, s.uid, s.title, s.counter, s.topicid, t.topic_title FROM $tbls s, $tblt t WHERE s.topicid=t.topic_id ORDER BY s.counter DESC";
$result = $db->query($sql,intval($limit));
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['storyid']]=$myrow;
}
$ret['mostreadednews']=$ret2;
unset($ret2);
// Less readed articles
$ret2=array();
$sql="SELECT s.storyid, s.uid, s.title, s.counter, s.topicid, t.topic_title FROM $tbls s, $tblt t WHERE s.topicid=t.topic_id ORDER BY s.counter";
$result = $db->query($sql,intval($limit));
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['storyid']]=$myrow;
}
$ret['lessreadednews']=$ret2;
unset($ret2);
// Best rated articles
$ret2=array();
$sql="SELECT s.storyid, s.uid, s.title, s.rating, s.topicid, t.topic_title FROM $tbls s, $tblt t WHERE s.topicid=t.topic_id ORDER BY s.rating DESC";
$result = $db->query($sql,intval($limit));
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['storyid']]=$myrow;
}
$ret['besratednews']=$ret2;
unset($ret2);
// Most readed authors
$ret2=array();
$sql="SELECT Sum(counter) as cpt, uid FROM $tbls GROUP BY uid ORDER BY cpt DESC";
$result = $db->query($sql,intval($limit));
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['uid']]=$myrow['cpt'];
}
$ret['mostreadedauthors']=$ret2;
unset($ret2);
// Best rated authors
$ret2=array();
$sql="SELECT Avg(rating) as cpt, uid FROM $tbls WHERE votes > 0 GROUP BY uid ORDER BY cpt DESC";
$result = $db->query($sql,intval($limit));
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['uid']]=$myrow['cpt'];
}
$ret['bestratedauthors']=$ret2;
unset($ret2);
// Biggest contributors
$ret2=array();
$sql="SELECT Count(*) as cpt, uid FROM $tbls GROUP BY uid ORDER BY cpt DESC";
$result = $db->query($sql,intval($limit));
while ($myrow = $db->fetchArray($result) ) {
$ret2[$myrow['uid']]=$myrow['cpt'];
}
$ret['biggestcontributors']=$ret2;
unset($ret2);
return $ret;
}
/**
* Get the date of the older and most recent news
*/
function GetOlderRecentNews(&$older, &$recent)
{
$db =& Database::getInstance();
$sql = 'SELECT min(published) as minpublish, max(published) as maxpublish FROM '.$db->prefix('stories');
$result = $db->query($sql);
if(!$result) {
$older = $recent = 0;
} else {
list($older, $recent) = $this->db->fetchRow($result);
}
}
/*
* Returns the author's IDs for the Who's who page
*/
function getWhosWho($checkRight=false, $limit=0, $start=0)
{
$db =& Database::getInstance();
$ret = array();
$sql = 'SELECT distinct(uid) as uid FROM '.$db->prefix('stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND topicid IN ('.$topics.')';
} else {
return null;
}
}
$sql .= " ORDER BY uid";
$result = $db->query($sql);
while ( $myrow = $db->fetchArray($result) ) {
$ret[] = $myrow['uid'];
}
return $ret;
}
/**
* Returns the content of the summary and the titles requires for the list selector
*/
function auto_summary($text, &$titles)
{
$auto_summary = '';
if(news_getmoduleoption('enhanced_pagenav')) {
$expr_matches = array();
$posdeb = preg_match_all('/([pagebreak:|[pagebreak).*]/iU', $text, $expr_matches);
if(count($expr_matches) > 0) {
$delimiters = $expr_matches[0];
$arr_search = array('[pagebreak:', '[pagebreak', ']');
$arr_replace = array('', '', '');
$cpt = 1;
if(isset($titles) && is_array($titles)) {
$titles[] = strip_tags(sprintf(_NW_PAGE_AUTO_SUMMARY,1, $this->title()));
}
$item = "<a href='".XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid()."&page=0'>".sprintf(_NW_PAGE_AUTO_SUMMARY,1, $this->title()).'</a><br />';
$auto_summary .= $item;
foreach($delimiters as $item) {
$cpt++;
$item = str_replace($arr_search, $arr_replace, $item);
if(xoops_trim($item) == '') {
$item = $cpt;
}
$titles[] = strip_tags(sprintf(_NW_PAGE_AUTO_SUMMARY,$cpt, $item));
$item = "<a href='".XOOPS_URL.'/modules/news/article.php?storyid='.$this->storyid().'&page='.($cpt-1)."'>".sprintf(_NW_PAGE_AUTO_SUMMARY,$cpt, $item).'</a><br />';
$auto_summary .= $item;
}
}
}
return $auto_summary;
}
function hometext($format = 'Show')
{
$myts =& MyTextSanitizer::getInstance();
$html = $smiley = $xcodes = 1;
if ( $this->nohtml() ) {
$html = 0;
}
if ( $this->nosmiley() ) {
$smiley = 0;
}
switch ( $format ) {
case 'Show':
$hometext = $myts->displayTarea($this->hometext,$html,$smiley,$xcodes);
$tmp = '';
$auto_summary = $this->auto_summary($this->bodytext('Show'),$tmp);
$hometext = str_replace('[summary]', $auto_summary, $hometext);
break;
case 'Edit':
$hometext = $myts->htmlSpecialChars($this->hometext);
break;
case 'Preview':
$hometext = $myts->previewTarea($this->hometext,$html,$smiley,$xcodes);
break;
case 'InForm':
$hometext = $myts->stripSlashesGPC($this->hometext);
$hometext = $myts->htmlSpecialChars($hometext);
break;
}
return $hometext;
}
function bodytext($format = 'Show')
{
$myts =& MyTextSanitizer::getInstance();
$html = 1;
$smiley = 1;
$xcodes = 1;
if ( $this->nohtml() ) {
$html = 0;
}
if ( $this->nosmiley() ) {
$smiley = 0;
}
switch ( $format ) {
case 'Show':
$bodytext = $myts->displayTarea($this->bodytext,$html,$smiley,$xcodes);
$tmp = '';
$auto_summary = $this->auto_summary($bodytext,$tmp);
$bodytext = str_replace('[summary]', $auto_summary, $bodytext);
break;
case 'Edit':
$bodytext = $myts->htmlSpecialChars($this->bodytext);
break;
case 'Preview':
$bodytext = $myts->previewTarea($this->bodytext,$html,$smiley, $xcodes);
break;
case 'InForm':
$bodytext = $myts->stripSlashesGPC($this->bodytext);
$bodytext = $myts->htmlSpecialChars($bodytext);
break;
}
return $bodytext;
}
/**
* Returns stories by Ids
*/
function getStoriesByIds($ids, $checkRight = true, $asobject = true, $order = 'published', $onlyOnline = true)
{
$limit = $start = 0;
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$sql = 'SELECT s.*, t.* FROM '.$db->prefix('stories').' s, '. $db->prefix('topics').' t WHERE ';
if(is_array($ids) && count($ids) > 0) {
array_walk($ids, 'intval');
}
$sql .= ' s.storyid IN ('.implode(',', $ids).') ';
if($onlyOnline) {
$sql .= ' AND (s.published > 0 AND s.published <= '.time().') AND (s.expired = 0 OR s.expired > '.time().') ';
}
$sql .= ' AND (s.topicid=t.topic_id) ';
if($checkRight) {
$topics = news_MygetItemIds('news_view');
if(count($topics)>0) {
$topics = implode(',', $topics);
$sql .= ' AND s.topicid IN ('.$topics.')';
} else {
return null;
}
}
$sql .= " ORDER BY s.$order DESC";
$result = $db->query($sql,intval($limit),intval($start));
while ( $myrow = $db->fetchArray($result) ) {
if ($asobject) {
$ret[$myrow['storyid']] = new NewsStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
}
?>
Posté le : 23/12/2009 15:43
|
PS : Toujours faire une sauvegarde des fichiers avant de les modifier !------------------------------------------- http://www.aideordi.com
|
|
Re: Ajouter un champ au module News |
|
Semi pro
Inscrit: 10/11/2004 13:40
|
modules/news/include/storyform.inc.php
<?php
// $Id: storyform.inc.php,v 1.14 2004/09/03 17:30:43 hthouzard Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> ... nbsp; //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
if (!defined('XOOPS_ROOT_PATH')) {
die("XOOPS root path not defined");
}
if (file_exists(XOOPS_ROOT_PATH.'/language/'.$xoopsConfig['language'].'/calendar.php')) {
include_once XOOPS_ROOT_PATH.'/language/'.$xoopsConfig['language'].'/calendar.php';
} else {
include_once XOOPS_ROOT_PATH.'/language/english/calendar.php';
}
include_once XOOPS_ROOT_PATH.'/class/xoopsformloader.php';
include_once XOOPS_ROOT_PATH.'/modules/news/include/functions.php';
include_once XOOPS_ROOT_PATH.'/modules/news/config.php';
$sform = new XoopsThemeForm(_NW_SUBMITNEWS, "storyform", XOOPS_URL.'/modules/'.$xoopsModule->getVar('dirname').'/submit.php');
$sform->setExtra('enctype="multipart/form-data"');
$sform->addElement(new XoopsFormText(_NW_TITLE, 'title', 50, 255, $title), true);
// Topic's selection box
if (!isset($xt)) {
$xt = new NewsTopic();
}
if($xt->getAllTopicsCount()==0) {
redirect_header("index.php",4,_NW_POST_SORRY);
exit();
}
include_once XOOPS_ROOT_PATH."/class/tree.php";
$allTopics = $xt->getAllTopics($xoopsModuleConfig['restrictindex'],'news_submit');
$topic_tree = new XoopsObjectTree($allTopics, 'topic_id', 'topic_pid');
$topic_select = $topic_tree->makeSelBox('topic_id', 'topic_title', '-- ', $topicid, false);
$sform->addElement(new XoopsFormLabel(_NW_TOPIC, $topic_select));
//If admin - show admin form
//TODO: Change to "If submit privilege"
if ($approveprivilege) {
//Show topic image?
$sform->addElement(new XoopsFormRadioYN(_AM_TOPICDISPLAY, 'topicdisplay', $topicdisplay));
//Select image position
$posselect = new XoopsFormSelect(_AM_TOPICALIGN, 'topicalign', $topicalign);
$posselect->addOption('R', _AM_RIGHT);
$posselect->addOption('L', _AM_LEFT);
$sform->addElement($posselect);
//Publish in home?
//TODO: Check that pubinhome is 0 = no and 1 = yes (currently vice versa)
$sform->addElement(new XoopsFormRadioYN(_AM_PUBINHOME, 'ihome', $ihome, _NO, _YES));
}
// News author
if ($approveprivilege && is_object($xoopsUser) && $xoopsUser->isAdmin($xoopsModule->mid())) {
if(!isset($newsauthor)) {
$newsauthor=$xoopsUser->getVar('uid');
}
$member_handler = &xoops_gethandler( 'member' );
$usercount = $member_handler->getUserCount();
if ( $usercount < $cfg['config_max_users_list']) {
$sform->addElement(new XoopsFormSelectUser(_NW_AUTHOR,'author',true, $newsauthor),false);
} else {
$sform->addElement(new XoopsFormText(_NW_AUTHOR_ID, 'author', 10, 10, $newsauthor), false);
}
}
$editor=news_getWysiwygForm(_NW_THESCOOP, 'hometext', $hometext, 15, 60, 'hometext_hidden');
$sform->addElement($editor,true);
//Extra info
//If admin -> if submit privilege
if ($approveprivilege) {
$editor2=news_getWysiwygForm(_AM_EXTEXT, 'bodytext', $bodytext, 15, 60, 'bodytext_hidden');
$sform->addElement($editor2,false);
if(news_getmoduleoption('tags')) {
$itemIdForTag = isset($storyid) ? $storyid : 0;
require_once XOOPS_ROOT_PATH.'/modules/tag/include/formtag.php';
$sform->addElement(new XoopsFormTag('item_tag', 60, 255, $itemIdForTag, 0));
}
if(news_getmoduleoption('metadata')) {
$sform->addElement(new xoopsFormText(_NW_META_DESCRIPTION, 'description', 50, 255, $description), false);
$sform->addElement(new xoopsFormText(_NW_META_KEYWORDS, 'keywords', 50, 255, $keywords), false);
}
}
// Manage upload(s)
$allowupload = false;
switch ($xoopsModuleConfig['uploadgroups'])
{
case 1: //Submitters and Approvers
$allowupload = true;
break;
case 2: //Approvers only
$allowupload = $approveprivilege ? true : false;
break;
case 3: //Upload Disabled
$allowupload = false;
break;
}
if($allowupload)
{
if($op=='edit') {
$sfiles = new sFiles();
$filesarr=Array();
$filesarr=$sfiles->getAllbyStory($storyid);
if(count($filesarr)>0) {
$upl_tray = new XoopsFormElementTray(_AM_UPLOAD_ATTACHFILE,'<br />');
$upl_checkbox=new XoopsFormCheckBox('', 'delupload[]');
foreach ($filesarr as $onefile)
{
$link = sprintf("<a href='%s/%s' target='_blank'>%s</a>n",XOOPS_UPLOAD_URL,$onefile->getDownloadname('S'),$onefile->getFileRealName('S'));
$upl_checkbox->addOption($onefile->getFileid(),$link);
}
$upl_tray->addElement($upl_checkbox,false);
$dellabel=new XoopsFormLabel(_AM_DELETE_SELFILES,'');
$upl_tray->addElement($dellabel,false);
$sform->addElement($upl_tray);
}
}
$sform->addElement(new XoopsFormFile(_AM_SELFILE, 'attachedfile', $xoopsModuleConfig['maxuploadsize']), false);
}
//ajout champ price
$sform->addElement(new xoopsFormText(_NW_PRICE, 'price', 10, 255, $price), false);
$option_tray = new XoopsFormElementTray(_OPTIONS,'<br />');
//Set date of publish/expiration
if ($approveprivilege) {
if(is_object($xoopsUser) && $xoopsUser->isAdmin($xoopsModule->getVar('mid'))) {
$approve=1;
}
$approve_checkbox = new XoopsFormCheckBox('', 'approve', $approve);
$approve_checkbox->addOption(1, _AM_APPROVE);
$option_tray->addElement($approve_checkbox);
$check=$published>0 ? 1 :0;
$published_checkbox = new XoopsFormCheckBox('', 'autodate',$check);
$published_checkbox->addOption(1, _AM_SETDATETIME);
$option_tray->addElement($published_checkbox);
$option_tray->addElement(new XoopsFormDateTime(_AM_SETDATETIME, 'publish_date', 15, $published));
$check=$expired>0 ? 1 :0;
$expired_checkbox = new XoopsFormCheckBox('', 'autoexpdate',$check);
$expired_checkbox->addOption(1, _AM_SETEXPDATETIME);
$option_tray->addElement($expired_checkbox);
$option_tray->addElement(new XoopsFormDateTime(_AM_SETEXPDATETIME, 'expiry_date', 15, $expired));
}
if (is_object($xoopsUser)) {
$notify_checkbox = new XoopsFormCheckBox('', 'notifypub', $notifypub);
$notify_checkbox->addOption(1, _NW_NOTIFYPUBLISH);
$option_tray->addElement($notify_checkbox);
if ($xoopsUser->isAdmin($xoopsModule->getVar('mid'))) {
$nohtml_checkbox = new XoopsFormCheckBox('', 'nohtml', $nohtml);
$nohtml_checkbox->addOption(1, _DISABLEHTML);
$option_tray->addElement($nohtml_checkbox);
}
}
$smiley_checkbox = new XoopsFormCheckBox('', 'nosmiley', $nosmiley);
$smiley_checkbox->addOption(1, _DISABLESMILEY);
$option_tray->addElement($smiley_checkbox);
$sform->addElement($option_tray);
//TODO: Approve checkbox + "Move to top" if editing + Edit indicator
//Submit buttons
$button_tray = new XoopsFormElementTray('' ,'');
$preview_btn = new XoopsFormButton('', 'preview', _PREVIEW, 'submit');
$preview_btn->setExtra('accesskey="p"');
$button_tray->addElement($preview_btn);
$submit_btn = new XoopsFormButton('', 'post', _NW_POST, 'submit');
$submit_btn->setExtra('accesskey="s"');
$button_tray->addElement($submit_btn);
$sform->addElement($button_tray);
//Hidden variables
if(isset($storyid)){
$sform->addElement(new XoopsFormHidden('storyid', $storyid));
}
if (!isset($returnside)) {
$returnside=isset($_POST['returnside']) ? intval($_POST['returnside']) : 0;
if(empty($returnside)) {
$returnside=isset($_GET['returnside']) ? intval($_GET['returnside']) : 0;
}
}
if(!isset($returnside)) {
$returnside=0;
}
$sform->addElement(new XoopsFormHidden('returnside', $returnside),false);
if (!isset($type)) {
if ($approveprivilege) {
$type = "admin";
}
else {
$type = "user";
}
}
$type_hidden = new XoopsFormHidden('type', $type);
$sform->addElement($type_hidden);
$sform->display();
?>
Posté le : 23/12/2009 15:44
|
PS : Toujours faire une sauvegarde des fichiers avant de les modifier !------------------------------------------- http://www.aideordi.com
|
Vous pouvez voir les sujets.
Vous ne pouvez pas débuter de nouveaux sujets.
Vous ne pouvez pas répondre aux contributions.
Vous ne pouvez pas éditer vos contributions.
Vous ne pouvez pas effacez vos contributions.
Vous ne pouvez pas ajouter de nouveaux sondages.
Vous ne pouvez pas voter en sondage.
Vous ne pouvez pas attacher des fichiers à vos contributions.
Vous ne pouvez pas poster sans approbation.
|