
echo $titlefreeroll_page; ?>
echo $main_text1; ?> echo $main_text2; ?>
![]() |
echo $text_to_freeroll_page ?> |
![]() |
echo $text_to_download_page ?> |
Webmaster Freeroll Script
echo $index_freerollscripttext; ?>
echo $titlelaatstenieuws; ?>
include('admin/lib.php');
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("$host","$username","$password");
//select which database you want to edit
mysql_select_db("$db");
$query = "SELECT * FROM nieuws_berichten WHERE published='1' ORDER BY id DESC LIMIT 5 ";
$result=mysql_query($query);
$num=mysql_numrows($result);
//mysql_close();
$i=0;
while ($i < $num) {
?>
$titel = mysql_result($result,$i,"titel");
$bron_naam =mysql_result($result,$i,"bron_naam");
$bron_url = mysql_result($result,$i,"bron_url");
$id = mysql_result($result,$i,"id");
$cat = mysql_result($result,$i,"categorie");
$datum = mysql_result($result,$i,"datum");
$bericht4 = mysql_result($result,$i,"tekst");
//Limit content of news item
$contentshort = substr($bericht4, 0, 400);
if (strlen($bericht4) > 400) {
//Here we try to find the last position of a . followed by a space,
//which in my mind indicates the end of a sentence. So it should
//prevent breaking the news item in the middle of a html tag!
$lastsentence = strripos($contentshort, ". ");
if($lastsentence != FALSE)
{
$contentshort = substr($contentshort, 0, $lastsentence+1);
$contentshort = $contentshort." Lees meer.....
"; $bericht4 = $contentshort; } } //End of news item limitation $bericht3 = nl2br($bericht4); ?> $sql = "SELECT * FROM nieuws_categorie WHERE categorie='$cat' LIMIT 1 "; $result2 = mysql_query($sql); if (!$result2) { echo "Could not successfully run query ($sql) from DB: " . mysql_error(); exit; } if (mysql_num_rows($result2) == 0) { echo "No rows found, nothing to print so am exiting"; exit; } while ($row = mysql_fetch_assoc($result2)) { $logo = $row["img_logo_url"]; $banner = $row["banner_url"]; } include('linklijst.php'); //mysql_free_result($result2); ?> $i++; } ?>
"; $bericht4 = $contentshort; } } //End of news item limitation $bericht3 = nl2br($bericht4); ?> $sql = "SELECT * FROM nieuws_categorie WHERE categorie='$cat' LIMIT 1 "; $result2 = mysql_query($sql); if (!$result2) { echo "Could not successfully run query ($sql) from DB: " . mysql_error(); exit; } if (mysql_num_rows($result2) == 0) { echo "No rows found, nothing to print so am exiting"; exit; } while ($row = mysql_fetch_assoc($result2)) { $logo = $row["img_logo_url"]; $banner = $row["banner_url"]; } include('linklijst.php'); //mysql_free_result($result2); ?> $i++; } ?>
echo $meldjeaan; ?>
echo $meldjeaan_regel1;?>echo $meldjeaan_regel2; ?>