whitepapers

kte.or.kr

리퍼런스, 워드프레스By 관리자 2017년 4월 19일

테마 : Enfold 하나보드 한글파일 업로드 허용

/* User Add Uploads */
define('ALLOW_UNFILTERED_UPLOADS', true );

1 2	/* User Add Uploads */ define('ALLOW_UNFILTERED_UPLOADS', true );

function add_custom_mime_types($mimes){
	return array_merge($mimes,array (
		'hwp' => 'application/hangul'
	));
}
add_filter('upload_mimes','add_custom_mime_types');

function add_custom_mime_types($mimes){

return array_merge($mimes,array (

'hwp' => 'application/hangul'

));

}

add_filter('upload_mimes','add_custom_mime_types');

첨부파일 링크 수정 다운로드 후 페이지 리도드 멈춤현상 : 55번 라인 _blank 추가

<li>
    <a href="<?php echo $file->url;?>" target="_blank" title="<?php echo esc_attr( $file->title );?>">
        <span class="attachment-filename">
            <?php echo $file->title; ?>
        </span>
        <span class="attachment-filesize">
            <?php echo ( empty($file->filesize) ? "" : "(".$file->filesize.")" ) ?>
        </span>
     </a>
</li>

<li>

<a href="<?php echo $file->url;?>" target="_blank" title="<?php echo esc_attr( $file->title );?>">

<?php echo $file->title; ?>

</span>

<?php echo ( empty($file->filesize) ? "" : "(".$file->filesize.")" ) ?>

</span>

</a>

</li>

상세(보기)

지엘디지털

리퍼런스, 워드프레스By 관리자 2017년 3월 30일

the7 테마 수정사항 /wp-content/themes/brooklyn/partials/blog/content.php 87번라인 주석처리 싱글컨텐츠 출력시 피처이미지 숨김

<?php if ( is_single() ) : ?>
    <!--<div class="entry-thumbnail">        
        <img alt="<?php echo $caption; ?>" class="wp-post-image" src="<?php echo $thumbnail; ?>">
    </div>//-->
<?php else : ?>

<?php if ( is_single() ) : ?>

<!--<div class="entry-thumbnail">

<img alt="<?php echo $caption; ?>" class="wp-post-image" src="<?php echo $thumbnail; ?>">

</div>//-->

<?php else : ?>

상세(보기)

오키나와에세이

리퍼런스, 워드프레스By 관리자 2016년 9월 21일 Leave a comment

전환율 스크립트실행 do_action
테마 function 추가
/wp-content/plugins/dopbsp/includes/reservations/class-frontend-reservations.php 85라인

상세(보기)

csr.co.kr

리퍼런스, 워드프레스By 관리자 2016년 9월 21일 Leave a comment

네비게이션 리디렉트 \wp-content\themes\dt-the7\inc\helpers\post_navigation.php 247
아카이브 칼럼4개 강제 \wp-content\themes\dt-the7\inc\helpers\masonry-template.php 39 45
이미지 라이트박스 팝업 방지 \wp-content\themes\dt-the7\inc\mods\portfolio\public\mod-portfolio-helpers.php 337 외

상세(보기)

crontab 활용

Linux, Linux Command, Linux ConfigBy 관리자 2016년 9월 21일 Leave a comment

매일 00시 00분에 명령어 실행.. 관리자에 메일보내기 안하기 > /dev/null 2>&1 추가

02 3 * * * root /usr/bin/rdate -s time.bora.net | clock -w > /dev/null 2>&1
05 4 * * * root /root/bin/su_backup > /dev/null 2>&1

1 2	02 3 * * * root /usr/bin/rdate -s time.bora.net \| clock -w > /dev/null 2>&1 05 4 * * * root /root/bin/su_backup > /dev/null 2>&1

상세(보기)

짐브라 자체 테스트 인증서갱신

zimbraBy 관리자 2016년 9월 21일 Leave a comment

짐브라 인증서는 기본으로 1년간 유효하다. 1년 후 인증서 갱신 작업이 필요하고

상세(보기)

MySQL over 8G Ram

MySQLBy 관리자 2016년 9월 21일 Leave a comment

