(Help) PHP Error?

Kristopher · Aug 6, 2013

PHP:

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta http-equiv="content-type" content="text/html; charset=utf-8">
        <title>{hotelName} - News</title>
        <div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_US/all.js#xfbml=1&appId=138881106159184";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
        <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css">
        <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs2.js"></script>
        <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/visual.js"></script>
        <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/libs.js"></script>
        <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/common.js"></script>
        <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/fullcontent.js"></script>
 
        <script type="text/javascript">
            document.habboLoggedIn = true;
            var habboName = "{username}";
            var habboId = "{userid}";
            var habboReqPath = "";
            var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
            var habboImagerUrl = "[url]http://www.habbo.com/habbo-imaging/[/url]";
            var habboPartner = "";
            var habboDefaultClientPopupUrl = "{url}/client";
            window.name = "habboMain";
            if (typeof HabboClient != "undefined") {
                HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
                HabboClient.maximizeWindow = true;
            }
        </script>
 
        <!--[if IE 8]>
            <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie8.css" type="text/css">
        <![endif]-->
        <!--[if lt IE 8]>
            <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie.css" type="text/css" />
        <![endif]-->
        <!--[if lt IE 7]>
            <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/ie6.css" type="text/css" />
            <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/pngfix.js"></script>
            <script type="text/javascript">
                try { document.execCommand('BackgroundImageCache', false, true); } catch(e) {}
            </script>
            <style type="text/css">
                body { behavior: url({url}/app/tpl/skins/Habbo/js/csshover.htc); }
            </style>
        <![endif]-->
    </head>
 
    <body id="news">
<div id="overlay"></div>
        <div id="header-container">
            <div id="header" class="clearfix">
                <h1><a href="{url}/"></a></h1>
                <div id="subnavi">
                    <div id="subnavi-user">
                        <ul>
                    <li id="myfriends"><a href="#"><span>My Friends</span></a><span class="r"></span></li>
                    <li id="mygroups"><a href="#"><span>My Groups</span></a><span class="r"></span></li>
                    <li id="myrooms"><a href="#"><span>My Rooms</span></a><span class="r"></span></li>
                </ul>
                    </div>
                    <div id="subnavi-search">
                        <div id="subnavi-search-upper">
                            <ul id="subnavi-search-links">
 
                                <u><li><a href="{url}/logout" style="color:#000">Logout</a></li></u>
                            </ul>
                        </div>
                    </div>
                    <div id="to-hotel">
                        <a href="{url}/api.php" class="new-button green-button" target="eac955c8dbc88172421193892a3e98fc7402021a" onclick="HabboClient.openOrFocus(this); return false;"><b>Enter Galaxy</b><i></i></a>
                    </div>
                </div>
              <ul id="navi">
                    <li class="metab"><a href="{url}/me">{username}</a><span></span></li>
                    <li class="selected"><strong>Community</strong><span></span></li>
                    <li><a href="{url}/vip">VIP</a><span></span></li>
                    <li><a href="{url}/404">Coming Soon! ({vip_points}p)</a><span></span></li>
                </ul>
           
                <div id="habbos-online">
    <div id="content">
        <div class="cbb ">
<span>{online} members online</span></div>
    </div>
</div>
            </div>
            </div>
        </div>
        <?php
        if( $_GET['id'] ) {
                               
                                            $query = mysql_query( "SELECT * FROM `cms_news` WHERE id = '".filter($_GET['id'])."'");
                                            $array = mysql_fetch_assoc( $query );
                               
                                        }
                           
                                        if( $_GET['id'] ) {
                               
                                            $query = mysql_query( "SELECT * FROM `cms_news` WHERE id = '".filter($_GET['id'])."'");
                                            $array = mysql_fetch_assoc( $query );
                                        }
                                            ?>
        <div id="content-container">
            <div id="navi2-container" class="pngbg">
                <div id="navi2" class="pngbg clearfix">
                    <ul>
                   
                        <li><a href="{url}/community">Community</a></li>
            <li class="selected">&#9734; News&#9734;</li>
                        <li><a href="{url}/staff">Staff</a></li>
                        <li><a href="{url}/topstats">Top User Stats</a></li>
                        <li class=" last"><a href="{url}/expert">eXperts</a></li>
                    </ul>
                </div>
            </div>
            <div id="container">
                <div id="content" style="position: relative" class="clearfix">
                    <div id="column1" class="column">
                        <div class="habblet-container ">
                            <div class="cbb clearfix red ">
                                <h2 class="title">News</h2>
                                <div id="article-archive">
 
                                    <ul>
 
                                        {newsList}
                                    </ul>
                                </div>
                            </div>
                        </div>
                        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                    </div>
                    <div id="column2" class="column">
                        <div class="habblet-container ">
                            <div class="cbb clearfix notitle ">
                                <div id="article-wrapper">
                                    <h2>{newsTitle} </h2>
                                    <div class="article-meta">Posted {newsDate}</div>
 
                                    <p class="summary">{newsTitle}</p>
                                    <div class="article-body">
                              {newsContent}
                     
               
                                        <script type="text/javascript" language="Javascript">
                                            document.observe("dom:loaded", function() {
                                                $$('.article-images a').each(function(a) {
                                                    Event.observe(a, 'click', function(e) {
                                                        Event.stop(e);
                                                        Overlay.lightbox(a.href, "Image is loading");
                                                    });
                                                });
                                     
                                                $$('a.article-2729').each(function(a) {
                                                    a.replace(a.innerHTML);
                                                });
                                            });
                                        </script>
                                    </div>
                                </div>
                            </div>
                        </div>
     
             
