Author Topic: [MOD] Last User on Profile / Letzter User auf dem Profil  (Read 46493 times)

0 Members and 1 Guest are viewing this topic.

Offline Daniel

  • Full Member
  • ***
  • Posts: 183
  • php rockt
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #30 on: January 29, 2008, 05:21:54 AM »
The Limit for Last User in Profil is 25.
After six Weeks i have 84000 inserts in the lastuser table. (about 84t)
And then the MOD works just perhaps. Sometimes it work and sometimes it dont work.
4images in Benutzung/use seit/since 2002 / Version 1.7.6

Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #31 on: January 29, 2008, 02:19:02 PM »
The Limit for Last User in Profil is 25.
After six Weeks i have 84000 inserts in the lastuser table. (about 84t)
And then the MOD works just perhaps. Sometimes it work and sometimes it dont work.

Ok, I check code. I see why.

1 - MOD is no check for same user visit self profile (is count too).
2 - MOD is no check for different user visit target profile after 1 time (is count too).
3 - MOD is inject for all visit.
4 - MOD is no remove data after days (like postcards) - (is count too).

Is why, after 6 weeks, you have 84000 inserts ( 8O ) and good thing for host support hi DB permission ...

I say for no one use this MOD if small DB permission of host ...
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline Daniel

  • Full Member
  • ***
  • Posts: 183
  • php rockt
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #32 on: July 11, 2008, 07:38:21 PM »
Next Stop:
Datasets: 7897 insgesamt
Highest lastuser_id:32767 (colum one ind lastuser table)
No mohr Data write in Database


    Feld     Typ    Attribute    Null    Standard    Extra    Aktion
    lastuser_id     smallint(5)         Nein          auto_increment     Ändern    Löschen    Primärschlüssel    Index    Unique    Volltext
    userprofil_id     smallint(10)         Nein     0          Ändern    Löschen    Primärschlüssel    Index    Unique    Volltext
    user_on_id     smallint(10)         Nein     0          Ändern    Löschen    Primärschlüssel    Index    Unique    Volltext
    last_date     int(15)         Nein     0          Ändern    Löschen    Primärschlüssel    Index    Unique    Volltext

PRIMARY      PRIMARY      7897       Bearbeiten       Löschen       lastuser_id
4images in Benutzung/use seit/since 2002 / Version 1.7.6

Offline bergblume

  • Sr. Member
  • ****
  • Posts: 463
  • on to the top!
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #33 on: November 12, 2008, 09:21:23 AM »
i've this code:

Code: [Select]
$userpic_img = ($config['userpic'] && @file_exists(ROOT_PATH."data/userpic/".$row['userpic']) && $user_info['user_level'] >= USER) ? "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$row['user_id']."&user_name=".$row['user_name'])."\"><img src=\"".ROOT_PATH."data/userpic/".$row['userpic']."\" width=\"".$config['userpic_width']."\" height=\"".$config['userpic_height']."\" border=\"0\"></a>" : $lang['no_random_userpic'];
how make show userpics with username as " alt="USERNAME" " ???

is there already a solution how to make this possible? I mean not showing username with text in member profile but also with a user pic?

Looking forward to your suggestions.

Greetz,
bergblume

Offline Daniel

  • Full Member
  • ***
  • Posts: 183
  • php rockt
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #34 on: May 07, 2009, 08:05:38 PM »
Next Stop:
Datasets: 9481 insgesamt
Highest lastuser_id:32767 (colum one ind lastuser table)
No mohr Data write in Database
4images in Benutzung/use seit/since 2002 / Version 1.7.6

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #35 on: May 07, 2009, 09:28:20 PM »
Daniel,

defination of columns are in your case wrong:

you should ALTER colums with smallint to int

BACKUP YOUR DATABASE FIRST!

mysql query for phpmyadmin:
Code: [Select]
ALTER TABLE `4images_lastuser` CHANGE `lastuser_id` `lastuser_id` INT( 10 ) NOT NULL AUTO_INCREMENT
V@no mentioned that here
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline Daniel

  • Full Member
  • ***
  • Posts: 183
  • php rockt
    • View Profile
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #36 on: May 07, 2009, 09:33:23 PM »
OK

lastuser_id table changed to "int"

I make a new test now.

thanks in advance Nicky
Daniel
4images in Benutzung/use seit/since 2002 / Version 1.7.6

Offline luener

  • Jr. Member
  • **
  • Posts: 54
  • Pessimisten sind Optimisten mit mehr Erfahrung!
    • View Profile
    • TopFoto24.com
Re: [MOD] Last User on Profile / Letzter User auf dem Profil
« Reply #37 on: October 07, 2009, 11:12:09 AM »
...works it with 1.7.7..???

the variables {lang_last_user} and {last_user} gives no output on member_profile.html.

thanks for answer...!
ralf