This is an old revision of the document!
Add Item to Green Box
<php> include(“/var/www/html/greenbox/sqlconnect.php”); include(“/var/www/html/greenbox/sqlconnect2.php”);
$query = “INSERT INTO Items (Year,Type,Freq,Class,Description,Comments,SAN,Contributor,Email,MoreInfoURL,Cell)
VALUES
('$Year','$Type','$Freq','$Class','$Description','$Comments','$SAN','$Contributor','$Email','$MoreInfoURL','$Cell')";
$result = mysql_query($query)
or die ("Couldn't execute query.");
$ItemID = mysql_insert_id(); // 46
while ($row = mysql_fetch_assoc($result)) {
echo "The following item has been added to the database:<br>
<ul>
<li>Type: $row['Type']
<li>Frequency: $row['Freq']
<li>Class: $row['Class']
<li><b>$row['Description'] </b>- $row['Comments']
<li>SAN penalty: $row['SAN']
<li>Contributed by: $row['Contributor'] $row['Email']
<li>More info from: $row['MoreInfoURL']
<li>Cell $Cell available from $row['Year']
\n”; }
echo "</ul>"; echo "Add Another Item\n";
</php>
<html> <br> <b>Add as much detail as you can in the form below, fields which cannot be blank are indicated with an Asterisk <font color=red>*</font></b> <form action=“/doku.php/dg/greenbox/add” method=“post”> <table>
<tr> <td><b>Type<font color=red>*</font> <td><b>Frequency<font color=red>*</font> <td><b>Available since <td><b>Cell
</tr>
<tr>
<td><select name="Type">
<option value="Mythos" >Mythos
<option Selected value="Mundane" >Mundane
<option value="Occult" >Occult
<option value="Other" >Other
</select>
<td><select name="Freq">
<option Selected value="0" >Very Common
<option value="1" >Common
<option value="2" >Uncommon
<option value="3" >Rare
<option value="4" >Very Rare
<option value="5" >Unique
</select>
<td><input type="text" name="Year" size="4" maxlength="4">
<td><input type="text" name="Cell" size="1" maxlength="1">
</td></tr>
<tr> <td><b>Item class<font color=red>*</font> <td><b>Short Description<font color=red>*</font> <td><b>SAN effects </tr>
<tr>
<td><select name="Class">
<option Selected value="Artefact" >Artefact
<option value="Weapon" >Weapon
<option value="Info" >Info
<option value="ID" >ID
<option value="Contact" >Contact
<option value="Other" >Other
</select>
<td><input type="text" name="Description" value="short description"
size="75" maxlength="255">
<td><input type="text" name="SAN" value="0/0"
size="12" maxlength="12">
</tr> </table> <b>Full description of item:</b><br>
<textarea name="Comments" rows="5" cols="75" maxlength="5000"></textarea>
<table> <tr>
<tr>
<td><b>Contributed by
<td><b>E-mail
<td><b>More Info URL
</tr>
<tr>
<td><input type="text" name="Contributor" value="Agent X"
size="25" maxlength="255">
<td><input type="text" name="Email" value="web form"
size="25" maxlength="255">
<td><input type="text" name="MoreInfoURL" size="25" maxlength="255">
</table>
<p><input type=“submit” name=“newbutton” value=“Commit Item to Green Box”> <input type=“submit” name=“newbutton” value=“Cancel”> </form> </html>
