Need some direction with this script

[djr33]

Hm. I wonder if that's an infinite loop. Add echo 1; inside the loop-- if you get thousands of 1s, then you know it's an infinite loop that times out after probably 30 seconds (depending on server settings).

By the way:

        died('We are sorry, but there appears to be a problem with the form you submitted.'); 

Should be die, not died. (Technically it's exit 'Message'. The other forms are aliases, which work but aren't standard. That's not too important though.)
But that's in a comment so it shouldn't cause you any problems at the moment.

[traq]

on an unrelated note, that's a weird error. I wonder why it claims there is a ';' when there isn't one in the code at all. Traq, any ideas?
I suppose it really means "the end came too early", and it's just not phrased well.

I get Parse error: syntax error, unexpected '?>' ... - but I'm running 5.4. I would suspect that the ?> was simply synonymous with ; in earlier versions (since you can omit the semicolon -can, not should - in single-line statements), or, at least, resolved to the same error message.

PHP has some weird error messages (but you learn to understand them with time). One of them (in the English version of PHP) is actually written in Indonesian-- some kind of weird typo![/i]

Are you thinking of paamayim_nekudotayim? It's Hebrew (it means "double-colon").

//WORKS TILL HERE
 else {
    $query = "INSERT INTO player_data (player_name, player_id, guid) 
    VALUES ('$player_name', '$player_id', '$guid')"; 
        $result = $mysqli->query($query);
    if ( false===$result ) {
  printf("error: %s\n", mysqli_error($mysqli));
}
else {
     echo 'Player: ' . $player_name . ' ' . $player_id . ' ' . $guid . ' has been added to the whitelist.';
    }
}
$mysqli->close();
?> 

That parses fine for me...

Try adding this immediately after you run the INSERT query:

print '<pre>'; exit( var_dump( $result ) ); 

[djr33]

Are you thinking of paamayim_nekudotayim? It's Hebrew (it means "double-colon").

Yeah, that's the one. Hebrew, not Indonesian. I'll remember that.

Ok, back to the topic, I'll stop being off topic

[itivae]

That parses fine for me...

Try adding this immediately after you run the INSERT query:

print '<pre>'; exit( var_dump( $result ) ); 

I still get a blank screen with this added in. i.e.

else {

    $query = "INSERT INTO player_data (player_name, player_id, guid) 
    VALUES ('$player_name', '$player_id', '$guid')"; 
        print '<pre>'; exit( var_dump( $result ) ); 
        $result = $mysqli->query($query);
    if ( false===$result ) {
  printf("error: %s\n", mysqli_error($mysqli));
}
else {
     echo 'Player: ' . $player_name . ' ' . $player_id . ' ' . $guid . ' has been added to the whitelist.';
    }
   
}
$mysqli->close();

?> 

[itivae]

Hm. I wonder if that's an infinite loop. Add echo 1; inside the loop-- if you get thousands of 1s, then you know it's an infinite loop that times out after probably 30 seconds (depending on server settings).

the result for this code:

else {
echo "1";
    $query = "INSERT INTO player_data (player_name, player_id, guid) 
    VALUES ('$player_name', '$player_id', '$guid')"; 
     
        $result = $mysqli->query($query);
    if ( false===$result ) {
  printf("error: %s\n", mysqli_error($mysqli));
}
else {
     echo 'Player: ' . $player_name . ' ' . $player_id . ' ' . $guid . ' has been added to the whitelist.';
    }
   
}
$mysqli->close();

?> 

else {

$query = "INSERT INTO player_data (player_name, player_id, guid)
VALUES ('$player_name', '$player_id', '$guid')";

$result = $mysqli->query($query);
if ( false===$result ) {echo "1";
printf("error: %s\n", mysqli_error($mysqli));
}
else {
echo 'Player: ' . $player_name . ' ' . $player_id . ' ' . $guid . ' has been added to the whitelist.';
}

}
$mysqli->close();

?>[/PHP]

and

else {
    $query = "INSERT INTO player_data (player_name, player_id, guid) 
    VALUES ('$player_name', '$player_id', '$guid')"; 
     
        $result = $mysqli->query($query);
    if ( false===$result ) {
  printf("error: %s\n", mysqli_error($mysqli));
}
else {echo "1";
     echo 'Player: ' . $player_name . ' ' . $player_id . ' ' . $guid . ' has been added to the whitelist.';
    }
   
}
$mysqli->close();

?> 

Is still a blank screen. Both have been run with

echo 1; 

and

echo "1"; 

Am I using it correctly?

[djr33]

I was talking about the while loop above that. Is it possible that loop is never stopping?

[itivae]

Sorry my mistake. Still blank with this code.

if ($result = $mysqli->query($query)){
while ($obj = $result->fetch_object()) {
        echo '1'; 
       printf ('<div class="bans">'."%s", $obj->banned_guid);
       printf (" appears in the ban list" . '</div>');
    }
} //WORKS TILL HERE 

[djr33]

//WORKS TILL HERE

That doesn't make sense. It can't be blank if it "works" until that point-- you should see a lot of 1s. Back up (keep moving the echo line up the code) until you find where it actually works. Start at the top to be sure it's doing something. If not, it's a parse error and somehow this page is different than the other one.

[itivae]

This is what I get

   $query = "SELECT * FROM player_bans WHERE banned_guid = '$guid'";

echo '1'; //here echos 1 once
 if ($result = $mysqli->query($query)){echo '1'; //here echos 1 once
while ($obj = $result->fetch_object()) {
       
       printf ('<div class="bans">'."%s", $obj->banned_guid);
       printf (" appears in the ban list" . '</div>');
    }
        
} //WORKS TILL HERE 

here it it gives this "Parse error: syntax error, unexpected T_ELSE in /home/userdirfoobar/guid-checker.php on line 35" 35 is the line where the else{} begins.

 if ($result = $mysqli->query($query)){
while ($obj = $result->fetch_object()) {
       
       printf ('<div class="bans">'."%s", $obj->banned_guid);
       printf (" appears in the ban list" . '</div>');
    }
        
} //WORKS TILL HERE
echo '1'; 
 else {

    $query = "INSERT INTO player_data (player_name, player_id, guid) 
    VALUES ('$player_name', '$player_id', '$guid')"; 
     
        $result = $mysqli->query($query);
    if ( false===$result ) {
  printf("error: %s\n", mysqli_error($mysqli)); 

[djr33]

Ok, good. Parse errors are displaying. You can't interrupt if (...) {...} else {....} with something before 'else'. But try it in some other places. You should be able to figure out exactly where it breaks then work out why. I suggest starting a the top of your script first, then jumping down a bit, and continue until it doesn't work (until you don't see any 1s). Then go back to find the exact spot. That's how debugging works, and, yes, it can take a while.