Friday, December 17, 2010

List tables used by stored procedures in mysql

List tables used inside the stored procedures in MySQL


SELECT IT.TABLE_NAME

FROM INFORMATION_SCHEMA.ROUTINES IR

JOIN INFORMATION_SCHEMA.TABLES IT ON

IR.ROUTINE_DEFINITION LIKE BINARY CONCAT("%", IT.TABLE_NAME, "%")

WHERE TABLE_SCHEMA = 'DATABASE_NAME' AND IR.ROUTINE_NAME IN

('PROCEDURE_NAME1', 'PROCEDURE_NAME2')

GROUP BY IT.TABLE_NAME;

Add fields to joomla registration form

Here you can find " How to add fields to joomla registration form "

Adding fields to joomla registration form is very simply. Follow the below steps.
Here steps to joomla registration form add fields:

Step 1:

Explore joomla database in phpMyadmin or in any GUI tool for the RDBMS MySQL
go to table jos_users and add your column in an appropriate place.

Step 2:

go to "libraries -> joomla -> user" from the root directory of joomla

open user.php and find existing variables of jos_users table like $id, $name, $email etc.

and insert the fields that you want to add in an appropriate place between the variables.

and Below find a check() function, add the validation for you filed under that function, if needed.

Step 3:

Now go to
"components -> com_user -> views -> register -> tmpl" from the root directory of joomla

open default.php and add your HTML element like textbox or dropdown whatever under the table.

Now it's done.