dynamic scan\n";
foreach ($_g['pages'] as $pgi) { $do.="
{$pgi[0]}
{$pgi[1]}\n"; }
$do.="
\n \n\n";
$do.="JPGs in SQL but not in ".
"Work in progress: \"SQL\":\n";
$sres=do_query("select * from general where gal='cw' and width>0");
$row = mysql_fetch_assoc($sres);
while ($row!=FALSE) {
$_g['sqlist'][$row['frameno']]=array('frameno'=>$row['frameno']);
if (isset($_g['fullist']["{$row['frameno']}|rwhgal1"]))
$_g['fullist']["{$row['frameno']}|rwhgal1"]['s']=$row['seqno'];
else $do.="{$row['frameno']} ";
$row=mysql_fetch_assoc($sres);
}
$do.=" \nEnd of list. ". count($_g['sqlist']) ." JPGs in SQL
\n";
$do.="JPGs detected during file scan but not in SQL:\n";
foreach ($_g['nams'] as $frameno) { if (!isset($_g['sqlist'][$frameno])) $do.="$frameno "; }
$do.=" \nEnd of list.
\n";
$do.="JPGs in old full list but not in new full list: \n";
foreach ($ofullist as $key => $oli) {
if (!isset($_g['fullist'][$key])) {
$do.="{$oli[0]},{$oli[1]}". (isset($_g['nams'][$oli[0]]) ? ",known" : ",gone ");
$_g['fullist'][$key]=array($oli[0],$oli[1],'o');
}
}
$do.=" \nEnd of list.
\n";
$do.="JPGs in new full list other than those in rwhgal1 but not in old full list: \n";
foreach ($_g['fullist'] as $key => $li) {
if (!isset($ofullist[$key]) && $li[1]!='rwhgal1')
{ $do.="{$li[0]},{$li[1]} "; $_g['fullist'][$key][2]='n'; }
}
$do.=" \nEnd of list.