<?php
################################
# Freundesliste by legalsauger #
# Version 1.1 #
# © by ilch-module.de #
################################
defined('main') or die('no direct access');
$title = $allgAr['title'].' :: Freunde';
$hmenu = 'Freunde';
$design = new design($title,$hmenu);
$design->header();
if (loggedin()) {
if (isset($_POST['sub'])) {
$name = escape($_POST['name'],'string');
$fid = db_result(db_query("SELECT id FROM prefix_user WHERE name = BINARY '".$name."'"),0);
$dupe = @db_result(db_query("SELECT * FROM prefix_friends WHERE uid = ".$_SESSION['authid']." AND fid = ".$fid),0);
if ($fid > 0 AND $fid != $_SESSION['authid']) {
if ($dupe == 0) {
db_query('INSERT INTO prefix_friends (uid,fid) VALUES ('.$_SESSION['authid'].','.$fid.')');
$msg = 'Erfolgreich eingetragen.<br><br>';
} else {
$msg = 'Du hast diese Person schon in deiner Freundesliste.<br><br>';
}
} else {
$msg = 'Es ist Fehler beim Eintragen aufgetreten.<br><br>';
}
}
echo $msg;
if ($menu->getA(1) == 'd') {
db_query("DELETE FROM prefix_friends WHERE id = ".$menu->getE(1));
}
$tpl = new tpl('freunde');
$tpl->out(0);
$abf = db_query("SELECT * FROM prefix_friends WHERE uid = ".$_SESSION['authid']);
while ($row = db_fetch_assoc($abf)) {
$r['class'] = ($class=='Cmite'?'Cnorm':'Cmite');
$sql = db_query("SELECT id,name FROM prefix_user WHERE id = ".$row['fid']);
$rr = db_fetch_assoc($sql);
$r['name'] = '<a href="index.php?user-details-'.$rr['id'].'">'.$rr['name'].'</a>';
$r['aktfid'] = $row['fid'];
$r['id'] = $row['id'];
$tpl->set_ar_out($r,1);
}
$tpl->out(2);
$abf = db_query("SELECT uid FROM prefix_friends WHERE fid = ".$_SESSION['authid']);
while ($row = db_fetch_assoc($abf)) {
$r['class'] = ($class=='Cmite'?'Cnorm':'Cmite');
$sql = db_query("SELECT id,name FROM prefix_user WHERE id = ".$row['uid']);
$rr = db_fetch_assoc($sql);
$r['name'] = '<a href="index.php?user-details-'.$rr['id'].'">'.$rr['name'].'</a>';
$r['aktfid'] = $row['fid'];
$tpl->set_ar_out($r,3);
}
$tpl->out(4);
} else {
echo 'Nur für angemeldete User.';
}
$design->footer();
?>
Zitat
