PHP afstemning med op til 25 spørgsmål?

Hvis du selv gider lave en admin del kan du få det her:

($kundenavn er blot en variabel til at adskille tabeller)

<?

$sql = 'SELECT * FROM ' . $kundenavn . '_afstemning_spm ORDER BY ID DESC LIMIT 0,1';
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$spm = $row['spm'];
$id = $row['id'];

if ($_GET['stem'] != "" && $_GET['valg'] != "") {
setcookie("har_stemt$id", "jepper", time()+60*60*24*365);
}

global $id;
//tjek cookie her
$ny_var = "har_stemt" . "$id";
if($_COOKIE[$ny_var] != "jepper") {
    if ($_GET['stem'] != "" && $_GET['valg'] != "") {
    $sql = 'UPDATE ' . $kundenavn . '_afstemning_muligheder SET antal = antal + 1 WHERE id = "' . $_REQUEST['valg'] . '"';
    $result = mysql_query($sql);
    }
}

$sql2 = 'SELECT * FROM ' . $kundenavn . '_afstemning_muligheder WHERE spm_id="' . $row['id'] . '"';
$result2 = mysql_query($sql2);

if ($_GET['resultat'] || $_COOKIE[$ny_var] == "jepper") {
///Vis resultat

$sql_tael = 'SELECT SUM(antal) AS antal FROM ' . $kundenavn . '_afstemning_muligheder WHERE spm_id="' . $row['id'] . '"';
$result_tael = mysql_query($sql_tael);
$row_tael = mysql_fetch_array($result_tael);
$samlet_antal = $row_tael['antal'];

echo '<form><table cellpadding="0" cellspacing="0" width="100%" border="0"><tr><td colspan="2"><strong>' . $row['spm'] . '</strong></td></tr>';
while($row2 = mysql_fetch_array($result2)) {

$procent = round($row2['antal'] / $samlet_antal * 100);

echo '<tr><td style="height:30px" width="100%">' . $row2['svar'] . '</td></tr>';
echo '<tr><td valign="top" style="height:30px" width="100%"><span style="width:100%"><span style="background-color:#5788BF;width:' . $procent . '"></span>&nbsp;<span>' . $procent . '%</span></span></td></tr>';
$procent = 0;
}

echo '<tr><td colspan="2">Stemmer: ' . $samlet_antal . ' ialt</td></tr></table>';

} else {
///Vis afstemning

echo '<form><input type="hidden" name="resultat" value="ja"><table cellpadding="0" cellspacing="0" border="0"><tr><td colspan="2"><strong>' . $row['spm'] . '</strong></td></tr>';

while($row2 = mysql_fetch_array($result2)) {
echo '<tr><td style="height:30px;width:10px"><input type="radio" name="valg" value="' . $row2['id'] . '"></td><td width="100%">' . $row2['svar'] . '</td></tr><tr><td style="height:30px">&nbsp;</td></tr>';
}

echo '</table><table cellpadding="0" cellspacing="0" border="0"><tr><td><input type="submit" name="stem" value="Stem"></td><td><input type="button" value="Vis resultat" onclick="this.form.submit()"></td></tr></table></form>';
}
?>
<br>

Mange tak. MEN det tør jeg ikke løbe an på, det med selv at lave admin delen.
Jeg er parat til og give 500 point hvis du vil lave admin delen også.

Du kan max give 200 point så den går ikke. Desuden er point ligegyldige for mig.

Her er admin delen, men jeg gider ikke rette den til. Det burde dog heller ikke være noget problem. Det eneste der er er at lige i toppen er der noget adgangstjek. Det skal fjernes :)

<?
include("modul_afstemning.cfg.php");
include("side_top.php");
?>
<table align="center" width="95%" cellspacing="0" cellpadding="0" border="0">
<tr><td>
<h3>Afstemninger

<?
if($_REQUEST['side'] == 1) {
$underside = "Se resultater";
if($brugerniveau != 1) {
$brugerniveau_fejl = 1;
}
}

if($_REQUEST['side'] == 2) {
$underside = "Opret ny afstemning";
if($brugerniveau != 1) {
$brugerniveau_fejl = 1;
}
}

if($_REQUEST['side'] == 3) {
$underside = "Ret/slet afstemning";
if($brugerniveau != 1) {
$brugerniveau_fejl = 1;
}
}

if($_REQUEST['side'] == 4) {
$underside = "Indstillinger";
if($brugerniveau != 1) {
$brugerniveau_fejl = 1;
}
}

if(isset($underside)) echo " &raquo; " . $underside;

?>

</h3>
</td></tr>
</table>

