SET @@sql_mode = '' SELECT * FROM vb_datastore WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','blogstats','blogfeatured_settings','blogfeatured_entries','blogtagcloud','navdata','navdata','attachmentcache','cron','profilefield','loadcache','noticecache','activitystream','routes') SELECT * FROM vb_session WHERE sessionhash = '1c26265ff6159192f68ecd840389defc' AND lastactivity > 1714249731 AND idhash = '6d01e73c20450132027d15a40ba08212' SELECT * FROM vb_session WHERE userid = 0 AND host = '18.218.55.14' AND idhash = '6d01e73c20450132027d15a40ba08212' LIMIT 1 SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_posting AS phrasegroup_posting, phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal, phrasegroup_postbit AS phrasegroup_postbit, phrasegroup_vbblogcat AS phrasegroup_vbblogcat, phrasegroup_inlinemod AS phrasegroup_inlinemod, 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 data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'cms_priv_user_0' SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, 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, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight , bu.bloguserid, bu.entries, bu.options AS blog_options, bu.subscribeown AS blog_subscribeown, bu.memberids, bu.memberblogids, bu.subscribeothers AS blog_subscribeothers, bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.draft AS blog_draft, bu.pending AS blog_pending, bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.akismet_key AS blog_akismet_key, isblogmoderator, bu.comments_moderation AS blog_comments_moderation, bu.lastblog, bu.lastblogid, bu.lastblogtitle, bu.categorycache, bu.tagcloud, bu.sidebar, bu.custompages, bu.customblocks, blockparsed.blocktext, 7 AS blogstyleid, blog_usercsscache.csscolors AS blog_csscolors, blog_usercsscache.cachedcss AS blog_cachedcss, IF(blog_usercsscache.cachedcss IS NULL, 0, 1) AS blog_hascachedcss, blog_usercsscache.buildpermissions AS blog_cssbuildpermissions, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed FROM vb_user AS user LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb_blog_user AS bu ON (bu.bloguserid = user.userid) LEFT JOIN vb_blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 7 AND blockparsed.languageid = 3) LEFT JOIN vb_blog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 24128) LEFT JOIN vb_blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid) WHERE user.userid = 24128 LIMIT 1 SELECT bm.userid, bm.permissions, bm.type, user.username FROM vb_blog_moderator AS bm INNER JOIN vb_user AS user USING (userid) SELECT COUNT(*) AS total, FROM_UNIXTIME(dateline - 0, '%c-%e-%Y') AS period FROM vb_blog AS blog LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid) WHERE options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND dateline >= 1711234800 AND dateline < 1714250931 AND blog.userid = 24128 GROUP BY period SELECT title, template FROM vb_template WHERE templateid IN (33285,33320,33388,33337,33283,33282,33281,33798,33796,33350,33371,33323,33324,33325,33332,33365,33366,33372,33368,33369,33370,33367,33373,33374,33375,33377,33378,33379,33380,33376,33385,33382,33278,34020,34022,33340,33331,33339,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,33781,33786,33782,33788,33789,33784,33785,33787,33726,33728,33730,33732,33734,33960,33955,33958,33959,34039,34040,33961,33956,33953,33954,34252,33358,0,0,0,0) SELECT MAX(dateline) AS dateline FROM vb_blog AS blog LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid) WHERE options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND blog.userid = 24128 AND dateline <= 1711922399 SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, blog_visitor.visible FROM vb_blog_visitor AS blog_visitor INNER JOIN vb_user AS user ON (user.userid = blog_visitor.visitorid) WHERE blog_visitor.userid = 24128 AND (visible = 1 OR blog_visitor.visitorid = 0) ORDER BY blog_visitor.dateline DESC LIMIT 20 SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title ,avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight FROM vb_blog AS blog LEFT JOIN vb_blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid) LEFT JOIN vb_user AS user ON (blog_text.userid = user.userid) INNER JOIN vb_user AS user2 ON (blog.userid = user2.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE blog.userid = 24128 AND blog_text.blogtextid <> blog.firstblogtextid AND blog_text.state IN ('visible') AND blog.state IN ('visible') AND blog.dateline <= 1714250931 AND blog.pending = 0 AND ~blog.options & 8 ORDER BY blog.lastcomment DESC LIMIT 5 SELECT blog.blogid, blog.title, blog.dateline, blog.state, blog.pending FROM vb_blog AS blog WHERE blog.dateline <= 1714250931 AND blog.pending = 0 AND blog.userid = 24128 AND blog.state IN ('visible') AND ~blog.options & 8 ORDER BY blog.dateline DESC LIMIT 5 SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vb_types.types' SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount FROM vb_tagcontent AS tagcontent INNER JOIN vb_tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN vb_blog AS blog ON (tagcontent.contenttypeid = 15 AND tagcontent.contentid = blog.blogid) INNER JOIN vb_blog_user AS blog_user ON (blog.userid = blog_user.bloguserid) WHERE blog.dateline <= 1714250931 AND blog.pending = 0 AND blog.state = 'visible' AND ~blog.options & 8 AND blog.userid = 24128 AND tagcontent.dateline > 1682714931 GROUP BY tagcontent.tagid, tag.tagtext ORDER BY searchcount DESC LIMIT 70UPDATE vb_blog_user SET tagcloud = 'a:3:{s:4:\"tags\";a:0:{}s:5:\"count\";i:0;s:8:\"dateline\";i:1714250931;}' WHERE bloguserid = 24128 SELECT SQL_CALC_FOUND_ROWS attach, blog.blogid, blog.dateline, blog.rating FROM vb_blog AS blog LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid) WHERE blog.userid = 24128 AND ~blog.options & 8 AND state IN('visible') AND blog.pending = 0 AND blog.dateline <= 1714250931 ORDER BY blog.dateline DESC LIMIT 0, 10 SELECT FOUND_ROWS() SELECT blog_categoryuser.blogid, blog_category.title, blog_category.blogcategoryid, blog_categoryuser.userid, blog_category.userid AS creatorid, user.usergroupid, user.membergroupids, user.infractiongroupids FROM vb_blog_categoryuser AS blog_categoryuser LEFT JOIN vb_blog_category AS blog_category ON (blog_category.blogcategoryid = blog_categoryuser.blogcategoryid) INNER JOIN vb_user AS user ON (user.userid = blog_categoryuser.userid) WHERE blogid IN (938,823,817,543,499,349,291) ORDER BY blogid, displayorder SELECT fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize, a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder, at.contenttypes FROM vb_attachment AS a INNER JOIN vb_filedata AS fd ON (fd.filedataid = a.filedataid) LEFT JOIN vb_attachmenttype AS at ON (at.extension = fd.extension) WHERE a.contentid IN (938,823,817,543,499,349,291) AND a.contenttypeid = 15 ORDER BY a.contentid, a.displayorder SELECT blog.*, blog.options AS blogoptions, blog_text.pagetext, ipdata.ip AS blogipaddress, blog_text.allowsmilie, blog_text.htmlstate, user.*, bu.title AS blogtitle, bu.memberids, bu.options_member, bu.options_guest, bu.options_buddy, bu.bloguserid, blog_textparsed.pagetexthtml, blog_textparsed.hasimages, blog_editlog.userid AS edit_userid, blog_editlog.dateline AS edit_dateline, blog_editlog.reason AS edit_reason, blog_editlog.username AS edit_username, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight ,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.firstblogtextid = blog_text.blogtextid) LEFT JOIN vb_ipdata AS ipdata ON (blog_text.ipaddress = ipdata.ipid) LEFT JOIN vb_blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid) LEFT JOIN vb_blog_textparsed AS blog_textparsed ON(blog_textparsed.blogtextid = blog_text.blogtextid AND blog_textparsed.styleid = 7 AND blog_textparsed.languageid = 3) LEFT JOIN vb_user AS user ON (blog.postedby_userid = user.userid) INNER JOIN vb_user AS user2 ON (blog.userid = user2.userid) LEFT JOIN vb_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb_blog_user AS bu ON (bu.bloguserid = blog.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE blog.blogid IN (938,823,817,543,499,349,291) ORDER BY blog.dateline DESC SELECT template FROM vb_template WHERE templateid = 34019 UPDATE vb_session SET lastactivity = 1714250931, location = 'blog/blog.php?u=24128', badlocation = 0 WHERE sessionhash = '2507254f3098a7342c6b657af2e481dc' A4-Freunde.COMmunity - Dein Forum zum Thema Audi A4 - QuattroManni - Blogs
RSS-Feed anzeigen

QuattroManni

  1. AEB 1,8t Wasserflansch am Zylinderkopf tauschen & Teileinfos!

    Hallo zusammen,
    wer den Wasserflansch hinten am Zylinderkopf tauschen möchte benötigt folgende Teile.
    Flansch: 058 121 132---- Dichtung Nr 1. ist enthalten
    Dichtringe:
    1. Flansch am Kopf 037 121 687 <---beim Flansch dabei!
    2. Flansch zu Wasserrohr 058 121 687
    3. Temp.Geber N903 168 02
    4. Verschlußstopfen neben dem Geber N903 168 02
    5. in der Schnellkupplung Wasservorlauf zu Wärmetauscher ist auch eine Dichtung. Die gibts nicht einzeln. Man kann ...

    Aktualisiert: 23.01.2015 um 23:11 von QuattroManni

    Kategorien
    Erfahrungswerte
  2. AEB Steuerkette und Spanner wechseln, einstellung prüfen.

    Hallo A4 Freunde,
    an meinem 1,8t MKB AEB rasselte, besonders beim Kaltstart, der Motor.
    Das Rasseln war beim spontanen Gasgeben aus dem hinteren Bereich des Motors zu hören.
    Da ja auch der Zahnriemenwechsel geplant war wollte ich dann auch gleich die Steuerkette und den Spanner wechseln.

    Zuerst muss dann mal der Motor auf Zünd-OT gestellt werden.
    Hier die Markierung der Nockenwelle und Kurbelwelle
    IMG_2016.jpgIMG_2017.jpg ...

    Aktualisiert: 15.01.2015 um 08:34 von QuattroManni

    Kategorien
    Kategorielos
  3. AEB Zahnriemen wechseln, einstellen.

    Hallo zusammen,
    da ich es letzte Woche im Forum versprochen habe den Riemenwechsel zu dokumentieren kommt hier der Blog Eintrag dazu.

    Ich habe den Wagen zuerst auf Auffahrrampen gestellt.
    Mir genügt das um überall gut hin zu kommen.
    Wichtig! den Wagen gut sichern, sprich Handbremse rein und Keile unter die hinteren Räder legen. Da wir ja später den Motor durchdrehen wollen muss der Wagen im Getriebe Leerlauf abgestellt werden.
    IMG_2008.jpg ...

    Aktualisiert: 04.02.2014 um 07:56 von QuattroManni

    Kategorien
    Erfahrungswerte
  4. Kraftstoffverlust am Kraftstofffilter, erneuern, tauschen. A4 B5 1,8t Quattro

    Gestern ist es passiert!
    Das erste mal brauchte der kleine länger das er anspringt.
    Hm komisch, hat er ja noch nie gemacht dachte ich mir, stelle den Motor wieder ab und startete erneut. Dann sprang er sofort an.
    OK, also kein Problem und ab 30km auf die arbeit fahren.

    Dort angekommen roch es leicht nach Sprit. Einen Blick unters Auto riskiert aber nix gesehen.

    Abends wieder ins Auto und nach Hause, sprang wieder schlechter an.

    Zu Hause angekommen ...

    Aktualisiert: 14.03.2013 um 08:23 von QuattroManni

    Kategorien
    Kategorielos
  5. Sitzheizung ohne funktion, Messen und Reparieren

    Hallo A4Freunde,
    im Winter ist es angenehm wenn man eine Sitzheizung hat. Schade nur wenn sie teilweise ausgefallen ist. Bei mir war das der Fall, es funktionierte leider nur noch der Außenbereich des Sitzkissens.
    Zuerst sollte man mit einem Ohmmeter ein paar einfache Messungen durchführen.
    Bitte zieht den Zündschlüssel ab wenn Ihr die Steckverbindungen trennt.
    Unter dem Sitz finden wir 3 Stecker, der grüne ist für die Sitzheizung.
    stecker.jpg ...

    Aktualisiert: 23.02.2013 um 11:54 von QuattroManni

    Kategorien
    Kategorielos
  6. ABS Regelt immer wieder bei langsamer Fahrt, ABS Ring hinten gebrochen

    Hallo zusammen,
    ich hatte immer das Ärgerniss das bei langsamer Fahrt und bei leichtem Linkseinschlag das ABS regelt.
    Manchmal auch bei Geradeausfahrt, allerdings so gut wie nie wenn nach rechts gefahren wurde.
    Im Fehlerspeicher war nichts und die Sensoren sind auch von den Messwerten her OK.
    Also Antriebswellen prüfen, welch ein spaß....
    OK, ich wollte den kleinen eh etwas näher auf die Straße bringen, sprich tieferlegen, da bietet es sich ja an die Sensorringe ...
    Kategorien
    Erfahrungswerte
    Miniaturansichten angehängter Grafiken Angehängte Grafiken
  7. Wie lange braucht man für eine Arbeit bei der nur 11 Schrauben zu lösen sind?

    Tja Leute,
    wie lange benötigt man wenn man eigentlich nur 11 Schrauben lösen muss um zwei obere Querlenkerstreben am A4 zu erneuern?
    5 Schrauben davon sind übrigens Radschrauben!

    Ich habe 4,5 Stunden benötigt!

    Ahrg, so eine beschissene Konstruktion!
    Vermutlich wird der ein oder andere wissen das die beiden oberen Querlenkerstreben am Achschenkel mit einer langen Klemmschraube befestigt werden.
    ...
    Kategorien
    Sonstiges
    Miniaturansichten angehängter Grafiken Angehängte Grafiken