$picture = $timestamp . $ext;
$convertstr = " -scale {$pic_res} -quality {$pic_quality} {$bazar_dir}/{$pic_path}/temp{$ext} {$bazar_dir}/{$pic_path}/{$picture}";
exec($convertpath . $convertstr);
$_picture = "_" . $timestamp . $ext;
$_convertstr = " -scale {$pic_lowres} -quality {$pic_quality} {$bazar_dir}/{$pic_path}/temp{$ext} {$bazar_dir}/{$pic_path}/{$_picture}";
exec($convertpath . $_convertstr);
suppr("{$bazar_dir}/{$pic_path}/temp{$ext}");
if ($pic_database) {
if (!move_uploaded_file_todb("{$bazar_dir}/{$pic_path}/{$picture}", $picture, $type)) {
died("Could NOT copy the file!");
}
suppr("{$bazar_dir}/{$pic_path}/{$picture}");
if (!move_uploaded_file_todb("{$bazar_dir}/{$pic_path}/{$_picture}", $_picture, $type)) {
died("Could NOT copy the file!");
}
suppr("{$bazar_dir}/{$pic_path}/{$_picture}");
}
}
}
}
if ($picture_del) {
$picture = "";
$_picture = "";
}
// Database Update
$query = mysql_query("update " . $prefix . "userdata\n\t\t\t\t\t\t set sex = '{$_POST['sex']}',\n\t\t\t\t newsletter = '{$_POST['newsletter']}',\n\t\t\t\t\t\t firstname = '{$_POST['firstname']}',\n\t\t\t\t\t\t lastname = '{$_POST['lastname']}',\n\t\t\t\t\t\t address = '{$_POST['address']}',\n\t\t\t\t\t\t zip = '{$_POST['zip']}',\n\t\t\t\t\t\t city = '{$_POST['city']}',\n\t\t\t\t\t\t state = '{$_POST['state']}',\n\t\t\t\t\t\t country = '{$_POST['country']}',\n\t\t\t\t\t\t phone = '{$_POST['phone']}',\n\t\t\t\t\t\t cellphone = '{$_POST['cellphone']}',\n\t\t\t\t\t\t icq = '{$_POST['icq']}',\n\t\t\t\t\t\t homepage = '{$_POST['homepage']}',\n\t\t\t\t\t\t hobbys = '{$_POST['hobbys']}',\n picture= '{$picture}',\n _picture= '{$_picture}',\n\t\t\t\t\t\t field1 = '{$_POST['field1']}',\n\t\t\t\t\t\t field2 = '{$_POST['field2']}',\n\t\t\t\t\t\t field3 = '{$_POST['field3']}',\n\t\t\t\t\t\t field4 = '{$_POST['field4']}',\n\t\t\t\t\t\t field5 = '{$_POST['field5']}',\n\t\t\t\t\t\t field6 = '{$_POST['field6']}',\n\t\t\t\t\t\t field7 = '{$_POST['field7']}',\n\t\t\t\t\t\t field8 = '{$_POST['field8']}',\n\t\t\t\t\t\t field9 = '{$_POST['field9']}',\n\t\t\t\t\t\t field10 = '{$_POST['field10']}',\n\t\t\t\t\t\t timezone = '{$_POST['timezone']}',\n\t\t\t\t\t\t dateformat = '{$_POST['dateformat']}'\n\t\t\t where id = '{$_SESSION['suserid']}'") or died(mysql_error());
$_SESSION[susertimezone] = $_POST[timezone];
$_SESSION[suserdateformat] = $_POST[dateformat];
logging("X", "{$_SESSION['suserid']}", "{$_SESSION['susername']}", "AUTH: updated data", "");
if (!$query) {
$m_update = $error[20];
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db['picture3']}'") or died("Database Query Error");
}
if (!$pic_database && $db[_picture3] && is_file("{$bazar_dir}/{$pic_path}/{$db['_picture3']}")) {
suppr("{$bazar_dir}/{$pic_path}/{$db['_picture3']}");
} elseif ($db[_picture3]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db['_picture3']}'") or died("Database Query Error");
}
// Delete Attachments if any ...
if ($db[attachment1] && is_file("{$bazar_dir}/{$att_path}/{$db['attachment1']}")) {
suppr("{$bazar_dir}/{$att_path}/{$db['attachment1']}");
}
if ($db[attachment2] && is_file("{$bazar_dir}/{$att_path}/{$db['attachment2']}")) {
suppr("{$bazar_dir}/{$att_path}/{$db['attachment2']}");
}
if ($db[attachment3] && is_file("{$bazar_dir}/{$att_path}/{$db['attachment3']}")) {
suppr("{$bazar_dir}/{$att_path}/{$db['attachment3']}");
}
// Delete Entry from favorits-DB
mysql_query("delete from " . $prefix . "favorits where adid = '{$adid}'") or died("Database Query Error");
// Delete Entry from ads-DB
mysql_query("delete from " . $prefix . "ads where id = '{$adid}'") or died("Database Query Error");
echo "<div class=\"mainheader\">{$admydel_head}</div>\n";
echo "<br>\n";
echo "<div class=\"smsubmit\">{$admydel_done}<br><br>\n";
if ($_SESSION[susermod]) {
echo "<form action=javascript:window.opener.location.href='classified.php?" . sidstr() . "status=7';window.close(); METHOD=POST><input type=submit value={$close}></form>\n";
} else {
echo "<form action=javascript:window.opener.location.reload();window.close(); METHOD=POST><input type=submit value={$close}></form>\n";
}
echo "</div>\n";
} else {
echo " File {$val} deleted.\n";
}
}
}
}
echo " Attachment cleanup finished\n";
}
// remove old webmails & attachments
if ($webmail_enable && $webmail_storedays) {
$deletestamp = $timestamp - $webmail_storedays * 3600 * 24;
$result = mysql_query("SELECT * FROM " . $prefix . "webmail WHERE timestamp<'{$deletestamp}'") or die(mysql_error());
while ($db = mysql_fetch_array($result)) {
if ($db[attachment1] && is_file("{$bazar_dir}/{$webmail_path}/{$db['attachment1']}")) {
suppr("{$bazar_dir}/{$webmail_path}/{$db['attachment1']}");
}
if ($db[attachment2] && is_file("{$bazar_dir}/{$webmail_path}/{$db['attachment2']}")) {
suppr("{$bazar_dir}/{$webmail_path}/{$db['attachment2']}");
}
if ($db[attachment3] && is_file("{$bazar_dir}/{$webmail_path}/{$db['attachment3']}")) {
suppr("{$bazar_dir}/{$webmail_path}/{$db['attachment3']}");
}
mysql_query("DELETE FROM " . $prefix . "webmail WHERE id='{$db['id']}'") or die(mysql_error());
}
echo " WebMail prune old mails & attachments finished\n";
}
// remove old logevents
if ($logging_enable && $logging_days) {
$deletestamp = $timestamp - $logging_days * 3600 * 24;
mysql_query("DELETE FROM " . $prefix . "logging WHERE timestamp<'{$deletestamp}'") or die(mysql_error());
echo " Logging prune old events finished\n";
}
if (is_file("{$tmp_dir}/tmp_picture{$ext}")) {
$picture_size = filesize("{$tmp_dir}/tmp_picture{$ext}");
$picture_bin = addslashes(fread(fopen("{$tmp_dir}/tmp_picture{$ext}", "r"), $picture_size));
$picinfo = GetImageSize("{$tmp_dir}/tmp_picture{$ext}");
mysql_query("INSERT INTO pictures VALUES ('{$db['picture']}','{$type}','{$picinfo['1']}','{$picinfo['0']}','{$picture_size}','{$picture_bin}')") or die("DB Update Error {$db['picture']} " . mysql_error());
suppr("{$tmp_dir}/tmp_picture{$ext}");
echo "Picture {$db['picture']} stored in Database. (Type: {$ext}, Size: {$picture_size})<br>";
}
$_convertstr = " -geometry {$pic_lowres} -quality {$pic_quality} {$bazar_dir}/{$image_dir}/userpics/{$db['picture']} {$tmp_dir}/tmp_picture{$ext}";
exec($convertpath . $_convertstr);
if (is_file("{$tmp_dir}/tmp_picture{$ext}")) {
$picture_size = filesize("{$tmp_dir}/tmp_picture{$ext}");
$picture_bin = addslashes(fread(fopen("{$tmp_dir}/tmp_picture{$ext}", "r"), $picture_size));
$picinfo = GetImageSize("{$tmp_dir}/tmp_picture{$ext}");
mysql_query("INSERT INTO pictures VALUES ('_{$db['picture']}','{$type}','{$picinfo['1']}','{$picinfo['0']}','{$picture_size}','{$picture_bin}')") or die("DB Update Error {$db['picture']} " . mysql_error());
suppr("{$tmp_dir}/tmp_picture{$ext}");
echo "Picture _{$db['picture']} stored in Database. (Type: {$ext}, Size: {$picture_size})<br>";
}
}
} else {
echo "WARNING: Picture {$db['picture']} wrong Filetype, nothing done.<br>";
}
} else {
echo "ERROR: Picture {$db['picture']} couldn't open.<br>";
}
}
}
echo "<br><b>Logix Classifieds Convert Pictures, Ready ...</b>";
} else {
echo "<b><u>INFOS: </b></u><br>";
$result = mysql_query("SELECT * FROM " . $prefix . "config WHERE type='version' AND name='db'");
suppr("{$bazar_dir}/{$pic_path}/{$db['picture2']}");
} elseif ($db[picture2]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db['picture2']}'") or died(mysql_error());
}
if (!$pic_database && $db[_picture2] && is_file("{$bazar_dir}/{$pic_path}/{$db['_picture2']}")) {
suppr("{$bazar_dir}/{$pic_path}/{$db['_picture2']}");
} elseif ($db[_picture2]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db['_picture2']}'") or died(mysql_error());
}
if (!$pic_database && $db[picture3] && is_file("{$bazar_dir}/{$pic_path}/{$db['picture3']}")) {
suppr("{$bazar_dir}/{$pic_path}/{$db['picture3']}");
} elseif ($db[picture3]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db['picture3']}'") or died(mysql_error());
}
if (!$pic_database && $db[_picture3] && is_file("{$bazar_dir}/{$pic_path}/{$db['_picture3']}")) {
suppr("{$bazar_dir}/{$pic_path}/{$db['_picture3']}");
} elseif ($db[_picture3]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db['_picture3']}'") or died(mysql_error());
}
// Delete Entry from favorits-DB
mysql_query("delete from " . $prefix . "favorits where adid = '{$db['id']}'") or died(mysql_error());
// Delete Entry from ads-DB
mysql_query("delete from " . $prefix . "ads where id = '{$db['id']}'") or died(mysql_error());
}
} else {
// or only overwrite the password :-) better
mysql_query("update " . $prefix . "ads set deleted='1' where userid = '{$_SESSION['suserid']}'") or died(mysql_error());
mysql_query("update " . $prefix . "userdata set password='******',language='xd' where id = '{$_SESSION['suserid']}'") or died(mysql_error());
}
logging("X", "{$_SESSION['suserid']}", "{$_SESSION['susername']}", "AUTH: deleted", "");
logout();
if (!$pic_database && $db[$fieldname] && is_file("{$bazar_dir}/{$pic_path}/{$db[$fieldname]}")) {
suppr("{$bazar_dir}/{$pic_path}/{$db[$fieldname]}");
} elseif ($db[$fieldname]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db[$fieldname]}'") or died("Database Query Error");
}
if (!$pic_database && $db[$_fieldname] && is_file("{$bazar_dir}/{$pic_path}/{$db[$_fieldname]}")) {
suppr("{$bazar_dir}/{$pic_path}/{$db[$_fieldname]}");
} elseif ($db[$_fieldname]) {
mysql_query("delete from " . $prefix . "pictures where picture_name = '{$db[$_fieldname]}'") or died("Database Query Error");
}
}
// Delete Attachments if any ...
for ($i = 1; $i <= 5; $i++) {
$fieldname = "attachment" . $i;
if ($db[$fieldname] && is_file("{$bazar_dir}/{$att_path}/{$db[$fieldname]}")) {
suppr("{$bazar_dir}/{$att_path}/{$db[$fieldname]}");
}
}
// Delete Entry from favorits-DB
mysql_query("delete from " . $prefix . "favorits where adid = '{$db['id']}'") or died("Database Query Error");
// Delete Entry from ads-DB
mysql_query("delete from " . $prefix . "ads where id = '{$db['id']}'") or died("Database Query Error - ads");
}
}
if ($editadid && !$_SESSION[susermod]) {
if ($adeditapproval) {
$locvar = "choice=my&status=13&textmessage=" . rawurlencode($text_msg[1]);
} else {
# $locvar="choice=my&status=13&textmessage=".rawurlencode($text_msg[0]);
$locvar = "choice=my&status=13";
}
