[TYPO3] [Typo3] page changed by user:

[Matthew Manderson]

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>
>>  
>> 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.
>