addvar = new Additions; } function set_guide_colors(){ // set background color of guides frame NB. no hashes (!#) // $calbgcol = "7cb527"; $bgcol= array('496b8f','ac9a5b','a97399'); $img = array('/gigs/images/buddha1.gif','/gigs/images/buddha2.gif','/gigs/images/dragon-wood.png'); $num = rand(1,3) - 1 ; $bgcol1 = $bgcol[$num]; $img1 = $img[$num]; $guidebg = array($bgcol1,$img1); return ($guidebg); } function get_dates(){ //echo "sow= $_GET[sow]"; if ($_GET[sow] != NULL) { if (!$_GET[month] || !$_GET[day] || !$_GET[year]){ $datearr = $this->addvar->cal->findDate($_GET[sow]); $alldates = array($_GET[sow], $datearr[1], $datearr[0], $datearr[2]); } else { $alldates = array($_GET[sow], $_GET[month], $_GET[day], $_GET[year]); // echo "get_dates: $_GET[sow] , $_GET[month] , $_GET[day] , $_GET[year]"; } } else { $d = getdate(time()); if ($day == "") { $day = $d["mday"]; } if ($month == "") { $month = $d["mon"]; } if ($year == "") { $year = $d["year"]; } $date = date ("Ymd", mktime(0,0,0,$month,$day,$year)); $sow = $this->addvar->cal->findMonday($date); $alldates = array($sow, $month, $day, $year); //echo "1: $day , $month , $year , $sow"; } return ($alldates); } function show_title_date($sow){ echo " - ".$this->addvar->cal->findMonday2($sow)." to ".$this->addvar->cal->findSunday($sow)." - \n"; } function show_css($bgcol,$img){ echo " \n"; echo " \n"; //echo " \n"; //echo " \n"; // echo 'num = '. $num.'bgcol = '.$bgcol1.' img = '.$img1; //print_r($bgcol); echo "\n"; echo "\n"; } function display_content(){ echo "
\n"; $this->display_left_column(); //echo "
\n"; //$this->display_guide_header(); //echo "
"; //echo "
\n"; //$this->display_guide_body(); //echo "
\n"; //echo "
\n"; //echo "
\n"; //echo "
\n"; echo "
\n"; } function display_left_column(){ echo "
\n"; $this->display_logo(); //$this->display_buttons(); //$this->display_cal(); $this->getlastfiveGuide(); $this->getlastfiveForum(); //$this->getmostViewsForum(); //$this->display_banner(1); echo '

Let more music lovers know whats going on.

Posting here helps keep people informed. When your audience knows what\'s happening there will be bigger crowds and better atmosphere at events. You might even discover the next big thing here.

Don\'t delay... Post a listing today!!!

'; } function display_left_column_top(){ echo ("
\n"); echo " \n"; echo " \n"; echo ("
\n"); } function display_left_column_bottom(){ echo ("
\n"); echo " \n"; echo " \n"; echo ("
\n"); } function display_logo(){ echo "
\n"; echo "

DJCJ Gigs Guide

On Your Phone

\n"; //$this->display_buttons(); echo "
\n"; echo "
\n"; } function display_buttons(){ echo "
\n"; echo " \"Add\n"; //echo (" \n"); //echo ("\n"); echo "
\n"; } function display_guide_body(){ if($_GET[map] == 1){ ?>
Map of Apkujong Map of Hongdae

Map of Itaewon Map of Sinchon

faq(); }else if($_GET[suggestions]) { $this->suggestions(); }else if($_GET[banner]) { $this->create_banner_form(); }else if($_GET[allven]) { $this->get_all_venues(); }else if($_GET[archive]){ $this->get_archive(); }else if($_GET[delfor]) { $this->del_user_posts(); }else { ?> show_events($agent, "venvars"); // echo (" $_GET[sow], $day, $month, $year, $agent\n"); ?> \n"; } $compare = substr($compare, 0, -2); // echo $compare; $vv = mysql_query("SELECT post_id, poster_id from phpbb_posts where $compare"); $i = 0; while($row1 = mysql_fetch_array($vv, MYSQL_ASSOC)) { // $array[$i][$key] = $var; echo $row1[poster_id].' '.$row1[post_id]."
\n"; $i++; } /* foreach ($array as $key => $var){ echo "$key = ".$array[$key][post_id]."
\n"; } */ } function display_cal(){ echo ("
\n"); echo (" \n"); echo (" \n"); echo (" \n"); echo (" \n"); echo ("
\n"); echo ("\n"); echo (" \n"); echo (" \n"); echo (" \n"); echo (" \n"); echo ("
\n"); $alldates = $this->get_dates(); //echo "
$alldates[0], $alldates[1], $alldates[2],$alldates[3],$alldates[4]"; echo $this->addvar->cal->getMonthView( $alldates[1], $alldates[3], $alldates[0], $calbgcol); echo ("\n"); echo ("
\n"); echo ("\n"); echo ("
\n"); echo ("\n"); echo ("
\n"); echo ("\n"); } function getlastfiveGuide(){ $this->display_left_column_top(); $v = mysql_query("SELECT * FROM djcjgg where display = 1 order by day_id desc limit 0,5"); // $v = mysql_query("SELECT sow, vname FROM djcjggv where djcjggv.id = $num and djcjggv.display = 1"); echo "
\n"; echo "

Latest Posts in
the Gigs Guide

\n"; $ii = 1; while($row = mysql_fetch_array($v, MYSQL_ASSOC)) { //print_r($row); $vv = mysql_query("SELECT vname, address FROM djcjgg_venues where vid = $row[vid]"); $row1 = mysql_fetch_array($vv); $vname = $this->addvar->trimvars2($row1[vname],20); $div_id = "lastFiveGuide".$row[day_id]; echo " ".$ii.": $vname
\n"; echo " ". $row1[address] ."
\n"; //print_r($row); $ii ++; $daynames = array('mon','tue','wed','thu','fri','sat','sun'); $datearr = $this->addvar->cal->findDate($row[sow]); // print_r($datearr); for($i = 0; $i < 7; $i++){ $day = $datearr[0] + $i; $month = $datearr[1]; $year = $datearr[2]; $dow = $this->addvar->cal->findDay($day, $month, $year); $desc = $daynames[$i]; $url = $daynames[$i]."url"; $price = $daynames[$i]."p"; $time = $daynames[$i]."t"; if ($row[$desc] != NULL){ echo " $dow
\n"; echo " $row[$desc]
\n"; if ($row[$price] != NULL) echo " $row[$price]
"; if ($row[$price] != NULL) echo " $row[$time]
\n"; echo "

\n"; } } } echo"

\n"; $this->display_left_column_bottom(); } function getlastfiveForum(){ $this->display_left_column_top(); $v = mysql_query("SELECT * FROM phpbb_posts order by post_id desc limit 0,10"); echo "
\n"; echo "

Latest Posts
in the Forum

\n"; $ii = 1; while($row = mysql_fetch_array($v, MYSQL_ASSOC)) { $vv = mysql_query("SELECT topic_title FROM phpbb_topics where topic_id = $row[topic_id]"); $title = mysql_fetch_array($vv); $vvvv = mysql_query("SELECT post_subject FROM phpbb_posts_text where post_id = $row[post_id]"); $subject = mysql_fetch_array($vvvv); // print_r($row); $titleTrim = $this->addvar->trimvars2($title[topic_title],25); $subjectTrim = $this->addvar->trimvars2($subject[post_subject],25); //echo "xxx".$titleTrim.",".$subjectTrim."
\n"; if(!$subjectTrim){ echo " ".$ii.": ".$titleTrim."...
\n"; } else { echo " ".$ii.": ".$subjectTrim."...
\n"; } $ii ++; } echo"
\n"; $this->display_left_column_bottom(); } function getmostViewsForum(){ $this->display_left_column_top(); $v = mysql_query("SELECT * FROM phpbb_topics order by topic_views desc limit 0,5"); echo "
\n"; echo "

Most popular topics
in the Forum

\n"; while($row = mysql_fetch_array($v, MYSQL_ASSOC)) { // print_r($row); $titleTrim = $this->addvar->trimvars2($row[topic_title],25); //echo "xxx".$titleTrim.",".$subjectTrim."
\n"; echo " Views: ".$row[topic_views]." ".$titleTrim."...
\n"; } echo"
\n"; $this->display_left_column_bottom(); } function get_all_venues(){ $v = mysql_query("SELECT distinct address FROM djcjgg_venues order by address"); $addressArray = array(); while($row = mysql_fetch_array($v, MYSQL_ASSOC)) { $addressArray[] = $row[address]; } sort($addressArray); //print_r($addressArray); echo "
\n"; echo "

All the venues in the Gigs Guide

\n"; foreach($addressArray as $key => $var){ if($var){ echo "

$var

"; $vv = mysql_query("SELECT * FROM djcjgg_venues where address = '$var' order by address"); while($row1 = mysql_fetch_array($vv, MYSQL_ASSOC)) { if ($row1[url] != NULL){ echo " $row1[vname]"; }else{ echo " $row1[vname]"; } if ($row[phone]) echo " , $row1[phone]"; echo "
\n"; } } } echo"
\n"; } function get_archive(){ // $v = mysql_query("SELECT * FROM djcjgg"); // $v = mysql_query("SELECT sow, vname FROM djcjggv where djcjggv.id = $num and djcjggv.display = 1"); // $this->display_buttons(); $v = mysql_query("SELECT * FROM djcjgg_venues as v, djcjgg as g where v.vid = g.vid and g.display = 1 order by g.day_id desc"); echo "
\n"; echo "

All the Posts From the Gigs Guide Calendar Archive 2003 - 2006

\n"; while($row = mysql_fetch_array($v, MYSQL_ASSOC)) { $date = $this->addvar->cal->findArchiveDate($row[sow]); if ($row[url] != NULL){ echo " ".$date.": $row[vname]"; }else{ echo " ".$date.": $row[vname]"; } if ($row[mon]) echo " $row[mon]"; if ($row[tue]) echo " $row[tue]"; if ($row[wed]) echo " $row[wed]"; if ($row[thu]) echo " $row[thu]"; if ($row[fri]) echo " $row[fri]"; if ($row[sat]) echo " $row[sat]"; if ($row[sun]) echo " $row[sun]"; echo "
\n"; } echo"
\n"; } function show_events($agent, $id){ $alldates = $this->get_dates(); // echo "

in show_events...
"; //print_r($alldates); //echo "id = $id
"; $weekdates = $this->addvar->cal->getWeekView($alldates[2], $alldates[1], $alldates[3], $calbgcol); // print_r($weekdates); if ($id == "venvars"){ // echo "id = $id
"; $this->addvar->getvenvars($alldates[0], $alldates[2], $alldates[1],$alldates[3], $weekdates, $agent); } else if($id == "addvars"){ $this->addvar->getaddvars($agent, $weekdates); } else { $this->addvar->geteditvenvars($alldates[0], $alldates[1], $alldates[2],$alldates[3], $id, $weekdates); } // $this->addvar->close_grid(); } function listing_forms_table($novname){ // echo "1: sow=$sow thissow=$this->sow day=$day y=$year m=$month
"; // echo "calbgcol=$calbgcol"; // Check to see if editing previous entry // echo "3: sow=$_GET[sow] thissow=$this->sow day=$day m=$month y=$year
"; ?> addvar->cal->findMonday($_GET[year].$_GET[month].$_GET[day]); // echo $sow; $this->addvar->getformvars($sow, $novname); //echo " in listing forms table
novname = $novname

\n"; } else { echo "

\n"; echo "Choose the date
for your listing

\n"; echo "

\n"; echo " \n"; echo " \n"; echo " \n"; $p = explode("?",$_GET[p]); echo " \n"; echo "

\n"; echo "

\n"; echo "
\n"; echo "
\n"; } } else { $sow = $_GET[sow]; // echo "3:sow=$sow"; echo "
\n"; $this->addvar->getformvars($sow, $novname); //echo " in listing forms table
novname = $novname

\n"; echo "

\n"; } } function suggestions() { if ($_POST[selfsend]) { ?>
Thanks, your message has been delivered
Please check before you send.
">
   


"> ">
User Name:
Email address:

Gigs Guide FAQ

We need your questions to make this useful

Table of Contents

  1. How do I make a post?
  2. Who is this site for?
  3. Is there a moderator?
  4. How do I help?
  5. Is there a message board?
  6. Is there a mailing list I can join?

  1. How do I make a post? Simply press the ADD icon and fill in the required fields.

    When you press preview it will show you a preview of the listing. This is the time to check for spelling and any mistakes, also anything else that may need to be added. Then press the submit button and it will be posted.

  2. Who is this site for? It is for everyone who wants to know whats happening, as well as for the promotion companies to post their events on an unbiased, and ultimately, widely read site. We would like it to be used by the whole peninsula, but one step at a time.

  3. Is there a moderator? All submissions are catalogued as a backup and checked for ill intentioned content. Mistakes are not moderated.

  4. How do I help? Either submit this form or contact the site admin directly. All help is welcome. Especially people who are able to help with the English/Korean postings.

  5. Is their a forum/message board? Yes. Just look in the community link in the menu.

  6. Is their a mailing list I can join? Yes. Just look in the community link in the menu.