Adding Profile Phot and URL to view_video.tpl

Hey All -

Listen I am attempting to add the Profile photo and website URL of the person whon uploaded the video to show in the view_video.tpl

So far no go on photo -

On URL I found a thread here with an answer that did not work (for me or the original question holder) what I have so far is this.

Code:

---

{insert name=id_to_name assign=uweb un=$user_info[0].website}{$uweb}

---

or this:

Code:

---

{insert name=id_to_name assign=uweb un=$website}{$uweb}

---

My output I get is for either is:

Quote:

---

ERROR: Unable to execute query

SELECT `username` FROM `signup` WHERE `UID`=

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

---

So I have something happening, but obviously its not right - any help, suggestions?? Is buyscripts or an Admin around that might know the answer to this?

Thanks For any input - and YES I will post the answer if I figure it out.

- MTOD

I have not tried this yet, but it's worth a shot. Just tossing out ideas. Let me know if it works.

In user.tpl you'll find code relating to their URL which looks something like this:

Code:

---

{if $user_info.website ne ""}
Website:{$user_info.website}
{/if}

---

You might have to stick that into the appropriate place on view_video.tpl?

For the photo, all it says in user.tpl is

Code:

---

[img]{$photo_url}[/img]

---

Not sure if just poking that into view_video.tpl will work or not.

grynmoors -

Thanks, but no I read about that in another posting - it does not work at all - that format requires something from the user.php so it will work in user.tpl. In other word just putting it in does not work :(

Any other ideas - Any chance the Admin (buyscripts) would give a hint - please :!:

Well, I wracked my brain and I give up.

I think it has something to do with the smarty/plug-ins stuff like this one:

Code:

---

{insert name=favour_count assign=favcount uid=$UID}
Favorites: {$favcount}

---

I think we just need to figure out what the insert name and assign name is for website and the photo, or at least how to create one in the smarty/plug-ins thing if it doesn't exist :?:

Something like this maybe:

Code:

---

{insert name=user_info assign=website uid=$UID}Website: {$user_info.website}</div>

---

:?: :?: :?:

I tried all kinds of things and either got a smarty (plug-in error) or mysql error.

grynmoors -

Thanks for trying - maybe an admin would help? At least I know I tried all I could think of, because I am getting the same errors.

This is really frustrating - because we must be close - but without a little assist from "buyscripts" I may be dead in the water on this.

Anyone else have any luck - I know that mhancoc7 has the user photo on the view_video.tpl, but mhancoc7 correct me if I an wrong - you said you are using two modified scripts - so not the same?

-MTOD

Yeah, he's using a combination of scripts. cl*p sh*re and vShare I believe.

I don't think admin or buyscripts visits this section of the forums very often if at all, leaving us to our own devices...and there's a saying, "Leave them alone long enough and they'll figure it out on their own." which might be coming into play. :?

To bad they dont check in here the best to better the script and layouts seem to come from here - lol

Well you might be right

Quote:

---

...and there's a saying, "Leave them alone long enough and they'll figure it out on their own."

---

- I figured I would take a day or two off from this problem and maybe go at it fresh on Wednesday this week, when I have some time to commit.

- MTOD

mahanoc said

Quote:

---

<a href="{$baseurl}/{$uname}">[img]{$baseurl}/photo/{$UID}.jpg[/img]

---

But of course! DOH!

I just have one thing to say besides Thank You:

Quote:

---

Leave them alone long enough and they'll figure it out on their own.

---

Now...for the user URL...

grynmoors -

Thanks I had to work in the real world for a few days -

Quote:

---

But of course! DOH!

I just have one thing to say besides Thank You:

---

???

Did you have any luck figuring this out? I will be working on it in the mean time.

- MTOD Erica

The original poster was banned by admin for "promoting a non-vshare site" and all his posts have been deleted which blows because he posted a lot of very useful code and now it's all lost unless y'all happened to copy/paste any of it and kept it on file or applied it to existing templates.

Here's the code he posted:

Code:

---

[img]{$baseurl}/photo/{$UID}.jpg[/img]

---

He, too, has had trouble with the URL part. I think it's a lost cause.