Board Logo
Go To Bottom

Printable Version  
[ Total Views: 12320 | Total Replies: 28 | Thread Id: 32164 ]
Author: Subject: Tech Article : Can I use "rattle can" paint on my car?
MemberGibbo
Custom Title Time!
*****


Avatar


Posts: 1683
Threads: 324
Registered: June 29th, 2004
Member Is Offline

Location: Southside Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: I Want to Learn Welding!

nike.gif posted on November 26th, 2004 at 10:48 AM
Tech Article : Can I use "rattle can" paint on my car?


FAQ #6 - Can I use "rattle can" paint on my car?
The following was graciously donated by MARTINSR.


There are many reasons why we would choose to us an aerosol or “rattle can”. The convince of a small container with no clean up, or the lack of a compressor, or the product needed commonly comes in an aerosol like spray adhesive. Now, I know that you are saying, “come on, what could I need to learn about rattle cans”. One of my job duties as a paint rep was doing the “defects” every month or so. I would go into the distribution center and find six or seven cases of aerosol cans among the assorted sandpaper and bondo that “didn’t work” for the customer. I say “defects” because there are very, very few actual defects, most were returned do to misuse. With about 99% of these aerosols only problem being that they were plugged up I figure there are a lot of people out there doing as I always did and some “basics” could be used.

First off, what makes the thing work? The aerosol can is simply a tank filled with compressed air that pushes out the product when you open the valve. In a 12oz aerosol can there is about 4oz of paint product, 2 or 3 ounces of solvent and the rest is the propellant (compressed air basically). The nozzle is hooked to the pickup tube that runs down to the bottom of the can into the product. If you were to turn the can upside down, the end of the pickup tube would be up at the bottom of the can in the propellant right? More on this following.

The propelent is at the top of the can pushing down on the paint product. When you push on the nozzle the valve is opened to release the pressure. The propellant pushes down on the paint product forcing it up the pickup tube, out the nozzle onto the surface being painted. About the only thing that can go wrong with this simple design is for the tube or nozzle to get clogged.

This is exactly what would happen to a huge majority of the aerosols in the defect department. There is a very simple procedure that will eliminate this.

First: Shake the can like it says in the instructions. Most say for two or more minutes. Look at a clock and shake it for two or more FULL minutes, not the 20 seconds we THINK is long enough.

Second: Turn the can upside down and give it a spray to clear the nozzle. Most of the time there should only be air at this point. You are now ready to spray.

Third: When you are done spraying, turn it upside down and clear the nozzle and pickup tube by spraying out all the paint that is in the tube and nozzle. Remember, the end of the tube is up in the propellant at the “bottom” of the can. It is like spraying air through a spray gun when you clean it.

THIS IS VERY IMPORTANT!

If you do this EVERY time you use the can, you WILL use it till it is empty and never throw away a can for being clogged again.

You can even save clogged cans with this method, I used to save cans in the defect department all the time.

Remember, there is very little actual paint in the can and it is very thin. You need to apply a number of thing coats to get good results. I have never did a mil thickness test on an aerosol but I would venture to guess it is somewhere .05 mils a coat. The average paint product shot out of a gun is about 1.5 mils (some etching primers are down to .05 all the way to high solids clears and primers giving 4 or 5).

So if you only apply a coat or two, you are not getting the mil thickness needed for good protection.

Advanced rattle can use: Aerosols you buy at the parts store are pretty limited. Limited to 1K (though there are some 2K aerosols now hitting the market). Limited to color or product you can get. But there are a few ways to use aerosol technology in your projects. You can move up to unlimited color, and product choice, even hardener!

One is to have cans “Custom filled”. This is a really neat process where the paint store puts the paint of your choice in an “empty” can (it already has the solvent and propellant in it). The “empty” can looks just like a normal aerosol, it simply has no paint product in it. The paint store employee puts this aerosol in a “press” like device. A funnel is install right into the top of the pickup tube where the nozzle fits. This funnel is actually a cylinder in which a piston is installed, after the cylinder is filled with paint product. The piston is pushed down with a manual handle or even air powered ram.

You then have an aerosol with any product you want, as long as it is compatible with the solvent in the can. They were limited to lacquer, synthetic enamel and enamel. There are now “universal” fillable cans that will take darn near anything. I have even seen a guy mix the hardener in with the enamel paint, rush home and paint with it before the paint “kicked”. Sounds crazy, but it worked.

