For the Online Game "Planetside" , Sony is providing our Clans and players with Statistics. I need this Data fetched and put in my MYSQL Database. The Data is provided in HTML only and updated daily. You can see the Outfit (Clan) Page at : [url removed, login to view]**6622**&worldId=**21**
The most important Part is the Member Roster on the right as every player has a single character page. Example Character Link : [url removed, login to view]**322447**&worldId=**21
So we have 1 Outfit Page and several Character pages. The world ID (21) is constant and reflects our Server. The Outfit(Clan) ID (6622) is constant too. Every Player has a different but constant CharID. So what needs to be done ?
Fetch Data form the outfit Page and create :
**1 Table** (Outfit) containing : Date Outfit Created, Outfit Leader, Total Outfit Points, Member Count.
**1 Table** (promotions) containing all recent promotions
**1 Table** (Outfitroster) containing : charid, name, title, battlerank, points, lastloggedin.
From every Member in Outfitroster now the Data from their single Character page has to be fetched and put in **1 Table** (Charinfo) containing : name, Empire, Outfit, Command Rank, Battlerank, Title, Points, Hacks, Kills1, 2 + Total, Last Logged in and all Certs. Every Cert should be put in 1 Field and nr. of certs is different.
This stuff has to be updated more than once a day. Check if Data has changed if false get from Mysql if true fetch Data from HTML into MYSQL and then get from MYSQL. The display part is done by myself with PHP. I only need the Data parsed and put in my Database more than once a day. Would like to talk to the coder about some some special Fields and some extras.
1.)Tables created in MYSQL Database
2.)HTML to MYSQL parser in PHP? without the output code
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
MYSQL + PHP