function addNewKey($devId64, $active, $sec, $note, $client, $user=-1, $serial='') {
        global $admEmail;
        $usrid = $user > 0 ? $user : base64_encode(time());
        $sn = $serial != '' ? $serial : nextSerial();
        $stmt = 'INSERT INTO yubikeys '.
          '(client_id,active,created,tokenId,userId,secret,counter,low,high,notes,serial) VALUES ('.
                $client.','.
                $active.','.
                'NOW(),'.
                mysql_quote($devId64).','.
                mysql_quote($usrid).','.
                mysql_quote($sec).','.
                '0,'.
                '0,'.
                '0,'.
                mysql_quote($note).','.
                mysql_quote($sn).
                ')';
        writeLog($stmt);
        if (!query($stmt)) {
                $err = 'Failed to add a new key, devId='.$devId64.' for client '.$client;
                writeLog($err);
                sendMail($admEmail, 'Failed to add a new yubikey', $err, $admEmail);
                return null;
        }
        $a = array();
        $a['keyid'] = mysql_insert_id();
        $a['sn'] = $sn;
        $a['usrid'] = $usrid;
        return $a;
}

mysql yubikey -e "insert into yubikeys(client_id, userId, active, created, accessed, tokenId, secret) values(1,xxx, 1, '`date +"%Y-%m-%d %H:%M:%S"`', '`date +"%Y-%m-%d %H:%M:%S"`', 'base65 yubikeyid', 'base64 AES secret');"

function setStatVal($name, $val) {
   if (getStatVal($name) == null) { // Insert new
      $stmt = 'INSERT INTO stats (name, value) VALUES ('.
         mysql_quote($name).','.
         mysql_quote($val).
         ')';
      query($stmt);
   } else { // Update existing
      $stmt = 'UPDATE stats SET value='.mysql_quote($val).
         ' WHERE name='.mysql_quote($name);
      query($stmt);
   }
}

DROP TABLE IF EXISTS `stats`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `stats` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(55) default NULL,
  `value` varchar(120) default NULL,
  PRIMARY KEY  (`id`),
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;