Programming Theory
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOther TechnologiesProgramming Theory

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
Dell PowerEdge Servers
  #1  
Old November 9th, 2006, 07:52 PM
Wella67 Wella67 is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Sweden
Posts: 3 Wella67 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Livescore in PHP?

Codewalkernewbie here, hello everybody!

I am creating a livescore application with PHP, XML, MySql on Apache.
Would love some help trying to trim appl further.
Making the updates for the visitors faster and more frequent.

This is how it works right know:
script
Retrieve ALL XML-files via HTTPS, store them locally.
Parse files and generates a HTML-page for each game.
end script
# The script runs twice in 30 seconds. (Set up in apache)
# The visitors view the HTML-page with has a META-REFRESH of 30 secs.
# the XML-files are three per game; lineup, report and stats. Sometimes there is up to 6 games at once, making it 18 XML-files.
Lineup contains lineup and some other gamedata like judges,arena,capacity.
Report contains all events of the game, what team, what player and what time he did what. Also includes teamstats.
Finally stats contains playerstats like playingtime, goals, assist and much much more. This is avaliable after the game today but will be continuously updated soon.

We are setting up a "mini-server" on the webserver to take care of the output of the HTML-pages only, fastest easiest way possible, freeing up Apache.

We have already created a RSS-feed containing data on which files have been updated, so I don“t have to retrieve them all, all the time.
Now(need to write code first) I just read the RSS checking for updates files, and retrieve them, parse them and create a new HTML-page for that particular game.

I would like to avoid storing everything in a database(Other then a TEMP table within the script)?

How can I get frequently updated stats the fastest, most reliable way to the user/visitor?

Please think outside the box. Everything is changeable, from the structure of the XML-files, to the page which the visitor viewes.

I have faith in you!

Reply With Quote
  #2  
Old March 15th, 2007, 08:45 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: Livescore in PHP?

Sorry to bother mate, but I have a question for you tangent to your post. Where do livescore sites get their scores from? Do they have people tracking tens of leagues live, or is there a central database or what is it? i really appreciate your help.

Reply With Quote
Reply

Viewing: Codewalkers ForumsOther TechnologiesProgramming Theory > Livescore in PHP?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.

 
Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.

 
Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.

 
Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five &quot;checkpoints&quot; for any implementation plan that will help make IP communications a successful proposition.

 
Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway