Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Login

Or Register
Accueil / forum / Public Forum / Main Forum / Users List order in backend

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

×

Notice

The forum is in read only mode.

  1. forum
  3. Public Forum
  5. Main Forum
  7. Users List order in backend
× OLD Forum post could be checked here : forum.joomprod.com

Users List order in backend

More
8 years 8 months ago #21217 by raggio
Users List order in backend was created by raggio
I use Adsmanager 3.1.5 but I've a problem with User Field in Backend.
If I have to add an ads for a user (we have almost 20.000 in our site) I just have a select list of 20.000 users random!
How can I find it? Is it possible to have an alphabetic order ( or a search in the select like as category choose)?

Thank you, Raggio
WWOOF Italia - www.wwoof.it
More
8 years 8 months ago #21219 by loic
Replied by loic on topic Users List order in backend
Hello,

In 'administrator/components/com_adsmanager/models/user.php', line 212, replace that line:
$this->_db->setQuery("SELECT * FROM #__users WHERE 1"  );

By this one:
$this->_db->setQuery("SELECT * FROM #__users WHERE 1 ORDER BY username ASC"  );

Best regards.
More
8 years 8 months ago - 8 years 8 months ago #21227 by raggio
Replied by raggio on topic Users List order in backend
You are very kind and fast!
Ok, now it's possible.
I suggest you to thinking to a search because for example from a tablet can be difficult to scroll 20.000 users.
Then to charge the page with all the select is a very hard work for the server.
If the select would be as the Category one (with search) it should be better.
Thank you, Raggio
WWOOF Italia - www.wwoof.it
Last edit: 8 years 8 months ago by raggio.
More
8 years 8 months ago #21236 by loic
Replied by loic on topic Users List order in backend
Hello,

It is a good remark, I will add that upgrade in the to-do list.

Best regards.
More
7 years 11 months ago #25176 by raggio
Replied by raggio on topic Users List order in backend
After 9 months users on my site are 36.000 and i can't access to ADS in BAckend becouse the page gives this error:

Si è verificato un errore.
3 Error writing file '/dev/shm/MYPmfWbf' (Errcode: 12) SQL=SELECT * FROM #__users WHERE 1 ORDER BY name ASC


How can I resolve?
Since a month I can't validate new ads!
WWOOF Italia - www.wwoof.it
Moderators: perry
  1. forum
  3. Public Forum
  5. Main Forum
  7. Users List order in backend
Time to create page: 0.191 seconds
Powered by Kunena Forum