Announcement

Collapse
No announcement yet.

Buddy users

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Buddy users

    What query can I use to provide a current count on how many buddies a member might have online at any time ?

    Thank you

  • #2
    This query will show a list of userids that are in a user's buddy list:

    SELECT buddylist FROM usertextfield WHERE userid=X

    Where X is the userid of the user in question. Change usertextfield to include your table prefix if you use one.

    Comment


    • #3
      Thanks Jake

      Is there anyway I can grab whether those users are online at the current time ?

      Comment


      • #4
        Here is a little script I made. Upload it to your forum directory and run it from your browser. The picture shows what it does.
        Attached Files

        Comment


        • #5
          Very nice thank you Jake that's very helpful !!

          Comment

          Loading...
          Working...
          X