[TYPO3] [Typo3] page changed by user:
Dmitry Dulepov
typo3 at accio.lv
Mon Sep 4 10:35:08 CEST 2006
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.
--
Dmitry Dulepov
http://typo3bloke.net/
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)
More information about the TYPO3-english
mailing list