Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: MySQL query to return users and categories  (Read 2516 times)

0 Members and 1 Guest are viewing this topic.

dquelhas

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
MySQL query to return users and categories
« on: September 02, 2006, 07:44:00 pm »
Hello,

i was looking for the link between the users table, categories table and albuns table without success.
I want to make a query to return the usernames and their categories. Something like:

array(
    user1 => 10003,
    user2 => 10007,
    etc.
)

Can someone help me?

Thanks in advance,

Dinis
« Last Edit: September 02, 2006, 08:09:40 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: MySQL query to return users and categories
« Reply #1 on: September 02, 2006, 07:52:13 pm »
The category is numbered as 10000 + user_id.
Logged

dquelhas

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: MySQL query to return users and categories
« Reply #2 on: September 02, 2006, 07:54:42 pm »
Thanks mate,

it's solved :)
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.018 seconds with 20 queries.