".$sql."";
$mdb2 = getConnection();
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
print 'Error: '.$affected->getMessage().'.
';
else
print "Successful update.
\n";
}
// ttGenerateKeys - generates keys for groups that do not have them.
function ttGenerateKeys() {
$mdb2 = getConnection();
$sql = "select id from tt_groups where group_key is null and status = 1";
$res = $mdb2->query($sql);
if (is_a($res, 'PEAR_Error')) die($res->getMessage());
$numGroups = 0;
while ($val = $res->fetchRow()) {
$group_id = $val['id'];
$group_key = $mdb2->quote(ttRandomString());
$sql = "update tt_groups set group_key = $group_key where id = $group_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error')) die($affected->getMessage());
$numGroups++;
}
print "
Generated keys for $numGroups groups.
\n";
}
if ($request->isGet()) {
echo('