<script type="text/javascript">
parent.frames.infoboks.infoboks_overskrift.innerHTML = '<? echo $overskrift; ?>';
top.boges_modul_status.innerHTML = '<? echo $overskrift; if(isset($underside)) echo " &raquo; " . $underside; ?>';
parent.frames.infoboks.tekst.innerHTML = '<?
echo str_replace("
", "<br>", $hjaelpetekst); ?>';
</script>

<?

if(isset($brugerniveau_fejl)) {
$fejl = "Du har ikke det nødvendige adgangsniveau til at se denne side";
echo besked($tak,$fejl);
exit;
}

if($_REQUEST['side'] == 1) {

?>

<fieldset>

<legend><strong>Se resultater</strong></legend>

<?

echo '<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">';
$i = 0;
$sql = 'SELECT * FROM ' . $kundenavn . '_afstemning_spm';
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {

echo '<tr><td style="padding:6px;padding-left:7px" bgcolor="' . $bgcolor . '"><a href="modul_afstemning.php?side=1&id=' . $row['id'] . '">' . $row['spm'] . '</a></td></tr>';


if($_GET['id'] && $_GET['id'] == $row['id']) {

$sql1 = 'SELECT * FROM ' . $kundenavn . '_afstemning_spm WHERE id = "' . $_GET['id'] . '"';
$result1 = mysql_query($sql1);
$row1 = mysql_fetch_array($result1);

echo "";

$sql2 = 'SELECT SUM(antal) AS samlet_antal FROM ' . $kundenavn . '_afstemning_muligheder WHERE spm_id = "' . $row1['id'] . '"';
$result2 = mysql_query($sql2);
$row2 = mysql_fetch_array($result2);

echo "<tr><td style=\"padding:6px;padding-left:7px\">Antal stemmer: " . $row2['samlet_antal'] . "<br></td></tr>";


echo "<tr><td style=\"padding:6px;padding-left:7px\">";

$sql3 = 'SELECT * FROM ' . $kundenavn . '_afstemning_muligheder WHERE spm_id = "' . $row1['id'] . '"';

$result3 = mysql_query($sql3);
while($row3 = mysql_fetch_array($result3)) {

if($row3['antal'] > 0 && $row2['samlet_antal'] > 0) {
$procent = $row3['antal'] / $row2['samlet_antal'] * 100;
}
echo  $row3['svar'] . " (" . round($procent) . " %)<br>";
echo "<span style=\"background-color:#5788BF;width:" . round($procent) . "%\"><img src=\"billeder/spacer.gif\" border=\"0\" width=\"1\" height=\"10px\"></span><br>";
}

echo '</td></tr>';

}

}

echo "</table>";

?>

</fieldset>

<?

}
















if($_REQUEST['side'] == 2) {


if($_REQUEST['trin'] != 2) {
$_SESSION['nyt_array'] = "";
}


$nyt_spm = htmlentities ($_REQUEST['nyt_spm']);

if ($_POST['send'] == 'ok') {

$sql = 'INSERT INTO ' . $kundenavn . '_afstemning_spm (spm) VALUES ("' . $_REQUEST['nyt_spm'] . '")';
mysql_query($sql);

$id = mysql_insert_id();
$svar = $_POST['svar'];
for($i=0; $i < count($svar); $i++) {

$sql = 'INSERT INTO ' . $kundenavn . '_afstemning_muligheder (spm_id, sortering, svar) VALUES ("' . $id . '", "' . $i . '", "' . $svar[$i] . '")';
mysql_query($sql);
}

$tak = "Afstemning oprettet";
$_SESSION['nyt_array'] = "";

$nyt_spm = "";

}

?>

<script language="JavaScript" type="text/javascript">

function valider (form) {

  if (document.form.nyt_spm.value.length > 0 ) {
      // alt ok han har skrevet noget
  } else {
      alert ("Du skal indtaste et spørgsmål");
      document.form.nyt_spm.focus();
      return false;
  };

  if (document.form.svar.value.length > 0) {
      // alt ok han har skrevet noget
  } else {
      alert ("Du skal indtaste mindst 2 svarmuligheder");
      document.form.svar.focus();
      return false;
  };

}

</script>


<? echo besked($tak,$fejl); ?>




<script>
function opret_ny() {
tekst = document.form.ny_mulighed.value;
if(tekst == "") {
alert("Du skal indtaste en ny svarmulighed");
} else {
hvorhen = 'modul_afstemning.php?side=2&trin=2&nyt_spm=' + document.form.nyt_spm.value + '&ny_mulighed=' + tekst;
location.href = hvorhen;
}
}

</script>


<fieldset>

<legend><strong>Opret ny afstemning</strong></legend>

<form name="form" onSubmit="return valider(this)" method="post" action="modul_afstemning.php">
<input name="side" type="hidden" value="2">
<input name="send" type="hidden" value="ok">
<input name="trin" value="2" type="hidden">
<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">
<tr><td width="180" nowrap style="padding:6px;padding-left:7px"><strong>Spørgsmål:</strong> </td><td width="100%" style="padding:6px" colspan="2"><input name="nyt_spm" value="<? echo $nyt_spm; ?>" style="width:100%" type="text" size="40"></td>
</tr>

<tr><td style="padding:6px;padding-left:7px"><strong>Aktiv fra:</strong> </td><td style="padding:6px">

<select name="aktiv_fra_dag" style="width:50px;">
<? $dag_fra = date("d"); ?>
    <option value=1 <? if($dag_fra == 1) echo "selected"; ?>>1</option>
    <option value=2 <? if($dag_fra == 2) echo "selected"; ?>>2</option>
    <option value=3 <? if($dag_fra == 3) echo "selected"; ?>>3</option>
    <option value=4 <? if($dag_fra == 4) echo "selected"; ?>>4</option>
    <option value=5 <? if($dag_fra == 5) echo "selected"; ?>>5</option>
    <option value=6 <? if($dag_fra == 6) echo "selected"; ?>>6</option>
    <option value=7 <? if($dag_fra == 7) echo "selected"; ?>>7</option>
    <option value=8 <? if($dag_fra == 8) echo "selected"; ?>>8</option>
    <option value=9 <? if($dag_fra == 9) echo "selected"; ?>>9</option>
    <option value=10 <? if($dag_fra == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($dag_fra == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($dag_fra == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($dag_fra == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($dag_fra == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($dag_fra == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($dag_fra == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($dag_fra == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($dag_fra == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($dag_fra == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($dag_fra == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($dag_fra == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($dag_fra == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($dag_fra == 23) echo "selected"; ?>>23</option>
    <option value=24 <? if($dag_fra == 24) echo "selected"; ?>>24</option>
    <option value=25 <? if($dag_fra == 25) echo "selected"; ?>>25</option>
    <option value=26 <? if($dag_fra == 26) echo "selected"; ?>>26</option>
    <option value=27 <? if($dag_fra == 27) echo "selected"; ?>>27</option>
    <option value=28 <? if($dag_fra == 28) echo "selected"; ?>>28</option>
    <option value=29 <? if($dag_fra == 29) echo "selected"; ?>>29</option>
    <option value=30 <? if($dag_fra == 30) echo "selected"; ?>>30</option>
    <option value=31 <? if($dag_fra == 31) echo "selected"; ?>>31</option>
</select>
&nbsp;<select name="aktiv_fra_maaned" style="width:60px">
<? $maaned_fra = date("m"); ?>
    <option value=1 <? if($maaned_fra == 1) echo "selected"; ?>>jan</option>
    <option value=2 <? if($maaned_fra == 2) echo "selected"; ?>>feb</option>
    <option value=3 <? if($maaned_fra == 3) echo "selected"; ?>>mar</option>
    <option value=4 <? if($maaned_fra == 4) echo "selected"; ?>>apr</option>
    <option value=5 <? if($maaned_fra == 5) echo "selected"; ?>>maj</option>
    <option value=6 <? if($maaned_fra == 6) echo "selected"; ?>>jun</option>
    <option value=7 <? if($maaned_fra == 7) echo "selected"; ?>>jul</option>
    <option value=8 <? if($maaned_fra == 8) echo "selected"; ?>>aug</option>
    <option value=9 <? if($maaned_fra == 9) echo "selected"; ?>>sep</option>
    <option value=10 <? if($maaned_fra == 10) echo "selected"; ?>>okt</option>
    <option value=11 <? if($maaned_fra == 11) echo "selected"; ?>>nov</option>
    <option value=12 <? if($maaned_fra == 12) echo "selected"; ?>>dec</option>
</select>
&nbsp;<select name="aktiv_fra_aar" style="width:60px">
<? $aar_fra = date("Y"); ?>
    <option value=2003 <? if($aar_fra == 2003) echo "selected"; ?>>2003</option>
    <option value=2004 <? if($aar_fra == 2004) echo "selected"; ?>>2004</option>
    <option value=2005 <? if($aar_fra == 2005) echo "selected"; ?>>2005</option>
    <option value=2006 <? if($aar_fra == 2006) echo "selected"; ?>>2006</option>
    <option value=2007 <? if($aar_fra == 2007) echo "selected"; ?>>2007</option>
    <option value=2008 <? if($aar_fra == 2008) echo "selected"; ?>>2008</option>
    <option value=2999>Altid</option>
</select>
&nbsp;&nbsp;kl:&nbsp;<select name="aktiv_fra_time" style="width:40px">
    <option value=0 <? if($time_fra == 0) echo "selected"; ?>>00</option>
    <option value=1 <? if($time_fra == 1) echo "selected"; ?>>01</option>
    <option value=2 <? if($time_fra == 2) echo "selected"; ?>>02</option>
    <option value=3 <? if($time_fra == 3) echo "selected"; ?>>03</option>
    <option value=4 <? if($time_fra == 4) echo "selected"; ?>>04</option>
    <option value=5 <? if($time_fra == 5) echo "selected"; ?>>05</option>
    <option value=6 <? if($time_fra == 6) echo "selected"; ?>>06</option>
    <option value=7 <? if($time_fra == 7) echo "selected"; ?>>07</option>
    <option value=8 <? if($time_fra == 8) echo "selected"; ?>>08</option>
    <option value=9 <? if($time_fra == 9) echo "selected"; ?>>09</option>
    <option value=10 <? if($time_fra == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($time_fra == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($time_fra == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($time_fra == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($time_fra == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($time_fra == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($time_fra == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($time_fra == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($time_fra == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($time_fra == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($time_fra == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($time_fra == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($time_fra == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($time_fra == 23) echo "selected"; ?>>23</option>
</select>
&nbsp;<select name="aktiv_fra_minut" style="width:40px">
    <option value="00" <? if($minut_fra == 00) echo "selected"; ?>>00</option>
    <option value="15" <? if($minut_fra == 15) echo "selected"; ?>>15</option>
    <option value="30" <? if($minut_fra == 30) echo "selected"; ?>>30</option>
    <option value="45" <? if($minut_fra == 45) echo "selected"; ?>>45</option>
</select>

</td></tr>

<tr><td style="padding:6px;padding-left:7px"><strong>Aktiv til:</strong> </td><td style="padding:6px">

<select name="aktiv_til_dag" style="width:50px;">
<? $dag_til = date("d", time()+60*60*24*366); ?>
    <option value=1 <? if($dag_til == 1) echo "selected"; ?>>1</option>
    <option value=2 <? if($dag_til == 2) echo "selected"; ?>>2</option>
    <option value=3 <? if($dag_til == 3) echo "selected"; ?>>3</option>
    <option value=4 <? if($dag_til == 4) echo "selected"; ?>>4</option>
    <option value=5 <? if($dag_til == 5) echo "selected"; ?>>5</option>
    <option value=6 <? if($dag_til == 6) echo "selected"; ?>>6</option>
    <option value=7 <? if($dag_til == 7) echo "selected"; ?>>7</option>
    <option value=8 <? if($dag_til == 8) echo "selected"; ?>>8</option>
    <option value=9 <? if($dag_til == 9) echo "selected"; ?>>9</option>
    <option value=10 <? if($dag_til == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($dag_til == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($dag_til == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($dag_til == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($dag_til == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($dag_til == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($dag_til == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($dag_til == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($dag_til == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($dag_til == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($dag_til == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($dag_til == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($dag_til == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($dag_til == 23) echo "selected"; ?>>23</option>
    <option value=24 <? if($dag_til == 24) echo "selected"; ?>>24</option>
    <option value=25 <? if($dag_til == 25) echo "selected"; ?>>25</option>
    <option value=26 <? if($dag_til == 26) echo "selected"; ?>>26</option>
    <option value=27 <? if($dag_til == 27) echo "selected"; ?>>27</option>
    <option value=28 <? if($dag_til == 28) echo "selected"; ?>>28</option>
    <option value=29 <? if($dag_til == 29) echo "selected"; ?>>29</option>
    <option value=30 <? if($dag_til == 30) echo "selected"; ?>>30</option>
    <option value=31 <? if($dag_til == 31) echo "selected"; ?>>31</option>
</select>
&nbsp;<select name="aktiv_til_maaned" style="width:60px">
<? $maaned_til = date("m", time()+60*60*24*366); ?>
    <option value=1 <? if($maaned_til == 1) echo "selected"; ?>>jan</option>
    <option value=2 <? if($maaned_til == 2) echo "selected"; ?>>feb</option>
    <option value=3 <? if($maaned_til == 3) echo "selected"; ?>>mar</option>
    <option value=4 <? if($maaned_til == 4) echo "selected"; ?>>apr</option>
    <option value=5 <? if($maaned_til == 5) echo "selected"; ?>>maj</option>
    <option value=6 <? if($maaned_til == 6) echo "selected"; ?>>jun</option>
    <option value=7 <? if($maaned_til == 7) echo "selected"; ?>>jul</option>
    <option value=8 <? if($maaned_til == 8) echo "selected"; ?>>aug</option>
    <option value=9 <? if($maaned_til == 9) echo "selected"; ?>>sep</option>
    <option value=10 <? if($maaned_til == 10) echo "selected"; ?>>okt</option>
    <option value=11 <? if($maaned_til == 11) echo "selected"; ?>>nov</option>
    <option value=12 <? if($maaned_til == 12) echo "selected"; ?>>dec</option>
</select>
&nbsp;<select name="aktiv_til_aar" style="width:60px">
<? $aar_til = date("Y", time()+60*60*24*366); ?>
    <option value=2003 <? if($aar_til == 2003) echo "selected"; ?>>2003</option>
    <option value=2004 <? if($aar_til == 2004) echo "selected"; ?>>2004</option>
    <option value=2005 <? if($aar_til == 2005) echo "selected"; ?>>2005</option>
    <option value=2006 <? if($aar_til == 2006) echo "selected"; ?>>2006</option>
    <option value=2007 <? if($aar_til == 2007) echo "selected"; ?>>2007</option>
    <option value=2008 <? if($aar_til == 2008) echo "selected"; ?>>2008</option>
    <option value=2999>Altid</option>
</select>
&nbsp;&nbsp;kl:&nbsp;<select name="aktiv_til_time" style="width:40px">
    <option value=0 <? if($time_til == 0) echo "selected"; ?>>00</option>
    <option value=1 <? if($time_til == 1) echo "selected"; ?>>01</option>
    <option value=2 <? if($time_til == 2) echo "selected"; ?>>02</option>
    <option value=3 <? if($time_til == 3) echo "selected"; ?>>03</option>
    <option value=4 <? if($time_til == 4) echo "selected"; ?>>04</option>
    <option value=5 <? if($time_til == 5) echo "selected"; ?>>05</option>
    <option value=6 <? if($time_til == 6) echo "selected"; ?>>06</option>
    <option value=7 <? if($time_til == 7) echo "selected"; ?>>07</option>
    <option value=8 <? if($time_til == 8) echo "selected"; ?>>08</option>
    <option value=9 <? if($time_til == 9) echo "selected"; ?>>09</option>
    <option value=10 <? if($time_til == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($time_til == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($time_til == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($time_til == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($time_til == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($time_til == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($time_til == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($time_til == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($time_til == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($time_til == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($time_til == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($time_til == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($time_til == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($time_til == 23) echo "selected"; ?>>23</option>
</select>
&nbsp;<select name="aktiv_til_minut" style="width:40px">
    <option value="00" <? if($minut_til == 00) echo "selected"; ?>>00</option>
    <option value="15" <? if($minut_til == 15) echo "selected"; ?>>15</option>
    <option value="30" <? if($minut_til == 30) echo "selected"; ?>>30</option>
    <option value="45" <? if($minut_til == 45) echo "selected"; ?>>45</option>
</select>

</td></tr>
</table>

</fieldset>
<br><br>

<fieldset>

<legend><strong>Svarmuligheder</strong></legend>

<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">

<?
$i = 0;
$i2 = 0;

if($_REQUEST['ny_mulighed'] != "") {
$_SESSION['nyt_array'][] = $_REQUEST['ny_mulighed'];
}

if($_REQUEST['fjern'] > -1) {
$_SESSION['nyt_array'][$_REQUEST['fjern']] = "";
}


if(is_array($_SESSION['nyt_array'])) {

foreach($_SESSION['nyt_array'] as $v) {
if($v != "") {



$i2++;
?>


<tr><td style="padding:6px;padding-left:7px" width="180" nowrap><strong>Svarmulighed <? echo $i2; ?></strong>:</td><td width="100%" style="padding:6px"><input name="svar[]" style="width:100%" type="text" value="<? echo $v; ?>" size="40"></td><td style="padding:6px"><input type="button" class="knap" value=" Fjern " onclick="location.href='modul_afstemning.php?side=2&trin=2&nyt_spm=<? echo $nyt_spm; ?>&fjern=<? echo $i; ?>'"></td></tr>
<?

}
$i++;
}

}

if($i2 == 0) {

$_SESSION['nyt_array'] = "";
}

?>





<tr><td style="padding:6px;padding-left:7px" width="180" nowrap><strong>Tilføj ny svarmulighed:</strong> </td><td width="100%" style="padding:6px" colspan="2"><input type="text" name="ny_mulighed" style="width:100%" size="30"></td></tr>
<tr><td></td><td style="padding:6px" colspan="2"><input type="button" class="knap" value="Tilføj svarmulighed" onclick="opret_ny()">&nbsp;<input type="submit" class="knap" value="Opret afstemning"></td></tr>


</table>
</form>


</fieldset>






<?PHP
}
















if($_REQUEST['side'] == 3) {

$id = $_REQUEST['afstemning'];

if($_REQUEST["aktiv$id"] == 1) {
$sql = 'UPDATE ' . $kundenavn . '_afstemning_spm SET aktiv=1 WHERE id = "' . $_REQUEST['afstemning'] . '"';
$result = mysql_query($sql) or die(mysql_error());
$tak = "Afstemning aktiveret";
}

if(isset($_REQUEST["aktiv$id"]) && $_REQUEST["aktiv$id"] == 0) {
$sql = 'UPDATE ' . $kundenavn . '_afstemning_spm SET aktiv=0 WHERE id = "' . $_REQUEST['afstemning'] . '"';
$result = mysql_query($sql) or die(mysql_error());
$tak = "Afstemning deaktiveret";
}



if($_REQUEST['fjern'] != "") {
$sql = 'DELETE FROM ' . $kundenavn . '_afstemning_muligheder WHERE id = "' . $_REQUEST['fjern'] . '"';
$tak = "Svarmulighed fjernet";
$result = mysql_query($sql) or die(mysql_error());
}

if($_REQUEST['slet'] == "ok") {
$sql = 'DELETE FROM ' . $kundenavn . '_afstemning_spm WHERE id = "' . $_REQUEST['id'] . '"';
$result = mysql_query($sql) or die(mysql_error());
$sql = 'DELETE FROM ' . $kundenavn . '_afstemning_muligheder WHERE spm_id = "' . $_REQUEST['id'] . '"';
$result = mysql_query($sql) or die(mysql_error());
$tak = "Afstemning slettet";
}

if($_REQUEST['nulstil'] == "ok") {
$sql = 'UPDATE ' . $kundenavn . '_afstemning_muligheder SET antal=0 WHERE spm_id = "' . $_REQUEST['afstemning'] . '"';
$result = mysql_query($sql) or die(mysql_error());
$tak = "Afstemning nulstillet";
}

if($_POST['send'] == "ok") {

$ny_mulighed = htmlentities ($_POST['ny_mulighed']);
$nyt_spm = htmlentities ($_POST['nyt_spm']);

if($ny_mulighed != "") {
$sql = 'INSERT INTO ' . $kundenavn . '_afstemning_muligheder (spm_id, svar) VALUES ("' . $_POST['afstemning'] . '","' . $ny_mulighed . '")';
mysql_query($sql) or die(mysql_error());
}


if (checkdate($_REQUEST['aktiv_fra_maaned'],$_REQUEST['aktiv_fra_dag'],$_REQUEST['aktiv_fra_aar'])) {
$dag = $_REQUEST['aktiv_fra_dag'];
if(strlen($dag) == 1) {
$dag = "0" . $dag;
}

$maaned = $_REQUEST['aktiv_fra_maaned'];
$aar = $_REQUEST['aktiv_fra_aar'];
$time = $_REQUEST['aktiv_fra_time'];
$minut = $_REQUEST['aktiv_fra_minut'];

$aktiv_fra = $aar . "-" . $maaned . "-" . $dag . " " . $time . ":" . $minut . ":00";

} else {

$fejl = "fra";

}


if (checkdate($_REQUEST['aktiv_til_maaned'],$_REQUEST['aktiv_til_dag'],$_REQUEST['aktiv_til_aar'])) {
$dag = $_REQUEST['aktiv_til_dag'];
if(strlen($dag) == 1) {
$dag = "0" . $dag;
}

$maaned = $_REQUEST['aktiv_til_maaned'];
$aar = $_REQUEST['aktiv_til_aar'];
$time = $_REQUEST['aktiv_til_time'];
$minut = $_REQUEST['aktiv_til_minut'];

$aktiv_til = $aar . "-" . $maaned . "-" . $dag . " " . $time . ":" . $minut . ":00";

} else {

$fejl = "til";

}


if($fejl != "") {

if($fejl == "fra") {

$fejl = "Den valgte \"Aktiv fra\" dato er ugyldig";

}

if($fejl == "til") {

$fejl = "Den valgte \"Aktiv til\" dato er ugyldig";

}

} else {

$sql = 'UPDATE ' . $kundenavn . '_afstemning_spm SET spm="' . $nyt_spm . '", aktiv_fra = "' . $aktiv_fra . '", aktiv_til = "' . $aktiv_til . '" WHERE id=' . $_POST['afstemning'];
mysql_query($sql) or die(mysql_error());


$svar = $_REQUEST['svar'];
$id = $_REQUEST['id'];
for($i=0; $i < count($svar); $i++) {
$svar_id = $id[$i];
$svar_spm = $svar[$i];
$sql = 'UPDATE ' . $kundenavn . '_afstemning_muligheder SET svar = "' . $svar_spm . '" WHERE id = "' . $svar_id . '"';
mysql_query($sql);
}

$tak = "Afstemning rettet";

}

}

if($_REQUEST['trin'] == "") {


?>

<? echo besked($tak,$fejl); ?>

<fieldset>

<legend><strong>Ret/slet afstemning</strong></legend>

<form name="form1" action="modul_afstemning.php" method="post">
<input type="hidden" name="valg" value="afstemninger">
<input type="hidden" name="side" value="3">
<input type="hidden" name="afstemning">
<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">
<?
$sql = 'SELECT * FROM ' . $kundenavn . '_afstemning_spm ORDER BY id DESC';
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)) {


$dag_fra = substr($row['aktiv_fra'], 8, 2);
$maaned_fra = substr($row['aktiv_fra'], 5, 2);
$aar_fra = substr($row['aktiv_fra'], 0, 4);
$time_fra = substr($row['aktiv_fra'], 11, 2);
$minut_fra = substr($row['aktiv_fra'], 14, 2);

if($maaned_fra == 1) $maaned_fra = "jan";
if($maaned_fra == 2) $maaned_fra = "feb";
if($maaned_fra == 3) $maaned_fra = "mar";
if($maaned_fra == 4) $maaned_fra = "apr";
if($maaned_fra == 5) $maaned_fra = "maj";
if($maaned_fra == 6) $maaned_fra = "jun";
if($maaned_fra == 7) $maaned_fra = "jul";
if($maaned_fra == 8) $maaned_fra = "aug";
if($maaned_fra == 9) $maaned_fra = "sep";
if($maaned_fra == 10) $maaned_fra = "okt";
if($maaned_fra == 11) $maaned_fra = "nov";
if($maaned_fra == 12) $maaned_fra = "dec";

$fra = $dag_fra . " " . $maaned_fra. " " . $aar_fra;

$dag_til = substr($row['aktiv_til'], 8, 2);
$maaned_til = substr($row['aktiv_til'], 5, 2);
$aar_til = substr($row['aktiv_til'], 0, 4);
$time_til = substr($row['aktiv_til'], 11, 2);
$minut_til = substr($row['aktiv_til'], 14, 2);

if($maaned_til == 1) $maaned_til = "jan";
if($maaned_til == 2) $maaned_til = "feb";
if($maaned_til == 3) $maaned_til = "mar";
if($maaned_til == 4) $maaned_til = "apr";
if($maaned_til == 5) $maaned_til = "maj";
if($maaned_til == 6) $maaned_til = "jun";
if($maaned_til == 7) $maaned_til = "jul";
if($maaned_til == 8) $maaned_til = "aug";
if($maaned_til == 9) $maaned_til = "sep";
if($maaned_til == 10) $maaned_til = "okt";
if($maaned_til == 11) $maaned_til = "nov";
if($maaned_til == 12) $maaned_til = "dec";

$til = $dag_til . " " . $maaned_til . " " . $aar_til;

$i++;

$aktiv = "";
$aktiv2 = "";

if($row['aktiv'] == 1) {
$aktiv = "checked";
} else {
$aktiv2 = "checked";
}

echo "<tr><td style=\"padding:6px;padding-left:7px\" width=\"100%\"><strong>$row[spm]</strong></td><td width=\"200\" nowrap>";

if($aktiv != "") {
echo "<span style=\"color:#5788BF\">Aktiv $fra - $til</span>";
}

if($aktiv2 != "") {
echo "<span style=\"color:red\">Ikke aktiv</span>";
}

echo "</td><td><input type=\"radio\" onclick=\"form1.afstemning.value='$row[id]';this.form.submit()\" name=\"aktiv$row[id]\" value=\"1\" $aktiv></td><td>Aktiv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td><input type=\"radio\" onclick=\"form1.afstemning.value='$row[id]';this.form.submit()\" name=\"aktiv$row[id]\" value=\"0\" $aktiv2></td><td>Ikke&nbsp;aktiv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td style=\"padding:6px\"><input type=\"button\" class=\"knap\" value=\" Ret \" onclick=\"location.href='modul_afstemning.php?side=3&trin=2&afstemning=$row[id]'\">&nbsp;<input type=\"button\" class=\"knap\" value=\" Nulstil \" onclick=\"decision('Nulstil afstemning?','modul_afstemning.php?side=3&nulstil=ok&id=$row[id]','')\">&nbsp;<input type=\"button\" class=\"knap\" value=\" Slet \" onclick=\"decision('Slet afstemning?','modul_afstemning.php?side=3&slet=ok&id=$row[id]','')\"></td></tr>";
}
?>
</table>
</form>

</fieldset>

<?

}

if($_REQUEST['trin'] == "2") {

$sql = 'SELECT * FROM ' . $kundenavn . '_afstemning_spm WHERE id="' . $_REQUEST['afstemning'] . '"';
$result = mysql_query($sql) or die(mysql_error());
$row_udtraek = mysql_fetch_array($result);

$dag_fra = substr($row_udtraek['aktiv_fra'], 8, 2);
$maaned_fra = substr($row_udtraek['aktiv_fra'], 5, 2);
$aar_fra = substr($row_udtraek['aktiv_fra'], 0, 4);
$time_fra = substr($row_udtraek['aktiv_fra'], 11, 2);
$minut_fra = substr($row_udtraek['aktiv_fra'], 14, 2);

$dag_til = substr($row_udtraek['aktiv_til'], 8, 2);
$maaned_til = substr($row_udtraek['aktiv_til'], 5, 2);
$aar_til = substr($row_udtraek['aktiv_til'], 0, 4);
$time_til = substr($row_udtraek['aktiv_til'], 11, 2);
$minut_til = substr($row_udtraek['aktiv_til'], 14, 2);

?>

<script type="text/javascript">

function valider (form) {

  if (document.form.nyt_spm.value.length > 0 ) {
      // alt ok han har skrevet noget
  } else {
      alert ("Du skal indtaste et spørgsmål");
      document.form.nyt_spm.focus();
      return false;
  };

  if (document.form.svar1.value.length > 0) {
      // alt ok han har skrevet noget
  } else {
      alert ("Du skal indtaste mindst 2 svarmuligheder");
      document.form.svar1.focus();
      return false;
  };
 
  if (document.form.svar2.value.length > 0) {
      // alt ok han har skrevet noget
  } else {
      alert ("Du skal indtaste mindst 2 svarmuligheder");
      document.form.svar2.focus();
      return false;
  };
 

 
}

</script>

<? echo besked($tak,$fejl); ?>

<fieldset>

<legend><strong>Ret/slet afstemning</strong></legend>

<form name="form" onSubmit="return valider(this)" action="modul_afstemning.php" method="post">
<input type="hidden" name="send" value="ok">
<input type="hidden" name="side" value="3">
<input type="hidden" name="trin" value="2">
<input type="hidden" name="afstemning" value="<? echo $_REQUEST['afstemning']; ?>">
<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">
<tr><td style="padding:6px;padding-left:7px" width="180" nowrap><strong>Spørgsmål:</strong> </td><td style="padding:6px" width="100%" colspan="2"><input name="nyt_spm" value="<? echo $row_udtraek['spm']; ?>" style="width:100%" type="text" size="40"></td>
</tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Aktiv fra:</strong> </td><td style="padding:6px" colspan="2">

<select name="aktiv_fra_dag" style="width:50px;">
    <option value=1 <? if($dag_fra == 1) echo "selected"; ?>>1</option>
    <option value=2 <? if($dag_fra == 2) echo "selected"; ?>>2</option>
    <option value=3 <? if($dag_fra == 3) echo "selected"; ?>>3</option>
    <option value=4 <? if($dag_fra == 4) echo "selected"; ?>>4</option>
    <option value=5 <? if($dag_fra == 5) echo "selected"; ?>>5</option>
    <option value=6 <? if($dag_fra == 6) echo "selected"; ?>>6</option>
    <option value=7 <? if($dag_fra == 7) echo "selected"; ?>>7</option>
    <option value=8 <? if($dag_fra == 8) echo "selected"; ?>>8</option>
    <option value=9 <? if($dag_fra == 9) echo "selected"; ?>>9</option>
    <option value=10 <? if($dag_fra == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($dag_fra == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($dag_fra == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($dag_fra == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($dag_fra == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($dag_fra == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($dag_fra == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($dag_fra == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($dag_fra == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($dag_fra == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($dag_fra == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($dag_fra == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($dag_fra == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($dag_fra == 23) echo "selected"; ?>>23</option>
    <option value=24 <? if($dag_fra == 24) echo "selected"; ?>>24</option>
    <option value=25 <? if($dag_fra == 25) echo "selected"; ?>>25</option>
    <option value=26 <? if($dag_fra == 26) echo "selected"; ?>>26</option>
    <option value=27 <? if($dag_fra == 27) echo "selected"; ?>>27</option>
    <option value=28 <? if($dag_fra == 28) echo "selected"; ?>>28</option>
    <option value=29 <? if($dag_fra == 29) echo "selected"; ?>>29</option>
    <option value=30 <? if($dag_fra == 30) echo "selected"; ?>>30</option>
    <option value=31 <? if($dag_fra == 31) echo "selected"; ?>>31</option>
</select>
&nbsp;<select name="aktiv_fra_maaned" style="width:60px">
    <option value=1 <? if($maaned_fra == 1) echo "selected"; ?>>jan</option>
    <option value=2 <? if($maaned_fra == 2) echo "selected"; ?>>feb</option>
    <option value=3 <? if($maaned_fra == 3) echo "selected"; ?>>mar</option>
    <option value=4 <? if($maaned_fra == 4) echo "selected"; ?>>apr</option>
    <option value=5 <? if($maaned_fra == 5) echo "selected"; ?>>maj</option>
    <option value=6 <? if($maaned_fra == 6) echo "selected"; ?>>jun</option>
    <option value=7 <? if($maaned_fra == 7) echo "selected"; ?>>jul</option>
    <option value=8 <? if($maaned_fra == 8) echo "selected"; ?>>aug</option>
    <option value=9 <? if($maaned_fra == 9) echo "selected"; ?>>sep</option>
    <option value=10 <? if($maaned_fra == 10) echo "selected"; ?>>okt</option>
    <option value=11 <? if($maaned_fra == 11) echo "selected"; ?>>nov</option>
    <option value=12 <? if($maaned_fra == 12) echo "selected"; ?>>dec</option>
</select>
&nbsp;<select name="aktiv_fra_aar" style="width:60px">
    <option value=2003 <? if($aar_fra == 2003) echo "selected"; ?>>2003</option>
    <option value=2004 <? if($aar_fra == 2004) echo "selected"; ?>>2004</option>
    <option value=2005 <? if($aar_fra == 2005) echo "selected"; ?>>2005</option>
    <option value=2006 <? if($aar_fra == 2006) echo "selected"; ?>>2006</option>
    <option value=2007 <? if($aar_fra == 2007) echo "selected"; ?>>2007</option>
    <option value=2008 <? if($aar_fra == 2008) echo "selected"; ?>>2008</option>
    <option value=2999>Altid</option>
</select>
&nbsp;&nbsp;kl:&nbsp;<select name="aktiv_fra_time" style="width:40px">
    <option value=0 <? if($time_fra == 0) echo "selected"; ?>>00</option>
    <option value=1 <? if($time_fra == 1) echo "selected"; ?>>01</option>
    <option value=2 <? if($time_fra == 2) echo "selected"; ?>>02</option>
    <option value=3 <? if($time_fra == 3) echo "selected"; ?>>03</option>
    <option value=4 <? if($time_fra == 4) echo "selected"; ?>>04</option>
    <option value=5 <? if($time_fra == 5) echo "selected"; ?>>05</option>
    <option value=6 <? if($time_fra == 6) echo "selected"; ?>>06</option>
    <option value=7 <? if($time_fra == 7) echo "selected"; ?>>07</option>
    <option value=8 <? if($time_fra == 8) echo "selected"; ?>>08</option>
    <option value=9 <? if($time_fra == 9) echo "selected"; ?>>09</option>
    <option value=10 <? if($time_fra == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($time_fra == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($time_fra == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($time_fra == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($time_fra == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($time_fra == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($time_fra == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($time_fra == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($time_fra == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($time_fra == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($time_fra == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($time_fra == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($time_fra == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($time_fra == 23) echo "selected"; ?>>23</option>
</select>
&nbsp;<select name="aktiv_fra_minut" style="width:40px">
    <option value="00" <? if($minut_fra == 00) echo "selected"; ?>>00</option>
    <option value="15" <? if($minut_fra == 15) echo "selected"; ?>>15</option>
    <option value="30" <? if($minut_fra == 30) echo "selected"; ?>>30</option>
    <option value="45" <? if($minut_fra == 45) echo "selected"; ?>>45</option>
</select>

</td></tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Aktiv til:</strong> </td><td style="padding:6px" colspan="2">

<select name="aktiv_til_dag" style="width:50px;">
    <option value=1 <? if($dag_til == 1) echo "selected"; ?>>1</option>
    <option value=2 <? if($dag_til == 2) echo "selected"; ?>>2</option>
    <option value=3 <? if($dag_til == 3) echo "selected"; ?>>3</option>
    <option value=4 <? if($dag_til == 4) echo "selected"; ?>>4</option>
    <option value=5 <? if($dag_til == 5) echo "selected"; ?>>5</option>
    <option value=6 <? if($dag_til == 6) echo "selected"; ?>>6</option>
    <option value=7 <? if($dag_til == 7) echo "selected"; ?>>7</option>
    <option value=8 <? if($dag_til == 8) echo "selected"; ?>>8</option>
    <option value=9 <? if($dag_til == 9) echo "selected"; ?>>9</option>
    <option value=10 <? if($dag_til == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($dag_til == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($dag_til == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($dag_til == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($dag_til == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($dag_til == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($dag_til == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($dag_til == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($dag_til == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($dag_til == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($dag_til == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($dag_til == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($dag_til == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($dag_til == 23) echo "selected"; ?>>23</option>
    <option value=24 <? if($dag_til == 24) echo "selected"; ?>>24</option>
    <option value=25 <? if($dag_til == 25) echo "selected"; ?>>25</option>
    <option value=26 <? if($dag_til == 26) echo "selected"; ?>>26</option>
    <option value=27 <? if($dag_til == 27) echo "selected"; ?>>27</option>
    <option value=28 <? if($dag_til == 28) echo "selected"; ?>>28</option>
    <option value=29 <? if($dag_til == 29) echo "selected"; ?>>29</option>
    <option value=30 <? if($dag_til == 30) echo "selected"; ?>>30</option>
    <option value=31 <? if($dag_til == 31) echo "selected"; ?>>31</option>
</select>
&nbsp;<select name="aktiv_til_maaned" style="width:60px">
    <option value=1 <? if($maaned_til == 1) echo "selected"; ?>>jan</option>
    <option value=2 <? if($maaned_til == 2) echo "selected"; ?>>feb</option>
    <option value=3 <? if($maaned_til == 3) echo "selected"; ?>>mar</option>
    <option value=4 <? if($maaned_til == 4) echo "selected"; ?>>apr</option>
    <option value=5 <? if($maaned_til == 5) echo "selected"; ?>>maj</option>
    <option value=6 <? if($maaned_til == 6) echo "selected"; ?>>jun</option>
    <option value=7 <? if($maaned_til == 7) echo "selected"; ?>>jul</option>
    <option value=8 <? if($maaned_til == 8) echo "selected"; ?>>aug</option>
    <option value=9 <? if($maaned_til == 9) echo "selected"; ?>>sep</option>
    <option value=10 <? if($maaned_til == 10) echo "selected"; ?>>okt</option>
    <option value=11 <? if($maaned_til == 11) echo "selected"; ?>>nov</option>
    <option value=12 <? if($maaned_til == 12) echo "selected"; ?>>dec</option>
</select>
&nbsp;<select name="aktiv_til_aar" style="width:60px">
    <option value=2003 <? if($aar_til == 2003) echo "selected"; ?>>2003</option>
    <option value=2004 <? if($aar_til == 2004) echo "selected"; ?>>2004</option>
    <option value=2005 <? if($aar_til == 2005) echo "selected"; ?>>2005</option>
    <option value=2006 <? if($aar_til == 2006) echo "selected"; ?>>2006</option>
    <option value=2007 <? if($aar_til == 2007) echo "selected"; ?>>2007</option>
    <option value=2008 <? if($aar_til == 2008) echo "selected"; ?>>2008</option>
    <option value=2999>Altid</option>
</select>
&nbsp;&nbsp;kl:&nbsp;<select name="aktiv_til_time" style="width:40px">
    <option value=0 <? if($time_til == 0) echo "selected"; ?>>00</option>
    <option value=1 <? if($time_til == 1) echo "selected"; ?>>01</option>
    <option value=2 <? if($time_til == 2) echo "selected"; ?>>02</option>
    <option value=3 <? if($time_til == 3) echo "selected"; ?>>03</option>
    <option value=4 <? if($time_til == 4) echo "selected"; ?>>04</option>
    <option value=5 <? if($time_til == 5) echo "selected"; ?>>05</option>
    <option value=6 <? if($time_til == 6) echo "selected"; ?>>06</option>
    <option value=7 <? if($time_til == 7) echo "selected"; ?>>07</option>
    <option value=8 <? if($time_til == 8) echo "selected"; ?>>08</option>
    <option value=9 <? if($time_til == 9) echo "selected"; ?>>09</option>
    <option value=10 <? if($time_til == 10) echo "selected"; ?>>10</option>
    <option value=11 <? if($time_til == 11) echo "selected"; ?>>11</option>
    <option value=12 <? if($time_til == 12) echo "selected"; ?>>12</option>
    <option value=13 <? if($time_til == 13) echo "selected"; ?>>13</option>
    <option value=14 <? if($time_til == 14) echo "selected"; ?>>14</option>
    <option value=15 <? if($time_til == 15) echo "selected"; ?>>15</option>
    <option value=16 <? if($time_til == 16) echo "selected"; ?>>16</option>
    <option value=17 <? if($time_til == 17) echo "selected"; ?>>17</option>
    <option value=18 <? if($time_til == 18) echo "selected"; ?>>18</option>
    <option value=19 <? if($time_til == 19) echo "selected"; ?>>19</option>
    <option value=20 <? if($time_til == 20) echo "selected"; ?>>20</option>
    <option value=21 <? if($time_til == 21) echo "selected"; ?>>21</option>
    <option value=22 <? if($time_til == 22) echo "selected"; ?>>22</option>
    <option value=23 <? if($time_til == 23) echo "selected"; ?>>23</option>
</select>
&nbsp;<select name="aktiv_til_minut" style="width:40px">
    <option value="00" <? if($minut_til == 00) echo "selected"; ?>>00</option>
    <option value="15" <? if($minut_til == 15) echo "selected"; ?>>15</option>
    <option value="30" <? if($minut_til == 30) echo "selected"; ?>>30</option>
    <option value="45" <? if($minut_til == 45) echo "selected"; ?>>45</option>
</select>

</td></tr>
</table>

</fieldset>
<br>
<br>

<fieldset>

<legend><strong>Nuværende svarmuligheder</strong></legend>

<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">

<?
$i = 0;
$sql2 = 'SELECT * FROM ' . $kundenavn . '_afstemning_muligheder WHERE spm_id="' . $_REQUEST['afstemning'] . '" ORDER BY sortering';
$result2 = mysql_query($sql2) or die(mysql_error());
while($row2 = mysql_fetch_array($result2)) {

$i++;

?>

<tr>
<td style="padding:6px;padding-left:7px" width="180" nowrap><strong>Svarmulighed <? echo $i; ?></strong>:</td><td width="100%" style="padding:6px"><input name="id[]" value="<? echo $row2['id']; ?>" type="hidden"><input name="svar[]" value="<? echo $row2['svar']; ?>" style="width:100%" type="text" size="40"></td><td style="padding:6px"><input type="button" class="knap" value=" Fjern " onclick="location.href='modul_afstemning.php?side=3&trin=2&afstemning=<? echo $_REQUEST['afstemning']; ?>&fjern=<? echo $row2['id']; ?>'">
</tr>

<?
}
?>




<tr><td></td><td style="padding:6px;padding-left:7px"><input type="submit" class="knap"  value="Gem ændringer">&nbsp;<input type="button" class="knap" onclick="decision('Slet afstemning?','modul_afstemning.php?side=3&slet=ok&id=<? echo $_POST['afstemning']; ?>','')"  value="Slet afstemning">&nbsp;<input type="button" class="knap" onclick="decision('Nulstil afstemning?','modul_afstemning.php?side=3&trin=2&nulstil=ok&afstemning=<? echo $_REQUEST['afstemning']; ?>','')"  value="Nulstil afstemning"></td>
</tr>
</table>

</fieldset>
<br>
<br>

<fieldset>

<legend><strong>Tilføj svarmulighed</strong></legend>
<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">
<tr><td width="180" nowrap style="padding:6px;padding-left:7px"><strong>Tilføj ny svarmulighed:</strong> </td><td width="100%" colspan="2" style="padding:6px"><input type="text" name="ny_mulighed" style="width:100%" size="30"></td></tr>

<tr><td></td><td style="padding:6px;padding-left:7px"><input type="button" class="knap"  value="Tilføj svarmulighed" onclick="this.form.submit()"></td></tr>

</table>
</form>

</fieldset>

<?
}

}














if($_REQUEST['side'] == 4) {

if($_POST['send'] == 'ok') {
$indhold = $_POST['indhold'];

$sql = 'UPDATE ' . $kundenavn . '_afstemning_indstillinger SET indhold ="' . $indhold . '"';
$result = mysql_query($sql) or die(mysql_error());
$tak = "Indstillinger opdateret";
}

$sql = 'SELECT * FROM ' . $kundenavn . '_afstemning_indstillinger';
$result = mysql_query($sql) or die(mysql_error());
if(!mysql_num_rows($result)) {
$sql2 = 'INSERT INTO ' . $kundenavn . '_afstemning_indstillinger (indhold) VALUES("")';
$result2 = mysql_query($sql2) or die(mysql_error());
}
$row = mysql_fetch_array($result);

?>

<? echo besked($tak,$fejl); ?>

<fieldset>

<legend><strong>Indstillinger</strong></legend>

<form name="form1" method="post" action="modul_afstemning.php">
<input type="hidden" name="side" value="4">
<input type="hidden" name="send" value="ok">



<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0">
<tr><td valign="top" style="padding:6px;padding-left:7px" width="180" nowrap>Tekst til afstemnings oversigt</td><td style="padding:6px" valign="top" width="100%">

<textarea name="indhold" style="width:100%; height:347px">
<? echo $row['indhold']; ?>
</textarea>

<script language="javascript1.2">
editor_generate('indhold');
</script>

</td></tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Tekst på stem knap:</strong> </td><td style="padding:6px"><input type="text" value="<? echo $row['besked1']; ?>" style="width:100%" name="besked1"></td></tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Tekst på vis resultat knap:</strong> </td><td style="padding:6px"><input type="text" value="<? echo $row['besked2']; ?>" style="width:100%" name="besked2"></td></tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Tekst på link til tidligere afstemninger:</strong> </td><td style="padding:6px"><input type="text" value="<? echo $row['besked3']; ?>" style="width:100%" name="besked3"></td></tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Tekst til visning af antal stemmer:</strong> </td><td style="padding:6px"><input type="text" value="<? echo $row['besked4']; ?>" style="width:100%" name="besked4"></td></tr>
<tr><td style="padding:6px;padding-left:7px"><strong>Tekst der vises hvis der ingen afstemninger er:</strong> </td><td style="padding:6px"><input type="text" value="<? echo $row['besked5']; ?>" style="width:100%" name="besked5"></td></tr>
<tr><td></td><td style="padding:6px"><input type="submit" class="knap"  value="Gem ændringer"></td></tr>


</table>
</form>

</fieldset>

<?
}
?>

TAK TAK
Det adgangstjek du snakker om.
Er det her under? Og skal det bare fjernes?
<?
include("modul_afstemning.cfg.php");
include("side_top.php");
?>

Ups har du også Create filen til MYsql?
Skal jeg kalde de 2 første filer noget bestemt? vote.php og admin.php

Det kunne vel ikke lade sig gøre at du sendte mig en mail med filerne kunne det? ;-)

Linierne med brugerkontrol er dem der ligner den her:

if($brugerniveau != 1) {
$brugerniveau_fejl = 1;
}

Desuden kan du også fjerne det her:


<script type="text/javascript">
parent.frames.infoboks.infoboks_overskrift.innerHTML = '<? echo $overskrift; ?>';
top.boges_modul_status.innerHTML = '<? echo $overskrift; if(isset($underside)) echo " &raquo; " . $underside; ?>';
parent.frames.infoboks.tekst.innerHTML = '<?
echo str_replace("
", "<br>", $hjaelpetekst); ?>';
</script>

<?

if(isset($brugerniveau_fejl)) {
$fejl = "Du har ikke det nødvendige adgangsniveau til at se denne side";
echo besked($tak,$fejl);
exit;
}

DB strukturen er som følger:

# MySQL-Front Dump 2.5
#
# Host: localhost  Database: demo
# --------------------------------------------------------
# Server version 4.0.17-nt


#
# Table structure for table 'demo_afstemning_indstillinger'
#

DROP TABLE IF EXISTS demo_afstemning_indstillinger;
CREATE TABLE demo_afstemning_indstillinger (
  indhold text,
  besked1 text,
  besked2 text,
  besked3 text,
  besked4 text,
  besked5 text
) TYPE=MyISAM;



#
# Table structure for table 'demo_afstemning_muligheder'
#

DROP TABLE IF EXISTS demo_afstemning_muligheder;
CREATE TABLE demo_afstemning_muligheder (
  id int(10) unsigned NOT NULL auto_increment,
  spm_id int(10) unsigned default NULL,
  sortering int(10) NOT NULL default '0',
  svar text,
  antal int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Table structure for table 'demo_afstemning_spm'
#

DROP TABLE IF EXISTS demo_afstemning_spm;
CREATE TABLE demo_afstemning_spm (
  id int(10) NOT NULL auto_increment,
  aktiv tinyint(1) unsigned default '0',
  aktiv_fra datetime default NULL,
  aktiv_til datetime default NULL,
  spm text NOT NULL,
  PRIMARY KEY  (id),
  KEY ID (id)
) TYPE=MyISAM;

Tak :-)
Sender du lige et svar? Så du kan få point

Ja, hvis du fik det til at virke?

Så langt er jeg ikke kommet endnu. Jeg er på vagt 12 timer af gangen. Så det bliver ikke til meget kode værk når man kommer hjem.
Men Torsdag vil jeg sætte mig ned og kigge på det.

Så må du give lyd hvis det kniber med at få det til at virke :)

Ok det skal jeg nok.
Jeg har lige snakket med ham, som jeg laver siden for hvor den afstemning skal være.
Nu vil han godt have 2 afstemninger på hver 15 ved siden af hinanden. Så man makere 2 svar muligheder. Kan det laves?
Hvis ja Var det så noget for dig, mod og få en henvisning fra hans side til din/dig?
Siden jeg er ved at lave er om fodbold, et drengehold i Herfølge boldklub.

Ellers tak, men du kan da sende den "i udbud" her på E, der er sikkert nogen der vil lave den :)

Ok det kan være jeg gør det.
Jeg har ellers set en på nettet for ikke så lang tid siden, kan bare ikke huske hvor :-(
Men der er måske nogle her inde som ved det.