what's different from the previous version...

i.e. what has been fixed/modified :D?

- Mist

[QUOTE]Originally posted by Sho
Some more information about the changes:

Using fresh & clean 2.2.6 files there are at least two code snippets you can't find using the original installer, because JelSoft rewrote them. talon3dhq posted the new 2.2.6 snippets and Boofo applied bira's changes to them.

Also, there is a wrong find/add after in the original installer - it makes you add bira's code where it doesn't belong. Birdie501 pointed this one out.

Finally, there are some very unclear find/replace instructions. For example, you have to search for "...lastactivity" and change it to "...away,lastactivity". Now, in 2.2.6, the line is "...lastactivity,lastvisit". If you just replace the whole line, you loose the "lastvisit". I wrote down the complete new lines and their correct replacements in the new installer.

I installed this hack now, works like a charm :) :banana:

Thank you very much!!!!

regards,
Schorsch

:classic:

:thumbup: thanks Sho

curious I already install your hack at my local and it s perfect but not my server yet so I wonder if do I have to delete and install new one? Is there anything I can update without having to delete it? I already have old one at my server and I have some errors that members mentioned at Bira's thead.

thanks again

Since nothing has changed on the database side, download bira's original installer (there's a link to the thread in the first posting; around page 10 someone posted a text-based installer of the old version), find the code snippets you originally inserted into your files, delete them and install my re-release of the hack. Your user's away status won't be affected by it. :)

Great, thanks Sho :)

Just don't run the queries listed under "Database Changes", of course. The tables are already there.

hello i am getting an error when i try and edit user in admin cp, it is a mysql error that seems to be pointing this hack:


start error:


Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=7
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064

Date: Saturday 24th of August 2002 01:49:57 PM
Script: http://www.domain.co.uk/forums/forum...=edit&userid=7
Referer: http://www.domain.co.uk/forums/admin...t%26userid%3D7

If you are trying to install this hack on 2.2.6, please try my re-release.