sugar01
\nhttp:\/\/prospect.new21.net<\/p>\n
\n\ud68c\uc6d0\ud14c\uc774\ube14\uc5d0 \ud14c\uc2a4\ud2b8\uc6a9\uc73c\ub85c \uc544\uc774\ub514 ‘test’ \ube44\ubc00\ubc88\ud638 ‘test’ \uc778 \ub370\uc774\ud130\ub97c \ud558\ub098 \ub123\uc5c8\uc2b5\ub2c8\ub2e4.
\n###########\ud68c\uc6d0 \ud14c\uc774\ube14###########
\nCREATE TABLE sugar_member (
\n num int(4) unsigned NOT NULL auto_increment,
\n id char(20) NOT NULL default ”,
\n passwd char(20) NOT NULL default ”,
\n PRIMARY KEY (num)
\n) TYPE=MyISAM;<\/p>\n
INSERT INTO sugar_member VALUES(”,’test’,password(‘test’));<\/p>\n
##########\uc138\uc158 \uad00\ub9ac \ud14c\uc774\ube14###################
\nCREATE TABLE sugar_session4 (
\n uid varchar(32) NOT NULL default ‘0’,
\n sess_key varchar(32) NOT NULL default ”, \/\/\uc138\uc158\ud0a4
\n last_log int(11) unsigned NOT NULL default ‘0’,
\n last_ip varchar(15) NOT NULL default ”,
\n sess_value text NOT NULL, \/\/\uc138\uc158\uac12, \ub85c\uadf8\uc778 \ud558\uac8c\ub418\uba74 \uc800\uc7a5\ub418\ub294 \uc815\ubcf4
\n attack int(2) NOT NULL default ‘0’, \/\/\ub85c\uadf8\uc778\ud6c4 \ub2e4\ub978 \uc544\uc774\ud53c\uc5d0\uc11c \ub85c\uadf8\uc778 \ud558\ub824 \ud558\uba74 \uc99d\uac00
\n KEY sess_key (sess_key)
\n) TYPE=MyISAM;<\/p>\n
\n#######config.php#########
\n$localhost=localhost;
\n$user_name=””; \/\/\ub514\ube44 \uc0ac\uc6a9\uc774\ub984
\n$db_passwd=””; \/\/\ub514\ube44 \ud328\uc2a4\uc6cc\ub4dc
\n$db_name=””; \/\/\ub514\ube44 \uc774\ub984<\/p>\n
$connect=mysql_connect(“$localhost”,”$user_name”,”$db_passwd”) or die(“SQL server\uc5d0 \uc5f0\uacb0\ud560\uc218 \uc5c6\uc2b5\ub2c8\ub2e4.”);
\nmysql_select_db(“$db_name”,$connect);
\n?>
\n\n#########sess_test.php#################<\/p>\n
include “config.php”;<\/p>\n
session_cache_limiter(”);
\nsession_set_save_handler(“sess_open”, “sess_close”, “sess_read”, “sess_write”, “sess_destroy”, “sess_gc”);
\nsession_start();
\n\/\/echo”_SESSION[sess_id] = $_SESSION[sess_id]
“;
\n$time=time();
\n\/\/echo”time= $time
“;<\/p>\n
function sess_open($save_path, $session_name) {
\n \/\/echo”sess_open save_path = $save_path session_name= $session_name <\/p>\n
“;
\n return 1;
\n}<\/p>\n
function sess_read($key) {
\n \/\/echo”sess_read key = $key <\/p>\n
“;
\n $query=mysql_query(“SELECT sess_value FROM sugar_session4 WHERE sess_key = ‘$key’ AND last_log > ‘”.(time()-get_cfg_var(“session.gc_maxlifetime”)).”‘ “) or die(mysql_error());
\n $row=mysql_fetch_array($query);
\n return $row[0];
\n}<\/p>\n
function sess_write($key, $value) {
\n \/\/echo”sess_write key = $key value=$value <\/p>\n
“;
\n $query=mysql_query(“SELECT * FROM sugar_session4 WHERE sess_key=’$key’AND sess_value IS NOT NULL”) or die(mysql_error());
\n $time=time();
\n $check=mysql_num_rows($query);
\n \/\/echo”check = $check
“;
\n if(mysql_num_rows($query)==0) \/\/\uc0c8\ub85c \ub85c\uadf8\uc778 \ud558\ub824\ub294 \uacbd\uc6b0
\n {
\n if($value!=””)
\n {
\n $uid=$GLOBALS[‘sess_id’];
\n \/\/\ub85c\uadf8\uc544\uc6c3 \ud558\uc9c0 \uc54a\uace0 \ucc3d\uc744 \ub2eb\uc544\uc11c \uc0ac\uc774\ud2b8\ub97c \ub098\uac00\uace0 \ub2e4\uc2dc \ub85c\uadf8\uc778 \ud558\ub824\ub294 \uacbd\uc6b0
\n $query=mysql_query(“SELECT sess_value from sugar_session4 WHERE uid=’$uid’ AND last_ip='”.$_SERVER[“REMOTE_ADDR”].”‘”) or die(mysql_error());<\/p>\n
\n if(mysql_num_rows($query))
\n {
\n mysql_query(“UPDATE sugar_session4 SET sess_key=’$key’,last_log='”.time().”‘, last_ip='”.$_SERVER[“REMOTE_ADDR”].”‘, sess_value=’$value’ WHERE uid=’$uid'”) or die(mysql_error());
\n echo”“;
\n }<\/p>\n
else \/\/\ub85c\uadf8\uc544\uc6c3 \ud558\uace0 \ub098\uac00\uc11c \ub2e4\uc2dc \ub85c\uadf8\uc778 \ud558\ub824\ub294 \uacbd\uc6b0
\n {
\n \/\/\ub2e4\ub978 \uc544\uc774\ud53c\ub85c \uc811\uadfc \ud558\ub824\ub294 \uacbd\uc6b0
\n $query=mysql_query(“SELECT sess_value FROM sugar_session4 WHERE uid=’$uid’ AND last_ip!='”.$_SERVER[“REMOTE_ADDR”].”‘”) or die (mysql_error());
\n if(mysql_num_rows($query))
\n {
\n $query=mysql_query(“UPDATE sugar_session4 SET attack=attack+1 WHERE uid=’$uid’ AND last_ip!='”.$_SERVER[“REMOTE_ADDR”].”‘”) or die (mysql_error());<\/p>\n
echo(“