// WRITE system event triggers
$sql = "
SELECT sysevt.name as 'evtname', pe.pluginid, plugs.name
FROM $dbase.".$table_prefix."system_eventnames sysevt
INNER JOIN $dbase.".$table_prefix."site_plugin_events pe ON pe.evtid = sysevt.id
INNER JOIN $dbase.".$table_prefix."site_plugins plugs ON plugs.id = pe.pluginid
WHERE plugs.disabled=0
ORDER BY sysevt.name;
";
$events = array();
$rs = mysql_query($sql);
$limit_tmp = mysql_num_rows($rs); // line146
for ($i=0; $i<$limit_tmp; $i++) {
$evt = mysql_fetch_assoc($rs);
if(!$events[$evt['evtname']]) $events[$evt['evtname']] = array();
$events[$evt['evtname']][] = $evt['name'];
}
foreach($events as $evtname => $pluginnames) {
$tmpPHP .= '$this->pluginEvent[\''.$evtname.'\'] = array(\''.implode("','",$pluginnames)."');\n";
}
so do I add
or die(mysql_error()); to line 145?
ore do I add a new line
$blah = mysql_query($blah) or die(mysql_error());
before line 144?
the result I get from the first option is:
You have an error in your SQL syntax near '; ' at line 7
and the result from the last option is:
hope this helps