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

[Code Monkey]

You only need a table name on a collumn if you are using JOIN, to distinguish the table. And even then you should asign it a value, " . TABLE_PREFIX . "user AS user, so you wouldn't need the prefix more than once.

In this case, you don't need the table name to be attached to the collumn at all.

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

[ConqSoft]

Exactly, which is the alternative I suggested. Though, adding the prefix will also correct it.

[dieselpowered]

Originally Posted by ConqSoft

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

Yes it did

[Mastar]

K, now where would I know that this has been installed, in the ACP/Forum?

[ConqSoft]

Originally Posted by Mastar

K, now where would I know that this has been installed, in the ACP/Forum?

It'll show up as a product and you'll see its plugin, but there's no settings to administer. It just shows up on the user's profile page.

[Nutz]

Just a little update; I?m having problems with adjusting Boofo?s code to work with the hack but at the same time not mess up the users current time (the one looking at the profile).

Thanks to Boofo and ConqSoft helping people out when I?m not around

Thanks,
Mat

[davidw]

<font color="SeaGreen">* christianb clicks install</font>

[davidw]

I found out after the fact that this product had not been updated with the fix (mentioned on page 2). I had to manually update the product to:

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

and now it works

[Boofo]

Originally Posted by Nutzz

Just a little update; I?m having problems with adjusting Boofo?s code to work with the hack but at the same time not mess up the users current time (the one looking at the profile).

Thanks to Boofo and ConqSoft helping people out when I?m not around

Thanks,
Mat

I use that same code in the profile without any problems. What are you having trouble with?

[Boofo]

Originally Posted by JumpD

You only need a table name on a collumn if you are using JOIN, to distinguish the table. And even then you should asign it a value, " . TABLE_PREFIX . "user AS user, so you wouldn't need the prefix more than once.

In this case, you don't need the table name to be attached to the collumn at all.

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

Thank you. That was all I was trying to point out.