get_results( 'SHOW TABLES FROM '.DB_NAME, ARRAY_A ); // Tablo var mı? if (in_array('ahmeti_wp_timeline',$table_list_array)){ // Tablo var }else{ // SQL Çalıştır $db_sql="CREATE TABLE IF NOT EXISTS `$create_table` ( `event_id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` smallint(6) NOT NULL DEFAULT '0', `timeline_bc` bigint(20) DEFAULT '0', `timeline_date` datetime DEFAULT '0000-00-00 00:00:00', `title` varchar(255) DEFAULT NULL, `event_content` mediumtext, `type` enum('event','group_name') NOT NULL DEFAULT 'event' COMMENT 'grup adları almak için group_name listele, diğerleri event olacaktır.', PRIMARY KEY (`event_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; "; $wpdb->query( $db_sql ); } // Ayar Meta Var mı? if (get_option('AhmetiWpTimelineOptions') == false ){ $options=array( 'DefaultSort' => 'ASC', 'StartState' => 'close', 'PageLimit' => '20', 'DateFormatYear' => 'Y', 'DateFormatYearMonth' => 'm.Y', 'DateFormatYearMonthDay' => 'd.m.Y', 'DateFormatHourMinutesSecond' => 'H:i:s' ); add_option('AhmetiWpTimelineOptions', json_encode($options)); } // Old Meta Delete if (get_option('AhmetiWpTimelinePageLimit') !== false ){ delete_option( 'AhmetiWpTimelinePageLimit' ); } } function Ahmeti_Wp_Timeline_Admin_Head() { /* Wp Admin Head */ load_plugin_textdomain('ahmeti-wp-timeline', FALSE, dirname(plugin_basename(__FILE__)).'/languages/'); wp_enqueue_script('jquery'); /* Datepicker */ if (@$_GET['islem']=='NewEventForm' || @$_GET['islem']=='EditEventForm' || @$_GET['islem']=='EventList'){ wp_enqueue_script('jquery-ui-datepicker'); wp_register_style( 'AhmetiWpTimelineAdminJqueryUi', plugins_url().'/ahmeti-wp-timeline/Admin/Css/smoothness/jquery-ui-1.10.3.custom.min.css',array(),'','screen' ); wp_enqueue_style( 'AhmetiWpTimelineAdminJqueryUi' ); } wp_register_script('AhmetiWpTimelineAdminJs', plugins_url().'/ahmeti-wp-timeline/Admin/Js/AhmetiWpTimelineAdmin.js', array( 'jquery' )); wp_enqueue_script('AhmetiWpTimelineAdminJs'); /* Start Add Js Variables */ $JsData = array('pluginUrl' => plugins_url().'/ahmeti-wp-timeline/' ,'pluginAdminUrl' => AHMETI_WP_TIMELINE_ADMIN_URL); wp_localize_script('AhmetiWpTimelineAdminJs', 'AhmetiWpTimelineJsData', $JsData); /* End Add Js Variables */ wp_register_style( 'AhmetiWpTimelineAdminCss', plugins_url().'/ahmeti-wp-timeline/Admin/Css/AhmetiWpTimelineAdmin.css',array(),'','screen' ); wp_enqueue_style( 'AhmetiWpTimelineAdminCss' ); } function Ahmeti_Wp_Timeline_Head() { /* Get Short Code Parameters */ $dat = array(); preg_match("/\[ahmetiwptimeline (.+?)\]/", get_post_field('post_content', get_the_ID()), $dat); if ( empty($dat)){ return false; } $dat = array_pop($dat); $dat= explode(" ", $dat); $params = array(); foreach ($dat as $d){ list($opt, $val) = explode("=", $d); $params[$opt] = trim($val, '"'); } /* End Short Code Parameters */ /* Wp User Head */ load_plugin_textdomain('ahmeti-wp-timeline', FALSE, dirname(plugin_basename(__FILE__)).'/languages/'); /* JS */ wp_enqueue_script('jquery'); wp_register_script('timelinerColorboxJs', plugins_url().'/ahmeti-wp-timeline/TimelinerJquery/inc/colorbox.js', array( 'timelinerTimelinerJs' )); wp_enqueue_script('timelinerColorboxJs'); wp_register_script( 'timelinerTimelinerJs', plugins_url().'/ahmeti-wp-timeline/TimelinerJquery/js/timeliner.min.js', array( 'jquery' )); $translation_array = array( 'ExpandAll' => __('+ Expand All','ahmeti-wp-timeline'), 'CollapseAll' => __('- Collapse All','ahmeti-wp-timeline'), 'State'=> $params['state']); wp_localize_script( 'timelinerTimelinerJs', 'timelinerTimelinerJsObject', $translation_array ); wp_enqueue_script('timelinerTimelinerJs'); /* CSS */ wp_register_style( 'timelinerColorboxCss', plugins_url().'/ahmeti-wp-timeline/TimelinerJquery/inc/colorbox.css',array(),'','screen' ); wp_enqueue_style( 'timelinerColorboxCss' ); wp_register_style( 'timelinerScreenCss', plugins_url().'/ahmeti-wp-timeline/TimelinerJquery/css/screen.css',array(),'','screen' ); wp_enqueue_style( 'timelinerScreenCss' ); } function Ahmeti_Wp_Timeline_Admin() { /* Admin Menü */ add_action('admin_enqueue_scripts', 'Ahmeti_Wp_Timeline_Admin_Head'); add_menu_page( 'Ahmeti Wp Timeline', 'Timeline', 'edit_pages', 'ahmeti-wp-timeline/index.php', 'Ahmeti_Wp_Timeline_Index', plugins_url('ahmeti-wp-timeline/images/ahmeti-wp-timeline-icon.png') , '6.9'); //load_plugin_textdomain('ahmeti-wp-timeline', FALSE, dirname(plugin_basename(__FILE__)).'/languages/'); } function AhmetiWpTimelineDateTitle($mysqlDateTime,$options) { $explTime=explode(' ',$mysqlDateTime); // $explTime[0] // 2012-12-12 // $explTime[1] // 00:00:00 $explDate=explode('-',$explTime[0]); // $explDate[0] // Year // $explDate[1] // Month // $explDate[2] // Day if ($explDate[2] > 0 && $explTime[1] != '00:00:00'){ // D-M-Y And H:i:s if ( empty($options->DateFormatYearMonthDay) || empty($options->DateFormatHourMinutesSecond)){ return $mysqlDateTime; }else{ return date( $options->DateFormatYearMonthDay." ".$options->DateFormatHourMinutesSecond, strtotime($mysqlDateTime)); } }elseif( $explDate[2] > 0){ // D-M-Y if ( empty($options->DateFormatYearMonthDay) ){ return $explTime[0]; }else{ return date( $options->DateFormatYearMonthDay, strtotime($explDate[0].'-'.$explDate[1].'-'.$explDate[2])); } }elseif($explDate[1] > 0 ){ // M-Y if ( empty($options->DateFormatYearMonth) ){ return $explDate[0].'-'.$explDate[1]; }else{ return date( $options->DateFormatYearMonth, strtotime($explDate[0].'-'.$explDate[1])); } }else{ // Y if ( empty($options->DateFormatYear) ){ return $explDate[0]; }else{ return date( $options->DateFormatYear, strtotime(($explDate[0]+1).'-00')); } } } function AhmetiWpTimelineGetYear($mysqlDateTime){ $explDate=explode('-',$mysqlDateTime,2); return $explDate[0]; } function AhmetiWpTimelineShortCodeOutput( $atts ) { global $wpdb; /* * Aynı yıl içinde varsa bir kaç tane olay varsa yılın içine ekle... * */ //echo _e('Hepsini_Ac','ahmeti-wp-timeline'); /* OPTIONS*/ $ahmetiWpTimelineOpt=json_decode(get_option('AhmetiWpTimelineOptions')); /* SHORTCODE */ $group_id=$atts['groupid']; $sort=@$atts['sort']; $state=@$atts['state']; if (empty($sort)){ $sort=$ahmetiWpTimelineOpt->DefaultSort; if ( empty($sort)){ $sort='DESC'; } } if (empty($state)){ $state=$ahmetiWpTimelineOpt->StartState; if ( empty($state)){ $state='close'; } } $AhmetiWpTimelineEndSqlYear=''; $AhmetiWpTimelineOut='