function ForceIncomingString($VariableName, $DefaultValue) {
// First check the querystring
$sReturn = ForceSet(@$_GET[$VariableName], $DefaultValue);
$sReturn = ForceString($sReturn, $DefaultValue);
// If the default value was defined, then check the post variables
if ($sReturn == $DefaultValue) {
$sReturn = ForceSet(@$_POST[$VariableName], $DefaultValue);
$sReturn = ForceString($sReturn, $DefaultValue);
}
// And strip slashes from the string
$sReturn = stripslashes($sReturn);
return $sReturn;
}
function ForceIncomingInt($VariableName, $DefaultValue)
{
// First check the querystring
$iReturn = ForceSet(@$_GET[$VariableName], $DefaultValue);
$iReturn = ForceInt($iReturn, $DefaultValue);
// If the default value was defined, then check the form variables
if ($iReturn == $DefaultValue) {
$iReturn = ForceSet(@$_POST[$VariableName], $DefaultValue);
$iReturn = ForceInt($iReturn, $DefaultValue);
}
// If the value found was less than 0, set it to the default value
if ($iReturn < 0) {
$iReturn == $DefaultValue;
}
return $iReturn;
}
/*
* Copyright 2003 - 2005 Mark O'Sullivan
* This file is part of Vanilla.
* Vanilla is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
* Vanilla is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
* You should have received a copy of the GNU General Public License along with Vanilla; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
* The latest source code for Vanilla is available at www.lussumo.com
* Contact Mark O'Sullivan at mark [at] lussumo [dot] com
*
* Description: File used by Dynamic Data Management object to fill autocomplete data on user input field
*/
include "../appg/settings.php";
include "../appg/init_ajax.php";
$Context->Session->Check(agSAFE_REDIRECT);
$Search = ForceSet(@$_GET["Search"], "");
$Search = urldecode($Search);
$Search = FormatStringForDatabaseInput($Search);
$Sender = ForceIncomingString("Sender", "");
if ($Search != "") {
$s = $Context->ObjectFactory->NewContextObject($Context, "SqlBuilder");
$s->SetMainTable("User", "u");
$s->AddSelect("Name", "u");
$s->AddWhere("Name", $Search . "%", "like");
$s->AddOrderBy("Name", "u", "asc");
$s->AddLimit(0, 10);
$ResultSet = $Context->Database->Select($Context, $s, "Tools", "AutoComplete", "An error occurred while retrieving autocomplete items.", 0);
$Name = "";
$Loop = 1;
if ($ResultSet) {
while ($row = $Context->Database->GetRow($ResultSet)) {