[TYPO3] [Typo3] page changed by user:

[Дылгеров Цыден Владимирович]

I don't have any time to write this sql. I solved this problem by another way: inserting name of group-owner. It is extension named responsible. But the name of group is too short, so I decided to insert field "Description" from be_user (see my version of responsible in attachment (use plugin.responsible_pi1.show_group_description=1)). But I do not any idea of make this extension Multilanguage, because of I don not know how working it in general.
 
But when I wrote this letter I found this http://typo3.org/extensions/repository/view/lastupdate/3.1.7/ - here I see that problem is solved something. Good success! You may find there you SQL-request, I think.
 
 
Matthew Manderson wrote:
 
 
>Hi Дылгеров
 
>Dmitry is right.
 
>However, I have a project coming up and I'll need to do the same thing and I
plan to do it using the mysql route.
 
>So if you write the SQL query (You need to do something ;-) and I'll write
>the rest to insert into your HTML marker.
 
>You can use the phpmyadmin tool in TYPO3 to test your SQL. Use the same tool
>to browse around those tables Dmitry listed to establish what data you
>need.
 
>What do you think?
 
>Matthew
 
 
> Dulepov wrote:
 
> Hi!
> 
> Дылгеров Цыден Владимирович wrote:
>> Hi - I am from Russia.
> 
> Please, spell your name in English for this list and try russian list
> first.
> 
>> I use Typo3 since 2 weeks, and now want to see at the
>> bottom of every of my pages something like:
>> ######################
>> Last Update: The date
>> Updated by user: username or realName
>> ######################
>> I managed with the "Last Update" thing. The problem is
>> discused and solved at several places on the net.
>> Here is one of them
>> http://www.enomaly.com/Last_Update.372.0.html <http://www.enomaly.com/Last_Update.372.0.html> 
>> <http://www.enomaly.com/Last_Update.372.0.html <http://www.enomaly.com/Last_Update.372.0.html> >
>>  
>> The Problem is that I want the backend username which
>> last modyfied the page displayed too.
>> Where(or How) to get it from?
> 
> I afraid there is no direct way because pages table does not contain
> this information. You will need one of two ways. Firsts involves cistom
> field in pages table and hook to TCEmain to record current user when any
> record on this page changes. Seconds is a query involving many tables.
> Quickly I can remember these:
> - pages (page UID here for sys_log table)
> - sys_log (sys_history UID for page record here for sys_history table)
> - sys_history (user UID here for be_users)
> - be_users (user name here)
> 
> Neither of these two is simple for a person who works with typo3 only
> for two weeks. I would go for the first way because it is easier for me
> (personally).
> 
> Of course, I could overlook something but I am pretty sure there is no
> other way.
>