Check with your local paint supplier, he may have one of these filler in the back hidden from view. The seldom make it well know that they have it being it is kind of a pain to use. Ask and you may be in luck. You may have to buy a pint of paint and then fill a few aerosols if you need a color mixed.

Another way is with a “Preval” system. I don’t know of any other brand names but there may be others. This is a glass jar with a removable, replaceable propellant can that screws on the top. The disposable propellant can has the pick up tube hanging off the bottom that goes down into the bottom of the glass jar into the paint product. The top has the nozzle just like a regular aerosol. I am sure you get the idea. Any paint product can be put in the jar and sprayed. This includes epoxies, or urethanes using hardener. Is that cool or what?

Some products may need some over reducing to get them out of the nozzle. Some may not work at all because of their high viscosity like polyester primer. But your range is much wider with these two advanced aerosol systems.

One of my street rod mentors who lived near me as a kid sprayed an entire “T” bucket hot rod with aerosols and showed the car! You can get good results, just give the preparation the same respect as you would spraying it with a gun.

VERY IMPORTANT

Just because you are “only” spraying with an aerosol doesn’t mean you don’t need to protect yourself, please do so.




http://img63.imageshack.us/img63/7488/userbar334840xm.gif
MemberColumBUS
A.k.a.: The Liquid Chef
Wolfsburg Elder
Hail To The Bus Driver!
*******


Avatar


Posts: 3601
Threads: 164
Registered: September 12th, 2004
Member Is Offline

Location: Sydney CBD... Sydney!
Theme: UltimaBB Pro Blue ( Default )
Mood: Euro - Trashed

posted on November 27th, 2004 at 04:52 AM


great stuff!

i have a question; i am keen on aerosol murals on my car, i think the best way to execute this would be a matt black base coat, aerosol artwork, then clear coat. what is your opinion on this? do you think having more paint (albeit not much) would affect the paint in any way?




http://i77.photobucket.com/albums/j68/kroozinkikko/fishsigfinalsmall.jpg
Memberkustomkool
A.k.a.: Damian Von
Custom Title Time!
BEING KOOL AINT CHEAP
*****


Avatar


Posts: 1611
Threads: 178
Registered: November 8th, 2002
Member Is Offline

Location: Melbourne,Victoria
Theme: UltimaBB Pro Blue ( Default )
Mood: farked up...

posted on November 27th, 2004 at 07:33 PM


There are heaps of shit paint on the market stick to these brands Belton ,krylon,montana all the rest are crap..



http://i43.photobucket.com/albums/e372/mear156/kustbann.jpg
Memberkillakornkobb
A.k.a.: Damien
Custom Title Time!
where's that clutch?
*****


Avatar


Posts: 1663
Threads: 149
Registered: March 28th, 2004
Member Is Offline

Location: Rowville, Melbourne
Theme: UltimaBB Pro Blue ( Default )
Mood: Pierced

posted on November 27th, 2004 at 08:18 PM


my cousin's place is full of montana aerosols!! and the work he does always looks sweet!!



Tagedeezee Heezy
MemberThe_Bronze.
A.k.a.: Bronze
Custom Title Time!
Minister of Volkswagenism
*****


Avatar


Posts: 1922
Threads: 238
Registered: September 1st, 2002
Member Is Offline

Location: Toronto - Westlakes NSW
Theme: UltimaBB Pro Blue ( Default )
Mood: Enlightened.

posted on December 8th, 2004 at 11:36 PM


Do it Dog-O-War Style:

Roll it on!

Bronze.




[size=4]Bronze.[/size]

Rathmines, Lake Macquarie, NSW.
MemberOasis
Custom Title Time!
Going alone...
*****


Avatar


Posts: 1806
Threads: 77
Registered: July 5th, 2003
Member Is Offline

Location: Cammeray, Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Deep

posted on December 9th, 2004 at 01:36 AM


Mate, I brushed it on with a house painting brush. Left a couple of strands of dog hair on the car, but it took 2 hours and was a pleasant change bin scenery...



"Tell him 'We've already got one'"
Memberakean1
A.k.a.: Dr Akean
Custom Title Time!
Remember To Love
*****


Avatar


Posts: 1088
Threads: 90
Registered: December 27th, 2004
Member Is Offline

