Jump to content

nismopc

Members
  • Posts

    53
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by nismopc

  1. :fuckyeah: That doesn't look like a Nissan Titan. :gabe:
  2. And apparently will not stop cops from shooting innocent citizens. It wasn't even a damn Nissan or GREY in color. WTH?
  3. Is there a code or link? I didn't see that on their site http://www.armed2defend.com/
  4. That is not a Corvette. WTF? No way... ..C7. :lolguy:
  5. That was cleared up in the link provided earlier... http://www.ct.gov/despp/cwp/view.asp?Q=517284 It was a Izhmash Canta-12 Gauge Shot gun...
  6. Those are the stock rims... :fuckyeah:
  7. Was thinking same damn thing... :fuuuu:
  8. More... Pool dancers included. Old skool.
  9. Maybe I'll try again and see if it stays... ...they are planning on moving us to I-Space next. Bastardized version of Windows 7. Not sure how well this will go especially since we already know there are software conflicts with that and current software we use.
  10. It's now an approved app, but has to be installed via EURC request or if you know someone who can admin push it to you. Me too, but at end of 2012 they bastardized it like they do all the apps. Now my home page always defaults to Chase instead of Google and can not be changed.
  11. That's cuz the emblem's missing from the hood. Kinda make's it hard to tell...
  12. Good thing is we have to wait another 5000+ years until it happens again!
  13. According to the Mayans it wasn't the end of the world but the beginning of a new era. Same as current times 365 day calendar and New Years Eve/Day. The media hyped it up as well as the uneducated.
  14. This is my current set-up... http://i62.photobucket.com/albums/h109/nismopc/IMAG0342.jpg The kids and their friends play them way more than I do. Did it to just say I can. The one in the middle and the one on the right are both MAME emus in modified arcade cabinets, the left one is actual Bad Dudes vs. Dragon Ninja
  15. LMAO at running man 1:50 marker :dumb: Damn link
  16. Definitely not a OEM/factory set-up. Appears to be a auxiliary input by PO. Try this. Flip that switch to on position, then push the SAT button and see if the display shows something other than "NO SAT", something like "AUX-01". If it does, you now know how to use it as a auxiliary input for iPod/smartphone/MP3.
  17. Those Aussie's make anything and everything fast...
  18. Oops... ...missed a few things... ...try this and let me know the results. SELECT A.[solarSystemName] ,A.[solarSystemID] ,A.[constellationID] ,A.[x] ,A.[y] ,A.[z] ,A.[security] ,SUM(CASE WHEN B.[GroupID] = 7 THEN 1 ELSE 0 END) as [Num_Planets] ,SUM(CASE WHEN B.[GroupID] = 8 THEN 1 ELSE 0 END) as [Num_Moons] ,SUM(CASE WHEN B.[GroupID] = 9 THEN 1 ELSE 0 END) as [Num_Belts] ,0 as [Zero_1] ,0 as [Zero_2] FROM [dbo].[mapSolarSystems] A JOIN [dbo].[mapDenormalize] B ON A.[solarSystemID] = B.[solarSystemID] GROUP BY A.[solarSystemName] ,A.[solarSystemID] ,A.[constellationID] ,A.[x] ,A.[y] ,A.[z] ,A.[security] GO
  19. Without having SQL and database in front of me, can't verify this, but I "think" this should do it as long as all the columns from table A are distinct to the System Id... SELECT A.[solarSystemName] ,A.[solarSystemID] ,A.[constellationID] ,A.[x] ,A.[y] ,A.[z] ,A.[security] ,SUM(CASE WHEN B.[Planets] > 0 THEN 1 ELSE 0 END) as [Num_Planets] ,SUM(CASE WHEN B.[Moons] > 0 THEN 1 ELSE 0 END) as [Num_Moons] ,SUM(CASE WHEN B.[belts] > 0 THEN 1 ELSE 0 END) as [Num_Belts] ,0 as [Zero_1] ,0 as [Zero_2] FROM [dbo].[mapSolarSystems] A JOIN [dbo].[OtherTableName] B ON A.[solarSystemID] = B.[solarSystemID] GROUP BY A.[solarSystemName] ,A.[solarSystemID] ,A.[constellationID] ,A.[x] ,A.[y] ,A.[z] GO
  20. http://p.twimg.com/A76Fe_1CEAAsxHu.jpg
  21. Bimbo is considering the purchase of Twinkies. They will be back, and more than likely identical recipe... ...as will most of the others.
×
×
  • Create New...