Gesior: get char name by id

[raf]

How can i get character name by id ?
i have query to get latest news posts from forum:

$query = $SQL->query("SELECT `z_forum`.`icon_id`,`z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;")->fetchAll();

$author_guid

is the id of author

i've been already looking into forum.php file to check how it's done in there, but can't reproduce it in latestnews.php ;s

 

[Leo32]

How can i get character name by id ?
i have query to get latest news posts from forum:

$query = $SQL->query("SELECT `z_forum`.`icon_id`,`z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;")->fetchAll();

$author_guid

is the id of author

i've been already looking into forum.php file to check how it's done in there, but can't reproduce it in latestnews.php ;s

`players`.`id` = `z_forum`.`author_guid`

So...

$author_guid

is literally just the playerid.

This should work:

$query = $SQL->query('SELECT `name` from `players` where `id` = '.$author_guid.';')->fetch();

 

[EvulMastah]

This query already selects name.

 

[Leo32]

This query already selects name.

I think that's the point he was making; that query has the data he wants, but he isn't sure how to just pull the name out of it?

idk.

 

[StreamSide]

info is there

 

[Gesior.pl]

How can i get character name by id ?
i have query to get latest news posts from forum:

$query = $SQL->query("SELECT `z_forum`.`icon_id`,`z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;")->fetchAll();

$author_guid

is the id of author

i've been already looking into forum.php file to check how it's done in there, but can't reproduce it in latestnews.php ;s

It already gets name of players by SELECT ... , `players`.`name` FROM ...

So to display name of player (it's list of topics, so to display anything you must iterate over it 'foreach'):

$query = $SQL->query("SELECT `z_forum`.`icon_id`,`z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;")->fetchAll();
foreach($query as $thread)
{
     echo 'Thread author character name: ' . $thread['name'];
}

Of course it's not nice that it gets name of player from variable $thread['name'], but this is how works that simple forum [1 table forum].

 

[raf]

omg, i didn't notice it anyway thanks, it works

 

[raf]

Hey, i'm back to this issue. I've made a script that stores player id in database instead of name ( i don't know how to store correctly name ), and i want to pull it out on website as player name. Is there a function for that ?

Nevermind...
Figured it out my self

db.escapeString(Player_name)

in sql query to insert data, and then i can pull the name from database