Serendipity Forums

SELECT i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
a.realname AS authorname
FROM s_images AS i
LEFT OUTER JOIN s_authors AS a
ON i.authorid = a.authorid
LEFT JOIN s_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN s_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'directory'
AND acl_acc.artifact_index = i.path
)

WHERE 1=1 AND (
i.path IS NULL OR
acl_acc.groupid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY i.id
ORDER BY i.date DESC LIMIT 0, 8

/ Unknown column 'i.realname' in 'field list'

AbstractUtopia wrote:They make you pay for any help they give you. Its just how they work.

I do have access to phpMyAdmin.

create table s_mediaproperties (
  mediaid int(11) not null,
  property varchar(128) not null,
  property_group varchar(50) not null default '',
  property_subgroup varchar(50) not null default '',
  value text
);

create table s_options (
  name varchar(255) not null,
  value text not null,
  okey varchar(64) not null default ''
);

ALTER TABLE s_images ADD COLUMN realname varchar(255) not null default '';
ALTER TABLE s_references ADD COLUMN type varchar(128) not null default '';

ALTER TABLE s_category ADD COLUMN sort_order int(11);
ALTER TABLE s_category ADD COLUMN hide_sub int(1);

CREATE INDEX categoryso_idx ON s_category (sort_order);
CREATE INDEX reftype_idx ON s_references (type);
CREATE INDEX options_idx ON s_options (okey);