Allow your visitor to submit new or modify a url...

[gspinney]

"Permission
Allow your visitor to submit new or modify an url inside this category"

Say I forgot the sql query that would allow you to update or change the permissions set on all of the categories from one setting to another.

Anyone know??

Trying to google it, no luck yet.

[dody]

Which permission do you want?
- no need editor approval
- need editor approval
- not allowed

I'll post the query here, to update all categories permission. Before that, let me know which permission you want

[gspinney]

Currently it is set to - no need editor approval for all 350 categories.

I want to change it to - need editor approval

I notice when someone adds a listing, it adds the link, but when you click on that link to go to the detail page is says it is susspeneded. (before they have paid)

Thanks dody.

[dody]

Run this query in admin panel > database > query box:

update idx_category set permission = 1

I notice when someone adds a listing, it adds the link, but when you click on that link to go to the detail page is says it is susspeneded. (before they have paid)

run this query

update idx_link set suspended = 0

[gspinney]

Thank you Sir.

btw, did the changes and it still does it. I submit a listing and it adds the listing automatically, but shows the detail page as "Suspended Resource This link is suspended."

Go ahead and try it yourself. Search "e" from the search bar in the top right after you submit a listing.

I am setting them up as Premium Listings. Also tried it as SPONSORED.

[dody]

Please submit a helpdesk ticket regarding this issue.