[bananalive]

Originally Posted by gakousei

Sorry to post it again but I had no reply.

I would like to add a profile's field into the player's statistics in the tmnt_ladder_cmpt template.


After I added , user.* into the php code, what am I suppose to add into the template ?

Could you give me an exemple with "field1" ?

i tried with $cmpt[field1] then with $profile[field1] etc...

I don't really know how to add the field into the template.

Help would be greatly appreciate.

change line 311

PHP Code:

" . (!$team ? "LEFT JOIN " . TABLE_PREFIX . "user AS user ON (players.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid) " : "") . " 


to:

PHP Code:

" . (!$team ? "LEFT JOIN " . TABLE_PREFIX . "user AS user ON (players.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid) " : "") . " 


line 309 starts

PHP Code:

$cmpts = $db->query_read("SELECT 


to:

PHP Code:

$cmpts = $db->query_read("SELECT userfield.field1,