Timezone Image In Profile

Timezone Image In Profile

Description
This plug-in will allow you to have a world timezone image in user profile view.(see screenshot).

Details

• 1 Product
• 1 Phrase
• 1 Template Modification

Notes
Requires 1 small template modification to MEMBERINFO.
The time zone image is selected from the users Timezone options.

History
1.0
Initial Version

1.5
Time and date is imprinted on the timezone image.

1.5.1
Some stupid mistakes by me o_O

Last Words
I hope you enjoy the hack!
And don't forget to click install please



Thanks,
Mat

[dieselpowered]

So then it would be correct to assume that this hack makes a query to the db? Is there anyway to get rid of that query?

[rb290]

hmmm i got another hack installed: The Awards Hack
this is what the MEMBERINFO looks like when i go to edit
with the </table> $footer at the bottom

PHP Code:

<!-- Award detail list -->
<if condition="$show['userawards']">
<a name="award"></a>
<br>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
    <tr>
        <td class="tcat" colspan="3" align="center">$vbphrase[award_showcase]</td>
    </tr>
    <tr>
<if condition="$vboptions[aw_showicon]">
        <td class="thead" nowrap>$vbphrase[award_icon]</td>
</if>
<if condition="$vboptions[aw_showimage]">
        <td class="thead" nowrap>$vbphrase[award_image]</td>
</if>
        <td class="thead" width="100%">$vbphrase[award_description]</td>
    </tr>
    $userawardslistbits
</table>
</if>
<!-- /Award detail list -->

$footer 


[Boofo]

Originally Posted by ConqSoft

In the plugin, change this:

		SELECT timezoneoffset
		FROM " . TABLE_PREFIX . "user
		WHERE user.userid =

To this:

		SELECT timezoneoffset
		FROM " . TABLE_PREFIX . "user
		WHERE " . TABLE_PREFIX . "user.userid =

No, that is wrong. user.userid is NOT a table. The original code is correct.

[ConqSoft]

Umm. user is a table. In his case, it should have been the following, and my listed code change would correct it.

SELECT timezoneoffset
FROM vb3_user
WHERE vb3_user.userid = 1;

[Boofo]

Originally Posted by ConqSoft

Umm. user is a table. In his case, it should have been the following, and my listed code change would correct it.

SELECT timezoneoffset
FROM vb3_user
WHERE vb3_user.userid = 1;

You're missing the point. Yes, user IS a table, but user.userid is not. It is a column of that table. The original code is correct, sorry.

[ConqSoft]

Then explain his error:

SELECT timezoneoffset
FROM vb3_user
WHERE user.userid = 1;

MySQL Error : Unknown table 'user' in where clause

When you reference user.userid you ARE referencing the user table. He doesn't have a user table. He has a vb3_user table. So, it needs to be vb3_user.userid. Or, alternatively, leaving the table off completely and just using userid should work too, since there's only one userid field and there should be no ambiguity.

I don't program in PHP (ASP instead), but I do SQL work for a living, so I know how to reference tables and fields therein.

xtremeoff-road,
Did adding the prefix fix your problem?

[Nutz]

Originally Posted by xtremeoff-road

So then it would be correct to assume that this hack makes a query to the db? Is there anyway to get rid of that query?

Not at the moment but its only one query extra for member view

hmmm i got another hack installed: The Awards Hack

Can you post A link please.

@The SQL error: I fail to see why you would need the TABLE_PREFIX in the where statement take function "fetch_avatar_url"

[sql]
WHERE user.userid = $userid
[/sql]
But if adding the table prefix works then i will change the product :/

Thanks,
Mat

[Boofo]

Originally Posted by ConqSoft

Then explain his error:

SELECT timezoneoffset
FROM vb3_user
WHERE user.userid = 1;

MySQL Error : Unknown table 'user' in where clause

When you reference user.userid you ARE referencing the user table. He doesn't have a user table. He has a vb3_user table. So, it needs to be vb3_user.userid. Or, alternatively, leaving the table off completely and just using userid should work too, since there's only one userid field and there should be no ambiguity.

I don't program in PHP (ASP instead), but I do SQL work for a living, so I know how to reference tables and fields therein.

xtremeoff-road,
Did adding the prefix fix your problem?

Well, adding that isn't going to fix the problem. You are calling a column from a table, and in that sense you wouldn't use a table prefix on a column.

[Mastar]

I don't see it in my usercp options nor in the admincp

[ConqSoft]

Originally Posted by Boofo

You are calling a column from a table, and in that sense you wouldn't use a table prefix on a column.

You're not getting it... You're trying to call a column from a table that DOES NOT EXIST though.

user.userid.

The first part, user, defines the table to look for the second part, userid, which is the fieldname.