Solved How to show storage info in characters.php?

[Xeikh]

Solved.

Thanks a lot.

 

[Cykotitan]

			$bgcolor = $config['site'][is_int($number_of_rows / 2) ? 'darkborder' : 'lightborder']; $number_of_rows++;
			$main_content .= '<tr style="background-color:'.$bgcolor.'"><td>Fishes:</td><td>';
			if($q = $SQL->query('SELECT value FROM player_storage WHERE player_id = '.$player->getId().' AND `key` = 8981 AND value != 0'))
				$main_content .= $q[0].' fishes';
			else
				$main_content .= 'This player doesn\'t have a fish yet';
			$main_content .= '</td></tr>';

 

[Xeikh]

			$bgcolor = $config['site'][is_int($number_of_rows / 2) ? 'darkborder' : 'lightborder']; $number_of_rows++;
			$main_content .= '<tr style="background-color:'.$bgcolor.'"><td>Fishes:</td><td>';
			if($q = $SQL->query('SELECT value FROM player_storage WHERE player_id = '.$player->getId().' AND `key` = 8981 AND value != 0'))
				$main_content .= $q[0].' fishes';
			else
				$main_content .= 'This player doesn\'t have a fish yet';
			$main_content .= '</td></tr>';

Thanks!!!! Im going to test it, btw... If you want something if change for this, tell me how much it is, your help worth it

 

[BeniS]

Could try this, not sure if you have already called $SQL but remove it if you have:

		$SQL = POT::getInstance()->getDBHandle(); // ?
		$bgcolor = $config['site'][is_int($number_of_rows / 2) ? 'darkborder' : 'lightborder']; $number_of_rows++;
		$main_content .= '<tr style="background-color:'.$bgcolor.'"><td>Fishes:</td><td>';
		$s = $SQL->query("SELECT `value` FROM `player_storage` WHERE `player_id` = ".$player->getId()." AND `key` = 8981 AND `value` != 0")->fetch();
		if($s['value'] > 0)
			$main_content .= $s[0].' fishes';
		else
			$main_content .= 'This player doesn\'t have a fish yet';

		$main_content .= '</td></tr>';

 

[Xeikh]

Thansk! Im going to test it.

Edit:

Works!

Thanks a lot!!!

Im going to print your display and username and use it as picture in my future next altar:$ (Just kidding, but you saved my life!)

 

[Cykotitan]

why $s['value'] > 0 if query has `value` != 0

 

[Xeikh]

why $s['value'] > 0 if query has `value` != 0

I dont know u_u

Anyways thx a lot:3