nieuws |
$sql = "SELECT a.id, a.titel, a.vpplaatje, a.inleiding FROM nieuws AS a WHERE a.goedgekeurd='ja' ORDER BY a.datum DESC LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
$nieuws = "![\"".$row["titel"]."\" \"nieuws\"](\"1ouder/".$row["vpplaatje"]."\") ".ucfirst($row["titel"])."
".$row["inleiding"];
$nieuwsid = $row["id"];
}
mysql_free_result($result);
?>
Lees verder  |
|
|
reizen |
|
artikelen |
|
de expert |
$sql = "SELECT a.id, a.titel, a.vpplaatje, a.reissoort, MIN(b.datum_van) as dedatum, b.datum_tot, c.naam FROM reizen AS a LEFT JOIN reizen_data AS b ON b.reis_id = a.id LEFT JOIN reizen_operators AS c ON b.operator_id = c.id WHERE b.datum_van>now() GROUP BY a.id ORDER BY RAND() LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
if ($row["vpplaatje"]=="") {
switch($row["reissoort"]) {
case "Diversen": $row["vpplaatje"] = "reizen_".$row["reissoort"].".gif";break;
default: $row["vpplaatje"] = "reizen_".$row["reissoort"].".jpg";break;
}
}
$reis = "![\"".$row["titel"]."\" \"reis\"](\"1ouder/".$row["vpplaatje"]."\") ".ucfirst($row["titel"])."
Van ".ndate($row["dedatum"], "j F Y")." tot ".ndate($row["datum_tot"], "j F Y")." via ".$row["naam"].".";
$reisid = $row["id"];
}
mysql_free_result($result);
$sql = "SELECT a.id, a.titel, a.datum, a.inleiding FROM artikelen AS a USE INDEX (idxSort) WHERE a.goedgekeurd='ja' ORDER BY a.datum DESC LIMIT 2";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
$artikel = "".ucfirst($row["titel"])."
".$row["inleiding"];
$artid = $row["id"];
$row = mysql_fetch_array($result);
$artrow = $row;
}
mysql_free_result($result);
$sql = "SELECT id, onderwerp, bericht FROM forumberichten WHERE forumid = 27 AND topic = 0 ORDER BY datum DESC LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
$demsg = $row["bericht"];
$demsg = eregi_replace("\\[img height=([^\\[]*)\\ width=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img width=([^\\[]*)\\ height=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img width=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img align=(left|right|center)]([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$expert = strip_bb_tags($demsg);
if (strlen($expert)>350) {
$expert = substr($expert, 0, 350)."...";
}
$expert = "".ucfirst($row["onderwerp"])."
".ucfirst($expert);
$expid = $row["id"];
$row = mysql_fetch_array($result);
$exprow = $row;
}
mysql_free_result($result);
?>
Lees verder  |
|
Lees verder  |
|
Lees verder  |
|
|
|
|
|
|
forum |
|
boeken |
|
poll |
$sql = "SELECT a.id, a.lastreplydatum, a.lastreplyby, a.username, a.onderwerp, a.bericht FROM forumberichten AS a LEFT JOIN forumaccess AS b ON a.forumid = b.forumid WHERE (b.userid='".$_COOKIE["cuserid"]."' OR isnull(b.userid)) AND a.topic=0 AND a.pollvraag='nee' AND (a.deleted='nee' OR a.deleted='notitie') ORDER BY a.lastreplydatum DESC LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
$demsg = $row["bericht"];
$demsg = eregi_replace("\\[img height=([^\\[]*)\\ width=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img width=([^\\[]*)\\ height=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img width=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img align=(left|right|center)]([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$bericht = ucfirst(strip_bb_tags($demsg));
if (strlen($bericht)>350) {
$bericht = substr($bericht, 0, 350)."...";
}
$forum = "".ucfirst($row["onderwerp"])."
".$bericht;
$fid = $row["id"];
}
mysql_free_result($result);
$sql = "SELECT a.id, a.onderwerp, a.bericht FROM forumberichten AS a WHERE a.topic=0 AND a.deleted='nee' AND a.forumid=23 ORDER BY a.datum DESC LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
$bericht = ucfirst(formpost($row["bericht"]));
if (strlen($bericht)>513) {
$bericht = substr($bericht, 0, 510)."...";
}
$boeken = "".ucfirst($row["onderwerp"])."
".$bericht;
$boekid = $row["id"];
}
mysql_free_result($result);
?>
Lees verder  |
|
Lees verder  |
|
Lees verder  |
|
|
|
|
|
$sql = "SELECT a.id, a.pollvraag, a.lastreplydatum, a.lastreplyby, a.username, a.onderwerp, a.bericht FROM forumberichten AS a WHERE a.pollvraag='ja' AND a.forumid=26 AND a.topic=0 AND a.deleted='nee' ORDER BY a.datum DESC LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
if ($row["pollvraag"]=="ja") {
echo " ".$row["onderwerp"]."
";
$poll_voorpos=strpos(strtoupper($row["bericht"]),"[POLL]");
$poll_eindpos=strpos(strtoupper($row["bericht"]),"[/POLL]");
$poll_naeindpos=$poll_eindpos+7;
$poll_vooreindpos=$poll_voorpos+6;
$poll_eindeindpos=$poll_eindpos-$poll_voorpos-7;
if ($poll_eindpos<=0) {
$poll_eindpos=strlen($row["bericht"]);
$poll_naeindpos=$poll_eindpos;
$poll_vooreindpos=0;
$poll_eindeindpos=$poll_eindpos;
}
$poll_vooropmerking=trim(chop(trim(substr($row["bericht"],0,$poll_voorpos))));
$poll_naopmerking=trim(chop(trim(substr($row["bericht"],$poll_naeindpos,2000))));
$poll_antwoorden=trim(chop(trim(substr($row["bericht"],$poll_vooreindpos,$poll_eindeindpos))));
$antwoord=explode("\n",$poll_antwoorden);
$acnt=count($antwoord);
$show_poll_form=0;
$eigen_antwoord=-1;
$qry="SELECT id,antwoord FROM poll where userid>0 and userid=".$_COOKIE["cuserid"]." and forumid='".$row["id"]."' limit 1";
$poll_result = mysql_query($qry);
if ($poll_result) {
if (mysql_num_rows($poll_result)>=1) {
$show_poll_form=0;
$poll_row=mysql_fetch_array($poll_result);
$eigen_antwoord=$poll_row["antwoord"];
} else {
$show_poll_form=1;
} // als numrows>0
} else { // als poll_result
$show_poll_form=1;
} // als poll_result
if ($thisislocked=="ja") {
$show_poll_form=0;
}
if ($show_poll_form==1) {
$pmsg="";
// $pmsg=formpost(nvervang(nl2br(geticons($poll_vooropmerking))));
$pmsg.="\n";
// $pmsg.=formpost(nvervang(nl2br(geticons($poll_naopmerking))));
} else { // als niet show_poll_form
$qry="SELECT antwoord,count(antwoord) as aantal FROM poll where forumid='".$row["id"]."' group by antwoord order by antwoord desc";
$pollres = mysql_query($qry);
for ($p=0;$p<$acnt;$p++) {
$aantal[$p]=0;
}
$totaal=0;
while ($pollrow=mysql_fetch_array($pollres)) {
$aantal[$pollrow["antwoord"]]=$pollrow["aantal"];
$totaal=$totaal+max(0,$pollrow["aantal"]);
}
// $pmsg=stagster(nl2br($poll_vooropmerking));
$pmsg.="\n";
for ($p=0;$p<$acnt;$p++) {
$percentage=round(($aantal[$p]/$totaal)*100,1);
$breedte=round((50*$percentage)/100);
$pmsg.="".$antwoord[$p]." | ".$percentage."% | \n";
}
$pmsg.=" Totaal: ".$totaal." stemmen | \n";
$pmsg.=" \n";
// $pmsg.=stagster(nl2br($poll_naopmerking));
} // einde else showpollform
} // als pollvraag
// einde pollpraag
mysql_free_result($result);
}
echo $pmsg;
// weblog
$sql = "SELECT id, onderwerp, bericht FROM forumberichten WHERE forumid = 24 AND topic = 0 ORDER BY datum DESC LIMIT 1";
$result = mysql_query($sql) or die("Kan query niet uitvoeren");
$row = mysql_fetch_array($result);
if ($row) {
$demsg = $row["bericht"];
$demsg = eregi_replace("\\[img height=([^\\[]*)\\ width=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img width=([^\\[]*)\\ height=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img width=([^\\[]*)\\]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img align=(left|right|center)]([^\\[]*)\\[/img\\]","",$demsg);
$demsg = eregi_replace("\\[img]http:\/\/([^\\[]*)\\[/img\\]","",$demsg);
$weblog = strip_bb_tags($demsg);
if (strlen($weblog)>350) {
$weblog = substr($weblog, 0, 350)."...";
}
$weblog = "".ucfirst($row["onderwerp"])."
".ucfirst($weblog);
$webid = $row["id"];
$row = mysql_fetch_array($result);
$webrow = $row;
}
mysql_free_result($result);
?> |
weblog |
|
|
|
artikelen |
Lees verder  |
|
|
|
Lees verder  |
|
|
|
|
|
$bericht = strip_tags($artrow["inleiding"]);
if (strlen($bericht)>225) {
$bericht = substr($bericht, 0, 225)."...";
}
echo " ".$artrow["titel"]."
".$bericht;
?> |
|