8기가 램에 설정파일 스크랩 합니다. MySQL config 5.0.x, 5.1.x, 5.5.x Connections : 1000

[mysqld_safe]
nice 				= -15

[client]
socket 				= /var/lib/mysql/mysql.sock
default-character-set 		= utf8

[mysqld]
## Charset and Collation
character-set-server 		= utf8
collation-server 		= utf8_general_ci

## Files
back_log 			= 300
open-files-limit 		= 8192
open-files 			= 1024	
port 				= 3306
socket 				= /var/lib/mysql/mysql.sock
pid-file 			= /var/lib/mysql/mysql.pid
skip-external-locking
skip-name-resolve

## Logging
datadir				= /var/lib/mysql
relay_log			= mysql-relay-bin
relay_log_index			= mysql-relay-index
#log				= mysql-gen.log	
log_error			= mysql-error.err
log_warnings
log_bin				= mysql-bin
log_slow_queries		= mysql-slow.log
#log_queries_not_using_indexes
long_query_time 		= 10	#default: 10
max_binlog_size 		= 256M	#max size for binlog before rolling
expire_logs_days 		= 4	#binlog files older than this will be purged

## Per-Thread Buffers * (max_connections) = total per-thread mem usage
thread_stack 			= 256K	  #default: 32bit: 192K, 64bit: 256K
sort_buffer_size 		= 512K	  #default: 2M, larger may cause perf issues
read_buffer_size 		= 512K	  #default: 128K, change in increments of 4K
read_rnd_buffer_size 		= 512K	  #default: 256K				
join_buffer_size 		= 512K	  #default: 128K
binlog_cache_size 		= 64K	  #default: 32K, size of buffer to hold TX queries
## total per-thread buffer memory usage: 4736000K = 4.625GB

## Query Cache
query_cache_size 		= 32M	#global buffer
query_cache_limit 		= 512K	#max query result size to put in cache

## Connections
max_connections 		= 2000	#multiplier for memory usage via per-thread buffers
max_connect_errors 		= 100	#default: 10
concurrent_insert		= 2	#default: 1, 2: enable insert for all instances
connect_timeout			= 30	#default -5.1.22: 5, +5.1.22: 10
max_allowed_packet 		= 32M	#max size of incoming data to allow

## Default Table Settings
sql_mode 			= NO_AUTO_CREATE_USER

## Table and TMP settings
max_heap_table_size 		= 1G	#recommend same size as tmp_table_size
bulk_insert_buffer_size 	= 1G	#recommend same size as tmp_table_size
tmp_table_size                  = 1G    #recommend 1G min
#tmpdir                         = /data/mysql-tmp0:/data/mysql-tmp1 #Recommend using RAMDISK for tmpdir

## Table cache settings
#table_cache 			= 512	#5.0.x
#table_open_cache		= 512	#5.1.x, 5.5.x

## Thread settings
thread_concurrency		= 16  #recommend 2x CPU cores
thread_cache_size		= 100 #recommend 5% of max_connections

## Replication
#read_only
#skip-slave-start		
#slave-skip-errors		= <default: none, recommend:1062>
#slave-net-timeout		= <default: 3600>
#slave-load-tmpdir		= <location of slave tmpdir>
#slave_transaction_retries	= <default: 10>
#server-id                      =
#replicate-same-server-id       =  
#auto-increment-increment       =
#auto-increment-offset          =
#master-connect-retry           =
#log-slave-updates		= <default: 0 disable>
#report-host			= <master_server_ip>
#report-user			= <replication_user>
#report-password                =
#report-port			= <default: 3306>
#replicate-do-db            	=
#replicate-ignore-db		=
#replicate-do-table		= 
#relicate-ignore-table		=
#replicate-rewrite-db		=
#replicate-wild-do-table	=
#replicate-wild-ignore-table	=

## Replication Semi-Synchronous 5.5.x only, requires dynamic plugin loading ability 
#rpl_semi_sync_master_enabled	= 1 #enable = 1, disable = 0
#rpl_semi_sync_master_timeout	= 1000 #in milliseconds , master only setting

## 5.1.x and 5.5.x replication related setting. 
#binlog_format			= MIXED

