Joomla! Discussion Forums

Hi!

I am developing a core hack for Joomla 1.5.14.

In which some files will be replaced.
and a table in database will be altered and a new field will be added.

Files are ready!!
MYSQL query is ready!!

Now i dont know what to call it.
Module Plugin or what.

My question is is there a way that i make a package which included this sql query and alter table of core Joomla.

To replace the files i know the hierarchical files should be zipped and uploaded using admin backend.
Now Problem comes how to get that query executed.

I tried using an install.name.php file calling it using name.xml file .

But it does not work.

Please help in this matter so i can contribute to Joomla community.

Regards
Xaurav

and this is the code for
Install.name.php i am using.




Here goes the name.xml code

Be aware that only components can execute sql and php at install time.
Place this in your xml install file:



And then add a file named install.mysql.sql to your package. All sql in that file will be executed when you install your hack component.

Hope it helps...

Hello Thanks for quick reply.

But i get this error

Unable to find install package

Can you tell me , how to setup an xml file to overwrite existing files

also add and sql file to do changes in mysql database .

Regards
Xaurav

You have to setup a extensionname.xml, in the root of the packed zip.

This file should look like this (if you want to run it as a Joomla 1.5 component):

http://docs.joomla.org/Components:xml_installfile

If you need to run a php file (for the table alter, and you will need one for overwriting the core files.. With the xml and file listing and the standard joomla installer you won't be happy). So just use it to start the install.extension.php and do the rest by your own script.

After description:

</description>
<installfile>install.extensionname.php</installfile>
<uninstallfile>uninstall.extensionname.php</uninstallfile>

etc.

And if you replace core files, then please make sure that you backup them (copy to a folder etc.) and restore them with the uninstall php file.

Ah the install php file has to start like this:

defined( '_JEXEC' ) or die ( 'Restricted access' );
function com_install()
{
Your code....

I hope you know what you are doing No offense!

Remember: He first unpacks the zip to tmp then runs your install php, so you copy / alter the files at this time! And you will have to alter the tables in the PHP with a mysql query not within the install.mysql.sql! Except you wanna drop the core tables before

Best regards,

Yves