#!/usr/bin/php
<?php

require_once __DIR__ . '/includes/db.inc.php';
require_once __DIR__ . '/includes/src.inc.php';
require_once __DIR__ . '/includes/wildcard.inc.php';

$stam_cfg = array();
$stam_cfg['simulation'] = false;
require_once __DIR__ . '/includes/config.inc.php';

if ($argc < 3) {
	echo "Syntax: $argv[0] <newCategory> <categoryWildcard>\n";
	#db_close();
	exit(2);
}

array_shift($argv);
$newcat = trim($argv[0]);

array_shift($argv);
if (!isset($argv[0]) || (trim($argv[0])=='')) $argv[0] = '*';

$arg = trim(implode(' ', $argv));
# while ($arg = array_shift($argv)) {
	$wildcard = trim(mywc($arg));

	# Simulation mode
	if ($stam_cfg['simulation']) {
		fwrite(STDERR, "============ CAT-MOVETO SIMULATION: $wildcard :: $newcat\n");
		#db_close();
		exit(0);
	}

	$res = db_query("SELECT id, cat, txt FROM stam_entries WHERE
		cat LIKE '".db_real_escape_string($wildcard)."'
	");
	if (!$res) {
		fwrite(STDERR, db_error()."\n");
		#db_close();
		exit(1);
	}
	while ($row = db_fetch_array($res)) {
		$id     = $row['id'];
		$oldcat = $row['cat'];
		$txt    = $row['txt'];

		if ($oldcat == $newcat) {
			echo "ID $id is already in <$oldcat>: $txt\n";
			continue; // not affected
		}

		$x = db_query("UPDATE stam_entries SET
			cat = '".db_real_escape_string($newcat)."'
			WHERE
			id = '".db_real_escape_string($id)."'
			");
		if (!$x) {
			fwrite(STDERR, db_error()."\n");
			#db_close();
			exit(1);
		}

		$afr = db_affected_rows();
		if ($afr != 1) {
			fwrite(STDERR, "Error: Could not update $id <$oldcat> '$txt'\n");
			#db_close();
			exit(1);
		} else {
			echo green("OK! Moved $id from '$oldcat' to '$newcat': $txt\n");
		}
	}
# }

# ---

function green($txt) {
	return "\033[1;32;40m".$txt."\033[0m";
}