• 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!

I need a script (php+sql)

Kavvson

Kavvson

Gdy boli cie glowa wez
Joined
Jun 25, 2008
Messages
1,177
Reaction score
72
Location
Poland
I search for a stand alone script that will give me the ability to check a characters details form a database.

I need just like a easy example no layout needed.

1. Index page you write a players name -> the content will load or switch in a other page ( ?editcharacter=name)
2. There will be displayed like nick,lvl all form database


Regards. I really need it :))
 
Sort by date Sort by votes
PHP: 
<fieldset>
   <legend>Account Informations</legend>

    Account Name :
<?PHP //ECHO $accountresult['name'];  ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['name']; ?>" />
    <br>
    Passowrd :
<?PHP //ECHO $accountresult['password']; ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['password']; ?>" />
    <br>
    Premium Days :
<?PHP //ECHO $accountresult['premdays']; ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['premdays']; ?>" />
    <br>
    Email :
<?PHP //ECHO $accountresult['email']; ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['email']; ?>" />
    <br>
    Group_ID :
<?PHP //ECHO $accountresult['group_id']; ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['group_id']; ?>" />
    <br>
    Page Access :
<?PHP //ECHO $accountresult['page_access']; ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['page_access']; ?>" />
    <br>
    Premium Points :
<?PHP //ECHO $accountresult['premium_points']; ?> <input type="text" name="name" value="<?PHP ECHO $accountresult['premium_points']; ?>" />
    <br>
</fieldset>

<fieldset>
   <legend>Character Informations</legend>

	Name :
   <?PHP echo $result['name']; ?>
	<br>
	Health :
   <?PHP echo $result['health']; ?>
   	<br>
	healthmax :
<?PHP echo $result['healthmax']; ?>
   	<br>
	account_id :
<?PHP echo $result['account_id']; ?>
	<br>
	level :
<?PHP echo $result['level']; ?>
	<br>
	vocation :
<?PHP echo $result['vocation']; ?>
	<br>
	experience :
<?PHP echo $result['experience']; ?>
	<br>
	maglevel :
<?PHP echo $result['maglevel']; ?>
	<br>
	mana :
<?PHP echo $result['mana']; ?>
	<br>
	manamax :
<?PHP echo $result['manamax']; ?>
	<br>
	soul :
<?PHP echo $result['soul']; ?>
	<br>
	posx :
<?PHP echo $result['posx']; ?>
	<br>
	posy :
<?PHP echo $result['posy']; ?>
	<br>
	posz:
<?PHP echo $result['posz']; ?>
	<br>
	cap :
<?PHP echo $result['cap']; ?>
	<br>
	sex :
<?PHP echo $result['sex']; ?>
	<br>
	guildnick :
<?PHP echo $result['guildnick']; ?>
	<br>
	promotion :
<?PHP echo $result['promotion']; ?>
</fieldset>
 
Upvote 0 Downvote
I'm only doing the account part, but you'll most likely be able to modify it for the character part as well.

The view part:
PHP: 
<fieldset>
   <legend>Account Informations</legend>
   
   Account Name:
   <input type="text" name="name" value="<?PHP echo $accountresult['name']; ?>" />
   <br />
   Password:
   <input type="text" name="password" value="<?PHP echo $accountresult['password']; ?>" />
   <br />
   Premium Days:
   <input type="text" name="premdays" value="<?PHP echo $accountresult['premdays']; ?>" />
   <br />
   Email:
   <input type="text" name="email" value="<?PHP echo $accountresult['email']; ?>" />
   <br />
   Group ID:
   <input type="text" name="group_id" value="<?PHP echo $accountresult['group_id']; ?>" />
   <br />
   Page Access:
   <input type="text" name="page_access" value="<?PHP echo $accountresult['page_access']; ?>" />
   <br />
   Premium Points:
   <input type="text" name="premium_points" value="<?PHP echo $accountresult['premium_points']; ?>" />
</fieldset>
The update part:
PHP: 
<?PHP
    
    if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` SET
            `name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).'
            WHERE `id` = ACCOUNT_ID_HERE
        ' );
    }

?>
 
Upvote 0 Downvote
Account_ID_HERE

as i remember you made it a search name option

$result = $mysqli->query( 'SELECT * FROM `players` WHERE `name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\' LIMIT 1;' )->fetch_assoc( );
Click to expand...

so how to connect it with
WHERE `id` = ACCOUNT_ID_HERE
Click to expand...
?

Also what input value should have the submit button
 
