A script to throw away keys without returning them to the owner can be found here. It makes house owners to think more about who they give a key. If they are not careful they lose a key and have to buy a new one in Hunter's Lodge.
The latest houses.php contains a way for the house owner to take back his keys. (I don't know if it was possible in the english translation.)
For the more friendly habitants of LoGD who want to give back unwanted keys, it is the best to do it by item ID - just in case that there are more than one keys to a house.
The easiest (not the best) way for this is to give the item ID of the key and the ID of the house through the nav.
Example:
All keys that give access to other's houses are listet in navs and can be returned. This would work as a separate script as well and doesn't have to be put into houses.php. I recommend not to enable users to give back keys while they are guests in the house.
$this->bbcode_second_pass_code('', '...
// get all guest keys of the user for all houses
$row=db_query('SELECT * FROM items WHERE class="key" AND owner='.$session['user']['acctid'].' AND value1<>'.$session['user']['house'].' ORDER BY value1');
// generate navs to return guest keys
addnav("Return key");
y=db_num_rows($row);
for (x=0;x<y;x++){
$item=db_fetch_assoc($row);
addnav("for house ".$item['value1'],"xy.php?op=returnkey&itemid=".$item['id']."&houseid=".$item['value']); // not the best way to 'show' those values in the navs!
}
...')
$this->bbcode_second_pass_code('', '...
}elseif ($_GET['op']=="returnkey"){
// return selected key to house owner
$house=db_fetch_assoc(db_query('SELECT owner FROM houses WHERE houseid='.(int)$_GET['houseid']));
db_query('UPDATE items SET owner='.$house['owner'].' WHERE id='.(int)$_GET['itemid']) or die(db_error(LINK));
}
...')
(Not optimized, not tested!
Replace class="key" by class="Schlüssel" for German version.)
Did this help you?