var Max_List = 20;
function loadEvent(){
	var tableName = encodeURL("event_db ED JOIN eventsupport_db ESD ON (ED.f_eventnumber = ESD.f_eventnumber or ED.f_creator = ESD.f_creator)");
	var Field = encodeURL("ED.f_eventnumber,ED.f_title,ED.f_catch,CAST(CAST(ED.f_startdate AS DATE) AS VARCHAR(10)),CAST(CAST(ED.f_enddate AS DATE) AS VARCHAR(10)),CAST(CAST(ED.f_editdate AS DATE) AS VARCHAR(10))");
	var Where = encodeURL("WHERE (f_visibleflags = 1) and (f_publishdate <= 'TODAY') and (f_enddate >= 'TODAY') and (ED.f_sscode = '10003200' or ED.f_sscode = '10090400' or ESD.f_sscode = '10003200' or ESD.f_sscode = '10090400')");
	var Order = encodeURL('ED.f_enddate ASC');
	var xmlhttp = createXMLHttp();
	if (xmlhttp){
		xmlhttp.onreadystatechange = function () {
			geteventDB(xmlhttp);
		};
		xmlhttp.open('POST', '../cgi/selectwsdl.cgi', true);
		xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
		xmlhttp.send('table=' + tableName + '&field=' + Field + '&order=' + Order + '&where=' + Where + '&count=' + Max_List + '&quot="');
	}else{
		alert("サーバーにアクセスできませんでした");
	}
}
function geteventDB(xmlhttp){
	var hMes = '';
	var i, listData, Line, Count = 0;
	if (xmlhttp.readyState == 4 && xmlhttp.status == 200){
		listData = xmlhttp.responseText.substr(0, xmlhttp.responseText.lastIndexOf('"')).substr(1).split('"\n"');
//alert(listData.length);
		for (i = 0; (i < Max_List) && (i < listData.length); i++){
			if (listData[i] != ''){
				Line = listData[i].split('","');
				hMes += '<div class="eventdate">' + Line[3].replace(/-/g,'.');
				if(Line[4] != Line[3]){
					hMes += '-' + Line[4].replace(/-/g,'.');
				}
				hMes += '</div>';
				hMes += '<div><a href="http://www.crewcrew.net/cgi/wsdb_temp.cgi?template=temp_event_data.html&f_eventnumber=' + Line[0] + '" target="event" class="eventtitle">';
				hMes += Line[1];
				hMes += '</div></a>';
				if (Line[2] != ''){
					if (Line[2].length < 24){
						hMes += '<div class="eventlead">　' + Line[2] + '</div>';
					} else {
						hMes += '<div class="eventlead">　' + Line[2].substr(0,24) + '・・・</div>';
					}
				}

				hMes += '</dl>';
				Count++;
			}
		}
		if (Count == 0){
			hMes += '<dl class="information">';
			hMes += '<dd>現在予定はありません</dd>';
			hMes += '</dl>';
		}
		DispHTML('event', hMes);
	}
}
function encodeURL(str){
    var s0, i, s, u;
    s0 = "";                // encoded str
    for (i = 0; i < str.length; i++){   // scan the source
        s = str.charAt(i);
        u = str.charCodeAt(i);          // get unicode of the char
        if (s == " "){s0 += "+";}       // SP should be converted to "+"
        else {
            if ( u == 0x2a || u == 0x2d || u == 0x2e || u == 0x5f || ((u >= 0x30) && (u <= 0x39)) || ((u >= 0x41) && (u <= 0x5a)) || ((u >= 0x61) && (u <= 0x7a))){       // check for escape
                s0 = s0 + s;            // don't escape
            }
            else {                  // escape
                if ((u >= 0x0) && (u <= 0x7f)){     // single byte format
                    s = "0"+u.toString(16);
                    s0 += "%"+ s.substr(s.length-2);
                }
                else if (u > 0x1fffff){     // quaternary byte format (extended)
                    s0 += "%" + (oxf0 + ((u & 0x1c0000) >> 18)).toString(16);
                    s0 += "%" + (0x80 + ((u & 0x3f000) >> 12)).toString(16);
                    s0 += "%" + (0x80 + ((u & 0xfc0) >> 6)).toString(16);
                    s0 += "%" + (0x80 + (u & 0x3f)).toString(16);
                }
                else if (u > 0x7ff){        // triple byte format
                    s0 += "%" + (0xe0 + ((u & 0xf000) >> 12)).toString(16);
                    s0 += "%" + (0x80 + ((u & 0xfc0) >> 6)).toString(16);
                    s0 += "%" + (0x80 + (u & 0x3f)).toString(16);
                }
                else {                      // double byte format
                    s0 += "%" + (0xc0 + ((u & 0x7c0) >> 6)).toString(16);
                    s0 += "%" + (0x80 + (u & 0x3f)).toString(16);
                }
            }
        }
    }
    return s0;
}