EasyEasy
Customer
Great mod but with a few errors.
I cant change the options in the acp settings. when i click the edit options for the blog not to include it it still stays active.
Also after clicking the navbar tab i get the following error which i think is to do with the fact i dont have blogs on my site
---------- Post added at 22:29 ---------- Previous post was at 22:08 ----------
I have a update on this. It still wont let me disable certain content types however if i set the content type to zero in the preview settings it removes it it. still not ideal though as we should be able to disable as the option says
I cant change the options in the acp settings. when i click the edit options for the blog not to include it it still stays active.
Also after clicking the navbar tab i get the following error which i think is to do with the fact i dont have blogs on my site
Database error in vBulletin 4.1.1:
Invalid SQL:
SELECT
blog.*,
blog_text.*,
user.*,
blog.title AS blogtitle,
blog.dateline,
blog.blogid AS contenttypeid,
'blogposts' AS contenttype
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb
FROM vbblog AS blog
LEFT JOIN vbblog_text AS blog_text ON(blog_text.blogtextid = blog.firstblogtextid)
LEFT JOIN vbuser AS user ON(user.userid = blog.userid)
LEFT JOIN vbdbtech_livewall_settings AS currentuser_settings ON(currentuser_settings.userid = 1)
LEFT JOIN vbdbtech_livewall_settings AS actionuser_settings ON(actionuser_settings.userid = user.userid)
LEFT JOIN vbuserlist AS actionuser_friend ON(actionuser_friend.userid = user.userid AND actionuser_friend.relationid = 1)
LEFT JOIN vbavatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON (customavatar.userid = user.userid)
WHERE blog_text.state = 'visible'
AND blog.state = 'visible'
AND NOT FIND_IN_SET(0, membergroupids)
AND usergroupid NOT IN(0)
AND
(
user.userid = 1 OR
(
(
ISNULL(currentuser_settings.blogposts_display) OR
(
currentuser_settings.blogposts_display = 0 OR
(
currentuser_settings.blogposts_display = 1 AND
1 > 0
) OR
(
currentuser_settings.blogposts_display = 2 AND
actionuser_friend.type = 'buddy'
) OR
(
currentuser_settings.blogposts_display = 3 AND
actionuser_friend.type = 'buddy' AND
actionuser_friend.friend = 'yes'
)
)
) AND
(
ISNULL(actionuser_settings.blogposts_privacy) OR
(
actionuser_settings.blogposts_privacy = 0 OR
(
actionuser_settings.blogposts_privacy = 1 AND
1 > 0
) OR
(
actionuser_settings.blogposts_privacy = 2 AND
actionuser_friend.type = 'buddy'
) OR
(
actionuser_settings.blogposts_privacy = 3 AND
actionuser_friend.type = 'buddy' AND
actionuser_friend.friend = 'yes'
)
)
)
)
)
ORDER BY blog.blogid DESC
LIMIT 20;
MySQL Error : Table '************.vbblog' doesn't exist
Error Number : 1146
Request Date : Tuesday, February 14th 2012 @ 10:02:50 PM
Error Date : Tuesday, February 14th 2012 @ 10:02:51 PM
Script : http:***************/livewall.php
Referrer : http:*****************************
IP Address : **********
Username : ****************
Classname : ********************
MySQL Version : 5.0.**-community-log
---------- Post added at 22:29 ---------- Previous post was at 22:08 ----------
I have a update on this. It still wont let me disable certain content types however if i set the content type to zero in the preview settings it removes it it. still not ideal though as we should be able to disable as the option says