• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

How to call a simple value from database

llamavani

llamavani

Trinitium Rubidia Style!
Joined
Sep 17, 2009
Messages
173
Reaction score
3
Location
Guadalajara, Mexico
Hello
I want to call a value but I don't know what I'm doing bad

I want the value of a global_storage

Code: 
	$puntosclan = 21200+$guild_id;
	$puntos = $connection->query ('SELECT `value` FROM `global_storage` WHERE `key` = '.$puntosclan)->fetch();

help me people when it shows the result of $puntos shows ARRAY
 
Sort by date Sort by votes
the code is on php take a look:
Code: 
<?php
	
    @DEFINE ('INJECTION_PATH', 'injections/guild_view/Advanced Table');
	
    ################################
    ##          Style part        ##
	
	$image_i = '<img style="border: medium none;" src="'.WEBSITE.'/'.INJECTION_PATH.'/images/Golden_Goblet.gif">';
	ECHO '<link rel="stylesheet" href="'.WEBSITE.'/'.INJECTION_PATH.'/jquery.alerts.css" /><script src="'.WEBSITE.'/'.INJECTION_PATH.'/jquery.alerts.js" type="text/javascript"></script>';
	
	########################
    ##      Connection    ##
	########################
	## Leave these values ##
	########################
	
	$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);
	
	###############
	## Variables ##
	###############
	
	$skills = array(
		0 => "Golpe",
		1 => "Mazo/Garrote",
		2 => "Espada/Cuchilla",
		3 => "Hacha/Filamento",
		4 => "Distania",
		5 => "Escudo",
		6 => "Pesca"
				);
	
#################################################################################
## +---------------------------------------------------------------------------
## | Database queries
## +---------------------------------------------------------------------------
#################################################################################

	$puntosclan = 21200+$guild_id;
	$puntos = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` = '.$puntosclan.'')->fetch();
	$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( );
	$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();
    
        $a=round($allM2[0]);
        $b=$allM1[0];
        $sum = $a+$b+$guildMembers[0]+$allM3[0];

#################################################################################
## +---------------------------------------------------------------------------
## | Functions
## +---------------------------------------------------------------------------
#################################################################################

Function member($guildMembers){
     IF ( $guildMembers[0] == 1 ){
         ECHO "El clan tiene <p style='color:green;display:inline;'><b>".$guildMembers[0]."</b></p> miembros";
     }ELSE{
         ECHO "El clan tiene <p style='color:green;display:inline;'><b>".$guildMembers[0]."</b></p> miembros";
     }
}
Function invite($invite){
      IF ( $invite[0] == 0 ){
         ECHO "No hay miembros invitados";
     }ELSEIF ( $invite[0] == 1 ){
         ECHO "Un miembro esta invitado";
     }ELSE{
	     ECHO "<p style='color:green;display:inline;'><b>".$invite[0]."</b></p> Miembros estan actualmente invitados";
      }
}
Function online($allM){
      IF ( $allM[0] == 0 ){
         ECHO "Nadie esta Online";
     }ELSEIF ( $allM[0] == 1 ){
         ECHO "Un miembro esta conectado";
     }ELSE{
	     ECHO "<p style='color:green;display:inline;'><b>".$allM[0]."</b></p> Miembros estan conectados";
      }
}
Function level($allM1, $allM2){
     ECHO "<p style='color:green;display:inline;'><b>".$allM1[0]."</b></p> Nivel total en el clan<br>";
	 ECHO "<p style='color:green;display:inline;'><b>".round($allM2[0])."</b></p> Promedio del nivel de todos los miembros del clan";
}
Function rank($allM3, $allM4){
     ECHO "<p style='color:green;display:inline;'><b>".$allM3[0]."</b></p> Tiene el nivel mas bajo del clan<br>";
     ECHO "<p style='color:green;display:inline;'><b>".$allM4[0]."</b></p> Tiene el mejor nivel del clan";
}
Function points($sum){
echo "<br><p style='color:green;display:inline;'><b>".$sum."</b></p> puntos de reputacion del clan";
}
Function puntos($puntos){
	$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);
	$puntosclan = 21200+$guild_id;
	$puntos = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` = '.$puntosclan.'')->fetch();
