1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Juice Compent for Joonla CMS - problem

Discussion in 'Content Management' started by cdx, May 14, 2006.

0
  1. #1
    Hello all...

    I imported 4000 users to joomla DB. I have now 4000 users that I need to enable them! The only way I see that I can enable them is by going one-by-one and pressing the ENABLE buttom!

    Is there any other way to enable ALL the users after I have imported them into Joomla ?

    Thanks in advance!

    Guy.
     
    cdx, May 14, 2006 IP
  2. tyrithe

    tyrithe Member

    Messages:
    97
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    Maybe you can look into doing an SQL update command to change the status, but I'm not sure about that one. Having to manually do it sounds like a lot of work.
     
    tyrithe, May 14, 2006 IP
  3. cdx

    cdx Peon

    Messages:
    364
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I found something ...

    There is an option for disabeling the need for approval from admins.

    Now the problem is that it doesn't approve everytime I am importing users... It did just in the first import.....

    Strange, don't you think so?
     
    cdx, May 14, 2006 IP
  4. natsirtm

    natsirtm Active Member

    Messages:
    114
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #4
    definitely just do a sql update.

    UPDATE #__users
    SET block = 0;

    replace #__ with your prefix (eg. jos_)
     
    natsirtm, May 14, 2006 IP