c# - Get data from tabel [HTML] into SQL database -
i create program gets data play.eslgaming.com website , puts database.
i found out data need in raw code of webpages. following:
<div id="round-1" class="ui-tabs-panel ui-widget-content ui-corner-bottom"> <span class="teamstatus">team: evil squirrels <small><i>(attacker)</i></small></span> <table class="wot_stats"> <tbody class="matchloser"> <tr> <th>tank</th> <th>player</th> <th>kills</th> <th>dmg dealt</th> <th>remain. hp</th> <th>blocked dmg</th> <th>time alive</th> <th>shots fired</th> <th>accuracy</th> </tr> <tr> <td> <div class="tank"> <img src="http://static-ptl-eu.gcdn.co/static/2.34.2/encyclopedia/tankopedia/vehicle/contour/ussr-object_140.png" class="icon-img"> <em>u.s.s.r. object 140</em> </div> </td> <td> <div class="playername"> <a target="_blank" style="cursor: pointer;" href="/worldoftanks/europe/wot/open/bronze-series/player/7176461">conchita_</a> <em>conchita_</em> </div> </td> <td>2</td> <td>2781</td> <td>destroyed</td> <td>240</td> <td>07m 34s</td> <td>18</td> <td>50%</td> and on each player each round 2 teams.
but problem don't know how information easiest. put them database can make totals , monitor everything. can program bit c# maybe there way use code.
i know how needed data webpages.
i use anglesharp project scraping: https://github.com/anglesharp/anglesharp
Comments
Post a Comment