I am attempting to get vBExperience to integrate with QuoteIt! and count quote submissions, but I am having problems revising the same Custom Data Provider script.
This is my first attempt:
PHP Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<product productid="xpquotes" active="1">
<title>vBExperience QuoteIt! Integration</title>
<description>vBExperience QuoteIt! Submission Tracking</description>
<version>1.0.0</version>
<dependencies>
<dependency dependencytype="product" parentproductid="vbexperience3" minversion="3.7.14" maxversion="" />
</dependencies>
<codes>
<code version="1.0.0">
<installcode><![CDATA[
if (!field_exists('xperience_stats', 'points_misc_quotes')) $vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "xperience_stats ADD points_misc_quotes BIGINT DEFAULT '0'");
function field_exists($table, $field)
{
global $vbulletin;
return ($vbulletin->db->num_rows($vbulletin->db->query_read("SHOW COLUMNS FROM `" . TABLE_PREFIX .$table."` LIKE '".$field."'"))> 0);
}
]]></installcode>
<uninstallcode><![CDATA[
]]></uninstallcode>
</code>
</codes>
<templates>
<template name="xpquotes_profile" templatetype="template" date="1205333644" username="Phalynx" version="1.0.0"><![CDATA[
<if condition="$xperience_points_misc_quotes<>0"><li><span class="shade">$vbphrase[xperience_points_misc_quotes]:</span> $xperience_points_misc_quotes</li></if>
]]></template>
</templates>
<plugins>
<plugin active="1" executionorder="5">
<title>vBExperience QuoteIt! Integration</title>
<hookname>xperience_calcdata</hookname>
<phpcode><![CDATA[
if ($vbulletin->options['xperience_points_quotes'] > 0)
{
if ($DoDebug==1) echo "<br/>Custom Data Provider - Quotes";
$attq = $vbulletin->db->query_read("SELECT
SUM(counter) as sum_quotes
FROM " . TABLE_PREFIX . "quotes
WHERE userid=".$user['userid']);
if ($vbulletin->db->num_rows($attq) > 0)
{
$att = $vbulletin->db->fetch_array($attq);
$xperience['count_misc_quotes'] = $att['sum_quotes'] * $vbulletin->options['xperience_points_quotes'];
$xperience['count_misc'] += $xperience['count_misc_quotes'];
$additionalsql .= "points_misc_quotes=".$xperience['count_misc_quotes'].",";
}
}
]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title><![CDATA[vBExperience QuoteIt! Integration]]]></title>
<hookname>xperience_memberprofile</hookname>
<phpcode><![CDATA[
global $vbphrase;
$xperience_points_misc_quotes = vb_number_format($stat_q['points_misc_quotes']);
eval('$this->block_data[xperience_points_misc_tpl] .= " ' . fetch_template('xpquotes_profile') . '";');
]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>vBExperience (cache_templates)</title>
<hookname>cache_templates</hookname>
<phpcode><![CDATA[
if ($vbulletin->options['xperience_enabled']) {
$globaltemplates = array_merge($globaltemplates, array(
'xpquotes_profile'
));
}
]]></phpcode>
</plugin>
</plugins>
<phrases>
<phrasetype name="GLOBAL" fieldname="global">
<phrase name="xperience_points_misc_quotes" date="0" username="Phalynx" version="1.0.0"><![CDATA[Custom Data Provider]]></phrase>
</phrasetype>
<phrasetype name="vBulletin Settings" fieldname="vbsettings">
<phrase name="setting_xperience_points_quotes_desc" date="1205333644" username="Phalynx" version="1.0.0"><![CDATA[How many points should be given for quotes?]]></phrase>
<phrase name="setting_xperience_points_quotes_title" date="1205333644" username="Phalynx" version="1.0.0"><![CDATA[Points for Custom Data Provider Sample]]></phrase>
</phrasetype>
</phrases>
<options>
<settinggroup name="xperience_points" displayorder="7502">
<setting varname="xperience_points_quotes" displayorder="300">
<defaultvalue>2</defaultvalue>
</setting>
</settinggroup>
</options>
</product>
The script seemed to import, but the following error resulted when Updating Points:
Code:
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT
SUM(counter) as sum_quotes
FROM quotes
WHERE userid=1;
MySQL Error : Unknown column 'counter' in 'field list'
Error Number : 1054
Script : xxxxxxxxxxxxxx/admincp/misc.php?do=xperience_recount_xp
Referrer : xxxxxxxxxxxxxxt/admincp/misc.php?do=chooser
The new field does not appear in any ACP options or templates either.
The way I see it, I have two options of referencing quote totals. The first is by totaling the counts by running through and counting totals for each "userid" within the "quotes" table. The second is by directly referencing the "quotecount" field within the "user" table, which I would think would be easier. I would appreciate anyone having a quick look at the code and offering suggestions.
More Information