public function __construct ($mwsFileName) {
$mwsFile = fopen_utf8($mwsFileName, 'rb');
if (!$mwsFile) error('Unable to open masterbase CSV file: ' . $mwsFileName);
echo "Processing MWS masterbase...";
// windows-1252
//$csv = new CSV(';', "\r\n", '"'); // Cell separator, row separator, value enclosure.
//$csv->setContent(file_get_contents($mwsFileName, false , null)); // Parse the string content.
//$rows = $csv->getArray();
$i = 0;
while (($row = fgetcsv($mwsFile, 6000, ';', '"')) !== FALSE) {
//foreach($rows as $row){
if($i++ == 0) continue; //skip first line
if ($i++ % 50 == 0) echo '.';
// Extract.
$title = (string)trim($row[0]);
$set = (string)trim($row[1]);
$color = (string)trim($row[4]);
$type = (string)trim($row[6]);
$p = (string)trim($row[8]);
$t = (string)trim($row[9]);
$flavor = (string)trim($row[10]);
$rarity = (string)trim($row[11]);
$cost = (string)trim($row[5]);
$legal = trim($row[7]);
$pic = (string)trim($row[2]);
$artist = (string)trim($row[12]);
$collectorNumber = (string)trim($row[13]);
// Title.
if ($set == 'VG') $title = 'Avatar: ' . $title;
// Casting cost.
$cost = $this->replaceDualManaSymbols($cost);
$cost = preg_replace('/([0-9]+)/', '{\\1}', $cost); //
$cost = preg_replace('/([WUBRGXYZ])/', '{\\1}', $cost);
$cost = preg_replace('/{{([0-9XYZWUBRG])}{([WUBRG])}}/', '{\\1\\2}', $cost);
// Color.
if ($color == 'Z/Z') {
// Determine split card colors.
$cost1 = substr($cost, 0, strpos($cost, '/'));
$colors = Card::getCostColors($cost1);
$color = strlen($colors) == 1 ? $colors : 'Gld';
$color .= '/';
$cost2 = substr($cost, strpos($cost, '/') + 1);
$colors = Card::getCostColors($cost2);
$color .= strlen($colors) == 1 ? $colors : 'Gld';
}
//php5 fixups
$flavor = str_replace("\xA0", '', $flavor);
$flavor = iconv('windows-1250', 'utf-8', $flavor);
$legal = iconv('windows-1250', 'utf-8' ,$legal);
$artist = iconv('windows-1250', 'utf-8' ,$artist);
//convert title and type just in case
$title = iconv('windows-1250', 'utf-8', $title);
$type = iconv('windows-1250', 'utf-8' ,$type);
// Type.
$type = str_replace(' - ', ' — ', $type);
// Legal.
$legal = $this->replaceDualManaSymbols($legal);
$legal = preg_replace('/\%([0-9]+)/', '{\\1}', $legal);
$legal = preg_replace('/\%([WUBRGTXYZ])/', '{\\1}', $legal);
$legal = preg_replace('/\%([C])/', '{Q}', $legal);
$legal = preg_replace('/#([^#]+)# – /', '\\1 – ', $legal); // Remove italics from ability keywords.
$legal = str_replace("\r\n----\r\n", "\n-----\n", $legal); // Flip card separator.
$legal = str_replace('Creature - ', 'Creature — ', $legal);
$legal = str_replace(' upkeep - ', ' upkeep—', $legal);
$legal = str_replace(' - ', ' — ', $legal);
$legal = str_replace('AE', 'Æ', $legal);
$legal = str_replace(".]", ".)", $legal);
$legal = str_replace("\r\n", "\n", $legal);
// Fix vanguard inconsistencies.
if (preg_match('/Starting & Max[^\+\-]+([\+\-][0-9]+)[^\+\-]+([\+\-][0-9]+)/', $legal, $matches))
$legal = 'Hand ' . $matches[1] . ', Life ' . $matches[2] . "\n" . substr($legal, 0, strpos($legal, ' Starting & Max'));
if (preg_match('/Hand Size[^\+\-]+([\+\-][0-9]+)[^\+\-]+([\+\-][0-9]+)\.?/', $legal, $matches))
$legal = 'Hand ' . $matches[1] . ', Life ' . $matches[2] . "\n" . substr($legal, 0, strpos($legal, 'Hand Size'));
$legal = trim($legal);
// Flavor.
$flavor = str_replace("'", '’', $flavor); // ' to ’
$flavor = preg_replace('/"([^"]*)"/', '“\\1”', $flavor); // "text" to “text”
$flavor = preg_replace("/(.*[^.]) '([^']*)'/", "\\1 ‘\\2’", $flavor); // 'text' to ‘text’
$flavor = preg_replace('/(.*[^.]) ’(.*)’/', '\\1 ‘\\2’', $flavor); // ’text’ to ‘text’
$flavor = str_replace('”’', '’”', $flavor); // ”’ to ’”
$flavor = str_replace('‘”', '”‘', $flavor); // ‘” to ”‘
$flavor = str_replace('“’', '“‘', $flavor); // “’ to “‘
$flavor = str_replace(',’', '’,', $flavor); // ,’ to ’,
$flavor = preg_replace("/\r\n- ?/", "\n—", $flavor); // - to —
$flavor = preg_replace("/\r\n#- ?/", "\n#—", $flavor);
$flavor = preg_replace("/ - /", "—", $flavor);
$flavor = str_replace('AE', 'Æ', $flavor);
$flavor = str_replace("\r\n", "\n", $flavor);
$flavor = str_replace('"', '”', $flavor); // " to ”
// Store.
$card = new Card();
$card->title = $title;
$card->set = $set;
$card->color = $color;
$card->type = $type;
$card->pt = ($p != "" && $t !="") ? $p . '/' . $t : (preg_match('/%([0-9]+)#/', $p, $matches) ? "/$matches[1]" : '');
$card->flavor = $flavor;
$card->rarity = $rarity;
$card->cost = $cost;
$card->legal = $legal;
$card->pic = $pic;
$card->artist = $artist;
$card->collectorNumber = $collectorNumber;
$this->cards[] = $card;
}
// Compute total cards in each set.
$setToCollectorNumbers = array();
foreach ($this->cards as $card) {
// Only count cards with collector numbers.
if (!$card->collectorNumber) continue;
// Don't count the same collector number twice.
if (!@$setToCollectorNumbers[$card->set]) $setToCollectorNumbers[$card->set] = array();
if (@$setToCollectorNumbers[$card->set][$card->collectorNumber]) continue;
$setToCollectorNumbers[$card->set][$card->collectorNumber] = true;
}
foreach ($this->cards as $card) {
if (!$card->collectorNumber) continue;
// Try hardcoded value first.
$cardsInSet = MasterBase::getTotalCardsInSet($card->set);
// Then try computed vallue.
if (!$cardsInSet && @$setToCollectorNumbers[$card->set]) $cardsInSet = count($setToCollectorNumbers[$card->set]);
if (!$cardsInSet) continue;
$card->collectorNumber .= '/' . $cardsInSet;
}
}
public function __construct($mwsFileName)
{
$mwsFile = fopen_utf8($mwsFileName, 'rb');
if (!$mwsFile) {
error('Unable to open masterbase CSV file: ' . $mwsFileName);
}
echo "Processing MWS masterbase...";
// windows-1252
//$csv = new CSV(';', "\r\n", '"'); // Cell separator, row separator, value enclosure.
//$csv->setContent(file_get_contents($mwsFileName, false , null)); // Parse the string content.
//$rows = $csv->getArray();
$i = 0;
while (($row = fgetcsv($mwsFile, 6000, ';', '"')) !== FALSE) {
//foreach($rows as $row){
if ($i++ == 0) {
continue;
}
//skip first line
if ($i++ % 50 == 0) {
echo '.';
}
// Extract.
$title = (string) trim($row[0]);
$set = (string) trim($row[1]);
$color = (string) trim($row[4]);
$type = (string) trim($row[6]);
$p = (string) trim($row[8]);
$t = (string) trim($row[9]);
$flavor = (string) trim($row[10]);
$rarity = (string) trim($row[11]);
$cost = (string) trim($row[5]);
$legal = trim($row[7]);
$pic = (string) trim($row[2]);
$artist = (string) trim($row[12]);
$collectorNumber = (string) trim($row[13]);
// Title.
if ($set == 'VG') {
$title = 'Avatar: ' . $title;
}
// Casting cost.
$cost = $this->replaceDualManaSymbols($cost);
$cost = $this->replacePhyrexiaSymbols($cost);
$cost = preg_replace('/([0-9]+)/', '{\\1}', $cost);
//
$cost = preg_replace('/([WUBRGXYZ])/', '{\\1}', $cost);
$cost = preg_replace('/{{([0-9XYZWUBRG])}{([WUBRG])}}/', '{\\1\\2}', $cost);
$cost = preg_replace('/{([P]){([WUBRG])}}/', '{\\1\\2}', $cost);
// Color.
if ($color == 'Z/Z' || strpos($title, '/') !== FALSE && $p == "" && $t == "") {
// Determine split card colors.
$cost1 = substr($cost, 0, strpos($cost, '/'));
$colors = Card::getCostColors($cost1);
$color = strlen($colors) == 1 ? $colors : 'Gld';
$color .= '/';
$cost2 = substr($cost, strpos($cost, '/') + 1);
$colors = Card::getCostColors($cost2);
$color .= strlen($colors) == 1 ? $colors : 'Gld';
}
if (strpos($title, "/") !== FALSE && ($p != "" && $t != "" || $set == 'DKA' || $set == 'ISD')) {
// flip cards fixes
$title1 = substr($title, 0, strpos($title, '/'));
$title2 = substr($title, strpos($title, '/') + 1);
$title = $title1;
$type1 = substr($type, 0, strpos($type, '/'));
$type2 = substr($type, strpos($type, '/') + 1);
$type = $type1;
$pt = "";
if (strpos($t, '|') !== FALSE) {
$t1 = substr($t, 0, strpos($t, '|'));
$pt = substr($t, strpos($t, '|') + 1);
$t = $t1;
} else {
if (strpos($p, '|') !== FALSE) {
$p1 = substr($p, 0, strpos($p, '|'));
$pt = substr($p, strpos($p, '|') + 1) . '/' . $t;
$p = $p1;
$t = '';
if ($pt == '#/') {
//maybe need something more generic for dual planeswalkers later
$pt = '';
$p .= '#';
}
}
}
$insertPosition = strpos($legal, "//");
$insertString = "\n" . $title2 . "\n" . $type2 . ($pt != "" ? "\n" . $pt : "");
$legalTmp = substr_replace($legal, $insertString, $insertPosition + 2, 0);
$legal = $legalTmp;
}
//php5 fixups
$flavor = str_replace("�", '', $flavor);
$flavor = iconv('windows-1250', 'utf-8', $flavor);
$legal = iconv('windows-1250', 'utf-8', $legal);
$artist = iconv('windows-1250', 'utf-8', $artist);
//convert title and type just in case
$title = iconv('windows-1250', 'utf-8', $title);
$type = iconv('windows-1250', 'utf-8', $type);
// Type.
$type = str_replace(' - ', ' — ', $type);
// Legal.
$legal = $this->replaceDualManaSymbols($legal);
$legal = $this->replacePhyrexiaSymbols($legal);
$legal = preg_replace('/\\%([0-9]+)/', '{\\1}', $legal);
$legal = preg_replace('/\\%([WUBRGTXYZ])/', '{\\1}', $legal);
$legal = str_replace('%C', '{Q}', $legal);
$legal = str_replace("<hr>", "-----", $legal);
$flavor = str_replace("<hr>", "-----", $flavor);
$legal = str_replace("//", "-----", $legal);
$flavor = str_replace("//", "-----", $flavor);
//card specific
$legal = str_replace('El-Hajjaj', 'El-Hajjâj', $legal);
$legal = str_replace('Junun', 'Junún', $legal);
$legal = str_replace('Lim-Dul', 'Lim-Dûl', $legal);
$legal = str_replace('Jotun', 'Jötun', $legal);
$legal = str_replace('Ghazban', 'Ghazbán', $legal);
$legal = str_replace('Ifh-Biff', 'Ifh-Bíff', $legal);
$legal = str_replace('Juzam', 'Juzám', $legal);
$legal = str_replace('Khabal', 'Khabál', $legal);
$legal = str_replace('Marton', 'Márton', $legal);
$legal = str_replace("Ma'ruf", "Ma'rûf", $legal);
$legal = str_replace("Ma’ruf", "Ma’rûf", $legal);
$legal = str_replace('Deja Vu', 'Déjà Vu', $legal);
$legal = str_replace('Dandan', 'Dandân', $legal);
$legal = str_replace('Bosium', 'Bösium', $legal);
$legal = str_replace(' en-', ' #en#-', $legal);
$legal = str_replace(' il-', ' #il#-', $legal);
$legal = str_replace('Seance', 'Séance', $legal);
$legal = preg_replace('/#([^#]+)# – /', '\\1 – ', $legal);
// Remove italics from ability keywords.
$legal = str_replace("\r\n-----\r\n", "\n-----\n", $legal);
// Flip card separator.
$legal = str_replace('Creature - ', 'Creature — ', $legal);
$legal = str_replace(' upkeep - ', ' upkeep—', $legal);
$legal = str_replace(' - ', ' — ', $legal);
$legal = str_replace('AE', 'Æ', $legal);
$legal = str_replace(".]", ".)", $legal);
$legal = str_replace("\r\n", "\n", $legal);
// Fix vanguard inconsistencies.
if (preg_match('/Starting & Max[^\\+\\-]+([\\+\\-][0-9]+)[^\\+\\-]+([\\+\\-][0-9]+)/', $legal, $matches)) {
$legal = 'Hand ' . $matches[1] . ', Life ' . $matches[2] . "\n" . substr($legal, 0, strpos($legal, ' Starting & Max'));
}
if (preg_match('/Hand Size[^\\+\\-]+([\\+\\-][0-9]+)[^\\+\\-]+([\\+\\-][0-9]+)\\.?/', $legal, $matches)) {
$legal = 'Hand ' . $matches[1] . ', Life ' . $matches[2] . "\n" . substr($legal, 0, strpos($legal, 'Hand Size'));
}
$legal = trim($legal);
// Flavor.
$flavor = str_replace("'", '’', $flavor);
// ' to ’
$flavor = preg_replace('/"([^"]*)"/', '“\\1”', $flavor);
// "text" to “text”
$flavor = preg_replace("/(.*[^.]) '([^']*)'/", "\\1 ‘\\2’", $flavor);
// 'text' to ‘text’
$flavor = preg_replace('/(.*[^.]) ’(.*)’/', '\\1 ‘\\2’', $flavor);
// ’text’ to ‘text’
$flavor = str_replace('”’', '’”', $flavor);
// ”’ to ’”
$flavor = str_replace('‘”', '”‘', $flavor);
// ‘” to ”‘
$flavor = str_replace('“’', '“‘', $flavor);
// “’ to “‘
$flavor = str_replace(',’', '’,', $flavor);
// ,’ to ’,
$flavor = preg_replace("/\r\n- (.?)/", "\n—\\1", $flavor);
// - to —
$flavor = preg_replace("/\r\n#- (.?)/", "\n#—\\1", $flavor);
$flavor = preg_replace("/ - /", "—", $flavor);
$flavor = str_replace('AE', 'Æ', $flavor);
$flavor = str_replace("\r\n", "\n", $flavor);
$flavor = str_replace('"', '”', $flavor);
// " to ”
// Store.
$card = new Card();
$card->title = $title;
$card->set = $set;
$card->color = $color;
$card->type = $type;
$card->pt = $p != "" && $t != "" ? $p . '/' . $t : (preg_match('/%([0-9]+)#/', $p, $matches) ? "/{$matches['1']}" : '');
$card->flavor = $flavor;
$card->rarity = $rarity;
$card->cost = $cost;
$card->legal = $legal;
$card->pic = $pic;
$card->artist = $artist;
$card->collectorNumber = $collectorNumber;
$this->cards[] = $card;
}
// Compute total cards in each set.
$setToCollectorNumbers = array();
foreach ($this->cards as $card) {
// Only count cards with collector numbers.
if (!$card->collectorNumber) {
continue;
}
// Don't count the same collector number twice.
if (!@$setToCollectorNumbers[$card->set]) {
$setToCollectorNumbers[$card->set] = array();
}
if (@$setToCollectorNumbers[$card->set][$card->collectorNumber]) {
continue;
}
$setToCollectorNumbers[$card->set][$card->collectorNumber] = true;
}
foreach ($this->cards as $card) {
if (!$card->collectorNumber) {
continue;
}
// Try hardcoded value first.
$cardsInSet = MasterBase::getTotalCardsInSet($card->set);
// Then try computed vallue.
if (!$cardsInSet && @$setToCollectorNumbers[$card->set]) {
$cardsInSet = count($setToCollectorNumbers[$card->set]);
}
if (!$cardsInSet) {
continue;
}
$card->collectorNumber .= '/' . $cardsInSet;
}
}
