I've been coding my own Search Module modification for vbCMPS which
allows not only for full customization of the search module from the admincp, but also allows Users to modify which search engines they want to see on the 'portal' page and which they don't. They also have the option to disable it entirely as well.
Anyways, most of it has been really easy to do, however I've hit a 'snag' sort of.
So to understand that, I'll explain a bit:

I would like to make a drop-down list in the UserCP that shows all of the
current Search Engines in the database. The table for the 'search engines' is setup as follows:
Where -
searchengines = title of the search engine
value = html code for the search engine
defaultvalue = totally useless table, will probably remove it later :tongue:
optioncode = yes or no value ('yesno')
displayorder = the order in which the engine is displayed in the list (I probably won't use this either)
sengineid = Unique ID assigned by the database (like the user table is setup)

My first problem is that I don't know how to call up my list (array) of search engines from the database, and display them in a drop-down table WITH the little catch that I want (for instance) another drop-down menu next to it to show wether the selected search engine is enable or disabled.
That's my biggest problem at the moment anyways. Have been digging through various code for a few days now with no luck, so if someone would be so kind as to give me a few tips on that it would be most appreciated :wink:


My second problem is as follows:
What I've done so far, is setup a new column in the user table named 'sengineids', which will list only the id's of the search engines they have selected as 'enabled'. Unfortunately I don't fully understand how to write the code that can utilize that, tho I'm sure it's possible to use it.
So if someone could throw a location at me of where an example of such could be found, that would be awesome :wink:

Many thanks for any help on this matter.. and yes I don't program my own
vbulletin code very often, so forgive me if some of the above sounds a bit stupid, cause no doubt it is :tongue:

__________________

For your second problem there is an easy fix:
Change the table from:
to
Where active is a small INT.

Many thanks Deaths, that works nicely

Also looking into my code further, I think the problem is just that the php code doesn't like being called into an html drop-down menu, since the actual code resides inside of that. So sometime soon I'll get around to putting the drop-down list into the function itself, and then just do away with the html (template) code entirely.
It seems to make sense anyways, heh.

Oh and I found some other problems in my code for the sql query, so that would be another problem :p

For the dropdown, you could use the while(); function.

Inside it you can use
(note the "." before the "=")
And use that to construct your downdown.

Read a little on PHP.net, or download my vBMA hack and look for the dropdown part in stickets.php about the while function.