4WuuA8Ng

1<?php
2
3$sql = array();
4
5$sql[] = 'DROP TABLE IF EXISTS `'._DB_PREFIX_.'justpurchased`)';
6
7$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'justpurchased` (
8    `id_city` int(11) NOT NULL AUTO_INCREMENT,
9    `city_name` varchar(128) NOT NULL,
10    `city_pop` int(10) NOT NULL,
11	`city_pop_small` float(10) NOT NULL,
12    PRIMARY KEY  (`id_city`)
13) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';
14
15$sql[] = 'TRUNCATE `'._DB_PREFIX_.'justpurchased`';
16
17$doc = new DOMDocument();
18$file = _PS_MODULE_DIR_.'justpurchased'.DS.'sql'.DS.'just_purchased_uk.xml';
19$doc->load($file);
20
21
22
23$blocks = $doc->getElementsByTagName("block");
24
25foreach ($blocks as $block)
26{
27		$ids = $block->getElementsByTagName("id_city");
28		$id = $ids->item(0)->nodeValue;
29		$city_names = $block->getElementsByTagName("city_name");
30		$city_name = $city_names->item(0)->nodeValue;
31		$city_pops = $block->getElementsByTagName("city_pop");
32		$city_pop = $city_pops->item(0)->nodeValue;
33		$sql[]= "INSERT INTO `"._DB_PREFIX_."justpurchased` (`id_city`, `city_name`, `city_pop`)
34		values('".$id."','".$city_name."','".$city_pop."')";
35}
36
37$sql[] = 'update `'._DB_PREFIX_.'justpurchased` set city_pop_small = city_pop/1000000';
38foreach ($sql as $query) {
39    if (Db::getInstance()->execute($query) == false) {
40        return false;
41    }
42}