/**
* Helper to display userdata content
*/
function showUserdataField($userId, $settingName, $defaultValue = '')
{
global $db;
if (!is_numeric($userId)) {
return false;
}
if (!is_numeric($settingName)) {
$userdata = getUserdataFieldByName($settingName);
if (!$userdata) {
return $defaultValue;
}
}
$q = 'SELECT settingValue FROM tblSettings WHERE ownerId=' . $userId . ' AND settingType=' . SETTING_USERDATA . ' AND settingName="' . $userdata['fieldId'] . '"';
$result = $db->getOneItem($q);
switch ($userdata['fieldType']) {
case USERDATA_TYPE_RADIO:
case USERDATA_TYPE_SELECT:
case USERDATA_TYPE_GENDER:
case USERDATA_TYPE_THEME:
$val = getCategoryName(CATEGORY_USERDATA, $result);
break;
case USERDATA_TYPE_IMAGE:
if (!$result) {
return false;
}
// TODO: Make this an optional setting
if (isInQueue($result, MODERATION_PRES_IMAGE)) {
return false;
}
$val = showThumb($result, $settingName, 270, 200);
break;
default:
$val = $result;
}
return $val;
}
global $globalDatabase;
// MySQL Connection
$connection = mysqli_connect($globalHostName, $globalUserName, $globalPassword, $globalDatabase);
// Connection Error Handling
if ($connection->connect_error) {
// Kill the Connection
die("Could Not Connect to the Database");
}
// MySQL Injection Neutralized Email Variable
$safeEmail = mysqli_real_escape_string($connection, $_REQUEST['inputEmail']);
// Query Preparation
$query = mysqli_prepare($connection, 'SELECT COUNT(*) as total FROM users WHERE email = ?');
$query->bind_param('s', $safeEmail);
// Query Execution
mysqli_stmt_execute($query);
// Query Result Analysis
mysqli_stmt_bind_result($query, $total);
$data = mysqli_stmt_fetch($query);
//-----
$connection->close();
// If That Email is Already Registered...
if ($total > 0) {
echo "true";
return true;
} else {
echo "false";
return false;
}
}
isInQueue();
<?php
/**
* $Id$
*
* Takes a user id, returns this user's presentation image
*/
if (empty($_GET['id']) || !is_numeric($_GET['id'])) {
die;
}
require_once 'find_config.php';
$fieldId = getUserdataFieldIdByType(USERDATA_TYPE_IMAGE);
$fileId = loadUserdataSetting($_GET['id'], $fieldId);
if ($fileId && !isInQueue($fileId, MODERATION_PRES_IMAGE)) {
$h->files->sendFile($fileId, true);
}
