public function GetNextID($serviceName)
{
$returnArray = array();
$responseArray = array();
$nextID = 0;
$selectQuery = "select id from idinfo where servicename = :servicename;";
$parameters = array(':servicename' => trim($serviceName));
$stmt = runQuery(DB_SERVER, DB_PORT, DB_USERNAME, DB_USERPASSWORD, DB_NAME, $selectQuery, $parameters);
if ($stmt == QUERY_FAILED) {
return FAILED;
}
$row = fetchNextRow($stmt['statement']);
if ($row != null) {
try {
$nextID = getValue($row, "id");
$nextID = $nextID + 1;
} catch (Exception $e) {
error_log('Database Error: ' . $e->getMessage());
return FAILED;
}
}
$updateQuery = "UPDATE idinfo SET id = :id WHERE servicename = :servicename;";
$parameters = array(':id' => $nextID, ':servicename' => trim($serviceName));
$stmt = runQuery(DB_SERVER, DB_PORT, DB_USERNAME, DB_USERPASSWORD, DB_NAME, $updateQuery, $parameters);
if ($stmt == QUERY_FAILED) {
error_log('Database Error: ' . $e->getMessage());
return FAILED;
}
return $nextID;
}
$sourceMap = createSourceMap();
userCache_init();
$currentLexem = array(0, '');
// Force loading a lexem on the next comparison.
print "<!DOCTYPE dict [\n";
print " <!ENTITY diams \"♦\">\n";
print " <!ENTITY loz \"◊\">\n";
print " <!ENTITY rsquo \"’\">\n";
print "]>\n";
print "<Dictionary>\n";
print " <Timestamp>" . time() . "</Timestamp>\n";
if ($version == '1.0') {
print " <NumResults>" . $defDbResult->rowCount() . "</NumResults>\n";
}
foreach ($defDbResult as $row) {
fetchNextRow($row);
SmartyWrap::assign('version', $version);
SmartyWrap::assign('includeNameWithDiacritics', hasFlag('a'));
SmartyWrap::displayWithoutSkin('xml/update.tpl');
}
print "</Dictionary>\n";
return;
function createSourceMap()
{
$sourceMap = array();
$sources = Model::factory('Source')->find_many();
foreach ($sources as $source) {
$sourceMap[$source->id] = $source;
}
return $sourceMap;
}
public function CheckUsernameAvailability(array $dataArray)
{
$returnArray = array();
$responseArray = array();
$responseArray["usernameExists"] = 0;
//Get email
$username = trim($dataArray["username"]);
$userId = $dataArray["userId"];
$query = "";
$parameters = "";
if ($userId == 0) {
//Check if mFirst account exists
//$data = $this->db->users->find(array("userInfo.username"=>$username));
$query = "select * from users where username = :username;";
$parameters = array(':username' => $username);
} else {
//Check if mFirst account exists
//$data = $this->db->users->find(array("userInfo.username"=>$username,"_id"=>array('$ne'=>$userId)));
$query = "select * from users where username = :username and id <> :userId; ";
$parameters = array(':userId' => $userId, ':username' => $username);
}
$stmt = runQuery(DB_SERVER, DB_PORT, DB_USERNAME, DB_USERPASSWORD, DB_NAME, $query, $parameters);
if ($stmt == QUERY_FAILED) {
error_log('Error: runQuery returned QUERY_FAILED ');
return FAILED;
}
$row = fetchNextRow($stmt['statement']);
if ($row != null) {
$tmp = array();
try {
while ($row != null) {
$tmmp = array();
$tmmp["usernameExists"] = 1;
array_push($tmp, $tmmp);
$row = fetchNextRow($stmt['statement']);
}
array_push($responseArray, $tmp);
$returnArray["success"] = true;
} catch (Exception $e) {
error_log('Error: ' . $e->getMessage());
$returnArray["success"] = false;
}
} else {
error_log('UserDAO: No rows selected');
$tmp = array();
$tmmp = array();
$tmmp["usernameExists"] = 0;
array_push($tmp, $tmmp);
array_push($responseArray, $tmp);
$returnArray["success"] = false;
}
$returnArray["responseArray"] = $responseArray;
return $returnArray;
}
function resultsToString($result, $rowParseFunction)
{
$cumulativeResults = "";
$counter = 0;
$row = fetchNextRow($result);
if ($row == null) {
return "";
} else {
do {
//print_r($row);
$singleRecordString = $rowParseFunction($row);
if ($counter > 0) {
$cumulativeResults .= RECORD_DELIMITER;
}
$cumulativeResults .= $singleRecordString;
$counter++;
$row = fetchNextRow($result);
} while ($row);
return $cumulativeResults;
}
}
