showthread // postbit : SQL Query

[Harmachis]

Hi, im trying to creat a mod but i need some help in SQL Query.

at SHOWTHREAD & POSTBIT templete i saw these codes:

$post[avatarurl] = for user's avatar url

$post[musername] = shows poster name

$post[message] = shows posted message

now i need to add this codes in my new created PHP file (mod)
but what they r referring ? referring to which SQL code ?

well, i searched in showthread.php file but found nothing like those code

now, can u provide me those SQL code, maybe like $post[message] = $db->query_read(" ...... which will work for the thread i want to read (myMod.php?t=threadid)

tnx in advance