All pastes #146424 Raw Edit

Joel

public text v1 · immutable
#146424 ·published 2006-08-23 16:27 UTC
rendered paste body
    $vLimit = $cDB->dbGetConfig('front_sets');
    (float) $vScaleFactor = $cDB->dbGetConfig('thumbnail_scale');
    $vFields = array("ID","Name","Date","Author","Comments");
    $vResult = $cDB->dbSelect('Sets',$vFields,'','',$vLimit);
    $vSetRows = $cDB->dbGetRowsArray($vResult);
    $vFields = array("ID","Title","Description","URI","Width","Height");
    foreach ($vSetRows as $vSetValue) {
        $vResult = $cDB->dbSelect('photos',$vFields,'PhotoSet',$vSetValue['ID']);
        $vPicRows = $cDB->dbGetRowsArray($vResult);
        foreach ($vPicRows as $vPicValue) {
             if ($vPicValue['Height']==NULL){
                $vPicInfo = getimagesize($vPicValue['URI']);
                $vPicValue['Width']= $vPicInfo['0'];
                $vPicValue['Height']= $vPicInfo['1'];
             }
             $vPicValue['ThumbHeight'] = round($vScaleFactor * $vPicValue['Height']);
             $vPicValue['ThumbWidth'] = round($vScaleFactor * $vPicValue['Width']);
        }
        $vSetValue['Pictures'] = array();
        $vSetValue['Pictures'] = $vPicRows;
        $vPicRows = '';
    }
    $this->ul_var_dump($vSetRows);