Version 3.x.x to 4.0.0

It’s not necessary to upgrade if you’re not having any problems with the previous version

ANDROID STUDIO

A complete reinstallation project is required. See FAQ for more detail.

ADMIN PANEL

This guide is for you who want to migrate from older version (v3.x.x) to latest version (v4.0.0) without losing your previous data, but, to avoid unexpected data loss, we recommend that you backup your data before doing this step, this step is for the admin panel as server side.

Update Database

1. Login to your cpanel hosting, open PhpMyAdmin

2. Select your database and make update by inserting SQL query function on below :

Query 1

CREATE TABLE `tbl_license` (
`id` INT NOT NULL AUTO_INCREMENT,
`purchase_code` VARCHAR(255) NOT NULL,
`item_id` INT NOT NULL,
`item_name` VARCHAR(255) NOT NULL,
`buyer` VARCHAR(255) NOT NULL,
`license_type` VARCHAR(45) NOT NULL,
`purchase_date` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query 2

CREATE TABLE `tbl_ads` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `ad_status` varchar(5) NOT NULL DEFAULT 'on',
  `ad_type` varchar(45) NOT NULL DEFAULT 'admob',
  `admob_publisher_id` varchar(45) NOT NULL DEFAULT '0',
  `admob_app_id` varchar(255) NOT NULL DEFAULT '0',
  `admob_banner_unit_id` varchar(255) NOT NULL DEFAULT '0',
  `admob_interstitial_unit_id` varchar(255) NOT NULL DEFAULT '0',
  `admob_native_unit_id` varchar(255) NOT NULL DEFAULT '0',
  `fan_banner_unit_id` varchar(255) NOT NULL DEFAULT '0',
  `fan_interstitial_unit_id` varchar(255) NOT NULL DEFAULT '0',
  `fan_native_unit_id` varchar(255) NOT NULL DEFAULT '0',
  `startapp_app_id` varchar(45) NOT NULL DEFAULT '0',
  `unity_game_id` varchar(45) NOT NULL DEFAULT '0',
  `unity_banner_placement_id` varchar(45) NOT NULL DEFAULT '0',
  `unity_interstitial_placement_id` varchar(45) NOT NULL DEFAULT '0',
  `interstitial_ad_interval` int(11) NOT NULL DEFAULT '3',
  `native_ad_interval` int(11) NOT NULL DEFAULT '20',
  `native_ad_index` int(11) NOT NULL DEFAULT '4',
  `last_update_ads` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query 3

INSERT INTO `tbl_ads` (
    `id`, 
    `ad_status`, 
    `ad_type`, 
    `admob_publisher_id`, 
    `admob_app_id`, 
    `admob_banner_unit_id`, 
    `admob_interstitial_unit_id`, 
    `admob_native_unit_id`, 
    `fan_banner_unit_id`, 
    `fan_interstitial_unit_id`, 
    `fan_native_unit_id`, 
    `startapp_app_id`, 
    `unity_game_id`, 
    `unity_banner_placement_id`, 
    `unity_interstitial_placement_id`, 
    `interstitial_ad_interval`, 
    `native_ad_interval`, 
    `native_ad_index`, 
    `last_update_ads`
) 
VALUES (1, 
    'on', 
    'admob', 
    'pub-3940256099942544', 
    'ca-app-pub-3940256099942544~3347511713', 
    'ca-app-pub-3940256099942544/6300978111', 
    'ca-app-pub-3940256099942544/1033173712', 
    'ca-app-pub-3940256099942544/2247696110', 
    '243455220090448_245283556574281', 
    '243455220090448_264906991278604', 
    '243455220090448_264953971273906', 
    '200857567', 
    '3930381', 
    'banner', 
    'video', 
    3, 
    20, 
    5, 
    '2020-08-20 14:00:29'
);

Query 4

CREATE TABLE `tbl_ads_status` (
  `ads_status_id` int(11) NOT NULL,
  `banner_ad_on_home_page` int(11) NOT NULL,
  `banner_ad_on_search_page` int(11) NOT NULL,
  `banner_ad_on_wallpaper_detail` int(11) NOT NULL,
  `banner_ad_on_wallpaper_by_category` int(11) NOT NULL,
  `interstitial_ad_on_click_wallpaper` int(11) NOT NULL,
  `interstitial_ad_on_wallpaper_detail` int(11) NOT NULL,
  `native_ad_on_wallpaper_list` int(11) NOT NULL,
  `native_ad_on_exit_dialog` int(11) NOT NULL,
  `last_update_ads_status` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`ads_status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query 5

INSERT INTO `tbl_ads_status` (
    `ads_status_id`, 
    `banner_ad_on_home_page`, 
    `banner_ad_on_search_page`, 
    `banner_ad_on_wallpaper_detail`, 
    `banner_ad_on_wallpaper_by_category`, 
    `interstitial_ad_on_click_wallpaper`, 
    `interstitial_ad_on_wallpaper_detail`, 
    `native_ad_on_wallpaper_list`, 
    `native_ad_on_exit_dialog`, 
    `last_update_ads_status`) 
VALUES (1, 0, 1, 0, 1, 1, 1, 0, 1, '2020-12-21 22:21:32'
);

Query 6

ALTER TABLE `tbl_gallery` 
ADD `image_name` VARCHAR(255) NOT NULL AFTER `tags`, 
ADD `image_resolution` VARCHAR(255) NOT NULL DEFAULT '0' AFTER `image_name`, 
ADD `image_size` VARCHAR(255) NOT NULL DEFAULT '0' AFTER `image_resolution`, 
ADD `image_extension` VARCHAR(45) NOT NULL AFTER `image_size`, 
ADD `last_update` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL 
DEFAULT CURRENT_TIMESTAMP AFTER `image_size`;

Update PHP Script

1. Login to your cpanel hosting, open File Manager

2. Navigate to the directory where you put the php admin panel code

3. Delete All Old PHP Scripts and folder in your admin panel directory EXCEPT : ‘upload’ and ‘includes’ folder

4. Download material_wallpaper_admin_panel_update_v4.zip, upload it into your existing admin panel directory and then extract it (this update code same with admin panel code in the Codecanyon download package except upload and includes folder).

5. After the extract process is complete, refresh it

6. Your Admin Panel is ready to use. (Note : if you use Google Chrome, click “Ctrl + F5” to reload the Admin Panel page).

VIDEO TUTORIAL