Upvote 0 Downvote
Try this.
PHP: 
<?PHP
    
    if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
            `a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).'
            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
        ' );
    }

?>
The input value of the submit button doesn't really matter.
 
Upvote 0 Downvote
Works. But as you know you need refresh the site to see the result.. Is there a other possibility? To see it faster after input and POST it?


@Also

Is there a possibility to add some validation places? on the fields like max value only text/numbers etc
 
Upvote 0 Downvote
To solve the refresh "problem" you may either use JavaScript or the header function to automatically redirect upon success. Yes, it is possible to add validations. I'm to lazy to create them for you, unfortunately. But have a look at strlen( ), filter_var( ) and preg_match( ) (assuming you have at least a small idea of how Regular Expressions work, if not - search the internet for a few functions). There are obviously a lot more functions, but those three are some I would use.
 
Upvote 0 Downvote
PineIt said:
Try this.
PHP: 
<?PHP
    
    if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
            `a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).'
            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
        ' );
    }

?>
The input value of the submit button doesn't really matter.
Click to expand...

Could you give me just 1 example of it for the char info?

Name :
<input type="text" name="name" value="<?PHP echo $result['name']; ?>" />
<br>
Health :
<input type="text" name="health" value="<?PHP echo $result['health']; ?>" />
Click to expand...

and how to connect the 2 UPDATE tasks
 
Upvote 0 Downvote
Add players_ in front of all the names to ensure there is no collision.
PHP: 
Name :
<input type="text" name="players_name" value="<?PHP echo $result['name']; ?>" />
<br>
Health :
<input type="text" name="players_health" value="<?PHP echo $result['health']; ?>" />
PHP: 
<?PHP
    
    if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
            `a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).',
            
            `p`.`name` = \''.$mysqli->real_escape_string( $_POST['players_name'] ).'\',
            `p`.`level` = \''.$mysqli->real_escape_string( $_POST['players_level'] ).'\',
            
            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
        ' );
    }

?>
 
Upvote 0 Downvote
PHP: 
if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
            `a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).'

			`p`.`name` = \''.$mysqli->real_escape_string( $_POST['player_name'] ).'\',
			`p`.`health` = \''.$mysqli->real_escape_string( $_POST['player_health'] ).'\',
			`p`.`account_id` = \''.$mysqli->real_escape_string( $_POST['player_account_id'] ).'\',
			`p`.`level` = \''.$mysqli->real_escape_string( $_POST['player_level'] ).'\',
			`p`.`vocation` = \''.$mysqli->real_escape_string( $_POST['player_vocation'] ).'\',
			`p`.`experience` = \''.$mysqli->real_escape_string( $_POST['player_experience'] ).'\',
			`p`.`maglevel` = \''.$mysqli->real_escape_string( $_POST['player_maglevel'] ).'\',
			`p`.`mana` = \''.$mysqli->real_escape_string( $_POST['player_mana'] ).'\',
			`p`.`manamax` = \''.$mysqli->real_escape_string( $_POST['player_manamax'] ).'\',
			`p`.`soul` = \''.$mysqli->real_escape_string( $_POST['player_soul'] ).'\',
			`p`.`posx` = \''.$mysqli->real_escape_string( $_POST['player_posx'] ).'\',
			`p`.`posy` = \''.$mysqli->real_escape_string( $_POST['player_posy'] ).'\',
			`p`.`posz` = \''.$mysqli->real_escape_string( $_POST['player_posz'] ).'\',
			`p`.`sex` = \''.$mysqli->real_escape_string( $_POST['player_sex'] ).'\',
			`p`.`guildnick` = \''.$mysqli->real_escape_string( $_POST['player_guildnick'] ).'\',
			`p`.`promotion` = \''.$mysqli->real_escape_string( $_POST['player_promotion'] ).'\',
            
            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
			
        ' );
    }

It doesn't work. When i remove the part:

PHP: 
`p`.`name` = \''.$mysqli->real_escape_string( $_POST['player_name'] ).'\',
            `p`.`health` = \''.$mysqli->real_escape_string( $_POST['player_health'] ).'\',
            `p`.`account_id` = \''.$mysqli->real_escape_string( $_POST['player_account_id'] ).'\',
            `p`.`level` = \''.$mysqli->real_escape_string( $_POST['player_level'] ).'\',
            `p`.`vocation` = \''.$mysqli->real_escape_string( $_POST['player_vocation'] ).'\',
            `p`.`experience` = \''.$mysqli->real_escape_string( $_POST['player_experience'] ).'\',
            `p`.`maglevel` = \''.$mysqli->real_escape_string( $_POST['player_maglevel'] ).'\',
            `p`.`mana` = \''.$mysqli->real_escape_string( $_POST['player_mana'] ).'\',
            `p`.`manamax` = \''.$mysqli->real_escape_string( $_POST['player_manamax'] ).'\',
            `p`.`soul` = \''.$mysqli->real_escape_string( $_POST['player_soul'] ).'\',
            `p`.`posx` = \''.$mysqli->real_escape_string( $_POST['player_posx'] ).'\',
            `p`.`posy` = \''.$mysqli->real_escape_string( $_POST['player_posy'] ).'\',
            `p`.`posz` = \''.$mysqli->real_escape_string( $_POST['player_posz'] ).'\',
            `p`.`sex` = \''.$mysqli->real_escape_string( $_POST['player_sex'] ).'\',
            `p`.`guildnick` = \''.$mysqli->real_escape_string( $_POST['player_guildnick'] ).'\',
            `p`.`promotion` = \''.$mysqli->real_escape_string( $_POST['player_promotion'] ).'\',

