\n"; ?> \n"; echo "{$loc}\n"; echo "" . str_replace(" ", "T", substr($lastmod, 0, 30)) . "+00:00\n"; echo "{$changefreq}\n"; echo "{$priority}\n"; echo "\n"; } $query = sql_query("SELECT gr_id FROM {$g5['group_table']} WHERE as_show = '1' ORDER BY gr_order", false); $gr_arr = []; while ($row = sql_fetch_array($query)) { $gr_arr[] = $row['gr_id']; } foreach ($gr_arr as $gr) { $result2 = sql_query("SELECT bo_table FROM {$g5['board_table']} WHERE gr_id = '{$gr}' AND as_show = '1' AND as_grade = '1'"); while ($row2 = sql_fetch_array($result2)) { generate_url(G5_BBS_URL . "/board.php?bo_table={$row2['bo_table']}", G5_TIME_YMDHIS); $query = sql_query("SELECT wr_id, wr_datetime FROM `{$g5['write_prefix']}{$row2['bo_table']}` WHERE wr_is_comment = '0' AND wr_option NOT LIKE '%secret%'"); while ($row = sql_fetch_array($query)) { generate_url(G5_BBS_URL . "/board.php?bo_table={$row2['bo_table']}&wr_id={$row['wr_id']}", $row['wr_datetime'],'weekly','0.5'); } } $result3 = sql_query("SELECT as_html, html_id, as_file FROM {$g5['apms_page']} WHERE gr_id = '{$gr}' AND as_html <> '3' AND as_show = '1' AND as_grade = '1'"); while ($row3 = sql_fetch_array($result3)) { $loc = ($row3['as_html'] == "2" || $row3['as_html'] == "1") ? G5_BBS_URL . "/page.php?hid={$row3['html_id']}" : G5_URL . "/{$row3['as_file']}"; generate_url($loc, G5_TIME_YMDHIS); } } $query = sql_query("SELECT ca_id FROM {$g5['g5_shop_category_table']} WHERE LENGTH(ca_id) = '2' AND as_show = '1' ORDER BY as_order ASC, ca_id ASC", false); while ($row = sql_fetch_array($query)) { generate_url(G5_URL . "/shop/list.php?ca_id={$row['ca_id']}", G5_TIME_YMDHIS); $result = sql_query("SELECT ca_id FROM {$g5['g5_shop_category_table']} WHERE LENGTH(ca_id) = '4' AND ca_id LIKE '{$row['ca_id']}%' AND as_show = '1' ORDER BY ca_order ASC, ca_id ASC"); while ($row2 = sql_fetch_array($result)) { generate_url(G5_URL . "/shop/list.php?ca_id={$row2['ca_id']}", G5_TIME_YMDHIS); $result2 = sql_query("SELECT ca_id FROM {$g5['g5_shop_category_table']} WHERE LENGTH(ca_id) = '6' AND ca_id LIKE '{$row2['ca_id']}%' AND as_show = '1' ORDER BY ca_order ASC, ca_id ASC"); while ($row3 = sql_fetch_array($result2)) { generate_url(G5_URL . "/shop/list.php?ca_id={$row3['ca_id']}", G5_TIME_YMDHIS); } } $result3 = sql_query("select it_id, it_time from `{$g5['g5_shop_item_table']}` where it_use = '1' and (ca_id like '{$row['ca_id']}%' or ca_id2 like '{$row['ca_id']}%' or ca_id3 like '{$row['ca_id']}%') order by it_order desc"); while ($row4 = sql_fetch_array($result3)) { generate_url(G5_URL . "/shop/item.php?it_id={$row4['it_id']}", $row4['it_time'],'weekly','0.5'); } } ?>