public function getUpdateschema()
{
//$itemschema = SteamApi::itemschema();
$doc = new DOMDocument();
$start = 0;
$count = 100;
$gid = 730;
$max = 999;
$i = 0;
$marketlist = SteamApi::getMarket($start, $count, $gid);
//$listutf8 = htmlentities($marketlist->results_html, NULL, 'UTF-8');
$max = $marketlist->total_count;
$doc->loadHTML($marketlist->results_html);
$xpath = new DOMXPath($doc);
$marketitems = $xpath->query("//*[contains(concat(' ', normalize-space(@class), ' '), 'market_listing_row_link')]");
//var_dump($itemlist);
foreach ($marketitems as $marketitem) {
$item["marketlink"] = $marketitem->getAttribute("href");
$item["markethash"] = substr($item["marketlink"], strrpos($item["marketlink"], '/') + 1);
$item["marketname"] = urldecode($item["markethash"]);
$getitemname = explode("%28", $item["markethash"]);
$item["itemname"] = urldecode($getitemname[0]);
$itemvalue = SteamApi::getItemValue($item["markethash"], $gid);
if ($itemvalue == null) {
$item["value"] = 0;
} else {
$item["value"] = substr($itemvalue->lowest_price, 5);
}
preg_match_all("/\\(([^)]+)\\)/", $item["marketname"], $matches);
if ($matches[1][0]) {
$item["exterior"] = $matches[1][0];
} else {
$item["exterior"] = "";
}
/*$getvalue = $xpath->query("//*[contains(concat(' ', normalize-space(@class), ' '), 'market_table_value')]", $marketitem);
$values = $xpath->query("//*[contains(concat(' ', normalize-space(@style), ' '), 'color:white')]", $getvalue->item(0));
foreach($values as $value)
{
//var_dump($value);
}*/
$items[] = $item;
}
//print_r($items);
foreach ($items as $item) {
$item_row = ItemSchema::where('markethashname', '=', $item["markethash"])->first();
if ($item_row == false) {
$item_row = new ItemSchema();
$item_row->itemname = $item["itemname"];
$item_row->marketname = $item["marketname"];
$item_row->markethashname = $item["markethash"];
$item_row->marketlink = $item["marketlink"];
$item_row->minvalue = $item["value"];
$item_row->exterior = $item["exterior"];
//$item_row->imagenormal = $item["imagenormal"];
$item_row->save();
} else {
$item_row->itemname = $item["itemname"];
$item_row->marketname = $item["marketname"];
$item_row->markethashname = $item["markethash"];
$item_row->marketlink = $item["marketlink"];
$item_row->minvalue = $item["value"];
$item_row->exterior = $item["exterior"];
//$item_row->imagenormal = $item["imagenormal"];
$item_row->save();
}
}
return $view = View::make('default.admin.edit.itemschema');
}
