[TYPO3-dev] sorting tt_content

[JoH asenau]

> I want to move lots of content of a site from the right column
> (colPos=2) to the bottom of the normal column (colPos=0) via a
> database query or a script.
>
> Now I'm not sure how the sorting is done in the sorting column of
> tt_content. I want the new content to be always at the bottom.
>
> Can anyone give me a hint, please?

tt_content contains a field named sorting.
Default behaviour is: The higher the value the lower the position of this
element on the page.

So you have to fetch the highest sorting value available of the normal
column on that particular page.
Then you have to add this value to each sorting value of the items you are
going to move to make sure they
a) will appear below the "old normal" elements
b) will keep the sorting they already got in the right column.

HTH

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your gob sometimes!)
Dieter Nuhr, German comedian
Xing: http://contact.cybercraft.de
Twitter: http://twitter.com/bunnyfield
TYPO3 cookbook (2nd edition): http://www.typo3experts.com