Author Topic: signature mod - introduce $in_cat  (Read 3897 times)

0 Members and 1 Guest are viewing this topic.

Offline geohei

  • Jr. Member
  • **
  • Posts: 85
    • View Profile
signature mod - introduce $in_cat
« on: May 26, 2007, 06:15:03 PM »
Hi.

I use signature 2.21 from V@no.
He uses the variable $not_in_cat to eliminate undesired categories.
I'd like to do the opposite, keeping the $not_in_cat variable.

I created $in_cat

How do I have to modify the following query (partial excerpt only) in order to implement this feature?
Code: [Select]
...
WHERE i.image_active = 1 AND c.auth_viewcat = $auth AND i.cat_id NOT IN ($not_in_cat)".(($peruser) ? " AND i.user_id = ".$peruser : "").(($imageid) ? " AND i.image_id <> ".$imageid : "")."
...

Many thanks!
« Last Edit: May 27, 2007, 11:40:20 AM by geohei »

Offline geohei

  • Jr. Member
  • **
  • Posts: 85
    • View Profile
Re: signature mod - introduce $in_cat
« Reply #1 on: May 28, 2007, 02:58:32 PM »
No answer yet ... :?

Did nobody understand the my issue (shall I rephrase?), or is this not possible?
(sorry, I'm not the PHP/MySQL expert)

Thanks,