Text only | Text with Images

TinyPortal

Development => Support => Topic started by: fangweile on June 02, 2009, 11:43:25 AM

Title: How to batch update articles viewing option via php admin
Post by: fangweile on June 02, 2009, 11:43:25 AM
Hello there,

I have created more than 250 articles and I want to change the viewing option for all articles in category id 4.
I want to display only the following options.

Code Select
title,linktree,top,cblock,rblock,tblock,lblock,lbblock,category,inherit,social,nofrontsetting

I have tried to run this sql query but it failed
Code Select
UPDATE smf_tp_articles SET OPTION = 'title,linktree,top,cblock,rblock,tblock,lblock,lbblock,category,inherit,social,nofrontsetting' WHERE category = 4

Thanks in advance for any help
Title: Re: How to batch update articles viewing option via php admin
Post by: fangweile on June 02, 2009, 11:49:56 AM
Alright, It is working fine now. The query actually worked I just didn't notice it.  My bad
Text only | Text with Images