Quote:
Originally Posted by KirbyDE
Well, just execute it
global_start
PHP Code:
$subscribers = $db->query_first("SELECT COUNT(*) AS totalactive FROM " . TABLE_PREFIX . "subscriptionlog WHERE active=1");
$subscribers['totalactive'] = vb_number_format($subscribers['totalactive']);
As this adds 1 Query/Page, you might want to cache the Value in Datastore, but that involves more Code - and File Edits.
|
Kirby, thanks again for the help, but I think I'm code stupid.
I attempt to run the query but it gives me the following error
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'trickyd_ncaa.subscriptionlog' doesn't exist
|
And when I create a new plugin for the global_start.php as you suggested my board gets a fatal error.