vb.org Archive
Page 4 of 14 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Timezone Image In Profile (https://vborg.vbsupport.ru/showthread.php?t=101415)

Code Monkey 11-24-2005 01:52 PM
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.


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

ConqSoft 11-24-2005 01:56 PM
Exactly, which is the alternative I suggested. Though, adding the prefix will also correct it.

dieselpowered 11-24-2005 02:18 PM
Quote:
Originally Posted by ConqSoft
xtremeoff-road,
Did adding the prefix fix your problem?
Yes it did :)

Mastar 11-24-2005 05:54 PM
K, now where would I know that this has been installed, in the ACP/Forum?

ConqSoft 11-24-2005 05:57 PM
Quote:
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 11-24-2005 06:57 PM
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 12-05-2005 02:09 PM
<font color="SeaGreen">* christianb clicks install</font>

davidw 12-05-2005 02:37 PM
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:
Code:
                SELECT timezoneoffset
                FROM " . TABLE_PREFIX . "user
                WHERE " . TABLE_PREFIX . "user.userid =
and now it works

Boofo 12-05-2005 05:42 PM
Quote:
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 12-05-2005 05:43 PM
Quote:
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.


Code:
                SELECT timezoneoffset
                FROM " . TABLE_PREFIX . "user
                WHERE userid =
Thank you. That was all I was trying to point out. ;)


All times are GMT. The time now is 12:30 PM.
Page 4 of 14 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01193 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete