MOD: Database Code Generator
Posted: Wed Jun 28, 2006 12:31 amI 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
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