It works :/ Strange..?
 
Upvote 0 Downvote
Try removing the last comma character (the last character at the promotion line) and add a comma at the end of the premium_points line. If that does not work, use this code.
PHP: 
if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
            `a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).'

            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
            
        ' );
        $mysqli->query( '
            UPDATE `players` AS `p` SET
            
            `p`.`name` = \''.$mysqli->real_escape_string( $_POST['player_name'] ).'\',
            `p`.`health` = \''.$mysqli->real_escape_string( $_POST['player_health'] ).'\',
            `p`.`account_id` = \''.$mysqli->real_escape_string( $_POST['player_account_id'] ).'\',
            `p`.`level` = \''.$mysqli->real_escape_string( $_POST['player_level'] ).'\',
            `p`.`vocation` = \''.$mysqli->real_escape_string( $_POST['player_vocation'] ).'\',
            `p`.`experience` = \''.$mysqli->real_escape_string( $_POST['player_experience'] ).'\',
            `p`.`maglevel` = \''.$mysqli->real_escape_string( $_POST['player_maglevel'] ).'\',
            `p`.`mana` = \''.$mysqli->real_escape_string( $_POST['player_mana'] ).'\',
            `p`.`manamax` = \''.$mysqli->real_escape_string( $_POST['player_manamax'] ).'\',
            `p`.`soul` = \''.$mysqli->real_escape_string( $_POST['player_soul'] ).'\',
            `p`.`posx` = \''.$mysqli->real_escape_string( $_POST['player_posx'] ).'\',
            `p`.`posy` = \''.$mysqli->real_escape_string( $_POST['player_posy'] ).'\',
            `p`.`posz` = \''.$mysqli->real_escape_string( $_POST['player_posz'] ).'\',
            `p`.`sex` = \''.$mysqli->real_escape_string( $_POST['player_sex'] ).'\',
            `p`.`guildnick` = \''.$mysqli->real_escape_string( $_POST['player_guildnick'] ).'\',
            `p`.`promotion` = \''.$mysqli->real_escape_string( $_POST['player_promotion'] ).'\'
            
            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
            
        ' );
    }
PS. I would recommend you to try adding/removing the commas as described above before replacing your code. One query is better than two queries.
 
Upvote 0 Downvote
PHP: 
if ( isset( $_POST ) )
    {
        $mysqli->query( '
            UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
            `a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
            `a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
            `a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
            `a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
            `a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
            `a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
            `a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).',

            `p`.`name` = \''.$mysqli->real_escape_string( $_POST['player_name'] ).'\',
            `p`.`health` = \''.$mysqli->real_escape_string( $_POST['player_health'] ).'\',
            `p`.`account_id` = \''.$mysqli->real_escape_string( $_POST['player_account_id'] ).'\',
            `p`.`level` = \''.$mysqli->real_escape_string( $_POST['player_level'] ).'\',
            `p`.`vocation` = \''.$mysqli->real_escape_string( $_POST['player_vocation'] ).'\',
            `p`.`experience` = \''.$mysqli->real_escape_string( $_POST['player_experience'] ).'\',
            `p`.`maglevel` = \''.$mysqli->real_escape_string( $_POST['player_maglevel'] ).'\',
            `p`.`mana` = \''.$mysqli->real_escape_string( $_POST['player_mana'] ).'\',
            `p`.`manamax` = \''.$mysqli->real_escape_string( $_POST['player_manamax'] ).'\',
            `p`.`soul` = \''.$mysqli->real_escape_string( $_POST['player_soul'] ).'\',
            `p`.`posx` = \''.$mysqli->real_escape_string( $_POST['player_posx'] ).'\',
            `p`.`posy` = \''.$mysqli->real_escape_string( $_POST['player_posy'] ).'\',
            `p`.`posz` = \''.$mysqli->real_escape_string( $_POST['player_posz'] ).'\',
            `p`.`sex` = \''.$mysqli->real_escape_string( $_POST['player_sex'] ).'\',
            `p`.`guildnick` = \''.$mysqli->real_escape_string( $_POST['player_guildnick'] ).'\',
            `p`.`promotion` = \''.$mysqli->real_escape_string( $_POST['player_promotion'] ).'\'
            
            WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
            
        ' );
    }
 
