Search results

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

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

Try this.<?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` =...

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:<fieldset> <legend>Account Informations</legend> Account Name: <input type="text" name="name" value="<?PHP echo $accountresult['name']; ?>" /> <br />...

Give me a list of all the fields, please. (Please use the following format: field1, field2, field3 etc)

echo '<strong>Name:</strong> <input type="text" name="name" value="'.$result['name'].'" /><br />'; echo '<strong>Whatever:</strong> <input type="text" name="whatever" value="'.$result['whatever'].'" /><br />';