|
Re: Module Social Profile |
|
Régulier
Inscrit: 22/03/2006 10:49
|
Probleme résolu : j'avais juste mis à jour le module PROFILE. les tables n'avaient pas été crées en fait. Donc désinstallation du module et réinstall et c'est bon ;) ca a l'air pas mal du tout quand meme ce module ! juste la page FACEBOOK, je ne comprends pas bien à quoi ca sert... Je continue de tester ce module en bon noob que je suis. ca aidera du monde j'espere
Posté le : 26/04/2010 11:59
|
|
|
Re: Module Social Profile |
|
Régulier
Inscrit: 22/03/2006 10:49
|
Hello, j'ai installé ce module sur un xoops 2.4.4 en test car je cherche aussi un module de social network pour xoops. Je le teste sur le themepar défaut , histoire d'isoler les bugs cités pluys haut. Je ne comprends pas :quand je cherche à éditer mes préférences (qui peut voir quoi, etc ...) j'ai un message disant "could not save data". je ne comprends pas d'où ca vient. Sur le profil, je ne vois pas de bouton "ajouter des amis", "photos", ou ce genre de chose. c'est normal ? il faut installer d'autres modules ? ou pas ? ou utiliser un autre module ? Quel module conseilleriez vous ? y'en a plétore et on est un peu perdu (profile, friends, yogurt, etc ...) Sachant que c'est un peu incontournable pour un site aujourdh'ui. Merci
Posté le : 26/04/2010 10:18
|
|
|
Re: xNews_v1.68 |
|
Régulier
Inscrit: 22/03/2006 10:49
|
Autant pour moi. j'ai re-cloné le module, puis intallé DEPUIS LA PAGE "CLONE MANAGER" DE XNEWS et non depuis le gestionnaire de module de xoops comme la premiere fois : et là ça marche nickel Comme je ne serais pas le seul à avoir ce probleme... voilà c'est dit. ;)
Posté le : 22/04/2010 16:40
|
|
|
Re: xNews_v1.68 |
|
Régulier
Inscrit: 22/03/2006 10:49
|
concernant le clonage, j'ai installé xnews 1068, tout marche à merveille sauf l'image liée à l'article qui ne s'affiche nulle part (pas tres grave ca, juste à modifier le template je pense)
par contre le clone ca marche pas chez moi (media plan chez ovh). quand je lcique sur "cloner ca crée bien un nouveau dossier maius quend je clique sur "instaler" => page blanche.
Posté le : 22/04/2010 16:37
|
|
|
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 |
|
Régulier
Inscrit: 22/03/2006 10:49
|
Autant pour moi, le nom de la table est bien "price". ce nom est le seul utilisé.
Posté le : 05/12/2009 10:07
|
|
|
Re: Ajouter un champ au module News |
|
Régulier
Inscrit: 22/03/2006 10:49
|
up ;)
Posté le : 02/12/2009 14:10
|
|
|
Re: Ajouter un champ au module News |
|
Régulier
Inscrit: 22/03/2006 10:49
|
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/course/include/functions.php';
include_once XOOPS_ROOT_PATH.'/modules/course/config.php';
$sform = new XoopsThemeForm(_NW_SUBMITcourse, "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 CourseTopic();
}
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'],'course_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));
}
// Course author
if ($approveprivilege && is_object($xoopsUser) && $xoopsUser->isAdmin($xoopsModule->mid())) {
if(!isset($courseauthor)) {
$courseauthor=$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, $courseauthor),false);
} else {
$sform->addElement(new XoopsFormText(_NW_AUTHOR_ID, 'author', 10, 10, $courseauthor), false);
}
}
$editor=course_getWysiwygForm(_NW_THESCOOP, 'hometext', $hometext, 15, 60, 'hometext_hidden');
$sform->addElement($editor,true);
//Extra info
//If admin -> if submit privilege
if ($approveprivilege) {
$editor2=course_getWysiwygForm(_AM_EXTEXT, 'bodytext', $bodytext, 15, 60, 'bodytext_hidden');
$sform->addElement($editor2,false);
if(course_coursegetmoduleoption('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(course_coursegetmoduleoption('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);
}
$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));
// ajout irishcofee
$sform->addElement(new XoopsFormText(_NW_TITLE, 'price', 5, 255, $price), true);
//fin // ajout irishcofee
//blueteen - events - begin
$check=$booked>0 ? 1 :0;
$booked_checkbox = new XoopsFormCheckBox('', 'autobookdate',$check);
$booked_checkbox->addOption(1, _AM_course_SETEVENTDATETIME);
$option_tray->addElement($booked_checkbox);
$option_tray->addElement(new XoopsFormDateTime(_AM_course_SETEVENTDATETIME_BEGIN, 'booked_date', 15, $booked));//date de début de l'évènement
$option_tray->addElement(new XoopsFormDateTime(_AM_course_SETEVENTDATETIME_END, 'bookedend_date', 15, $bookedend));//date de fin de l'évènement
//blueteen - events - end
}
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 : 30/11/2009 12:47
|
|
|
Re: Ajouter un champ au module News |
|
Régulier
Inscrit: 22/03/2006 10:49
|
CLASS.COURSESTORY.PHP
<?php
// $Id: class.coursestory.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/course/include/functions.php';
//blueteen - events - begin
//transforme un tableau 2D en liste séparée par une virgule (ou le séparateur de notre choix)
function implodeArray2D ($sep, $array)
{
$num = count($array);
$str = "";
for ($i = 0; $i < $num; $i++)
{
if ($i)
{
$str .= $sep;
}
$str .= $array[$i];
}
return $str;
}
function stripBBCodeEvents($text_to_search) {
$pattern = '|[[/!]*?[^[]]*?]|si';
$replace = '';
return preg_replace($pattern, $replace, $text_to_search);
}
//blueteen - events - end
class CourseStory extends XoopsStory
{
var $coursetopic; // XoopsTopic object
var $rating; // Course rating
var $votes; // Number of votes
var $description; // META, desciption
var $keywords; // META, keywords
var $topic_imgurl;
var $topic_title;
//blueteen - events - begin
function setBooked($value)
{
$this->booked = intval($value);
}
function booked()
{
return $this->booked;
}
function setBookedend($value)
{
$this->bookedend = intval($value);
}
function bookedend()
{
return $this->bookedend;
}
function GetOlderRecentEvents(&$older, &$recent)
{
$db =& Database::getInstance();
$sql = 'SELECT min(booked) as minbooked, max(bookedend) as maxbookedend FROM '.$db->prefix('course_stories').' WHERE booked != 0';
$result = $db->query($sql);
if(!$result) {
$older = $recent = 0;
} else {
list($older, $recent) = $this->db->fetchRow($result);
}
}
//blueteen - events - end
/**
* Constructor
*/
function CourseStory($storyid=-1)
{
$this->db =& Database::getInstance();
$this->table = $this->db->prefix('course_stories');
$this->course_topicstable = $this->db->prefix('course_topics');
if (is_array($storyid)) {
$this->makeStory($storyid);
} elseif($storyid != -1) {
$this->getStory(intval($storyid));
}
}
/**
* Returns the number of course_stories published before a date
*/
function GetCountStoriesPublishedBefore($timestamp, $expired, $course_topicslist='')
{
$db =& Database::getInstance();
$sql = 'SELECT count(*) as cpt FROM '.$db->prefix('course_stories').' WHERE published <=' . $timestamp;
if($expired) {
$sql .=' AND (expired>0 AND expired<='.time().')';
}
if(strlen(trim($course_topicslist))>0) {
$sql .=' AND topicid IN ('.$course_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('course_topics').' t WHERE (storyid='.intval($storyid).') AND (s.topicid=t.topic_id)';
$array = $this->db->fetchArray($this->db->query($sql));
$this->makeStory($array);
}
/**
* Delete course_stories that were published before a given date
*/
function DeleteBeforeDate($timestamp, $expired, $course_topicslist='')
{
global $xoopsModule;
$mid= $xoopsModule->getVar('mid');
$db =& Database::getInstance();
$prefix = $db->prefix('course_stories');
$vote_prefix = $db->prefix('course_stories_votedata');
$files_prefix = $db->prefix('course_stories_files');
$sql = 'SELECT storyid FROM '.$prefix.' WHERE published <=' . $timestamp;
if($expired) {
$sql .=' (AND expired>0 AND expired<='.time().')';
}
if(strlen(trim($course_topicslist))>0) {
$sql .=' AND topicid IN ('.$course_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('course_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('course_stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().') AND storyid < '.$storyid;
$orderBy = ' ORDER BY storyid DESC';
}
if($checkRight) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics) > 0) {
$sql .= ' AND topicid IN ('.implode(',', $course_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 course_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('course_stories').' s, '. $db->prefix('course_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) {
$course_topics = course_courseMygetItemIds('course_view');
if(!in_array ($topic,$course_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) {
$course_topics = course_courseMygetItemIds('course_view');
$topic = array_intersect($topic,$course_topics);
}
if(count($topic)>0) {
$sql .= ' AND s.topicid IN ('.implode(',', $topic).')';
} else {
return null;
}
}
} else {
if($checkRight) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND s.topicid IN ('.$course_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 CourseStory($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('course_stories').' s, ' .$db->prefix('course_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) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND topicid IN ('.$course_topics.')';
} else {
return null;
}
}
$sql .= " ORDER BY $order DESC";
$result = $db->query($sql);
while ( $myrow = $db->fetchArray($result) ) {
if ($asobject) {
$ret[] = new CourseStory($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 course_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('course_stories').' s, '. $db->prefix('course_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) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND topicid IN ('.$course_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 CourseStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Get all articles published by an author
*
* @param int $uid author's id
* @param boolean $checkRight whether to check the user's rights to course_topics
*/
function getAllPublishedByAuthor($uid, $checkRight=false, $asobject=true)
{
$db =& Database::getInstance();
$myts =& MyTextSanitizer::getInstance();
$ret = array();
$tblstory=$db->prefix('course_stories');
$tblcourse_topics=$db->prefix('course_topics');
$sql = 'SELECT ' . $tblstory . '.*, '. $tblcourse_topics . '.topic_title, '.$tblcourse_topics.'.topic_color FROM '.$tblstory.','.$tblcourse_topics .' WHERE ('.$tblstory.'.topicid='.$tblcourse_topics.'.topic_id) AND (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
$sql .= ' AND uid='.intval($uid);
if ($checkRight) {
$course_topics = course_courseMygetItemIds('course_view');
$course_topics = implode(',', $course_topics);
if(xoops_trim($course_topics)!='') {
$sql .= ' AND topicid IN ('.$course_topics.')';
}
}
$sql .= ' ORDER BY '.$tblcourse_topics.'.topic_title ASC, '.$tblstory.'.published DESC';
$result = $db->query($sql);
while ( $myrow = $db->fetchArray($result) )
{
if ( $asobject ) {
$ret[] = new CourseStory($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 course_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('course_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 CourseStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Returns an array of object containing all the course 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('course_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 CourseStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
/**
* Get all submitted course_stories awaiting approval
*
* @param int $limit Denotes where to start the query
* @param boolean $asobject true will returns the course_stories as an array of objects, false will return storyid => title
* @param boolean $checkRight whether to check the user's rights to course_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;
}
$allowedcourse_topics = course_courseMygetItemIds('course_approve');
$criteria2 = new CriteriaCompo();
foreach ($allowedcourse_topics as $key => $topicid) {
$criteria2->add(new Criteria('topicid', $topicid), 'OR');
}
$criteria->add($criteria2);
}
$sql = 'SELECT s.*, t.* FROM '.$db->prefix('course_stories').' s, '.$db->prefix('course_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 CourseStory($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 course
*
* @param int $storytype 1=Expired, 2=Automated, 3=New submissions, 4=Last published course_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('course_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 course_stories
$sql .='(published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
break;
}
if($checkRight) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND topicid IN ('.$course_topics.')';
} else {
return 0;
}
}
$result = $db->query($sql);
$myrow = $db->fetchArray($result);
return $myrow['cpt'];
}
/**
* Get a list of course_stories (as objects) related to a specific topic
*/
function getByTopic($topicid, $limit=0)
{
$ret = array();
$db =& Database::getInstance();
$sql = 'SELECT * FROM '.$db->prefix('course_stories').' WHERE topicid='.intval($topicid).' ORDER BY published DESC';
$result = $db->query($sql, intval($limit), 0);
while( $myrow = $db->fetchArray($result) ){
$ret[] = new CourseStory($myrow);
}
return $ret;
}
/**
* Count the number of course published for a specific topic
*/
function countPublishedByTopic($topicid=0, $checkRight = false)
{
$db =& Database::getInstance();
$sql = 'SELECT COUNT(*) FROM '.$db->prefix('course_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) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND topicid IN ('.$course_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/course/submit.php?op=edit&storyid=".$this->storyid()."'>"._EDIT."</a> | <a href='".XOOPS_URL."/modules/course/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()
{
$ret = '';
if ($this->topic_imgurl() != '' && file_exists(XOOPS_ROOT_PATH.'/modules/course/images/course_topics/'.$this->topic_imgurl())) {
$ret = "<a href='".XOOPS_URL."/modules/course/index.php?storytopic=".$this->topicid()."'><img src='".XOOPS_URL."/modules/course/images/course_topics/".$this->topic_imgurl()."' alt='".$this->topic_title()."' hspace='10' vspace='10' align='".$this->topicalign()."' /></a>";
}
return $ret;
}
function textlink()
{
$ret = "<a href='".XOOPS_URL."/modules/course/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/course/include/functions.php';
global $xoopsUser, $xoopsConfig, $xoopsModuleConfig;
$myts =& MyTextSanitizer::getInstance();
$infotips = course_coursegetmoduleoption('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['ratecourse']) {
$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'],course_coursegetmoduleoption('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 ) {
$morelink .= '<a href="'.XOOPS_URL.'/modules/course/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();
$morelink .= '<a href="'.XOOPS_URL.'/modules/course/article.php?storyid='.$this->storyid().'';
$morelink2 = '<a href="'.XOOPS_URL.'/modules/course/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(course_courseis_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/course/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="'.course_coursemake_infotips($this->hometext()).'"';
} else {
$story['infotips'] = '';
}
$story['title'] = "<a href='".XOOPS_URL."/modules/course/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/course/article.php?storyid='.$this->storyid()."' title='"._NW_ATTACHEDLIB."'><img src='".XOOPS_URL.'/modules/course/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/course/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 = course_coursegetmoduleoption('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 course (in xml) and eventually the course_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 course_topics to limit to
* @param boolean $usecourse_topicsdef Should we also export course_topics definitions ?
* @param boolean $asobject Return values as an object or not ?
*/
function CourseExport($fromdate, $todate, $course_topicslist='', $usecourse_topicsdef=0, &$tblcourse_topics, $asobject=true, $order = 'published')
{
$ret=Array();
$myts =& MyTextSanitizer::getInstance();
if($usecourse_topicsdef) { // We firt begin by exporting course_topics definitions
// Before all we must know wich course_topics to export
$sql = 'SELECT distinct topicid FROM '.$this->db->prefix('course_stories').' WHERE (published >=' . $fromdate . ' AND published <= ' . $todate .')';
if(strlen(trim($course_topicslist))>0) {
$sql .=' AND topicid IN ('.$course_topicslist.')';
}
$result = $this->db->query($sql);
while ( $myrow = $this->db->fetchArray($result) ) {
$tblcourse_topics[]=$myrow['topicid'];
}
}
// Now we can search for the course_stories
$sql = 'SELECT s.*, t.* FROM '.$this->table.' s, '.$this->db->prefix('course_topics').' t WHERE (s.topicid=t.topic_id) AND (s.published >=' . $fromdate . ' AND s.published <= ' . $todate .')';
if(strlen(trim($course_topicslist))>0) {
$sql .=' AND topicid IN ('.$course_topicslist.')';
}
$sql .= " ORDER BY $order DESC";
$result = $this->db->query($sql);
while ($myrow = $this->db->fetchArray($result)) {
if ($asobject) {
$ret[] = new CourseStory($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);
//ajout irishcofee
$price = $myts->censorString($this->price);
//fin ajout irishcofee
$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));
$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;
$booked = !empty($this->booked) ? $this->booked : 0;//blueteen - events - date de début
$bookedend = !empty($this->bookedend) ? $this->bookedend : 0;//blueteen - events - date de fin
if (!isset($this->storyid)) {
//$newpost = 1;
$coursetoryid = $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, booked, bookedend, 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', %u, %u, %s)", $this->table, $coursetoryid, 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, $booked, $bookedend, $price);//blueteen - events - ajout base de données ajout rishcofee
} 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', booked='%u', bookedend='%u', 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, $booked, $bookedend, $price, intval($this->storyid()));//blueteen - events - mise à jour base de données ajout irishcofee
$coursetoryid = intval($this->storyid());
}
if (!$this->db->queryF($sql)) {
return false;
}
if (empty($coursetoryid)) {
$coursetoryid = $this->db->getInsertId();
$this->storyid = $coursetoryid;
}
return $coursetoryid;
}
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 course
*/
function getRandomCourse($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('course_stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
if ($topic != 0) {
if (!is_array($topic)) {
if($checkRight) {
$course_topics = course_courseMygetItemIds('course_view');
if(!in_array ($topic,$course_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) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND topicid IN ('.$course_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 CourseStory($onestory);
}
} else {
$ret3[]= new CourseStory($ret[$rand_keys]);
}
}
return $ret3;
}
/**
* Returns statistics about the course_stories and course_topics
*/
function GetStats($limit)
{
$ret=array();
$db =& Database::getInstance();
$tbls=$db->prefix('course_stories');
$tblt=$db->prefix('course_topics');
$tblf=$db->prefix('course_stories_files');
$db =& Database::getInstance();
// Number of course_stories per topic, including expired and non published course_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['course_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['mostreadedcourse']=$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['lessreadedcourse']=$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['besratedcourse']=$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 course
*/
function GetOlderRecentCourse(&$older, &$recent)
{
$db =& Database::getInstance();
$sql = 'SELECT min(published) as minpublish, max(published) as maxpublish FROM '.$db->prefix('course_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('course_stories').' WHERE (published > 0 AND published <= '.time().') AND (expired = 0 OR expired > '.time().')';
if($checkRight) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND topicid IN ('.$course_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(course_coursegetmoduleoption('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/course/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/course/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 course_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('course_stories').' s, '. $db->prefix('course_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) {
$course_topics = course_courseMygetItemIds('course_view');
if(count($course_topics)>0) {
$course_topics = implode(',', $course_topics);
$sql .= ' AND s.topicid IN ('.$course_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 CourseStory($myrow);
} else {
$ret[$myrow['storyid']] = $myts->htmlSpecialChars($myrow['title']);
}
}
return $ret;
}
}
?>
Posté le : 30/11/2009 12:46
|
|
|
Re: Ajouter un champ au module News |
|
Régulier
Inscrit: 22/03/2006 10:49
|
SUBMIT.PHPplusieurs ajouts repérables par "ajout irishcofee"
<?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/course/class/class.coursestory.php';
include_once XOOPS_ROOT_PATH.'/modules/course/class/class.sfiles.php';
include_once XOOPS_ROOT_PATH.'/modules/course/class/class.coursetopic.php';
include_once XOOPS_ROOT_PATH.'/class/uploader.php';
include_once XOOPS_ROOT_PATH.'/header.php';
include_once XOOPS_ROOT_PATH.'/modules/course/include/functions.php';
if (file_exists(XOOPS_ROOT_PATH.'/modules/course/language/'.$xoopsConfig['language'].'/admin.php')) {
include_once XOOPS_ROOT_PATH.'/modules/course/language/'.$xoopsConfig['language'].'/admin.php';
} else {
include_once XOOPS_ROOT_PATH.'/modules/course/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('course_submit', $perm_itemid, $groups, $module_id)) {
redirect_header(XOOPS_URL.'/modules/course/index.php', 3, _NOPERM);
exit();
}
$op = 'form';
//If approve privileges
$approveprivilege = 0;
if (is_object($xoopsUser) && $gperm_handler->checkRight('course_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 CourseStory(intval($_GET['storyid']));
if(is_object($xoopsUser) && $xoopsUser->getVar('uid')!=$tmpstory->uid() && !course_courseis_admin_group()) {
redirect_header(XOOPS_URL.'/modules/course/index.php', 3, _NOPERM);
exit();
}
} else { // Users can't edit their articles
if(!course_courseis_admin_group()) {
redirect_header(XOOPS_URL.'/modules/course/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(course_coursegetmoduleoption('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 CourseStory($storyid);
if($tmpstory->uid()==$xoopsUser->getVar('uid')) {
$op= isset($_GET['op']) ? $_GET['op'] : $_POST['post'];
unset($tmpstory);
$approveprivilege=1;
} else {
unset($tmpstory);
if(!course_courseis_admin_group()) {
redirect_header(XOOPS_URL.'/modules/course/index.php', 3, _NOPERM);
exit();
} else {
$approveprivilege=1;
}
}
}
} else {
if(!course_courseis_admin_group()) {
unset($tmpstory);
redirect_header(XOOPS_URL.'/modules/course/index.php', 3, _NOPERM);
exit();
} else {
$approveprivilege=1;
}
}
}
}
switch ($op) {
case 'edit':
if (!$approveprivilege) {
redirect_header(XOOPS_URL.'/modules/course/index.php', 0, _NOPERM);
exit();
break;
}
//if($storyid==0 && isset($_POST['storyid'])) {
// $storyid=intval($_POST['storyid']);
//}
$story = new CourseStory($storyid);
if (!$gperm_handler->checkRight('course_view', $story->topicid(), $groups, $module_id)) {
redirect_header(XOOPS_URL.'/modules/course/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();
$ihome = $story->ihome();
$courseauthor=$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;
}
//blueteen - events - begin
if ( $story -> booked() != 0) {
$booked = $story->booked();
} else {
$booked = 0;
}
if ( $story -> bookedend() != 0) {
$bookedend = $story->bookedend();
} else {
$bookedend = 0;
}
//blueteen - events - end
//ajout irishcofee
if ( $story -> price() != 0) {
$price = $story->price();
} else {
$price = 0;}
//fin ajout irishcofee
$type = $story -> type();
$topicdisplay = $story -> topicdisplay();
$topicalign = $story -> topicalign( false );
include_once XOOPS_ROOT_PATH.'/modules/course/include/storyform.inc.php';
echo'</td></tr></table>';
break;
case 'preview':
$topic_id = intval($_POST['topic_id']);
$xt = new CourseTopic($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 CourseStory($storyid);
$published = $story -> published();
$expired = $story -> expired();
//ajout irishcofee
$price = $story -> price();
//fin ajout irishcofee
$booked = $story -> booked();//blueteen - events
$bookedend = $story -> bookedend();//blueteen - events
} else {
$story = new CourseStory();
$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;
}
//ajout ajout irishcofee
$price = isset($_POST['price']) ? $_POST['price'] : 0;
//fin ajout irishcofee
//blueteen - events - begin
$booked = isset($_POST['booked_date']) ? $_POST['booked_date'] : 0;
$bookedend = isset($_POST['bookedend_date']) ? $_POST['bookedend_date'] : 0;
if(!empty($booked) && !empty($bookedend) && isset($_POST['autobookdate']) && intval($_POST['autobookdate']==1)) {
$booked = strtotime($booked['date']) + $booked['time'];
$bookedend = strtotime($bookedend['date']) + $bookedend['time'];
} else {
$booked = 0;
}
//blueteen - events - end
}
$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(course_coursegetmoduleoption('metadata')) {
$story->Setkeywords($_POST['keywords']);
$story->Setdescription($_POST['description']);
$story->setIhome(intval($_POST['ihome']));
}
} else {
$noname = isset($_POST['noname']) ? intval($_POST['noname']) : 0;
}
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');
if ($approveprivilege) {
$bodytext = $story->bodytext('InForm');
$ihome = $story -> ihome();
$description = $story->description('E');
$keywords = $story->keywords('E');
}
//Display post preview
$courseauthor=$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/course_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/course/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 CourseStory();
$editmode = false;
} else {
$story = new CourseStory($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 irishcofee
$price=$_POST['price'];
//fin ajout irishcofee
//blueteen - events - begin
if (!empty( $_POST['autobookdate'] ) && $approveprivilege) {
$booked_date=$_POST['booked_date'];
$booked_date = strtotime($booked_date['date']) + $booked_date['time'];
$bookedend_date=$_POST['bookedend_date'];
$bookedend_date = strtotime($bookedend_date['date']) + $bookedend_date['time'];
$offset = $xoopsUser -> timezone() - $xoopsConfig['server_TZ'];
$booked_date = $booked_date - ( $offset * 3600 );
$bookedend_date = $bookedend_date - ( $offset * 3600 );
$story -> setBooked( $booked_date );
$story -> setBookedend( $bookedend_date );
} else {
$story -> setBooked( 0 );
$story -> setBookedend( 0 );
}
//blueteen - events - end
if ($approveprivilege) {
if(course_coursegetmoduleoption('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);
}
//blueteen - events - begin
if (!$story->booked()) {
$story->setBooked(0);
}
if (!$story->bookedend()) {
$story->setBookedend(0);
}
//blueteen - events - end
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->setBooked(0);//blueteen - events
$story->setBookedend(0);//blueteen - events
//ajout irishcofee
$story->setPrice( $price );
//fin ajout irishcofee
$story->setTopicalign('R');
} else {
$approve = 0;
}
$story->setApproved($approve);
if($approve) {
course_courseupdateCache();
}
// 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 CourseStory( $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 && course_coursegetmoduleoption('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 course
*/
$permittedtypes = explode("n",str_replace("r",'',course_coursegetmoduleoption('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/course/index.php',2,_NW_THANKS);
exit();
} else {
redirect_header(XOOPS_URL.'/modules/course/admin/index.php?op=newarticle',2,_NW_THANKS);
exit();
}
break;
case 'form':
$xt = new CourseTopic();
$title = '';
$hometext = '';
$noname = 0;
$nohtml = 0;
$nosmiley = 0;
$notifypub = 1;
$topicid = 0;
if ($approveprivilege) {
$description='';
$keywords='';
$topicdisplay = 0;
$topicalign = 'R';
$ihome = 0;
$bodytext = '';
$approve = 0;
$autodate = '';
$expired = 0;
$published = 0;
$booked = 0;//blueteen - events
$bookedend = 0;//blueteen - events
$price='';//ajout irishcofee
}
if($xoopsModuleConfig['autoapprove'] == 1) {
$approve=1;
}
include_once XOOPS_ROOT_PATH.'/modules/course/include/storyform.inc.php';
break;
}
include_once XOOPS_ROOT_PATH.'/footer.php';
?>
Posté le : 30/11/2009 12:46
|
|
|