Can I Buld a floorplan from data in table

[KP7769]

I am trying to build a floor plan dynamically. My database can tell me what picture to use and where to put it(X and Y Coordinates) but I can't seem to find a way to make this happen in Flash. I am selling booths for an auction and need booth availability updated automatically by the data. So if a booth is sold the next refresh or load will show the booth as red. There can be hundreds of these booths. Here is what I want to the finsh product to look like. Each square is a booth and a separate jpg or gif.

http://www.taasports.org/flrplan.htm

Any help would be great. Thanks

 

[billwatson]

this might give you a nudge in the right direction

for(i=0;i<totalboxes;i++){
_root.createEmptyMovieClip(i, 100+i);
// perhaps some sort of conditional statement here to control color of boxes drawn
_root.lineStyle(2, 0xCCCCCC, 100);
_root.beginFill(0xCC6633, 100);
//alter this for size of boxes and position on stage
_root.moveTo(-12, -12);
_root.lineTo(12, -12);
_root.lineTo(12, 12);
_root.lineTo(-12, 12);
_root.endFill(-12, -12);
_root._x=((130)+(i*35));
_root._y=20;
}
}

as i said this is not a full solution but hopefully will get you started

 

[KP7769]

Thanks,
I think that will get me going. Just two questions. Does this code go in the onload and can I programmatically add a click event to each of these squares? I need to be able to send an email if a person clicks on a square to reserve it or buy it. I am not sure that Flash is the right program for this which is why I am asking all this before I start it. I beleive I can do all this in ASP but I already know it will be large. I am hoping Flash will be easier and faster performance.
Thanks again I really appreciate the information.

 

[BigBadDave]

I have made an xml based plot system, hows this:

http://www.byngdesigns.co.uk/tek-tips/plots.swf

http://www.byngdesigns.co.uk/tek-tips/plots.fla

http://www.byngdesigns.co.uk/tek-tips/plots.xml

The main function:

// stop timeline
stop ();
// declare vars
var total = 5;
var count = 0;
// set clr function
function setClr (plot, clr) {
	_root[plot].pClr.setRGB(clr);
}
// load xml
var pXML = new XML();
pXML.onLoad = convertXML;
pXML.load("plots.xml");
function convertXML () {
	if (pXML.loaded) {
		for (var i = 0; i<pXML.childNodes[2].childNodes.length; i++) {
			state = pXML.childNodes[2].childNodes[i].attributes.state;
			if (state != null) {
				count++;
				if (state == &quot;sold&quot;) {
					clr = 0xff0000;
				} else if (state == &quot;res&quot;) {
					clr = 0x0000ff;
				} else {
					clr = 0xffffff;
				}
				setClr(&quot;plot&quot;+count, clr);
			}
		}
	} else {
		convertXML();
	}
}

Regards
David Byng

http://www.byngdesigns.co.uk

davidbyng@hotmail.com

 

[billwatson]

you can regard movieclips as buttons in mx so on release works with clips

adding this to my code above
_root.onRelease = function() {
geturl(mailto: etc etc );
}

all code goes on main timeline

 

[billwatson]

oops..should be
_root.onRelease = function() {
geturl(mailto: etc etc );
}

 

[KP7769]

Thansk so much Guys. It is starting to make sense now. I think I can get what I want from this.