PDA

View Full Version : how do i run queries?


Pain86
04-28-2005, 06:01 PM
i want to install a few mods that require to run queries....

how do i do this

for example i want to install tha talker bot

Queries To Run:
ALTER TABLE `forum` ADD `mimicbotrop` INT( 5 ) DEFAULT '0' NOT NULL ;

Dean C
04-28-2005, 06:13 PM
Click the link above.

Pain86
04-28-2005, 06:20 PM
seems like alot of work.... in the admin control panal theres an option to run queries but i get this msg "
You are not authorized to execute SQL queries"

?

ericgtr
04-28-2005, 06:31 PM
You have to enable it. Open up your config.php and find this:


// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '';


Add whatever your userid number is to this above i.e. $canrunqueries = '1';

Then you will be able to run queries.

Pain86
04-28-2005, 07:36 PM
thanks ^