banner.php

<?php
/*
Plugin Name: Banner Maker
Plugin URI: http://bannermakerwp.com
Description: Create banners with many different effects 
Author: fruitfulcode
Author URI: http://fruitfulcode.com
*/
global $wpdb;

$currentFile = __FILE__;
$currentFolder = dirname($currentFile);

// base prefix
define('BASE_BANNER', $wpdb->prefix . 'banner_maker');
define('BASE_SETTINGS', $wpdb->prefix . 'banner_settings');

//file folders
define('BANNER_DIR',plugin_basename( __FILE__ ));
define('BANNER_INC',$currentFolder . '/inc');
define('BANNER_SCRIPTS',$currentFolder . '/scripts');
define('BANNER_IMG',plugins_url('/img',__FILE__));

//include  files
require_once BANNER_INC.'/effect.php';
require_once BANNER_INC.'/function.php';
require_once BANNER_INC.'/shortcode.php';
require_once BANNER_INC.'/file.php';
require_once 'init.php';

register_activation_hook(BANNER_DIR,'banner_install');
register_deactivation_hook(BANNER_DIR, 'banner_deactivation');
register_uninstall_hook(BANNER_DIR, 'banner_delete'); 

function banner_install () {
	/*register function*/
	require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); 
    global $wpdb;

    $banner_prefs_table = BASE_BANNER;
    
    if($wpdb->get_var("SHOW TABLES LIKE '$banner_prefs_table'") != $banner_prefs_table) {
        $sql = "CREATE TABLE `" . $banner_prefs_table . "` (
            `id` INT NOT NULL AUTO_INCREMENT,
            `name` VARCHAR(255) NOT NULL default '',
			`height` INT NOT NULL,
			`width` INT NOT NULL,
			`url` VARCHAR(255) NOT NULL default '',
			`click` INT NOT NULL,
			`background` VARCHAR(255) NOT NULL default '',
            UNIQUE KEY id (id)
        )CHARACTER SET=utf8";
        
        dbDelta($sql); 
		
		load_default_banner ();
    }
	
	$banner_prefs_table = BASE_SETTINGS;
	
	if($wpdb->get_var("SHOW TABLES LIKE '$banner_prefs_table'") != $banner_prefs_table) {
        $sql = "CREATE TABLE `" . $banner_prefs_table . "` (
            `id` INT NOT NULL,
            `settings` LONGTEXT NOT NULL default '',
			 UNIQUE KEY id (id)
        )CHARACTER SET=utf8";
        
		dbDelta($sql); 
    }
	
}

function banner_deactivation () {
   /*unregister function*/
}

function banner_delete () {
    /*delete function*/
    global $wpdb;
	
    $banner_prefs_table = BASE_BANNER;
	
    if($wpdb->get_var("SHOW TABLES LIKE '$banner_prefs_table'") == $banner_prefs_table) {
      $sql = "DROP TABLE `" . $banner_prefs_table . "`";
      $wpdb->query($sql);
	}
	unset($sql);
	$banner_prefs_setting_table = BASE_SETTINGS;
	
	if($wpdb->get_var("SHOW TABLES LIKE '$banner_prefs_setting_table'") == $banner_prefs_setting_table) {
      $sql = "DROP TABLE `" . $banner_prefs_setting_table . "`";
      $wpdb->query($sql);
    }
	
}

/*Art - add pages*/
add_action('admin_menu', 'banner_add_pages');

function banner_add_pages() {
    add_menu_page('bannercreator', 'Banners', 8, 'banner', 'banner_page');
}


function banner_page() {

	echo "<div id='head_line'><img id='logo' src='".plugins_url('/img/banner_logo.jpg',__FILE__)."' /><h2>Banner Maker</h2></div>";
	
	$active = getBannerPage();
	
	if($active == "show" or !$active or $active == "delete" or $active == "copy")	{
	    $out .= "<div id='banners_page'><table>";
		$out .= '<thead><tr><td class="grid_B_1">ID</td>
					 <td class="grid_B_2">Name</td>
					 <td class="grid_B_3">Shortcode</td>
					 <td class="grid_B_3">Settings</td>
					 <td class="grid_B_1">Clicks</td>
					 <td class="grid_B_1">Preview</td></tr></thead>';
		$out .= get_my_banners();
		$out .= '</table>';
		$out .= "<a class='add_banner' href='".$_SERVER["PHP_SELF"]."?page=banner&status=create'>add new banner</a></div>";

		echo $out.'<div id="show_preview"></div>';	
	}
}

/*Art - get banners  */
function get_my_banners() {
	global $wpdb;
	$count = 0;
	
	$banner_prefs_table = BASE_BANNER;
	
	$sql = "select * from $banner_prefs_table";
	$check = $wpdb->get_results($sql);
   	
	foreach($check as $line){
		$count++;
		$prefix = ($count%2 == 0) ? 'pink' : '';
		$out .= '<tr class='.$prefix.'>';
		$id = '';
			foreach($line as $key  => $value){
					if($key == "id")		{ 	$out .= '<td>'.$value.'</td>';$id = $value;	}
					if($key == "name")		{ 	$out .= '<td>'.$value.'</td>';				}
					if($key == "click")		{ 	$click = $value;							}
			}
		$out .= '<td>[bannermaker id="'.$id.'"]</td>'; 	
		$out .= '<td><a href="'.$_SERVER["PHP_SELF"].'?page=banner&status=edit&id='.$id.'" class="edit_but">edit</a>';
		$out .= '<a href="'.$_SERVER["PHP_SELF"].'?page=banner&status=copy&id='.$id.'" class="copy_but">copy</a>';
		$out .= '<a href="'.$_SERVER["PHP_SELF"].'?page=banner&status=delete&id='.$id.'" class="delete_but">delete</a></td>';
		$out .= '<td><span class="click">'.$click.'</span></td>'; 	
		$out .= '<td><a class="view_but show_preview" data_id="'.$id.'">viev</a></td>'; 	
		
		$out .= '</tr>';
	}
	if(!$check) { $out = '<tr><td>-</td><td>no banners found</td><td></td><td></td><td></td><td></td></tr>';	}
	
	return $out;
} 
?>