Mini Mods - [AJAX] Drop Down Message Display / Selector

File Edits: 0
Template Edits: 2
Difficulty: Easy

Description
This hack adds a drop down menu underneath your navbar.
When someone selects an option it'll load a table with the contents you put in it (without reloading the page).

You can use HTML when you add a new message.

I have added a new hook for the use of replacing text.
I have hardcoded two replacements.

[username] - This will display the username of the user browsing
[userid] - This will display the userid of the user browsing.


F.A.Q.
Q: How can I add my own replacements?
A: Add a new plugin under the hook "ajax_drop_menu_start".
In the Plugin PHP code use this format: $cm['text'] = str_replace("find", "replace", $cm['text']);

Example:

PHP Code:

$cm['text'] = str_replace("[username]", $vbulletin->userinfo['username'], $cm['text']); 


Q: Can I use the hook for other things besides replacing text?
A: Yes. You can use it for almost anything. If you'd like to query the database for the lastest 5 threads and display them in the drop down menu you can.


On the demo you'll see a drop down menu with the text "Select Message".
View The Demo

[dilbert]

Terrific! Thank you.

You mentioned new requests for queries were being accepted.

I have a few addition on my site I'd like to query that last 10 of.

Links
Photos
Reviews
Classifieds
Downloads

What do you kneed to know about these? I can post the table structure for each, but will wait until you ask so as not to make this a huge post.

Many thanks, Cliff

[harmor19]

Originally Posted by dilbert

Terrific! Thank you.

You mentioned new requests for queries were being accepted.

I have a few addition on my site I'd like to query that last 10 of.

Links
Photos
Reviews
Classifieds
Downloads

What do you kneed to know about these? I can post the table structure for each, but will wait until you ask so as not to make this a huge post.

Many thanks, Cliff

I'll need to know the table structure for all of those.

[dilbert]

Originally Posted by harmor19

I'll need to know the table structure for all of those.

See attached.
I'm sure many others people who use this mod will find these queries useful too.

PhotoPost Products
Classifieds
Reviews
Photos

vBadvanced Product
Links

[dilbert]

Hmm, many errors on non standard pages.
For instance, I have Photoposts Classified, Reviews, and Photos. On all of those pages I get page can not be found error. The dropdown shows, but no results. Then if I go to the new posts page http://www.bloodbanktalk.com/forum/search.php?do=getnew the drop down is there, but there are no selections.

Uninstalled for now. Hopefully a new version soon?

[Snake]

Thank you, thank you!

[harmor19]

If you use this hack I'm interested in what queries you use. I would like to update this and add the most commonly used queries so you won't need to use a plugin.

For those who don't know what I'm talking about read the first post.

[DPSR]

Originally Posted by harmor19

Good idea. I'll get it done and add more features to it soon

Anyupdat on this buddy ????? :surprised: :surprised:

[Sofia]

For links in the custom messages, use bbcode [url].

To delete message, now, it's good.

-> hidden queries ok

[JohnBee]

Nice hack, to bad it doesn't work.

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM custom_messages ORDER BY display_order ASC;

MySQL Error  : Table 'pdiscdev.custom_messages' doesn't exist
Error Number : 1146
Date         : Saturday, September 29th 2007 @ 03:51:08 PM
Script       : http://www.mysite.com/forums/index.php
Referrer     : http://www.mysite.com/forums/admincp/index.php?do=head
IP Address   : 62.123.145.252
Username     : JohnBee
Classname    : vB_Database

[ShadowOne]

Sorry if this sounds dumb, but ive read all 3 1/2 pages and still dont understand what this MOD does, or what its used for. Ive looked at the screenies and i dont see what you said is there...