Modern AAC - Premium Points

[HeberPcL]

injection.php

<?php
    if(!defined('BASEPATH')) exit('No direct script access allowed');

	//** Connection to the database **// 
	$ots = POT::getInstance(); 
	$ots->connect(POT::DB_MYSQL, connection()); 
	$SQL = POT::getInstance()->getDBHandle(); 

	$player = $GLOBALS['player'];
	$pp = $SQL->query("SELECT `premium_points` FROM `players` WHERE `id` = '".$player->getId()."';");
	
	echo "
		<div class=\"bar\" align=\"center\"> <font size=4> Premium Points </font> </div>
		".$frags."
	";
?>

Error:

A PHP Error was encountered

Severity: 4096

Message: Object of class PDOStatement could not be converted to string

Filename: pp/injection.php

Line Number: 14

How fix?

 

[president vankk]

".$frags." :huh:

What you want do??

 

[Jetro]

<?php 
    if(!defined('BASEPATH')) exit('No direct script access allowed'); 

    //** Connection to the database **//  
    $ots = POT::getInstance();  
    $ots->connect(POT::DB_MYSQL, connection());  
    $SQL = POT::getInstance()->getDBHandle();  

    $player = $GLOBALS['player']; 
	$aid = $SQL->query("SELECT `account_id` FROM `players` WHERE `id` = {$player->getId()} ;")->fetch(); 
    $pp = $SQL->query("SELECT `premium_points` FROM `accounts` WHERE `id` = ".$aid['account_id']." ;")->fetch(); 


	
    echo " 
        <div class=\"bar\" align=\"center\"> <font size=4> Premium Points  </font> </div> 
		
      <tr><td width='90%'><center>".$pp['premium_points']."</center></td></tr>
    "; 
?>

 

[HeberPcL]

Jetro, fix. Thx

 

[danielbruno]

<?php 
    if(!defined('BASEPATH')) exit('No direct script access allowed'); 

    //** Connection to the database **//  
    $ots = POT::getInstance();  
    $ots->connect(POT::DB_MYSQL, connection());  
    $SQL = POT::getInstance()->getDBHandle();  

    $player = $GLOBALS['player']; 
	$aid = $SQL->query("SELECT `account_id` FROM `players` WHERE `id` = {$player->getId()} ;")->fetch(); 
    $pp = $SQL->query("SELECT `premium_points` FROM `accounts` WHERE `id` = ".$aid['account_id']." ;")->fetch(); 


	
    echo " 
        <div class=\"bar\" align=\"center\"> <font size=4> Premium Points  </font> </div> 
		
      <tr><td width='90%'><center>".$pp['premium_points']."</center></td></tr>
    "; 
?>

Jetro...
Can you to convert for GESIOR?

Thanks man.