login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Nieuwssystemen > Lucky News

Lucky News

Auteur: LuckyLuke - 07 maart 2005 - 17:17 - Gekeurd door: Joel - Hits: 23806 - Aantal punten: 3.80 (10 stemmen)




Link is dood, ik ben bezig met v2: http://luckynews.lucasvd.nl

Nadat ik mijn eerste script weer eens zag, ook een nieuws systeem, schrok ik nogal van de lelijke code. Daarom heb ik maar is besloten om nog een nieuws systeem te gaan maken. en zie hier het resultaat.

Belangrijkste functie's:
-Nieuws toevoegen/bewerken/verwijderen
-Reacties toevoegen/bewerken/verwijderen
-Categoriën toevoegen/bewerken/verwijderen
-IP ban
-Heel uitgebreid theming systeem
-Meerdere moderators
-Veel instellingen zijn configureerbaar in de admin
-Nieuws kan via RSS verkregen worden
-BBcode
-Smilies
-Uitgebreide admin
-Gemakkelijke installatie

En nog vele andere optie's!

Voorbeeld: http://luckynews.hyrule-castle.nl/
Admin Demo: http://luckynews.hyrule-castle.nl/
Username: admin_demo
pass: demo_admin
Download: http://luckynews.hyrule-castle.nl/Lucky%20News.zip

Ik en Yorick hebben flink geocht naar bugs, maar als je er toch nog 1 kan vinden meld het dan mij even. 

