File: /home/jairicem/alfijiri.com/app/controllers/admin/Reset.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Reset extends CI_Controller
{
public function __construct()
{
parent::__construct();
}
public function demo()
{
if (DEMO) {
$this->db->truncate('adjustments');
$this->db->truncate('adjustment_items');
$this->db->truncate('calendar');
$this->db->truncate('captcha');
$this->db->truncate('categories');
$this->db->truncate('combo_items');
$this->db->truncate('companies');
$this->db->truncate('costing');
$this->db->truncate('currencies');
$this->db->truncate('customer_groups');
$this->db->truncate('deliveries');
$this->db->truncate('deposits');
$this->db->truncate('expenses');
$this->db->truncate('gift_cards');
$this->db->truncate('groups');
$this->db->truncate('login_attempts');
$this->db->truncate('notifications');
$this->db->truncate('order_ref');
$this->db->truncate('payments');
$this->db->truncate('paypal');
$this->db->truncate('permissions');
$this->db->truncate('pos_register');
$this->db->truncate('pos_settings');
$this->db->truncate('products');
$this->db->truncate('product_photos');
$this->db->truncate('product_variants');
$this->db->truncate('promos');
$this->db->truncate('purchases');
$this->db->truncate('purchase_items');
$this->db->truncate('quotes');
$this->db->truncate('quote_items');
$this->db->truncate('sales');
$this->db->truncate('sale_items');
// $this->db->truncate('sessions');
$this->db->truncate('settings');
$this->db->truncate('skrill');
$this->db->truncate('suspended_bills');
$this->db->truncate('suspended_items');
$this->db->truncate('tax_rates');
$this->db->truncate('transfers');
$this->db->truncate('transfer_items');
$this->db->truncate('users');
$this->db->truncate('user_logins');
$this->db->truncate('variants');
$this->db->truncate('warehouses');
$this->db->truncate('warehouses_products');
$this->db->truncate('warehouses_products_variants');
$this->db->truncate('expense_categories');
$this->db->truncate('gift_card_topups');
$this->db->truncate('addresses');
$this->db->truncate('brands');
$this->db->truncate('price_groups');
$this->db->truncate('product_prices');
$this->db->truncate('units');
$this->db->truncate('stock_counts');
$this->db->truncate('stock_count_items');
$this->db->truncate('printers');
$this->db->truncate('pages');
$this->db->truncate('shop_settings');
$this->db->truncate('api_keys');
$this->db->truncate('api_limits');
$this->db->truncate('api_logs');
$this->db->delete('sessions', ['timestamp <' => time() - 60 * 60 * 48]);
$file = file_get_contents('./files/demo.sql');
mysqli_multi_query($this->db->conn_id, $file);
// $this->db->conn_id->multi_query($file);
$this->db->conn_id->close();
// $this->load->dbutil();
// $this->dbutil->optimize_database();
admin_redirect('login');
} else {
echo '<!DOCTYPE html>
<html>
<head>
<title>Stock Manager Advance</title>
<link href="https://fonts.googleapis.com/css?family=Lato:100" rel="stylesheet" type="text/css">
<style>
html, body { height: 100%; }
body { margin: 0; padding: 0; width: 100%; display: table; font-weight: 72; font-family: \'Lato\'; }
.container { text-align: center; display: table-cell; vertical-align: middle; }
.content { text-align: center; display: inline-block; }
.title { font-size: 72px; }
</style>
</head>
<body>
<div class="container">
<div class="content">
<div class="title">Demo is disabled!</div>
</div>
</div>
</body>
</html>
';
}
}
public function index()
{
show_404();
}
}