Forum – Diskussion

[insert_php]
$amne_id = $_REQUEST['i'];

require_once('./ims_files/functions.inc');
if(!isset($_SESSION['userOnlineID'])) exit(js_redirect('./logga-in'));

//Lägg till som person eller styrelse
if(!empty($_SESSION['userIsAdmin'])){
$CHOOSE_SENDER = ' Som Styrelse';
$CHOOSE_SENDER .= '  Som '.$_SESSION['userOnlineUsername'];
}else{
$CHOOSE_SENDER = '';
}

require_once('./ims_files/menu.inc');
require_once('./ims_files/db_conn.inc');

//Rubrik
$result = mysqli_query($conn,"select amne from ims_forum_amne where id = '$amne_id'");
$row = mysqli_fetch_assoc($result);
print '

';

//Spara inlägg
if(isset($_POST['spara']) && !empty($_POST['innehall'])){
$synlig = 1;
$pid = $_SESSION['userOnlineID'];
if(isset($_POST['foralder'])){
$foralder = $_POST['foralder'];
} else {
$foralder = 0;
}

$amne_id = $_POST['amne_id'];
$innehall = CleanUserInput($_POST['innehall'],0,1,1,0,1,1,0,0);
$inlagg_av = '';

if(isset($_POST['add_as']) and $_POST['add_as']=='Styrelse'){

$inlagg_av = 'Styrelse';
}

$query = "insert into ims_forum(amne_id,synlig,pid,inlagg_av,foralder,innehall,sourceip) "
. "values ('$amne_id','$synlig','$pid','$inlagg_av','$foralder','$innehall','".$_SERVER['REMOTE_ADDR']."')";
mysqli_query($conn, $query);
exit(js_redirect('./forum-diskussion?i='.$amne_id));
}

//Radera inllägg
if(isset($_REQUEST['del'])){
//mysqli_query($conn,"update ims_forum set foralder = 0 where id = " . $_REQUEST['del']);
mysqli_query($conn,"delete from ims_forum where id = ".$_REQUEST['del']);
exit(js_redirect('./forum-diskussion?i='.$_REQUEST['anme_id']));
}
# Navigator PROPERTIES #####################################################
$posts_per_page = 15;
$nav_sql = mysqli_query($conn,"select id from ims_forum");
$total_records = mysqli_num_rows($nav_sql);
@$current_page = $_REQUEST['cp'];
if(empty($current_page)){
$pagenr = 1;
}else{
$pagenr = $current_page;
}
$pages = ceil($total_records / $posts_per_page);
$start = ($pagenr * $posts_per_page) - $posts_per_page;
# Navigator PROPERTIES End #################################################

################################################################################

function get_topic($fid,$start,$posts_per_page,$amne_id){
require('./ims_files/db_conn.inc');
$result = mysqli_query($conn,"select id,amne_id,timestamp,pid,inlagg_av,foralder,innehall "
. "from ims_forum "
. "where synlig = 1 and foralder = '$fid' and amne_id = '$amne_id' "
. "order by timestamp asc, foralder "
. "limit $start, $posts_per_page");
$count_rows = mysqli_num_rows($result);

if(!empty($count_rows)){

while($row = mysqli_fetch_assoc($result)){

if(!empty($_SESSION['userIsAdmin'])){
$DELETE_ICON = ''
. '';
}else{
$DELETE_ICON = '';;
}

$getname = mysqli_query($conn,"select pid,bild,anvandarnamn "
. "from ims_person "
. "where pid = ".$row['pid']." "
. "order by timestamp");
$name_row = mysqli_fetch_assoc($getname);

//Kolla om bilden är tom
$bild = $name_row['bild'];
empty($bild) ? $bild = 'nopic.jpg' :'';

if(!empty($row['inlagg_av'])){
$styrelsen = ' av '.$row['inlagg_av'];
$background = 'border: #222 0.13em solid;background-color:#F7F7F7;';
}else{
$styrelsen = ' av ' . $name_row['anvandarnamn'];
$background = 'background-color:white;';
}
//
print '
'
. '

'
. ''
. ''.$DELETE_ICON.''
. ''.readable_date($row['timestamp']).$styrelsen.''
. '

---

'.nl2br($row['innehall']).'';get_topic($row['id'],$start,$posts_per_page,$row['amne_id']);print '

';
}

}
}

get_topic(0,$start,$posts_per_page,$amne_id);

/*
$bild = $_SESSION['userOnlinePic'];
if(empty($bild)){
$bild = 'nopic.jpg';
}

'.$_SESSION['userOnlineUsername'].'
*/

print '

';

//Form
if(isset($_REQUEST['reply'])){
$reply = '

'
. '

'
. ''
. '';
} else {
$reply = '';
}

print '

';

//Navigate

if($pages < $total_records ){ print '

';
if($pagenr > 1){
print '
• « Föregående

';
}else{
print '

• « Föregående

';
}

for ($i = 1; $i <= $pages; $i++){ if ($i == $pagenr){ print '

• '.$i.'

';
}else{
print '

• '.$i.'

';
}

}

if ($pagenr < $pages){ print '

• Nästa »

';
}else{
print '

• Nästa »

';
}

print '

';
}

if(isset($_SESSION['userIsAdmin'])){
print '
';
}

[/insert_php]