SQL редактиране

Anelis

Registered
Инсталирам ads_manager - joomla
Показва ми следното: Warning: implode() [function.implode]: Invalid arguments passed in /www/creditgroup.bg/www/root/components/com_adsmanager/adsmanager.php on line 1995
DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=DELETE FROM jos_adsmanager_ads WHERE id IN ()

Доколкото разбирам трябва да редактирам SQL синтаксиса, ако може някой да ми каже как става това - Благодаря
 
<?php
// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );

if (!defined( '_MOS_ADSMANAGER_MODULE' )) {
/** ensure that functions are declared only once */
define( '_MOS_ADSMANAGER_MODULE', 1 );

function reorderDate( $date ){
return mosFormatDate($date);
}

function displayVerticalLatestAds($ads,$image,$itemid,$nb_images,$displaycategory,$displaydate)
{
global $mosConfig_absolute_path,$mosConfig_live_site;

if ($image == 1)
{
?>
<ul class="adsmanager_ver_list">
<?php
if(isset($ads[0])) {
foreach($ads as $row) {
?>
<li>
<?php
$linkTarget = sefRelToAbs("index.php?option=com_adsmanager&page=show_ad&adid=".$row->id."&Itemid=".$itemid);
$ok = 0;$i=1;
while(!$ok)
{
if ($i < $nb_images + 1)
{
$ext_name = chr(ord('a')+$i-1);
$pic = $mosConfig_absolute_path."/images/com_adsmanager/ads/".$row->id.$ext_name."_t.jpg";
if (file_exists( $pic))
{
echo "<div align='center'><a href='".$linkTarget."'><img src='".$mosConfig_live_site."/images/com_adsmanager/ads/".$row->id.$ext_name."_t.jpg' alt='".htmlspecialchars(stripslashes($row->ad_headline),ENT_QUOTES)."' border='0' /></a>";
$ok = 1;
}
}
else
{
echo "<div align='center'><a href='".$linkTarget."'><img src='".$mosConfig_live_site."/components/com_adsmanager/images/nopic.gif' alt='noimage' border='0' /></a>";
$ok = 1;
}
$i++;
}
echo "<br /><a href='$linkTarget'>".stripslashes($row->ad_headline)."</a>";
if ($displaycategory == 1)
echo "<br /><span class=\"adsmanager_cat\">(".$row->parent." / ".$row->cat.")</span>";
if ($displaydate == 1)
echo "<br />".reorderDate($row->date_created);
echo "</div>";
?>
</li>
<?php
} }
?>
</ul>
<?php
}
else
{
?>
<ul class="mostread">
<?php
if (isset($ads[0])){
foreach($ads as $row) {
?>
<li class="mostread">
<?php
$linkTarget = sefRelToAbs("index.php?option=com_adsmanager&page=show_ad&adid=".$row->id."&catid=".$row->category."&Itemid=".$itemid);
echo "<a href='$linkTarget'>".stripslashes($row->ad_headline)."</a>";
if ($displaycategory == 1)
echo " <span class=\"adsmanager_cat\">(".$row->parent." / ".$row->cat.")";
if ($displaydate == 1)
echo " ".reorderDate($row->date_created)."</span>";
?>
</li>
<?php
}}
?>
</ul>
<?php
}
}

function displayHorizontalLatestAds($ads,$image,$itemid,$nb_images,$displaycategory,$displaydate)
{
global $mosConfig_absolute_path,$mosConfig_live_site;
if ($image == 1)
{
?>
<div class='adsmanager_box_module_2'>
<table class='adsmanager_inner_box_2' width="100%">
<tr align="center">
<?php
$ads_by_row = 4;
$num_ads = 0;
if (isset($ads[0])) {
foreach($ads as $row) {
if ($num_ads >= $ads_by_row) {
echo "</tr><tr>";
$num_ads = 0;
}
?>
<td>
<?php
$linkTarget = sefRelToAbs("index.php?option=com_adsmanager&page=show_ad&adid=".$row->id."&Itemid=".$itemid);
$ok = 0;$i=1;
while(!$ok)
{
if ($i < $nb_images + 1)
{
$ext_name = chr(ord('a')+$i-1);
$pic = $mosConfig_absolute_path."/images/com_adsmanager/ads/".$row->id.$ext_name."_t.jpg";
if (file_exists( $pic))
{
echo "<div align='center'><a href='".$linkTarget."'><img src='".$mosConfig_live_site."/images/com_adsmanager/ads/".$row->id.$ext_name."_t.jpg' alt='".htmlspecialchars(stripslashes($row->ad_headline),ENT_QUOTES)."' border='0' /></a>";
$ok = 1;
}
}
else
{
echo "<div align='center'><a href='".$linkTarget."'><img src='".$mosConfig_live_site."/components/com_adsmanager/images/nopic.gif' alt='noimage' border='0' /></a>";
$ok = 1;
}
$i++;
}

echo "<br /><a href='$linkTarget'>".stripslashes($row->ad_headline)."</a>";
if ($displaycategory == 1)
echo "<br /><span class=\"adsmanager_cat\">(".$row->parent." / ".$row->cat.")</span>";
if ($displaydate == 1)
echo "<br />".reorderDate($row->date_created);
echo "</div>";
?>
</td>
<?php
$num_ads ++;
} }
for(;$num_ads < $ads_by_row;$num_ads++)
{
echo "<td></td>";
}
?>
</tr>
</table>
</div>
<?php
}
else
{
?>
<ul class="mostread">
<?php
if (isset($ads[0])) {
foreach($ads as $row) {
?>
<li class="mostread">
<?php
$linkTarget = sefRelToAbs("index.php?option=com_adsmanager&page=show_ad&adid=".$row->id."&catid=".$row->category."&Itemid=".$itemid);
echo "<a href='$linkTarget'>".stripslashes($row->ad_headline)."</a>";
if ($displaycategory == 1)
echo "<br /><span class=\"adsmanager_cat\">(".$row->parent." / ".$row->cat.")</span>";
if ($displaydate == 1)
echo "<br />".reorderDate($row->date_created);
?>
</li>
<?php
} }
?>
</ul>
<?php
}
}

//$mainframe->addCustomHeadTag('<link rel="stylesheet" href="'.$mosConfig_live_site.'/components/com_adsmanager/css/adsmanager.css" type="text/css" />');
?>
<link rel="stylesheet" href="<?php echo $mosConfig_live_site; ?>/components/com_adsmanager/css/adsmanager.css" type="text/css" />
<?php
}
$nb_ads = intval($params->get( 'nb_ads', 3 )) ;
$image = intval($params->get( 'image', 1 )) ;
$itemid = intval($params->get( 'default_itemid', mosGetParam( $_GET, 'Itemid', 0 ) )) ;
$sort_sql = intval($params->get( 'random',0));