## MyISAM Engine
key_buffer			= 512K	#global buffer
myisam_sort_buffer_size		= 128M	#index buffer size for creating/altering indexes
myisam_max_sort_file_size	= 256M	#max file size for tmp table when creating/alering indexes
myisam_repair_threads		= 4	#thread quantity when running repairs
myisam_recover			= BACKUP	#repair mode, recommend BACKUP 

## InnoDB Plugin Dependent Settings
#ignore-builtin-innodb
#plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so

## InnoDB IO Capacity - 5.1.x plugin, 5.5.x
#innodb_io_capacity		= 200

## InnoDB IO settings -  5.1.x only
#innodb_file_io_threads		= 16

## InnoDB IO settings -  5.5.x and greater
#innodb_write_io_threads 	= 16
#innodb_read_io_threads		= 16

## InnoDB Plugin Independent Settings
innodb_data_home_dir            = /var/lib/mysql
innodb_data_file_path		= ibdata1:128M;ibdata2:10M:autoextend
innodb_log_file_size		= 256M	#64G_RAM+ = 768, 24G_RAM+ = 512, 8G_RAM+ = 256, 2G_RAM+ = 128 
innodb_log_files_in_group	= 4	#combined size of all logs <4GB. <2G_RAM = 2, >2G_RAM = 4
innodb_buffer_pool_size		= 4G 	#global buffer
innodb_additional_mem_pool_size	= 4M	#global buffer
innodb_status_file		  	#extra reporting
innodb_file_per_table			#enable always
innodb_flush_log_at_trx_commit	= 2	#2/0 = perf, 1 = ACID
innodb_table_locks		= 0	#preserve table locks
innodb_log_buffer_size 		= 128M 	#global buffer
innodb_lock_wait_timeout 	= 60	
innodb_thread_concurrency	= 16	#recommend 2x core quantity
innodb_commit_concurrency	= 16	#recommend 4x num disks
#innodb_flush_method		= O_DIRECT	   #O_DIRECT = local/DAS, O_DSYNC = SAN/iSCSI
innodb_support_xa		= 0		   #recommend 0, disable xa to negate extra disk flush
skip-innodb-doublewrite

## Binlog sync settings
## XA transactions = 1, otherwise set to 0 for best performance
sync_binlog			= 0

## TX Isolation
transaction-isolation		= REPEATABLE-READ #REPEATABLE-READ req for ACID, SERIALIZABLE req XA

## Per-Thread Buffer memory utilization equation:
#(read_buffer_size + read_rnd_buffer_size + sort_buffer_size + thread_stack + join_buffer_size + binlog_cache_size) * max_connections

## Global Buffer memory utilization equation:
# innodb_buffer_pool_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + key_buffer_size + query_cache_size

[mysqldump]
quick
quote-names
max_allowed_packet 		= 128M

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

[mysqld_safe]

nice = -15

[client]

socket = /var/lib/mysql/mysql.sock

default-character-set = utf8

[mysqld]

## Charset and Collation

character-set-server = utf8

collation-server = utf8_general_ci

## Files

back_log = 300

open-files-limit = 8192

open-files = 1024

port = 3306

socket = /var/lib/mysql/mysql.sock

pid-file = /var/lib/mysql/mysql.pid

skip-external-locking

skip-name-resolve

## Logging

datadir = /var/lib/mysql

relay_log = mysql-relay-bin

relay_log_index = mysql-relay-index

#log = mysql-gen.log

log_error = mysql-error.err

log_warnings

log_bin = mysql-bin

log_slow_queries = mysql-slow.log

#log_queries_not_using_indexes

long_query_time = 10 #default: 10

max_binlog_size = 256M #max size for binlog before rolling

expire_logs_days = 4 #binlog files older than this will be purged

## Per-Thread Buffers * (max_connections) = total per-thread mem usage

thread_stack = 256K #default: 32bit: 192K, 64bit: 256K

sort_buffer_size = 512K #default: 2M, larger may cause perf issues

read_buffer_size = 512K #default: 128K, change in increments of 4K

read_rnd_buffer_size = 512K #default: 256K

join_buffer_size = 512K #default: 128K

binlog_cache_size = 64K #default: 32K, size of buffer to hold TX queries