echo "<br><p style='color:green;display:inline;'><b>".$puntos."</b></p> puntos de reputacion del clan";
}

?>

<a id="alert_button" href="#">Puntuaciones mas altas del Clan (Estadisticas Internas)</a>
<style type="text/css">
.ui-tabs {
    height: !auto;
}
</style>
<script>
    $(document).ready(function () {
        $('#serverStats').fadeIn(6000)
    });
    $("a#alert_button").click(function () {
        jAlert('<?PHP echo "<div class=i_head>Skills</div><hr><table align=center>"; foreach($skills as $key => $value) { $allM5 = $connection->query ('
        SELECT`p`.`name`AS`Name`, `ps`.`value`AS`Sword`, `p`.`maglevel`, `p`.`experience`FROM`players`AS`p`JOIN`player_skills`AS`ps`WHERE`ps`.`player_id` = `p`.`id`AND`ps`.`skillid` = '.$key.'
        AND`rank_id`IN(SELECT`id`FROM`guild_ranks`WHERE`guild_id` = '.$guild_id.') ORDER BY`Sword`DESC Limit 1 ')->fetch(); echo "<tr align=center><td><img style=\"border:medium none;\" src=\"".WEBSITE."/".INJECTION_PATH."/images/skills/".$key.".png\"></td><td><div class=i_name>".$allM5[0]."</div></td><td><div class=i_skill>".$allM5[1]." : ".$value."</div></td></tr>"; } echo "</table><div class=i_head>Experiencia</div><hr><table align=center>"; echo "<tr align=center><td><img style=\"border:medium none;\" src=\"".WEBSITE."/".INJECTION_PATH."/images/skills/7.png\"></td><td><div class=i_name>".$allM5[0]."</div></td><td><div class=i_skill>".$allM5[3] . " : Experiencia</div></td></tr>"; echo "<tr align=center><td><img style=\"border:medium none;\" src=\"".WEBSITE."/".INJECTION_PATH."/images/skills/8.png\"></td><td><div class=i_name>".$allM5[0]."</div></td><td><div class=i_skill>".$allM5[2] . " : Nivel magico</div></td></tr>"; ?></table>', '<?PHP echo $image_i;?> Skill Ranking <?PHP echo $image_i;?>');
    });
</script>
<script>
$(function () {
    $("#tabs").tabs();
});
</script>

    <div id="serverStats" style="display:none;">
        <div id='tabs'>
    <ul>
        <li><a href="#general">Informacion General</a></li>
        <li><a href="#statistics">Estadisticas</a></li>
        <li><a href="#glory">Fama</a></li>
    </ul>
    <div id='general'>
        <?PHP $get=member($guildMembers);?>
        <br>
            <?PHP $get=invite($invite);?>
            <br>
                <?PHP $get=online($allM);?>
    </div>
            <div id='statistics'>
                <?PHP $get=level($allM1 ,$allM2);?>
            </div>
            <div id='glory'>
                <?PHP $get=rank($allM3 ,$allM4); $get=points($sum); $get=puntos($puntos);?>
            </div>
        </div>
    </div>
    <br>
        <br>
            <br>
 
Upvote 0 Downvote

Similar threads

M
  • Solved
AAC [MYAAC]Characters page
Replies
5
Views
722
Maarkiin
M
Engradiel
  • Solved
PHP Some PHP Expert to Help me of This command...
Replies
7
Views
297
Engradiel
Engradiel
shakal1994
  • Question
PHP znote acc powergamers
Replies
17
Views
734
mano368
M
johnsamir
  • Question
how to solve these errors that has appeared in my database
Replies
2
Views
595
johnsamir
johnsamir
Izaack
  • Question
Solved [MyACC] Call to a member function getID() on null
Replies
2
Views
323
Fjorda
F
ShadowProwl
  • Question
TFS 1.X+ MySQL errors
Replies
2
Views
277
ShadowProwl
ShadowProwl
A
  • Question
Boosted Monster Gesior
Replies
17
Views
967
Azerty
A
F
  • Question
TFS 1.X+ [tfs 1.4/1.5] edit database multiworld system
Replies
3
Views
608
lursky
L
Back
Top