One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/var/www/olasjoys/modules/poslogo/sql/

Edit File: install.php

<?php

// Init
$sql = array();

// Create Table in Database
        $sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'pos_logo` (
		  `id_pos_logo` int(10) NOT NULL AUTO_INCREMENT,
		  `title` varchar(250) NOT NULL,
                  `link` varchar(250) NOT NULL DEFAULT "#",
                  `image` longtext NOT NULL,
                  `description` longtext NOT NULL,
                  `porder` int NOT NULL,
  		PRIMARY KEY (`id_pos_logo`)
		) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8';

$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'pos_logo_shop` (
                    `id_pos_logo` int(11) unsigned NOT NULL,
                    `id_shop` int(11) unsigned NOT NULL,
                    PRIMARY KEY (`id_pos_logo`,`id_shop`)
                ) ENGINE = ' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8';

$doc = new DOMDocument();
    $file = _PS_MODULE_DIR_ . '/' . 'poslogo' . '/' . 'sql' . '/' . 'logo.xml';
    $doc->load($file);
    $blocks = $doc->getElementsByTagName("logo");
    foreach ($blocks as $block) {
        $ids = $block->getElementsByTagName("id_pos_logo");
        $id = $ids->item(0)->nodeValue;
        $titles = $block->getElementsByTagName("title");
        $title = $titles->item(0)->nodeValue;
        $links = $block->getElementsByTagName("link");
        $link = $links->item(0)->nodeValue;
        $descriptions = $block->getElementsByTagName("description");
        $description = $descriptions->item(0)->nodeValue;
        $porders = $block->getElementsByTagName("porder");
        $porder = $porders->item(0)->nodeValue;
        //  echo $id.'-'.$title.'-'.$description.'-'.$link.'-'.$porder; echo "<br>";
        $sql[] = "insert into `" . _DB_PREFIX_ . "pos_logo` (`id_pos_logo`, `title`, `link`, `description`, `porder`) 
           values('".$id."','".$title."','".$link."','".$description."','".$porder."');";
    }

$blockshops = $doc->getElementsByTagName("logo_shop");
    foreach ($blockshops as $blockshop) {
        $ids = $blockshop->getElementsByTagName("id_pos_logo");
        $id = $ids->item(0)->nodeValue;
        $id_shops = $blockshop->getElementsByTagName("id_shop");
        $id_shop = $id_shops->item(0)->nodeValue;
        //echo $id.'-'.$id_shop;
        $sql[] = "insert into `" . _DB_PREFIX_ . "pos_logo_shop`(`id_pos_logo`, `id_shop`) 
                VALUES('" . $id . "','" . $id_shop . "')";
    }