Code:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. ##########################################################
  2. config.php leeg laten!
  3. #######################################################
  4.  
  5. ##########################################################
  6. index.php
  7. #######################################################
  8. <?php
  9. require_once("init.php");
  10. define('PAGE_TITLE', "Home");
  11. require_once(HEADERF);
  12.  
  13. $action = (isset($_GET['action']) ? $_GET['action'] : "news");
  14.  
  15. if(!$action || $action == "news") {
  16.         $pn->setTable(MPREFIX."news");
  17.         $pn->setMax($config['max_news']);
  18.         $pn->setOrder("news_id", "DESC");
  19.         $pn->setWhere(" WHERE news_active=1");
  20.         $pn->getTotal();
  21.         $pn->showNews("news");
  22.         echo $pn ->createNav();
  23. } else if($action == "archive") {
  24.         $pn->setTable(MPREFIX."news");
  25.         $pn->setMax(10000000000);
  26.         $pn->setOrder("news_id", "DESC");
  27.         $pn->setWhere(" WHERE news_active=1");
  28.         $pn->getTotal();
  29.         echo "<table width='100%' class='fborder'>
  30.         <tr>
  31.         <td colspan='3' class='forumheader'>Nieuws archief</td>
  32.         </tr>
  33.         ";
  34.         $pn->showNews("cat");
  35.  
  36.        echo "</table>";
  37.        echo $pn->createNav();
  38. }
  39.  
  40. require_once(FOOTERF);
  41. ?>
  42.  
  43. ###################################################
  44. read.php
  45. ###################################################
  46. <?php
  47. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  48. | Lucky News Nieuws systeem. (c) Copyright 2005 Lucas van Dijk
  49. | File: read.php
  50. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
  51.  
  52. require_once("init.php");
  53. define('PAGE_TITLE', "Lees nieuws");
  54. require_once(HEADERF);
  55. $action = (isset($_GET['action']) ? $_GET['action'] : "comments");
  56. $news_id = (isset($_GET['news_id']) ? $_GET['news_id'] : false);
  57.  
  58. if(!$news_id) {
  59.         show_error(GENERAL, "Geen id opgegeven");
  60. }
  61.  
  62. if(isset($_POST['post_comment'])) {
  63.         extract($_POST);
  64.  
  65.         if(!$name || !$comment) {
  66.                 show_error(MESSAGE, "Geen bericht of naam ingevuld. Ga terug en probeer het opnieuw");
  67.         }
  68.  
  69.         $name = htmlspecialchars(addslashes($name));
  70.         $comment = htmlspecialchars(addslashes($comment));
  71.         $sql = "INSERT INTO ".MPREFIX."comments (comment_news_id, comment_author, comment_date, comment_body, comment_ip)
  72.         VALUES (".$news_id.", '".$name."', ".time().", '".$comment."', '".$_SERVER['REMOTE_ADDR']."')";
  73.         if(!$result = mysql_query($sql)) {
  74.                 show_error(GENERAL, "Kon reactie niet toevoegen", __LINE__, __FILE__, $sql);
  75.         }
  76.         tablerender("Ok", "Uw reactie is toegevoegd.");
  77. }
  78.  
  79. if($action == "extended") {
  80.         $pn->setTable(MPREFIX."news");
  81.         $pn->setMax(1);
  82.         $pn->setOrder("news_id", "DESC");
  83.         $pn->setWhere(" WHERE news_id=".$news_id);
  84.         $pn->getTotal();
  85.         $pn->showNews("extended");
  86. }
  87.  
  88. if($action == "comments") {
  89.         //
  90.         // Show news item
  91.         //
  92.         $sql = "SELECT * FROM ".MPREFIX."news WHERE news_id=".$news_id;
  93.         if(!$result = mysql_query($sql)) {
  94.                 show_error(GENERAL, "Kon nieuws niet selecteren", __LINE__, __FILE__, $sql);
  95.         }
  96.         $newsrow = mysql_fetch_array($result);
  97.         $ns -> showNews_item($newsrow, "comments");
  98.  
  99.         echo "<h4>Reacties</h4>";
  100.         //
  101.         // Show comments
  102.         //
  103.         $pn->setTable(MPREFIX."comments");
  104.         $pn->setMax($config['max_comments']);
  105.         $pn->setOrder("comment_id", "DESC");
  106.         $pn->setWhere(" WHERE comment_news_id=".$news_id);
  107.         $pn->getTotal();
  108.         echo $pn->createNav();
  109.         $pn->showComments();
  110.         echo $pn->createNav();
  111.  
  112. }
  113.  
  114. if($action == "post_comment") {
  115.         $text = "
  116.         <form method='post' action='read.php?action=comments&amp;news_id=".$news_id."'>
  117.         <table width='100%' cellpadding='0' cellspacing=0' border='0'>
  118.         <tr>
  119.         <td width='50%' valign='top'>Naam:</td>
  120.         <td width='50%' valign='top'><input type='text' name='name' size='40' maxlength='20' class='tbox'></td>
  121.         </tr>
  122.         <tr>
  123.         <td width='50%' valign='top'>Reactie:</td>
  124.         <td width='50%' valign='top'><textarea id='commentform' name='comment' class='tbox' cols='40' rows='7'></textarea><br />".$msg -> render_help('commentform')."</td>
  125.         </tr>
  126.         <tr>
  127.         <td colspan='2' style='text-align: center'><input type='submit' name='post_comment' value='Toevoegen!' class='button'></td>
  128.         </tr>
  129.         </table>
  130.  
  131.         </form>";
  132.         tablerender("Plaats reactie", $text);
  133. }
  134.  
  135.  
  136. require_once(FOOTERF);
  137.  
  138.  
  139. ?>
  140.  
  141. ######################################################
  142. category.php
  143. ######################################################
  144. <?php
  145. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  146. | Lucky News Nieuws systeem. (c) Copyright 2005 Lucas van Dijk
  147. | File: category.php
  148. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
  149.  
  150. require_once("init.php");
  151. define('PAGE_TITLE', "Categorieën");
  152. require_once(HEADERF);
  153.  
  154.  
  155. if(!isset($_GET['cat_id'])) {
  156.         $pn->setTable(MPREFIX."categories");
  157.         $pn->setMax(1000000);
  158.         $pn->setOrder("category_name", "ASC");
  159.         $pn->showCats("cats");
  160. } else {
  161.         $id = (isset($_GET['cat_id']) ? $_GET['cat_id'] : false);
  162.         if(!$id) {
  163.                 show_error(GENERAL, "Geen id opgegeven");
  164.         }
  165.         $sql = "SELECT * FROM ".MPREFIX."categories WHERE category_id=".$id;
  166.         if(!$result = mysql_query($sql)) {
  167.                 show_error(GENERAL, "Kon categorie niet selecteren", __LINE__, __FILE__, $sql);
  168.         }
  169.         $catrow = mysql_fetch_array($result);
  170.  
  171.         $pn->setTable(MPREFIX."news");
  172.         $pn->setMax($config['max_news']);
  173.         $pn->setOrder("news_id", "DESC");
  174.         $pn->setWhere(" WHERE news_category=".$id);
  175.         $pn->getTotal();
  176.  
  177.         echo "<table width='100%' class='fborder'>
  178.         <tr>
  179.         <td colspan='3' class='forumheader'>".$catrow['category_name']."</td>
  180.         </tr>
  181.         ";
  182.         $pn -> showNews("cat");
  183.         echo "</table>";
  184.         echo $pn -> createNav();
  185. }
  186. require_once(FOOTERF);
  187.  
  188.  
  189.  
  190. ?>
  191.  
  192. ######################################################
  193. init.php
  194. ######################################################
  195. <?
  197. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  198. | Lucky News Nieuws systeem. (c) Copyright 2005 Lucas van Dijk
  199. | File: init.php
  200. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
  201.  
  202. include('config.php');
  203. error_reporting(E_ERROR | E_WARNING | E_PARSE);
  204. //error_reporting(E_ALL);
  205. $start_time = microtime();
  206.  
  207. if(!defined('PATH')) {
  208.         // Not installed, redirect
  209.         header("Location: install.php");
  210. }
  211.  
  212. //
  213. // Define some dirs
  214. //
  215. $link_prefix = "";
  216. $url_prefix = substr($_SERVER['PHP_SELF'], strlen(PATH), strrpos($_SERVER['PHP_SELF'], "/") + 1 - strlen(PATH));
  217. $tmp = explode("?", $url_prefix);
  218. $num_levels=substr_count($tmp[0], "/");
  219.  
  220. for ($i = 1; $i <= $num_levels; $i++) {
  221.         $link_prefix .= "../";
  222. }
  223. define('LN_ROOT', $link_prefix);
  224. define('LN_IMAGE', LN_ROOT."images/");
  225.  
  226. if (preg_match("/\[(.*?)\].*?/i", $_SERVER['QUERY_STRING'], $matches)) {
  227.         define("LN_QUERY", str_replace($matches[0], "", eregi_replace("/?".session_name().".*", "", $_SERVER['QUERY_STRING'])));
  228. } else {
  229.         define("LN_QUERY", eregi_replace("/?".session_name().".*", "", $_SERVER['QUERY_STRING']));
  230. }
  231.  
  232. //
  233. // Include some files
  234. //
  235. include_once("includes/error_functions.php");
  236. include_once("includes/functions_misc.php");
  237. include_once("includes/template.php");
  238. include_once("includes/page_nav.php");
  239. include_once("includes/show_class.php");
  240. include_once("includes/user_class.php");
  241. include_once("includes/message_class.php");
  242. include_once("includes/rss_class.php");
  243.  
  244. //
  245. // Define class vars
  246. //
  247. $tp = new template;
  248. $ns = new show;
  249. $pn = new pageNav;
  250. $us = new user;
  251. $msg = new message;
  252. $rss = new rss;
  253.  
  254. //
  255. // Connect to DB
  256. //
  257. $connect = mysql_connect($dbServer, $dbUser, $dbPass);
  258. $selectDb = mysql_select_db($dbDbName);
  259. if(!$connect || !$selectDb) {
  260.         show_error(CRITICAL, "Kon niet met de database verbinding maken.", __LINE__, __FILE__);
  261. }
  262. //
  263. // Create config array
  264. //
  265. $sql = "SELECT * FROM ".$mprefix."config";
  266. if(!$result = mysql_query($sql)) {
  267.         show_error(CRITICAL, "Fout bij het selecteren uit de config tabel!", __LINE__, __FILE__, $sql);
  268. }
  269. while($row = mysql_fetch_array($result)) {
  270.         $config[$row['config_name']] = $row['config_value'];
  271. }
  272.  
  273. //
  274. // Error levels
  275. //
  276. define('CRITICAL', 1);
  277. define('GENERAL', 2);
  278. define('MESSAGE', 3);
  279.  
  280. //
  281. // User levels
  282. //
  283. define('HEAD_ADMIN', 1);
  284. define('ADMIN', 2);
  285. define('MOD', 3);
  286. define('ALL', 4);
  287.  
  288. //
  289. // Other constants
  290. //
  291. define('SITENAME', $config['site_name']);
  292. define('SITEDISCLAIMER', $config['sitedisclaimer']);
  293. define('TIMEZONE', $config['timezone']);
  294. define('THEME', LN_ROOT."themes/".$config['theme']."/");
  295. define('MPREFIX', $mprefix);
  296.  
  297.  
  298. //
  299. // Theme
  300. //
  301. $themeFile = THEME."theme.php";
  302. if(file_exists($themeFile)) {
  303.         include($themeFile);
  304. } else {
  305.         show_error(CRITICAL, "Theme kan niet worden geladen! Zorg dat je een theme.php bestand in je theme hebt!");
  306. }
  307.  
  308. //
  309. // Header and footer
  310. //
  311. define("HEADERF", LN_ROOT."themes/templates/header.php");
  312. define("FOOTERF", LN_ROOT."themes/templates/footer.php");
  313.  
  314. //
  315. // If user logged in get information and set his ID
  316. //
  317. if(isset($_SESSION['user_id'])) {
  318.         $us -> setId($_SESSION['user_id']);
  319.         $user_info = $us -> getInfo();
  320. }
  321.  
  322. //
  323. // Check if banned
  324. //
  325. $ip = $_SERVER['REMOTE_ADDR'];
  326. $sql = "SELECT * FROM ".MPREFIX."banlist WHERE ban_ip='".$ip."'";
  327. if(!$result = mysql_query($sql)) {
  328.         show_error(GENERAL, "Kon IP niet selecteren!", __LINE__, __FILE__, $sql);
  329. }
  330. $aantal = mysql_num_rows($result);
  331. if($aantal > 0 && $user_info['user_rank'] != HEAD_ADMIN) {
  332.         require_once(HEADERF);
  333.         $ban = mysql_fetch_array($result);
  334.         tablerender("Fout!", "Je bent gebanned van deze site! Je mag de site niet meer bezoeken.<br />
  335.         <b>Rede:</b><br />".$ban['ban_reason']);
  336.         require_once(FOOTERF);
  338. }
  339. ?>
  340.  
  341. #######################################################
  342. login.php
  343. #######################################################
  344. <?php
  345. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  346. | Lucky News Nieuws systeem. (c) Copyright 2005 Lucas van Dijk
  347. | File: login.php
  348. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
  349.  
  350. require_once("init.php");
  351. define('PAGE_TITLE', "Inloggen");
  352. require_once(HEADERF);
  353.  
  354. if(!isset($_POST['submit'])) {
  355.              $text = "<form method='post' action='login.php'>
  356.              <table width='100%' class='fborder'>
  357.              <tr>
  358.              <td width='40%' class='forumheader3' valign='top'>Username:</td>
  359.              <td width='60%' class='forumheader3' valign='top'><input type='text' name='username' class='tbox' size='40'></td>
  360.              </tr>
  361.              <tr>
  362.              <td width='40%' class='forumheader3' valign='top'>Wachtwoord:</td>
  363.              <td width='60%' class='forumheader3' valign='top'><input type='password' name='password' class='tbox' size='40'></td>
  364.              </tr>
  365.              <tr>
  366.              <td colspan='2' class='forumheader2' style='text-align: center'><input type='submit' name='submit' value='Inloggen!' class='button'></td>
  367.              </tr>
  368.              </table>
  369.              </form>";
  370.              tablerender("Inloggen", $text);
  371. } else {
  372.         $password = md5($_POST['password']);
  373.         $username = $_POST['username'];
  374.  
  375.         $sql = "SELECT * FROM ".MPREFIX."users WHERE user_name='".$username."' AND user_pass='".$password."'";
  376.         if(!$result = mysql_query($sql)) {
  377.                 show_error(GENERAL, "Kon gebruikers niet selecteren.", __LINE__, __FILE__, $sql);
  378.         }
  379.         $aantal = mysql_num_rows($result);
  380.  
  381.         if($aantal > 0) {
  382.                 $user = mysql_fetch_array($result);
  383.                 $_SESSION['user_id'] = $user['user_id'];
  384.                 $text = "Je bent nu ingelogd. Klik <a href='".LN_ROOT."admin/index.php'>hier</a> om naar de admin te gaan.";
  385.         } else {
  386.                 $text = "Je hebt een verkeerd wachtwoord of gebruikersnaam op gegeven. Ga terug en probeer het opnieuw.";
  387.         }
  388.         tablerender("", $text);
  389. }
  390.  
  391. require_once(FOOTERF);
  392. ?>
  393.  
  394. ######################################################
  395. install.php
  396. ######################################################
  397. <?
  398. /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  399. | Lucky News Nieuws systeem. (c) Copyright 2005 Lucas van Dijk
  400. | File: install.php
  401. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
  402.  
  403. $stage = (isset($_GET['stage']) ? $_GET['stage'] : 1);
  404. $PATH = substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], "/"))."/";
  405. ?>
  406. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  407. <html>
  408. <head>
  409. <title>Lucky news installeren</title>
  410. <style type="text/css">
  411. body {
  412.         font-size: 12px;
  413.         color: #fff;
  414.         font-family: tahoma, verdana, arial, sans-serif;
  415.         background-color: #500000;
  416.         margin:0px;
  417.         text-align:left
  418. }
  419.  
  420. .selected {
  421.         background-color: #620000;
  422.         font-size: 12px;
  423.         border: 1px dashed #bebebe;
  424. }
  425. .notselected {
  426.         background-color: #840000;
  427.         font-size: 12px;
  428. }
  429. .darkrow {
  430.         background-color: #620000;
  431.         font-size: 12px;
  432. }
  433. .lightrow {
  434.         background-color: #840000;
  435.         font-size: 12px;
  436. }
  437. .background {
  438.         background-color: #840000;
  439.         font-size: 12px;
  440. }
  441. .button  {
  442.           color: #fff;
  443.           font-size: 10px;
  444.           font-family: Verdana, Arial, Helvetica, sans-serif;
  445.           background-color: #5d0000;
  446.           text-align: center;
  447.           border: solid 1px #370000
  448. }
  449. .tbox {
  450.        color: #fff;
  451.        font-size: 10px;
  452.        font-family: Verdana, Arial, Helvetica, sans-serif;
  453.        background-color: #620000;
  454.        border: solid 1px #370000
  455. }
  456. .ttl_area { background-color: #620000; width: 75%; text-align: center; padding-top: 2px; padding-bottom: 2px; border-bottom: 1px solid #370000 }
  457. </style>
  458. </head>
  459. <body>
  460.  
  461. <?
  463. <div align="center">
  464. <div class="ttl_area">
  465. <img src="images/logo.gif" alt="" border="0">
  466. </div>
  467. <table width="75%" cellpadding="0" cellspacing="0" border="0">
  468. <tr>
  469. <td colspan="3" class="lightrow">Stap:</td>
  470. </tr>
  471. <tr>
  472. <td width="33%" class="'.($stage == 1 ? "selected" : "notselected").'">1. Welkom!</td>
  473. <td width="33%" class="'.($stage == 2 ? "selected" : "notselected").'">2. Gegevens invoeren</td>
  474. <td width="33%" class="'.($stage == 3 ? "selected" : "notselected").'">3. Klaar!</td>
  475. </tr>
  476. </table>';
  477. if($stage == 1) {
  478.         echo '<table width="75%" cellpadding="0" cellspacing="0" border="0">
  479.         <tr>
  480.         <td class="background">
  481.         <h3>Welkom!</h3>
  482.         Welkom bij het installatie script van Lucky News. Dit script zal het nieuws systeem installeren.<br />
  483.         We hebben wel wat gegevens van je nodig dus klik op de knop om verder te gaan!
  484.         </td>
  485.         </tr>
  486.         <tr>
  487.         <td class="darkrow" style="text-align: center"><input type="button" value="Verder!" onclick="document.location=\''.$_SERVER['PHP_SELF'].'?stage=2\'" class="button"></td>
  488.         </tr>
  489.         </table>';
  490. } else if($stage == 2) {
  491.         echo '
  492.         <form method="post" action="install.php?stage=3">
  493.         <table width="75%" cellpadding="0" cellspacing="0" border="0">
  494.         <tr>
  495.         <td colspan="2" class="darkrow">Gegevens invoeren</td>
  496.         </tr>
  497.         <tr>
  498.         <td class="lightrow" colspan="2"><b>Mysql gegevens</b></td>
  499.         </tr>
  500.         <tr>
  501.         <td class="background">Mysql host</td>
  502.         <td class="background"><input type="text" name="mysql_host" class="tbox" size="35"></td>
  503.         </tr>
  504.         <tr>
  505.         <td class="background">Mysql username</td>
  506.         <td class="background"><input type="text" name="mysql_user" class="tbox" size="35"></td>
  507.         </tr>
  508.         <tr>
  509.         <td class="background">Mysql password</td>
  510.         <td class="background"><input type="text" name="mysql_pass" class="tbox" size="35"></td>
  511.         </tr>
  512.         <tr>
  513.         <td class="background">Mysql database</td>
  514.         <td class="background"><input type="text" name="mysql_db" class="tbox" size="35"></td>
  515.         </tr>
  516.         <tr>
  517.         <td class="background">Mysql prefix</td>
  518.         <td class="background"><input type="text" name="mprefix" class="tbox" size="35" value="ln_"></td>
  519.         </tr>
  520.         <tr>
  521.         <td colspan="2" class="lightrow"><b>Admin gegevens</b></td>
  522.         </tr>
  523.         <tr>
  524.         <td class="background">Username</td>
  525.         <td class="background"><input type="text" name="username" class="tbox" size="35"></td>
  526.         </tr>
  527.         <tr>
  528.         <td class="background">Email</td>
  529.         <td class="background"><input type="text" name="email" class="tbox" size="35"></td>
  530.         </tr>
  531.         <tr>
  532.         <td class="background">Wachtwoord</td>
  533.         <td class="background"><input type="password" name="pass1" class="tbox" size="35"></td>
  534.         </tr>
  535.         <tr>
  536.         <td class="background">Wachtwoord (bevestigen)</td>
  537.         <td class="background"><input type="password" name="pass2" class="tbox" size="35"></td>
  538.         </tr>
  539.         <tr>
  540.         <td colspan="2" class="darkrow" style="text-align: center"><input type="submit" class="button" name="submit" value="Installeren!"></td>
  541.         </tr>
  542.         </table>';
  543. } else if($stage == 3 && isset($_POST['submit'])) {
  544.         $text = '';
  545.  
  546.         extract($_POST);
  547.         if(!$mysql_host || !$mysql_user || !$mysql_pass  || !$mysql_db || !$username || !$pass1) {
  548.                 die("U heeft iets niet ingevuld! Ga terug en probeer het opnieuw!");
  549.         }
  550.  
  551.         //
  552.         // News table
  553.         //
  554.         $queries[] = "
  555.         CREATE TABLE ".$_POST['mprefix']."news (
  556.         news_id INT NOT NULL AUTO_INCREMENT ,
  557.         news_author VARCHAR( 100 ) NOT NULL ,
  558.         news_title VARCHAR( 255 ) NOT NULL ,
  559.         news_category INT NOT NULL ,
  560.         news_date INT NOT NULL ,
  561.         news_body TEXT NOT NULL ,
  562.         news_extended TEXT NOT NULL ,
  563.         news_active INT NOT NULL ,
  564.         news_allow_comments INT NOT NULL ,
  565.         PRIMARY KEY ( news_id )
  566.         );";
  567.  
  568.         //
  569.         // Catgeories table
  570.         //
  571.         $queries[] = "
  572.         CREATE TABLE ".$_POST['mprefix']."categories (
  573.         category_id INT NOT NULL AUTO_INCREMENT ,
  574.         category_desc VARCHAR( 255 ) NOT NULL ,
  575.         category_name VARCHAR( 100 ) NOT NULL ,
  576.         category_icon VARCHAR( 150 ) NOT NULL ,
  577.         PRIMARY KEY ( category_id )
  578.         );";
  579.  
  580.         //
  581.         // Users table
  582.         //
  583.         $queries[] = "
  584.         CREATE TABLE ".$_POST['mprefix']."users (
  585.         user_id INT NOT NULL AUTO_INCREMENT ,
  586.         user_name VARCHAR( 100 ) NOT NULL ,
  587.         user_email VARCHAR( 100 ) NOT NULL ,
  588.         user_pass VARCHAR( 150 ) NOT NULL ,
  589.         user_rank INT NOT NULL ,
  590.         PRIMARY KEY ( user_id )
  591.         );";
  592.  
  593.         //
  594.         // Config table
  595.         //
  596.         $queries[] = "
  597.         CREATE TABLE ".$_POST['mprefix']."config (
  598.         config_name TEXT NOT NULL ,
  599.         config_value TEXT NOT NULL
  600.         );";
  601.  
  602.         //
  603.         // News comments table
  604.         //
  605.         $queries[] = "CREATE TABLE ".$_POST['mprefix']."comments (
  606.         comment_id INT NOT NULL AUTO_INCREMENT ,
  607.         comment_news_id INT NOT NULL ,
  608.         comment_author VARCHAR( 100 ) NOT NULL ,
  609.         comment_date INT NOT NULL ,
  610.         comment_body TEXT NOT NULL ,
  611.         comment_ip VARCHAR( 100 ) NOT NULL ,
  612.         PRIMARY KEY ( comment_id )
  613.         );";
  614.  
  615.         //
  616.         // Banlist table
  617.         //
  618.         $queries[] = "CREATE TABLE ".$_POST['mprefix']."banlist (
  619.         ban_id INT NOT NULL AUTO_INCREMENT ,
  620.         ban_ip VARCHAR( 20 ) NOT NULL ,
  621.         ban_reason TEXT NOT NULL ,
  622.         PRIMARY KEY ( ban_id )
  623.         );";
  624.  
  625.         //
  626.         // Config values
  627.         //
  628.         $queries[] = "
  629.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('theme', 'Raid Silver')";
  630.         $queries[] = "
  631.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('max_news', '5')";
  632.         $queries[] = "
  633.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('max_comments', '10')";
  634.         $queries[] = "
  635.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('max_admin', '15')";
  636.         $queries[] = "
  637.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('site_name', 'Lucky News nieuws systeem')";
  638.         $queries[] = "
  639.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('site_desc', 'Een beschrijving over je site. ')";
  640.         $queries[] = "
  641.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('timezone', '1')";
  642.         $queries[] = "
  643.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('sitedisclaimer', '&copy; Copyright 2005 bij (je site naam).')";
  644.         $queries[] = "
  645.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('date_format', 'd M Y H:i:s')";
  646.         $queries[] = "
  647.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('max_rss', '10')";
  648.         $queries[] = "
  649.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('filter', 'worden,die,gefilterd,moeten,worden')";
  650.         $queries[] = "
  651.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('logo', '{LN_IMAGE}logo.gif')";
  652.         $queries[] = "
  653.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('filter_replace', '-filter-')";
  654.         $queries[] = "
  655.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('enable_bbcode', 'TRUE')";
  656.         $queries[] = "
  657.         INSERT INTO ".$_POST['mprefix']."config (config_name, config_value) VALUES ('enable_smilies', '1')";
  658.  
  659.  
  660.         //
  661.         //Admin
  662.         //
  663.         $queries[] = "
  664.         INSERT INTO ".$_POST['mprefix']."users (user_name, user_email, user_pass, user_rank) VALUES ('".$_POST['username']."', '".$_POST['email']."', '".md5($_POST['pass1'])."', 1)";
  665.  
  666.         if($_POST['pass1'] != $_POST['pass2']) {
  667.                 die("De wachtwoorden komen niet overeen! Ga terug en probeer het opnieuw!");
  668.         }
  669.  
  670.         $connect = mysql_connect($_POST['mysql_host'], $_POST['mysql_user'], $_POST['mysql_pass']);
  671.         mysql_select_db($_POST['mysql_db']);
  672.  
  673.         if(!$connect) {
  674.                 $text .= "<b>Kon niet met de database verbinden!</b>";
  675.                 $error = true;
  676.         }
  677.         foreach($queries as $sql_query) {
  678.                 $text .= $sql_query;
  679.                 if(!$result = mysql_query($sql_query)) {
  680.                         $text .= "<br /><font style='color: #FF0000'>Mislukt: ".mysql_error()."</font><br /><br />";
  681.                         $error = true;
  682.                 } else {
  683.                         $text .= "<br /><font style='color: #00FF00'>Gelukt!</font><br /><br />";
  684.                 }
  685.         }
  686.  
  687.  
  688.         if(is_writeable('config.php')) {
  689.                 if($file = fopen('config.php', "w")) {
  690.                         $write = "
  691. <?
  692. //
  693. // Lucky news auto generated config file
  694. //
  695.  
  696. \$dbServer = \"".$_POST['mysql_host']."\";
  697. \$dbUser = \"".$_POST['mysql_user']."\";
  698. \$dbPass = \"".$_POST['mysql_pass']."\";
  699. \$dbDbName = \"".$_POST['mysql_db']."\";
  700. \$mprefix = \"".$_POST['mprefix']."\";
  701.  
  702. define('PATH', '".$PATH."');
  703. ?>
  704.                         ";
  705.                         if(!fwrite($file, $write)) {
  706.                                 $text .= "<font style='color: #FF0000;'>Kon de gegevens niet schrijven naar het config.php bestand!</font><br /><br />";
  707.                                 $error = true;
  708.                         }
  709.                 } else {
  710.                         $text .= "<font style='color: #FF0000;'>Kon config.php niet openen!</font><br /><br />";
  711.                         $error = true;
  712.                 }
  713.         } else {
  714.                 $text .= "<font style='color: #FF0000;'>config.php is niet beschrijfbaar!</font><br /><br />";
  715.                 $error = true;
  716.         }
  717.  
  718.         if(!isset($error)) {
  719.                 $text .= "<b>Alles is succesvol geinstalleerd! Verwijder dit bestand nu van de server en ga naar je admin om alles te configureren.</b>";
  720.         } else {
  721.                 $text .= "<b>Er is een fout opgetreden. Als je niet weet hoe je het moet oplossen, neem dan contact op met de maker.</b>";
  722.         }
  723.  
  724.  
  725.  
  726.  
  727.         echo '
  728.         <table width="75%" cellpadding="0" cellspacing="0" border="0">
  729.         <tr>
  730.         <td class="darkrow">Installeren...</td>
  731.         </tr>
  732.         <tr>
  733.         <td class="background">
  734.         '.$text.'
  735.         </td>
  736.         </tr>
  737.         </table>';
  738. } else {
  739.         $stage = 1;
  740. }
  741. ?>
  742. </div>
  743. </body>
  744. </html>
  745.  
  746. #######################################
  747. ER ZIJN NOG MEER BESTANDEN MAAR DAT IS ZOVEEL EN HEB NIET ZO ZIN OM DAT ALLEMAAL TE GAAN PLAATSEN. DOWNLOAD HET MAAR VOOR DE SORCE VAN DE ANDERE BESTANDEN
  748. ############################################
Download code! Download code (.txt)

 Bekijk een voorbeeld van dit script!
 Stemmen
Niet ingelogd.

 Reacties
Post een reactie
Lees de reacties (27)
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.087s