Most recent edit on 2007-11-15 16:30:52 by TrmonCopas
Additions:
noergetmo
Display the associated website of a news / Afficher le site internet associé àune brève
Deletions:
Display the associated website of a news / Afficher le site internet associé à une brève
Edited on 2007-11-10 10:55:20 by ChitaElcod
Additions:
getbasd
Display the associated website of a news / Afficher le site internet associé à une brève
Deletions:
Display the associated website of a news / Afficher le site internet associé à une brève
Edited on 2005-05-06 11:28:41 by CedricArrabie [Broutilles]
Additions:
Dans manager\inc\class.basicmanager.php changer la variable $r = 'SELECT ...' pour celle-ci :
Deletions:
Dans manager\inc\class.basicmanager.php chager la variable $r = 'SELECT ...' pour celle-ci :
Edited on 2005-05-06 06:21:14 by ClaireRoubey [correction orthographe]
Additions:
Dans manager\inc\class.basicmanager.php chager la variable $r = 'SELECT ...' pour celle-ci :
Puis supprimez ces lignes devenues inutiles :
Deletions:
Dans manager\inc\class.basicmanager.php chager la variable $r = 'SELECT ...' pour celle ci :
Puis supprimez ces lignes devenue inutiles :
Edited on 2005-05-06 04:37:45 by JosselinJaffres
Additions:
In manager\inc\class.basicmanager.php change the variable $r = 'SELECT ...' for this one :
Dans manager\inc\class.basicmanager.php chager la variable $r = 'SELECT ...' pour celle ci :
$r = 'SELECT '.$this->con->pfx.'resources.*,
'.$this->con->pfx.'categoryasso.*,
'.$this->con->pfx.'categories.*,
'.$this->con->pfx.'websites.*,
'.$this->con->pfx.'news.news_serial,
'.$this->con->pfx.'news.news_titlewebsite,
'.$this->con->pfx.'news.news_linkwebsite,
'.$this->con->pfx.'news.feed_id
FROM '.$this->con->pfx.'resources
LEFT JOIN '.$this->con->pfx.'categoryasso ON '.$this->con->pfx.'categoryasso.identifier='.$this->con->pfx.'resources.identifier
LEFT JOIN '.$this->con->pfx.'categories ON '.$this->con->pfx.'categoryasso.category_id='.$this->con->pfx.'categories.category_id
LEFT JOIN '.$this->con->pfx.'websites ON '.$this->con->pfx.'websites.website_id='.$this->con->pfx.'resources.website_id
LEFT JOIN '.$this->con->pfx.'news ON '.$this->con->pfx.'news.resource_id='.$this->con->pfx.'resources.resource_id ';
Puis supprimez ces lignes devenue inutiles :
if ($type 'news') {
$r .= ' LEFT JOIN '.$this->con->pfx.'news ON '.$this->con->pfx.'news.resource_id='.$this->con->pfx.'resources.resource_id ';
Deletions:
In/Dans manager\inc\class.basicmanager.php add this line after the other LEFT JOIN / ajoutez cette ligne après les autres LEFT JOIN :
LEFT JOIN '.$this->con->pfx.'news ON '.$this->con->pfx.'news.resource_id='.$this->con->pfx.'resources.resource_id ';
Edited on 2005-05-05 10:07:21 by ClaireRoubey [broutilles]
Additions:
In/Dans manager\inc\class.basicmanager.php add this line after the other LEFT JOIN / ajoutez cette ligne après les autres LEFT JOIN :
And if you want to display these informations in a $res loop, add this function in manager\frontinc\functions.php
Deletions:
In/Dans manager\inc\class.basicmanager.php add this line after the other LEFT JOIN / ajoutez cette ligne aprés les autres LEFT JOIN :
And if you want to display this informations in a $res loop, add this function in manager\frontinc\functions.php
Oldest known version of this page was edited on 2005-05-05 04:41:16 by JosselinJaffres []
Page view:
Display the associated website of a news / Afficher le site internet associé à une brève
By
Joss
In/Dans
manager\inc\class.basicmanager.php add this line after the other LEFT JOIN / ajoutez cette ligne aprés les autres LEFT JOIN :
LEFT
JOIN '.$this->con->pfx.'news ON
'.$this->con->pfx.'news.resource_id=
'.$this->con->pfx.'resources.resource_id
';
And if you want to display this informations in a $res loop, add this function in
manager\frontinc\functions.php
Et si vous voulez afficher ces informations dans une boucle $res, ajoutez cette fonction dans
manager\frontinc\functions.php
function pxResAssociatedLink
($s =
'<a href="%1$s">%2$s</a>')
{
if (strlen($GLOBALS['_PX_render']['m']->
res->
f('news_titlewebsite')) >
0) {
echo sprintf($s,
$GLOBALS['_PX_render']['m']->
res->
f('news_linkwebsite'),
$GLOBALS['_PX_render']['m']->
res->
f('news_titlewebsite'));
}
}