Beiträge von togo

            $uidOptions = $doc->getScriptOptions('field_uid');
        
            if(!isset($uidOptions['loaded'])){
                HTMLHelper::_('script', 'plugins/user/golof_preusergroup/fields/assets/javascript/copycontent.js', ['version' => 'auto','bla'=>'foo']);
                HTMLHelper::_('stylesheet', 'plugins/user/golof_preusergroup/fields/assets/css/copycontent.css', ['version' => 'auto']);
                JText::script("PLG_USER_GOLOF_PREUSERGROUP_COPYTOCLIPBORAD_CC_NOVALUE");
                $script = 'jQuery(function($){
                            CopyContent.init("'.JRoute::_('index.php?option=com_users&view=registration&gpuid=').'",null);
                             });';
                
                $doc->addScriptDeclaration($script);
                $doc->addScriptOptions('field_uid',array('loaded'=>'true'));
            }

// info $this->getHelperTableName() gibt #__coppermine_joom_migration_helper zurück

public function prepareMigrationTables(){
        $this->writeLogfile('Create Migration Table '.$this->getHelperTableName());
        $query = "CREATE TABLE IF NOT EXISTS ".$this->db->quoteName($this->getHelperTableName())." (
                    `id` int(11) NOT NULL AUTO_INCREMENT,
                    `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
                    `lft` int(11) NOT NULL DEFAULT '0',
                    `rgt` int(11) NOT NULL DEFAULT '0',
                    `level` int(10) unsigned NOT NULL DEFAULT '0',
                    `title` varchar(255) NOT NULL,
                    `alias` varchar(255) NOT NULL DEFAULT '',
                    `description` varchar(255) NOT NULL DEFAULT '',
                    `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
                    `path` varchar(255) NOT NULL DEFAULT '',
                    PRIMARY KEY (`id`),
                    KEY `idx_left_right` (`lft`,`rgt`)
                    ) DEFAULT CHARSET=utf8;";

       try{
        $this->db->setQuery($query);
       
        $this->db->execute();
       }
       catch (Exception $e){
           echo $e->getMessage();
           return false;
       }

       return true;
    }

Datensatz exemplarisch:
stdClass Object
(
    [description] => alles was nicht vom SCG oder seinen Mitgliedern veranstaltet wird
    [lft] => 3
    [rgt] => 4
    [alias] => 
    [id] => 4
    [parent_id] => 1
    [level] => 1
    [title] => allgemeine Veranstaltungen
    [access] => 1
    [path] => |4
)

Funtion:

 public function storeElementToCategoriesHelperTable($data){
        $table = $this->getTable();

        $this->writeLogfile('Try add ID '.$data->id.' to table '.$this->db->replacePrefix($table->getTableName()));

        echo '<pre>';
        print_r($data);
        echo '</pre>';

        try {
            $table->bind($data);
        }catch (Exception $e) {
            JErrorPage::render($e);
            return false;
        }

        $this->writeLogfile('ID '.$data->id.' successfull bind to table '.$this->db->replacePrefix($table->getTableName()));

        try{
            $table->check();
        }catch (Exception $e) {
            JErrorPage::render($e);
            return false;
        }
        $this->writeLogfile('ID '.$data->id.' successfull checked to table '.$this->db->replacePrefix($table->getTableName()));
        try{
            $table->store();
        }catch (Exception $e) {
            JErrorPage::render($e);
            return false;
        }
        $this->writeLogfile('ID '.$data->id.' successfull store to table '.$this->db->replacePrefix($table->getTableName()));
        return true;
    }

copperminecategories.php
class TableCoppermineCategories extends JTableNested
{
    /** @var int Primary key */
    var $id = 0;

    function __construct(&$db){
        parent::__construct( '#__coppermine_joom_migration_helper', 'id', $db );
    }

}

#Date: 2019-08-09 13:26:41 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime  priority  message
2019-08-09T13:26:55+00:00  INFO  Create Migration Table #__coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  Migration Step started
2019-08-09T13:26:57+00:00  INFO  max. execution time: 30 seconds
2019-08-09T13:26:57+00:00  INFO  calculated refresh time: 20 seconds
2019-08-09T13:26:57+00:00  INFO  *****************************
2019-08-09T13:26:57+00:00  INFO  Start migrate Coppermine Album to Coppermine Category
2019-08-09T13:26:57+00:00  INFO  Copy Entry id (1) from cpg_categories to lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  Try add ID 1 to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  ID 1 successfull bind to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  ID 1 successfull checked to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  ID 1 successfull store to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  Copy Entry id (4) from cpg_categories to lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  Try add ID 4 to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  ID 4 successfull bind to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  ID 4 successfull checked to table lkxqd_coppermine_joom_migration_helper
2019-08-09T13:26:57+00:00  INFO  ID 4 successfull store to table lkxqd_coppermine_joom_migration_helper