SET @@sql_mode = ''
SELECT *
FROM vb_datastore
WHERE title IN ('userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue','activeblocks','navdata','navdata','attachmentcache','cron','profilefield','loadcache','noticecache','activitystream','routes')
SELECT *
FROM vb_datastore
WHERE title IN ('blogcategorycache','blogstats')
SELECT *
FROM vb_session
WHERE sessionhash = '3eabc16e5174bde122571032921e4b10'
AND lastactivity > 1714249658
AND idhash = 'd07a629655a5a8e32d38679a0b149ba8'
SELECT *
FROM vb_session
WHERE userid = 0
AND host = '18.217.208.72'
AND idhash = 'd07a629655a5a8e32d38679a0b149ba8'
LIMIT 1
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_activitystream AS phrasegroup_activitystream,
phrasegroup_holiday AS phrasegroup_holiday,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM vb_language
WHERE languageid = 3
SELECT MAX(permissions & 1) AS perm
FROM vb_cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)
SELECT *
FROM vb_style
WHERE (styleid = 7 AND userselect = 1)
OR styleid = 7
ORDER BY styleid ASC
LIMIT 1
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
session.userid, session.inforum, session.lastactivity, session.badlocation,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM vb_session AS session
LEFT JOIN vb_user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1714249658
SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
FROM vb_forum AS forum
LEFT JOIN vb_user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN vb_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM vb_moderator AS moderator
INNER JOIN vb_user AS user USING(userid)
SELECT title, template
FROM vb_template
WHERE templateid IN (6442,1314,33735,33736,33737,33739,33740,33741,33742,33738,7402,33809,33815,14437,33811,33812,33813,33814,34160,7408,7407,8564,34282,0,0,6450,6444,13350,13024,13022,31734,31629,6451,6452,2680,33997,34271,19731,33947,33944,33945,33946,34301,0,0,34281,34242,33967,33968,33970,33971,34194,34313,34295,34245,34246,33794,33793,33797,33334,33358,19649,19652,19653,19651,19650,19654,19655)
SELECT post.dateline, post.pagetext AS message, post.allowsmilie, post.postid,
thread.threadid, thread.title, thread.prefixid, post.attach,
forum.forumid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb_post AS post
JOIN vb_thread AS thread ON (thread.threadid = post.threadid)
JOIN vb_forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN vb_user AS user ON (post.userid = user.userid)
LEFT JOIN vb_cms_nodeinfo AS info ON info.associatedthreadid = thread.threadid
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(65,20,40,34,3,12,14,13,32,17,15,16,19,18,23,24,36,29,2)
AND thread.visible = 1
AND post.visible = 1
AND thread.open <> 10
AND post.dateline > 1714164458
AND info.associatedthreadid IS NULL
ORDER BY post.dateline DESC
LIMIT 0,16
SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost AS threadlastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb_thread AS thread
INNER JOIN vb_forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_user AS user ON (thread.postuserid = user.userid)
LEFT JOIN vb_cms_nodeinfo AS info ON info.associatedthreadid = thread.threadid
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(65,20,40,34,3,12,14,13,32,17,15,16,19,18,36,29)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1711658858
AND info.associatedthreadid IS NULL
ORDER BY thread.replycount DESC
LIMIT 0,3
SELECT data, expires, locktime, serialized
FROM vb_cache
WHERE cacheid = 'forumblock.31ca0913eba23f34c91f1f9e427907d9'
SELECT data, expires, locktime, serialized
FROM vb_cache
WHERE cacheid = 'forumblock.a0ddce57cce59bae0c49d93004f376cf'
SELECT bm.userid, bm.permissions, bm.type, user.username
FROM vb_blog_moderator AS bm
INNER JOIN vb_user AS user USING (userid)
SELECT blog.blogid, blog.comments_visible as replycount, blog.title, blog.lastcomment, blog.lastcommenter, blog.postedby_userid, blog.postedby_username, blog.dateline,
blog_text.blogtextid, blog_text.pagetext AS message,
blog_user.title as blogtitle, blog_user.description as blogdescription,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb_blog AS blog
INNER JOIN vb_blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
INNER JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
INNER JOIN vb_user AS user ON (blog.userid = user.userid)
LEFT JOIN vb_blog_categoryuser AS cu ON (cu.blogid = blog.blogid)
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND blog.dateline > 1706474858
AND blog.state IN('visible')
AND blog.dateline <= 1714250858
AND blog.pending = 0
AND options_guest & 1
AND ~blog.options & 8
ORDER BY blog.dateline DESC
LIMIT 0,3
SELECT blog.blogid, blog.comments_visible as replycount, blog.title, blog.lastcomment, blog.lastcommenter, blog.postedby_userid, blog.postedby_username, blog.dateline,
blog_text.blogtextid, blog_text.pagetext AS message,
blog_user.title as blogtitle, blog_user.description as blogdescription,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb_blog AS blog
INNER JOIN vb_blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
INNER JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
INNER JOIN vb_user AS user ON (blog.userid = user.userid)
LEFT JOIN vb_blog_categoryuser AS cu ON (cu.blogid = blog.blogid)
LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND blog.dateline > 1706474858
AND blog.state IN('visible')
AND blog.dateline <= 1714250858
AND blog.pending = 0
AND options_guest & 1
AND ~blog.options & 8
ORDER BY blog.dateline DESC
LIMIT 0,3
UPDATE vb_session
SET lastactivity = 1714250858, location = '/forum.php', badlocation = 0
WHERE sessionhash = 'efb744f319ae5a536206ab8ca713d218'
A4-Freunde.COMmunity - Dein Forum zum Thema Audi A4
');
var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
//-->
Ich würde tatsächlich auf Zubehör gehen, also z.b. Bilstein. Also OEM Spezifikation und kein...
Teilenummern-Thread - Hier kein...