Modern AAC Function php

[Kavvson]

<?php
//** Connection to the database and getting the $guild_id **//
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$connection = POT::getInstance()->getDBHandle();
$CI =& get_instance(); 
$CI->load->helper("url");
$guild_id = $CI->uri->segment(3);

//** SQL Query **//
//** List **//
//** Functions **//
//** - Show the amount of members in guild **//
//** - Show the amount of members that are invited **//
//** - V2 **//
//%% - Fade %%//
//%% - Tabs %%//
//** - Show online members in the guild **//
//** - Show the total level of members in guild **//
//** - Show the average level of members in guild **//
//** - Show the highest level in guild **//
//** - Show the lowest level in guild **//
$invite = $connection->query( 'SELECT COUNT(*) FROM `guild_invites` WHERE `guild_id` = '.$guild_id)->fetch( );
$allM = $connection->query ('SELECT COUNT(1) as `people` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') AND online = 1')->fetch(); 
$allM1 = $connection->query ('SELECT SUM(`level`) as `level` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch(); 
$allM2 = $connection->query ('SELECT AVG(`level`) as `level` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch(); 
$allM3 = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `level` ASC LIMIT 1')->fetch(); 
$allM4 = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `level` DESC LIMIT 1')->fetch();

function guildMembers(){
global $connection;
global $guild_id;
global $guildMembers;
$guildMembers = $connection->query ( 'SELECT COUNT(`gr`.`id`) AS `total` FROM `players` AS `p` LEFT JOIN `guild_ranks` AS `gr` ON `gr`.`id` = `p`.`rank_id` WHERE `gr`.`guild_id` = '.$guild_id )->fetch( );
echo $guildMembers[0];
}
$d_gm = guildMembers();

... more

Error : Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\trunk.r241\injections\guild_view\Advanced Table\injection.php on line 34

 

[Cykotitan]

It appears $connection is not a valid object or is null
No, and I don't know how to fix it.