Location: north end of melbourne
Theme: UltimaBB Pro Blue ( Default )
Mood: On my bike...

posted on December 29th, 2004 at 09:14 AM


Belton brands are the easiest to use, lots of colour choice and faster drying
than montana. there has just recently been an australian brand of artist,s aerasols released called IRONLAK wich sells for almost half the price, check http://www.ironlak.com  for retailers
MemberPierced_VW
Learner Dubber
*


No Avatar


Posts: 10
Threads: 3
Registered: January 26th, 2005
Member Is Offline

Location: Perth, W.A. (SOR)
Theme: UltimaBB Pro Blue ( Default )
Mood: Cruisin

nike.gif posted on January 27th, 2005 at 06:11 AM


I used "rattle cans" on our (the wife's as well) 69 type 3 convertible. I found it easier then using bulk air and paint. In my opinion and othters that have seen the car up close. It turned out pretty damn shinny.
The pic is of the bonnet after applying the clear coat.
Good Luck

Error
Sorry, you must be a registered user in order to download attachments.




Scotty & Rach
69 Type 3 Convertible
Classic, Not Plastic
Membervisitor
Casual Dubber
*


No Avatar


Posts: 36
Threads: 12
Registered: July 25th, 2005
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on August 31st, 2005 at 10:08 PM


Pierced-VW
Can you please tell me what sort of paint you used- with the clear coat also? I'm in Perth too, SOR, so could I have the name of the shop too? Your bonnet looks fantastic!!!
MemberWarrenm
Wolfsburg Wizard
***


Avatar


Posts: 466
Threads: 98
Registered: August 6th, 2004
Member Is Offline

Location: Western Australia
Theme: UltimaBB Pro Blue ( Default )
Mood: Cruising & Happy

posted on November 19th, 2005 at 06:30 PM



Quote:
Originally posted by visitor
Pierced-VW
Can you please tell me what sort of paint you used- with the clear coat also? I'm in Perth too, SOR, so could I have the name of the shop too? Your bonnet looks fantastic!!!



If you go to SS Enterprises in Midvale they will make spray cans to whatever colour you want-They are suppliers to the trade and most paint Is Spies and Heckler.




Membertassupervee
A.k.a.: Knob Jockey
Custom Title Time!
That really hurts doesnt it!
*****


Avatar


Posts: 1171
Threads: 25
Registered: September 21st, 2003
Member Is Offline

Location: Huon Valley SouthernTasmania
Theme: UltimaBB Psyche Blue
Mood: Moody!

posted on November 19th, 2005 at 10:10 PM



I sprayed my superkart bodywork with Dulux household enamel cans. The Dulux was the pick of the bunch with excellent coverage and very strong pigments that covered a variety of sins. These cans also have a superior spray nozzle compared to nearly all of the different brands i have tried.
The "gun finish" is great and with a bit of practise you can induce varying amounts of "character" into the finish and the olde fashoined enamel is pretty much impervious to fuels and quite chip and scratch resistant.
I found that quite a few consecutive dust coats followed up by one really heavy final coat seemed to do the trick and minimised sagging.
http://www.ozsuperkart.net/images/Ecreeksilkyrooster.JPG 
i sparayed my first F-Vee in the same house paint but using a compressor and gun. It was winter in Southern Tassie, foggy and about 5 degrees in an open ended shed and apart from the bits of dust the result was remarkably good.
I pissed the enamel down quite a lot with turps to get it out of the gun set up for automotive paint and added an accellerant.
L8tr
E




Im not a complete idiot, quite a few parts are missing....
Memberitchworth
Learner Dubber
*


No Avatar


Posts: 1
Threads: 0
Registered: January 22nd, 2006
Member Is Offline

Location: melbourne
Theme: UltimaBB Pro Blue ( Default )
Mood: bashful

posted on January 22nd, 2006 at 02:41 AM



Quote:
Originally posted by akean1
Belton brands are the easiest to use, lots of colour choice and faster drying
than montana. there has just recently been an australian brand of artist,s aerasols released called IRONLAK wich sells for almost half the price, check http://www.ironlak.com  for retailers

hey guys just found your forum,
nice topic! :P
"This is it" store in richmond is selling prolines for bout the same price as ironlaks at the moment' ($8 ?).
proline/aerosol art cans are my fav at the moment but
i do like ironlacks.
for all people non conversant in the semantics of "rattle can" tech, the thing to look for is the nozzles-
most quality brands have a standardised cap system,
they come in a range of sizes from ultra skinny to super fat, and you buy them seperately to your tins.(50cent)
also u get what you pay for with spray paint tins..
go cheap n youll get runny uneven paint finishes.
you could paint a car with white aust' export for a nice runny birdshit effect.
dont much like dulux..
beltons,montanas,prolines,ironlacks should be what your looking for...nice consistant coats.beltons a good benchmark, other brands tend to have a few watery colours.
forget krylon, it just doesnt match up in terms of quality.
was the benchmark ten years ago..
with a bit of practice you can pull some pretty crazy shit with tins, n you wont even need an airbrush.
MemberWA Volksrodder
Seriously Crusin Dubber
**


Avatar


Posts: 105
Threads: 4
Registered: December 24th, 2005
Member Is Offline

Location: Perth
Theme: UltimaBB Pro Blue ( Default )
Mood: Tired and Angry

posted on January 22nd, 2006 at 04:43 AM



I own a beetle that was sprayed with cans...
The job is not good and the paint has turned to powder and comes off all over you if you touch it or lean on it...
Horrible...




The opinion of The Village Idiot, only matters to those that would have him Ring The Bell....
Membershaihulud
Custom Title Time!
*****


No Avatar


Posts: 1448
Threads: 197
Registered: November 4th, 2005
Member Is Offline

Location: Perth
Theme: UltimaBB Pro Blue ( Default )

posted on February 2nd, 2006 at 03:24 PM



I had the body of my buggy painted twice by a graffiti artist who used automotive quality touch up cans. It was awesome and the paint was super tough.
Memberlowmanx
Learner Dubber
*


Avatar


Posts: 5
Threads: 2
Registered: February 4th, 2006
Member Is Offline

Location: Newcastle, Australia
Theme: UltimaBB Pro Blue ( Default )

posted on February 6th, 2006 at 01:47 PM



I think I'll have to look at trying to get some spray can paint to touch up a deep scratch on my back fender. My GF tried to park the dub in the driveway but didn't have her glasses on... needless to say, the wall jumped out and attacked her. It's the only time I've ever actually sworn at her. *sigh* She could have at least done it to the dodgy old paint job at the front as opposed to the professional job at the back... but no, murphy's law strikes again. LOL

Considering I'm only touching it up so as rust doesn't set in (the scratch is through to the metal) do I need to put a bit of undercoat on it first or would it be fine to just spray on? Keeping in mind I'll be *hopefully* getting a new all-over paint job soon-ish.

LX.
Memberblue_bug
Commited Dubber
**


Avatar


Posts: 71
Threads: 4
Registered: May 4th, 2006
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on May 11th, 2006 at 04:34 PM



Quote:
Originally posted by kustomkool
There are heaps of shit paint on the market stick to these brands Belton ,krylon,montana all the rest are crap..

krylons crap to :lol: best to use is acrylic enamel...its the same paint they used on cars back in the day.




Aircooled for a reason...water is for boats
MemberSumo178
Casual Dubber
*


Avatar


Posts: 35
Threads: 2
Registered: March 23rd, 2006
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro Blue ( Default )

posted on May 22nd, 2006 at 03:14 PM



If you want a good paint use Moltona ( not Montana ) as it is an auto paint but has a good range of colours. This paint is the paint of choice for graffiti by the importers of Montana,Moltona,Belton etc. I know this as I know the importer well.

I am also a graffiti artist for 16 years and have a lot of experience with aerosol paint. I also used to do reviews on all the paints in a fairly well know magazine and have tried almost every brand available.
MemberXXX-1.8T
Bishop of Volkswagenism
******


Avatar


Posts: 3113
Threads: 454
Registered: October 9th, 2002
Member Is Offline

Location: Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Oil Drippin

posted on May 23rd, 2006 at 10:12 AM



sumo u have u2u
Memberbajaben
A.k.a.: Ben Alderson
Officially Full-On Dubber
***


Avatar


Posts: 222
Threads: 33
Registered: May 10th, 2005
Member Is Offline

Location: Townsville, north queensland
Theme: UltimaBB Pro Blue ( Default )
Mood: need more power

posted on May 23rd, 2006 at 10:49 AM



i own a skate shop that sells alot of paint etc and we have had krylon, belton and ironlak. ironlak and belton are by far the best and ironlak seems to cover better and have a nicer finish than belton and its only half the price so i would recommend that. but as for painting a car with it, would take a few cans but would be a hell of a rat look. i wanna do a matt black proffesional paint job then get my mates to graf over the top, would be so ghetto :P



trunk monkey, because sometime getting your car back just isn't enough
MemberSumo178
Casual Dubber
*


Avatar


Posts: 35
Threads: 2
Registered: March 23rd, 2006
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro Blue ( Default )

posted on May 24th, 2006 at 01:46 AM



Ironlak has a tendance to react with other paints and even with its other colours. I have had Ironlak Black fry up when used with Ironlak white!! but for the price its ok.
Membereraser
Fahrvergnugen
****


Avatar


Posts: 970
Threads: 128
Registered: March 11th, 2005
Member Is Offline

Location: Adelaide
Theme: UltimaBB Pro Powder

posted on October 17th, 2006 at 06:14 PM



I remember seeing a spray can spray gun somewhere for sale. Wish i had grabbed it makes life alot easier. Was basically a little plastic spraygun and you fitted the spray can inside without the nosil on top.



http://www.vwgeek.com/wp-content/uploads/2008/08/banner.jpg

Member68AutoBug
A.k.a.: Lee Noonan
Aircooled Master
Beetle Restorer - Experience over 138% - YIKES --
**********


Avatar


Posts: 11654
Threads: 449
Registered: August 31st, 2002
Member Is Offline

Location: SCONE in UPPER HUNTER VALLEY NSW
Theme: UltimaBB Pro Yellow
Mood: Really Mentally Ill - all of the time -

posted on October 17th, 2006 at 07:35 PM



Quote:
Originally posted by kustomkool
There are heaps of shit paint on the market stick to these brands Belton ,krylon,montana all the rest are crap..


Well, I've never seen or heard of those brands..
I only use rattle can paint to paint under the car...
usually black - matt or satin finish...
I find the more expensive the paint is, the better the product and the can spray unit are...

Taubmans and Dulux are standard brands of enamel..

cheaper paints than these are rubbish and if You can spray all the paint out without having it all over Your finger
.. good luck...

I've used Motorpro paint products with good results...
from Auto shops.... I've also used VHT paints with good results, but I've never tried to paint a car with any of these....

Lee

http://community.webshots.com/user/vw68autobug 




- [size=4]Helping keep Air Cooled VWs on the road - location: SCONE in the Upper Hunter Valley - Northern NSW 320 kms NNW of SYDNEY--- [/size]
MemberLearner
A.k.a.: Lionel Luu
Officially Full-On Dubber
***


No Avatar


Posts: 238
Threads: 55
Registered: July 27th, 2006
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro Blue ( Default )

posted on November 13th, 2006 at 06:38 PM



hey guys where can i found the good brands in melbourne? south eastern subs prefered but i'mnotthat lazy....

and also what is the best way toprepare the metal for cans?

cheers
MemberIwish4aSynchro
Wolfsburg Wizard
***


Avatar


Posts: 639
Threads: 102
Registered: August 7th, 2006
Member Is Offline

Location: Maclean NSW
Theme: UltimaBB Pro Blue ( Default )
Mood: Cheery

posted on February 18th, 2007 at 08:20 PM



I have recently repainted my bullbar on T3 syncro matt black after all prep work and finish with 3 coats of matt black i am wondering if i should apply clear coat?
Is it overkill?
Remember i really dont want the glossy shine on bullbar and i think this is what will happen if i clear coat it.
But i alos dont want it to become chalky and overly dry, u know the dusty type of finish U get after about 6months in the sun.




Keep the steering and the propulsion seperate . Still a Kombi...

It's all good, until it's bad, i suppose
MemberType3Sicko
Wolfsburg Wizard
***


Avatar


Posts: 596
Threads: 70
Registered: December 13th, 2006
Member Is Offline

Location: Nowhere
Theme: UltimaBB Pro Blue ( Default )
Mood: yes thanks

posted on February 24th, 2007 at 06:05 AM



Cool thread...must agree with most posts regarding you get what you pay for. It also helps if you do the prep properly, take the time to sand, degrease and clean the area you intend to paint with a decent product. let it air dry and as long as there is no silicone or residue of car wash/ wax, paint or whatever you should get a pretty even finish. letting the paint dry sufficiently also aids finish quality and even though "most" aerosol can finishes can't be buffed, please correct me and I'm sure I will be :) a couple of coats of clear acrylic will help to seal the generally good lustre that decent brand cans offer. paying a couple of hundred bucks for aerosol paint(X2 coats is better than one) and the associated stuff like masking tape for clean edges and acrylic clear certainly beats paying thousands for what can be a shit job that makes you wish you had done it yourself...and lets face it, at least you can say I did it, if you don't like the result...pick another colour and do it again, knowing that you have done it once, twice at least you know whats ahead of you and hey guys! It's YOUR RIDE, do what you want...for those with a few dollars more, check out POR 15 using their preval spayers and other equipment ,you can get a good quality finish for less than you think and it's great for chassis, underbody etc...also this one for the aerosol crew... http://www.eplate.com.au  ph (08)95724616 they do candy apple colours in a can to your specs and sell electroplating kits. Have fun :) Adam



