DB\ud074\ub798\uc2a4\ub294 \ub123\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ucc38\uace0\uc815\ub3c4 \ud558\uc2dc\ub77c\uace0 \uacf5\uac1c\ud569\ub2c8\ub2e4. \uc5ec\uae30 \uac8c\uc2dc\ud310\uc5d0\uc11c \ud301\ub3c4 \uc880 \uc5bb\uc5c8\uc2b5\ub2c8\ub2e4. \uc798 \ubcf4\uc2dc\uace0 \uc751\uc6a9\ud574 \ubcf4\uc138\uc694!<\/p>\n
\uc138\uc158\uad6c\uc6b8 \ub54c DB\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc911\ubcf5\ub85c\uadf8\uc778\uc744 \ub9c9\uace0, 2\ucc28\ub3c4\uba54\uc778\uc744 \uc0ac\uc6a9\ud558\ub294 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ud1b5\ud569\ub85c\uadf8\uc778\uc774 \uac00\ub2a5\ud1a0\ub85d\ud55c \uc18c\uc2a4\uc785\ub2c8\ub2e4.<\/p>\n
\ub298 \ud589\ubcf5\ud558\uc138\uc694!<\/p>\n
====== \uc544\ub798\ubd80\ud130 \uc18c\uc2a4\uc785\ub2c8\ub2e4. ==============<\/p>\n
\n\/\/!! eZSession DB (\uc138\uc158 DB\ud578\ub4e4\ub9c1 \ubc0f \ud1b5\ud569\ub85c\uadf8\uc778)
\n\/*<\/p>\n
CREATE TABLE “ezsession_session” (
\n “sesskey” varchar(33) NOT NULL,
\n “expiry” int4 NOT NULL,
\n “value” text NOT NULL,
\n “uid” int4 NOT NULL,
\n “security” varchar(1) NOT NULL,
\n “remoteip” varchar(20),
\n CONSTRAINT “ezsession_session_pkey” PRIMARY KEY (“sesskey”)
\n);<\/p>\n
\/\/ start session handling
\n include_once( “classes\/ezsession.php” );<\/p>\n
session_set_save_handler (“sess_open”, “sess_close”, “sess_read”, “sess_write”, “sess_destroy”, “sess_gc”);
\n session_set_cookie_params( 0, “\/”, “.ohmytravel.com” );
\n session_start();
\n*\/<\/p>\n
include_once( “classes\/ezdb.php” );<\/p>\n
$ini =& INIFile::globalINI();
\n$SesstionTimeOut = 30 * 60;
\n$maxlifetime = $SesstionTimeOut;<\/p>\n
\nfunction sess_open( $save_path, $session_name )
\n{
\n global $sess_save_path, $sess_session_name;<\/p>\n
\/\/ $sess_save_path = $save_path;
\n\/\/ $sess_session_name = $session_name;<\/p>\n
return true;
\n}<\/p>\n
\nfunction sess_close()
\n{
\n return true;
\n}<\/p>\n
\nfunction sess_read( $key )
\n{
\n global $sess_save_path, $sess_session_name;<\/p>\n
$db =& eZDB::globalDatabase();<\/p>\n
$value_array = array();<\/p>\n
$db->array_query( $value_array, “SELECT value FROM ezsession_session WHERE sesskey=’$key’ AND expiry > ” . time() );<\/p>\n
if( count( $value_array ) == 1 )
\n {
\n \/\/ \uc138\uc158\uc2dc\uac04\uc774 \ud604\uc7ac\uc2dc\uac04\ubcf4\ub2e4 \ud06c\ub2e4\uba74 \uc815\ubcf4\ub97c \uac00\uc838\uc628\ub2e4.
\n return $value_array[0][$db->fieldName(“value”)];
\n }
\n else
\n {
\n $db->query( “DELETE FROM ezsession_session WHERE sesskey=’$key'” );
\n return false;
\n }
\n}<\/p>\n
\nfunction sess_write( $key, $sess_data )
\n{
\n global $sess_save_path, $sess_session_name, $maxlifetime;<\/p>\n
$db =& eZDB::globalDatabase();
\n $ret = false;<\/p>\n
$session_array = array();
\n $check_array = array();<\/p>\n
$expiry = time() + $maxlifetime;
\n $value = addslashes( $sess_data );
\n $remoteip = $_SERVER[“REMOTE_ADDR”];<\/p>\n
\/\/ \uc138\uc158\uc815\ubcf4\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \uccb4\ud06c
\n $db->array_query( $session_array, “SELECT * FROM ezsession_session WHERE sesskey=’$key’ AND value IS NOT NULL” );<\/p>\n
if ( count( $session_array ) == 1 ) \/\/ \uc138\uc158\uc5c5\ub370\uc774\ud2b8 – DB\uc758 \uc2dc\uac04\uc774 \ud604\uc7ac\uc2dc\uac04\ubcf4\ub2e4 \ud06c\uba74 \uacc4\uc18d \uc2dc\uac04\uc744 \uc5c5\ub370\uc774\ud2b8 \uc2dc\ucf1c \uc138\uc158\uc744 \uc720\uc9c0.
\n {
\n $res = $db->query( “UPDATE ezsession_session SET expiry=’$expiry’ WHERE sesskey=’$key’ AND expiry > ” . time() );<\/p>\n
if( $res == true )
\n $ret = true;
\n }
\n else if ( count( $session_array ) == 0 ) \/\/ \uc138\uc158\uc815\ubcf4\uac00 \uc5c6\ub294 \uacbd\uc6b0. DB\uc5d0 \uc138\uc158\uc744 \ucd94\uac00\ud55c\ub2e4.
\n {
\n if ( $sess_data )
\n {
\n $uid = $GLOBALS[‘ezuser_session_id’];<\/p>\n
\/\/ \uc774\uc911 \ub85c\uadf8\uc778 \ucc28\ub2e8! \ud750\ud750~ \uc8fc\uae30\ub139! \uc644\ubcbd\ud55c \uc911\ubcf5\ub85c\uadf8\uc778 \ucc28\ub2e8\uc774\uc58c! \u314b\u314b\u314b~
\n $db->array_query( $check_array, “SELECT value FROM ezsession_session WHERE uid=’$uid’ AND remoteip!=’$remoteip'” );<\/p>\n
\/\/ \uc911\ubcf5\ub85c\uadf8\uc778\uc744 \uac80\uc0ac\ud558\uae30 \uc704\ud55c \ud544\ub4dc. O \uc815\uc0c1, X \uc911\ubcf5\ub85c\uadf8\uc778.
\n $security = “O”;
\n if ( count( $check_array ) == 1 )
\n {
\n $security = “X”;
\n }<\/p>\n
\/\/ lock the table
\n $db->begin();
\n $db->lock( “ezsession_session” );<\/p>\n
\/\/ \uc138\uc158\ucd94\uac00 – \ub85c\uadf8\uc778\ud588\uc744 \uacbd\uc6b0 $sess_data \uc815\ubcf4\uac00 \ud55c\ubc88 \ub118\uc5b4\uc628\ub2e4. \uadf8 \ub54c\ub9cc \ucd94\uac00\ud55c\ub2e4.
\n $res = $db->query( “INSERT INTO ezsession_session ( sesskey, expiry, value, uid, security, remoteip ) VALUES ( ‘$key’, ‘$expiry’, ‘$value’, ‘$uid’, ‘$security’, ‘$remoteip’ )” );<\/p>\n
if ( $res == true )
\n $ret = true;
\n }
\n }<\/p>\n
$db->unlock();<\/p>\n
if ( $ret == false )
\n $db->rollback( );
\n else
\n $db->commit();<\/p>\n
return $ret;
\n}<\/p>\n
\nfunction sess_destroy( $key )
\n{
\n global $sess_save_path, $sess_session_name;<\/p>\n
$db =& eZDB::globalDatabase();<\/p>\n
$db->query( “DELETE FROM ezsession_session WHERE sesskey=’$key'” );<\/p>\n
return true;
\n}<\/p>\n
\n\/*********************************************
\n* WARNING – You will need to implement some *
\n* sort of garbage collection routine here. *
\n*********************************************\/
\nfunction sess_gc( $maxlifetime )
\n{
\n $db =& eZDB::globalDatabase();<\/p>\n
$db->query( “DELETE FROM ezsession_session WHERE expiry < \" . time() );\n\n\n return true;
\n}<\/p>\n
\n\/\/ \uc138\uc158 \ud578\ub4e4\ub9c1 (\ub3c4\uba54\uc778 \uc785\ub825\uc2dc 1\ucc28\ub3c4\uba54\uc778 \uc55e\uc5d0 .(\uc810)\uc744 \ucc0d\uc5b4\uc57c \ud55c\ub2e4.)
\nsession_set_save_handler (“sess_open”, “sess_close”, “sess_read”, “sess_write”, “sess_destroy”, “sess_gc”);
\nsession_set_cookie_params( 0, “\/”, “.domain.com” );
\nsession_start();<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
DB\ud074\ub798\uc2a4\ub294 \ub123\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ucc38\uace0\uc815\ub3c4 \ud558\uc2dc\ub77c\uace0 \uacf5\uac1c\ud569\ub2c8\ub2e4. \uc5ec\uae30 \uac8c\uc2dc\ud310\uc5d0\uc11c \ud301\ub3c4 \uc880 \uc5bb\uc5c8\uc2b5\ub2c8\ub2e4. \uc798 \ubcf4\uc2dc\uace0 \uc751\uc6a9\ud574 \ubcf4\uc138\uc694! \uc138\uc158\uad6c\uc6b8 \ub54c DB\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc911\ubcf5\ub85c\uadf8\uc778\uc744 \ub9c9\uace0, 2\ucc28\ub3c4\uba54\uc778\uc744 \uc0ac\uc6a9\ud558\ub294 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ud1b5\ud569\ub85c\uadf8\uc778\uc774 \uac00\ub2a5\ud1a0\ub85d\ud55c \uc18c\uc2a4\uc785\ub2c8\ub2e4. \ub298 \ud589\ubcf5\ud558\uc138\uc694! ====== \uc544\ub798\ubd80\ud130 \uc18c\uc2a4\uc785\ub2c8\ub2e4. ==============<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-617","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=617"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/617\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}