Index: trunk/kernel/include/parseditem.php =================================================================== diff -u -r725 -r738 --- trunk/kernel/include/parseditem.php (.../parseditem.php) (revision 725) +++ trunk/kernel/include/parseditem.php (.../parseditem.php) (revision 738) @@ -936,8 +936,8 @@ } if(!$found && $LoadFromDB==TRUE) { - $sql = "SELECT * FROM ".$this->SourceTable." WHERE $Field = '$Value'"; - //echo $sql; + $sql = 'SELECT * FROM '.$this->SourceTable.' WHERE '.$Field.' = "'.addslashes($Value).'"'; +// $sql = 'SELECT * FROM '.$this->SourceTable.' WHERE '.$Field.' = "'.($Value).'"'; $res = $this->adodbConnection->Execute($sql); if($res && !$res->EOF) Index: trunk/admin/users/addgroup.php =================================================================== diff -u -r624 -r738 --- trunk/admin/users/addgroup.php (.../addgroup.php) (revision 624) +++ trunk/admin/users/addgroup.php (.../addgroup.php) (revision 738) @@ -179,14 +179,14 @@ > - "> + "> > - +   Index: trunk/admin/users/adduser_custom.php =================================================================== diff -u -r624 -r738 --- trunk/admin/users/adduser_custom.php (.../adduser_custom.php) (revision 624) +++ trunk/admin/users/adduser_custom.php (.../adduser_custom.php) (revision 738) @@ -167,7 +167,7 @@ if(is_object($f)) { - $val_field = "Get("Value")."\" name=\"$fieldname\">"; + $val_field = "Get("Value"))."\" name=\"$fieldname\">"; $field->Set("Value", $val_field); $field->Set("DataId",$f->Get("CustomDataId")); } Index: trunk/admin/users/addgroup_users.php =================================================================== diff -u -r732 -r738 --- trunk/admin/users/addgroup_users.php (.../addgroup_users.php) (revision 732) +++ trunk/admin/users/addgroup_users.php (.../addgroup_users.php) (revision 738) @@ -220,8 +220,8 @@ } else { - $list = '-1'; - $where = "u.PortalUserId = -1 "; + $list=0; + $where = "u.PortalUserId = -1 "; } $order = $objConfig->Get("User_SortOrder"); $SearchWords = $objSession->GetVariable("UserGroupSearchWord"); @@ -245,7 +245,7 @@ echo htmlentities($sql,ENT_NOQUOTES)."
\n"; $objUsers->Query_Item($sql, $objListView->GetLimitSQL() ); -$itemcount = TableCount(GetTablePrefix()."PortalUser", 'PortalUserId IN ('.$list.')',0); +$itemcount = $list?TableCount(GetTablePrefix()."PortalUser","PortalUserId IN ($list)",0):0; $objListView->SetListItems($objUsers); $objListView->IdField = "ResourceId";