Jump to content
xisto Community

alex1985

Members
  • Content Count

    398
  • Joined

  • Last visited

Everything posted by alex1985

  1. Do anybody know where I can obtain good tools for SSH ports? I need them to bypass University security settings to download files from Torrent or similar programs!University closed some important ports for me!
  2. Thanks. I was waiting for this answer for several months!
  3. Do you know how I can pass wireless security settings?
  4. I can not access to my FTP server, and I am sure the data which I am entering. The FTP manager says that wrong data, password or username. But, I am sure that it is the correct ones, the ones I used ti access the forum.Please, help me somebody.
  5. I do apologize, I think I forgot to post it over here in the beginning of this topic. Here, he is: <?php$host = "localhost";$dbuser = "....";$dbpassword = "....";$dbname = "....";$connection = mysql_connect($host, $dbuser, $password) or die(mysql_error());mysql_select_db($dbname) or die(mysql_error());?>
  6. I did not get your point! Can you state your ideas more clearly!!
  7. Hey, I found a new web-site, but I do not know if it pays.The process to earn with this web-site is following:1. For example, if you have your personal web-site which contains movies, music and so on.2. You convert those links (any files) with the web-site I gave in title of the topic.3. Post them on your web-site like portal, the first 16 seconds, a user will face advertisement, after that it will lead him to your original link.That's all! Only one disadvantage, this site pays only for American IPs as my friend told me.
  8. Does it really work? Who tried it, please post some replies to know the truth!
  9. The same question. Does it really works?
  10. OK. Let me know, if you did some good changes to it. Send some message to my PM, because notifications sometimes do not arrive at my email!
  11. Just show me the instance of it!
  12. This tutorial will teach you how to make a full news cms, this tutorial is quite long and don't complain about spelling mistakes! To start off we need to create our mysql for our news cms. CREATE TABLE `news` (`id` int(10) NOT NULL auto_increment,`title` varchar(50) NOT NULL default '',`author` varchar(30) NOT NULL default '',`content` text NOT NULL,`postdate` varchar(100) NOT NULL default '',PRIMARY KEY (`id`)) TYPE=MyISAM;CREATE TABLE `news_comments` (`id` int(10) NOT NULL auto_increment,`author` varchar(30) NOT NULL default '',`content` text NOT NULL,`postdate` varchar(100) NOT NULL default '',`nid` varchar(30) NOT NULL default '',PRIMARY KEY (`id`)) TYPE=MyISAM; This will create 2 tables, 1 table for news and one for news comments! The next part of the tutorial will show you have to create the BBCode file, if you wish to learn how to make your own read my tutorial here! bbcode.php <?function bbcode($content){ // our nice bbcode function$content = nl2br(htmlspecialchars($content)); // our message that we want to put the bbcode in $bbcode = array( // The BBCode tags "'[b](.*?)[/b]'", // Bold Tag [b]Bold[/b] "'[i](.*?)[/i]'", // Italics Tag [i]Italics[/i] "'[u](.*?)[/u]'", // Underline Tag [u]Underlined[/u] "'[strike](.*?)[/strike]'", // Stroked Out Tag [strike]Strike[/strike] "'[img=(.*?)]'", // Image Tag "'[url=http://(.*?)](.*?)[/url]'", // Url Tag [url=http://yoursite.com]A website =D[/url] "'[url=http://(.*?)](.*?)[/url]'", // Another Url Tag [url]yoursite.com[url] ); $html = array( // The HTML counter part of the tags "<strong>1</strong>", // Bold "<em>1</em>", // Italics "<u>1</u>", // Underlined "<strike>1</strike>", // Stroked out text "<a href='1' target='_BLANK'>2</a>", // Url 1 opens in a new window "<a href='1' target='_BLANK'>1</a>", // Url 2 opens in a new window "<img border='0' src='1'>", // Image ); $content = preg_replace($bbcode, $html, $content); // replaces all BBCode tags with their HTML counter parts return nl2br($content);}?> Save the code above as bbcode.php and remember to read the comments so you can learn! Ok so now we need a page to display our news, read the comments so you know what?s going on! news.php <?phpob_start(); // allows us to use cookiesinclude("config.php"); // includes the config fileinclude("bbcode.php"); // includes our bbcode file$q = mysql_query("SELECT * FROM news ORDER BY id DESC"); // querys the databaseif (mysql_num_rows($q) == "0") { // if there is nothing than we echo an error echo ("There is no news in the database!"); // opps nothing}while($r=mysql_fetch_array($q)){ // fetches array $id = $r['id']; // news id $title = $r['title']; // news title $author = $r['author']; // news author $postdate = $r['postdate']; // news date $content = bbcode($r['content']); // news content echo ("<tr> // displays our news <td><a href='news_comments.php?view=news&id=$id'>$title</a> Posted by <a href='/kurt/members.php?user=$author'>$author</a> At $postdate<br></td> </tr> <tr> <td>$content<br>[<a href='news_comments.php?view=addcomment&id=$id'>Add a comment</a>] [<a href='news_comments.php?view=news&id=$id'>View comments</a>]<br><br></td> </tr>");}if($logged[username] && $logged[level] ==5) echo ("[<a href='news_admin.php'>Administrative Panel</a>]"); // if the user is an admin display a link to the admin panelif(!$logged[username]) echo ("[<a href='login.php'>Login</a>] [<a href='register.php'>Register</a>]"); // if the user is a guest display links to login or register?> Save the code above as news.php, and remember to read the comments so you can learn. Now we are going to make a file to display the news comments, remember to read the comments! news_comments.php <?phpob_start();include("config.php");if ($logged['username']){switch($_GET['view']){case 'news':$id = $_GET['id'];$select = "select * from news where id=$id";$select2 = "select * from news_comments where nid=$id ORDER BY id DESC";$getnews = mysql_query($select)or die(mysql_error());$getcomments = mysql_query($select2);if (mysql_num_rows($getnews) == "0") {echo 'Unable to find the article in our database';exit();}$row = mysql_fetch_array($getnews)or die(mysql_error());$nid = $row['id'];$ntitle = $row['title'];$ncontent = $row['content'];$nauthor = $row['author'];$postdate = $row['postdate']; echo ("<tr> <td>$ntitle Posted by <a href='members.php?user=$nauthor'>$nauthor</a> At $postdate<br></td> </tr> <tr> <td>$ncontent<br><br>Comments:<br></td> </tr>");if (mysql_num_rows($getcomments) == "0") {echo("There are no comments!<br>[<a href='news_comments.php?view=addcomment&id=$id'>Add a comment</a>]");}if($logged[username] && $logged[level] ==5)while($rowc= mysql_fetch_array($getcomments)){$cauthor = $rowc['author'];$ccomment = $rowc['content'];$cdate = $rowc['postdate'];$cid = $rowc['id']; echo ("<tr> <td>Comment Posted by [<a href="news_admin.php?view=editcomment&id=$cid">Edit</a>] [<a href="news_admin.php?view=deletecomment&id=$cid">Delete</a>]<br></td> </tr> <tr> <td>$ccomment<br><br></td> </tr>"); }while($rowc= mysql_fetch_array($getcomments)){$cauthor = $rowc['author'];$ccomment = $rowc['content'];$cdate = $rowc['postdate']; echo ("<tr> <td>Comment Posted by <a href='members.php?user=$nauthor'>$cauthor</a> At $cdate<br></td> </tr> <tr> <td>$ccomment<br><br></td> </tr>");}echo("[<a href='news_comments.php?view=addcomment&id=$id'>Add a comment</a>]");break;case 'addcomment':ob_start();include("config.php");$id = $_GET['id'];if(isset($_POST['add_comment'])) {$author = $logged['username'];$postdate = date('g:i A, l F j');$comment = $_POST['comment'];$nid = $_GET['id'];$sql = "INSERT INTO news_comments ( `author` , `postdate`, `content`, `nid`) VALUES ('$author', '$postdate', '$comment', '$nid')";$addblog = mysql_query($sql)or die(mysql_error());header("Location: news.php");}else{echo ("<form method='post' name='addcomment'><tr> <td height='20'>Comment:</td></tr><tr> <td><br><textarea rows='5' cols='35' name='comment'>Type your comment here!</textarea><br> <input type='submit' name='add_comment' value='Submit'></td></tr></form>");}}if (!isset($_GET['id']))header("Location:news.php");}else{exit('Hey! you need to [<a href='utsagamingservers.com/kurt/cpanel?view=login&%2339; first!');}?> Save the above code as news_comments.php and read the comments! Now for the admin panel! news_admin.php <?ob_start();include('config.php');if ($logged['level'] == '5') {switch($_GET['view']) {case "addnews" :include("config.php");if(isset($_POST['add_news'])) {$title=$_POST['title'];$author=$logged['username'];$postdate=date("g:i A, l F j");$content=$_POST['content'];$sql = "INSERT INTO news (title, author, postdate, content) VALUES ('$title', '$author', '$postdate', '$content')";$addnews = mysql_query($sql)or die(mysql_error());header("Location:news.php");}else{echo ("<form method='post' name='addnews'><tr> <td height='20'>Article Title:<br></td></tr><tr> <td> <input class='content_box' Type='text' name='title' value='Article's Title'></td></tr><tr> <td height='20'><br>News Article:</td></tr><tr> <td><br><textarea rows='15' cols='95' name='content'>Type your article here!</textarea><br> <input type='submit' name='add_news' value='Submit'></td></tr></form>");}break;case "editnews" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the news article in the database!';exit();}if(isset($_POST['edit_news'])) {$title=$_POST['title'];$content=$_POST['content'];$sql = mysql_query("update news set title = '$title', content = '$content' where id = '$id'");echo ("<meta http-equiv='Refresh' content='1; URL=news.php'/>Your article has been updated! You will now be redirected");exit;}else{$get = mysql_query("select * from news where id=$id");$get = mysql_fetch_array($get);echo ("<form method='post' name='editnews'><tr> <td height='20'>Article Title:<br></td></tr><tr> <td> <input Type='text' name='title' value='$get[title]'></td></tr><tr> <td height='20'><br>News Article:</td></tr><tr> <td><br><textarea rows='15' cols='95' name='content'>$get[content]</textarea><br> <input type='submit' name='edit_news' value='Submit'></td></tr></form>");}break;case "deletenews" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the news article in the database!';exit();}$delete = mysql_query("DELETE FROM news WHERE id = '$id'") or die(mysql_error());$delete2 = mysql_query("DELETE FROM news_comments WHERE nid = '$id'") or die(mysql_error());echo("<meta http-equiv='Refresh' content='1; URL=news.php'/>Your article has been deleted! You will now be redirected");break;case "deletecommet" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news_comments where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the comment in the database!';exit();}$delete = mysql_query("DELETE FROM `news_comments` WHERE id = '$id'") or die(mysql_error());echo("<meta http-equiv='Refresh' content='1; URL=news.php'/>The comment has been deleted! You will now be redirected");break;case "editcomment" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news_comments where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the comment in the database!';exit();}if(isset($_POST['edit_comment'])) {$comment=$_POST['comment'];$sql = mysql_query("update news_comments set content = '$content' where id = '$id'");echo ("<meta http-equiv='Refresh' content='1; URL=news.php'/>The comment has been updated! You will now be redirected");exit;}else{$get = mysql_query("select * from news_comments where id=$id");$get = mysql_fetch_array($get);echo ("<form method='post' name='editcomment'><tr> <td height='20'>Comment:</td></tr><tr> <td><br><textarea rows='15' cols='95' name='comment'>$get[content]</textarea><br> <input type='submit' name='edit_comment' value='Submit'></td></tr></form>");}break;default:echo "Welcome to your news admin area $logged[username]! [<a href='news_admin.php?view=addnews'>Add News</a>]<br><br>";$q = mysql_query("SELECT * FROM news ORDER BY id DESC");if (mysql_num_rows($q) == "0") { echo ("There is no news in the database! [<a href='news_admin.php?view=addnews'>Add News</a>]");}while($r=mysql_fetch_array($q)){ $id = $r['id']; $title = $r['title']; $author = $r['author']; $postdate = $r['postdate']; echo ("<tr> <td><a href='news_comments.php?view=news&id=$id'>$title</a> Posted by <a href='members.php?user=$author'>$author</a> At $postdate [<a href='news_admin.php?view=editnews&id=$id'>Edit</a>] [<a href='news_admin.php?view=deletenews&id=$id'>Delete</a>]<br></td> </tr>");}break;}}else{exit('Hey! where do you think your going?');}?> Save the above code as news_admin.php and read the comments! And that's all folks! Enjoy!
  13. Hello, guys! I found several web-sites which pay you for downloads of your files. It was approved on other forums that are paying defenitely; they are not scam projects. Here, they are:1. http://forums.xisto.com/no_longer_exists/.'>http://forums.xisto.com/no_longer_exists/. http://www.letitbit.com/3. http://www.vip-file.com/. http://forums.xisto.com/no_longer_exists/.'>http://forums.xisto.com/no_longer_exists/. http://forums.xisto.com/no_longer_exists/ There are more information on their official web-sites. To know more about it, please visit them. But, if you have questions, I may answer them.
  14. Listen, guys! I forgot that link and can not access that web-site to see my earnings! The ones who got the link, can you post that link over here?
  15. This web-site really pays I saw some payments online!
  16. alex1985

    Ipod Tools ???

    More soft, please. Enough chatting and talking!
  17. Which kind of videos are allowed to post on youtube?
  18. Thanks, I got it and going to download it!
  19. Anymore replies? I need some tool to strengthen my wireless signal?!
  20. Hi, I got some problems mainly related to connection issue.Firstly, I can connect to FTP server to upload files.Secondly, I can not access cpanel account, it does not accept my registered data, the one which is totally right.I do not what happened because it was working fine before.
  21. You are absolutely right! It happens like that usually
  22. A really nice tutorial how to create a full news system, a good guide to follow. The features are: 1. Admin Panel a) Add News Edit News c) Delete News 2. Comments a) Add Comments Delete Comments c) Edit Comments 3. BBCode a) Bold Tags/Italics Tags Underlined Tags c) Strike Through Tags d) Link Tags e) Image Tags f) Code Tags g) E-Mail Tags At first, you need to create certain (2) tables which are news and comments for your system able to run: CREATE TABLE `news` (`id` int(10) NOT NULL auto_increment,`title` varchar(50) NOT NULL default '',`author` varchar(30) NOT NULL default '',`content` text NOT NULL,`postdate` varchar(100) NOT NULL default '',PRIMARY KEY (`id`)) TYPE=MyISAM;CREATE TABLE `news_comments` (`id` int(10) NOT NULL auto_increment,`author` varchar(30) NOT NULL default '',`content` text NOT NULL,`postdate` varchar(100) NOT NULL default '',`nid` varchar(30) NOT NULL default '',PRIMARY KEY (`id`)) TYPE=MyISAM; Secondly, you need to create a file which is called "bbcode.php", I guess, you know for what, because the name of it sounds its function. <?function bbcode($content){ // our nice bbcode function$content = nl2br(htmlspecialchars($content)); // our message that we want to put the bbcode in $bbcode = array( // The BBCode tags "'[b](.*?)[/b]'", // Bold Tag [b]Bold[/b] "'[i](.*?)[/i]'", // Italics Tag [i]Italics[/i] "'[u](.*?)[/u]'", // Underline Tag [u]Underlined[/u] "'[strike](.*?)[/strike]'", // Stroked Out Tag [strike]Strike[/strike] "'[img=(.*?)]'", // Image Tag "'[url=http://(.*?)](.*?)[/url]'", // Url Tag [url=http://yoursite.com]A website =D[/url] "'[url=http://(.*?)](.*?)[/url]'", // Another Url Tag [url]yoursite.com[url] ); $html = array( // The HTML counter part of the tags "<strong>1</strong>", // Bold "<em>1</em>", // Italics "<u>1</u>", // Underlined "<strike>1</strike>", // Stroked out text "<a href='1' target='_BLANK'>2</a>", // Url 1 opens in a new window "<a href='1' target='_BLANK'>1</a>", // Url 2 opens in a new window "<img border='0' src='1'>", // Image ); $content = preg_replace($bbcode, $html, $content); // replaces all BBCode tags with their HTML counter parts return nl2br($content);}?> Thirdly, we need to create a page that may display our news, which is "news.php": <?phpob_start(); // allows us to use cookiesinclude("config.php"); // includes the config fileinclude("bbcode.php"); // includes our bbcode file$q = mysql_query("SELECT * FROM news ORDER BY id DESC"); // querys the databaseif (mysql_num_rows($q) == "0") { // if there is nothing than we echo an error echo ("There is no news in the database!"); // opps nothing}while($r=mysql_fetch_array($q)){ // fetches array $id = $r['id']; // news id $title = $r['title']; // news title $author = $r['author']; // news author $postdate = $r['postdate']; // news date $content = bbcode($r['content']); // news content echo ("<tr> // displays our news <td><a href='news_comments.php?view=news&id=$id'>$title</a> Posted by <a href='/kurt/members.php?user=$author'>$author</a> At $postdate<br></td> </tr> <tr> <td>$content<br>[<a href='news_comments.php?view=addcomment&id=$id'>Add a comment</a>] [<a href='news_comments.php?view=news&id=$id'>View comments</a>]<br><br></td> </tr>");}if($logged[username] && $logged[level] ==5) echo ("[<a href='news_admin.php'>Administrative Panel</a>]"); // if the user is an admin display a link to the admin panelif(!$logged[username]) echo ("[<a href='login.php'>Login</a>] [<a href='register.php'>Register</a>]"); // if the user is a guest display links to login or register?> Fourthly, we need to create a file named "news_comments.php" in order to display comments: <?phpob_start();include("config.php");if ($logged['username']){switch($_GET['view']){case 'news':$id = $_GET['id'];$select = "select * from news where id=$id";$select2 = "select * from news_comments where nid=$id ORDER BY id DESC";$getnews = mysql_query($select)or die(mysql_error());$getcomments = mysql_query($select2);if (mysql_num_rows($getnews) == "0") {echo 'Unable to find the article in our database';exit();}$row = mysql_fetch_array($getnews)or die(mysql_error());$nid = $row['id'];$ntitle = $row['title'];$ncontent = $row['content'];$nauthor = $row['author'];$postdate = $row['postdate']; echo ("<tr> <td>$ntitle Posted by <a href='members.php?user=$nauthor'>$nauthor</a> At $postdate<br></td> </tr> <tr> <td>$ncontent<br><br>Comments:<br></td> </tr>");if (mysql_num_rows($getcomments) == "0") {echo("There are no comments!<br>[<a href='news_comments.php?view=addcomment&id=$id'>Add a comment</a>]");}if($logged[username] && $logged[level] ==5)while($rowc= mysql_fetch_array($getcomments)){$cauthor = $rowc['author'];$ccomment = $rowc['content'];$cdate = $rowc['postdate'];$cid = $rowc['id']; echo ("<tr> <td>Comment Posted by [<a href="news_admin.php?view=editcomment&id=$cid">Edit</a>] [<a href="news_admin.php?view=deletecomment&id=$cid">Delete</a>]<br></td> </tr> <tr> <td>$ccomment<br><br></td> </tr>"); }while($rowc= mysql_fetch_array($getcomments)){$cauthor = $rowc['author'];$ccomment = $rowc['content'];$cdate = $rowc['postdate']; echo ("<tr> <td>Comment Posted by <a href='members.php?user=$nauthor'>$cauthor</a> At $cdate<br></td> </tr> <tr> <td>$ccomment<br><br></td> </tr>");}echo("[<a href='news_comments.php?view=addcomment&id=$id'>Add a comment</a>]");break;case 'addcomment':ob_start();include("config.php");$id = $_GET['id'];if(isset($_POST['add_comment'])) {$author = $logged['username'];$postdate = date('g:i A, l F j');$comment = $_POST['comment'];$nid = $_GET['id'];$sql = "INSERT INTO news_comments ( `author` , `postdate`, `content`, `nid`) VALUES ('$author', '$postdate', '$comment', '$nid')";$addblog = mysql_query($sql)or die(mysql_error());header("Location: news.php");}else{echo ("<form method='post' name='addcomment'><tr> <td height='20'>Comment:</td></tr><tr> <td><br><textarea rows='5' cols='35' name='comment'>Type your comment here!</textarea><br> <input type='submit' name='add_comment' value='Submit'></td></tr></form>");}}if (!isset($_GET['id']))header("Location:news.php");}else{exit('Hey! you need to [<a href='utsagamingservers.com/kurt/cpanel?view=login&%2339; first!');}?> Fifthly, "news_admin.php" will be used for administration purposes: <?ob_start();include('config.php');if ($logged['level'] == '5') {switch($_GET['view']) {case "addnews" :include("config.php");if(isset($_POST['add_news'])) {$title=$_POST['title'];$author=$logged['username'];$postdate=date("g:i A, l F j");$content=$_POST['content'];$sql = "INSERT INTO news (title, author, postdate, content) VALUES ('$title', '$author', '$postdate', '$content')";$addnews = mysql_query($sql)or die(mysql_error());header("Location:news.php");}else{echo ("<form method='post' name='addnews'><tr> <td height='20'>Article Title:<br></td></tr><tr> <td> <input class='content_box' Type='text' name='title' value='Article's Title'></td></tr><tr> <td height='20'><br>News Article:</td></tr><tr> <td><br><textarea rows='15' cols='95' name='content'>Type your article here!</textarea><br> <input type='submit' name='add_news' value='Submit'></td></tr></form>");}break;case "editnews" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the news article in the database!';exit();}if(isset($_POST['edit_news'])) {$title=$_POST['title'];$content=$_POST['content'];$sql = mysql_query("update news set title = '$title', content = '$content' where id = '$id'");echo ("<meta http-equiv='Refresh' content='1; URL=news.php'/>Your article has been updated! You will now be redirected");exit;}else{$get = mysql_query("select * from news where id=$id");$get = mysql_fetch_array($get);echo ("<form method='post' name='editnews'><tr> <td height='20'>Article Title:<br></td></tr><tr> <td> <input Type='text' name='title' value='$get[title]'></td></tr><tr> <td height='20'><br>News Article:</td></tr><tr> <td><br><textarea rows='15' cols='95' name='content'>$get[content]</textarea><br> <input type='submit' name='edit_news' value='Submit'></td></tr></form>");}break;case "deletenews" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the news article in the database!';exit();}$delete = mysql_query("DELETE FROM news WHERE id = '$id'") or die(mysql_error());$delete2 = mysql_query("DELETE FROM news_comments WHERE nid = '$id'") or die(mysql_error());echo("<meta http-equiv='Refresh' content='1; URL=news.php'/>Your article has been deleted! You will now be redirected");break;case "deletecommet" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news_comments where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the comment in the database!';exit();}$delete = mysql_query("DELETE FROM `news_comments` WHERE id = '$id'") or die(mysql_error());echo("<meta http-equiv='Refresh' content='1; URL=news.php'/>The comment has been deleted! You will now be redirected");break;case "editcomment" :include("config.php");$id = $_GET['id'];if(!$_GET['id']){header("Location:news_admin.php");}$select = mysql_query("select * from news_comments where id=$id");if (mysql_num_rows($select) == "0") {echo 'Unable to find the comment in the database!';exit();}if(isset($_POST['edit_comment'])) {$comment=$_POST['comment'];$sql = mysql_query("update news_comments set content = '$content' where id = '$id'");echo ("<meta http-equiv='Refresh' content='1; URL=news.php'/>The comment has been updated! You will now be redirected");exit;}else{$get = mysql_query("select * from news_comments where id=$id");$get = mysql_fetch_array($get);echo ("<form method='post' name='editcomment'><tr> <td height='20'>Comment:</td></tr><tr> <td><br><textarea rows='15' cols='95' name='comment'>$get[content]</textarea><br> <input type='submit' name='edit_comment' value='Submit'></td></tr></form>");}break;default:echo "Welcome to your news admin area $logged[username]! [<a href='news_admin.php?view=addnews'>Add News</a>]<br><br>";$q = mysql_query("SELECT * FROM news ORDER BY id DESC");if (mysql_num_rows($q) == "0") { echo ("There is no news in the database! [<a href='news_admin.php?view=addnews'>Add News</a>]");}while($r=mysql_fetch_array($q)){ $id = $r['id']; $title = $r['title']; $author = $r['author']; $postdate = $r['postdate']; echo ("<tr> <td><a href='news_comments.php?view=news&id=$id'>$title</a> Posted by <a href='members.php?user=$author'>$author</a> At $postdate [<a href='news_admin.php?view=editnews&id=$id'>Edit</a>] [<a href='news_admin.php?view=deletenews&id=$id'>Delete</a>]<br></td> </tr>");}break;}}else{exit('Hey! where do you think your going?');}?> Lastly, you need create the configuration file that will access your database settings ("config.php"): <?php$host = "localhost";$dbuser = "username";$dbpassword = "password";$dbname = "table/database";$connection = mysql_connect($host, $dbuser, $password) or die(mysql_error());mysql_select_db($dbname) or die(mysql_error());?> That's it. Any replies to improve it are welcomed!!!
  23. Anymore replies, still waiting?!
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.