Ticket #13111: appointy.php

<?php
/*
Plugin Name: Appointy - Appointment Scheduler.
Plugin URI: http://www.appointy.com/wordpress/
Description: This plugin shows your free time slot on your blog and allows you to book appointments with your clients 24x7x365. Very easy Ajax interface. Easy to setup and can be controlled completely from powerful admin area.
Version: 1.5
Author: Appointy, Inc   
Author URI: http://www.appointy.com
*/

//define('WP_DEBUG', true);
//error_reporting( E_ALL );
define('APPOINTYPATH', get_option('siteurl').'/wp-content/plugins/appointy-appointment-scheduler');

$appointy_installed = true;
$appointy_calendar_privileges = 0;
$iFrameVal = "<iframe src=http://demo.appointy.com/?isGadget=1 width=710px height=550px scrolling=auto frameborder=0></iframe>";
        
add_action('init', 'appointy_calendar_init');
add_action('widgets_init', 'widget_init_appointy');
add_filter('the_content','appointy_insert');


function appointy_insert($content)
{
  if (preg_match('{APPOINTY}',$content))
    {
      $content = str_replace('{APPOINTY}',appointy(),$content);
    }
        //echo $content;
  return $content;
}

function appointy()
{
   global  $userdata, $table_prefix, $wpdb, $appointy_installed;
    get_currentuserinfo();
  //  $user_login = $userdata->user_login;
        $str='';
  if( !appointy_calendar_installed() )
                $appointy_installed = appointy_calendar_install();
                //echo "-->" . $appointy_installed;
    
    if( !$appointy_installed )
    {
                echo "PLUGIN NOT CORRECTLY INSTALLED, PLEASE CHECK ALL INSTALL PROCEDURE!";
                return;
        }
            $query = "
                        SELECT code AS code
                        FROM ".$table_prefix."appointy_calendar LIMIT 1
                ";
                //echo $query;
                $code = $wpdb->get_var( $query );
                
        //}
        ?>
        
        <?php
    $str.='<div class="wrap">';
        if( $code === null )
        {
                $str.= '<h4>You don\'t have appointy Calendar, please set code in Settings menu.</h4>';
        }
        else
        {
                
                                
                $str.='<center>';
                
                $str.='<div id="CalendarDiv">';
                ?><?php
                 $str.= $code;
                  ?>
                <?php 
                $str.='</div>';
                 
                 
                $str.='</center>';
         
        }
        ?>
        <?php
    $str.='</div>';
        
        return $str;
        
        
}

function widget_init_appointy() {
  if (!function_exists('register_sidebar_widget'))
        return;
  register_sidebar_widget('Appointy','widget_calendar_appointy');
}

function widget_calendar_appointy() {
        echo "appointy";
        }

function appointy_calendar_init()
{               
        global $appointy_calendar_privileges, $table_prefix, $wpdb, $appointy_path, $appointy_default, $appointy_installed;
        add_action('admin_menu', 'appointy_calendar_config_page');
}

function appointy_calendar_config_page() 
{

        if ( function_exists('add_submenu_page') )
        {
                add_menu_page('appointy Calendar', 'Appointy Calendar', 8, __FILE__, 'appointy_calendar_main_page');
                //add_submenu_page(__FILE__, 'Settings', 'Settings', $appointy_calendar_privileges, 'maintenance', 'appointy_calendar_manage_page');
                //add_submenu_page(__FILE__, 'Admin Settings', 'Admin Settings', 8, 'admin_maitenance', 'appointy_calendar_admin_manage_page');
        }
}

