Newbie Spellweaver
- Joined
- Dec 25, 2015
- Messages
- 56
- Reaction score
- 27
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:
Can someone help me? Because there is no value in bans table.
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:
[COLOR=#569CD6]final[/COLOR][COLOR=#D4D4D4] [/COLOR][COLOR=#569CD6]public[/COLOR][COLOR=#D4D4D4] [/COLOR][COLOR=#569CD6]function[/COLOR][COLOR=#D4D4D4] [/COLOR][COLOR=#DCDCAA]isBanned[/COLOR][COLOR=#D4D4D4]([/COLOR][COLOR=#9CDCFE]$value[/COLOR][COLOR=#D4D4D4])[/COLOR][COLOR=#D4D4D4] {
[COLOR=#569cd6]global[/COLOR] [COLOR=#9cdcfe]$engine[/COLOR];
[COLOR=#c586c0]if[/COLOR]([COLOR=#9cdcfe]$engine[/COLOR]->num_rows([COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]SELECT[/COLOR][COLOR=#ce9178] [/COLOR]*[COLOR=#ce9178] [/COLOR][COLOR=#569cd6]FROM[/COLOR][COLOR=#ce9178] bans [/COLOR][COLOR=#569cd6]WHERE[/COLOR][COLOR=#ce9178] value [/COLOR]=[COLOR=#ce9178] '[/COLOR][COLOR=#ce9178]"[/COLOR] . [COLOR=#9cdcfe]$value[/COLOR] . [COLOR=#ce9178]"' AND ban_expire >= '"[/COLOR] . [COLOR=#dcdcaa]time[/COLOR]() . [COLOR=#ce9178]"' "[/COLOR]) > [COLOR=#b5cea8]0[/COLOR]);
{
[COLOR=#c586c0]return[/COLOR] [COLOR=#569cd6]true[/COLOR];
}
[COLOR=#c586c0]return[/COLOR] [COLOR=#569cd6]false[/COLOR];
}
[COLOR=#569cd6]final[/COLOR] [COLOR=#569cd6]public[/COLOR] [COLOR=#569cd6]function[/COLOR] [COLOR=#dcdcaa]getReason[/COLOR]([COLOR=#9cdcfe]$value[/COLOR])
{
[COLOR=#569cd6]global[/COLOR] [COLOR=#9cdcfe]$engine[/COLOR];
[COLOR=#c586c0]return[/COLOR] [COLOR=#9cdcfe]$engine[/COLOR]->result([COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]SELECT[/COLOR][COLOR=#ce9178] ban_reason [/COLOR][COLOR=#569cd6]FROM[/COLOR][COLOR=#ce9178] bans [/COLOR][COLOR=#569cd6]WHERE[/COLOR][COLOR=#ce9178] value [/COLOR]=[COLOR=#ce9178] '[/COLOR][COLOR=#ce9178]"[/COLOR] . [COLOR=#9cdcfe]$value[/COLOR] . [COLOR=#ce9178]"' LIMIT 1"[/COLOR], [COLOR=#ce9178]"ban_reason"[/COLOR]);
}
[COLOR=#569cd6]final[/COLOR] [COLOR=#569cd6]public[/COLOR] [COLOR=#569cd6]function[/COLOR] [COLOR=#dcdcaa]hasClones[/COLOR]([COLOR=#9cdcfe]$ip[/COLOR])
{
[COLOR=#569cd6]global[/COLOR] [COLOR=#9cdcfe]$engine[/COLOR];
[COLOR=#c586c0]if[/COLOR]([COLOR=#9cdcfe]$engine[/COLOR]->num_rows([COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]SELECT[/COLOR][COLOR=#ce9178] [/COLOR]*[COLOR=#ce9178] [/COLOR][COLOR=#569cd6]FROM[/COLOR][COLOR=#ce9178] users [/COLOR][COLOR=#569cd6]WHERE[/COLOR][COLOR=#ce9178] ip_register [/COLOR]=[COLOR=#ce9178] '[/COLOR][COLOR=#ce9178]"[/COLOR] . [COLOR=#9cdcfe]$_SERVER[/COLOR][[COLOR=#ce9178]'REMOTE_ADDR'[/COLOR]] . [COLOR=#ce9178]"'"[/COLOR]) == [COLOR=#b5cea8]1[/COLOR])
{
[COLOR=#c586c0]return[/COLOR] [COLOR=#569cd6]true[/COLOR];
}
[COLOR=#c586c0]return[/COLOR] [COLOR=#569cd6]false[/COLOR];
[/COLOR]
[COLOR=#D4D4D4] }[/COLOR]
Can someone help me? Because there is no value in bans table.