How many is enough?
MemberIwish4aSynchro
Wolfsburg Wizard
***


Avatar


Posts: 639
Threads: 102
Registered: August 7th, 2006
Member Is Offline

Location: Maclean NSW
Theme: UltimaBB Pro Blue ( Default )
Mood: Cheery

posted on February 27th, 2007 at 09:03 PM



Recently used the preval butane spray kit and what can i say it works a treat.
Instead of paying 27bucks for a matched can of aerosol i chose the preval sprayer, the only down side is paint goes on very thinly because of mixture ratio, so use at least a three coat acrylic system before thinking about rub down with paper.....
On the upside you can slap it on without the fear of overkill....
Otherwise a very good investment 1 butane can doe's about 500ml of paint maybe a little more.




Keep the steering and the propulsion seperate . Still a Kombi...

It's all good, until it's bad, i suppose
MemberDylanTheDubber
Custom Title Time!
*****


No Avatar


Posts: 1252
Threads: 173
Registered: June 5th, 2009
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on November 12th, 2009 at 07:16 PM



We had an old 1973 L Bug that we just used to paint it with rattle cans. It was a bit of a rat bug.
MemberGedMcCormick
Casual Dubber
*


Avatar


Posts: 49
Threads: 17
Registered: October 20th, 2011
Member Is Offline

