Tags » Year 2

MORE PLANTS!

More plants, but this time in a plant pot. Created in the same way as the previous bushes. Again these are for placement around the level and will make the environment feel more lived in. 21 more words

Year 2

Pulling the Tag Tables Together

Going for a design that allowed multiple groups of tags to be defined made the SQL tricky, but it’s now working:

SELECT
	tbl1.tag_id, tag.tag_prompt, tag_value
FROM (
	SELECT
		tag_group_member.tag_id
	FROM
		tag_group_member
	WHERE
		tag_group_id IN (SELECT tag_group_id FROM element WHERE element_id=3)
	) AS tbl1
	LEFT OUTER JOIN
	(
		SELECT
			tag_value.tag_id, tag_value.tag_value
		FROM
			tag_value
		WHERE
			tag_value.element_id=3) AS tbl2
		ON tbl1.tag_id = tbl2.tag_id
	INNER JOIN tag
		ON tag.tag_id = tbl1.tag_id
… 10 more words
Year 2 OOP Project

Generic Plants

Another quick plant I made using planes. As you can see from the image the planes are subdivided and arched slightly, then using a diffuse and alpha map give the result of leaves. 38 more words

Year 2

Its A TREE!

Today I decided to have a proper look at the TreeGen Script which can be found HERE. Its a great tool for creating trees very quickly. 88 more words

Year 2

Signal Flags

A quick asset production for the game world. These can be placed is different location to help populate the world and make it feel lived in. 54 more words

Year 2

The Platforms of Paragon.

During the second semester of our paragon project I took over the task of creating the platforms for the station. Some had been previously created by… 320 more words

Year 2