SQL Query Syntax

[DragonByte Tech]

Unfortunately that syntax isn't going to work at all

If you take a look at any of our released vB5 mods, you'll find a file /upload/core/packages/<packagename>/db/mysql/querydefs.php where complex queries are stored.

You then need to use the DB Assertor similar to this:

$data = vB::getDbAssertor()->getRows('DBTechAjaxThreads:getDataForCache-' . $tableShort, array(vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_STORED), false, $keyField);

Or if you want to run simpler queries, you can use something like

		$nodes = vB::getDbAssertor()->getRows('vBForum:node', array(
			vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_SELECT,
			vB_dB_Query::COLUMNS_KEY => array('nodeid', 'lastupdate'),
			vB_dB_Query::CONDITIONS_KEY => array(
				array('field' => 'starter', 'value' => $nodeid, 'operator' => vB_dB_Query::OPERATOR_EQ)
			)
		));

I don't believe there's any documentation for this in the wild just yet, so your best bet would be to examine as many vB5 mods / core vB5 files as you can and try to pick it up as you go.

Hope that helps


Fillip