[Logician]

Originally posted by VeoMorphine
is there an edit i can make that lets certin usergroups use the tags insted of forum names? so insted of putting nick one i can put usergroup 6, 5 ,4

Try this:
edit newsconfig.php find:

PHP Code:

select postid, threadid, username, userid, dateline, title, pagetext, iconid 
from post WHERE
visible= '1' $SQLposters AND (pagetext LIKE '%[news]%' OR pagetext LIKE '%[NEWS]%')AND (pagetext LIKE '%[/news]%' OR pagetext LIKE '%[/NEWS]%') order by dateline DESC LIMIT 500 


Replace it as

PHP Code:

SELECT p.postid, p.threadid, p.username, p.userid, p.dateline, p.title, p.pagetext, p.iconid, u.usergroupid FROM post p LEFT  JOIN user u ON u.userid = p.userid WHERE ( u.usergroupid = 6 OR u.usergroupid = 5 OR u.usergroupid = 7 ) AND visible =  '1' AND ( pagetext LIKE  '%[news]%' OR pagetext LIKE  '%[NEWS]%' ) AND ( pagetext LIKE  '%[/news]%' OR pagetext LIKE  '%[/NEWS]%' ) ORDER  BY dateline DESC  LIMIT 500 


Also find:

PHP Code:

select postid, threadid, username, userid, dateline, title, pagetext, iconid, news 
from post WHERE 
news='1' AND (visible= '1' $SQLposters AND (pagetext LIKE '%[news]%' OR pagetext LIKE '%[NEWS]%')AND (pagetext LIKE '%[/news]%' OR pagetext LIKE '%[/NEWS]%') ) order by dateline DESC LIMIT 500 


And replace it as:

PHP Code:

SELECT p.postid, p.threadid, p.username, p.userid, p.dateline, p.title, p.pagetext, p.iconid, u.usergroupid,p.news FROM post p LEFT  JOIN user u ON u.userid = p.userid WHERE news='1' AND (( u.usergroupid = 6 OR u.usergroupid = 5 OR u.usergroupid = 7 ) AND visible =  '1' AND ( pagetext LIKE  '%[news]%' OR pagetext LIKE  '%[NEWS]%' ) AND ( pagetext LIKE  '%[/news]%' OR pagetext LIKE  '%[/NEWS]%' )) ORDER  BY dateline DESC  LIMIT 500 


This is not tested but should work.. However please notice that this can increase query return time to a certain extend (especially in large dbs) as to query usergroupid we need to connect our SQL query to user table too. I can't say anything how much it will effect. You can turn on $run_time_config variable and test yourself.. For small databases it will not be a big deal anyway..

Enjoy.