[HELP] How to make your news article author show your avatar? [HELP]

[jerison]

Okay, so I seen this other habbo retros news articles and the author looks like this:

As mine just looks like this: (My username is Jerison but it cuts it off for some reason? ;/)

How do I make mine like the other retros?

 

[LostDreams]

They just add it in manually.

 

[Reedz]

Give me your teamviewer details and I'll do it for you.

 

[jerison]

It's not hard, add the code of you avatar?

e.g.

Add it to the author part in the database?

 

[Reedz]

I've just said, give your teamviewer details and I'll show you.

 

[Pinkman]

This isnt hard. Here is the code man.
1. Go on your news.php
2. Search for {newsAuthor}
3. Add in this code;

<?php

$getCom = mysql_query("SELECT * FROM cms_news WHERE id = '".htmlentities($_GET['id'])."' ");
?><?php
          while($Com = mysql_fetch_array($getCom)){
          $getuserlook = mysql_query("SELECT * FROM users WHERE username = '".$Com['author']."'");
          $userlook = mysql_fetch_array($getuserlook);
                  echo'
                      <img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$userlook['look'].'&direction=1&head_direction=3&size=m" class="floatRight">
                      ';
                                 }?>

4. Then it works!
You should get something like this:

You must be registered for see links

 

[iGlenn]

This isnt hard. Here is the code man.
1. Go on your news.php
2. Search for {newsAuthor}
3. Add in this code;

<?php

$getCom = mysql_query("SELECT * FROM cms_news WHERE id = '".htmlentities($_GET['id'])."' ");
?><?php
          while($Com = mysql_fetch_array($getCom)){
          $getuserlook = mysql_query("SELECT * FROM users WHERE username = '".$Com['author']."'");
          $userlook = mysql_fetch_array($getuserlook);
                  echo'
                      <img src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$userlook['look'].'&direction=1&head_direction=3&size=m" class="floatRight">
                      ';
                                 }?>

4. Then it works!
You should get something like this:

You must be registered for see links

this thread is from 2013....

 

[Kristopher]

this thread is from 2013....

However it is useful if you think about it... Thanks for solvething this! You should much rather use the template engine that rev has... I will be posting a updated script where it uses the template engine. Thanks!

 

[iGlenn]

However it is useful if you think about it... Thanks for solvething this! You should much rather use the template engine that rev has... I will be posting a updated script where it uses the template engine. Thanks!

true, this is useful