Location: Gold Coast
Theme: UltimaBB Pro Blue ( Default )
Mood: Yes

posted on November 3rd, 2011 at 08:59 PM



In the 1970s old man re-sprayed our beetle with mums Volta vacuum cleaner on reverse and the optional spray bottle for the nozzle.

Had a finish like shark skin. Filthy!




Ged
Memberjr232
Learner Dubber
*


Avatar


Posts: 14
Threads: 3
Registered: August 20th, 2012
Member Is Offline

Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )

posted on October 17th, 2012 at 07:52 PM



Thanks for the interesting info everyone!


  Go To Top


Powered by GaiaBB, © 2011 The GaiaBB Group


[ Queries: 40 ] [ PHP: 35.3% - SQL: 64.7% ]
#Duration:Query:
1.0.00015402SELECT * FROM ubb_settings
2.0.00009894SELECT moderator FROM ubb_forums WHERE moderator != ''
3.0.00008011SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
4.0.00008297SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
5.0.00006700SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
6.0.00006509SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
7.0.00006104SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
8.0.00006294SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
9.0.00007105SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
10.0.00005794SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
11.0.00005889SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
12.0.00005412SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
13.0.00006294SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
14.0.00006318SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.0.00034499SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robots ORDER BY strlen DESC
16.0.00008702SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '32164'
17.0.00012612DELETE FROM ubb_whosonline WHERE ip = '52.203.18.65' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1643006941'
18.0.00006509INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('xguest123', '52.203.18.65', LPAD('1643007541', '15', '0'), '/viewtopic.php?tid=32164&page=1', '0', '')
19.0.00007296DELETE FROM ubb_guestcount WHERE ((ipaddress = '52.203.18.65') OR (onlinetime < '1642921141'))
20.0.00004292DELETE FROM ubb_robotcount WHERE ((ipaddress = '52.203.18.65') OR (onlinetime < '1642921141'))
21.0.00005102INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('52.203.18.65', '1643007541')
22.0.00008392SELECT * FROM ubb_themes WHERE themeid = '1'
23.0.00007415SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.0.00006008SELECT id FROM ubb_banned WHERE ((ip1 = '52' OR ip1 = '-1') AND (ip2 = '203' OR ip2 = '-1') AND (ip3 = '18' OR ip3 = '-1') AND (ip4 = '65' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.0.00025105SELECT fid, type, name, fup, status, private, userlist, password FROM ubb_forums WHERE private != '5' AND private != '3' AND private != '2' AND userlist = '' AND password = '' AND status = 'on' ORDER BY displayorder
26.0.00007200SELECT themeid, name FROM ubb_themes
27.0.00052381SELECT name, template FROM ubb_templates WHERE name IN ('functions_bbcode', 'functions_bbcodeinsert', 'functions_smilieinsert_smilie', 'functions_smilieinsert', 'viewtopic_reply', 'viewtopic_quickreply', 'viewtopic', 'viewtopic_invalid', 'viewtopic_modoptions', 'viewtopic_newpoll', 'viewtopic_newtopic', 'viewtopic_poll_options_view', 'viewtopic_poll_options', 'viewtopic_poll_submitbutton', 'viewtopic_poll', 'viewtopic_post', 'viewtopic_post_email', 'viewtopic_post_site', 'viewtopic_post_icq', 'viewtopic_post_aim', 'viewtopic_post_msn', 'viewtopic_post_yahoo', 'viewtopic_post_search', 'viewtopic_post_profile', 'viewtopic_post_pm', 'viewtopic_post_ip', 'viewtopic_post_repquote', 'viewtopic_post_report', 'viewtopic_post_edit', 'viewtopic_post_delete', 'viewtopic_post_attachmentimage', 'viewtopic_post_attachment', 'viewtopic_post_attach_noborder', 'viewtopic_post_attimg_noborder', 'viewtopic_post_sig', 'viewtopic_post_nosig', 'viewtopic_printable', 'viewtopic_printable_row', 'viewtopic_multipage', 'viewtopic_post_attachment_none', 'viewforum_rules', 'viewtopic_post_blog', 'viewtopic_post_rpg', 'viewforum_mpn_info', 'viewtopic_next_prev_links', 'viewtopic_captcha', 'css', 'error', 'footer', 'footer_querynum', 'footer_load', 'footer_phpsql', 'footer_totaltime', 'header', 'message', 'meta_tags', 'shadow', 'shadow2')
28.0.00010896SELECT t.tid, t.fid, t.subject, t.views, t.replies, t.closed, t.topped, l.uid as lp_uid, l.username as lp_user, l.dateline as lp_dateline, l.pid as lp_pid FROM ubb_threads t LEFT JOIN ubb_lastposts l ON l.tid = t.tid WHERE t.tid = '32164'
29.0.00008297SELECT * FROM ubb_forums WHERE fid='56' AND status='on'
30.0.00006199SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
31.0.00003099SELECT find, replace1 FROM ubb_words
32.0.00007415SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
33.0.00007415UPDATE ubb_threads SET views = views+1 WHERE tid = '32164' LIMIT 1
34.0.00011110SELECT COUNT(pid) FROM ubb_posts WHERE tid = '32164'
35.0.00495982SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 32164 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline < x.dateline AND t.fid = '56' ORDER BY l.dateline DESC LIMIT 1
36.0.00403905SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 32164 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline > x.dateline AND t.fid = '56' ORDER BY l.dateline ASC LIMIT 1
37.0.00009203SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '32164'
38.0.00018787SELECT pid FROM ubb_posts WHERE tid = '32164' ORDER BY pid LIMIT 0, 30
39.0.00034809SELECT * FROM ubb_attachments WHERE pid IN('270499', '270835', '271084', '271108', '276916', '276953', '285369', '299137', '403031', '430429', '430476', '449428', '449433', '453011', '453997', '487237', '491331', '491621', '491629', '492009', '545472', '545518', '554999', '573722', '575119', '575919', '746953', '870205', '927216')
40.0.00065899SELECT p.*, m.*,w.time FROM ubb_posts p LEFT JOIN ubb_members m ON m.username = p.author LEFT JOIN ubb_whosonline w ON p.author = w.username WHERE p.fid = '56' AND p.tid = '32164' ORDER BY p.pid ASC LIMIT 0, 30