360junkie
01-24-2008, 09:18 PM
this one https://vborg.vbsupport.ru/showthread.php?t=147346
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1')
OR
(s.s_private <> -1 AND s.s_user = '1')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '1')
)
order by s.s_time desc limit 20;
MySQL Error : Unknown column 's.s_private' in 'where clause'
Error Number : 1054
Date : Monday, January 21st 2008 @ 12:44:52 AM
Script : http://www.hatedbybungie.org/forum/infernoshout.php
Referrer : http://www.hatedbybungie.org/forum/index.php
IP Address :
Username : 360Junkie
Classname : vb_database
MySQL Version : 4.1.22-standard
Edit/Delete Message
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1')
OR
(s.s_private <> -1 AND s.s_user = '1')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced <> '0' AND u.userid = '1')
)
order by s.s_time desc limit 20;
MySQL Error : Unknown column 's.s_private' in 'where clause'
Error Number : 1054
Date : Monday, January 21st 2008 @ 12:44:52 AM
Script : http://www.hatedbybungie.org/forum/infernoshout.php
Referrer : http://www.hatedbybungie.org/forum/index.php
IP Address :
Username : 360Junkie
Classname : vb_database
MySQL Version : 4.1.22-standard
Edit/Delete Message