vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Members who have visited Today (or in the last 24 hours). (https://vborg.vbsupport.ru/showthread.php?t=121883)

A0007 01-05-2007 02:43 AM

Thanks ! cool mod :cool: :lick: :banana: :bunny: :up: :bunny: :bunny: :bunny: :banana: :banana: :banana:
https://vborg.vbsupport.ru/https://vborg.vbsupport.ru/https://vborg.vbsupport.ru/
:bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny:
:bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny:
:bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny: :bunny:

masterme 01-06-2007 11:55 AM

Nice feature this. Looks a bit sad with that single user which is me, but still.
Installed ofcourse!

farooqaaa 01-06-2007 03:37 PM

This is nice ;). Installing the latest version.

Limerick 01-08-2007 06:38 PM

Hello all,
Hello Paul,

I'd like to know if it is possible to display users in chronological order of visiting time instead of alphabetical order?

Thank you.

Limerick 01-08-2007 06:57 PM

Quote:

Originally Posted by Paul M (Post 1144883)
You would need to alter the sql in the plugin.

Sorry, I didn't see this answer before posting my question just above.

But in which way should we "alter the sql in the plugin"? :confused:

Paul M 01-08-2007 09:46 PM

Chage the order by from username to dateline.

Limerick 01-09-2007 05:50 PM

Quote:

Originally Posted by Paul M (Post 1154023)
Chage the order by from username to dateline.

Well, well, well... and could you just explain to me how to do that :o

I'm really not a coder and it's a bit strange for me :(

aciurczak 01-09-2007 07:03 PM

Quote:

Originally Posted by Limerick (Post 1154753)
Well, well, well... and could you just explain to me how to do that :o

I'm really not a coder and it's a bit strange for me :(


Go into the file with a text editor, and you should see a SQL statement that has an order statement in it. It will say something like "ORDER BY USERNAME" as the last clause of the SQL statement. Change the text USERNAME to DATELINE or WHOREAD.DATELINE, and resave the file, perhaps under a new name. Then when you upload the product via the vBulletin product manager, point to your new edited file.

Limerick 01-09-2007 07:05 PM

I tried to change username by dateline and I had the following

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:

                SELECT * FROM user
                WHERE lastactivity > 1168297200 ORDER BY dateline;

MySQL Error  : Unknown column 'dateline' in 'order clause'
Error Number : 1054


Limerick 01-09-2007 07:08 PM

I have the same with WHOREAD.DATELINE

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:

                SELECT * FROM user
                WHERE lastactivity > 1168297200 ORDER BY WHOREAD.DATELINE;

MySQL Error  : Unknown column 'WHOREAD.DATELINE' in 'order clause'



All times are GMT. The time now is 07:51 PM.

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.01877 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (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