[그누헌터]통계소스보여주기 정보
그누호환 [그누헌터]통계소스보여주기
본문
회원연동버전을 수정하였습니다.
hu_datetime2 datetime NOT NULL default '0000-00-00 00:00:00',
of_datetime2 datetime NOT NULL default '0000-00-00 00:00:00',
아래의 소스는 install.php의 내용을 수정한 일부분입니다...
$gh_hunter ="
CREATE TABLE gh_hunter (
hu_id int(11) NOT NULL auto_increment,
mb_id varchar(20) NOT NULL default '',
hu_jumin varchar(20) NOT NULL default '',
hu_passwd varchar(20) NOT NULL default '',
hu_subject varchar(255) NOT NULL default '',
hu_name varchar(20) NOT NULL default '',
hu_area char(2) NOT NULL default '',
hu_jiwon char(1) NOT NULL default '',
hu_goyong char(1) NOT NULL default '',
hu_jikjong char(2) NOT NULL default '',
hu_bosu int(11) NOT NULL default '0',
hu_danwi char(1) NOT NULL default '',
hu_email varchar(255) NOT NULL default '',
hu_tel varchar(20) NOT NULL default '',
hu_datetime varchar(30) NOT NULL default '',
hu_datetime2 datetime NOT NULL default '0000-00-00 00:00:00',
hu_ip varchar(15) NOT NULL default '',
hu_birth date NOT NULL default '0000-00-00',
hu_byung char(1) NOT NULL default '',
hu_sex char(1) NOT NULL default '',
hu_hakruk char(1) NOT NULL default '',
hu_school varchar(255) NOT NULL default '',
hu_license text NOT NULL,
hu_sogae text NOT NULL,
hu_zip1 char(3) NOT NULL default '',
hu_zip2 char(3) NOT NULL default '',
hu_addr varchar(255) NOT NULL default '',
hu_addr2 varchar(255) NOT NULL default '',
hu_first_date datetime NOT NULL default '0000-00-00 00:00:00',
hu_last_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (hu_id)
) TYPE=MyISAM";
$gh_offer ="
CREATE TABLE gh_offer (
of_id int(11) NOT NULL auto_increment,
mb_id varchar(20) NOT NULL default '',
of_jumin varchar(20) NOT NULL default '',
of_passwd varchar(20) NOT NULL default '',
of_subject varchar(255) NOT NULL default '',
of_company varchar(50) NOT NULL default '',
of_name varchar(20) NOT NULL default '',
of_area char(2) NOT NULL default '',
of_jiwon char(1) NOT NULL default '',
of_goyong char(1) NOT NULL default '',
of_jikjong char(2) NOT NULL default '',
of_bosu int(11) NOT NULL default '0',
of_danwi char(1) NOT NULL default '',
of_email varchar(255) NOT NULL default '',
of_tel varchar(20) NOT NULL default '',
of_fax varchar(20) NOT NULL default '',
of_zip1 char(3) NOT NULL default '',
of_zip2 char(3) NOT NULL default '',
of_addr varchar(255) NOT NULL default '',
of_addr2 varchar(255) NOT NULL default '',
of_datetime varchar(30) NOT NULL default '',
of_datetime2 datetime NOT NULL default '0000-00-00 00:00:00',
of_ip varchar(15) NOT NULL default '',
of_byung char(1) NOT NULL default '',
of_sex char(1) NOT NULL default '',
of_hakruk char(1) NOT NULL default '',
of_memo text NOT NULL,
of_first_date datetime NOT NULL default '0000-00-00 00:00:00',
of_last_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (of_id)
) TYPE=MyISAM";
그리고 hunterupdate.php와 offerupdate.php의 내용에
hu_datetime2 = '$now',
of_datetime2 = '$now',
의 내용을 더해줘야 합니다.
아래의 내용은 예제입니다.
$sql_common = " of_subject = '$of_subject',
of_company = '$of_company',
of_name = '$of_name',
of_area = '$of_area',
of_jiwon = '$of_jiwon',
of_goyong = '$of_goyong',
of_jikjong = '$of_jikjong',
of_bosu = '$of_bosu',
of_danwi = '$of_danwi',
of_email = '$of_email',
of_tel = '$of_tel',
of_fax = '$of_fax',
of_zip1 = '$of_zip1',
of_zip2 = '$of_zip2',
of_addr = '$of_addr',
of_addr2 = '$of_addr2',
of_datetime = '$reg',
of_datetime2 = '$now',
of_ip = '$REMOTE_ADDR',
of_byung = '$of_byung',
of_sex = '$of_sex',
of_hakruk = '$of_hakruk',
of_memo = '$of_memo',
of_first_date = '$of_first_date',
of_last_date = '$of_last_date',
mb_id = '$mb_id'";
그다음엔 index.php의 파일을 수정합니다...
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "DESIGN");
include "./hunter/hunter.lib.php";
$ht = new Hunter_;
$html_title = "그헌터";
include "./hunter/head.php";
?>
<TABLE width='100%' align=center cellpadding=0 cellspacing=0>
<colgroup width=50%>
<colgroup width=''>
<colgroup width=50%>
<tr>
<td valign=top align=center>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td colspan=2 height=1 background='./hunter/img/line.gif'></td></tr>
<tr class='ht subject subjectbg'><td colspan=2 align=center><a href='./?doc=hunter/offer.php'>구인 현황</a></td></tr>
<tr><td colspan=2 height=1 background='./hunter/img/line.gif'></td></tr>
<?
$sql = " select * from $cfg[table_offer] order by of_id desc ";
$result = sql_query($sql);
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$jiwon = cut_str($ht->get_search("jiwon", $row[of_jiwon]),4,"");
//$of_name = gblayer($row[of_name], cut_str($row[of_name],12), $member[mb_email], $member[mb_homepage], $row[mb_open]);
$of_name = gblayer($row[mb_id], cut_str($row[of_name],12), $member[mb_email], $member[mb_homepage], $row[mb_open]);
echo "
<tr height=22>
<td><span style='font-size:6pt;'>●</span> <a href='./?doc=hunter/offerview.php&of_id=$row[of_id]'>".conv_subject($row[of_subject],40)."</a></td>
<td width=80>$of_name</td>
</tr>";
}
if (!$i) {
echo "<tr><td height=100 align=center colspan=2>자료가 없습니다.</td></tr>";
}
?>
</table>
<?
$sql = " select * from $cfg[table_offer] order by of_id desc ";
$of = sql_query($sql);
// 오늘등록글
$sql = " select count(of_datetime2) from $cfg[table_offer] where TO_DAYS(CURDATE()) - TO_DAYS(of_datetime2) = 0";
$row = sql_fetch($sql);
$of_today_total = $row[0];
// 현재모집글
$sql = " select count(of_last_date) from $cfg[table_offer] where of_last_date > '$now'";
$row = sql_fetch($sql);
$of_ing_total = $row[0];
// 오늘마감글
$sql = " select count(of_last_date) from $cfg[table_offer] where TO_DAYS(CURDATE()) - TO_DAYS(of_last_date) = '$of[of_last_date]'";
$row = sql_fetch($sql);
$of_todaying_total = $row[0];
?>
<b>모집현황<br><br>
오늘등록글 : [<?=nf($of_today_total)?>]<br>
현재모집글 : [<?=nf($of_ing_total)?>]<br>
오늘마감글 : [<?=nf($of_todaying_total)?>]</b>
</td>
<td> </td>
<td valign=top align=center>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td colspan=2 height=1 background='./hunter/img/line.gif'></td></tr>
<tr class='ht subject subjectbg'><td colspan=2 align=center><a href='./?doc=hunter/hunter.php'>구직 현황</a></td></tr>
<tr><td colspan=2 height=1 background='./hunter/img/line.gif'></td></tr>
<?
$sql = " select * from $cfg[table_hunter] order by hu_id desc ";
$result = sql_query($sql);
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$jiwon = cut_str($ht->get_search("jiwon", $row[hu_jiwon]),4,"");
//$hu_name = gblayer($row[hu_name], cut_str($row[hu_name],12), $member[mb_email], $member[mb_homepage], $row[mb_open]);
$hu_name = gblayer($row[mb_id], cut_str($row[hu_name],12), $member[mb_email], $member[mb_homepage], $row[mb_open]);
echo "
<tr height=22>
<td><span style='font-size:6pt;'>●</span> <a href='./?doc=hunter/hunterview.php&hu_id=$row[hu_id]'>".conv_subject($row[hu_subject],40)."</a></td>
<td width=80>$hu_name</td>
</tr>";
}
if (!$i) {
echo "<tr><td height=100 align=center colspan=2>자료가 없습니다.</td></tr>";
}
?>
</table>
<?
$sql = " select * from $cfg[table_hunter] order by hu_id desc ";
$hu = sql_query($sql);
// 오늘등록글
$sql = " select count(hu_datetime2) from $cfg[table_hunter] where TO_DAYS(CURDATE()) - TO_DAYS(hu_datetime2) = 0";
$row = sql_fetch($sql);
$hu_today_total = $row[0];
// 현재모집글
$sql = " select count(hu_last_date) from $cfg[table_hunter] where hu_last_date > '$now'";
$row = sql_fetch($sql);
$hu_ing_total = $row[0];
// 오늘마감글
$sql = " select count(hu_last_date) from $cfg[table_hunter] where TO_DAYS(CURDATE()) - TO_DAYS(hu_last_date) = '$hu[hu_last_date]'";
$row = sql_fetch($sql);
$hu_todaying_total = $row[0];
?>
<b>모집현황<br><br>
오늘등록글 : [<?=nf($hu_today_total)?>]<br>
현재모집글 : [<?=nf($hu_ing_total)?>]<br>
오늘마감글 : [<?=nf($hu_todaying_total)?>]</b>
</td>
</tr>
</table>
<?
include "./hunter/tail.php";
?>
즐컴하시길 바랍니다....^^
추천
0
0
댓글 전체
수정된 소스는 자작게시판에 올려져 있습니다.
참 그리고 지난 소스 코멘트를 읽어보다가 수정이 안된 부분들이 있더군요.
지난 소스의 코멘트를 참조 하시길 바랍니다..
지니아빠님이 수정해놓으셨어요...
시간나는대로 수정하여 올릴께요...^^
참 그리고 지난 소스 코멘트를 읽어보다가 수정이 안된 부분들이 있더군요.
지난 소스의 코멘트를 참조 하시길 바랍니다..
지니아빠님이 수정해놓으셨어요...
시간나는대로 수정하여 올릴께요...^^