function getComments($forPostKey, $getLimit = 3)
{
$countDS = DB_GetDatasetWQuery('SELECT COUNT(*) as count FROM '.getTableName('messages').'
WHERE m_parent = ? AND m_deleted = "N" AND m_type="post" AND m_votehash = ""
', array($forPostKey));
return(array(
'count' => $countDS['count'],
'votes' => DB_GetList('SELECT COUNT(*) as votecount,m_data,m_id as count FROM '.getTableName('messages').'
WHERE m_parent = ? AND m_deleted = "N" AND m_type="post" AND m_votehash != ""
GROUP BY m_votehash
ORDER BY votecount DESC, m_created ASC
LIMIT 10
', array($forPostKey)),
'list' => array_reverse(DB_GetList('SELECT * FROM '.getTableName('messages').'
WHERE m_parent = ? AND m_deleted = "N" AND m_type="post" AND m_votehash = ""
ORDER BY m_created DESC
LIMIT '.$getLimit, array($forPostKey))),
));
}
function DB_GetDatasetMatch($table, $matchOptions, $fillIfEmpty = true, $noMatchOptions = array())
{
DB_Connect();
$where = array('1');
if (!is_array($matchOptions)) {
$matchOptions = stringParamsToArray($matchOptions);
}
foreach ($matchOptions as $k => $v) {
$where[] = '(' . $k . '="' . DB_Safe($v) . '")';
}
foreach ($noMatchOptions as $k => $v) {
$where[] = '(' . $k . '!="' . DB_Safe($v) . '")';
}
$iwhere = implode(' AND ', $where);
$query = 'SELECT * FROM ' . getTableName($table) . ' WHERE ' . $iwhere;
$resultDS = DB_GetDatasetWQuery($query);
if ($fillIfEmpty && sizeof($resultDS) == 0) {
foreach ($matchOptions as $k => $v) {
$resultDS[$k] = $v;
}
}
profile_point('DB_GetDatasetMatch(' . $table . ', ' . $iwhere . ')');
return $resultDS;
}
<?
$myOldUsername = $this->user->getUsername();
$ctr = 1;
// let's get the attributes exported to us from other services
$infoDS = DB_Getdataset('idaccounts', $this->user->key(), 'ia_user');
$twitterInfo = json_decode($infoDS['ia_properties'], true);
$fbInfo = $twitterInfo;
$openInfo = $twitterInfo;
// let's try to determine sensible user data from the login services
$idAccountWithEmail = DB_GetDatasetWQuery('SELECT * FROM '.getTableName('idaccounts').'
WHERE ia_user=? AND ia_type = "email"', array($this->user->key()));
$defaultEmail = getDefault($openInfo['contact/email'], $fbInfo['email'], $idAccountWithEmail['ia_url']);
// determining a default username idea
$emlName = trim(substr($defaultEmail, 0, strpos($defaultEmail, '@')));
$defaultUsername = safename(getDefault($twitterInfo['screen_name'], $fbInfo['first_name'], $emlName, $openInfo['namePerson/friendly']));
if($defaultUsername != '' && !HubbubEntity::isNameAvailable($defaultUsername))
{
do {
$defaultUsername2 = $defaultUsername.$ctr++;
} while (!HubbubEntity::isNameAvailable($defaultUsername2));
$defaultUsername = $defaultUsername2;
}
// making a reasonable default name of of the email address
$nameParts = array();
foreach(explode('.', $defaultUsername) as $namePart)
$nameParts[] = strtoupper(substr($namePart, 0, 1)).strtolower(substr($namePart, 1));
$emailNameReconstruction = implode(' ', $nameParts);
function findEntityGlobal($record)
{
$rec = array();
$record['server'] = strtolower(trim($record['server']));
$ds = DB_GetDatasetWQuery('SELECT * FROM ' . getTableName('entities') . ' WHERE user=? AND server=?', array($record['user'], getDefault($record['server'], cfg('service/server'))));
if ($ds['_local'] == 'Y') {
$ds['server'] = cfg('service/server');
}
return $ds;
}
