You are reading the Drake CMS Official Forums archive, available for historical purposes only.
Drake CMS has been rebranded into Lanius CMS, visit the new Lanius CMS Official Forums if you need support about Lanius CMS or Drake CMS -> Lanius CMS migration.
I just found the SQL-Query option and now I was
asking myself, if it would be possible to have an sql statement
which makes content categories from A-Z.
That would be
a great advantage...
Can you help me to build this sql
statement?
awrog
Re: SQL Statement for A-Z Content?
16 March 2008 12:26
Anonymous
L.S.
First of all, you have to be VERY!!
carefull with SQL-statements, your CMS can get corrupted very
easily!!
To display the sections
from DrakeCMS you might try something like:
Code:
select * from
#__sections
More detailed categories (for all
sections of DrakeCMS) you might try: Code:
select * from
#__categories
Once again, first make a tested
backup of your database, to be absolutely sure download a working
copy to your local computer (that is what I do). You might
also consider installing XAMPP (lite) and test it locally.
Remember, you might end up with a 'broken'
system!!
AWRog
siedlerchr
Re: SQL Statement for A-Z Content?
16 March 2008 13:12
Anonymous
Yeah, I know, I will first test it locally on my XAMPP
installation.
SQL Statement for A-Z Content? 