Upvote 0 Downvote
Also now i need a part that will get the players equipment info ( id ) Could you create that?:) All what i made will be released for free like always :p

Just simple sql query that gets the editcharacter info (+ then i could write the id in a input and save )
 
Upvote 0 Downvote
I don't play OT so I'm not quiet sure how the equipments work, but I'll give it a shot.
PHP: 
$eq = $mysqli->query( 'SELECT `i`.* FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` = '.$mysqli->real_escape_string( $_GET['editcharacter'] ).';' )->fetch_assoc( );
 
Upvote 0 Downvote
PineIt said:
I don't play OT so I'm not quiet sure how the equipments work, but I'll give it a shot.
PHP: 
$eq = $mysqli->query( 'SELECT `i`.* FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` = '.$mysqli->real_escape_string( $_GET['editcharacter'] ).';' )->fetch_assoc( );
Click to expand...

hmm and maybe edit the gesior one
PHP: 
$id = $_GET['editcharacter'];
			$number_of_items = 1;
			$main_content .= '<td align=center><table with=100% style="border: solid 1px #888888;" CELLSPACING="1"><TR>';		
                        $list = array('2','1','3','6','4','5','9','7','10','8');
                        foreach ($list as $pid => $name) {
                        $top = $SQL->query('SELECT * FROM player_items WHERE player_id = '.$id.' AND pid = '.$list[$pid].';')->fetch_assoc();
                           if($top[itemtype] == false) {
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br/>'.$player->getSoul().'</td>';
			}
				if(is_int($number_of_items / 3)){
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$list[$pid].'.gif"/></TD></tr><tr>';
				} else {
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$list[$pid].'.gif"/></TD>';
			}
				$number_of_items++;
			}
			else
			{
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br/>'.$player->getSoul().'</td>';
			}
				if(is_int($number_of_items / 3))
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD></tr><tr>';
				else
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD>';
				$number_of_items++;
			}
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Cap:<br/>'.$player->getCap().'</td>';
			}
			}
			$main_content .= '</tr></TABLE></td>';

Just delete some and edit.. How do you think? Could you try
 
Upvote 0 Downvote
PHP: 
echo '<pre>'; // Output
$list = array( 2, 1, 3, 6, 4, 5, 9, 7, 10, 8 );
foreach( $list as $pid => $name )
{
    $equipment = $mysqli->query( 'SELECT `i`.* FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\';' )->fetch_assoc( );
    print_r( $equipment ); // Output
}
echo '</pre>'; // Output
 
Upvote 0 Downvote
Fatal error: Call to a member function fetch_assoc() on a non-object in C:\xampp\htdocs\aapal\char.php on line 97

$equipment = $mysqli->query( 'SELECT `i`.* FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\';' )->fetch_assoc( );
 
Upvote 0 Downvote
Code: 
Fatal error: Cannot use object of type mysqli_result as array in C:\xampp\htdocs\aapal\char.php on line 99

94-106

PHP: 
$list = array('2','1','3','6','4','5','9','7','10','8');
                        foreach ($list as $pid => $name) {
                       
    $top = $mysqli->query( 'SELECT `i`.* FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\';' );
 if($top[itemtype] == false) {
                           if(is_int($number_of_items / 3))
            echo '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD></tr><tr>';
                else
            echo '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD>';
                $number_of_items++;
            }
	}

Sql

Code: 
INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES
(1, 2180, 2180, 2180, 1, '');
 
Upvote 0 Downvote

Similar threads

Jpstafe
  • Solved
Erro Rook_Sample created(MYACC)
Replies
2
Views
279
Jpstafe
Jpstafe
blokerzinha
  • Question
Problem with the wrong player appearing as top even though he is not. Znote
Replies
1
Views
329
blokerzinha
blokerzinha
V
  • Question
AAC reset system geisor
Replies
0
Views
281
vitorelias1
V
ralke
  • Question
AAC Paypal automatic payments doesn't load points on ZnoteAAC
Replies
4
Views
739
ralke
ralke
Adorius Black
  • Question
TFS 1.X+ Adding custom atribute into XML
Replies
1
Views
188
Fjorda
F
Duzo
  • Solved
Zone ACC Version 1.5 Can't Register Account. TFS 1.0
Replies
6
Views
796
kibo433
K
Back
Top