LoGD Standardrelease steht hier zum Download zur Verfügung!
<?php
function adddbfieldifne($table,$field,$type,$after)
{ $found = FALSE;
$sql = "SELECT * FROM ".$table;
$result = db_query($sql) or die(db_error(LINK));
$fields = mysql_num_fields($result);
for ($i=0; $i < $fields; $i++)
{ if (mysql_field_name($result, $i)==$field) { $found=TRUE; } }
if (!$found)
{ $sql = "ALTER TABLE `".$table."` ADD `".$field."` ".$type." NOT NULL AFTER `".$after."`";
$result = db_query($sql) or die(db_error(LINK));
}
}
function showpranger()
{ $sql = "SELECT * FROM items WHERE class='Pranger' ORDER BY value1 ASC";
$result = db_query($sql) or die(db_error(LINK));
output("<table border='0'>",true);
for($i=0; $i<db_num_rows($result); $i++)
{ $item=db_fetch_assoc($result);
output("<tr><td>`6$item[description]</td></tr>",true);
addnav("",$lnk);
}
output("</table>",true);
}
function getstreetname($house)
{ $house = (int)$house;
switch ($house)
{ case 0: $ret = "Strasse der 13.Nacht"; break;
case 1: $ret = "Finsterallee"; break;
case 2: $ret = "Zum Folterhain"; break;
case 3: $ret = "Höllengässchen"; break;
case 4: $ret = "Am Todesgarten"; break;
case 5: $ret = "Satansweg"; break;
case 6: $ret = "Am Galgenberg"; break;
case 7: $ret = "Knochengasse"; break;
case 8: $ret = "Dunkelberg"; break;
case 9: $ret = "Henkerviertel"; break;
case 10: $ret = "Zum Halsabschneider"; break;
case 11: $ret = "Totenmanns Weg"; break;
case 12: $ret = "Gevatter Tod Strasse"; break;
default: $ret = "Straße ".$i; break;
}
return $ret;
}
function addforestlakeflirtmap($ownid,$ownname,$partnerid,$partnername,$mapchance=50)
// $mapchance is the chance in percent that the map will be created
{ $rand = e_rand(0,100);
$flirtload = e_rand(50,100); // Adjust here how long a flirt map should endure.
// $flirtload = 0; // You would use this for never-ending flirts.
if ($rand<$mapchance)
{ $sqlmap = "SELECT * FROM items WHERE owner=$ownid AND class='Karte' AND value1=$ownid AND value2=$partnerid";
$resultmap = db_query($sqlmap);
if (db_num_rows($resultmap)==0)
{ $sql = "INSERT INTO `items` (name,class,owner,value1,value2,description) VALUES ('Karte zu ".$partnername."', 'Karte', '".$ownid."', '".$partnerid."', '".$flirtload."', 'Dieser Karte hilft dir, ".$partnername." am Trampelpfad zu finden.');";
db_query($sql);
}
$sqlmap = "SELECT * FROM items WHERE owner=$partnerid AND class='Karte' AND value1=$partnerid AND value2=$ownid";
$resultmap = db_query($sqlmap);
if (db_num_rows($resultmap)==0)
{ $sql = "INSERT INTO `items` (name,class,owner,value1,value2,description) VALUES ('Karte zu ".$ownname."', 'Karte', '".$partnerid."', '".$ownid."', '".$flirtload."', 'Dieser Karte hilft dir, ".$ownname." am Trampelpfad zu finden.');";
db_query($sql);
}
}
}
?>