So here we got a very small task. You need to be very familiar with TinyMCE. If you are, you will probably finish it in no time. Please, only make a bid if you know TinyMCE really well.
We got a small online shop. On the back end, employees are able to edit product descriptions in a TinyMCE window. So they can insert sub headings and links and all kinds of fancy stuff.
What we need is an additional button (= TinyMCE plugin) for internal links in the TinyMCE window. The user clicks on it and sees a drop down list of all products and product categories. He or she can select a product or category. Then, an internal link is inserted in the TinyMCE window. Like, <a href="[url removed, login to view];>Our coolest product</a>
Of course, the <a> tag is not visible in the window, because tinymce is wysiwyg.
Second, when a user editing the box clicks on a link, the window appears again. Then, he or she can edit the selection of the drop down list.
(What makes it a little tricky is the fact Tinymce already has some window to edit <a> tags, of course. So we guess the easiest thing is to edit the "link" or the "advlink" module and add the new function in there.)
If the user clicks on a *external* link in the tinymce window, he or she must still be able to edit it as usual.
For this job, you do not need to do database requests. We will supply you some sample data (for the product list and the category list).
Hi, I can create this plugin for you. I will use TinyMCE 3.2.7. I will publish my work on my own web server. So, you can be able to see my plugin in action. -- Sergey aka TakeReal