<?php
 
 
if(isset($_POST['post_comment']))
  $posted_on = date("M j, Y g:i A");
 
if (empty($_POST['comment']))
$_POST['comment'] = '';
 
$comment = strip_tags (filter($_POST['comment']));
if($comment == NULL){
        //define("ERROR", "You have to type in a reply!<br /><br />");
    //$error_message = 'You have to type in a reply!<br /><br />';
  }else{
if (isLogged)
{
  mysql_query("INSERT INTO cms_comments (article, userid, comment, posted_on, author) VALUES ('".filter($_GET['id'])."', '".$_SESSION['user']['id']."', '".filter($comment)."', '".$posted_on."', '" . $_SESSION['user']['username']. "');") or die(mysql_error());
    define('SUCCESS', 'You have successfully posted a comment on this news article!');
 
 
    define("ERROR", "<br>Thanks for your reply!<br />");
 
        //$error_message = 'Thanks for your reply!<br /><br />';
  }
}
?>
 
<div class="habblet-container ">
<div class="cbb clearfix notitle ">
<div id="article-wrapper"><h2>Place Comment</h2>
<div class="article-meta"></div>
<div class="article-body">
<?php
if($userPosts >= 1)
{
    define('ERROR', 'Sorry, you are only allowed one comment per article.');
}
if(defined("SUCCESS")){
?>
<div class="rounded rounded-green" width="20%">
                    <?php echo SUCCESS; ?><br />
                </div>
                <div>&nbsp;</div>
<?php
}
if(defined("ERROR")) {
?>
<div class="rounded rounded-red" width="20%">
                    <?php echo ERROR; ?><br />
                </div>
                <div>&nbsp;</div>
<?php
}
else
{
?>
<form action="" method="post">
<textarea name="comment" maxlength="200"></textarea><br /><br />
<input type="submit" name="post_comment" value="Place Comment" />
</form>
<?php
}
?>
</div>
</div>
</div>
</div>
 
<style type="text/css">
input[type="text"], input[type="password"] {
background-color: #F1F1F1;
border: 1px solid #999999;
width: 175px;
padding: 5px;
font-family: verdana;
font-size: 10px;
color: #666666;
}
input[type="submit"] {
background-color: #F1F1F1;
border: 1px solid #999999;
padding: 5px;
font-family: verdana;
font-size: 10px;
color: #666666;
}
textarea {
background-color: #F1F1F1;
border: 1px solid #999999;
padding: 5px;
width: 517px;
height: 70px;
font-family: verdana;
font-size: 10px;
color: #666666;
}
select {
background-color: #F1F1F1;
border: 1px solid #999999;
padding: 5px;
font-family: verdana;
font-size: 10px;
color: #666666;
}
</style>
<?php
$getComments = mysql_query("SELECT * FROM cms_comments WHERE article = '".filter($_GET['id'])."' ORDER by id DESC");
?>
<div class="habblet-container ">
<div class="cbb clearfix notitle ">
<div id="article-wrapper"><h2>Comments <?php echo mysql_num_rows($getComments); ?></h2>
<div class="article-meta"></div>
<div class="article-body">
<?php
      if(mysql_num_rows($getComments) == 0) {
          echo "No comments for this article!";
      } else {
          echo '<table width="528px">';
          while($Comments = mysql_fetch_array($getComments)){
          $getUserInfo = mysql_query("SELECT * FROM users WHERE username = '".$Comments['author']."'");
          $userInfo = mysql_fetch_array($getUserInfo);
                  echo '
                  <tr>
                    <td width="90px" valign="top"></div>
                    <div style="
height: 65px;
width: 50px;
float: left;
overflow: hidden;
">
                      <div style="float:left"><img position:absolute; src="[url]http://www.habbo.nl/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&size=b&direction=2&head_direction=3&gesture=sml&size=2[/url]"></div>
                      ';
                        if($userInfo['rank'] >= 5) {
                            echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/album1584/ADM.gif"></div>';
                        }
                        if($userInfo['rank'] == 3) {
                            echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/XXX.gif"></div>';
                        }
                        if($userInfo['rank'] == 4) {
                            echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/XXX.gif"></div>';
                        }
                        if($userInfo['rank'] == 2) {
                            echo '<div style="position: absolute; z-index:1"><img src="{url}/r63/c_images/badges/VIP.gif"></div>';
                        }
                        if($userInfo['rank'] == 1) {
                            echo '<div style="position: absolute; z-index:1"><img src="{url}/lid.png"></div>';
                        }
           
 
                echo '
 
                </td>
                    <td width="427px" valign="top">
                    <i><a href="/me">'.$userInfo['username'].' </a></i>
                                        <br /><br />'.$Comments['comment'].'
                               
 
                    </td>
                  </tr>
          <tr>
                    <td width="80px" valign="top">
           
                    </td>
                                <td width="400px" align="right">
 
                                     
                                     
 
               
 
</div></div></div></div>
<br>
<div style="width:125%; height:1px; background-color:#ccc; margin-top:-17px;"></div>
 
 
            </td>
          </tr>';
          }
          echo '</table>';
        }
        ?></div> </div> </div> </div>
