/**
* INPUTS
* @deprecated use hErrors()
*/
function ehErrors($return = false)
{
$html = '';
if (function_exists('app_ehErrors')) {
$errors = ErrorsGet();
if (count($errors) == 0) {
return;
}
ErrorsClear();
app_ehErrors($errors);
}
$aErrors = aErrorsClean();
if (count($aErrors) > 0) {
$html .= '<div class="alert alert-error">';
if (vgfGet('ERROR_TITLE') == '') {
// KFD 6/27/07, think this got broken by changes to SQL2 and
// error reporting system, just take it out
//echo "There was an error attempting to save:<br/>";
} elseif (vgfGet('ERROR_TITLE') == '*') {
// do nothing, the asterisk means do nothing
} else {
$html .= vgfGet('ERROR_TITLE');
}
foreach ($aErrors as $error) {
// Don't do htmlentities on errors, as they may contain
// hyperlinks, and they are all system generated so we consider
// them safe.
//echo '<p>'.htmlentities($error).'</p>';
$html .= '<p>' . $error . '</p>';
}
$html .= '</div>';
}
if ($return === true) {
return $html;
} else {
echo $html;
}
}
function fbProcInner($fi, $t)
{
x_EchoFlush("BEGIN FILE PROCESSING");
$FILE = fopen($fi['uname'], 'r');
if (!$FILE) {
x_EchoFlush("Trouble opening local uploaded file.");
x_EchoFlush("ABORT WITH ERROR");
return 0;
}
// Make sure first line is ok
$line1 = fsGets($FILE);
if (strlen($line1) == 0) {
x_EchoFlush("Failed reading first line, file is empty?");
x_EchoFlush("ABORT WITH ERROR");
return 0;
}
if (strlen($line1) > 4998) {
x_EchoFlush("First line is > 4998 bytes, this cannot be right.");
x_EchoFlush("ABORT WITH ERROR");
return 0;
}
// Now convert the first line into the list of columns
$acols = explode('|', $line1);
x_echoFlush("COLUMNS IN FILE:");
foreach ($acols as $acol) {
x_EchoFlush($acol);
}
// Retrieve maps
$mapcols = SQL_AllRows("SELECT column_id,COALESCE(column_id_src,'') as src\n FROM importmapcolumns\n WHERE table_id=" . SQLFC($t['table_id']) . "\n AND importmap=" . SQLFC(gp('gp_map')), 'column_id');
echo "<hr>";
echo "<h2>Map is as follows: " . gp('gp_map') . "</h2>";
hprint_r($mapcols);
echo "<hr>";
// Now convert each line as we go
$linenum = 0;
$linesok = 0;
while (($oneline = fsGets($FILE)) !== false) {
$linenum++;
// Give the user something to believe in
if ($linenum % 100 == 0) {
x_EchoFlush("Line: {$linenum} processing");
}
// Pull the line
$data = explode('|', $oneline);
// Maybe a problem?
if (count($data) != count($acols)) {
x_EchoFlush("ERROR LINE {$linenum}");
x_EchoFlush("Too many or too few values");
hprint_r($data);
continue;
}
// No problem yet, attempt the insert
ErrorsClear();
// Assign first-row column names to incoming data
$row = array_combine($acols, $data);
// Match the values from the map
$rowi = array();
foreach ($mapcols as $mapcol => $info) {
if ($info['src'] != '') {
if (isset($row[$info['src']])) {
$rowi[$mapcol] = $row[$info['src']];
}
}
}
$mixed = array($t['table_id'] => array($rowi));
SQLX_Cleanup($mixed);
SQLX_insert($t, $mixed[$t['table_id']][0]);
// Complaints? Problems? Report them!
if (Errors() && strpos(hErrors(), 'Duplicate Value') === false) {
x_EchoFlush('------------------------------------------------');
x_EchoFlush("ERROR LINE {$linenum} when attempting to insert");
x_EchoFlush(hErrors());
x_EchoFlush('------------------------------------------------');
continue;
}
$linesok++;
}
return array($linenum, $linesok);
}
function MD5_ForgotPage3()
{
$UID = gp('uid');
$md5 = gp('md5');
$pw1 = gp('pw1');
$pw2 = gp('pw2');
fwLogEntry('1025', 'PW Change Attempt', $UID);
if ($pw1 != $pw2) {
ErrorAdd("Password values did not match");
}
if (strlen($pw1) < 6) {
ErrorAdd("Password must be at least 5 characters");
}
if (!preg_match("/[0-9]/", $pw1)) {
ErrorAdd("Password must contain at least one numeric digit");
}
if (!preg_match("/[a-z]/", $pw1)) {
ErrorAdd("Password must contain at least one lower case character");
}
if (!preg_match("/[A-Z]/", $pw1)) {
ErrorAdd("Password must contain at least one upper case character");
}
if (strpos(strtolower($pw1), strtolower($UID)) !== false) {
ErrorAdd("You cannot use your user_id in your password!");
}
if (Errors()) {
echo hErrors();
gpSet('gpp', '2');
ErrorsClear();
return;
}
$row = array('user_id' => $UID, 'md5' => $md5, 'member_password' => $pw1);
SQLX_Insert('users_pwverifies', $row);
if (Errors()) {
echo hErrors();
gpSet('gpp', '2');
ErrorsClear();
return;
} else {
fwLogEntry('1026', 'PW Change Success', $UID);
?>
<p>Your password has been set, you can now
<a href="?gp_page=x_login">Login</a>.
<?php
}
}
