• [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x 5 0 5 1
Currently:  

Author Topic: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x  (Read 617366 times)

0 Members and 1 Guest are viewing this topic.

Offline Marquis2000

  • Full Member
  • ***
  • Posts: 103
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #165 on: June 29, 2005, 01:45:39 PM »
Also erstmal guter mod hab ihn gerade installiert habe aber noch eine Frage, ich möchte in der Navigation einen Link "Meine Bilder" für die eingeloggten User haben aber ich weiss nicht was in href="" rein muss ??? Das gleiche möchte ich auch für die Kommentare??

Dank im Voraus

Gruß Marquis

Offline martrix

  • Hero Member
  • *****
  • Posts: 755
    • View Profile
    • overlord.cz
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #166 on: June 29, 2005, 04:22:36 PM »
das ist ja eine Frage, die mit der Mitgliederlist nix zu tun hat ;)

ich komme jetzt nicht zu dem Code, also bin ich mir nicht sicher, aber versuch's doch mal mit

Quote
http://www.deinegalerie.de/search.php?search_user={user_name}

in der Template-Datei user_logininfo.html

Falls du mehrere Sprachen auf deiner Seite benutzt, wäre es komplizierter...
MAяTRIX


Offline Marquis2000

  • Full Member
  • ***
  • Posts: 103
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #167 on: June 29, 2005, 05:28:54 PM »
Danke funktioniert ;) allerdings ist in dem link einmal "search.php?" zuviel!!

Offline Marquis2000

  • Full Member
  • ***
  • Posts: 103
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #168 on: June 29, 2005, 05:45:07 PM »
Achso, gehört zwr auch nicht direkt zu dem MOD aber wie geht dann der LInk für die Kommentare des jeweiligen Users??

Offline martrix

  • Hero Member
  • *****
  • Posts: 755
    • View Profile
    • overlord.cz
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #169 on: June 30, 2005, 06:55:54 PM »
allerdings ist in dem link einmal "search.php?" zuviel!!

 :D yep... so was passiert, wenn die Finger schneller sind, als das Gesetz erlaubt  :lol:

wie geht dann der LInk für die Kommentare des jeweiligen Users??
Kannst du die Frage bitte etwas genauer schreiben?
Zu den Kommentaren des jeweilig angemeldeten Users?
Zu den Kommentaren des in der Mitgliederliste angezeigten Users?
 :|
MAяTRIX


Offline Marquis2000

  • Full Member
  • ***
  • Posts: 103
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #170 on: July 01, 2005, 01:35:00 PM »
Ich meine zu den Kommentaren zu dem jeweiligem User der grad eingeloggt ist!!??!

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #171 on: July 10, 2005, 10:53:55 AM »
Hi everybody,

Quote
I have three usergroups:

    * photographers
    * customers
    * partner


Now I'd like to show only the usergroup "photographer" in the memberlist.

I believe, that would be a very useful features. Means this request a lot of work?

Thank you for feedback.

TIMT

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #172 on: July 13, 2005, 01:18:08 PM »
Try the following (untested)...

Open memberlist.php and search for

Code: [Select]
$user_per_page = 10;
and add below

Code: [Select]
$show_group_id = "1";Add the group id you want to show the users from in there. Multiple groups are possible, separate the IDs by comma:

Code: [Select]
$show_group_id = "1,3,8";
Then search for

Code: [Select]
$sql = "SELECT COUNT(*) AS total_user
       FROM ".USERS_TABLE."
       WHERE user_id <> ".GUEST;
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
   $user_cache[$row['user_id']]['total_user'] = $row['total_user'];
}
$site_db->free_result();

$num_rows_all = (isset($user_cache[$user_id]['total_user'])) ? $user_cache[$user_id]['total_user'] : 0;

and replace it with

Code: [Select]
$user_cache = array();
$sql = "SELECT user_id
       FROM ".GROUP_MATCH_TABLE."
       WHERE group_id IN (".$show_group_id.")";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
   $user_cache[$row['user_id']] = $row['user_id'];
}
$site_db->free_result();

$num_rows_all = count($user_cache);

Then search for

Code: [Select]
$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE user_id <> ".GUEST."
        ORDER BY $order_by
        LIMIT $offset, $user_per_page";

and replace it with

Code: [Select]
$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE user_id IN (".implode(',', $user_cache).")
        ORDER BY $order_by
        LIMIT $offset, $user_per_page";
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #173 on: July 13, 2005, 02:00:23 PM »
Thank you for the Code.

Unfortunately I get the following error message:

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id IN 7,1,8,3 ORDER BY user_name ASC LIMIT 0, 10
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 '7,1,8,3 ORDER BY user_name ASC LIMIT 0, 10' a

What do I have to change?


Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #174 on: July 13, 2005, 02:32:59 PM »
Error in last part. I've updated my previous post:

Code: [Select]
$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE user_id IN (".implode(',', $user_cache).")
        ORDER BY $order_by
        LIMIT $offset, $user_per_page";
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #175 on: July 13, 2005, 02:45:43 PM »
Hi Jan

First tests were OK! I thank you very much for the great help.   :D

TIMT

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #176 on: July 13, 2005, 10:44:37 PM »
Jan... it's me again...

I tried to implement the code from V@no for the following features:

Quote
Now someone must do this;
Select user like this (#.A. B. C. D. E. F. G. H. I. J. K. L. M. N. O. P. Q. R. S. T. U. V. W. X. Y. Z)

Now I get stuck with point 1.4. and 1.5.

Find:
Code: [Select]
WHERE user_id <> ".GUEST;
Replace with:
Code: [Select]
WHERE user_id <> ".GUEST.$condition;
and the same Code for 1.5.

This code has changed because of the "usergroup-features".
What do I have to do for point 1.4. and 1.5.?

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: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #177 on: July 14, 2005, 12:36:29 AM »
Code: [Select]
        WHERE user_id IN (".implode(',', $user_cache).")$condition
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 TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #178 on: July 14, 2005, 10:12:47 PM »
Thanks V@no

There is still a little problem.
Once I have click on a character, I get all users beginning with this character. That is fine. Now I want to see all users again, not only users beginning with a specific character.
But the link "ALL" doesn't work. I can see the text "all", but it is not al link.

In the new code, I found only one
Code: [Select]
WHERE user_id IN (".implode(',', $user_cache).")$condition
There were two
Code: [Select]
WHERE user_id <> ".GUEST.")$condition in the old code to change.

That is may be the reason for the problem... I dont know.

What do I have to do for displaying all users again?

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: [Mod] Memberlist / Mitgliederliste > for/für v 1.7.x
« Reply #179 on: July 19, 2005, 08:17:37 PM »
Hi V@no

Can you help me? Do you have a solution?