I have installed Drupal on our internal network and would like to use it to modify fields within our mysql database. I have read and installed CCK but before I dig deeper into this I want to pose this question to see if I'm going in the right direction.
I have a field that I would like to modify in a mysql database on a different server. This field contains HTML that is displayed on a 3rd party application. I simply want to display a wysiwyg editor that loads this fields contents and allows the user to modify and save the field. How can I accomplish this without writing a custom module?
Step 1: user logs into drupal
Step 2: user clicks on a link to modify HTML from the database field
Step 3: Drupal or CCK module selects the field and displays in a wysiwyg
Select value from viewer_text where position = 1
Step 4: user changes the HTML within the wysiwyg and saves
Update value from viewer_text where position = 1
I'm just stepping this out as in how I think this could happen I dont know if this is possible, what modules would I need to install etc...