\n".$submit_criteria['link_name']."
".$locale['417']." ".$locale['418']." \n";
}
} else {
$links = "\n".$locale['414']." \n \n";
}
$result = dbquery("SELECT * FROM ".$db_prefix."submissions WHERE submit_type='n'".(multilang_table("N")?" AND submit_language='".LANGUAGE."'":"")." ORDER BY submit_datestamp DESC");
if (dbrows($result) != "0") {
while ($data = dbarray($result)) {
$submit_criteria = unserialize($data['submit_criteria']);
$news .= "\n".$submit_criteria['news_subject']."
".$locale['417']." ".$locale['418']." \n";
}
} else {
$news = "\n".$locale['415']." \n \n";
}
$result = dbquery("SELECT * FROM ".$db_prefix."submissions WHERE submit_type='a'".(multilang_table("A")?" AND submit_language='".LANGUAGE."'":"")." ORDER BY submit_datestamp DESC");
if (dbrows($result) != "0") {
while ($data = dbarray($result)) {
$submit_criteria = unserialize($data['submit_criteria']);
$articles .= "\n".$submit_criteria['article_subject']."
".$locale['417']." ".$locale['418']." \n";
}
} else {
$articles = "\n".$locale['416']." \n \n";
}
$result = dbquery("SELECT * FROM ".$db_prefix."submissions WHERE submit_type='p'".(multilang_table("PA")?" AND submit_language='".LANGUAGE."'":"")." ORDER BY submit_datestamp DESC");
if (dbrows($result) != "0") {
while ($data = dbarray($result)) {
$submit_criteria = unserialize($data['submit_criteria']);
$photos .= "\n".$submit_criteria['photo_title']."
".$locale['417']." ".$locale['418']." \n";
}
} else {
$photos = "\n".$locale['420']." \n \n";
}
$result = dbquery("SELECT * FROM ".$db_prefix."submissions WHERE submit_type='f'".(multilang_table("D")?" AND submit_language='".LANGUAGE."'":"")." ORDER BY submit_datestamp DESC");
if (dbrows($result) != "0") {
while ($data = dbarray($result)) {
$submit_criteria = unserialize($data['submit_criteria']);
$files .= "\n".$submit_criteria['download_title']."
".$locale['417']." ".$locale['418']." \n";
}
} else {
$files = "\n".$locale['422']." \n \n";
}
opentable($locale['410']);
echo "
".$locale['411']."
$links
".$locale['412']."
$news
".$locale['413']."
$articles
".$locale['419']."
$photos
".$locale['421']."
$files
\n";
closetable();
}
}
if ($stage == "2" && $t == "l") {
if (isset($_POST['add'])) {
$link_name = stripinput($_POST['link_name']);
$link_url = stripinput($_POST['link_url']);
$link_description = stripinput($_POST['link_description']);
$result = dbquery("INSERT INTO ".$db_prefix."weblinks (weblink_name, weblink_description, weblink_url, weblink_cat, weblink_datestamp, weblink_count) VALUES ('$link_name', '$link_description', '$link_url', '".$_POST['link_category']."', '".time()."', '0')");
$result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'");
opentable($locale['430']);
echo "".$data['weblink_cat_name']." \n";
} else {
$opts .= "".$locale['434']." \n";
}
$data = dbarray(dbquery(
"SELECT ts.*, user_id,user_name FROM ".$db_prefix."submissions ts
LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id
WHERE submit_id='$submit_id'"
));
$submit_criteria = unserialize($data['submit_criteria']);
$posted = showdate("longdate", $data['submit_datestamp']);
opentable($locale['440']);
echo "\n";
closetable();
}
}
if ($stage == "2" && $t == "n") {
if (isset($_POST['publish'])) {
$data = dbarray(dbquery(
"SELECT ts.*, user_id,user_name FROM ".$db_prefix."submissions ts
LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id
WHERE submit_id='$submit_id'"
));
$news_subject = stripinput($_POST['news_subject']);
$news_cat = isNum($_POST['news_cat']) ? $_POST['news_cat'] : "0";
$news_body = addslash($_POST['news_body']);
$news_breaks = ($_POST['news_breaks'] == "y") ? "y" : "n";
$result = dbquery("INSERT INTO ".$db_prefix."news (news_subject, news_cat, news_news, news_extended, news_breaks, news_name, news_datestamp, news_start, news_end, news_visibility, news_reads, news_allow_comments, news_allow_ratings, news_language) VALUES ('$news_subject', '$news_cat', '$news_body', '', '$news_breaks', '".$data['user_id']."', '".time()."', '0', '0', '0', '0', '1', '1', '".(multilang_table("N")?LANGUAGE:$settings['locale'])."')");
$result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'");
opentable($locale['490']);
echo "".$data2['news_cat_name']." \n";
}
}
opentable($locale['500']);
echo "\n";
closetable();
}
}
if ($stage == "2" && $t == "a") {
if (isset($_POST['publish'])) {
$data = dbarray(dbquery(
"SELECT ts.*, user_id,user_name FROM ".$db_prefix."submissions ts
LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id
WHERE submit_id='$submit_id'"
));
$submit_criteria = unserialize($data['submit_criteria']);
$article_cat = $_POST['article_cat'];
$article_subject = $_POST['article_subject'];
$article_snippet = addslash($_POST['article_snippet']);
$article_body = addslash($_POST['article_body']);
$article_breaks = ($_POST['article_breaks'] == "y") ? "y" : "n";
$result = dbquery("INSERT INTO ".$db_prefix."articles (article_cat, article_subject, article_snippet, article_article, article_breaks, article_name, article_datestamp, article_reads, article_allow_comments, article_allow_ratings) VALUES ('$article_cat', '$article_subject', '$article_snippet', '$article_body', '$article_breaks', '".$data['user_id']."', '".time()."', '0', '1', '1')");
$result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'");
opentable($locale['530']);
echo "".$data2['article_cat_name']." \n";
}
opentable($locale['540']);
echo "\n";
closetable();
}
}
if ($stage == "2" && $t == "p") {
if (isset($_POST['publish'])) {
require_once INCLUDES."photo_functions_include.php";
$photo_file = ""; $photo_thumb1 = ""; $photo_thumb2 = "";
$data = dbarray(dbquery(
"SELECT ts.*, user_id,user_name,user_avatar FROM ".$db_prefix."submissions ts
LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id
WHERE submit_id='$submit_id'"
));
$submit_criteria = unserialize($data['submit_criteria']);
$photo_title = stripinput($_POST['photo_title']);
$photo_description = stripinput($_POST['photo_description']);
if ($settings['user_photogallery']==1) {
$album_id = isNum($_POST['album_id']) ? $_POST['album_id'] : "UPA";
} else {
$album_id = isNum($_POST['album_id']) ? $_POST['album_id'] : "0";
}
$photo_name = strtolower(substr($submit_criteria['photo_file'], 0, strrpos($submit_criteria['photo_file'], ".")));
$photo_ext = strtolower(strrchr($submit_criteria['photo_file'],"."));
//if users can create image in own album
if ($settings['user_photogallery']==1) {
//if user want to create image in own album
if ($album_id=="UPA") {
//check that user album exists
$uresult = dbquery("SELECT album_id FROM ".$db_prefix."photo_albums WHERE album_user=".$data['user_id']." LIMIT 1");
$urows = dbrows($uresult);
//if user album not exists
if ($urows==0) {
//get user avatar for gallery thumbnail
if ($data['user_avatar']!='' && file_exists(IMAGES."avatars/".$data['user_avatar'])) {
$album_thumb = $data['user_avatar'];
$album_file = image_exists(PHOTOS, $album_thumb);
$albumfile = @getimagesize(IMAGES."avatars/".$album_thumb);
//make thumb for album
//createthumbnail($filetype, $origfile, $thumbfile, $new_w, $new_h)
createthumbnail($albumfile[2], IMAGES."avatars/".$album_thumb, PHOTOS.$album_file, $settings['thumb_w'], $settings['thumb_h']);
} else {
$album_thumb = "imagenotfound.jpg";
$album_file = image_exists(PHOTOS, $album_thumb);
$albumfile = @getimagesize(IMAGES.$album_thumb);
//make unknown thumb for album
//createthumbnail($filetype, $origfile, $thumbfile, $new_w, $new_h)
createthumbnail($albumfile[2], IMAGES.$album_thumb, PHOTOS.$album_file, $settings['thumb_w'], $settings['thumb_h']);
}
//get max album order
$album_order = dbresult(dbquery("SELECT MAX(album_order) FROM ".$db_prefix."photo_albums".(multilang_table("PA")?" WHERE album_language='".LANGUAGE."'":"")), 0) + 1;
$result = dbquery("INSERT INTO ".$db_prefix."photo_albums (album_id, album_title, album_description, album_thumb, album_user, album_access, album_order, album_datestamp, album_language) VALUES ('', '".$data['user_name']."', '".addslashes(sprintf($locale['599'], $data['user_name']))."', '".$album_file."', '".$data['user_id']."', '".$submit_criteria['album_visibility']."', '".$album_order."', '".time()."', '".(multilang_table("PA")?$data['submit_language']:$settings['locale'])."')");
$album_id = mysql_insert_id();
if (!SAFEMODE) @mkdir(PHOTOS."album_".$album_id, 0755);
//if user album exists
} else {
$udata = dbarray($uresult);
$album_id = $udata['album_id'];
}
}
}
define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$album_id."/" : ""));
$photo_dest = PHOTODIR;
$photo_file = image_exists($photo_dest, $photo_name.$photo_ext);
@copy(PHOTOS."submissions/".$submit_criteria['photo_file'], $photo_dest.$photo_file);
@chmod($photo_dest.$photo_file, 0644);
@unlink(PHOTOS."submissions/".$submit_criteria['photo_file']);
$imagefile = @getimagesize($photo_dest.$photo_file);
$photo_thumb1 = image_exists($photo_dest, $photo_name."_t1".$photo_ext);
createthumbnail($imagefile[2], $photo_dest.$photo_file, $photo_dest.$photo_thumb1, $settings['thumb_w'], $settings['thumb_h']);
if ($imagefile[0] > $settings['photo_w'] || $imagefile[1] > $settings['photo_h']) {
$photo_thumb2 = image_exists($photo_dest, $photo_name."_t2".$photo_ext);
createthumbnail($imagefile[2], $photo_dest.$photo_file, $photo_dest.$photo_thumb2, $settings['photo_w'], $settings['photo_h']);
}
$photo_order = dbresult(dbquery("SELECT MAX(photo_order) FROM ".$db_prefix."photos WHERE album_id='$album_id'"), 0) + 1;
$result = dbquery("INSERT INTO ".$db_prefix."photos (album_id, photo_title, photo_description, photo_filename, photo_thumb1, photo_thumb2, photo_datestamp, photo_user, photo_views, photo_order, photo_allow_comments, photo_allow_ratings) VALUES ('$album_id', '$photo_title', '$photo_description', '$photo_file', '$photo_thumb1', '$photo_thumb2', '".time()."', '".$data['submit_user']."', '0', '$photo_order', '1', '1')");
$result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'");
opentable($locale['580']);
echo "".$data2['album_title']." \n";
}
}
if ($settings['user_photogallery']==1) {
if (isset($album_id)) $sel = ($album_id == "UPA" ? " selected" : "");
$photo_albums .= "".sprintf($locale['599'], $data['user_name'])." \n";
}
opentable($locale['590']);
echo "\n";
closetable();
}
}
if ($stage == "2" && $t == "f") {
if (isset($_POST['publish'])) {
$data = dbarray(dbquery(
"SELECT ts.*, user_id,user_name FROM ".$db_prefix."submissions ts
LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id
WHERE submit_id='$submit_id'"
));
$submit_criteria = unserialize($data['submit_criteria']);
$download_title = stripinput($_POST['download_title']);
$download_description = addslash($_POST['download_description']);
$download_cat = isNum($_POST['download_cat']) ? $_POST['download_cat'] : "0";
$download_license = stripinput($_POST['download_license']);
$download_os = stripinput($_POST['download_os']);
$download_version = stripinput($_POST['download_version']);
$download_folder = (stripinput($_POST['download_folder'])=="downloads"?"":stripinput($_POST['download_folder']))."/";
$download_file = stripinput($_POST['download_file']);
$download_filesize = stripinput($_POST['download_filesize']);
$download_url = BASEDIR."http://uploadelvis92.za.pl/downloads/".$download_folder.$download_file;
copy(BASEDIR."http://uploadelvis92.za.pl/downloads/submissions/".$download_file, $download_url);
chmod($download_url, 0644);
unlink(BASEDIR."http://uploadelvis92.za.pl/downloads/submissions/".$download_file);
$result = dbquery("INSERT INTO ".$db_prefix."downloads (download_title, download_description, download_url, download_image, download_cat, download_license, download_os, download_version, download_filesize, download_datestamp, download_count) VALUES ('$download_title', '$download_description', '$download_url', '', '$download_cat', '$download_license', '$download_os', '$download_version', '$download_filesize', '".time()."', '0')");
$result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'");
opentable($locale['650']);
echo "".$data2['download_cat_name']." \n";
}
}
$download_fld = makefilelist(BASEDIR."downloads/", ".|..|submissions", true, "folders");
$download_folders = "";
for ($i=0;$i".$download_fld[$i]."\n";
}
opentable($locale['660']);
echo "\n";
closetable();
}
}
echo "\n";
require_once BASEDIR."footer.php";
?>