triplex2k7

Does the_content really have any advantages over the_excerpt?

This is exactly what I am trying to do at the moment. What I have done so far is use the loadvars function of flash to load some variables from a php file which is fetching them from the database.
My post which is more detailed is Here(https://www.ads-software.com/support/topic/125184?replies=5).
I don’t know if you have worked with mysql and flash together before but I hadn’t and only ever touched mysql directly for the first time on Sunday. This tutorial(https://www.creativecow.net/articles/brimelow_lee/php_mysql/php_mysql_flash.html) helped me a lot.
Good luck, if you want any more info on how I’m getting on I will be more than happy to share my progress with you. Please email me at rupham1 AT googlemail DOT com if you wish. Thanks

Identical in latest versions of IE and FF apart from some line spacing in the post content.

I find it quite crowded and hard to easy to get distracted from what you’re reading. I like the latest post feature though.

nice – i like the clean look and animated menu

Hooray!!!

I have managed to get somewhere! So far it only displays the title and excerpt but the rest should be straightforward from now on.

Here is the code in frame 1 of my swf:

stop();

addressVars = new LoadVars();
addressVars.load("https://localhost/testing/posts.php");

addressVars.onLoad = function(success) {
	gotoAndStop(10);
}

In frame 10:

stop();

_root.theTitle0 = addressVars.title0;
_root.theExcerpt0 = addressVars.excerpt0;

(theTitle0 and theExcerpt0 are variable names of my two dynamic text boxes)

And finally, the code in posts.php:

<?php
mysql_pconnect ("localhost", "myusername", "mypassword");

mysql_select_db ("wordpress");
$qResult = mysql_query ("SELECT * FROM wp_posts ORDER BY
     post_date DESC");
$nRows = mysql_num_rows($qResult);
$rString ="".$nRows;
for ($i=0; $i< $nRows; $i++){

$row = mysql_fetch_array($qResult);
$datetime = strtotime($row['post_date']);
$rString .="&title".$i."=".$row['post_title'].
"&"."theTime".$i."=".date(jS." ".F." ".Y.", ".h.":".i."
     ".a,$datetime).
"&"."link".$i."=".$row['guid'].
"&"."comments".$i."=".$row['comment_count'].
"&"."excerpt".$i."=".$row['post_excerpt'].
"";

}
echo $rString."&";

?>

(That has more code than is necessary as I have not set up Flash to receive anything other than the title and excerpt yet.)

As I said, this is just a start but I hope it was the hardest part! I will keep this topic marked as unresolved until I have completed what I am trying to do so if anyone has any suggestions I will be very grateful.

Thanks!

Sorry it didn’t copy correctly, but you can still understand it.

Ok, I have managed to write the code for the swf to get the current php date, because I thought that would be an easier place to start. I will continue to try to integrate the WP template tags into the php which is fed to Flash. This is the code I am using at the moment:

In my PHP file:

<?php
$theDate = date('l jS F Y');  ;

$passIn = "" ;
$passIn .= "theDate=" . $theDate . "" ;

echo $passIn ;
?>

and in my actionscript:

onEnterFrame = function() {

addressVars = new LoadVars();
	addressVars.load("https://localhost/testing/date.php");

addressVars.onLoad = function() {

_root.theDate = "The PHP date is 

"+addressVars.theDate;

}

}

Thank you for your quick response

If you need to mod your theme that much why not create your own?