<?php

// +--------------------------------------------------------------------+

// | PowerAdmin								|

// +--------------------------------------------------------------------+

// | Copyright (c) 1997-2002 The PowerAdmin Team			|

// +--------------------------------------------------------------------+

// | This source file is subject to the license carried by the overal	|

// | program PowerAdmin as found on http://poweradmin.sf.net		|

// | The PowerAdmin program falls under the QPL License:		|

// | http://www.trolltech.com/developer/licensing/qpl.html		|

// +--------------------------------------------------------------------+

// | Authors: Roeland Nieuwenhuis <trancer <AT> trancer <DOT> nl>	|

// |          Sjeemz <sjeemz <AT> sjeemz <DOT> nl>			|

// +--------------------------------------------------------------------+

//

// File: seq_update.php

// Description: synches your database after manual insertions.

// Doesnt do much, just searches the highest record_id and updates the seq table with this

require_once("inc/toolkit.inc.php");

require_once("inc/header.inc.php");

// Ok we have to synch it all.

// What to do? Find the MAX(id) on each table and set it to the _seq table.

echo "<P><B>" . _('Synching databases. This is useful if you did manual insertions (in case you havent been here yet).') . "</B></P>";

if(!level(10))

{

    error(ERR_LEVEL_10);

}

function seq_update(&$item)

{

	global $db;

	$number_u = $db->getOne("SELECT MAX(id) FROM $item");

	if($number_u > 1)

	{

		echo $number_u;

		$number_u_seq = $db->getOne("SELECT id FROM " . $item . "_seq");

		if($number_u_seq < $number_u)

		{

			$number_u += 1;

			$db->query("UPDATE " . $item . "_seq SET id='$number_u'");

		}

	}

}

$tables = array('users', 'zones', 'records', 'domains');

array_walk($tables, 'seq_update');

message( _('All tables are successfully synchronized.') );

php?>