techmonkey78
-
Posts
2 -
Joined
-
Last visited
Everything posted by techmonkey78
-
Hi, I'm trying to write a script that posts the contents of a text file generated by radio automation software from a cron job every 30 minutes. The script should open this file (data.txt), compare it to a second file(title.txt), if it's different, post the new version to twitter and update title.txt. If it's not different, just die. The posting is working just fine, however, it will post duplicates as it's not doing the comparison part. Currently the station isn't 24 hours so it will just keep posting ad infinitum as it stands, if the station is off air, the two text files should be the same and not post. Where am I going wrong here? Many thanks in advance Iain <?php include 'EpiCurl.php'; include 'EpiOAuth.php'; include 'EpiTwitter.php'; #Consumer key token $consumer_key = 'xxxxxxx'; #Consumer secret token $consumer_secret = 'xxxxxxx'; #Access Token $token = 'xxxxxx'; #Access Token Secret $secret= 'xxxxxxxx'; $twitterObj = new EpiTwitter($consumer_key, $consumer_secret, $token, $secret); $twitterObjUnAuth = new EpiTwitter($consumer_key, $consumer_secret); $file = fopen("../data.txt","r"); if(!file) { echo("ERROR:cant open file"); } else { $buff = fread ($file,filesize("../data.txt")); } echo $buff; $refresh = "3600"; // Page refresh time in seconds. Put 0 for no refresh ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" > <?php if ($refresh != "0") { print "<meta http-equiv=\"refresh\" content=\"$refresh\">\n"; } print "<title>TwiceCast - $buff</title>"; ?> </head> <body><center> <?php $fh = fopen('title.txt', 'r'); $track = fread($fh, filesize('title.txt')); if ($track == $buff."\n"){ fclose($fh); die(0); }else{ @fclose($fh); // if it errors, then the file doesn't exist, and the stream was never open $fh = fopen('title.txt', 'w'); fwrite($fh, $buff ."\n"); fclose($fh); $twitterObj->post('/statuses/update.json', array('status' => "Recently played: " . $buff . " #nowplaying http://bit.ly/kbridgeuk")); } ?> </center> </body> </html>
-
Hi, I'm designing a website for an online radio station. One show a week they have a DJ who has his own top 40 show with HIS top 40 listed on his own site At the moment, the only solution I have to getting the top 40 onto my clients site is an iframe (not good I know!) However, what's worse is that this top 40 list has horrendous colours that completely break the theme of my clients site and worse still, is Excel generated HTML! The author of this list is not a client of mine, and so, I can't do anything to persuade him to change. I've attached a copy of the offending file so you can see what I'm working with, changed the extension from html to txt for the forum post. Just for clarification, the excel generated HTML file is not hosted on my server (although I could set up a cron job to get it if required) I've done some digging and found a useful bit of code However, it displays the table 4 or 5 times In addition to this, is there a way to manipulate the width of the columns with this code? <?php $oldSetting = libxml_use_internal_errors( true ); libxml_clear_errors(); $html = new DOMDocument(); $html->loadHtmlFile('Chart%20Table2.htm'); $xpath = new DOMXPath( $html ); $elements = $xpath->query( "//table" ); foreach ( $elements as $item ) { $newDom = new DOMDocument; $newDom->appendChild($newDom->importNode($item,true)); $xpath = new DOMXPath( $newDom ); foreach ($item->attributes as $attribute) { for ($node = $item->firstChild; $node !== NULL; $node = $node->nextSibling) { if (($attribute->nodeName =='valign') && ($attribute->nodeValue=='top')) { print($node->nodeValue); } else { print("<br>".$node->nodeValue); } } print("<br>"); } } libxml_clear_errors(); libxml_use_internal_errors( $oldSetting ); ?> Basically, I just want the table, I'm not bothered about the first column that contains some pictures as I think that's a separate table Ideally, I'd like to apply my own formatting to the table too (padding etc) if that is possible (eg from line 897 <td class=xl28 x:num>1</td>) down to line 1433 The trouble is, there is a lot of custom widths and styles inbetween which I don't want I'd like all the tr and td's without all the associated guff from the original export from Excel Geez I wish there was an easy way to get this guy just to export as CSV but unfortunately that's not an option! Many thanks in advance! [attachment deleted by admin]