Various RevCMS Fixes

Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Account Inactive Muffmuncher is offline
    InactiveRank
    Nov 2011 Join Date
    144Posts

    Various RevCMS Fixes

    Here are various fixes for RevCMS. Fixes noted untested are not tested, and therefore need verfication. Those tested are based on the Mango theme, but the process will be similar or probably the same for other skins.

    1. "Unknown column 'seckey' in 'field list'" registration error fix:
    Execute SQL in phpMyAdmin or Navicat.
    Code:
    ALTER TABLE `users` ADD `seckey` VARCHAR(999)
    2. Fix for "Incorrect integer value: '' for column 'author' at row 1" news posting error:
    Select cms_news table> Design Table in Navicat> Change type of "author" field to varchar.

    3. Default figure code:
    Code:
    hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100
    4. Client popup:
    In me.php, replace
    Code:
    <center><a href="api.php" onclick="mango.client.popup(); return false;">Enter {hotelName} Hotel</a></center>
    with
    Code:
    <center><a href="api.php" target="ClientWndw" onclick="window.open('api.php','ClientWndw','width=980,height=597');return false;">Enter {hotelName} Hotel</a></center>
    5. Get bans fix (untested):
    In hk\banlist.php, replace get bans code with
    Code:
    <?php
    $getBans = mysql_query("SELECT * FROM bans");
     
    while(($ban = mysql_fetch_array($getBans))) 
    {
    echo "<tr><td>" . $ban['value'] ."</td><td>" . $ban['reason'] . "</td><td>" . $ban['added_by'] . "</td><td><a href='?url=banlist&unban=" . $ban['id'] . "'><b>Unban</b></a></td></tr>";
    }
    ?>
    6. Account per IP:
    In /app/class.users, change value 1 in the following code to desired number of accounts.
    Code:
    if($engine->num_rows("SELECT * FROM users WHERE ip_reg = '" . $_SERVER['REMOTE_ADDR'] . "'") == 1)
    7. Unban fix (untested):
    In hk/banlist.php, replace
    Code:
    <table width="100%">
    <tr><td><b>Username</b></td><td><b>Reason</b></td><td><b>Banned by</b></td><td><b>Value</b></td></tr>
    <?php
    while($two = mysql_fetch_array(mysql_query("SELECT * FROM bans"), MYSQL_ASSOC))
    {
    echo "<tr><td>" . $two['value'] ."</td><td>" . $two['reason'] . "</td><td>" . $two['added_by'] . "</td><td><a href='?url=banlist&unban=" . $two['id'] . "'><b>Unban</b></a></td></tr>";
    }
     
    ?>
    with
    Code:
    <table width="100%">
    <tr><td><b>Username</b></td><td><b>Reason</b></td><td><b>Banned by</b></td><td><b>Expires</b></td><td><b>Value</b></td></tr>
    <?php
    $getBans = mysql_query("SELECT * FROM bans");
     
    while(($ban = mysql_fetch_array($getBans)))
    {
    echo "<tr><td>" . $ban['value'] ."</td><td>" . $ban['reason'] . "</td><td>" . $ban['added_by'] . "</td><td>" . @date("d-m-Y H:i", $ban['expire']) . "</td><td><a href='?url=banlist&unban=" . $ban['id'] . "'><b>Unban</b></a></td></tr>";
    }
    ?>
    ASE should be working fine at this point. Now in app/class.core.php, replace
    Code:
    if($k == 'balist')
    with
    Code:
    if($k == 'banlist')
    Lastly perform a :update_bans command in hotel to take effect.

    8. Edit User Account Script Name Case Fix (untested):
    In hk/edit.php, find
    Code:
    <input type="username" value="<?php echo $_POST['l_username']; ?>" style="width: 95%;" />
    change
    Code:
    <?php echo $_POST['l_username']; ?>
    to
    Code:
    <?php echo $two['username']; ?>
    9. News Fix (HTML phrasing):
    In hk/news2.php, replace line 66 with
    Code:
        mysql_query("INSERT INTO cms_news (title,shortstory,longstory,published,image,author, campaign, campaignimg) VALUES ('" . filter($_SESSION["title"]) . "', '" . filter($_SESSION["shortstory"]) . "', '" . ($_SESSION["longstory"]) . "', '" . time() . "', '" . filter($_POST["topstory"]) . "', '" . filter($author) . "', 0, 'default')") or die(mysql_error());

    .. don't thank me just yet, this is just a compilation of works from several others, only phrased for easy understandings. So full credits to the respective contributors.
    Last edited by Muffmuncher; 11-07-12 at 06:39 AM.


  2.  
  3. #2
    Account Inactive zMatty is offline
    InactiveRank
    Feb 2012 Join Date
    35Posts

    Re: Various RevCMS Fixes

    Very GooD

  4. #3
    Programmer Jax is offline
    True MemberRank
    Dec 2009 Join Date
    971Posts

    Re: Various RevCMS Fixes

    Nice tutorial! The best for the newbs

    OFFTOPIC: zMatty your not in the zTeam with me and zJordan are you lol.

  5. #4
    Account Inactive Facebook is offline
    InactiveRank
    Oct 2011 Join Date
    My PCLocation
    2,045Posts

    Re: Various RevCMS Fixes

    Nice, but is it me is the ase slow? I am using iis..

  6. #5
    Account Inactive Muffmuncher is offline
    InactiveRank
    Nov 2011 Join Date
    144Posts

    Re: Various RevCMS Fixes

    Quote Originally Posted by Facebook View Post
    Nice, but is it me is the ase slow? I am using iis..
    Site loads slow at first instant, but once went through the process of entering, it all becomes quick. I'm experiencing the same as well, which I don't know the cause nor how to solve.

  7. #6
    Account Inactive Jake7383 is offline
    InactiveRank
    Dec 2011 Join Date
    KentuckyLocation
    58Posts

    Re: Various RevCMS Fixes

    Will be taking effect in my retro tomorrow! (:

  8. #7
    Account Inactive J4y2 is offline
    InactiveRank
    Feb 2012 Join Date
    South KoreaLocation
    317Posts

    Re: Various RevCMS Fixes

    I Don't Get It About This Part

    2. Fix for "Incorrect integer value: '' for column 'author' at row 1" news posting error:
    Select cms_news table> Design Table in Navicat> Change type of "author" field to varchar.

  9. #8
    Account Inactive Muffmuncher is offline
    InactiveRank
    Nov 2011 Join Date
    144Posts

    Re: Various RevCMS Fixes

    Quote Originally Posted by J4y2 View Post
    I Don't Get It About This Part

    2. Fix for "Incorrect integer value: '' for column 'author' at row 1" news posting error:
    Select cms_news table> Design Table in Navicat> Change type of "author" field to varchar.
    Can't believe my thread is still alive :p as far as I could remember, it means there is this error that when you try to post a news article via ASE, you'll get an error message reading: "Incorrect integer value: '' for column 'author' at row 1". To fix it, you then need to do as stated.

  10. #9
    The One And Only. Whale is offline
    True MemberRank
    Jun 2012 Join Date
    United KingdomLocation
    234Posts

    Re: Various RevCMS Fixes

    Fix for a white client?

  11. #10
    Account Inactive Muffmuncher is offline
    InactiveRank
    Nov 2011 Join Date
    144Posts

    Re: Various RevCMS Fixes

    Quote Originally Posted by daviid601 View Post
    Fix for a white client?
    Go to client.php and check if port is 30001. Most likely the case if you use a custom theme or skin.

  12. #11
    scream my name ParadiseRel is offline
    True MemberRank
    Jun 2012 Join Date
    clitLocation
    601Posts

    Re: Various RevCMS Fixes

    Great fixes, Definitely helped me when I was having trouble with RevCMS. Welldone.
    they b stressin while we sexn

    neighbors kno ma name.

  13. #12
    Account Inactive Zelly is offline
    InactiveRank
    Jul 2012 Join Date
    5Posts

    Re: Various RevCMS Fixes

    HEY I NEED HELP WHEN EVER I CLICK ENTER HOTEL IT SAYS Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\thehabbos_api\class.validate.php on line 33

  14. #13
    Account Inactive Boy357 is offline
    InactiveRank
    Apr 2011 Join Date
    34Posts

    Re: Various RevCMS Fixes

    Quote Originally Posted by Zelly View Post
    HEY I NEED HELP WHEN EVER I CLICK ENTER HOTEL IT SAYS Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\thehabbos_api\class.validate.php on line 33
    Change on Every Page the link: /api.php to /client ''without .php''! :)

  15. #14
    Member CtarikC is offline
    MemberRank
    Feb 2012 Join Date
    49Posts

    Re: Various RevCMS Fixes

    Ty ;p

  16. #15
    Newbie yalmanmfp is offline
    MemberRank
    Jan 2013 Join Date
    2Posts

    Re: Various RevCMS Fixes

    thanks thanks :D ─▒ love you


  17.  

    Latest Gaming Releases

Page 1 of 2 12 LastLast

Advertisement