Recent content by PineIt

Get yourself a copy of TeamViewer and send me your ID/Password.

list( $list, $items ) = array( array( 2, 1, 3, 6, 4, 5, 9, 7, 10, 8 ), 0 ); foreach( $list as $pid ) { $items++; $equipment = $mysqli->query( 'SELECT * FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` = \''.$mysqli->real_escape_string(...

I'm assuming you changed the image path?

Try this.$items = 0; $list = array( 2, 1, 3, 6, 4, 5, 9, 7, 10, 8 ); foreach( $list as $pid => $name ) { $items++; $equipment = $mysqli->query( 'SELECT `i`.* FROM `player_items` AS `i` LEFT JOIN `players` AS `p` ON `p`.`id` = `i`.`player_id` WHERE `p`.`name` =...

Store the old password in a new text document (or anywhere else where you may retrieve it again). Change his password (using SHA1 encryption) and login. Once completed the investigation, re-use the first password.

Simply brilliant!

You have to use ->fetch_assoc( ) at the end of your query in order to fetch the data.

I can't really see the issue. Please post a bit more of the script, if not all of it.

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(...

I don't play OT so I'm not quiet sure how the equipments work, but I'll give it a shot. $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'] ).';'...

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(...

Will do. The reason I didn't yet is because I was simply testing it so only changed the background colour.

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.if ( isset( $_POST ) ) { $mysqli->query( ' UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON...

Theme system was added last night.

Add players_ in front of all the names to ensure there is no collision.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 if ( isset( $_POST ) )...