Develop new plugin with db - best practice?

[ttrepper]

Hi all,

I want to develop a new plugin with DB-Storage, in detail the plugin should store quotes and display one of them in a random way as a 'quote-of-the-day' in the dashboard (I mean the overview-page).

I think I need to:

• create the plugin-structure
• create the database-layout
• modify the dashboard, or?

The database-structure is simple, because its one table, but how is it created during installation? Is there an upgrade-mechanism, if I will release a plugin-upgrade in future, which I should now keep in mind?

How about modifying the dashbord? Is this the right way or do I have to implement or extend some hooks? Does anybody has a working mini-example *WITH* DB_Access?

Thanks a lot and best regards,

Thomas

[allenlook]

I like your idea, and the ability to post messages to users would also be awesome.

[fernandog]

I know this is a big cheat but I just placed an iframe in the dashboard linking to an internal .html file. I use this to post any content I want to display on the main page across all workspaces (mostly links and notices), and I designed the file to look like OG widgets 

If you figure out a better way, do post !

[allenlook]

I'm assuming you posted your iframe into application\views\dashboard\index.php?

Care to share where?

[fernandog]

Hi,

Yes there exactly.
I created a new folder in application\views\dashboard called "iframe"
Inside that folder I posted the html files
I added  the code bellow to the index.php file, right before the last <script> tag

<IFRAME src="http://localhost/opengoo/application/views/dashboard/iframe/index.html" width="100%" height="500" scrolling="auto" frameborder="0"></IFRAME>

[allenlook]

Good idea

I've integrated the SuperSimple Blog/CMS into a tab of its own and I'll post a write-up shortly.  It requires very little hacking, and allows for comments and RSS feed subscriptions.  Otherwise it's dirt-simple.