Problem with too many categories (28000+)

[psico]

I have a problem with my phplinkdirectory, I´ve imported 28000+ categories from DMOZ, and now I can't add a category from the admin area because it takes too much time to read all the categories and shows in the drop down menu. Any ideas on how to resolve this issue?

[David]

I know for certain that people have changed their submit page to only display the category for which they are submitting, and not even use the drop down. Hopefully someone will post this code. For example, I know Casey knows how to do this, though I know he is out of town right now. Hopefully, we can find an answer for you soon.

[psico]

Tnx a lot, I´ll wait.

[David]

Just to move this along, I will note that clearly the answer lies in submit.tpl in this section of code:
Content visible to registered users only.

The two priorities are to "print" the CATEGORY_ID and then probably to use a hidden form field to submit the value. I know the answer would be easy to a Smarty pro. This might even be a great opportunity to post this in one of the Smarty discussion forum on the net, and see if they will help us.

[Tim_Myth]

Change
Content visible to registered users only.
to something like this:
Content visible to registered users only.
That should work, but I have not tested it.

[David]

Ok, thanks...that is one step closer. What that does is display the actual number of the category ID. Now all we need to do is show the name.

[bobby9101]

that works... thank you
is there any way to change it to showing the category title or url instead of id?

[psico]

Not work for me...

Content visible to registered users only.

[David]

For me it showed the category id, but not the name.
I think we will still get a solution, so please be patient, and bump this thread in 48 hours if you still don't get an answer.
Thanks,
David

[psico]

So? Any news?

[David]

Send a PM to Ap0s7le
He is the guy that wrote this mod.
Also, yktan I'm sure would know the answer quickly.

[Ap0s7le]

Hey all, yeah I'm out of town and I have the mod so when I get home I'll post it.

Basically what it does is takes the CatID, recurses through the DB to form the Title URL so it looks nice etc...

What I am planning on doing is have it available for an admin, so once they log in they can surf their directory able to add directly in a Cat so that no dropdowns are needed as well as having Edit / Remove / Delete buttons next to each Link / Cat.

I am away though and should be home in a couple weeks.

If anyone is willing to pay, then I'd go ahead and try to do it from here.

Let me know,

Kind Regards and Best Wishes

-Casey

[psico]

Hi!

Are you back in town now?

Can you help me with this problem?

Tnx in advance!

[Ap0s7le]

No I'm not :(

Our truck is in the shop, I hope to be home soon.

I can go ahead and have a look at it if you wish.

PM me the FTP / CPanel info and I'll see what I can do without following my own instructions haha!!

-Casey

[psico]

Ap0s7le,

Check your PM inbox! ;)

Tnx a lot!

[Ap0s7le]

Checked and responded.

-Casey

[Ap0s7le]

I haven't messed with the Admin yet, but is this to your liking so far?
{url not currently in service}

-Casey

[psico]

Excellent!!!!

You r the MAN! ;)

This is an great solution!

[Ap0s7le]

Sent another PM

-Casey

[psico]

Responded

[stuw]

I got the same issue here, I couldn't find a posted mod for this. Any help anyone?

[edit] sorted it myself thanks. Guess i shouldn't be so lazy :)

[mhamdi]

Hi,
How about someone posts the solution for everybody.

[stuw]

These little jobs are a good way of funding the time spent on this project.

I'm sure one of the project developers with a little free time will do this job for you if you ask nicely and make a donation

[Scorpion]

Ap0s7le,

i sent you a pm couple of days ago. waiting for your response

[Scorpion]

Ap0s7le,

Did you received my pm?

i don't see the pm in my sent folder, when ever i am trying to send pm it is going to outbox.