Good Day, Xoops.Org and the community at large.

I am a beginner attempting to write a module that will store information in the database.

I ran into some problems.

1.) xoops_version.php edited "$modversion ['sqlfile']['mysql'] = "sql/mysql.sql" included
2.) Install module as normal
3.) Table is generated in database by sql/mysql.sql datadump/script file.
4.) Uninstall module with no error message.

However when I do a SHOW TABLES in mysql, the table that was created in the sql/mysql.sql dump file was not dropped.

I am definately missing something as I am gropping in the dark, the modules how to in the wiki does not actually cover database aspect of module development.

Any help from hereforth is greatly appreciated.

Thanking all in advance, Regards.

I think you have to list your tables in xoops_version.php
That is what the uninstall uses, if memory serves.

You should go through the whole of xoop_version.php (it is all pretty self evident), as that is quite important.

lykoszine, thanks for the prompt reply.

I've inserted the table names into xoops_version.php. Subsequently the tables were dropped.

Since then I ran into trouble getting blocks to be displayed. Is there a tutorial that you could point me to? I rather read on how to develop modules on my own.

Regards

Here is a good post on creating module blocks.
https://xoops.org/modules/newbb/viewtopic.php?topic_id=12716&forum=15#forumpost50968