Codezwiz >> Forums >> General PHP Nuke Help >> I can't find a categorized module block with an installer

My myAdmin has never been able to import sql files when I need them. I have downloaded the modules block tweak from 3 sources now hoping one of them had an installer with it. They have all had the categories.sql file instead. Does anyone know where to find a block WITH installer. OR, an installer for the module block tweak that is everywhere.

Thx in advance.

Thx bro, but that doesnt have the sql processing yet.

They said the next addition will. I was hoping to run into the guy who wrote the center block script here. He recently wrote an installer in about 30 minutes for me when I couldnt import the sql that came with it. But again thx. Maybe someone will come by who has seen a modules block that can be categorized and comes with an installer.

Save as install.php and upload to your root file run it once and delete it.

<?php
/************************************************************************/
/* CZModules Database install file
/* Installation of the CZModules database tables
/* Written by Telli - [ Register or login to view links on this board. ]
/* Delete after use
/************************************************************************/
include("config.php");
require_once("mainfile.php");
mysql_connect($dbhost, $dbuname, $dbpass);
@mysql_select_db($dbname);
mysql_query("DROP TABLE IF EXISTS ".$prefix."_modules_categories");
mysql_query("CREATE TABLE ".$prefix."_modules_categories (
mcid int(11) NOT NULL auto_increment,
mcname varchar(60) NOT NULL,
visible int(1) NOT NULL default '1',
PRIMARY KEY(mcid),
KEY mcid (mcid),
KEY mcname (mcname)
) TYPE=MyISAM");
mysql_query("INSERT INTO ".$prefix."_modules_categories VALUES (NULL, 'General', '1')");
mysql_query("ALTER TABLE ".$prefix."_modules ADD mcid int(11) NOT NULL default '1'");
include("header.php");
OpenTable();
echo "<center> CZModules database complete, please delete this file off your server, enjoy!</center>";
CloseTable();
include("footer.php");
?>