Tuesday, June 18, 2013

3D JavaScript is weird...

3D JavaScript is weird...

An object can ONLY be collided with if it's in the scene, even if you're only using the object collection as collision reference.
The problem is that an object can only be collided with if it's of type geometry , which normal .obj's aren't.

Now, for the fun part!

Rendering a textured object is significantly faster than rendering an object with a mesh, so, whilst you could just use textured mesh's and render those, this is slow as heck.

And how do you get past this dilemma... ?

Add both the object AND the mesh to the scene, and hide the mesh's. Since they're technically there, they can still be collided with, and since they're invisible, they don't use rendering cycles ;D

Result: 60 FPS with full collision ♥

Friday, May 17, 2013

How to block ads from websites

As you probably see below this post (If it's the latest) and on the right of the page under the "Site History", I have added some ads.

But fret not - For this post shall include how to remove ads such as these! \o/

1.) Download and install Adblock for Firefox, Chrome, or Opera - If you're using IE... Download Chrome ^_^
2.) Subscribe to the recommended filter list - Should be called 'EasyList'
3.) Enjoy an ad-free experience :D
4.) Example With Adblock Installed: Click Me :D
Note: Some of the items in the image (Pencil, Spanner, Etc) only appear for me since I own the page ^_^

Monday, May 6, 2013

Create a SQL Database using an existing MDF File

If you have an MDF file, and you need to create a SQL Database from it using code, do the following:
USE [master]
GO
CREATE DATABASE [insert_database_name_here] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\fileNameHere.mdf' ),
FOR ATTACH ;
GO

Thursday, March 14, 2013

SharePoint 2010 CAML Query Nuance In C#

Whilst playing around in SharePoint with pulling data from lists (Which requires a wonderfully syntactically obscene language known as CAML Query), I found that my query simply refused to filter out data.

string camlQuery = @"
   <Query>   
      <Where>
         <Eq>
            <FieldRef Name = 'Title' />
            <Value Type='Text'>" + chosenIndex + @"</Value>
         </Eq>
      </Where>
   </Query>";
SPListItemCollection items = myList.GetItems(camlQuery);

Seems simple, enough - Right?

Not quite...

Turns out, if you include the <Query> tags in your CAML Query, the entire thing gets blatantly ignored! No errors - It just selects everything o_O

To fix this problem, simply remove the <Query></Query> tags from your statement, and everything will work as planned...

Note: Thanks to manoli.net for the formatting code :D