TAV1702 Posted January 31, 2010 Report Share Posted January 31, 2010 Has anyone ever made a marquee for phpVMS that automatically pulls data from the database? Say for example, I hit my mark and gain a new rank. It would add it to todays marquee and say Congrats TAV0001 for recent promotion to Captain..............Happy 45th Birthday Oscar the Grouch........Congrats TAV0001 on your 1 year anniversay I used to belong to a va ( Livewire Airlines) that actually has something like that. I enquired about it once and they told me in simple words that it runs a cron or something of the such and querys the database for new updated info that is preset and inserts it when necessary. It would NOT need to pull every single little detail. Simply Ranks, Bdays, website anniversarys, and stuff like that. It would NOT need to insert the fact that a pirep was just filed or anything like that. We allready have all that info available from page. To add it to the marquee would just be redundant. Just a thought about a nifty addon. Ray Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted January 31, 2010 Moderators Report Share Posted January 31, 2010 i ame interested to for that Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 31, 2010 Author Report Share Posted January 31, 2010 Yeah it would be kind of cool actually. I know how to use the html but I am not good at anything database related. And for the most part, this one would be cron/database driven..... So I'm guessing Quote Link to comment Share on other sites More sharing options...
RogerB Posted February 1, 2010 Report Share Posted February 1, 2010 I have an idea how to do this. I will try and let you know in a few hours..working right now Quote Link to comment Share on other sites More sharing options...
RogerB Posted February 2, 2010 Report Share Posted February 2, 2010 <marquee behavior="scroll" direction="up" align="bottom" scrolldelay="150" onmouseover="this.stop();" onmouseout="this.start();">PUT WHAT EVER YOU WANT HERE</marquee> I did it on my productin site. It works. check it out on the va stats. http://www.pirateairvirtual.com Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted February 3, 2010 Author Report Share Posted February 3, 2010 Yeah man that is cool. I had that part under control. lol I was meaning that ti would pull the data right out of the database automatically. Manual updating every day would suck real bad. I guess it would need to run as a cron job and query the database and insert info automagically But yeah that is pretty dam nice. The site looks great. Quote Link to comment Share on other sites More sharing options...
hjhjhgjgjh Posted February 5, 2010 Report Share Posted February 5, 2010 actually what you guys are looking for is some kinda rss stream. there are several readers and stuff, just google a bit and you maybe find something suitable or you take the code below (<marquee behavior="scroll" direction="up" align="bottom" scrolldelay="150" onmouseover="this.stop();" onmouseout="this.start();">PUT WHAT EVER YOU WANT HERE</marquee>) and then make some <?php echo "MYSQLREQUEST OR SOMETHING" ?> in it where you just get the content of the news for example Quote Link to comment Share on other sites More sharing options...
RogerB Posted February 6, 2010 Report Share Posted February 6, 2010 There is actually one for the CMS system E107 that is really nice, it is database driven. I will have a look at porting it when I get time.. Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted February 7, 2010 Author Report Share Posted February 7, 2010 If you want an idea of what I am referring to, you can visit http://www.livewireairlines.com and log in as a demo user. As soon as you do, you will notice a marquee at the top above the nav. I have been a member there for a good while now, but the owner has fallen ill or had a stroke or something like that and only gets on from time to time so I have no way of finding out how he pulls this info I am after. That site is NOT phpVMS though. It is all his own code. Some cool stuff there, but the VA 10 years later is kind of stale. Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted February 11, 2010 Administrators Report Share Posted February 11, 2010 Is this an idea of what you are thinking of - This will welcome your newest pilot... <?php $newpilot = PilotData::getLatestPilots(1); ?> <marquee>Welcome Our Newest Pilot: <?php foreach ($newpilot as $pilot) { echo $pilot->firstname.' '.$pilot->lastname.' ('.PilotData::getPilotCode($pilot->code, $pilot->pilotid).')'; } ?> </marquee> It should be streamlined a bit but I just threw it together as an example. You could use a similar function to pull the newest news post title or the like as well. Quote Link to comment Share on other sites More sharing options...
llju1 Posted February 11, 2010 Report Share Posted February 11, 2010 Thanks simpilot it worked great on my site. I do wish I could slow it down abit but it still work great. Lloyd Quote Link to comment Share on other sites More sharing options...
RogerB Posted February 11, 2010 Report Share Posted February 11, 2010 You actually can slow that down.... look up earlier in this post and you can impliment any of those commands Quote Link to comment Share on other sites More sharing options...
llju1 Posted February 11, 2010 Report Share Posted February 11, 2010 Duh I knew that lol ;D I must always remember to read everything first lol. God it sucks getting old ;D Quote Link to comment Share on other sites More sharing options...
RogerB Posted February 11, 2010 Report Share Posted February 11, 2010 No worries Lloyd... Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted February 13, 2010 Author Report Share Posted February 13, 2010 Hey all have been gone a few days and come back to this. Now we are getting somewhere. That is pretty cool. I will have to toss it up on site and see how it goes for me. Thanks guys! Quote Link to comment Share on other sites More sharing options...
Matthew Talbot Posted June 2, 2010 Report Share Posted June 2, 2010 Is this an idea of what you are thinking of - This will welcome your newest pilot... <?php $newpilot = PilotData::getLatestPilots(1); ?>       <marquee>Welcome Our Newest Pilot:         <?php           foreach ($newpilot as $pilot)                 {                   echo $pilot->firstname.' '.$pilot->lastname.' ('.PilotData::getPilotCode($pilot->code, $pilot->pilotid).')';                 }         ?>       </marquee> It should be streamlined a bit but I just threw it together as an example. You could use a similar function to pull the newest news post title or the like as well. Hey it looks great, but where do I put the code, I am on PHPVMS, does it work for PHPVMS? Many Thanks, Matthew Quote Link to comment Share on other sites More sharing options...
Matthew Talbot Posted June 2, 2010 Report Share Posted June 2, 2010 Is this an idea of what you are thinking of - This will welcome your newest pilot... <?php $newpilot = PilotData::getLatestPilots(1); ?>       <marquee>Welcome Our Newest Pilot:         <?php           foreach ($newpilot as $pilot)                 {                   echo $pilot->firstname.' '.$pilot->lastname.' ('.PilotData::getPilotCode($pilot->code, $pilot->pilotid).')';                 }         ?>       </marquee> It should be streamlined a bit but I just threw it together as an example. You could use a similar function to pull the newest news post title or the like as well. looks great on my sie Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.