## total per-thread buffer memory usage: 4736000K = 4.625GB

## Query Cache

query_cache_size = 32M #global buffer

query_cache_limit = 512K #max query result size to put in cache

## Connections

max_connections = 2000 #multiplier for memory usage via per-thread buffers

max_connect_errors = 100 #default: 10

concurrent_insert = 2 #default: 1, 2: enable insert for all instances

connect_timeout = 30 #default -5.1.22: 5, +5.1.22: 10

max_allowed_packet = 32M #max size of incoming data to allow

## Default Table Settings

sql_mode = NO_AUTO_CREATE_USER

## Table and TMP settings

max_heap_table_size = 1G #recommend same size as tmp_table_size

bulk_insert_buffer_size = 1G #recommend same size as tmp_table_size

tmp_table_size = 1G #recommend 1G min

#tmpdir = /data/mysql-tmp0:/data/mysql-tmp1 #Recommend using RAMDISK for tmpdir

## Table cache settings

#table_cache = 512 #5.0.x

#table_open_cache = 512 #5.1.x, 5.5.x

## Thread settings

thread_concurrency = 16 #recommend 2x CPU cores

thread_cache_size = 100 #recommend 5% of max_connections

## Replication

#read_only

#skip-slave-start

#slave-skip-errors = <default: none, recommend:1062>

#slave-net-timeout = <default: 3600>

#slave-load-tmpdir = <location of slave tmpdir>

#slave_transaction_retries = <default: 10>

#server-id =

#replicate-same-server-id =

#auto-increment-increment =

#auto-increment-offset =

#master-connect-retry =

#log-slave-updates = <default: 0 disable>

#report-host = <master_server_ip>

#report-user = <replication_user>

#report-password =

#report-port = <default: 3306>

#replicate-do-db =

#replicate-ignore-db =

#replicate-do-table =

#relicate-ignore-table =

#replicate-rewrite-db =

#replicate-wild-do-table =

#replicate-wild-ignore-table =

## Replication Semi-Synchronous 5.5.x only, requires dynamic plugin loading ability

#rpl_semi_sync_master_enabled = 1 #enable = 1, disable = 0

#rpl_semi_sync_master_timeout = 1000 #in milliseconds , master only setting

## 5.1.x and 5.5.x replication related setting.

#binlog_format = MIXED

## MyISAM Engine

key_buffer = 512K #global buffer

myisam_sort_buffer_size = 128M #index buffer size for creating/altering indexes

myisam_max_sort_file_size = 256M #max file size for tmp table when creating/alering indexes

myisam_repair_threads = 4 #thread quantity when running repairs

myisam_recover = BACKUP #repair mode, recommend BACKUP

## InnoDB Plugin Dependent Settings

#ignore-builtin-innodb

#plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so

## InnoDB IO Capacity - 5.1.x plugin, 5.5.x

#innodb_io_capacity = 200

## InnoDB IO settings - 5.1.x only

#innodb_file_io_threads = 16

## InnoDB IO settings - 5.5.x and greater

#innodb_write_io_threads = 16

#innodb_read_io_threads = 16

## InnoDB Plugin Independent Settings

innodb_data_home_dir = /var/lib/mysql

innodb_data_file_path = ibdata1:128M;ibdata2:10M:autoextend

innodb_log_file_size = 256M #64G_RAM+ = 768, 24G_RAM+ = 512, 8G_RAM+ = 256, 2G_RAM+ = 128

innodb_log_files_in_group = 4 #combined size of all logs <4GB. <2G_RAM = 2, >2G_RAM = 4

innodb_buffer_pool_size = 4G #global buffer

innodb_additional_mem_pool_size = 4M #global buffer

innodb_status_file #extra reporting

innodb_file_per_table #enable always

innodb_flush_log_at_trx_commit = 2 #2/0 = perf, 1 = ACID

innodb_table_locks = 0 #preserve table locks

innodb_log_buffer_size = 128M #global buffer

innodb_lock_wait_timeout = 60

innodb_thread_concurrency = 16 #recommend 2x core quantity

innodb_commit_concurrency = 16 #recommend 4x num disks

