custom page view

Hi Chris,

So 'dancer_slide_show' is an upload field in the 'player' section (or will be a field)? Is that right? Or will there be a separate section for dancers?

Either way you'd probably want to lookup the dancer by player (or dancer name) or record number.

Are the dancers in the same record and section as the players or how will they be stored?

Hey Dave

Let me try to explain the structure of the CMS better.
I made a Section called player ( now looking back I should have named it staff) That is where everyone is listed dancers,players,coaches, and office personal. It has there name hight weight ect.. all there bio information. Inside that Section is an upload box named dancer_slide_show. That is where I want them to upload only the pictures they want to show in the slide show.

So when they click the read more on a dancer it pulls up the dancerPage.php That contains the flash file slide show on it and with any luck starts displaying the matching girls photos.

So I need in the page view in the xml for it to match the dancers personal entry in the players section so it displays just the pictures uploaded to just her.

If your still thinking English is my second or third language [:P] I will try to rephrase my question again. if you could write the syntactic of how I would define
$options['where'] = to check the field dancer_slide_show = the name field That in my little knowledge of php should be how it can match up the pictures uploaded to the girl.

Thanks
Chris

Alright been messing with the code

<?php
require_once "/home/ragefoot/public_html/cmsAdmin/lib/viewer_functions.php";
$options = array();
$options['tableName'] = 'player';
$options['recordNum'] = '90';
$options['where'] = '';
$record = getRecord($options);
?>
<playlist xmlns="http://xspf.org/ns/0/" version="1">
<trackList>
<?php foreach (getUploads($options['tableName'], 'dancer_slide_show', $record['num']) as $upload): ?>
<track>

<location>http://www.ragefootball.com/cmsAdmin/uploads/Dancers/<?php echo $upload['filename'] ?></location>
</track>
<?php endforeach ?>
</trackList>
</playlist>

Will get me the image to load.

I had to tell it a recordNum to get it to do that. So now I need to figure out how to pass a number to it and have it display the matching ones.

Thanks

Ok, I think I got it. You have a page called dancerPage.php that shows details on specific dancer, but you don't want images shown on that page directly, because you're using a flash slideshow (_on that page_) which needs to load the images from an XML config file. Is that right?

If it is, you'd probably display dancer pages with an url like this: dancerPage.php?dancer-name-3/

If so, just blank out the where option on your XML page (I'm going to pretend it's called dancePageXML.php) and link to it directly the same way: dancerPageXML.php?dancer-name-3/

The part after the ? in the url is called the "query string" and you can link from dancerPage.php to dancerPageXML.php like this to pass it along:

dancerPageXML.php?<?php echo @$_SERVER['QUERY_STRING']; ?>

Let me know if that works. You can test it during development by linking directly to urls like dancerPageXML.php?3 and viewing source and making sure it's creating the right XML.

Hope that helps, if I totally misunderstood let me know! ;)

Trust me Tom I am the more confused one. You are talking to a guy that has a portfolio full of Illustrator work so yeah my job description has changed a lot. I got your message at the same time as I posted my update. If you go to
http://www.ragefootball.com/dancerPage.php?96/
you will see the slide show in action.
On dancerPage.php I have this code
<script type="text/javascript">
var so = new SWFObject('http://www.ragefootball.com/test/imagerotator.swf','mpl','275','418','8');
so.addParam('allowscriptaccess','always');
so.addParam('allowfullscreen','true');
so.addVariable('height','418');
so.addVariable('width','275');
so.addVariable('file','http://www.ragefootball.com/test/imagelist.php.xml');
so.addVariable('transition','fade');
so.addVariable('enablejs','true');
so.addVariable('linkfromdisplay','true');
so.write('player');
</script>
I could write it like this if you think it would help
<embed
src="http://www.ragefootball.com/test/imagerotator.swf"
width="275"
height="418"
allowscriptaccess="always"
allowfullscreen="true"
flashvars="height=418&width=275&file=http://www.ragefootball.com/test/imagelist.php.xml&transition=fade"
/>
With the imagelist.php.xml looking like this
<?php
require_once "/home/ragefoot/public_html/cmsAdmin/lib/viewer_functions.php";
$options = array();
$options['tableName'] = 'player';
$options['recordNum'] = '90';
$options['where'] = '';
$record = getRecord($options);
?>
<playlist xmlns="http://xspf.org/ns/0/" version="1">
<trackList>
<?php foreach (getUploads($options['tableName'], 'dancer_slide_show', $record['num']) as $upload): ?>
<track>

<location>http://www.ragefootball.com/cmsAdmin/uploads/Dancers/<?php echo $upload['filename'] ?></location>
</track>
<?php endforeach ?>
</trackList>
</playlist>
So that gets to the point I am at.
you can view the xml file output by going here
http://www.ragefootball.com/test/imagelist.php.xml
I tried to place dancerPageXML.php?<?php echo @$_SERVER['QUERY_STRING']; ?>
in the xml file at the $options['where'] = ''; and got this error "Parse error: syntax error, unexpected T_STRING in /home/ragefoot/public_html/test/imagelist.php.xml on line 6"

I know we are close Dave I can feel it or I would have told the client not that can't be done LOL.

Thanks for your time
Chris

Ok, in dancerPage.php change the 'file' line to this:

so.addVariable('file','http://www.ragefootball.com/test/imagelist.php.xml?<?php echo @$_SERVER['QUERY_STRING']; ?>');

So it passes the record number to the php xml file. Next, in imagelist.php.xml change the recordNum option to this:

$options['recordNum'] = '';

So it loads the record number from the url.

If that doesn't do it, feel free to email me FTP and I can get in there and take a look.

Hope that helps! :)