Custom Field SQL Query

[Quiver]

The banner is there...

Can you paste the template here? There's something missing or wrong somewhere.

I want, in the end to display the banner in the ad_header template.
But right now I'm trying to test it out in the Twisted Promotion Top User template.
What it should be doing, at this stage, is simply outputting the banner URL.
Instead it outputs nothing at all.

 

[Chris D]

So it will be: {$XTopUser.userFieldValues.banner} then

 

[Quiver]

So it will be: {$XTopUser.userFieldValues.banner} then

Brilliant. That works. Thank you!
It outputs the banner URL. See: http://www.twistedpromotion.com/forum/
Now I want that in ad_header template.
The {$XTopUser.userFieldValues.banner}

Something like this:

<a href="{$XTopUser.homepage}"><img src="{XTopUser.userFieldValues.banner}" alt="{XTopUser.username}"></a>

Of course, when I tried this last time it seems ad_header doesn't have access to the required params?
But I need to use the ad_header template as that's where I want the ad. Any ideas Chris?

 

[Chris D]

Just shooting out so can't be much help.

Basically you might want to look at using a template hook that hooks into the ad_header hook.

You can inject your own template in there and pass to the template any parameters you like.

You should look at tutorials to learn how to use template hooks.

 

[Quiver]

Just shooting out so can't be much help.

Basically you might want to look at using a template hook that hooks into the ad_header hook.

You can inject your own template in there and pass to the template any parameters you like.

You should look at tutorials to learn how to use template hooks.

???

 

[Chris D]

What?

Template hooks are used to inject new HTML or custom templates into existing templates. You can pass parameters into template hooks from PHP as well.

I'm saying you could use that to make the banner parameter available.

Look up some tutorials.

 

[Quiver]

What?

Template hooks are used to inject new HTML or custom templates into existing templates. You can pass parameters into template hooks from PHP as well.

I'm saying you could use that to make the banner parameter available.

Look up some tutorials.

I've viewed tutorials, including this one: http://xenforo.com/community/threads/how-to-use-template-hooks.13167/
I don't know what I'm doing wrong but I just don't get the hang of what I need to do.

 

[Chris D]

It's really no more difficult than what you've already achieved. I have replied to your other thread on the subject we should probably continue the discussion there.