2
everwy, welcome on the XOOPS forum!
If you do not find the required block among the blocks listed for the module in admin blocks manager, then you have to adapt it for your own.
If you look in xoops_version.php, then you see some blocks defined. Copy a block with a similar function and looks and add it in the list with the next consecutive number.
Rename all referred items (constants, files) as xxxx_newprod_xxxxx.
Copy the used constants in the language files and make the same rename and adapt the texts.
Copy the used files and make the same rename and adapt the code. For the query, you can mostly do a select on the autoincrement field (eg prodid) for the product table (see mysql.sql) and specify a
order by prodid desc
clause.