function appointy_calendar_main_page()
{
        global $appointy_default, $userdata, $table_prefix, $wpdb, $appointy_installed, $iFrameVal;
    get_currentuserinfo();
    
    if( !appointy_calendar_installed() )
                $appointy_installed = appointy_calendar_install();
        
    if( !$appointy_installed )
    {
                echo "PLUGIN NOT CORRECTLY INSTALLED, PLEASE CHECK ALL INSTALL PROCEDURE!";
                return;
        }
        ?>
        <div class="wrap">
        <?php
        $valid = true;

        $queryS = "select * from ".$table_prefix."appointy_calendar limit 1";
        $d1 = $wpdb->get_var( $queryS );
        if( $d1 === null )
                {
                        $query ="
                                INSERT INTO ".$table_prefix."appointy_calendar (code)
                                VALUES ('". $iFrameVal ."')
                        ";
                        $wpdb->query( $query );
                }
        else
                {
                        $query = "SELECT code AS code FROM ".$table_prefix."appointy_calendar   LIMIT 1";
                        $iFrameVal = $wpdb->get_var( $query );
                }
        
                
        if( isset($_POST["set"]) AND $_POST["set"] == "Update" )
        {
                        
                if( !appointy_calendar_code( $_POST["code"] ) )
                        $valid = false;
                else
                
                {
                        $query ="Update ".$table_prefix."appointy_calendar set code = '".$_POST["code"]."'";// where calendar_id = " & $d1 ->calendar_id;
                        $wpdb->query( $query );
                        $iFrameVal = str_replace("\\", "", ($_POST["code"]));
                }
        }
        
        if( isset( $_GET["ui"]) and $_GET["ui"] == "true" )
        {
                $query = "
                        DROP TABLE ".$table_prefix."appointy_calendar
                ";
                mysql_query( $query ) or die( mysql_error() );
                
                delete_option( 'appointy_calendar_privileges' ); //Removing option from database...
                
                $installed = appointy_calendar_installed();
                
                if( !$installed ) {
                        echo "PLUGIN UNINSTALLED. NOW DE-ACTIVATE PLUGIN.<br />";
                        echo " <a href=plugins.php>CLICK HERE</a>";
                        return;
                        }
                else
                {
                        echo "PROBLEMS WITH UNINSTALL FUNCTION.";
                }
                        
        }
        ?>

        <div style="margin-bottom:20px;"><h2>Appointy Calendar</h2></div>
        <div>
        <div style="float:left;">
        <img src="<?php echo APPOINTYPATH; ?>/calendar.png" border="0" />
        <br /><br />

        <span style="float:left;width:400px;padding-left:20px;">
        <p><b>Don't have an account on Appointy?</b></p>
        <a href ="http://www.appointy.com/quickUserSignUp.aspx" target="_blank" class="button">&nbsp;&nbsp;Register Now. It's Free &raquo;&nbsp;&nbsp;</a><br />
        <br />
        </span></div>   
        
        <div style="float:left;width:400px;padding-left:20px;" >
    <form action="<?php echo $_SERVER["PHP_SELF"]."?page=".$_GET["page"]; ?>" method="POST">
          <p><b style="color:#000099">STEP &raquo; 1 Enter your Appointy Calendar Code</b><br />
            <span style="font-size:11px;">Don't have appointy username? Click here to register free.</span><br /> 
        <span style="font-size:11px;">Change "demo.appointy.com" to "{yourusername}.appointy.com"<br />
        where {yourusername} is your username on Appointy.com <br />
        </span><br />
        <textarea type ="text" name="code" rows="5" cols="60"><?php echo $iFrameVal ?></textarea>
      </p>
          <p><input type="submit" name="set" value="Update" /></p>
        </form>
        <p><b style="color:#000099">STEP &raquo; 2 Create a new page. </b><br />
          Goto &quot;<strong>Write</strong>&quot; --&gt; &quot;<strong>Write Page</strong>&quot;. Enter a<strong> Title</strong> e.g. &quot;Schedule an appointment&quot; (This would be shown as a link on your page. So make sure you chose the right title) and in <strong>Page Content </strong>write {APPOINTY} (including brackets). See preview. <br /><br />Note: If it overlaps your sidebar then create a new template from your theme without sidebar and use it for Appointy page. <a href=http://blog.appointy.com/tip/solution-appointy-wordpress-plugin-overlays-sidebar target=_blank >Click here</a> to see step by step instructions.</p>
        <p><b style="color:#000099">STEP &raquo; 3 You are done. Now manage Appointments and clients from admin area easily. </b><br />
          You are all done. Now test your blog. Appointy is easy to use and your clients would love scheduling with you. If you want to change your business hours, block days or times, add staff or service, approve appointment etc then click the link below and login to your powerful admin area on Appointy. <br />
          <br />
          <a href =<?php echo get_admin_url(); ?> target="_blank" class="button">&nbsp;&nbsp; Goto Admin Area &raquo;&nbsp;&nbsp;</a>               </p>
        <p><br />
                <p>Uninstall Appointy Plugin: <a href="admin.php?page=appointy-appointment-scheduler\appointy.php&ui=true">UNINSTALL</a></p>
          <br />
          <br />
        
        </p>
        </div>
        </div>
        <div>
        <div style="clear:both"></div>
        
        <?php
}


function appointy_calendar_code( $code )
{
        if( strpos($code, "<iframe") === FALSE )
                return false;
        else
                return true;
}

/*
function get_admin_url()
{
 global $iFrameVal;
 $adminURL = preg_match("/http:\/\/(.*).com/", $iFrameVal, $matches);
 if ($adminURL = true)
 {
 $adminURL = htmlentities($matches['0']);
 $adminURL = $adminURL .'/admin';
 }
 return $adminURL;
}
*/

function appointy_calendar_installed()
{
        global $table_prefix, $wpdb;
        
        $query = "
                SHOW TABLES LIKE '".$table_prefix."appointy_calendar'
        ";
        //echo $query;
        $install = $wpdb->get_var( $query );
        //echo "nemesh-->>" . $install;
        
        if( $install === NULL )
                return false;
        else
                return true;
}

function appointy_calendar_install()
{
        global $table_prefix, $wpdb;
        
        $query = "
                CREATE TABLE ".$table_prefix."appointy_calendar (
                        calendar_id INT(11) NOT NULL auto_increment,
                        code TEXT NOT NULL,
                        PRIMARY KEY( calendar_id )
                )
        ";
        $wpdb->query( $query );

        //Using option for appointy calendar plugin!
        add_option( "appointy_calendar_privileges", "2" );
        
        if( !appointy_calendar_installed() )
                return false;
        else
                return true;
}



?>