Author Topic: list the recent members?  (Read 24186 times)

0 Members and 1 Guest are viewing this topic.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: list the recent members?
« Reply #15 on: December 13, 2005, 11:58:47 PM »
hey veno can u fix that code am using 4images_vb35_integration
done
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline waleed

  • Jr. Member
  • **
  • Posts: 71
    • View Profile
Re: list the recent members?
« Reply #16 on: December 14, 2005, 12:48:09 AM »
: Bad SQL Query: SELECT userid , username FROM user WHERE userid <> 0 AND lastactivity >= 1134431219 AND = 0 ORDER BY lastactivity DESC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0 ORDER BY lastactivity DESC' at line 3

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

 :(

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: list the recent members?
« Reply #17 on: December 14, 2005, 12:57:23 AM »
I have no clue how VB integration works, so if you dont have user_invisible in includes/sessions.php...maybe you should ask the VB integration's author to help u on this one ;)
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline waleed

  • Jr. Member
  • **
  • Posts: 71
    • View Profile
Re: list the recent members?
« Reply #18 on: December 14, 2005, 01:21:27 AM »

i have that line in sessions.php

// Set her the corresponding database fields of the user table.
// If there is no corresponding field in the new user table,
// leave the value blank. Normally no need to change.
$user_table_fields = array(
  "user_id" => "userid",
  "user_level" => "usergroupid",
  "user_name" => "username",
  "user_password" => "password",
  "user_email" => "email",
  "user_showemail" => "",
  "user_allowemails" => "",
  "user_invisible" => "",
  "user_joindate" => "joindate",
  "user_activationkey" => "",
  "user_lastaction" => "lastactivity",
  "user_location" => "",
  "user_lastvisit" => "lastvisit",
  "user_comments" => "",
  "user_homepage" => "homepage",
  "user_icq" => "icq"
);


any idea ?

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: list the recent members?
« Reply #19 on: December 14, 2005, 01:50:11 AM »
Then remove:
Code: [Select]
AND ".get_user_table_field("", "user_invisible")." = 0
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline waleed

  • Jr. Member
  • **
  • Posts: 71
    • View Profile
Re: list the recent members?
« Reply #20 on: December 14, 2005, 02:00:42 AM »
thanks alot man it works fine now :)

Offline glitzer

  • Full Member
  • ***
  • Posts: 204
    • View Profile
    • over 7000 E-Cards
Re: list the recent members?
« Reply #21 on: February 04, 2006, 08:36:45 PM »
hello
can somebody help me to create the table for this?

i dont know, how i do this

many thanx

Offline TheOracle

  • Hero Member
  • *****
  • Posts: 875
    • View Profile
Re: list the recent members?
« Reply #22 on: February 04, 2006, 08:54:11 PM »
@glitzer:

The SQL Table name : USERS_TABLE should already exists as part of your 4images since your first installation. ;)

Offline glitzer

  • Full Member
  • ***
  • Posts: 204
    • View Profile
    • over 7000 E-Cards
Re: list the recent members?
« Reply #23 on: February 04, 2006, 09:01:42 PM »
oh :-(

i doesnt see something in my whos online when i put in
{today_users}and {today_users_list}. There is nothing to see.

Did i understand it correcly?
I only have to put the code for the index you write in the index.php
and then the {today_users}and {today_users_list} to whos online?

Have i something more to do?

:(

Offline glitzer

  • Full Member
  • ***
  • Posts: 204
    • View Profile
    • over 7000 E-Cards
Re: list the recent members?
« Reply #24 on: February 04, 2006, 09:41:41 PM »
hello!

it works thanks!

It works only in home.html not in whoisonline.

thanks all!

greez

Offline TheOracle

  • Hero Member
  • *****
  • Posts: 875
    • View Profile
Re: list the recent members?
« Reply #25 on: February 04, 2006, 10:07:04 PM »
Quote

{today_users}and {today_users_list}


Ah ! I see what you were trying to do now. Althought, these aren't called "tables" but "tags". ;)