Hello & Welcome to our community. Is this your first visit? Register

Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Hardcore Member

    Rank
    Member
    Join Date
    Nov 2011
    Posts
    144

    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 07:39 AM.


  2.  
  3. #2
    Member

    Rank
    Member
    Join Date
    Feb 2012
    Posts
    35

    Re: Various RevCMS Fixes

    Very GooD

  4. #3
    Programmer Jax's Avatar

    Rank
    True Member
    Join Date
    Dec 2009
    Posts
    972

    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
    Alpha Member Facebook's Avatar

    Rank
    Alpha Male
    Join Date
    Oct 2011
    Location
    My PC
    Posts
    2,045

    Re: Various RevCMS Fixes

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


    Rest In Peace, To my dog Sparky. Never forgotten <3

    Skype: Danny.runsnyc

    msn: dannyrunsnyc@hotmail.com

  6. #5
    Hardcore Member

    Rank
    Member
    Join Date
    Nov 2011
    Posts
    144

    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
    Member Jake7383's Avatar

    Rank
    Member
    Join Date
    Dec 2011
    Location
    Kentucky
    Posts
    58

    Re: Various RevCMS Fixes

    Will be taking effect in my retro tomorrow! (:

  8. #7
    Galie J4y2's Avatar

    Rank
    True Member
    Join Date
    Feb 2012
    Location
    South Korea
    Posts
    317

    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
    Hardcore Member

    Rank
    Member
    Join Date
    Nov 2011
    Posts
    144

    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's Avatar

    Rank
    True Member
    Join Date
    Jun 2012
    Location
    United Kingdom
    Posts
    234

    Re: Various RevCMS Fixes

    Fix for a white client?

  11. #10
    Hardcore Member

    Rank
    Member
    Join Date
    Nov 2011
    Posts
    144

    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's Avatar

    Rank
    True Member
    Join Date
    Jun 2012
    Location
    clit
    Posts
    601

    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
    Registered

    Rank
    Member
    Join Date
    Jul 2012
    Posts
    5

    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
    Member

    Rank
    Member
    Join Date
    Apr 2011
    Posts
    34

    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's Avatar

    Rank
    Member
    Join Date
    Feb 2012
    Posts
    49

    Re: Various RevCMS Fixes

    Ty ;p

  16. #15
    Newbie

    Rank
    Member
    Join Date
    Jan 2013
    Posts
    2

    Re: Various RevCMS Fixes

    thanks thanks :D ─▒ love you

 

 
Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HyperFilter
Sponsored by HyperFilter , secured by Incapsula , powered by LiteSpeed.
Mods by DBTech. All times are GMT +1. The time now is 04:56 AM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.