[Replicant]

Create the following directory structure in your product directory

db/mysql

Create a file called querydefs.php in the mysql directory, adjust column names as needed

<?php if (!defined('VB_ENTRY')) die('Access denied.');
class Anonymous_dB_MYSQL_QueryDefs extends vB_dB_QueryDefs
{
	protected $db_type = 'MYSQL';
	protected $saveDbCacheErrorState = false;
	protected $table_data = array(
		'anonymous_log' => array('key' =>  array('logid' , 'userid' , 'parentid' , 'nodeid')) 
	);
	protected $query_data = array();
}

This is the code to do the insert. You will need to set the variables appropriately. These variables worked in my test. I tested it in the createcontent.php frontend controller in the createNewNode() function.

$userinfo = vB_Api::instance('user')->fetchUserInfo();
vB::getDbAssertor()->insert('Replinonymous:anonymous_log',  array(
'userid' => $userinfo['userid'],
'logid' => '',
'parentid' => $input['parentid'],
'nodeid' => $nodeId 
));

That's pretty much it. Any table you want to write to that is not in the vb querydefs file, has to have an entry in your product query defs file for the api to work. You can also put named queries in the querydefs file and call them with assertQuery().