Sorry, of course the 2nd log is good...
> BAD:
> ------------------------------------------------------------
> 020302 18:50:09 73 Init DB midgard
[...]
> 243 Connect root@localhost on
> 243 Init DB informed
> 73 Query SELECT admingroup FROM sitegroup
> WHERE id=0
^^^^^^^^^^
> 73 Query SELECT person.id,person.password
> FROM person,member WHERE person.username='author' AND person.sitegroup=0
^^^^^^^^^^^^^^^^^^
> AND member.uid = person.id AND member.gid=0
> 73 Query SELECT
> id,up,score,name,description,extra,owner,code,creator,Unix_timestamp(created)
> as created,revisor,Unix_timestamp(revised) as revised,revision FROM
> topic WHERE up=0 AND name='informed' AND (sitegroup in (0, 0) OR 0<>0)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
--------------------------------------------------------------------
> This is the GOOD:
> -------------------------------------------------
> 020302 18:51:23 75 Statistics
[...]
> 75 Query SELECT admingroup FROM sitegroup
> WHERE id=1
^^^^
> 75 Query SELECT id,password FROM person WHERE
> username='author' AND sitegroup=1
^^^^^^^^^^^
> 75 Query SELECT gid FROM member WHERE uid=9
> AND sitegroup in (0, 1) ORDER BY gid DESC
^^^^^^^^^^^^^^^^^^^
[...]
> 75 Query SELECT
> id,up,score,name,description,extra,owner,code,creator,Unix_timestamp(created)
> as created,revisor,Unix_timestamp(revised) as revised,revision FROM
> topic WHERE up=0 AND name='informed' AND (sitegroup in (0, 1) OR 0<>0)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
Anyway, why is this syntax: "(sitegroup in (0, 1) OR 0<>0)"?
And what does the ampersand (&) mean here: "SELECT info&2 FROM page
WHERE id=109"?
Thanks:
Circum
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
