#!/usr/local/bin/php -q
<?
/*
 Network Interface Statistics Collection Agent
 by Brett Baugh
 */

// Delete or comment out the "echo" line below to enable this script
// after you've read the comments.  :)
echo "You need to edit this script and read the comments at its\nbeginning before running it. Important stuff in there...\n\n"; die;

/*
 Did I mention that once this script has run, you can't run
 it again? :)  "mysqldump -a stats > backup.sql" is all I can say.

 This script updates a version 2.1 installation of NISCA to
 version 2.2, and ONLY version 2.1.  It alters your database,
 so be sure to back up your database before running it, usually by
 running "mysqldump stats > backup.sql". To restore this dump, you
 would do something like:

 echo y|mysqladmin drop DATABASE_NAME
 mysqladmin create DATABASE_NAME
 mysql DATABASE_NAME < backup.sql

 ...and be sure to redo the privileges the user NISCA connects as
 has to DATABASE_NAME if necessary.

 Okay, here endeth the comments; update away.....
 */

require_once("/etc/nisca/nisca.conf");
require_once($location["functions"]);

set_time_limit(0);

///////////// THIS IS WHERE THE OLD STUFF STARTS! /////////////
// If you've already applied this file once, just comment out everything
// from here down to the "NEW STUFF" line below with "/*   */"
// and run it again.

if ($version != "2.1") {
  echo "\n\nSorry; you need to upgrade (or downgrade) from\n" .
       "v$version to v2.1 before running this... Dying.\n\n";
  die;
}
?>

Okay, stand by; this shouldn't take long.
(Any errors you see beyond this point are abnormal
and should have some attention payed to them.)

<?
$version="2.2";

// First, update the version number in the database.
$sq="update config set version='$version'";
$res=dosql($sq);

// Add the new columns to the reports table.
$sq="alter table reports add column multiple varchar(1) default ''";
$res=dosql($sq);

///////////// THIS IS WHERE THE NEW STUFF STARTS! /////////////

// Add the new columns to the interfaces table.
$sq="alter table interfaces add column hostalias varchar(255) default ''";
$res=dosql($sq);
$sq="alter table interfaces add column method varchar(16) default 'ifDescr'";
$res=dosql($sq);
$sq="alter table interfaces add column cir bigint default 0";
$res=dosql($sq);
// We won't initialize the "hostalias" column, so the admin section
// will try getting the "sysName" entry for each host first.

///////////// BELOW HERE IS EVEN NEWER! /////////////

$sq="alter table reports add column multi_int int default 300";
$res=dosql($sq);

///////////// BELOW HERE IS THE NEWEST! /////////////

$sq="alter table localhost add column speed bigint default 0";
$res=dosql($sq);

echo "------------------------------\nUpdate to version 2.2 complete!\n\n";
?>