RevCMS Arcturus Unknown column 'value' in 'where clause'

Results 1 to 11 of 11
  1. #1
    Member dimaklt is offline
    MemberRank
    Dec 2015 Join Date
    GermanyLocation
    55Posts

    config RevCMS Arcturus Unknown column 'value' in 'where clause'


    RaGEZONE Recommends

    RaGEZONE Recommends

    Hi,
    I want to make my RevCMS compatible with Arcturus but when I try to register I get this error: Unknown column 'value' in 'where clause'

    I think it is because of bans in class.users.php:
    Code:
    finalpublicfunctionisBanned($value)  {
        global $engine;
        if($engine->num_rows("SELECT*FROM bans WHERE value = '" . $value . "' AND ban_expire >= '" . time() . "' ") > 0);
        {
          return true;
        }
          
        return false;
      }
      
      final public function getReason($value)
      {
        global $engine;
        return $engine->result("SELECT ban_reason FROM bans WHERE value = '" . $value . "' LIMIT 1", "ban_reason");
      }
      
      final public function hasClones($ip)
      {
        global $engine;
        if($engine->num_rows("SELECT*FROM users WHERE ip_register = '" . $_SERVER['REMOTE_ADDR'] . "'") == 1)
        {
          return true;
        }
        
        return false;
    
      }
    Can someone help me? Because there is no value in bans table.
    Webdesigner & Programmer


    https://Bobba.Biz - WORLD CONNECTED


  2. #2
    Death from above! The General is offline
    The OmegaRank
    Aug 2011 Join Date
    8,950Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    The error says exactly whats wrong? The column value does not exist in the bans table because Arcturus does not have such a column.
    If you are using Arcturus, contact me
    Skype: wesley.jabbo
    Discord: TheGeneral#0063


  3. #3
    Member dimaklt is offline
    MemberRank
    Dec 2015 Join Date
    GermanyLocation
    55Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Quote Originally Posted by The General View Post
    The error says exactly whats wrong? The column value does not exist in the bans table because Arcturus does not have such a column.
    I know. But I don't know how to fix it, because I don't know what to use instead of value.
    If I remove it completely, I can't even register anymore -> errors.
    Webdesigner & Programmer


    https://Bobba.Biz - WORLD CONNECTED

  4. #4
    dont judge me Wuzix is offline
    True MemberRank
    Sep 2013 Join Date
    C:\inetpub\wwwLocation
    363Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Quote Originally Posted by dimaklt View Post
    I know. But I don't know how to fix it, because I don't know what to use instead of value.
    If I remove it completely, I can't even register anymore -> errors.
    The name ' value ' must have another name on the ' bans ' table. Check for yourself.

  5. #5
    Member dimaklt is offline
    MemberRank
    Dec 2015 Join Date
    GermanyLocation
    55Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Quote Originally Posted by Wuzix View Post
    The name ' value ' must have another name on the ' bans ' table. Check for yourself.
    I checked it before I opened this thread. The problem is, I don't know what value is out of these:
    id int(11) Auto-Inkrement
    user_id int(11)
    ip varchar(50) []
    machine_id varchar(255)
    user_staff_id int(11)
    timestamp int(11)
    ban_expire int(32) [0]
    ban_reason varchar(200) []
    type enum('account','ip','machine','super')[account] Account is the entry in the users table banned. IP is any client that connects with that IP. Machine is the computer that logged in. Super is all of the above.
    cfh_topic int(4) [-1]

    Is it cfh_topic?
    Webdesigner & Programmer


    https://Bobba.Biz - WORLD CONNECTED

  6. #6
    Registered Jordyever is offline
    MemberRank
    Jul 2012 Join Date
    Oostkamp, BelgiLocation
    21Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Value should be changed to: user_id , ip or machine_id not sure how you want it to be checked.

  7. #7
    Death from above! The General is offline
    The OmegaRank
    Aug 2011 Join Date
    8,950Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Its because the old banning system from phoenix was shitty. Remove or recode it?
    If you are using Arcturus, contact me
    Skype: wesley.jabbo
    Discord: TheGeneral#0063


  8. #8
    dont judge me Wuzix is offline
    True MemberRank
    Sep 2013 Join Date
    C:\inetpub\wwwLocation
    363Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Quote Originally Posted by Jordyever View Post
    Value should be changed to: user_id , ip or machine_id not sure how you want it to be checked.
    Are you stupid? Value should be changed to 'type' as you see in the picture.

  9. #9
    Registered Jordyever is offline
    MemberRank
    Jul 2012 Join Date
    Oostkamp, BelgiLocation
    21Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Quote Originally Posted by Wuzix View Post
    Are you stupid? Value should be changed to 'type' as you see in the picture.
    Useless community , no wonder it dies out

  10. #10
    You looking at me? Zoxq is offline
    True MemberRank
    Dec 2015 Join Date
    308Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    Quote Originally Posted by Wuzix View Post
    Are you stupid? Value should be changed to 'type' as you see in the picture.
    Well, @Jordyever is right.
    Value is user_id, IP and machine_id. Some emulator use only value and some separate them, so they don't have to make so many columns when banning.

    The type is simply to make it easier to see what ban they got.
    For example, if someone gets banned by their IP it would say type = IP.

    And you can clearly see that he is trying to get the users username/id though the value table.

    So the only thing you'll have to do is to change value to the type you want to keep from your hotel.
    If you're trying to keep out everyone who's IP banned just use IP instead of value and if your trying to keep those who have been banned by their machine ID just use machine_id instead of value.

    You could also make it block them all, by adding some lines or just editing some stuff it's not that hard.

  11. #11
    Death from above! The General is offline
    The OmegaRank
    Aug 2011 Join Date
    8,950Posts

    Re: RevCMS Arcturus Unknown column 'value' in 'where clause'

    For those wondering; I decided to add more information when banning so if you decide to change a ban, all you have to change is the ban type from say ban to ipban.

    If you are using a TCP proxy, make sure to have your CMS update the ip_current column in the users table.
    If you are using Arcturus, contact me
    Skype: wesley.jabbo
    Discord: TheGeneral#0063





Advertisement