Advanced Multi Uploader Support Product Page
AMU not posting all filenames to dbase table
Asked 05 May 2010 08:57:17
1
has this question
05 May 2010 08:57:17 Heather V posted:
New problems:#1: I've upgraded to DWCS4 (yes, I know CS5 is out), installed AMU extension, it is nowhere to be found (in either the INSERT, DMXZONE menu in DESIGN or DESIGN COMPACT mode or Server Behavior, DMXZONE menu)
#2: AMU works great when I upload ten files at a time on a localhost system and does publish to my dbase table just fine. BUT, when I upload the AMU and all the required files on a live server to make it work and attempt to upload more than one file (the same files I tested on a localhost), the files do upload on the server, but only ONE filename records in the dbase. Why?
I've inserted in the following order:
AMU,SIPP,SIPP,INSERT RECORD
The Form:
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="UploadQueue" id="UploadQueue" onsubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,gif,jpg,jpeg,bmp,png',false,'','','','','','','');return document.MM_returnValue">
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,63,0" width="500" height="350" id="upload1" align="middle">
<param name="FlashVars" value="url=<?php echo urlencode($GP_uploadAction); ?>&formName=UploadQueue&FlashUpload=true<?php if ($ppu->redirectURL <> '') {echo "&redirectUrl=".$ppu->redirectURL;}?>" />
<param name="movie" value="dmxMultiUploader.swf" />
<param name="quality" value="best" />
<param name="wmode" value="transparent" />
<embed src="dmxMultiUploader.swf" name="upload1" quality="best" flashvars="url=<?php echo urlencode($GP_uploadAction); ?>&formName=UploadQueue&FlashUpload=true<?php if ($ppu->redirectURL <> '') {echo "&redirectUrl=".$ppu->redirectURL;}?>" wmode="transparent" type="application/x-shockwave-flash" width="500" height="350" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>
<input name="Filename" type="file" style="display:none" onchange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,gif,jpg,jpeg,bmp,png',false,'','','','','','','')" />
<input type="hidden" name="Filedata" />
<script type="text/javascript">window.upload1 = document.forms["UploadQueue"].upload1;</script>
<input type="hidden" name="MM_insert" value="UploadQueue">
</form><?php require_once('...php'); ?>
<?php require_once('../../ScriptLibrary/incPureUpload.php'); ?>
<?php require_once('../../ScriptLibrary/cGraphicMediator.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
$MM_authorizedUsers = "y";
$MM_donotCheckaccess = "false";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && false) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "../index.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
// Pure PHP Upload 2.1.10
$ppu = new pureFileUpload();
$ppu->path = "../../images/gallery";
$ppu->extensions = "GIF,JPG,JPEG,BMP,PNG,gif,jpg,jpeg,bmp,png";
$ppu->formName = "UploadQueue";
$ppu->storeType = "file";
$ppu->sizeLimit = "";
$ppu->nameConflict = "over";
$ppu->requireUpload = "false";
$ppu->minWidth = "";
$ppu->minHeight = "";
$ppu->maxWidth = "";
$ppu->maxHeight = "";
$ppu->saveWidth = "";
$ppu->saveHeight = "";
$ppu->timeout = "600";
$ppu->progressBar = "";
$ppu->progressWidth = "300";
$ppu->progressHeight = "100";
$ppu->redirectURL = "";
$ppu->checkVersion("2.1.10");
$ppu->doUpload();
?>
<?php
// Smart Image Processor PHP 2.0.7
if (isset($_GET['GP_upload'])) {
$sipp2 = new cGraphicMediator("upload", $ppu, "");
$sipp2->setComponent("Auto");
$sipp2->setMatteColor("#000000");
$sipp2->resize(400, 400, true);
$sipp2->overwrite = true;
$sipp2->saveJPEG(80);
$sipp2->process();
}
?>
<?php
// Smart Image Processor PHP 2.0.7
if (isset($_GET['GP_upload'])) {
$sipp1 = new cGraphicMediator("upload", $ppu, "");
$sipp1->setComponent("Auto");
$sipp1->setMatteColor("#000000");
$sipp1->resize(300, 100, true);
$sipp1->overwrite = false;
$sipp1->setMask("##path##thumbs/##name##.jpg");
$sipp1->saveJPEG(80);
$sipp1->process();
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
if (isset($editFormAction)) {
if (isset($_SERVER['QUERY_STRING'])) {
if (!eregi("GP_upload=true", $_SERVER['QUERY_STRING'])) {
$editFormAction .= "&GP_upload=true";
}
} else {
$editFormAction .= "?GP_upload=true";
}
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "UploadQueue")) {
$insertSQL = sprintf("INSERT INTO gallery (filename) VALUES (%s)",
GetSQLValueString($_POST['Filedata'], "text"));
mysql_select_db($database_radmin, $radmin);
$Result1 = mysql_query($insertSQL, $radmin) or die(mysql_error());
}
?>
<?php
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
?>How do I fix this one?
Replies
Replied 05 May 2010 10:20:14
05 May 2010 10:20:14 Miroslav Zografski replied:
Hello Heather,
Do you remember that I told you you may have a problem with the Restrict Access server behavior?
Please, set a page without RA on it just for test and upload it on your live server.
Regards,
Do you remember that I told you you may have a problem with the Restrict Access server behavior?
Please, set a page without RA on it just for test and upload it on your live server.
Regards,
Replied 05 May 2010 18:35:33
05 May 2010 18:35:33 Heather V replied:
Modified RA using "Securing the Advanced Multi Uploader" suggestion.
Result: filenames record in dbase. First image on list uploads, but second uploads with a broken image link with first SIPP; thumbnails from second SIPP DO NOT UPLOAD. (both files before upload are less than 400K).
Still checking on php.ini.
Result: filenames record in dbase. First image on list uploads, but second uploads with a broken image link with first SIPP; thumbnails from second SIPP DO NOT UPLOAD. (both files before upload are less than 400K).
Still checking on php.ini.
Replied 05 May 2010 23:22:01
05 May 2010 23:22:01 Heather V replied:
AMU with two SIPP's and INSERT working accordingly by following the order above.
Unfortunately, when I add the Advanced Conditional Region following the instructions here, I get the error:
Parse error: syntax error, unexpected $end in C:\yada\yada\insert.php on line 173
Line 173: is </html> but I'm sure there's an insert '}' somewhere that shouldn't be there.
Form:
I had no other way to compare this code. The linked page is for ASP.
Unfortunately, when I add the Advanced Conditional Region following the instructions here, I get the error:
Parse error: syntax error, unexpected $end in C:\yada\yada\insert.php on line 173
Line 173: is </html> but I'm sure there's an insert '}' somewhere that shouldn't be there.
Form:
<?php if (MM_Username<>"") { // Adv Conditional Region ?>
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="UploadQueue" id="UploadQueue" onsubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,gif,jpg,jpeg,bmp,png',false,'','','','','','','');return document.MM_returnValue">
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,63,0" width="500" height="400" id="upload1" align="middle">
<param name="FlashVars" value="url=<?php echo urlencode($GP_uploadAction); ?>&formName=UploadQueue&FlashUpload=true<?php if ($ppu->redirectURL <> '') {echo "&redirectUrl=".$ppu->redirectURL;}?>" />
<param name="movie" value="dmxMultiUploader.swf" />
<param name="quality" value="best" />
<param name="wmode" value="transparent" />
<embed src="dmxMultiUploader.swf" name="upload1" quality="best" flashvars="url=<?php echo urlencode($GP_uploadAction); ?>&formName=UploadQueue&FlashUpload=true<?php if ($ppu->redirectURL <> '') {echo "&redirectUrl=".$ppu->redirectURL;}?>" wmode="transparent" type="application/x-shockwave-flash" width="500" height="400" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object>
<input name="Filename" type="file" style="display:none" onchange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG,gif,jpg,jpeg,bmp,png',false,'','','','','','','')" />
<input type="hidden" name="Filedata" />
<script type="text/javascript">window.upload1 = document.forms["UploadQueue"].upload1;</script>
<input type="hidden" name="MM_insert" value="UploadQueue" />
</form>
<? } // MM_Username<>"" ?>I had no other way to compare this code. The linked page is for ASP.
Replied 07 May 2010 19:15:21
07 May 2010 19:15:21 Heather V replied:
George was mentioning that there is an error in the code after the SB installs it. Apparently, at the end of the form it says
but should be
.
I've made the change and am receiving a different error:
Notice: Use of undefined constant MM_Username - assumed 'MM_Username' in C:\insert.php on line 154
Line 154, of course, is
This is becoming quite frustrating and I would appreciate the developers looking into this further to get this product working.
The start of my code is the following:
<? } // MM_Username<>"" ?>
but should be
<?php } // MM_Username<>"" ?>
.
I've made the change and am receiving a different error:
Notice: Use of undefined constant MM_Username - assumed 'MM_Username' in C:\insert.php on line 154
Line 154, of course, is
<?php if (MM_Username<>"") { // Adv Conditional Region ?>This is becoming quite frustrating and I would appreciate the developers looking into this further to get this product working.
The start of my code is the following:
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "../../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?> Replied 10 May 2010 10:10:47
10 May 2010 10:10:47 Miroslav Zografski replied:
Hello Heather,
You need to remove the RA from that page, keeping only the session start:
Than you need to change the MM_Username with $_SESSION['MM_Username']
so it will be :
instead of :
Regards,
You need to remove the RA from that page, keeping only the session start:
if (!isset($_SESSION)) {
session_start();
}
Than you need to change the MM_Username with $_SESSION['MM_Username']
so it will be :
<?php if (isset($_SESSION['MM_Username'])&&($_SESSION['MM_Username']<>"")) { // Adv Conditional Region ?>
instead of :
<?php if (MM_Username<>"") { // Adv Conditional Region ?>
Regards,

