i have few comments :
1) non latin characters and import - the import screws the non latin characters up, if imported from mySQL database 5.0+ with specific encoding. Is there a way how to set up the source encoding (i.e. cp1250-win1250), and what exactly is the target encoding - in what encoding does Photopost run ? Where to set PhotoPosts encoding ?
2) please note that the importer is not working as desired :
Quote:
$query=mysql_query("SELECT * FROM {$Globals['photopost']}photos",$u3t);
$members=mysql_num_rows($query);
$members=$members+1; // +1
$end=$start+5000;
echo "Importing $members files .... please wait<p>";
if ($start >= $members) {
echo "Import Done";
exit;
}
while ($line=mysql_fetch_array($query)) {
for ( $x=0; $x < count($members); $x++ ) {
$id = $line['id'];
$userid = $line['userid'];
$filepath = $line['filepath'];
$cat = $line['cat'];
$image = $line['bigimage'];
$image2 = "thumb_$image";
mysql_select_db("$vdb",$vbc);
echo "Importing ($image)<br />";
|
as you find out the number of rows in the table, you launch the import, and you import not 5000 (nor 2500) images, but ALL of them. Once the cycle ends, you redirect to page ...?action=import_files&start=2500 and the import runs AGAIN from the scratch, trying to import all the files ! Same is with other parts of the import process, where you redirect to "part" imports by hundreds or thousands items at a time. Importing 38 thousand images from 680 galleries might be really painfull with these errors
You are either missing "limit $start, $number" in the sql query statement, or there is wrong limitation in the FOR cycle going thru the records.