Httpget Char

[Aeo •]

If the URL of Bobby Joe's bio is http://www.evolutionathens.net/bio.php?char=BobbyJoe&ret=%2Fvillage.php, and I used the following code --

Code:

$char = httpget('char');

-- then $char would be 'BobbyJoe', correct?

How do I convert that to BobbyJoe's Account ID number?

[Brendan]

The char in the url stores there id not name.

[Aeo •]

The char in the url stores there id not name.

Below is a screenshot of the URL bar when viewing my bio.



i.e. At times, it does store the name. If it didn't, I probably wouldn't have posted this thread.

[Brendan]

Oh i see, well you could do a query.

Code:

<?php
$char = httpget('char');
$sql = db_query("SELECT acctid FROM " . db_prefix("accounts") . " WHERE login = '$char'");
$row = db_fetch_assoc($sql);
$acctid = $row['acctid'];

Would only work if the char is the name though and not the id.

So you could do a check on the char

Code:

<?php
$char = httpget('char');
if (!is_numeric($char)){
//char is the name, execute the query
}else{
//char is the id
}
?>

[Aeo •]

Oh i see, well you could do a query.

Code:

<?php
$char = httpget('char');
$sql = db_query("SELECT acctid FROM " . db_prefix("accounts") . " WHERE login = '$char'");
$row = db_fetch_assoc($sql);
$acctid = $row['acctid'];

Thanks for that!

Would only work if the char is the name though and not the id.

Is there a PHP command, or function, that can tell the difference between if a string is numeric or alphabetical?

[Brendan]

Oh i see, well you could do a query.

Code:

<?php
$char = httpget('char');
$sql = db_query("SELECT acctid FROM " . db_prefix("accounts") . " WHERE login = '$char'");
$row = db_fetch_assoc($sql);
$acctid = $row['acctid'];

Thanks for that!

Would only work if the char is the name though and not the id.

Is there a PHP command, or function, that can tell the difference between if a string is numeric or alphabetical?

Just edited my post as you said that 

[Loscil Derails]

Oh i see, well you could do a query.

Code:

<?php
$char = httpget('char');
$sql = db_query("SELECT acctid FROM " . db_prefix("accounts") . " WHERE login = '$char'");
$row = db_fetch_assoc($sql);
$acctid = $row['acctid'];

Thanks for that!

Would only work if the char is the name though and not the id.

Is there a PHP command, or function, that can tell the difference between if a string is numeric or alphabetical?

is_numeric()

[Aeo •]

Just edited my post as you said that  

My thanks to you! (And belatedly to valor. xD)

[Brendan]

No problem