/modules/images/ajax/get_screenshot.php

<?php
	include('../../../config.php');
	include('../../../mysql.php');
?>
<link rel="stylesheet" type="text/css" href="<?php echo $basehref; ?>modules/images/js/tagging.css" />
<script type="text/javascript" src="<?php echo $basehref; ?>modules/images/js/tagging.js"></script>
<?php
	$id = $_GET['id'];
	if(isset($link) && isset($id)) {
		if ($link && is_numeric($id)) {
			$sql = "SELECT screenshots.`id` AS `id`,
				screenshots.`screenshot_name` AS screenshot_name,
				screenshots.`screenshot_describe` AS screenshot_describe,
				screenshots.`screenshot_file` AS screenshot_file,
				screenshots.`screenshot_orig` AS screenshot_orig,
				screenshots.`screenshot_filesize` AS screenshot_filesize,
				DATE_FORMAT(screenshots.`created`, '%b %e %Y, %l:%i %p') AS fcreated,
				DATE_FORMAT(screenshots.`modified`, '%b %e %Y, %l:%i %p') AS fmodified,
				screenshots.`created` AS `created`,
				screenshots.`modified` AS `modified`
				FROM screenshots
				WHERE screenshots.`id` = '" . $id . "'";
		}
		$fetch = mysql_query($sql);
		while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
			$id = $row['id'];
			$screenshot_name = $row['screenshot_name'];
			$screenshot_describe = $row['screenshot_describe'];
			$screenshot_file = $row['screenshot_file'];
			$screenshot_orig = $row['screenshot_orig'];
			$screenshot_filesize = $row['screenshot_filesize'];
			$fcreated = $row['fcreated'];
			$fmodified = $row['fmodified'];
			$modified = $row['modified'];
			$created = $row['created'];
			?>
			<div id="main_panel">
				 <div style="margin: 0;">
					<div id="image_panel" >
						<img src="/modules/images/uploads/<?php echo $screenshot_file; ?>" id="imageMap" class="<? echo $id; ?>" />
						<div id="mapper" ><img src="/modules/images/js/save.png" class="tagbtn" onclick="openDialog()" /></div>
						<div id="planetmap"><?php
							$tags_sql = "SELECT
								`id`,
								`screenshot_id`,
								`x_coord`,
								`y_coord`,
								`width`,
								`height`,
								`tag_text`
								FROM screenshots_pos
								WHERE screenshot_id='$id'";
							$tags_q = mysql_query($tags_sql);
							while($i = mysql_fetch_object($tags_q)) {
								$tag_id = $i->id;
								$x_coord = $i->x_coord;
								$y_coord = $i->y_coord;
								$width = $i->width;
								$height = $i->height;
								$tag_text = $i->tag_text;
								?>
								<div id="<?php echo $tag_id; ?>" class="tagged" style="width:<? echo $width; ?>px;height:<? echo $height; ?>px;left:<? echo $x_coord; ?>px;top:<? echo $y_coord; ?>px;" >
									<div class="tagged_box" style="width:<?php echo $width; ?>px;height:<? echo $height; ?>px;"></div>
									<div class="tagged_title" style="top:<?php echo ($height+5); ?>px;display:none;" ><? echo $tag_text; ?></div>
								</div>
								<?php
							}
						?></div>
						<div id="form_panel">
<!--
							<div class="row">
								<div class="label">Message</div><div class="field"><textarea id="title" cols="32" rows="6" maxlength="2400"></textarea></div>
							</div>
							<div class="row">
								<div class="label"></div>
								<div class="field">
									<input type="button" value="Add Tag" onclick="addTag()" />
								</div>
							</div>
 -->
							<div class="control-group">
								<label class="control-label" for="title">Message</label>
								<div class="controls">
									<textarea id="title" rows="6" maxlength="2400"></textarea>
								</div>
							</div>
							<div class="control-group">
								<div class="controls">
									<input type="button" value="Add Tag" onclick="addTag()" />
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
			<?php
		}
	}
?>