$catselect = $params->get('catselect',"no");
$displaycategory = intval($params->get( 'displaycategory',1));
$displaydate = intval($params->get( 'displaydate',1));

switch($sort_sql)
{
/* Popular */
case 2:
$order_sql = "ORDER BY a.views DESC,a.date_created DESC ,a.id DESC ";
break;

/* Random */
case 1:
$order_sql = "ORDER BY RAND() ";
break;

/* Latest */
case 0:
default:
$order_sql = "ORDER BY a.date_created DESC ,a.id DESC ";
break;
}

$cat_query = "";
switch($catselect)
{
case "no";
break;

case "-1":
$catid = intval(mosGetParam( $_GET, 'catid', 0 ));
if (($catid != 0)&&($catid != -1))
{
$cat_query = "a.category = $catid AND ";
}
break;
default:
$cat_query = "a.category = $catselect AND ";
break;
}

$database->setQuery("SELECT a.id, a.ad_headline, a.category, a.date_created,p.id as parentid,p.name as parent,c.id as catid, c.name as cat ".
"FROM #__adsmanager_ads as a ".
"LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id ".
"LEFT JOIN #__users as u ON a.userid = u.id ".
"LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id ".
"LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id ".
"WHERE $cat_query c.published = 1 and a.published = 1 GROUP BY a.id $order_sql LIMIT 0, $nb_ads");

$ads = $database->loadObjectList();

// get configuration
$database->setQuery( "SELECT * FROM #__adsmanager_config");
$confs = $database->loadObjectList();
if ($database -> getErrorNum()) {
echo $database -> stderr();
return false;
}

if ( file_exists( $mosConfig_absolute_path . "/components/com_paidsystem/api.paidsystem.php"))
{
require_once($mosConfig_absolute_path . "/components/com_paidsystem/api.paidsystem.php");
}

$nbimages = $confs[0]->nb_images;
if (function_exists("getMaxPaidSystemImages"))
{
$nbimages += getMaxPaidSystemImages();
}

switch ( $params->get( 'style', 'hor' ) ) {
case 'ver':
displayVerticalLatestAds($ads,$image,$itemid,$confs[0]->nb_images,$displaycategory,$displaydate);
break;

case 'hor':
default:
displayHorizontalLatestAds($ads,$image,$itemid,$confs[0]->nb_images,$displaycategory,$displaydate);
break;
}
?>
 

Горе