the problem i line 4 and 5 is solve now exist error :
Parse error: syntax error, unexpected T_STRING in C:\AppServ\www\components\com_chronoconnectivity\libraries\connection.php(303) : eval()'d code on line 6
this is the code from connection.php :
<?php
/**
* CHRONOCONNECTIVITY version 2.0 stable
* Copyright (c) 2008 Chrono_Man, ChronoEngine.com. All rights reserved.
* Author: Chrono_Man (ChronoEngine.com)
* See readme.html.
* @license GNU/GPL
* Visit http://www.ChronoEngine.com for regular update and information.
**/
defined('_JEXEC') or die('Restricted access');
class CFChronoConnection extends JObject{
var $connectionid;
var $connectionrow;
var $connectionparams;
var $connectionerrors = '';
var $connectiondebug = '';
var $stoploading = false;
var $formtagplaced = false;
function __construct($connectionname = ''){
if (!empty($connectionname)) {
$this->getConnection(trim($connectionname));
}
else
{
//todo: need to load default table properties
//initialise
$this->getConnection(trim($connectionname));
}
}
function &getInstance($connectionname = ''){
static $instances;
if (!isset ($instances)) {
$instances = array ();
}
if (empty($connectionname)) {
$connectionname = trim(JRequest::getVar( 'connectionname'));
}
if(empty($instances[trim($connectionname)])){
$instances[trim($connectionname)] = new CFChronoConnection($connectionname);
return $instances[trim($connectionname)];
}else{
return $instances[trim($connectionname)];
}
}
function getConnection( $connectionname )
{
global $mainframe;
$database =& JFactory::getDBO();
if(!trim($connectionname)){
$connectionname = JRequest::getVar( 'connectionname');
if (!trim($connectionname)) {
$params =& $mainframe->getPageParameters('com_chronocontact');
$connectionname = $params->get('connectionname');
}
}
$query = "SELECT * FROM `#__chronoconnectivity` WHERE `name` = '".$connectionname."'";
$database->setQuery( $query );
$cf_rows = $database->loadObjectList();
if(count($cf_rows)){
$this->connectionrow = $cf_rows[0];
$this->connectionname = $this->connectionrow->name;
//load params
$paramsvalues = new JParameter($this->connectionrow->paramsall);
$this->connectionparams = $paramsvalues;
return true;
}else{
$emptyConnection = new StdClass();
$emptyConnection->id = 0;
$emptyConnection->name = '';
$this->connectionrow = $emptyConnection;
$paramsvalues = new JParameter('');
$this->connectionparams = $paramsvalues;
return false;
}
}
function connectionparams($key, $default = '')
{
return $this->connectionparams->get($key, $default);
}
function setConnectionParam( $param, $value )
{
global $mainframe;
$database =& JFactory::getDBO();
$this->connectionparams->set($param, $value);
}
function setConnectionData( $key, $value )
{
global $mainframe;
$database =& JFactory::getDBO();
$this->connectionrow->$key = $value;
}
function getConnectionName( $connectionid )
{
global $mainframe;
$database =& JFactory::getDBO();
$query = "SELECT * FROM `#__chronoconnectivity` WHERE `id` = '".$connectionid."'";
$database->setQuery( $query );
$cf_rows = $database->loadObjectList();
if(count($cf_rows)){
return $cf_rows[0]->name;
}else{
return false;
}
}
function setConnectionName( $newconnectionname )
{
$this->connectionname = $newconnectionname;
}
function addErrorMsg( $text )
{
$this->connectionerrors = $this->connectionerrors.'<li>'.$text.'</li>';
}
function addDebugMsg( $text )
{
$this->connectiondebug = $this->connectiondebug.'<li>'.$text.'</li>';
}
function showConnection($connectionname, $posted = array())
{
$MyConnection =& CFChronoConnection::getInstance($connectionname);
if(!$MyConnection->connectionrow->id){
echo "There is no connection with this name";
return;
}
$session =& JFactory::getSession();
if(!trim(JRequest::getVar('cfreturnurl'))){
$session->clear('chrono_connection_errors', md5('chrono'));
$session->clear('chrono_connection_data', md5('chrono'));
}
if( trim($MyConnection->connectionparams('enmambots')) == 'Yes'){
$MyConnection->runMambots($MyConnection->connectionrow->name);
}
//$MyPlugins =& CFPlugins::getInstance($MyConnection->connectionrow->id);
//$MyPlugins->runPlugin('', array('ONLOAD', 'ONLOADONSUBMIT'));
if(!$MyConnection->stoploading){
HTML_ChronoConnectivity::showmainlist( $MyConnection->connectionrow, $posted);
}
}
function runMambots($connectionname, $content){
global $mainframe;
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$params =& $mainframe->getParams('com_content');
$dispatcher =& JDispatcher::getInstance();
$type = 'content';
JPluginHelper::importPlugin($type);
$rowmam->text = $content;
$results_mambots = $mainframe->triggerEvent( 'onPrepareContent', array (&$rowmam, & $params, 0 ));
$content = $rowmam->text;
return $content;
}
function buildWhere($connectionname)
{
global $mainframe;
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$posted = explode(",", $MyConnection->connectionparams('posted'));
$geted = explode(",", $MyConnection->connectionparams('geted'));
ob_start();
eval("?>".$MyConnection->connectionrow->SQL);
$WHERE = ob_get_clean();
foreach($posted as $postname){
$WHERE = str_replace("{".trim($postname)."}", $session->get("chronoconnectivity_post_".trim($postname), '', md5('chrono')), $WHERE);
}
foreach($geted as $getname){
$WHERE = str_replace("{".trim($getname)."}", $session->get("chronoconnectivity_get_".trim($getname), '', md5('chrono')), $WHERE);
}
return $WHERE;
}
function getTableFields($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$tables = array( $MyConnection->connectionrow->tablenames );
$result = $database->getTableFields( $tables );
$table_fields = array_keys($result[$MyConnection->connectionrow->tablenames]);
return $table_fields;
}
function buildQuery($connectionname)
{
global $mainframe;
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$WHERE = $MyConnection->buildWhere($connectionname);
//todo: get appropriate connection from connections table to get its data!
$query = "SELECT * FROM ".$MyConnection->connectionrow->tablenames;
if($MyConnection->connectionrow->SQL){
$query = $query." ".trim($WHERE);
}
if(trim($MyConnection->connectionparams('ordersql'))){
$query = $query." ORDER BY ".trim($MyConnection->connectionparams('ordersql'));
}
$pageNav = $MyConnection->buildPageNav($MyConnection->connectionrow->name);
$query .= " LIMIT $pageNav->limitstart,$pageNav->limit";
return $query;
}
function buildPageNav($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$WHERE = $MyConnection->buildWhere($connectionname);
// Pagination
if(JRequest::getVar( 'limit', '', 'post', 'string' )){
$session->set("chronoconnectivity_limit_".$MyConnection->connectionrow->name, JRequest::getVar( 'limit', '', 'post', 'string' ), md5('chrono'));
}
if(JRequest::getVar( 'limit', '', 'post', 'string' ) == "0"){
$session->set("chronoconnectivity_limit_".$MyConnection->connectionrow->name, "0", md5('chrono'));
}
$limit = $session->get('chronoconnectivity_limit_'.$MyConnection->connectionrow->name, (int)$MyConnection->connectionparams('listlimit'), md5('chrono'));
$limitstart = JRequest::getVar('limitstart', 0);
$database->setQuery( "SELECT count(*) FROM ".$MyConnection->connectionrow->tablenames." ".trim($WHERE) );
$total = $database->loadResult();
echo $database->getErrorMsg();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
return $pageNav;
}
function evalPart($connectionname, $part)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$pageNav = $MyConnection->buildPageNav($MyConnection->connectionrow->name);
$MyPermissions =& CFChronoConnectionPermissions::getInstance($MyConnection->connectionrow->id);
${$part} = $MyConnection->connectionrow->$part;
ob_start();
eval("?>".${$part});
${'base_'.$part} = ob_get_clean();
${$part} = ${'base_'.$part};
$formtag = CFChronoConnection::getFormTag($connectionname);
if(!$MyConnection->connectionparams('enformtag', '0')){
if($MyConnection->formtagplaced){
$formtag = '';
}else{
$MyConnection->formtagplaced = true;
}
}else{
$formtag = '';
}
if($formtag){
${$part} = str_replace("{pagination}", $formtag.$pageNav->getListFooter().'</form>', ${$part});
}else{
${$part} = str_replace("{pagination}", $pageNav->getListFooter(), ${$part});
}
if( trim($MyConnection->connectionparams('enmambots')) == 'Yes'){
${$part} = $MyConnection->runMambots($MyConnection->connectionrow->name, ${$part});
}
//add new to head
$authnew = $MyPermissions->checkPermissions('new');
if($authnew){
${$part} = str_replace("{new_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=newrecord').'">'.$MyConnection->connectionparams('newlink', 'New Record').'</a>', ${$part});
}else{
${$part} = str_replace("{new_record}", '', ${$part});
}
return ${$part};
}
function getFormTag($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
return '<form action="index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'" method="post" name="connectivity">';
}
function getBody($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
//$pageNav = $MyConnection->buildPageNav($MyConnection->connectionrow->name);
$MyData =& CFChronoConnectionData::getInstance($MyConnection->connectionrow->id);
$MyPermissions =& CFChronoConnectionPermissions::getInstance($MyConnection->connectionrow->id);
$part = 'body';
${'total_'.$part} = '';
$table_fields = $MyConnection->getTableFields($MyConnection->connectionrow->name);
foreach($MyData->getDataRows() as $MyRow){
${$part} = $MyConnection->connectionrow->$part;
ob_start();
eval("?>".${$part});
${'base_'.$part} = ob_get_clean();
${$part} = ${'base_'.$part};
foreach($table_fields as $table_field){
${$part} = str_replace("{".$table_field."}", $MyRow->$table_field, ${$part});
}
//add edit/delet links
if($MyPermissions->checkPermissions('delete')){
$MyPermissions->setRowPermissions('delete', $MyRow, ${$part});
${$part} = str_replace("{delete_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=deleterecord&cids='.$MyRow->{$MyConnection->connectionparams('primarykey')}).'">'.$MyConnection->connectionparams('deletelink', 'Delete Record').'</a>', ${$part});
}else{
${$part} = str_replace("{delete_record}", '', ${$part});
}
if($MyPermissions->checkPermissions('edit')){
$MyPermissions->setRowPermissions('edit', $MyRow, ${$part});
${$part} = str_replace("{edit_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=editrecord&cids='.$MyRow->{$MyConnection->connectionparams('primarykey')}).'">'.$MyConnection->connectionparams('editlink', 'Edit Record').'</a>', ${$part});
}else{
${$part} = str_replace("{edit_record}", '', ${$part});
}
if($MyPermissions->checkPermissions('new')){
${$part} = str_replace("{new_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=newrecord').'">'.$MyConnection->connectionparams('newlink', 'New Record').'</a>', ${$part});
}else{
${$part} = str_replace("{new_record}", '', ${$part});
}
if( trim($MyConnection->connectionparams('enmambots')) == 'Yes'){
${$part} = $MyConnection->runMambots($MyConnection->connectionrow->name, ${$part});
}
${'total_'.$part} .= ${$part};
}
return ${'total_'.$part};
}
function editRow($connectionname, $rowid)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$MyPermissions =& CFChronoConnectionPermissions::getInstance($MyConnection->connectionrow->id);
$primary = $MyConnection->connectionparams('primarykey');
if($rowid){
if(!$MyPermissions->checkPermissions('edit')){
echo "You are not authorized to view this page, Global Edit error";
return;
}
if(!$MyPermissions->checkRowPermissions('edit', $rowid)){
echo "You are not authorized to view this page, Row Edit Error";
return;
}
$row =& JTable::getInstance(str_replace($mainframe->getCfg('dbprefix'), '', $MyConnection->connectionrow->tablenames), 'Table');
$row->load($rowid);
if(empty($row)&&$MyPermissions->checkPermissions('new')){
$row =& JTable::getInstance(str_replace($mainframe->getCfg('dbprefix'), '', $MyConnection->connectionrow->tablenames), 'Table');
$row->load(0);
}else if(empty($row)&& !$MyPermissions->checkPermissions('new')){
echo "Loading this record failed";
return;
}else{
}
}else{
if(!$MyPermissions->checkPermissions('new')){
echo "You are not authorized to view this page, Global New Record Error";
return;
}else{
$row =& JTable::getInstance(str_replace($mainframe->getCfg('dbprefix'), '', $MyConnection->connectionrow->tablenames), 'Table');
$row->load(0);
}
}
HTML_ChronoConnectivity::editrecord( $MyConnection, $row );
}
function gethash1()
{
global $mainframe;
$database =& JFactory::getDBO();
$configs = JComponentHelper::getParams('com_chronoconnectivity');
if($configs->get('licensevalid', 0)){
return '';
}else{
return base64_decode('ICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBmb2xsb3dpbmcgMyBsaW5lcyBpZiB5b3UgZGlkbid0IGJ1eSBhIENocm9ub0Nvbm5lY3Rpdml0eSBzdWJzY3JpcHRpb24gLS0+IA0KICAgICAgICA8ZGl2IGNsYXNzPSJjaHJvbm9mb3JtIj4NCiAgICAgICAgPGEgaHJlZj0iaHR0cDovL3d3dy5jaHJvbm9lbmdpbmUuY29tIj5Qb3dlcmVkIEJ5IENocm9ub0Nvbm5lY3Rpdml0eSAtIENocm9ub0VuZ2luZS5jb208L2E+DQogICAgICAgIDwvZGl2Pg0KICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBhYm92ZSAzIGxpbmVzIGlmIHlvdSBkaWRuJ3QgYnV5IGEgQ2hyb25vQ29ubmVjdGl2aXR5IHN1YnNjcmlwdGlvbiAtLT4=');
}
}
function gethash2()
{
global $mainframe;
$database =& JFactory::getDBO();
$configs = JComponentHelper::getParams('com_chronoconnectivity');
if($configs->get('licensevalid', 0)){
return '';
}else{
return base64_decode('ICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBmb2xsb3dpbmcgMyBsaW5lcyBpZiB5b3UgZGlkbid0IGJ1eSBhIENocm9ub0Nvbm5lY3Rpdml0eSBzdWJzY3JpcHRpb24gLS0+IA0KICAgICAgICA8ZGl2IGNsYXNzPSJjaHJvbm9mb3JtIj4NCiAgICAgICAgPGEgaHJlZj0iaHR0cDovL3d3dy5jaHJvbm9lbmdpbmUuY29tIj5Qb3dlcmVkIEJ5IENocm9ub0Nvbm5lY3Rpdml0eSAtIENocm9ub0VuZ2luZS5jb208L2E+DQogICAgICAgIDwvZGl2Pg0KICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBhYm92ZSAzIGxpbmVzIGlmIHlvdSBkaWRuJ3QgYnV5IGEgQ2hyb25vQ29ubmVjdGl2aXR5IHN1YnNjcmlwdGlvbiAtLT4=');
}
}
}
Parse error: syntax error, unexpected T_STRING in C:\AppServ\www\components\com_chronoconnectivity\libraries\connection.php(303) : eval()'d code on line 6
this is the code from connection.php :
<?php
/**
* CHRONOCONNECTIVITY version 2.0 stable
* Copyright (c) 2008 Chrono_Man, ChronoEngine.com. All rights reserved.
* Author: Chrono_Man (ChronoEngine.com)
* See readme.html.
* @license GNU/GPL
* Visit http://www.ChronoEngine.com for regular update and information.
**/
defined('_JEXEC') or die('Restricted access');
class CFChronoConnection extends JObject{
var $connectionid;
var $connectionrow;
var $connectionparams;
var $connectionerrors = '';
var $connectiondebug = '';
var $stoploading = false;
var $formtagplaced = false;
function __construct($connectionname = ''){
if (!empty($connectionname)) {
$this->getConnection(trim($connectionname));
}
else
{
//todo: need to load default table properties
//initialise
$this->getConnection(trim($connectionname));
}
}
function &getInstance($connectionname = ''){
static $instances;
if (!isset ($instances)) {
$instances = array ();
}
if (empty($connectionname)) {
$connectionname = trim(JRequest::getVar( 'connectionname'));
}
if(empty($instances[trim($connectionname)])){
$instances[trim($connectionname)] = new CFChronoConnection($connectionname);
return $instances[trim($connectionname)];
}else{
return $instances[trim($connectionname)];
}
}
function getConnection( $connectionname )
{
global $mainframe;
$database =& JFactory::getDBO();
if(!trim($connectionname)){
$connectionname = JRequest::getVar( 'connectionname');
if (!trim($connectionname)) {
$params =& $mainframe->getPageParameters('com_chronocontact');
$connectionname = $params->get('connectionname');
}
}
$query = "SELECT * FROM `#__chronoconnectivity` WHERE `name` = '".$connectionname."'";
$database->setQuery( $query );
$cf_rows = $database->loadObjectList();
if(count($cf_rows)){
$this->connectionrow = $cf_rows[0];
$this->connectionname = $this->connectionrow->name;
//load params
$paramsvalues = new JParameter($this->connectionrow->paramsall);
$this->connectionparams = $paramsvalues;
return true;
}else{
$emptyConnection = new StdClass();
$emptyConnection->id = 0;
$emptyConnection->name = '';
$this->connectionrow = $emptyConnection;
$paramsvalues = new JParameter('');
$this->connectionparams = $paramsvalues;
return false;
}
}
function connectionparams($key, $default = '')
{
return $this->connectionparams->get($key, $default);
}
function setConnectionParam( $param, $value )
{
global $mainframe;
$database =& JFactory::getDBO();
$this->connectionparams->set($param, $value);
}
function setConnectionData( $key, $value )
{
global $mainframe;
$database =& JFactory::getDBO();
$this->connectionrow->$key = $value;
}
function getConnectionName( $connectionid )
{
global $mainframe;
$database =& JFactory::getDBO();
$query = "SELECT * FROM `#__chronoconnectivity` WHERE `id` = '".$connectionid."'";
$database->setQuery( $query );
$cf_rows = $database->loadObjectList();
if(count($cf_rows)){
return $cf_rows[0]->name;
}else{
return false;
}
}
function setConnectionName( $newconnectionname )
{
$this->connectionname = $newconnectionname;
}
function addErrorMsg( $text )
{
$this->connectionerrors = $this->connectionerrors.'<li>'.$text.'</li>';
}
function addDebugMsg( $text )
{
$this->connectiondebug = $this->connectiondebug.'<li>'.$text.'</li>';
}
function showConnection($connectionname, $posted = array())
{
$MyConnection =& CFChronoConnection::getInstance($connectionname);
if(!$MyConnection->connectionrow->id){
echo "There is no connection with this name";
return;
}
$session =& JFactory::getSession();
if(!trim(JRequest::getVar('cfreturnurl'))){
$session->clear('chrono_connection_errors', md5('chrono'));
$session->clear('chrono_connection_data', md5('chrono'));
}
if( trim($MyConnection->connectionparams('enmambots')) == 'Yes'){
$MyConnection->runMambots($MyConnection->connectionrow->name);
}
//$MyPlugins =& CFPlugins::getInstance($MyConnection->connectionrow->id);
//$MyPlugins->runPlugin('', array('ONLOAD', 'ONLOADONSUBMIT'));
if(!$MyConnection->stoploading){
HTML_ChronoConnectivity::showmainlist( $MyConnection->connectionrow, $posted);
}
}
function runMambots($connectionname, $content){
global $mainframe;
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$params =& $mainframe->getParams('com_content');
$dispatcher =& JDispatcher::getInstance();
$type = 'content';
JPluginHelper::importPlugin($type);
$rowmam->text = $content;
$results_mambots = $mainframe->triggerEvent( 'onPrepareContent', array (&$rowmam, & $params, 0 ));
$content = $rowmam->text;
return $content;
}
function buildWhere($connectionname)
{
global $mainframe;
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$posted = explode(",", $MyConnection->connectionparams('posted'));
$geted = explode(",", $MyConnection->connectionparams('geted'));
ob_start();
eval("?>".$MyConnection->connectionrow->SQL);
$WHERE = ob_get_clean();
foreach($posted as $postname){
$WHERE = str_replace("{".trim($postname)."}", $session->get("chronoconnectivity_post_".trim($postname), '', md5('chrono')), $WHERE);
}
foreach($geted as $getname){
$WHERE = str_replace("{".trim($getname)."}", $session->get("chronoconnectivity_get_".trim($getname), '', md5('chrono')), $WHERE);
}
return $WHERE;
}
function getTableFields($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$tables = array( $MyConnection->connectionrow->tablenames );
$result = $database->getTableFields( $tables );
$table_fields = array_keys($result[$MyConnection->connectionrow->tablenames]);
return $table_fields;
}
function buildQuery($connectionname)
{
global $mainframe;
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$WHERE = $MyConnection->buildWhere($connectionname);
//todo: get appropriate connection from connections table to get its data!
$query = "SELECT * FROM ".$MyConnection->connectionrow->tablenames;
if($MyConnection->connectionrow->SQL){
$query = $query." ".trim($WHERE);
}
if(trim($MyConnection->connectionparams('ordersql'))){
$query = $query." ORDER BY ".trim($MyConnection->connectionparams('ordersql'));
}
$pageNav = $MyConnection->buildPageNav($MyConnection->connectionrow->name);
$query .= " LIMIT $pageNav->limitstart,$pageNav->limit";
return $query;
}
function buildPageNav($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$WHERE = $MyConnection->buildWhere($connectionname);
// Pagination
if(JRequest::getVar( 'limit', '', 'post', 'string' )){
$session->set("chronoconnectivity_limit_".$MyConnection->connectionrow->name, JRequest::getVar( 'limit', '', 'post', 'string' ), md5('chrono'));
}
if(JRequest::getVar( 'limit', '', 'post', 'string' ) == "0"){
$session->set("chronoconnectivity_limit_".$MyConnection->connectionrow->name, "0", md5('chrono'));
}
$limit = $session->get('chronoconnectivity_limit_'.$MyConnection->connectionrow->name, (int)$MyConnection->connectionparams('listlimit'), md5('chrono'));
$limitstart = JRequest::getVar('limitstart', 0);
$database->setQuery( "SELECT count(*) FROM ".$MyConnection->connectionrow->tablenames." ".trim($WHERE) );
$total = $database->loadResult();
echo $database->getErrorMsg();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
return $pageNav;
}
function evalPart($connectionname, $part)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$pageNav = $MyConnection->buildPageNav($MyConnection->connectionrow->name);
$MyPermissions =& CFChronoConnectionPermissions::getInstance($MyConnection->connectionrow->id);
${$part} = $MyConnection->connectionrow->$part;
ob_start();
eval("?>".${$part});
${'base_'.$part} = ob_get_clean();
${$part} = ${'base_'.$part};
$formtag = CFChronoConnection::getFormTag($connectionname);
if(!$MyConnection->connectionparams('enformtag', '0')){
if($MyConnection->formtagplaced){
$formtag = '';
}else{
$MyConnection->formtagplaced = true;
}
}else{
$formtag = '';
}
if($formtag){
${$part} = str_replace("{pagination}", $formtag.$pageNav->getListFooter().'</form>', ${$part});
}else{
${$part} = str_replace("{pagination}", $pageNav->getListFooter(), ${$part});
}
if( trim($MyConnection->connectionparams('enmambots')) == 'Yes'){
${$part} = $MyConnection->runMambots($MyConnection->connectionrow->name, ${$part});
}
//add new to head
$authnew = $MyPermissions->checkPermissions('new');
if($authnew){
${$part} = str_replace("{new_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=newrecord').'">'.$MyConnection->connectionparams('newlink', 'New Record').'</a>', ${$part});
}else{
${$part} = str_replace("{new_record}", '', ${$part});
}
return ${$part};
}
function getFormTag($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
return '<form action="index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'" method="post" name="connectivity">';
}
function getBody($connectionname)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
//$pageNav = $MyConnection->buildPageNav($MyConnection->connectionrow->name);
$MyData =& CFChronoConnectionData::getInstance($MyConnection->connectionrow->id);
$MyPermissions =& CFChronoConnectionPermissions::getInstance($MyConnection->connectionrow->id);
$part = 'body';
${'total_'.$part} = '';
$table_fields = $MyConnection->getTableFields($MyConnection->connectionrow->name);
foreach($MyData->getDataRows() as $MyRow){
${$part} = $MyConnection->connectionrow->$part;
ob_start();
eval("?>".${$part});
${'base_'.$part} = ob_get_clean();
${$part} = ${'base_'.$part};
foreach($table_fields as $table_field){
${$part} = str_replace("{".$table_field."}", $MyRow->$table_field, ${$part});
}
//add edit/delet links
if($MyPermissions->checkPermissions('delete')){
$MyPermissions->setRowPermissions('delete', $MyRow, ${$part});
${$part} = str_replace("{delete_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=deleterecord&cids='.$MyRow->{$MyConnection->connectionparams('primarykey')}).'">'.$MyConnection->connectionparams('deletelink', 'Delete Record').'</a>', ${$part});
}else{
${$part} = str_replace("{delete_record}", '', ${$part});
}
if($MyPermissions->checkPermissions('edit')){
$MyPermissions->setRowPermissions('edit', $MyRow, ${$part});
${$part} = str_replace("{edit_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=editrecord&cids='.$MyRow->{$MyConnection->connectionparams('primarykey')}).'">'.$MyConnection->connectionparams('editlink', 'Edit Record').'</a>', ${$part});
}else{
${$part} = str_replace("{edit_record}", '', ${$part});
}
if($MyPermissions->checkPermissions('new')){
${$part} = str_replace("{new_record}", '<a href="'.JRoute::_('index.php?option=com_chronoconnectivity&connectionname='.$MyConnection->connectionrow->name.'&task=newrecord').'">'.$MyConnection->connectionparams('newlink', 'New Record').'</a>', ${$part});
}else{
${$part} = str_replace("{new_record}", '', ${$part});
}
if( trim($MyConnection->connectionparams('enmambots')) == 'Yes'){
${$part} = $MyConnection->runMambots($MyConnection->connectionrow->name, ${$part});
}
${'total_'.$part} .= ${$part};
}
return ${'total_'.$part};
}
function editRow($connectionname, $rowid)
{
global $mainframe;
$database =& JFactory::getDBO();
$session =& JFactory::getSession();
$MyConnection =& CFChronoConnection::getInstance($connectionname);
$MyPermissions =& CFChronoConnectionPermissions::getInstance($MyConnection->connectionrow->id);
$primary = $MyConnection->connectionparams('primarykey');
if($rowid){
if(!$MyPermissions->checkPermissions('edit')){
echo "You are not authorized to view this page, Global Edit error";
return;
}
if(!$MyPermissions->checkRowPermissions('edit', $rowid)){
echo "You are not authorized to view this page, Row Edit Error";
return;
}
$row =& JTable::getInstance(str_replace($mainframe->getCfg('dbprefix'), '', $MyConnection->connectionrow->tablenames), 'Table');
$row->load($rowid);
if(empty($row)&&$MyPermissions->checkPermissions('new')){
$row =& JTable::getInstance(str_replace($mainframe->getCfg('dbprefix'), '', $MyConnection->connectionrow->tablenames), 'Table');
$row->load(0);
}else if(empty($row)&& !$MyPermissions->checkPermissions('new')){
echo "Loading this record failed";
return;
}else{
}
}else{
if(!$MyPermissions->checkPermissions('new')){
echo "You are not authorized to view this page, Global New Record Error";
return;
}else{
$row =& JTable::getInstance(str_replace($mainframe->getCfg('dbprefix'), '', $MyConnection->connectionrow->tablenames), 'Table');
$row->load(0);
}
}
HTML_ChronoConnectivity::editrecord( $MyConnection, $row );
}
function gethash1()
{
global $mainframe;
$database =& JFactory::getDBO();
$configs = JComponentHelper::getParams('com_chronoconnectivity');
if($configs->get('licensevalid', 0)){
return '';
}else{
return base64_decode('ICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBmb2xsb3dpbmcgMyBsaW5lcyBpZiB5b3UgZGlkbid0IGJ1eSBhIENocm9ub0Nvbm5lY3Rpdml0eSBzdWJzY3JpcHRpb24gLS0+IA0KICAgICAgICA8ZGl2IGNsYXNzPSJjaHJvbm9mb3JtIj4NCiAgICAgICAgPGEgaHJlZj0iaHR0cDovL3d3dy5jaHJvbm9lbmdpbmUuY29tIj5Qb3dlcmVkIEJ5IENocm9ub0Nvbm5lY3Rpdml0eSAtIENocm9ub0VuZ2luZS5jb208L2E+DQogICAgICAgIDwvZGl2Pg0KICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBhYm92ZSAzIGxpbmVzIGlmIHlvdSBkaWRuJ3QgYnV5IGEgQ2hyb25vQ29ubmVjdGl2aXR5IHN1YnNjcmlwdGlvbiAtLT4=');
}
}
function gethash2()
{
global $mainframe;
$database =& JFactory::getDBO();
$configs = JComponentHelper::getParams('com_chronoconnectivity');
if($configs->get('licensevalid', 0)){
return '';
}else{
return base64_decode('ICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBmb2xsb3dpbmcgMyBsaW5lcyBpZiB5b3UgZGlkbid0IGJ1eSBhIENocm9ub0Nvbm5lY3Rpdml0eSBzdWJzY3JpcHRpb24gLS0+IA0KICAgICAgICA8ZGl2IGNsYXNzPSJjaHJvbm9mb3JtIj4NCiAgICAgICAgPGEgaHJlZj0iaHR0cDovL3d3dy5jaHJvbm9lbmdpbmUuY29tIj5Qb3dlcmVkIEJ5IENocm9ub0Nvbm5lY3Rpdml0eSAtIENocm9ub0VuZ2luZS5jb208L2E+DQogICAgICAgIDwvZGl2Pg0KICAgICAgICA8IS0tIERvbid0IHJlbW92ZSBvciBlZGl0IHRoZSBhYm92ZSAzIGxpbmVzIGlmIHlvdSBkaWRuJ3QgYnV5IGEgQ2hyb25vQ29ubmVjdGl2aXR5IHN1YnNjcmlwdGlvbiAtLT4=');
}
}
}