Rapport til clanwarscript + farveændring (PHP)
Hejsa...Jeg har siddet og programmeret et clanwar script her idag i PHP.
Dog er det ikke fuldent endnu...
Jeg kunne godt tænke mig at man for hver kamp, ved hver rapport billede, kunne trykke på det og få vist rapport for den pågældende kamp...
Endvidere vil jeg gerne ha' score farvene til at være fx. rød ved en tabt kamp, grøn ved en vundet kamp og fx. sort ved en uafgjort kamp...
Til farverne kunne jeg forestille mig at man skal anvende if sætninger... men hvordan?
Koden til mine to filer ser ud som følgende:
--------------
index.php
--------------
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<title></title>
<link rel="stylesheet" type="text/css">
</head>
<body bgcolor="#333333">
<font color="#FFFFFF" face="Verdana" style="font-size: 9pt">»
<span style="font-weight: 700">Clanwars</font></span></p>
<?
$db = mysql_connect("localhost", "root", "");
mysql_select_db("valuable", $db);
if($_POST['skriv']){
$rapport = $_POST['rapport'];
$ip = $GLOBALS['REMOTE_ADDR'];
mysql_query("INSERT INTO clanwars (modstander, type, map1, map2, dato_dag, dato_måned, dato_år, score_jeres, score_modstander, rapport) VALUES ('$_POST[modstander]', '$_POST[type]', '$_POST[map1]', '$_POST[map2]', '$_POST[dato_dag]', '$_POST[dato_måned]', '$_POST[dato_år]', '$_POST[score_jeres]', '$_POST[score_modstander]', '$rapport')");
}
?>
<?
$resultat = mysql_query("select * from clanwars");
$nummer = mysql_num_rows($resultat);
if ($nummer <= 0) {
echo "<font face='Verdana' color='#ffffff' size='1'> - Der er ikke spillet nogle clanwars endnu</font></span></p>";
} else {
echo "<font face='Verdana' color='#ffffff' size='1'> - Der er spillet $nummer clanwars ialt</font></span></p>";
}
?>
</p>
<table border='0' bordercolor='#808080' style='border-collapse: collapse' height="36">
<tr bgcolor='#13161F'>
<td width='90' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Modstander</b></td>
<td width='100' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Type</b></td>
<td width='155' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Map(s)</b></td>
<td width='75' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Dato</b></td>
<td width='40' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Score</b></td>
<td width='20' height='16'><font face='Verdana' color='#ffffff' size='1'> </font></td>
</tr>
<?
$foresp = mysql_query("SELECT modstander, type, map1, map2, dato_dag, dato_måned, dato_år, score_jeres, score_modstander, rapport, nr FROM clanwars ORDER BY nr DESC");
if(!$foresp){
//noget gik galt.
die("Fejl ved SQL udførsel: ".mysql_error());
}
while($data = mysql_fetch_row($foresp)){
echo "
<tr>
<tr><td width='90' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[0]</font></td>";
echo "<td width='100' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[1]</font></td>";
echo "<td width='155' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[2] / $data[3]</font></td>";
echo "<td width='75' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[4]/$data[5]-$data[6]</font></td>";
echo "<td width='40' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[7]-$data[8]</font></td>";
echo "<td width='20' height='13'><a href='???'><img src='rapport.gif' border='0'></a></td></tr>";
}
?>
</font>
</table>
<br>
<font face="Verdana"><a href="tilfoej.php"><font color="#FFFFFF" size="1">Tilfoej/slet clanwar</font></a></font>
</body>
</html>
--------------
tilfoej.php
--------------
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<title></title>
<link rel="stylesheet" type="text/css" href="gfx.css">
</head>
<body bgcolor="#333333">
<font color="#FFFFFF" face="Verdana" style="font-size: 9pt">»
<span style="font-weight: 700">Tilføj/slet clanwar</font></span></p>
<?
$db = mysql_connect("localhost", "root", "");
mysql_select_db("valuable", $db);
if($_POST['skriv']){
$rapport = $_POST['rapport'];
$ip = $GLOBALS['REMOTE_ADDR'];
mysql_query("INSERT INTO clanwars (modstander, type, map1, map2, dato_dag, dato_måned, dato_år, score_jeres, score_modstander, rapport) VALUES ('$_POST[modstander]', '$_POST[type]', '$_POST[map1]', '$_POST[map2]', '$_POST[dato_dag]', '$_POST[dato_måned]', '$_POST[dato_år]', '$_POST[score_jeres]', '$_POST[score_modstander]', '$rapport')");
}
?>
<form method=post action="tilfoej.php">
<input type=hidden NAME=skriv VALUE=1>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="429" height="154">
<tr>
<td width="429" height="33" valign="top">
<table cellSpacing="0" cellPadding="0" align="left" border="0" height="172" width="423">
<tr>
<td height="3" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Modstander:</font></td>
<td height="3" width="309" valign="top">
<input type="text" name="modstander" size="20">
</td>
</tr>
<tr>
<td height="1" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Type:</font></td>
<td height="1" width="309" valign="top">
<input type="text" name="type" size="20">
</td>
</tr>
<tr>
<td height="19" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Map 1:</font></td>
<td height="19" width="309" valign="top">
<input type="text" name="map1" size="20">
</td>
</tr>
<tr>
<td height="21" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Map 2:</font></td>
<td height="21" width="309" valign="top">
<input type="text" name="map2" size="20">
</td>
</tr>
<tr>
<td height="21" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Dato:</font></td>
<td width="309" height="21">
<SELECT name=dato_dag class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=01 value=01>01</OPTION>
<OPTION label=02 value=02>02</OPTION>
<OPTION label=03 value=03>03</OPTION>
<OPTION label=04 value=04>04</OPTION>
<OPTION label=05 value=05>05</OPTION>
<OPTION label=06 value=06>06</OPTION>
<OPTION label=07 value=07>07</OPTION>
<OPTION label=08 value=08>08</OPTION>
<OPTION label=09 value=09>09</OPTION>
<OPTION label=10 value=10>10</OPTION>
<OPTION label=11 value=11>11</OPTION>
<OPTION label=12 value=12>12</OPTION>
<OPTION label=13 value=13>13</OPTION>
<OPTION label=14 value=14>14</OPTION>
<OPTION label=15 value=15>15</OPTION>
<OPTION label=16 value=16>16</OPTION>
<OPTION label=17 value=17>17</OPTION>
<OPTION label=18 value=18>18</OPTION>
<OPTION label=19 value=19>19</OPTION>
<OPTION label=20 value=20>20</OPTION>
<OPTION label=21 value=21>21</OPTION>
<OPTION label=22 value=22>22</OPTION>
<OPTION label=23 value=23>23</OPTION>
<OPTION label=24 value=24>24</OPTION>
<OPTION label=25 value=25>25</OPTION>
<OPTION label=26 value=26>26</OPTION>
<OPTION label=27 value=27>27</OPTION>
<OPTION label=28 value=28>28</OPTION>
<OPTION label=29 value=29>29</OPTION>
<OPTION label=30 value=30>30</OPTION>
<OPTION label=31 value=31>31</OPTION>
</SELECT>
<SELECT name=dato_måned class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=januar value=01>januar</OPTION>
<OPTION label=februar value=02>februar</OPTION>
<OPTION label=marts value=03>marts</OPTION>
<OPTION label=april value=04>april</OPTION>
<OPTION label=maj value=05>maj</OPTION>
<OPTION label=juni value=06>juni</OPTION>
<OPTION label=Juli value=07>juli</OPTION>
<OPTION label=august value=08>august</OPTION>
<OPTION label=september value=09>september</OPTION>
<OPTION label=oktober value=10>oktober</OPTION>
<OPTION label=november value=11>november</OPTION>
<OPTION label=december value=12>december</OPTION>
</SELECT>
<SELECT name=dato_år class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=2004 value=2004>2004</OPTION>
<OPTION label=2005 value=2005>2005</OPTION>
<OPTION label=2006 value=2006>2006</OPTION>
<OPTION label=2007 value=2007>2007</OPTION>
<OPTION label=2008 value=2008>2008</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td height="18" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Jeres score:</font></td>
<td height="18" width="9">
<SELECT name=score_jeres class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=00 value=00>00</OPTION>
<OPTION label=01 value=01>01</OPTION>
<OPTION label=02 value=02>02</OPTION>
<OPTION label=03 value=03>03</OPTION>
<OPTION label=04 value=04>04</OPTION>
<OPTION label=05 value=05>05</OPTION>
<OPTION label=06 value=06>06</OPTION>
<OPTION label=07 value=07>07</OPTION>
<OPTION label=08 value=08>08</OPTION>
<OPTION label=09 value=09>09</OPTION>
<OPTION label=10 value=10>10</OPTION>
<OPTION label=11 value=11>11</OPTION>
<OPTION label=12 value=12>12</OPTION>
<OPTION label=13 value=13>13</OPTION>
<OPTION label=14 value=14>14</OPTION>
<OPTION label=15 value=15>15</OPTION>
<OPTION label=16 value=16>16</OPTION>
<OPTION label=17 value=17>17</OPTION>
<OPTION label=18 value=18>18</OPTION>
<OPTION label=19 value=19>19</OPTION>
<OPTION label=20 value=20>20</OPTION>
<OPTION label=21 value=21>21</OPTION>
<OPTION label=22 value=22>22</OPTION>
<OPTION label=23 value=23>23</OPTION>
<OPTION label=24 value=24>24</OPTION>
<OPTION label=25 value=25>25</OPTION>
<OPTION label=26 value=26>26</OPTION>
<OPTION label=27 value=27>27</OPTION>
<OPTION label=28 value=28>28</OPTION>
<OPTION label=29 value=29>29</OPTION>
<OPTION label=30 value=30>30</OPTION>
<OPTION label=31 value=31>31</OPTION>
<OPTION label=32 value=32>32</OPTION>
<OPTION label=33 value=33>33</OPTION>
<OPTION label=34 value=34>34</OPTION>
<OPTION label=35 value=35>35</OPTION>
<OPTION label=36 value=36>36</OPTION>
<OPTION label=37 value=37>37</OPTION>
<OPTION label=38 value=38>38</OPTION>
<OPTION label=39 value=39>39</OPTION>
<OPTION label=40 value=40>40</OPTION>
<OPTION label=41 value=41>41</OPTION>
<OPTION label=42 value=42>42</OPTION>
<OPTION label=43 value=43>43</OPTION>
<OPTION label=44 value=44>44</OPTION>
<OPTION label=45 value=45>45</OPTION>
<OPTION label=46 value=46>46</OPTION>
<OPTION label=47 value=47>47</OPTION>
<OPTION label=48 value=48>48</OPTION>
</SELECT></td>
</tr>
<tr>
<td height="23" width="114" valign="middle">
<font size="1" face="Verdana" color="#FFFFFF">Modstander score:</font> </td>
<td height="23" width="9">
<SELECT name=score_modstander class='input'>
<OPTION value="" selected></OPTION>
<OPTION label=00 value=00>00</OPTION>
<OPTION label=01 value=01>01</OPTION>
<OPTION label=02 value=02>02</OPTION>
<OPTION label=03 value=03>03</OPTION>
<OPTION label=04 value=04>04</OPTION>
<OPTION label=05 value=05>05</OPTION>
<OPTION label=06 value=06>06</OPTION>
<OPTION label=07 value=07>07</OPTION>
<OPTION label=08 value=08>08</OPTION>
<OPTION label=09 value=09>09</OPTION>
<OPTION label=10 value=10>10</OPTION>
<OPTION label=11 value=11>11</OPTION>
<OPTION label=12 value=12>12</OPTION>
<OPTION label=13 value=13>13</OPTION>
<OPTION label=14 value=14>14</OPTION>
<OPTION label=15 value=15>15</OPTION>
<OPTION label=16 value=16>16</OPTION>
<OPTION label=17 value=17>17</OPTION>
<OPTION label=18 value=18>18</OPTION>
<OPTION label=19 value=19>19</OPTION>
<OPTION label=20 value=20>20</OPTION>
<OPTION label=21 value=21>21</OPTION>
<OPTION label=22 value=22>22</OPTION>
<OPTION label=23 value=23>23</OPTION>
<OPTION label=24 value=24>24</OPTION>
<OPTION label=25 value=25>25</OPTION>
<OPTION label=26 value=26>26</OPTION>
<OPTION label=27 value=27>27</OPTION>
<OPTION label=28 value=28>28</OPTION>
<OPTION label=29 value=29>29</OPTION>
<OPTION label=30 value=30>30</OPTION>
<OPTION label=31 value=31>31</OPTION>
<OPTION label=32 value=32>32</OPTION>
<OPTION label=33 value=33>33</OPTION>
<OPTION label=34 value=34>34</OPTION>
<OPTION label=35 value=35>35</OPTION>
<OPTION label=36 value=36>36</OPTION>
<OPTION label=37 value=37>37</OPTION>
<OPTION label=38 value=38>38</OPTION>
<OPTION label=39 value=39>39</OPTION>
<OPTION label=40 value=40>40</OPTION>
<OPTION label=41 value=41>41</OPTION>
<OPTION label=42 value=42>42</OPTION>
<OPTION label=43 value=43>43</OPTION>
<OPTION label=44 value=44>44</OPTION>
<OPTION label=45 value=45>45</OPTION>
<OPTION label=46 value=46>46</OPTION>
<OPTION label=47 value=47>47</OPTION>
<OPTION label=48 value=48>48</OPTION>
</SELECT></td>
</tr>
<tr>
<td vAlign="top" height="54" width="82">
<font size="1" face="Verdana" color="#FFFFFF">Rapport:</font></td>
<td height="54" width="314" valign="top">
<font color="#FFFFFF" face="Verdana" size="1">
<textarea class="input" style="WIDTH: 300px; HEIGHT: 90px" name="rapport" rows="1" cols="20"></textarea>
</font></td>
</tr>
<tr>
<td height="20" width="114"></td>
<td height="20" width="309" valign="top">
<input type="submit" name="submit" value="tilføj" style="color: #000000; background-color: #FFFFFF; border:1px solid #9A9A9A;"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
<?
$resultat = mysql_query("select * from clanwars");
$nummer = mysql_num_rows($resultat);
if ($nummer <= 0) {
echo "<font face='Verdana' color='#ffffff' size='1'> - Der er ikke spillet nogle clanwars endnu</font></span></p>";
} else {
echo "<font face='Verdana' color='#ffffff' size='1'> - Der er spillet $nummer clanwars ialt</font></span></p>";
}
?>
</p>
<table border='0' bordercolor='#808080' style='border-collapse: collapse' height="36">
<tr bgcolor='#13161F'>
<td width='90' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Modstander</b></td>
<td width='100' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Type</b></td>
<td width='155' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Map(s)</b></td>
<td width='75' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Dato</b></td>
<td width='40' height='16'><font face='Verdana' color='#ffffff' size='1'><b>Score</b></td>
<td width='15' height='16'><font face='Verdana' color='#ffffff' size='1'> </font></td>
<td width='15' height='16'><font face='Verdana' color='#ffffff' size='1'> </font></td>
</tr>
<?
$foresp = mysql_query("SELECT modstander, type, map1, map2, dato_dag, dato_måned, dato_år, score_jeres, score_modstander, rapport, nr FROM clanwars ORDER BY nr DESC");
if(!$foresp){
//noget gik galt.
die("Fejl ved SQL udførsel: ".mysql_error());
}
while($data = mysql_fetch_row($foresp)){
echo "
<tr><td width='90' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[0]</font></td>";
echo "<td width='100' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[1]</font></td>";
echo "<td width='155' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[2] / $data[3]</font></td>";
echo "<td width='75' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[4]/$data[5]-$data[6]</font></td>";
echo "<td width='40' height='13'><font face='Verdana' color='#ffffff' size='1'>$data[7]-$data[8]</font></td>";
echo "<td width='15' height='13'><a href='???'><img src='rapport.gif' border='0' width='10' height='12'></a></td>";
echo "<td width='15' height='13'><a href='slet_clanwars.php?nr=$data[10]' style='text-decoration: none'><font face='Verdana' color='#ff0000' size='1'><b>SLET</b></font></a></td></tr>";
}
?>
</font>
</table>
<br>
<font face="Verdana"><a href="index.php"><font color="#FFFFFF" size="1">Se clanwars</font></a></font>
</body>
</html>
