PageRenderTime 37ms CodeModel.GetById 13ms RepoModel.GetById 0ms app.codeStats 0ms

/registration/delegate/conference/index.php

https://github.com/damanlovett/SEAHO
PHP | 119 lines | 110 code | 9 blank | 0 comment | 14 complexity | c34d0aa265d366ef85e6fcd43d61b1ac MD5 | raw file
    

  1. <?php require_once('../../../Connections/CMS.php'); ?>
    2. 

  2. <?php
    3. 

  3. if (!function_exists("GetSQLValueString")) {
    4. 

  4. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
    5. 

  5. {
    6. 

  6.   $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
    7. 

  7. 

  8.   $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
    9. 

  9. 

  10.   switch ($theType) {
    11. 

  11.     case "text":
    12. 

  12.       $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
    13. 

  13.       break;    
    14. 

  14.     case "long":
    15. 

  15.     case "int":
    16. 

  16.       $theValue = ($theValue != "") ? intval($theValue) : "NULL";
    17. 

  17.       break;
    18. 

  18.     case "double":
    19. 

  19.       $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
    20. 

  20.       break;
    21. 

  21.     case "date":
    22. 

  22.       $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
    23. 

  23.       break;
    24. 

  24.     case "defined":
    25. 

  25.       $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
    26. 

  26.       break;
    27. 

  27.   }
    28. 

  28.   return $theValue;
    29. 

  29. }
    30. 

  30. }
    31. 

  31. 

  32. mysql_select_db($database_CMS, $CMS);
    33. 

  33. $query_rsConferences = "SELECT conference.conference_id, conference.conference_name, conference.conference_theme, conference.location, conference.start_date, conference.end_date, conference.registration_begins, conference.registration_late, conference.registration_deadline, conference.registration_begins, conference.accept_registrations FROM conference WHERE conference.deleted = 0 AND conference.viewable = 1 AND conference.event_type = 'Conference'";
    34. 

  34. $rsConferences = mysql_query($query_rsConferences, $CMS) or die(mysql_error());
    35. 

  35. $row_rsConferences = mysql_fetch_assoc($rsConferences);
    36. 

  36. $totalRows_rsConferences = mysql_num_rows($rsConferences);
    37. 

  37. 

  38. mysql_select_db($database_CMS, $CMS);
    39. 

  39. $query_rsConferenceFull = "SELECT conference.conference_id, conference.conference_name, conference.conference_theme, conference.location, conference.start_date, conference.end_date, conference.registration_begins, conference.registration_late, conference.registration_deadline, conference.registration_begins, conference.accept_registrations, conference_reg_info.live_message FROM conference INNER JOIN conference_reg_info ON conference.conference_id = conference_reg_info.conference_id WHERE conference.deleted = 0 AND conference.viewable = 1 AND conference.event_type = 'Conference'";
    40. 

  40. $rsConferenceFull = mysql_query($query_rsConferenceFull, $CMS) or die(mysql_error());
    41. 

  41. $row_rsConferenceFull = mysql_fetch_assoc($rsConferenceFull);
    42. 

  42. $totalRows_rsConferenceFull = mysql_num_rows($rsConferenceFull);
    43. 

  43. ?>
    44. 

  44. <?php require_once('../../includefiles/initDelegates.php'); ?>
    45. 

  45. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    46. 

  46. <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/second.dwt.php" codeOutsideHTMLIsLocked="false" -->
    47. 

  47. <head>
    48. 

  48. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    49. 

  49. <!-- InstanceBeginEditable name="doctitle" -->
    50. 

  50. <title>Current Conference</title>
    51. 

  51. <!-- InstanceEndEditable -->
    52. 

  52. <link href="../../../stylesheets/mainsheet.css" rel="stylesheet" type="text/css" />
    53. 

  53. <!-- InstanceBeginEditable name="head" -->
    54. 

  54. <link href="../../styles/cmsMain.css" rel="stylesheet" type="text/css" />
    55. 

  55. <style type="text/css">
    56. 

  56. <!--
    57. 

  57. .style1 {font-weight: bold}
    58. 

  58. -->
    59. 

  59. </style>
    60. 

  60. <!-- InstanceEndEditable -->
    61. 

  61. </head>
    62. 

  62. 

  63. <body>
    64. 

  64. <!-- DO NOT MOVE! The following AllWebMenus code must always be placed right AFTER the BODY tag-->
    65. 

  65. <!-- ******** BEGIN ALLWEBMENUS CODE FOR mainnav ******** -->
    66. 

  66. <span id='xawmMenuPathImg-mainnav' style='position:absolute;top:-50px;left:0px'><img name='awmMenuPathImg-mainnav' id='awmMenuPathImg-mainnav' src='../../../menu/awmmenupath.gif' alt=''></span>
    67. 

  67. <script type='text/javascript'>var MenuLinkedBy='AllWebMenus [4]', awmBN='626'; awmAltUrl='';</script>
    68. 

  68. <script charset='UTF-8' src='../../../menu/mainnav.js' language='JavaScript1.2' type='text/javascript'></script>
    69. 

  69. <script type='text/javascript'>awmBuildMenu();</script>
    70. 

  70. <!-- ******** END ALLWEBMENUS CODE FOR mainnav ******** -->
    71. 

  71. <table width="760" border="0" align="center" cellpadding="0" cellspacing="0" class="textheader">
    72. 

  72. <?php require_once('../../../includefiles/header.inc.php'); ?>
    73. 

  73.   <tr>
    74. 

  74.     <td colspan="2" bgcolor="#FFFFFF"><!-- InstanceBeginEditable name="pageBanner" -->
    75. 

  75.         <?php require_once('../../includefiles/header.php'); ?>
    76. 

  76.     <!-- InstanceEndEditable --></td>
    77. 

  77.   </tr>
    78. 

  78.   <tr>
    79. 

  79.     <td colspan="2" class="texttop">&nbsp;</td>
    80. 

  80. </tr>
    81. 

  81.   <tr>
    82. 

  82.     <td width="182" valign="top" id="contentleftmain"><!-- InstanceBeginEditable name="leftNav" -->
    83. 

  83. <?php require_once('../../includefiles/leftNavDelegates.php'); ?>
    84. 

  84.     <!-- InstanceEndEditable --><img src="../../../images/dropshadowlogo.jpg" alt="Seaho Logo" /></td>
    85. 

  85.     <td width="582" valign="top" id="contentmain"><!-- InstanceBeginEditable name="mainContent" -->
    86. 

  86.       <h3><strong>Current Conference(s)</strong></h3>
    87. 

  87.       
    88. 

  88. 

  89.       
    90. 

  90.       <?php if ($totalRows_rsConferenceFull == 0) { // Show if recordset empty ?>
    91. 

  91.         <p>There are no conferences available at this time.</p>
    92. 

  92.         <?php } // Show if recordset empty ?>
    93. 

  93.       <?php if ($totalRows_rsConferenceFull > 0) { // Show if recordset not empty ?>
    94. 

  94.   <?php do { ?>
    95. 

  95.           <div>
    96. 

  96.             <p><strong><?php echo $row_rsConferenceFull['conference_name']; ?></strong><br />
    97. 

  97.                 <?php echo $row_rsConferenceFull['location']; ?><br />
    98. 

  98.                 <?php echo $row_rsConferenceFull['conference_theme']; ?><br />
    99. 

  99.                 <?php echo basicDate($row_rsConferenceFull['start_date']); ?> - <?php echo basicDate($row_rsConferenceFull['end_date']); ?> <br />
    100. 

  100.               </p>
    101. 

  101.             <?php if($row_rsConferenceFull['accept_registrations']=='Yes'){?>
    102. 

  102.             <p>To submit a registration for this conference,  go to the <a href="registration.php?conferenceID=<?php echo $row_rsConferenceFull['conference_id']; ?>"> Registration page</a> .</p>
    103. 

  103.             <?php } else {?>
    104. 

  104.             <p><?php echo $row_rsConferenceFull['live_message']; ?></p>
    105. 

  105.             <?php }?>
    106. 

  106.                     </div>
    107. 

  107.     <?php } while ($row_rsConferenceFull = mysql_fetch_assoc($rsConferenceFull)); ?>
    108. 

  108.   <?php } // Show if recordset not empty ?>
    109. 

  109. <!-- InstanceEndEditable --></td>
    110. 

  110.   </tr>
    111. 

  111.   <?php require_once('../../../includefiles/footer.inc.php'); ?>
    112. 

  112. </table>
    113. 

  113. </body>
    114. 

  114. <!-- InstanceEnd --></html>
    115. 

  115. <?php
    116. 

  116. mysql_free_result($rsConferences);
    117. 

  117. 

  118. mysql_free_result($rsConferenceFull);
    119. 

  119. ?>
    120. 

  120.