Character Name Changer php Script (Requested)

Status
Not open for further replies.
Re: [Release] Character Name Changer php Script (Requested)

this is my char check but it gives me the Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource error:

Code:
$charcheck = mysql_query('SELECT * FROM characters WHERE name="'.$_POST['char2'].'"');

if(mysql_num_rows(mysql_query($charcheck)) >= 1 ){
echo '<center>This name already exists!</center>';
ROFL! Please link me to the page that has this code. I would love to empty your entire database :)
 
Re: [Release] Character Name Changer php Script (Requested)

That's funny, I made one a while ago but couldn't seem to get it to work

PHP:
<?php
if (array_key_exists('reset', $_POST)) {
  include('config.php');
  $username = trim($_POST['username']);
  $password = trim($_POST['password']);
  $username = mysql_real_escape_string($username);
  $char = trim($_POST['char']);
  $nchar = trim($_POST['nchar']);
  $mesocheck = mysql_query('SELECT * FROM meso FROM characters');
  $result = mysql_query("SELECT meso, accountid FROM characters WHERE name = '$char' LIMIT 1");
  list($meso, $accountid) = mysql_fetch_row($result);
  $result = mysql_query("SELECT id, password, salt FROM accounts WHERE name = '$username' LIMIT 1");
  list($id, $realpass, $salt) = mysql_fetch_row($result);
  $sel = 'SELECT * FROM characters WHERE name="'.$_POST['char'].'"';
  $sql = "SELECT * FROM accounts WHERE name = '$username'";
  $result = mysql_query($sql);
  $row = mysql_fetch_assoc($result);
  
if($username == ""){
echo 'No username filled in.';
exit();
}elseif(mysql_num_rows(mysql_query($sel)) >= 1 ){
echo 'This username does already exists!';
exit();
}elseif($realpass == hash('sha512',$password.$salt) && $accountid == $id && $meso >= 9000000 && $loggedin < 1) { 	
     mysql_query("UPDATE characters SET name = '$nchar' WHERE name = '$char' LIMIT 1");
     mysql_query("UPDATE characters SET meso = meso - 9999999 WHERE name = '$char' LIMIT 1");
     echo "Yay!! You Changed Your Name to '$nchar'";
} else
     echo "You didn't put he right info -_-";    }
  else {
    $message[] = '';
    }
?>
The Form
PHP:
<form id="form1" name="form1" method="post" action="changename.php">
   <h2>Username:</h>
                   <input id="username" type="text" name="username" maxlength="12" / style=" font-size:.80em;border:2px inset pink;">
   <h2>Password :</h>
           <input id="password" style=" font-size:.80em;border:2px inset pink;" type="password" name="password" maxlength="20" />
<h2>Character Name:</h>
<input id="char" type="text" name="char" style=" font-size:.80em;border:2px inset pink;" maxlength="12" />
<h2>New Character Name: </h><input id="nchar" type="text" name="char" style=" font-size:.80em;border:2px inset pink;" maxlength="12" />
<input id="reset" name="reset" type="submit" style=" font-size:.80em;border:2px inset pink;" value="Change Your Name For 9.999999 Mil!" />
                 
              </form>
Does anyone know what's wrong with it?
 
Status
Not open for further replies.
Back