Query

--------------------------------------------------------------------------------

Hallo Allemaal,

Ik probeer Zoom gallery te instaleren op mijn joomla site.
Dit gaat niet via de administratie omdat de server op savemode draait.

Kijk ik nu in de install.php dan zie ik daar de querys voor de database
bijv. dit stukje

#__zoom dit zal ik dan moeten veranderen in joomla_zoom

//Run the mySQL queries
$tables = $database->getTableList();
echo '<table align="left">';
if(!in_array($mosConfig_dbprefix."zoom", $tables))
{
//Add tables if first time install
$query1 = "DROP TABLE #__zoom";
$query2 = "CREATE TABLE #__zoom ("
. "\n catid int(11) NOT NULL auto_increment,"
. "\n catname varchar(50) default '0',"
. "\n catdescr varchar(255) default NULL,"
. "\n catdir varchar(50) default '0',"
. "\n catimg int(11) default NULL,"
. "\n catpassword varchar(100) NOT NULL default '',"
. "\n catkeywords varchar(240) NOT NULL default '',"
. "\n subcat_id int(11) NOT NULL default '0',"
. "\n pos int(3) NOT NULL default '0',"
. "\n hideMsg tinyint(1) NOT NULL default '0',"
. "\n shared tinyint(1) NOT NULL default '0',"
. "\n published tinyint(1) NOT NULL default '1',"
. "\n uid int(11) NOT NULL default '0',"
. "\n catmembers varchar(240) NOT NULL default '',"
. "\n custom_order varchar(20) default NULL,"
. "\n PRIMARY KEY (catid),"
. "\n KEY catdir_search (catdir),"
. "\n KEY rel_subcats (subcat_id)"
. "\n ) TYPE=MyISAM";
$database->setQuery($query1);
$database->query();
$database->setQuery($query2);
$database->query();
echo '<tr><td style="color:red">#_zoom</td></tr>';
echo '<tr><td>'. _ZOOM_INSTALL_CREATE_DBASE_SUCC . '</td></tr>';
}
else
{

Als ik de query handmatig wil draaien in phpmyadmin welk stukje heb ik dan precies nodig.

Groetjes,
Tim