7
Did you check your database to see exactly what got inserted into the fields in question? I had a similar problem with avatars, viewing source showed truncated image filenames, and when I looked into the database (using phpmyadmin) I saw that the filenames were getting truncated on insertion because the field was limited to fewer characters than my filenames were using.
It would be easier for you if you cleaned up your queries; for example used a single-quote (') instead of double quote (") for your insert values so you wouldn't need to be escaping all those quotes. MySQL likes single-quotes just fine. You only need to escape them if they're used as part of an insert value (e.g. O'Reilley in a name field). Then, create simple variables to use in the query before writing the string; for example:
le="color: #000000"><?php $url = $DownloadBaseUrl . $file; $size = filesize($file); $thislogourl = $ShotBaseUrl . $logourl;
then you could have:
le="color: #000000"><?php "insert into xoops_mydownloads_downloads (cid,title,url,size,logourl,submitter,status,date,homepage,version,platform) values (2,'$title','$url','$size','$thislogourl',...etc";
Also usually in XOOPS it's a good idea to say:
le="color: #000000"><?php "insert into " .XOOPS_DB_PREFIX. "_mydownloads_downloads...
just in case somebody isn't using the default XOOPS table prefix.
Just a few thoughts I had that might help, since I'm also new at Xoops, although I've been working with PHP and MySQL for a few years.