koke / wordpress-scripts
watch download tarball
public
Forks0Right
Watchers5Right
Description: Small collection of scripts to manage wordpress
Homepage: http://people.warp.es/~koke/wordpress-scripts/
Clone URL: git://github.com/koke/wordpress-scripts.git
wordpress-scripts / wp-update-home
100755 35 lines (28 sloc) 0.919 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

#!/usr/bin/env php
<?php
 
 
if ($argc != 3) {
  printf("Usage: %s wp-dir host\n", $argv[0]);
  die;
}
 
$wp_path = $argv[1];
$host_name = $argv[2];
$wp_dir = basename($wp_path);
 
if (!is_dir($wp_path)) {
  printf("Invalid dir\n");
  die;
}
 
require $wp_path."/wp-config.php";
 
if (DB_PASSWORD == "") {
    $popt = "";
} else {
    $popt = "-p" . DB_PASSWORD;
}
if (!preg_match('/^http:\/\//', $host_name)) {
    $host_name = "http://$host_name";    
}
echo "Changing siteurl to $host_name...\n";
$sql = "UPDATE ${table_prefix}options SET option_value = '$host_name' WHERE option_name = 'siteurl'";
system(sprintf("mysql -h %s -u %s $popt %s -e \"%s\"", DB_HOST, DB_USER, DB_NAME, $sql));
echo "Changing siteurl to $host_name...\n";
$sql = "UPDATE ${table_prefix}options SET option_value = '$host_name' WHERE option_name = 'home'";
system(sprintf("mysql -h %s -u %s $popt %s -e \"%s\"", DB_HOST, DB_USER, DB_NAME, $sql));