</div>
</div>
</div>
</div>
 
        <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
        <script type="text/javascript">
            HabboView.run();
        </script>
 
        <!--[if lt IE 7]>
            <script type="text/javascript">
                Pngfix.doPngImageFix();
            </script>
        <![endif]-->
 
   
        <div id="footer" >
           <!-- <?php include "app/tpl/skins/Habbo/inc/footer.php"; ?> -->
        </div>
 
    </body>
</html>

Anyone know why it says this when you enter in a comment?

Unknown column 'article' in 'field list'

Also can anyone help me fix this code up? I've been at it for awhile. Its a whole mess and a half.

Find · Aug 6, 2013

because theirs no column "article" in the table it's trying to insert into

Kristopher · Aug 6, 2013

Theirs a column tho? It worked on xampp. Just not IIS.

Find · Aug 6, 2013

Stoner said:
Theirs a column tho? It worked on xampp. Just not IIS.

Well the error is saying there is no column article in cms_comments :S

Kristopher · Aug 6, 2013

Their aint. Hmm, SQL that would be needed? Would it have to be?

Kryptos · Aug 6, 2013

Because there's no 'article' column on 'cms_comments' table

Find · Aug 6, 2013

Depends, is the article done by name or id? if it's just ids then this should work:

Code:

ALTER TABLE cms_comments ADD COLUMN article INT(9);

If it's done by name change it to VARCHAR(30); or something

Kristopher · Aug 6, 2013

I've seen. Hmm. I entered it in. Varchar 999? Would that cover it?

Find · Aug 6, 2013

Stoner said:
I've seen. Hmm. I entered it in. Varchar 999? Would that cover it?

yep it just means there can be 999 characters

Kryptos · Aug 6, 2013

Stoner said:
I've seen. Hmm. I entered it in. Varchar 999? Would that cover it?

No, because it is an int. It is for the article's ID. Use Find's SQL code.

Kristopher · Aug 6, 2013

Incorrect integer value: 'Kristopher' for column 'author' at row 1

Markshall · Aug 6, 2013

Stoner said:
Incorrect integer value: 'Kristopher' for column 'author' at row 1

Integers are numbers (no decimal), you're trying to insert text.

Kristopher · Aug 6, 2013

RERSTERLERLZ said:
Integers are numbers (no decimal), you're trying to insert text.

Yeah, I was using xampp for working on this, now that I'm using IIS i realised the SQL that I received was missing alot so I've went back and fixed some of it. Now its saying their aint a default value?

Pacific · Aug 15, 2013

Stoner said:
Yeah, I was using xampp for working on this, now that I'm using IIS i realised the SQL that I received was missing alot so I've went back and fixed some of it. Now its saying their aint a default value?

Just set a default value for the column, 0 or something.

Heaplink · Aug 15, 2013

First off why do you use VARCHAR for an article content? Use TEXT as it can hold any length of characters and also better for memory (since varchar requires a predefined length) (+ the name is non-descriptive).

Second; Dump your cms_comments table structure so we can see it. Without it, we can't see what you're missing other than wrong code.

Third; mysql functions (e.g. non PDO/MySQLi) is not safe nor supported by PHP as of the latest releases. You should take a look at PDO and/or MySQLi

(Help) PHP Error?

Kristopher

Photographer

Find

Posting Freak

Kristopher

Photographer

Find

Posting Freak

Kristopher

Photographer

Kryptos

prjRev.com

Find

Posting Freak

Kristopher

Photographer

Find

Posting Freak

Kryptos

prjRev.com

Kristopher

Photographer

Markshall

Русский Стандарт

Kristopher

Photographer

Pacific

Spooderman

Heaplink

Developer & Designer

Users who are viewing this thread

Latest posts

Connect with us

Newest members