/modules/images/ajax/get_screenshot.php
https://bitbucket.org/websightdesigns/project-manager · PHP · 99 lines · 99 code · 0 blank · 0 comment · 5 complexity · d376f7c5060e6500c5a286398e9ae935 MD5 · raw file
- <?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
- }
- }
- ?>