dsaba Posted March 15, 2007 Share Posted March 15, 2007 hey guys! I can't seem to find the reason for this parse error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on line 765 here is the code snippet it starts off at line 758 elseif (langcookie == "he") { $filenamequery = mysql_query("SELECT filename_he FROM mainfilelist WHERE filename_he='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_he']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it go back and choose a different title"); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_he`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_he`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; it looks big but its just because its a really big insert query line 765 is where right after it says "die(blablabla);" Quote Link to comment Share on other sites More sharing options...
dsaba Posted March 15, 2007 Author Share Posted March 15, 2007 the whole thing is a if/elseif/elseif/elseif statement this part where it has trouble is specifically the first elseif statement after the if statement here is the full elseifstatement where it has that error elseif (langcookie == "he") { $filenamequery = mysql_query("SELECT filename_he FROM mainfilelist WHERE filename_he='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_he']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_he`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_he`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end HEBREW insertions } } Quote Link to comment Share on other sites More sharing options...
btherl Posted March 15, 2007 Share Posted March 15, 2007 Can you make the entire script available? Or at least the function containing this code, so we can do automated syntax checking. If I copy and paste what you've posted I get a whole heap of unrelated errors. And it's too messy to check manually. Quote Link to comment Share on other sites More sharing options...
dsaba Posted March 15, 2007 Author Share Posted March 15, 2007 sure no problem, by the way if you have some method of checking syntax automatically can you please tell me? here is the full if/elseif/elseif/elseif.... function if (langcookie == "en") { $filenamequery = mysql_query("SELECT filename_en FROM mainfilelist WHERE filename_en='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_en']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_en`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_en`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end ENGLISH insertions } } elseif (langcookie == "he") { $filenamequery = mysql_query("SELECT filename_he FROM mainfilelist WHERE filename_he='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_he']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_he`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_he`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end HEBREW insertions } } elseif (langcookie == "es") { $filenamequery = mysql_query("SELECT filename_es FROM mainfilelist WHERE filename_es='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_es']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_es`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_es`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end SPANISH insertions } } elseif (langcookie == "pt") { $filenamequery = mysql_query("SELECT filename_pt FROM mainfilelist WHERE filename_pt='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_pt']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_pt`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_pt`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end PORTUGUESE insertions } } elseif (langcookie == "pl") { $filenamequery = mysql_query("SELECT filename_pl FROM mainfilelist WHERE filename_pl='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_pl']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_pl`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_pl`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end POLISH insertions } } elseif (langcookie == "NULL") { $filenamequery = mysql_query("SELECT filename_en FROM mainfilelist WHERE filename_en='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_en']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_en`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_en`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = <<<FILELINK <a href="/video.php?id=$fetchedfileid" target="_self">$filename</a> FILELINK; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end ENGLISH/NULL insertions } } Quote Link to comment Share on other sites More sharing options...
skali Posted March 15, 2007 Share Posted March 15, 2007 <?php if (langcookie == "en") { $filenamequery = mysql_query("SELECT filename_en FROM mainfilelist WHERE filename_en='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_en']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_en`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_en`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = '<a href="/video.php?id=$fetchedfileid" target="_self">$filename</a>'; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end ENGLISH insertions } } elseif (langcookie == "he") { $filenamequery = mysql_query("SELECT filename_he FROM mainfilelist WHERE filename_he='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_he']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_he`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_he`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = '<a href="/video.php?id=$fetchedfileid" target="_self">$filename</a>'; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end HEBREW insertions } } elseif (langcookie == "es") { $filenamequery = mysql_query("SELECT filename_es FROM mainfilelist WHERE filename_es='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_es']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_es`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_es`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = '<a href="/video.php?id=$fetchedfileid" target="_self">$filename</a>'; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end SPANISH insertions } } elseif (langcookie == "pt") { $filenamequery = mysql_query("SELECT filename_pt FROM mainfilelist WHERE filename_pt='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_pt']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_pt`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_pt`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = '<a href="/video.php?id=$fetchedfileid" target="_self">$filename</a>'; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end PORTUGUESE insertions } } elseif (langcookie == "pl") { $filenamequery = mysql_query("SELECT filename_pl FROM mainfilelist WHERE filename_pl='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_pl']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_pl`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_pl`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = '<a href="/video.php?id=$fetchedfileid" target="_self">$filename</a>'; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end POLISH insertions } } elseif (langcookie == "NULL") { $filenamequery = mysql_query("SELECT filename_en FROM mainfilelist WHERE filename_en='$filename'"); $filenamequeryrow = mysql_fetch_array($filenamequery); $fromquery = $filenamequeryrow['filename_en']; if ($fromquery == $filename) { mysql_close(); die("This file title appears to be taken or you may have already submitted it, go back and choose a different title."); } else { $query1 = "INSERT INTO `mainfilelist` ( `filename_en`, `filegeneraltype_en`, `filegeneraltype_he`, `filegeneraltype_es`, `filegeneraltype_pt`, `filegeneraltype_pl`, `filespecifictype_en`, `filespecifictype_he`, `filespecifictype_es`, `filespecifictype_pt`, `filespecifictype_pl`, `fileifwalla`, `fileifyahoo`, `fileifgmail`, `fileiflycos`, `filenumwalla`, `filenumyahoo`, `filenumgmail`, `filenumlycos`, `filetotalmirrors`, `filewhatmirrors`, `filelanguage_en`, `filelanguage_he`, `filelanguage_es`, `filelanguage_pt`, `filelanguage_pl`, `fileifsubtitles_en`, `fileifsubtitles_he`, `fileifsubtitles_es`, `fileifsubtitles_pt`, `fileifsubtitles_pl`, `filesubtitlelang_en`, `filesubtitlelang_he`, `filesubtitlelang_es`, `filesubtitlelang_pt`, `filesubtitlelang_pl`, `fileifpassword_en`, `fileifpassword_he`, `fileifpassword_es`, `fileifpassword_pt`, `fileifpassword_pl`, `filepassword`, `filetemplateid`, `filesubmitlang`, `fileusername`, `fileuserip`, `filestatus_en`, `filestatus_he`, `filestatus_es`, `filestatus_pt`, `filestatus_pl`, `filestatusimage`, `filesentfrom`, `filedateadded`, `filedatetime`, `filehash1`, `filehash2`, `filedescription_en`, `fileimageurl1`, `fileimageurl2`, `fileimageurl3` ) VALUES ( '$filename','$transgeneraltype_en','$transgeneraltype_he','$transgeneraltype_es','$transgeneraltype_pt','$transgeneraltype_pl','$transspecifictype_en','$transspecifictype_he','$transspecifictype_es','$transspecifictype_pt','$transspecifictype_pl','$fileifwalla','$fileifyahoo','$fileifgmail','$fileiflycos','$filenumwalla','$filenumyahoo','$filenumgmail','$filenumlycos','$filetotalmirrors','$filewhatmirrors','$transfilelanguage_en','$transfilelanguage_he','$transfilelanguage_es','$transfilelanguage_pt','$transfilelanguage_pl','$transifsubtitles_en','$transifsubtitles_he','$transifsubtitles_es','$transifsubtitles_pt','$transifsubtitles_pl','$transsubtitlelanguage_en','$transsubtitlelanguage_he','$transsubtitlelanguage_es','$transsubtitlelanguage_pt','$transsubtitlelanguage_pl','$transifpassword_en','$transifpassword_he','$transifpassword_es','$transifpassword_pt','$transifpassword_pl','$svideopassword','$stemplateid','$userlanguage_en','$fileusername','$fileuserip','$transfilestatus_en','$transfilestatus_he','$transfilestatus_es','$transfilestatus_pt','$transfilestatus_pl','$filestatusimage','$filesentfrom','$date','$datetime','$filehash1','$filehash2','$filedescription','$fileimageurl1','$fileimageurl2','$fileimageurl3' )"; $runquery1 = mysql_query( $query1 ); if ($runquery1 == 1) { echo( "the table mainfilelist HAS BEEN succesfully INSERTED.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN inserted"); } $fetchedfileid = mysql_insert_id(); $filelink = '<a href="/video.php?id=$fetchedfileid" target="_self">$filename</a>'; $updatefilelistquery = mysql_query("UPDATE `mainfilelist` SET `filelink`='$filelink' WHERE `fileid`='$fetchedfileid'"); if ($updatefilelistquery == 1) { echo( "the table mainfilelist HAS BEEN succesfully UPDATED with filelink.<br>"); } else { mysql_close(); die("ERROR: mainfilelist has NOT BEEN UPDATED with filelink"); } //end ENGLISH/NULL insertions } } ?> Quote Link to comment Share on other sites More sharing options...
dsaba Posted March 15, 2007 Author Share Posted March 15, 2007 thanks - what did you change? Quote Link to comment Share on other sites More sharing options...
dsaba Posted March 15, 2007 Author Share Posted March 15, 2007 i have a similar error on the same kind of function i use so that is why i ask what you changed, because then i can find and fix the parse error on my own instead of posting again! it looks like u changed the FILELINK variable syntax, and took out some } { ?? i dont know if it will be the same if/else function now....? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.