#innodb_flush_method = O_DIRECT #O_DIRECT = local/DAS, O_DSYNC = SAN/iSCSI

innodb_support_xa = 0 #recommend 0, disable xa to negate extra disk flush

skip-innodb-doublewrite

## Binlog sync settings

## XA transactions = 1, otherwise set to 0 for best performance

sync_binlog = 0

## TX Isolation

transaction-isolation = REPEATABLE-READ #REPEATABLE-READ req for ACID, SERIALIZABLE req XA

## Per-Thread Buffer memory utilization equation:

#(read_buffer_size + read_rnd_buffer_size + sort_buffer_size + thread_stack + join_buffer_size + binlog_cache_size) * max_connections

## Global Buffer memory utilization equation:

# innodb_buffer_pool_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + key_buffer_size + query_cache_size

[mysqldump]

quick

quote-names

max_allowed_packet = 128M

상세(보기)

쿠키활용코드

JavascriptBy 관리자 2016년 9월 21일 Leave a comment

자바스크립트 쿠키활용 예제코드 2016 오키나와에세이 렌트카 부분활용 예제

// 쿠키 생성
function setCookie(cName, cValue, cDay){
   var expire = new Date();
   expire.setDate(expire.getDate() + cDay);
   cookies = cName + '=' + escape(cValue) + '; path=/ '; 
   if(typeof cDay != 'undefined') cookies += ';expires=' + expire.toGMTString() + ';';
   document.cookie = cookies;
}

// 쿠키 출력
function getCookie(cName) {
    cName = cName + '=';
    var cookieData = document.cookie;
    var start = cookieData.indexOf(cName);
    var cValue = '';
    if(start != -1){
        start += cName.length;
        var end = cookieData.indexOf(';', start);
        if(end == -1)end = cookieData.length;
        cValue = cookieData.substring(start, end);
    }
    return unescape(cValue);
}
// 쿠키확인
function checkCookie(){
    var source=getCookie('source');
    if(source!=""){
        alert("Welcome again " + source);
    }else{
            setCookie('source', getParameter('source'), 0);
        }
    }
}

checkCookie();

// 쿠키 생성

function setCookie(cName, cValue, cDay){

var expire = new Date();

expire.setDate(expire.getDate() + cDay);

cookies = cName + '=' + escape(cValue) + '; path=/ ';

if(typeof cDay != 'undefined') cookies += ';expires=' + expire.toGMTString() + ';';

document.cookie = cookies;

}

// 쿠키 출력

function getCookie(cName) {

cName = cName + '=';

var cookieData = document.cookie;

var start = cookieData.indexOf(cName);

var cValue = '';

if(start != -1){

start += cName.length;

var end = cookieData.indexOf(';', start);

if(end == -1)end = cookieData.length;

cValue = cookieData.substring(start, end);

}

return unescape(cValue);

}

// 쿠키확인

function checkCookie(){

var source=getCookie('source');

if(source!=""){

alert("Welcome again " + source);

}else{

setCookie('source', getParameter('source'), 0);

}

checkCookie();

상세(보기)

선거개표 프로그램 정리

리퍼런스By 관리자 2016년 9월 8일 Leave a comment

접속자 로그확인

cat access_log | awk '{print $1}' > total ; sort -u total > unique ; wc -l unique

1	cat access_log \| awk '{print $1}' > total ; sort -u total > unique ; wc -l unique

SQL 필드구분정리 number 선거번호 name 선거명칭 pnumber 선거구상위 선거 candidate 후보등록 마감완료 ballot 투표구 등록마감 elected 당선인수

상세(보기)

양산시 야구협회

리퍼런스By 관리자 2016년 9월 8일 Leave a comment

양산리그 규정타석 기준 양산리그 규정타석은 팀 경기수 x2.5를 곱한수가 해당 선수의 규정타석 입니다. 예로 이대호 선수의 소속 팀이 오늘 현재까지 경기수가 12경기이면 해당 팀 소속 선수들의 규정타석은 30타석이 되며 이대호 선수의 타율이 아무리 뛰어나도 30타석 미달이면 규정타석 미달로 표기 순위에 적용이되지 않으니 참조하시기 바랍니다.

상세(보기)