require_once('../../Connections/obc.php'); $sound = $_GET['sound']; $audio_id = $_GET['audio_id']; $video_id = $_GET['video_id']; mysql_select_db($database_obc,$obc); if ($sound != "off") { $sql= "select * from tb_prayer_bgsound where used = '1'"; $result = mysql_query($sql, $obc) or die(mysql_error()); $record = mysql_fetch_array($result); $bgsound = "../../admin/room/prayer/bgsound/files/$record[filename]"; } if ($audio_id != "") { $sql1= "select * from tb_prayer_multimedia where mul_id = '$audio_id'"; $result1 = mysql_query($sql1, $obc) or die(mysql_error()); $record1 = mysql_fetch_array($result1); if ($record1[url] == "") { $multimedia = "../../admin/room/prayer/multimedia/files/audio/$record1[filename]"; } else { $multimedia = $record1[url]; } } else if ($video_id != "") { $sql1= "select * from tb_prayer_multimedia where mul_id = '$video_id'"; $result1 = mysql_query($sql1, $obc) or die(mysql_error()); $record1 = mysql_fetch_array($result1); if ($record1[url] == "") { $multimedia = "../../admin/room/prayer/multimedia/files/video/$record1[filename]"; } else { $multimedia = $record1[url]; } } $sql2= "select * from tb_prayer_info where prayer_id = '1'"; $result2 = mysql_query($sql2, $obc) or die(mysql_error()); $record2 = mysql_fetch_array($result2); $sql3= "select * from tb_prayer_multimedia where type = '1'"; $result3 = mysql_query($sql3, $obc) or die(mysql_error()); $sql4= "select * from tb_prayer_multimedia where type = '2'"; $result4 = mysql_query($sql4, $obc) or die(mysql_error()); $sql6 = "select * from tb_prayer_topic where tp_id = '1'"; $result6 = mysql_query($sql6, $obc) or die(mysql_error()); $record6 = mysql_fetch_array($result6); $sql7 = "select * from tb_prayer_topic where tp_id = '2'"; $result7 = mysql_query($sql7, $obc) or die(mysql_error()); $record7 = mysql_fetch_array($result7); $sql8 = "select * from tb_prayer_topic where tp_id = '3'"; $result8 = mysql_query($sql8, $obc) or die(mysql_error()); $record8 = mysql_fetch_array($result8); $sql9= "select * from tb_prayer_request where publish = '1' order by request_id desc"; $result9 = mysql_query($sql9, $obc) or die(mysql_error()); ?>