PHP tchsp_cls_dbquery::tchsp_gallery_details_count 예제들

예제 #1

파일: tiny-carousel-query.php 프로젝트: mishravijay/coiner

 public static function tchsp_image_details_default()
 {
     global $wpdb;
     $prefix = $wpdb->prefix;
     $result = tchsp_cls_dbquery::tchsp_gallery_details_count(0);
     if ($result == 0) {
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_gallery` (`gal_title`, `gal_width`,`gal_height`) \r\r\n\t\t\tVALUES (%s, %d, %d)", array("Default Gallery", 100, 75));
         $wpdb->query($sql);
     }
     $result = tchsp_cls_dbquery::tchsp_image_details_count(0);
     if ($result == 0) {
         $img_title1 = "Tiny Carousel Horizontal Slider Plus Image 1";
         $img_title2 = "Tiny Carousel Horizontal Slider Plus Image 2";
         $img_title3 = "Tiny Carousel Horizontal Slider Plus Image 3";
         $img_title4 = "Tiny Carousel Horizontal Slider Plus Image 4";
         $img_imageurl1 = TCHSP_URL . "images/Sing_1.jpg";
         $img_imageurl2 = TCHSP_URL . "images/Sing_2.jpg";
         $img_imageurl3 = TCHSP_URL . "images/Sing_3.jpg";
         $img_imageurl4 = TCHSP_URL . "images/Sing_4.jpg";
         //$img_imageurl5 = TCHSP_URL . "images/Sing_5.jpg";
         //$img_imageurl6 = TCHSP_URL . "images/Sing_6.jpg";
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title1, $img_imageurl1, "1"));
         $wpdb->query($sql);
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title2, $img_imageurl2, "1"));
         $wpdb->query($sql);
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title3, $img_imageurl3, "1"));
         $wpdb->query($sql);
         $sql = $wpdb->prepare("INSERT INTO `" . $prefix . "tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`) \r\r\n\t\t\tVALUES (%s, %s, %d)", array($img_title4, $img_imageurl4, "1"));
         $wpdb->query($sql);
         //$sql = $wpdb->prepare("INSERT INTO `".$prefix."tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`)
         //VALUES (%s, %s, %d)", array($img_title, $img_imageurl5, "1"));
         //$wpdb->query($sql);
         //$sql = $wpdb->prepare("INSERT INTO `".$prefix."tinycarousel_image` (`img_title`, `img_imageurl`,`img_gal_id`)
         //VALUES (%s, %s, %d)", array($img_title, $img_imageurl6, "1"));
         //$wpdb->query($sql);
     }
     return true;
 }

예제 #2

파일: tiny-carousel-gallery-edit.php 프로젝트: mishravijay/coiner

    die('You are not allowed to call this page directly.');
}
?>

<div class="wrap">
<?php 
$did = isset($_GET['did']) ? $_GET['did'] : '0';
if (!is_numeric($did)) {
    die('<p>Are you sure you want to do this?</p>');
}
$tchsp_errors = array();
$tchsp_success = '';
$tchsp_error_found = FALSE;
// First check if ID exist with requested ID
$result = '0';
$result = tchsp_cls_dbquery::tchsp_gallery_details_count($did);
if ($result != '1') {
    ?>
<div class="error fade"><p><strong><?php 
    _e('Oops, selected details doesnt exist.', TCHSP_TDOMAIN);
    ?>
</strong></p></div><?php 
} else {
    $data = array();
    $data = tchsp_cls_dbquery::tchsp_gallery_details_select($did);
    // Preset the form fields
    $form = array('gal_id' => $data[0]['gal_id'], 'gal_title' => $data[0]['gal_title'], 'gal_width' => $data[0]['gal_width'], 'gal_height' => $data[0]['gal_height'], 'gal_controls' => $data[0]['gal_controls'], 'gal_autointerval' => $data[0]['gal_autointerval'], 'gal_intervaltime' => $data[0]['gal_intervaltime'], 'gal_animation' => $data[0]['gal_animation'], 'gal_random' => $data[0]['gal_random']);
}
// Form submitted, check the data
if (isset($_POST['tchsp_form_submit']) && $_POST['tchsp_form_submit'] == 'yes') {
    //	Just security thingy that wordpress offers us