Rev 2 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 2 | Rev 4 | ||
|---|---|---|---|
| 1 | #!/usr/bin/php |
1 | #!/usr/bin/php |
| 2 | <?php |
2 | <?php |
| 3 | 3 | ||
| 4 | if (php_sapi_name() != 'cli') { |
4 | if (php_sapi_name() != 'cli') { |
| 5 | echo "Please run in CLI mode\n"; |
5 | echo "Please run in CLI mode\n"; |
| 6 | exit(1); |
6 | exit(1); |
| 7 | } |
7 | } |
| 8 | 8 | ||
| 9 | require_once __DIR__ . '/../includes/database.inc.php'; |
9 | require_once __DIR__ . '/../includes/database.inc.php'; |
| 10 | verbinden(); |
10 | verbinden(); |
| 11 | 11 | ||
| 12 | $cont = file_get_contents(__DIR__ . '/install.sql'); |
12 | $cont = file_get_contents(__DIR__ . '/install.sql'); |
| 13 | 13 | ||
| 14 | $queries = preg_split('@;\s*\n@ismU', $cont); |
14 | $queries = preg_split('@;\s*\n@ismU', $cont); |
| 15 | 15 | ||
| 16 | foreach ($queries as $query) { |
16 | foreach ($queries as $query) { |
| 17 | $query = trim($query); |
17 | $query = trim($query); |
| 18 | if ($query == '') continue; |
18 | if ($query == '') continue; |
| 19 | if (substr($query, 0, 2) == '--') continue; |
19 | if (substr($query, 0, 2) == '--') continue; |
| 20 | $query .= ';'; |
20 | $query .= ';'; |
| 21 | 21 | ||
| 22 | mysql_query($query); |
22 | db_query($query); |
| 23 | 23 | ||
| 24 | $err = mysql_error(); |
24 | $err = db_error(); |
| 25 | if ($err) { |
25 | if ($err) { |
| 26 | fwrite(STDERR, "mySQL error $err at query $query\n\n"); |
26 | fwrite(STDERR, "mySQL error $err at query $query\n\n"); |
| 27 | } |
27 | } |
| 28 | } |
28 | } |
| 29 | 29 | ||