PHP contrList Examples

Example #1

File: contributors.php Project: spencerlambert/willie-php

            //$contrAlbums = $contrAlbumsObj->getGalleryListData();
            $smarty->assign('contrAlbums', $contrAlbums);
            // Assign contributor albums to smarty
            $smarty->assign("contrMediaCount", $contrMediaCount);
            $smarty->assign("contributor", $contributor);
            $smarty->display('contributor.profile.tpl');
            // Smarty template
        } else {
            $smarty->display('noaccess.tpl');
            // Smarty template
        }
    } else {
        /*
         * Select all active contributors
         */
        $contributorsResult = mysqli_query($db, "\r\n\t\t\t\tSELECT * FROM {$dbinfo[pre]}members \r\n\t\t\t\tLEFT JOIN {$dbinfo[pre]}memberships \r\n\t\t\t\tON {$dbinfo[pre]}members.membership = {$dbinfo[pre]}memberships.ms_id \r\n\t\t\t\tWHERE {$dbinfo[pre]}memberships.msfeatured = 1\r\n\t\t\t\tAND {$dbinfo[pre]}memberships.deleted = 0 \r\n\t\t\t\tAND {$dbinfo[pre]}memberships.active = 1 \r\n\t\t\t\tAND {$dbinfo[pre]}members.status = 1 \r\n\t\t\t\tORDER BY {$dbinfo[pre]}members.l_name\r\n\t\t\t\t");
        while ($contributor = mysqli_fetch_array($contributorsResult)) {
            $contributors[$contributor['mem_id']] = contrList($contributor);
        }
        $smarty->assign("contributorsList", $contributors);
        $smarty->display('contributors.tpl');
        // Smarty template
    }
} catch (Exception $e) {
    echo $e->getMessage();
}
include BASE_PATH . '/assets/includes/debug.php';
if ($db) {
    mysqli_close($db);
}
// Close any database connections

Example #2

File: gallery.php Project: spencerlambert/willie-php

     // New 4.3.2
     $templateFile = 'featured.media.tpl';
     break;
     /*
      * Contributors media gallery
      */
 /*
  * Contributors media gallery
  */
 case "contributor-media":
     /*
      * Select contributor details
      */
     $contributorResult = mysqli_query($db, "\r\n\t\t\t\t\tSELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}members \r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}memberships \r\n\t\t\t\t\tON {$dbinfo[pre]}members.membership = {$dbinfo[pre]}memberships.ms_id \r\n\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}members_address\r\n\t\t\t\t\tON {$dbinfo[pre]}members.mem_id = {$dbinfo[pre]}members_address.member_id\r\n\t\t\t\t\tWHERE {$dbinfo[pre]}members.mem_id = '{$_SESSION[id]}'\r\n\t\t\t\t\t");
     if ($contributorRows = getRows()) {
         $contributor = contrList(mysqli_fetch_array($contributorResult));
     }
     // Select the contributors details
     if ($contributor['msfeatured'] == 1 and $contributor['status'] == 1 or $contributor['showcase'] == 1 and $contributor['status'] == 1) {
         $publicAccess = true;
     }
     // Make sure that the contributor can be displayed and is active
     if ($publicAccess and $contributorRows) {
         if ($config['settings']['contr_metatags']) {
             define('META_TITLE', $contributor['f_name'] . " " . $contributor['l_name']);
             // Override page title, description, keywords and page encoding here
             define('META_DESCRIPTION', substr($contributor['bio_content'], 0, 200));
         }
         // Update crumbs links
         unset($_SESSION['crumbsSession']);
         $contrMediaPageLink['page'] = "gallery.php?mode=contributor-media&id={$contributor[useID]}&page=1";