Website Membership: Showing different pages based on specific users

Hi Nigel,

I recently did something similar for a site that was offering custom videos.

The first thing that I did (to reduce the eventual clutter) was to create a check box in the account records that said videos_for_sale (in your case it might be plans available)

Then I created a table called "Videos For Sale" with a field for the title of the video, an upload field for the video file itself, a description field, and a list field called videos_for_sale with the List options as “get options from MySQL Query”

and the query as:

SELECT num, last_name
FROM `<?php echo $TABLE_PREFIX ?>accounts`
WHERE video_for_sale='1'

Then for the detail page viewer code I used:
<!-- USER LOGIN FORM -->
<?php if (@$errorsAndAlerts): ?>
<div class="heading-text-13"><br/>
<?php echo $errorsAndAlerts; ?><br/>
</div>
<?php endif ?>

<?php if (!@$CURRENT_USER): ?>

<form action="?" method="post">
<input type="hidden" name="action" value="login" />

<table width="400" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td class="heading-text-13" colspan="2">You must be logged in to access this page.</td></tr><tr>
<td class="body-text-bold-9">Username</td>
<td><input type="text" name="username" value="<?php echo htmlspecialchars(@$_REQUEST['username']); ?>" size="20" /></td>
</tr>
<tr>
<td class="body-text-bold-9">Password</td>
<td><input type="password" name="password" value="<?php echo htmlspecialchars(@$_REQUEST['password']); ?>" size="20" /></td>
</tr>

<tr>
<td colspan="2" align="center">
<br/><input type="submit" name="submit" value="Login" />


</td>
</tr>
<tr>
<td colspan="2" align="left">

<br />
<br /> <a class="special" href="<?php echo $GLOBALS['WEBSITE_LOGIN_REMINDER_URL'] ?>">FORGOT YOUR PASSWORD? CLICK HERE</a> <br /><br />
<span class="body-text-9">If you'd like to become an Aranmore Dance member</span><br />
<a class="special" href="http://www.aranmoredance.com/becomeamember.php">CLICK HERE TO SIGN UP</a>

</td>
</tr>
</table>
</form>
<?php endif ?>
<!-- /USER LOGIN FORM -->

<?php if (@$CURRENT_USER): ?>

<table width="70%" border="0" cellspacing="10" cellpadding="5">
<tr>
<td valign="top" width="75%"><table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td colspan="2"><?php foreach ($videos_for_saleRecords as $record): ?><?php if ($CURRENT_USER['num'] == $record['videos_for_sale']): ?>
<span class="heading-text-bold-13">Welcome <?php echo $CURRENT_USER['first_name']; ?>&nbsp;<?php echo $CURRENT_USER['last_name']; ?>,</span><br /><span class="body-text-bold-9">Enjoy your video.</span><br />
<br />
</td>
</tr><tr><td>




<a class="special"href="<?php foreach ($record['video_upload'] as $upload): ?><?php echo $upload['urlPath'] ?><?php endforeach ?>">Click here if you'd prefer to download<br />your personal training video</a><br />
<?PHP endif ?><?php endforeach ?>
<br /></td></tr></table> <?php endif ?>



<?php if (@$CURRENT_USER): ?>

<?php foreach ($videos_for_saleRecords as $record): ?>

<?php if ($CURRENT_USER['num'] == $record['videos_for_sale']): ?>
<table align="center" width="90%" border="0" cellpadding="5">
<tr><td>
<h2 align="center"><?php echo $record['title'] ?></h2><br /></td>
<tr><td align="center">

<div id="container">&nbsp;</div>
<script type="text/javascript">
jwplayer("container").setup({

file: "http://www.aranmoredance.com<?php foreach ($record['video_upload'] as $upload): ?><?php echo $upload['urlPath'] ?><?php endforeach ?>",
height: 420,
width: 510,
<?php if (@$record['background_image']): ?>image: "http://www.aranmoredance.com<?php foreach ($record['background_image'] as $upload): ?><?php echo $upload['thumbUrlPath2'] ?>"<?php endforeach ?>, <?php endif ?>
autostart: true,
modes: [
{ type: "html5" },
{ type: "flash", src: "player.swf" }
]

});
</script>



<br /><br /></td></tr><tr><td class="body-text-9" align="left">
<?php echo $record['description'] ?>
</td></tr></table><?php endif ?><?php endforeach ?> <?php endif ?>

There’s a lot of extra code here because I included a login form on the page, a welcome to the current user, and a description field, but you should be able to use the core idea:
<?php if (@$CURRENT_USER): ?>

<?php foreach ($videos_for_saleRecords as $record): ?>

<?php if ($CURRENT_USER['num'] == $record['videos_for_sale']): ?>

YOUR CODE...

<?php endif ?><?php endforeach ?> <?php endif ?>

Hope that gets you going,

Jerry Kornbluth

Thanks, Jerry. I'll give this a go.