MOD: Database Code Generator

[SLY LS1]

I had this posted on the old IM site but I dont think its on this site so here it is.

I think this is one of the most handy sites youll ever use when doing mods to your Im site.

For those who dont understand what it does, it creates a db_update.php file for you to upload when you need add or modify your database, often you need to do this when installing a new mod and this will save you heaps of time.

Heres the link
http://www.phpbbhacks.com/forums/db_generator.php

Heres an example

If your doing a mod that asks you to add or make changes to your database and doesnt include the db_update/php file but just gives you the code to add like this

ALTER TABLE `phpbb_users` ADD `karma_plus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `phpbb_users` ADD `karma_minus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `phpbb_users` ADD `karma_time` BIGINT DEFAULT '0' NOT NULL ;

You just copy and paste that code into the "Enter SQL" box and click "Submit" it will then generate you a file to download, once you see the code in the "SQL Output" box click "Download' and save the db_update.php file to your root folder.

Then upload the db_update.php file your server and run it in your browser, if its all sucsessful then delete the db_update.php file from your server and your done.

Makes it all to easy.

Would be good if someone could get their hands on the code for the generator and host the same thing on kismod

Cheers

SLY

[found it]

There is a couple of mods that will do that and I do agree an excellant idea to add to this site for members to use....

Lets hope the admins here pick up this thread...

[SLY LS1]

There is a couple of mods that will do that and I do agree an excellant idea to add to this site for members to use....

Lets hope the admins here pick up this thread...

Well here we go, this is even better just add a db generator to your site, i just installed it and it works perfect. it all runs from the ACP exactly the same as the one in the link.

Heres the download link
http://www.phpbbhacks.com/download.php?id=1581

This mod should definatly be part of the next IM release.

Can 1 of the Moderators please move this thread to the MODs section

Cheers

SLY

[Dragonsys]

There is a couple of mods that will do that and I do agree an excellant idea to add to this site for members to use....

Lets hope the admins here pick up this thread...

Well here we go, this is even better just add a db generator to your site, i just installed it and it works perfect. it all runs from the ACP exactly the same as the one in the link.

Heres the download link
http://www.phpbbhacks.com/download.php?id=1581

This mod should definatly be part of the next IM release.

Can 1 of the Moderators please move this thread to the MODs section

Cheers

SLY

Here is a better link - http://www.phpbbhacks.com/download/1581

This is what I use for creating my db_update files for the MODs I port. It works great, and is super easy to use and install.

[SLY LS1]

Ha ha, beat u to it Dragon <img>

Cheers bud

[Dragonsys]

[quote=""SLY LS1";p="10403""]Ha ha, beat u to it Dragon

[found it]

Moved to the correct forum