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

[ConqSoft]

Yep, installed both here too. Work well together. Thanks.

[Boofo]

Nutzz, I'm going to make the files a little smaller in filesize. When I get them done I will post them for you here if you want to use them. The quality will be the exact same.

[Nutz]

I already made a hack to do that. You might want to incorporate it into this for those that don?t already have it.

Nice hack, can i use some of the code for the date/time

Nutzz, I'm going to make the files a little smaller in filesize. When I get them done I will post them for you here if you want to use them. The quality will be the exact same.

Yeah sure. And if any one wants to make a more exciting images please feel free to post them and I will add them to the zip

Oh and if there are any graphics gurus out there that would be interested in making some sun set and sun rise images please contact me

Thanks,
Mat

[dieselpowered]

Cool I think I will look into using this

[Boofo]

Originally Posted by Nutzz

Nice hack, can i use some of the code for the date/time



Yeah sure. And if any one wants to make a more exciting images please feel free to post them and I will add them to the zip

Oh and if there are any graphics gurus out there that would be interested in making some sun set and sun rise images please contact me

Thanks,
Mat

Yes and you should be able to dump that query using that code. Just make sure I get in the credits for all Kirby's, I...I... mean my hard work though.

[dieselpowered]

So has this been updated to include boofo's hack?

[dieselpowered]

Big fat error when trying to view member info:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT timezoneoffset
FROM vb3_user
WHERE user.userid = 1;

MySQL Error : Unknown table 'user' in where clause
Error Number : 1109
Date : Wednesday, November 23rd 2005 @ 08:03:17 PM
Script : http://www.weapondepot.com/vbtesting...lastposter&f=2
Referrer : http://www.weapondepot.com/vbtesting/forums/index.php?
IP Address : XX.XX.XX.XX
Username : XXXXXXX
Classname : vb_database

[ConqSoft]

Ah yes... Missed a table prefix. Easy fix.

[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 =

[dieselpowered]

Darnit....I should have seen that!!! Sorry about that! Thank you