function d3downloads_onupdate_base( $module , $mydirname )
{
require_once dirname(__FILE__).'/include/common_functions.php';
// transations on module update
global $msgs ; // TODO :-D
// for Cube 2.1
if( defined( 'XOOPS_CUBE_LEGACY' ) ) {
$root =& XCube_Root::getSingleton();
$root->mDelegateManager->add( 'Legacy.Admin.Event.ModuleUpdate.' . ucfirst($mydirname) . '.Success', 'd3downloads_message_append_onupdate' ) ;
$root->mDelegateManager->add( 'Legacy.Admin.Event.ModuleUpdate.' . ucfirst($mydirname) . '.Fail' , 'd3downloads_message_append_onupdate' ) ;
$msgs = array() ;
} else {
if( ! is_array( $msgs ) ) $msgs = array() ;
}
$db =& Database::getInstance() ;
$mid = $module->getVar('mid') ;
// TABLES (write here ALTER TABLE etc. if necessary)
// configs (Though I know it is not a recommended way...)
$check_sql = "SHOW COLUMNS FROM ".$db->prefix("config")." LIKE 'conf_title'" ;
if( ( $result = $db->query( $check_sql ) ) && ( $myrow = $db->fetchArray( $result ) ) && @$myrow['Type'] == 'varchar(30)' ) {
$db->queryF( "ALTER TABLE ".$db->prefix("config")." MODIFY `conf_title` varchar(255) NOT NULL default '', MODIFY `conf_desc` varchar(255) NOT NULL default ''" ) ;
}
// 0.01
$check_sql = "SELECT date FROM ".$db->prefix($mydirname."_downloads_history") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads_history")." ADD date int(10) NOT NULL default '0' AFTER description" ) ;
}
// 0.01 -> 0.02
$check_sql = "SELECT html FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD html tinyint(1) NOT NULL default '0' AFTER description,ADD smiley tinyint(1) NOT NULL default '0' AFTER html,ADD br tinyint(1) NOT NULL default '0' AFTER smiley,ADD xcode tinyint(1) NOT NULL default '0' AFTER br" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD html tinyint(1) NOT NULL default '0' AFTER description,ADD smiley tinyint(1) NOT NULL default '0' AFTER html,ADD br tinyint(1) NOT NULL default '0' AFTER smiley,ADD xcode tinyint(1) NOT NULL default '0' AFTER br" ) ;
}
// 0.01 -> 0.02
$check_sql = "SELECT mail FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD mail varchar(250) NOT NULL default '' AFTER submitter,ADD kanrisya text AFTER comments" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD mail varchar(250) NOT NULL default '' AFTER submitter,ADD kanrisya text AFTER notify" ) ;
}
// 0.02 -> 0.03
$check_sql = "SELECT shotsdir FROM ".$db->prefix($mydirname."_cat") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_cat")." ADD shotsdir varchar(250) NOT NULL default '' AFTER imgurl" ) ;
}
// 0.10 -> 0.20
$check_sql = "SELECT filename FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD filename varchar(50) NOT NULL default '' AFTER url,ADD ext varchar(10) NOT NULL default '' AFTER filename" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD filename varchar(50) NOT NULL default '' AFTER url,ADD ext varchar(10) NOT NULL default '' AFTER filename" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads_history")." ADD filename varchar(50) NOT NULL default '' AFTER url,ADD ext varchar(10) NOT NULL default '' AFTER filename" ) ;
}
// 0.70 -> 0.80
$check_sql = "SELECT upload FROM ".$db->prefix($mydirname."_user_access") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_user_access")." ADD upload tinyint(1) NOT NULL default 0 AFTER html" ) ;
}
// 0.97 -> 1.00
$check_sql = "SELECT expired FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD expired int(10) NOT NULL default '0' AFTER date" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD expired int(10) NOT NULL default '0' AFTER date" ) ;
d3download_update100( $mydirname ) ;
}
// 1.01 -> 1.02
$check_sql = "SELECT description FROM ".$db->prefix($mydirname."_cat") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_cat")." ADD description text AFTER imgurl" ) ;
}
// 1.01 -> 1.02
$check_sql = "SELECT date FROM ".$db->prefix($mydirname."_broken") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_broken")." ADD date int(10) NOT NULL default '0' AFTER ip" ) ;
}
// 1.02 -> 1.03
$check_sql = "SELECT homepagetitle FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD homepagetitle varchar(255) NOT NULL default '' AFTER homepage,ADD license varchar(255) NOT NULL default '' AFTER platform" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD homepagetitle varchar(255) NOT NULL default '' AFTER homepage,ADD license varchar(255) NOT NULL default '' AFTER platform" ) ;
}
// 1.03 -> 1.04
$check_sql = "SELECT filters FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD filters text AFTER xcode" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD filters text AFTER xcode" ) ;
}
// 1.04 -> 1.05
$check_sql = "SELECT file2 FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD file2 varchar(250) NOT NULL default '' AFTER ext,ADD filename2 varchar(50) NOT NULL default '' AFTER file2,ADD ext2 varchar(10) NOT NULL default '' AFTER filename2" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD file2 varchar(250) NOT NULL default '' AFTER ext,ADD filename2 varchar(50) NOT NULL default '' AFTER file2,ADD ext2 varchar(10) NOT NULL default '' AFTER filename2" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads_history")." ADD file2 varchar(250) NOT NULL default '' AFTER ext,ADD filename2 varchar(50) NOT NULL default '' AFTER file2,ADD ext2 varchar(10) NOT NULL default '' AFTER filename2" ) ;
}
// 1.05 -> 1.06
$check_sql = "SELECT version FROM ".$db->prefix($mydirname."_downloads_history") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads_history")." ADD version varchar(10) NOT NULL default '' AFTER ext2,ADD size int(8) NOT NULL default '0' AFTER version" ) ;
}
// 1.06 -> 1.07
$check_sql = "SELECT date FROM ".$db->prefix($mydirname."_cat") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_cat")." ADD date int(10) NOT NULL default '0' AFTER submit_message" ) ;
}
// 1.07 -> 1.08
$check_sql = "SELECT child FROM ".$db->prefix($mydirname."_cat") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_cat")." ADD child text AFTER date,ADD path text AFTER child" ) ;
d3download_historycheck( $mydirname );
}
// 1.08 -> 1.09
$check_sql = "SELECT cids_child FROM ".$db->prefix($mydirname."_cat") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_cat")." ADD cids_child text AFTER path" ) ;
d3download_make_serialize_data( $mydirname ) ;
$db->queryF( "CREATE TABLE ".$db->prefix($mydirname."_mylink")." ( `uid` mediumint(8) default NULL,`cids` text,`date` int(10) NOT NULL default '0',UNIQUE KEY (`uid`), KEY (`date`) ) ENGINE=MyISAM" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD mylink int(11) unsigned NOT NULL default '0' AFTER votes" ) ;
}
// 1.09 -> 1.10
$check_sql = "SELECT extra FROM ".$db->prefix($mydirname."_downloads") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." ADD extra text AFTER filters" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." ADD extra text AFTER filters" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads_history")." ADD extra text AFTER description" ) ;
}
// 1.20 -> 1.30
$check_sql = "SELECT status FROM ".$db->prefix($mydirname."_broken") ;
if( ! $db->query( $check_sql ) ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_broken")." ADD status varchar(100) NOT NULL default '' AFTER ip,ADD message text AFTER status,ADD name varchar(50) NOT NULL default '' AFTER message,ADD email varchar(60) NOT NULL default '' AFTER name" ) ;
}
// 1.44 -> 1.44a
$check_sql = "SHOW COLUMNS FROM ".$db->prefix($mydirname."_downloads")." LIKE 'size'" ;
if( ( $result = $db->query( $check_sql ) ) && ( $myrow = $db->fetchArray( $result ) ) && @$myrow['Type'] == 'int(8)' ) {
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads")." MODIFY `size` int(10) NOT NULL default '0'" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_unapproval")." MODIFY `size` int(10) NOT NULL default '0'" ) ;
$db->queryF( "ALTER TABLE ".$db->prefix($mydirname."_downloads_history")." MODIFY `size` int(10) NOT NULL default '0'" ) ;
}
// configs (Though I know it is not a recommended way...)
$check_sql = "SHOW COLUMNS FROM ".$db->prefix("config")." LIKE 'conf_title'" ;
if( ( $result = $db->query( $check_sql ) ) && ( $myrow = $db->fetchArray( $result ) ) && @$myrow['Type'] == 'varchar(30)' ) {
$db->queryF( "ALTER TABLE ".$db->prefix("config")." MODIFY `conf_title` varchar(255) NOT NULL default '', MODIFY `conf_desc` varchar(255) NOT NULL default ''" ) ;
}
// TEMPLATES (all templates have been already removed by modulesadmin)
$tplfile_handler =& xoops_gethandler( 'tplfile' ) ;
$tpl_path = dirname(__FILE__).'/templates' ;
if( $handler = @opendir( $tpl_path . '/' ) ) {
while( ( $file = readdir( $handler ) ) !== false ) {
if( substr( $file , 0 , 1 ) == '.' ) continue ;
$file_path = $tpl_path . '/' . $file ;
if( is_file( $file_path ) ) {
$mtime = intval( @filemtime( $file_path ) ) ;
$tplfile =& $tplfile_handler->create() ;
$tplfile->setVar( 'tpl_source' , file_get_contents( $file_path ) , true ) ;
$tplfile->setVar( 'tpl_refid' , $mid ) ;
$tplfile->setVar( 'tpl_tplset' , 'default' ) ;
$tplfile->setVar( 'tpl_file' , $mydirname . '_' . $file ) ;
$tplfile->setVar( 'tpl_desc' , '' , true ) ;
$tplfile->setVar( 'tpl_module' , $mydirname ) ;
$tplfile->setVar( 'tpl_lastmodified' , $mtime ) ;
$tplfile->setVar( 'tpl_lastimported' , 0 ) ;
$tplfile->setVar( 'tpl_type' , 'module' ) ;
if( ! $tplfile_handler->insert( $tplfile ) ) {
$msgs[] = '<span style="color:#ff0000;">ERROR: Could not insert template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b> to the database.</span>';
} else {
$tplid = $tplfile->getVar( 'tpl_id' ) ;
$msgs[] = 'Template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b> added to the database. (ID: <b>'.$tplid.'</b>)';
// generate compiled file
include_once XOOPS_ROOT_PATH.'/class/xoopsblock.php' ;
include_once XOOPS_ROOT_PATH.'/class/template.php' ;
if( ! xoops_template_touch( $tplid ) ) {
$msgs[] = '<span style="color:#ff0000;">ERROR: Failed compiling template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b>.</span>';
} else {
$msgs[] = 'Template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b> compiled.</span>';
}
}
}
}
closedir( $handler ) ;
}
include_once XOOPS_ROOT_PATH.'/class/xoopsblock.php' ;
include_once XOOPS_ROOT_PATH.'/class/template.php' ;
xoops_template_clear_module_cache( $mid ) ;
return true ;
}
function d3download_import_from_d3download( $mydirname , $import_mid, $uploads_dir_error )
{
$db =& Database::getInstance() ;
include_once dirname( dirname(__FILE__) ).'/include/mytable.php' ;
if( ! empty( $uploads_dir_error ) ){
redirect_header( XOOPS_URL."/modules/$mydirname/admin/index.php?page=import" , 10 , _MD_D3DOWNLOADS_FILE_CONFIGERROR ) ;
exit ;
} else {
$module_handler = & xoops_gethandler( 'module' ) ;
$from_module =& $module_handler->get( $import_mid ) ;
$from_dirname = $from_module->getVar('dirname') ;
foreach( $GLOBALS['d3download_tables'] as $table_name => $columns ) {
$to_table = $db->prefix( $mydirname.'_'.$table_name ) ;
$from_table = $db->prefix( $from_dirname.'_'.$table_name ) ;
$columns4sql = implode( ',' , $columns ) ;
$db->query( "DELETE FROM `$to_table`" ) ;
$irs = $db->query( "INSERT INTO `$to_table` ( $columns4sql ) SELECT $columns4sql FROM `$from_table`" ) ;
if( ! $irs ) d3download_import_errordie( $mydirname ) ;
}
// upload files delete
d3download_delete_uploadfiles_for_import( $mydirname );
// upload files copy
d3download_copy_uploadfiles_for_import( $mydirname, $from_dirname );
// convert url
d3download_copy_converturl_for_import( $mydirname, $from_dirname );
// make serialize data
include_once dirname( dirname(__FILE__) ).'/include/common_functions.php' ;
d3download_make_serialize_data( $mydirname );
// cache files delete
d3download_delete_cache_of_categories( $mydirname ) ;
}
}
function d3downloads_oninstall_base( $module , $mydirname )
{
// transations on module install
global $ret ; // TODO :-D
// for Cube 2.1
if( defined( 'XOOPS_CUBE_LEGACY' ) ) {
$root =& XCube_Root::getSingleton();
$root->mDelegateManager->add( 'Legacy.Admin.Event.ModuleInstall.' . ucfirst($mydirname) . '.Success' , 'd3downloads_message_append_oninstall' ) ;
$root->mDelegateManager->add( 'Legacy.Admin.Event.ModuleInstall.' . ucfirst($mydirname) . '.Fail' , 'd3downloads_message_append_oninstall' ) ;
$ret = array() ;
} else {
if( ! is_array( $ret ) ) $ret = array() ;
}
$db =& Database::getInstance() ;
$mid = $module->getVar('mid') ;
// TABLES (loading mysql.sql)
$sql_file_path = dirname(__FILE__).'/sql/mysql.sql' ;
$prefix_mod = $db->prefix() . '_' . $mydirname ;
if( file_exists( $sql_file_path ) ) {
$ret[] = "SQL file found at <b>".htmlspecialchars($sql_file_path)."</b>.<br /> Creating tables...";
if( file_exists( XOOPS_ROOT_PATH.'/class/database/oldsqlutility.php' ) ) {
include_once XOOPS_ROOT_PATH.'/class/database/oldsqlutility.php' ;
$sqlutil = new OldSqlUtility ;
} else {
include_once XOOPS_ROOT_PATH.'/class/database/sqlutility.php' ;
$sqlutil = new SqlUtility ;
}
$sql_query = trim( file_get_contents( $sql_file_path ) ) ;
$sqlutil->splitMySqlFile( $pieces , $sql_query ) ;
$created_tables = array() ;
foreach( $pieces as $piece ) {
$prefixed_query = $sqlutil->prefixQuery( $piece , $prefix_mod ) ;
if( ! $prefixed_query ) {
$ret[] = "Invalid SQL <b>".htmlspecialchars($piece)."</b><br />";
return false ;
}
if( ! $db->query( $prefixed_query[0] ) ) {
$ret[] = '<b>'.htmlspecialchars( $db->error() ).'</b><br />' ;
//var_dump( $db->error() ) ;
return false ;
} else {
if( ! in_array( $prefixed_query[4] , $created_tables ) ) {
$ret[] = 'Table <b>'.htmlspecialchars($prefix_mod.'_'.$prefixed_query[4]).'</b> created.<br />';
$created_tables[] = $prefixed_query[4];
} else {
$ret[] = 'Data inserted to table <b>'.htmlspecialchars($prefix_mod.'_'.$prefixed_query[4]).'</b>.</br />';
}
}
}
}
// TEMPLATES
$tplfile_handler =& xoops_gethandler( 'tplfile' ) ;
$tpl_path = dirname(__FILE__).'/templates' ;
if( $handler = @opendir( $tpl_path . '/' ) ) {
while( ( $file = readdir( $handler ) ) !== false ) {
if( substr( $file , 0 , 1 ) == '.' ) continue ;
$file_path = $tpl_path . '/' . $file ;
if( is_file( $file_path ) ) {
$mtime = intval( @filemtime( $file_path ) ) ;
$tplfile =& $tplfile_handler->create() ;
$tplfile->setVar( 'tpl_source' , file_get_contents( $file_path ) , true ) ;
$tplfile->setVar( 'tpl_refid' , $mid ) ;
$tplfile->setVar( 'tpl_tplset' , 'default' ) ;
$tplfile->setVar( 'tpl_file' , $mydirname . '_' . $file ) ;
$tplfile->setVar( 'tpl_desc' , '' , true ) ;
$tplfile->setVar( 'tpl_module' , $mydirname ) ;
$tplfile->setVar( 'tpl_lastmodified' , $mtime ) ;
$tplfile->setVar( 'tpl_lastimported' , 0 ) ;
$tplfile->setVar( 'tpl_type' , 'module' ) ;
if( ! $tplfile_handler->insert( $tplfile ) ) {
$ret[] = '<span style="color:#ff0000;">ERROR: Could not insert template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b> to the database.</span><br />';
} else {
$tplid = $tplfile->getVar( 'tpl_id' ) ;
$ret[] = 'Template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b> added to the database. (ID: <b>'.$tplid.'</b>)<br />';
// generate compiled file
include_once XOOPS_ROOT_PATH.'/class/xoopsblock.php' ;
include_once XOOPS_ROOT_PATH.'/class/template.php' ;
if( ! xoops_template_touch( $tplid ) ) {
$ret[] = '<span style="color:#ff0000;">ERROR: Failed compiling template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b>.</span><br />';
} else {
$ret[] = 'Template <b>'.htmlspecialchars($mydirname.'_'.$file).'</b> compiled.</span><br />';
}
}
}
}
closedir( $handler ) ;
}
include_once XOOPS_ROOT_PATH.'/class/xoopsblock.php' ;
include_once XOOPS_ROOT_PATH.'/class/template.php' ;
xoops_template_clear_module_cache( $mid ) ;
require_once dirname(__FILE__).'/include/common_functions.php';
d3download_make_serialize_data( $mydirname ) ;
d3download_set_default_user_access( $mydirname ) ;
return true ;
}
