adodbConnection = GetADODBConnection();
+ $this->adodbConnection = &GetADODBConnection();
$this->Clear();
$this->BasePermission="";
@@ -2863,7 +2863,7 @@
{
// use $this->SetTable('live', 'table name');
// in inherited constructors to set table for list
- $this->db =& GetADODBConnection();
+ $this->db =&GetADODBConnection();
}
function SetTable($action, $table_name = null)
Index: trunk/kernel/include/searchconfig.php
===================================================================
diff -u -N -r91 -r534
--- trunk/kernel/include/searchconfig.php (.../searchconfig.php) (revision 91)
+++ trunk/kernel/include/searchconfig.php (.../searchconfig.php) (revision 534)
@@ -230,7 +230,7 @@
{
$this->SourceTable = GetTablePrefix()."SearchConfig";
$this->classname = "clsSearchConfig";
- $this->adodbConnection = GetADODBConnection();
+ $this->adodbConnection = &GetADODBConnection();
$this->Items = array();
if($module)
$this->LoadModule($module);
Index: trunk/kernel/include/itemreview.php
===================================================================
diff -u -N -r366 -r534
--- trunk/kernel/include/itemreview.php (.../itemreview.php) (revision 366)
+++ trunk/kernel/include/itemreview.php (.../itemreview.php) (revision 534)
@@ -4,7 +4,7 @@
{
$count = 0;
$sql = "SELECT count(*) as DupCount FROM $SourceTable WHERE IPAddress='$ip' and ItemId=$id";
- $adodbConnection = GetADODBConnection();
+ $adodbConnection = &GetADODBConnection();
$rs = $adodbConnection->Execute($sql);
if($rs)
{
Index: trunk/kernel/include/emailmessage.php
===================================================================
diff -u -N -r448 -r534
--- trunk/kernel/include/emailmessage.php (.../emailmessage.php) (revision 448)
+++ trunk/kernel/include/emailmessage.php (.../emailmessage.php) (revision 534)
@@ -157,7 +157,7 @@
{
global $objUsers, $objEmailQueue,$objConfig;
- $conn = GetADODBConnection();
+ $conn = &GetADODBConnection();
//$this->recipient = $objUsers->GetUser($UserId);
//$this->recipient->TagPrefix="touser";
if(strlen($EmailAddress))
@@ -206,7 +206,7 @@
{
global $objUsers, $objEmailQueue, $objConfig;
- $conn = GetADODBConnection();
+ $conn = &GetADODBConnection();
//echo "Handling Event ".$this->Get("Event")." for user $UserId
\n";
$this->recipient = new clsPortalUser($UserId); // $objUsers->GetItem($UserId);
//echo "";print_r($this->recipient); echo "
";
@@ -265,7 +265,7 @@
{
global $objUsers, $objConfig, $objEmailQueue;
- $conn = GetADODBConnection();
+ $conn = &GetADODBConnection();
$this->recipient = $objUsers->GetUser($this->Get("FromUserId"));
$this->recipient->TagPrefix="touser";
@@ -691,7 +691,7 @@
$this->MessagesSent++;
$time = time();
- $conn = GetADODBConnection();
+ $conn = &GetADODBConnection();
/* $sql = "INSERT INTO ".GetTablePrefix()."EmailLog VALUES ('', '".htmlspecialchars($From)."', '".htmlspecialchars($To)."', '$Subject', $time, '')";
$conn->Execute($sql);*/
@@ -789,7 +789,7 @@
{
global $objSession;
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$To = mysql_escape_string($To);
$From = mysql_escape_string($From);
$Msg = mysql_escape_string($Msg);
@@ -803,7 +803,7 @@
{
global $objConfig, $objSession, $TotalMessagesSent;
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$MaxAllowed = $this->MessagesAtOnce;
$del_sql = array();
@@ -843,7 +843,7 @@
$headers = "From: $f\n";
$headers .= "MIME-Version: 1.0\n";
- $conn = GetADODBConnection();
+ $conn = &GetADODBConnection();
$time = time();
$sendTo = $ToName;
Index: trunk/admin/users/user_addimage.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/users/user_addimage.php (.../user_addimage.php) (revision 374)
+++ trunk/admin/users/user_addimage.php (.../user_addimage.php) (revision 534)
@@ -147,7 +147,7 @@
$envar = "env=" . BuildEnv() . "&en=$en";
$section = 'in-portal:edituser_image';
-$ado = GetADODBConnection();
+$ado = &GetADODBConnection();
/* page header */
print <<Execute("DELETE FROM UserGroup where UserId='$UserId' AND GroupId='$GroupId'");
break;
@@ -369,7 +369,7 @@
$GroupId = $_POST["GroupId"];
$CatId = $_POST["CategoryId"];
$Module = $_POST["Module"];
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$sql = "SELECT * FROM ".GetTablePrefix()."PermissionConfig WHERE ModuleId='$Module'";
$rs = $ado->Execute($sql);
$PermNames = array();
@@ -437,7 +437,7 @@
break;
case "m_perm_delete_group":
if($ro_perm) break;
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$CatId = $_POST["CategoryId"];
foreach($_POST["itemlist"] as $groupid)
{
@@ -656,7 +656,7 @@
break;
case "m_rel_delete":
- $adodbConnection= GetADODBConnection();
+ $adodbConnection= &GetADODBConnection();
$table = $objSession->GetEditTable("Relationship");
if(isset($_POST["itemlist"]))
{
@@ -685,7 +685,7 @@
//$r = $RelList->Add($_POST["SourceId"],$_POST["SourceType"],$_POST["TargetId"],$_POST["TargetType"],
// 0,(int)$_POST["Enabled"],$_POST["RelType"], $Rel);
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$NewId = $ado->GetOne('SELECT MIN(RelationshipId) as MinValue FROM '.$RelList->SourceTable);
if($NewId > 0) $NewId = 0;
$NewId--;
@@ -841,7 +841,7 @@
$id = $_POST["ItemId"];
$objEditData = new clsCustomDataList(); //$objSession->GetEditTable("CustomMetaData"));
$objEditData->SetTable('edit');
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
if($id && is_array($_POST["CustomData"]))
{
@@ -999,7 +999,7 @@
$r = $objReviews->AddReview($CreatedOn,$ReviewText,$Status, $IPAddress,
(int)$_POST["review_priority"], $_POST["ItemId"],$_POST["ItemType"],
$CreatedById,$html, $post_info['Module']);
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$rs = $ado->Execute("SELECT MIN(ReviewId) as MinValue FROM ".$objReviews->SourceTable);
$NewId = $rs->fields["MinValue"]-1;
$sql = "UPDATE ".$objReviews->SourceTable." SET ReviewId=".$NewId." WHERE ReviewId=".$r->Get("ReviewId");
@@ -1115,7 +1115,7 @@
$t = $objEditItems->AddTheme($_POST["name"],$_POST["description"],(int)$_POST["enabled"],
(int)$_POST["CacheTimeout"],$Primary);
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$rs = $ado->Execute("SELECT MIN(ThemeId) as MinValue FROM ".$objEditItems->SourceTable);
$NewId = $rs->fields["MinValue"]-1;
$sql = "UPDATE ".$objEditItems->SourceTable." SET ThemeId=".$NewId." WHERE ThemeId=".$t->Get("ThemeId");
@@ -1231,7 +1231,7 @@
$_POST["icon"],$_POST["date_format"],$_POST["time_format"],
$_POST["decimal"],$_POST["thousand"]);
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$rs = $ado->Execute("SELECT MIN(LanguageId) as MinValue FROM ".$objEditItems->SourceTable);
$NewId = $rs->fields["MinValue"]-1;
$sql = "UPDATE ".$objEditItems->SourceTable." SET LanguageId=".$NewId." WHERE LanguageId=".$l->Get("LanguageId");
@@ -1293,7 +1293,7 @@
if($_POST["importlabels"]==1 && $_POST["srcpack"]>0)
{
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$rs = $ado->Execute("SELECT * FROM ".GetTablePrefix()."Phrase WHERE LanguageId=".$_POST["srcpack"]);
$plist = new clsPhraseList();
$plist->SourceTable = $objSession->GetEditTable("Phrase");
@@ -1367,7 +1367,7 @@
{
$r = $objPhraseList->AddPhrase($_POST["name"][0],$_POST["LanguageId"],$_POST["translation"][0],$_POST["phrasetype"][0]);
if ($r != "Error") {
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$rs = $ado->Execute("SELECT MIN(PhraseId) as MinValue FROM ".$objPhraseList->SourceTable);
$NewId = $rs->fields["MinValue"]-1;
$sql = "UPDATE ".$objPhraseList->SourceTable." SET PhraseId=".$NewId." WHERE PhraseId=$PhraseId";
@@ -1420,7 +1420,7 @@
foreach($_POST["itemlist"] as $id)
{
$sql = "UPDATE ".$objSession->GetEditTable("Phrase")." SET LanguageId = 0 WHERE PhraseId = ".$id;
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$ado->Execute($sql);
}
}
@@ -1610,7 +1610,7 @@
break;
}
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$NewId = $ado->GetOne('SELECT MIN(ImageId) as MinValue FROM '.$objImageList->SourceTable);
if($NewId > 0) $NewId = 0;
$NewId--;
@@ -1995,7 +1995,7 @@
case "m_sql_query":
if($ro_perm) break;
$SqlQuery = $_POST["sql"];
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
if(strlen($sql))
{
$SqlResult = $ado->Execute(stripslashes($SqlQuery));
@@ -2005,14 +2005,14 @@
break;
case "m_purge_email_log":
if($ro_perm) break;
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$sql = "DELETE FROM ".GetTablePrefix()."EmailLog";
$ado->Execute($sql);
break;
case "m_session_delete":
if($ro_perm) break;
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
if (count($_POST['itemlist']) > 0) {
foreach($_POST["itemlist"] as $id)
{
@@ -2169,7 +2169,7 @@
/* category Edit */
if( GetVar('CatEditStatus') == 1 )
{
- $adodbConnection = GetADODBConnection();
+ $adodbConnection = &GetADODBConnection();
// $sql = "SELECT * FROM ".$objSession->GetEditTable("Category")." WHERE CategoryId=0";
$sql = "SELECT ParentId FROM ".$objSession->GetEditTable("Category")." WHERE CategoryId=-1";
@@ -2279,7 +2279,7 @@
$objEditList = new clsPhraseList();
$objEditList->SourceTable = $objSession->GetEditTable("Phrase");
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$rs = $ado->Execute("SELECT MIN(PhraseId) as MinValue FROM ".$objEditList->SourceTable);
$NewId = $rs->fields["MinValue"]-1;
@@ -2302,7 +2302,7 @@
if( GetVar('MissingLangEditStatus') == 2 )
{
$table = $objSession->GetSessionKey()."_".$ThemeId."_labels";
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$ado->Execute("DROP TABLE IF EXISTS ".$table);
}
Index: trunk/kernel/include/searchitems.php
===================================================================
diff -u -N -r402 -r534
--- trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 402)
+++ trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 534)
@@ -723,7 +723,7 @@
{
global $KeywordIgnore;
- $adodbConnection = GetADODBConnection();
+ $adodbConnection = &GetADODBConnection();
$rs = $adodbConnection->Execute("SELECT * FROM IgnoreKeywords");
while($rs && !$rs->EOF)
Index: trunk/admin/category/addpermission.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/category/addpermission.php (.../addpermission.php) (revision 374)
+++ trunk/admin/category/addpermission.php (.../addpermission.php) (revision 534)
@@ -149,7 +149,7 @@
$p = $objCatList->GetCategory($c->Get("ParentId"));
$objParentPerms->LoadPermTree($p);
-$ado = GetADODBConnection();
+$ado = &GetADODBConnection();
/* page header */
print <<GetSessionKey()."_sendmail";
$MessagesPerPage =2;
Index: trunk/admin/category/addimage.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/category/addimage.php (.../addimage.php) (revision 374)
+++ trunk/admin/category/addimage.php (.../addimage.php) (revision 534)
@@ -151,7 +151,7 @@
$envar = "env=" . BuildEnv() . "&en=$en";
$section = 'in-portal:cat_imageedit';
-$ado = GetADODBConnection();
+$ado = &GetADODBConnection();
/* page header */
print <<MetaTables(); // array_keys($tables);
@@ -158,7 +158,7 @@
$fp = fopen($filename,"a");
if (filesize($filename) == 0) {
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$sql = "SELECT Name, Version FROM ".GetTablePrefix()."Modules";
$r = $ado->Execute($sql);
while ($r && !$r->EOF) {
@@ -206,7 +206,7 @@
{
global $out;
- $conn = GetAdodbConnection();
+ $conn = &GetADODBConnection();
if ($mywhere !="")
{
Index: trunk/admin/users/group_select.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/users/group_select.php (.../group_select.php) (revision 374)
+++ trunk/admin/users/group_select.php (.../group_select.php) (revision 534)
@@ -146,7 +146,7 @@
{
case "addcategory_permissions":
$SelectorType = "radio";
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$sql = "SELECT Distinct(GroupId) FROM ".GetTablePrefix()."Permissions WHERE CatId=".$_GET["CatId"];
//$sql = "SELECT Distinct(p.GroupId) FROM ".GetTablePrefix()."Permissions AS p LEFT JOIN ".GetTablePrefix()."PortalGroup AS pg ON p.GroupId = pg.GroupId WHERE p.CatId=".$_GET["CatId"]." AND pg.Personal=0";
//echo "SQL 1: $sql
";
@@ -174,7 +174,7 @@
case "adduser_groups":
$SelectorType = "radio";
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$sql = sprintf('SELECT GroupId FROM '.GetTablePrefix().'UserGroup WHERE PortalUserId = %s', $_GET["UserId"]);
$inlist = $ado->GetCol($sql);
if($inlist !== false)
Index: trunk/admin/users/user_addpermission.php
===================================================================
diff -u -N -r402 -r534
--- trunk/admin/users/user_addpermission.php (.../user_addpermission.php) (revision 402)
+++ trunk/admin/users/user_addpermission.php (.../user_addpermission.php) (revision 534)
@@ -172,7 +172,7 @@
$UserGroupExists = is_object($UserGroup);
$permlist = array();
- $ado = GetADODBConnection();
+ $ado = &GetADODBConnection();
$sql = "SELECT * FROM ".GetTablePrefix()."PermissionConfig AS pc LEFT JOIN ".GetTablePrefix()."Phrase AS p ON pc.Description = p.Phrase WHERE pc.ModuleId='$PermModule' AND p.LanguageId = ".$objSession->Get("Language")." ORDER BY p.Translation ASC";
if($objSession->HasSystemPermission("DEBUG.LIST"))
Index: trunk/kernel/admin/include/summary/modules.php
===================================================================
diff -u -N -r13 -r534
--- trunk/kernel/admin/include/summary/modules.php (.../modules.php) (revision 13)
+++ trunk/kernel/admin/include/summary/modules.php (.../modules.php) (revision 534)
@@ -53,7 +53,7 @@
END;
- $ado=GetADODBConnection();
+ $ado=&GetADODBConnection();
$rs = $ado->Execute("SELECT * FROM ".GetTablePrefix()."Modules");
while($rs && !$rs->EOF)
{
Index: trunk/admin/backup/restore2.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/backup/restore2.php (.../restore2.php) (revision 374)
+++ trunk/admin/backup/restore2.php (.../restore2.php) (revision 534)
@@ -81,7 +81,7 @@
$formaction = $rootURL."admin/backup/restore3.php?".$envar;
$formaction = "restore3.php?".$envar;
$restoreexit = $rootURL."admin/backup/restore4.php?".$envar;
-$conn = GetAdodbConnection();
+$conn = &GetADODBConnection();
$totalfiles = $objSession->GetVariable("restore_files_num");
Index: trunk/admin/install/inst_ado.php
===================================================================
diff -u -N -r383 -r534
--- trunk/admin/install/inst_ado.php (.../inst_ado.php) (revision 383)
+++ trunk/admin/install/inst_ado.php (.../inst_ado.php) (revision 534)
@@ -1,6 +1,6 @@
Get("CategoryId"),$GroupId);
-$ado = GetADODBConnection();
+$ado = &GetADODBConnection();
$sql = "SELECT DISTINCT(ModuleId) FROM ".GetTablePrefix()."PermissionConfig";
$rs = $ado->Execute($sql);
$Modules = array();
Index: trunk/admin/backup/restore3.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/backup/restore3.php (.../restore3.php) (revision 374)
+++ trunk/admin/backup/restore3.php (.../restore3.php) (revision 534)
@@ -76,7 +76,7 @@
require_once($pathtoroot."admin/toolbar.php");
require_once($pathtoroot.$admin."/install/install_lib.php");
-$conn = GetAdodbConnection();
+$conn = &GetADODBConnection();
$section = "in-portal:restore";
int_header(NULL);
//echo "FileOffset: $FileOffset
\n";
Index: trunk/kernel/startup.php
===================================================================
diff -u -N -r449 -r534
--- trunk/kernel/startup.php (.../startup.php) (revision 449)
+++ trunk/kernel/startup.php (.../startup.php) (revision 534)
@@ -120,7 +120,7 @@
/* startup is complete, so now check the mail queue to see if there's anything that needs to be sent*/
$objEmailQueue->SendMailQeue();
- $ado=GetADODBConnection();
+ $ado=&GetADODBConnection();
$rs = $ado->Execute("SELECT * FROM ".GetTablePrefix()."Modules WHERE LoadOrder = 0");
$kernel_version = $rs->fields['Version'];
Index: trunk/admin/config/addcustomfield.php
===================================================================
diff -u -N -r374 -r534
--- trunk/admin/config/addcustomfield.php (.../addcustomfield.php) (revision 374)
+++ trunk/admin/config/addcustomfield.php (.../addcustomfield.php) (revision 534)
@@ -145,7 +145,7 @@
$section_env = "section=$section&DataType=$FieldType";
$envar = "$section_env&env=".BuildEnv();
-$ado = GetADODBConnection();
+$ado = &GetADODBConnection();
/* page header */
print <<clsItem(TRUE);
- //$this->adodbConnection = GetADODBConnection();
+ //$this->adodbConnection = &GetADODBConnection();
$this->tablename = GetTablePrefix()."Category";
$this->type=1;
$this->BasePermission ="CATEGORY";
@@ -1345,7 +1345,7 @@
$parents = substr($parents, 1, strlen($parents) - 2 );
$parents = explode('|', $parents);
- $db =& GetADODBConnection();
+ $db =&GetADODBConnection();
$sql = 'UPDATE '.$this->tablename.' SET Modified = '.$date.' WHERE CategoryId IN ('.implode(',', $parents).')';
$db->Execute($sql);
}
@@ -2145,7 +2145,7 @@
global $$cat_filter;
$filter = $$cat_filter;
- $adodbConnection = GetADODBConnection();
+ $adodbConnection = &GetADODBConnection();
$sql = "SELECT COUNT(Name) as children from ".$this->SourceTable." where ParentId=" . $ParentID . $filter;
$result = $adodbConnection->Execute($sql);
@@ -2297,7 +2297,7 @@
{
global $objCatList;
- $adodbConnection = GetADODBConnection();
+ $adodbConnection = &GetADODBConnection();
$sql = "select CategoryId from ".GetTablePrefix()."Category where ParentId='$Id'";
$rs = $adodbConnection->Execute($sql);
Index: trunk/tools/explang.php
===================================================================
diff -u -N -r13 -r534
--- trunk/tools/explang.php (.../explang.php) (revision 13)
+++ trunk/tools/explang.php (.../explang.php) (revision 534)
@@ -5,7 +5,7 @@
include_once("kernel/startup.php");
LogEntry("System Init Complete\n");
$fp = fopen($pathtoroot."tools/inportal.lang","w");
-$ado = GetADODBConnection();
+$ado = &GetADODBConnection();
$objLanguages->Query_Item("SELECT * FROM ".$objLanguages->SourceTable);
foreach($objLanguages->Items as $l)
Index: trunk/admin/config/config_general.php
===================================================================
diff -u -N -r13 -r534
--- trunk/admin/config/config_general.php (.../config_general.php) (revision 13)
+++ trunk/admin/config/config_general.php (.../config_general.php) (revision 534)
@@ -52,7 +52,7 @@
Execute($sql);
while($rs & !$rs->EOF)
Index: trunk/kernel/include/systemconfiguration.php
===================================================================
diff -u -N -r13 -r534
--- trunk/kernel/include/systemconfiguration.php (.../systemconfiguration.php) (revision 13)
+++ trunk/kernel/include/systemconfiguration.php (.../systemconfiguration.php) (revision 534)
@@ -13,7 +13,7 @@
{
function SystemConfiguration()
{
- $adodbConnection = GetADODBConnection(); // create a connection
+ $adodbConnection = &GetADODBConnection(); // create a connection
$sql = sprintf("SELECT DefaultLanguage, DefaultTheme, DBSchemaVersion, SystemSecurityContextId FROM SystemConfiguration");
$result = $adodbConnection->Execute($sql);
@@ -104,7 +104,7 @@
if(count($this->m_dirtyFieldsMap) == 0)
return true;
- $adodbConnection = GetADODBConnection();
+ $adodbConnection = &GetADODBConnection();
$sql = 'UPDATE SystemConfiguration SET ';
$first = 1;
@@ -132,7 +132,7 @@
function GetValue($variableName)
{
- $adodbConnection = GetADODBConnection(); // create a connection
+ $adodbConnection = &GetADODBConnection(); // create a connection
$sql = sprintf("SELECT VariableValue FROM ConfigurationValues WHERE VariableName = '%s'",$variableName);
$result = $adodbConnection->Execute($sql);
@@ -147,7 +147,7 @@
function SetValue($variableName, $variableValue)
{
- $adodbConnection = GetADODBConnection(); // create a connection
+ $adodbConnection = &GetADODBConnection(); // create a connection
if($variableValue == NULL) //Remove field
{
$sql = sprintf("DELETE FROM ConfigurationValues WHERE VariableName = '%s'",$variableName);