SELECT SecLink FROM Security WHERE SecLink=51 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=52 AND UserLink=;OUTPUT NIL
eq '*Other - Enter Below'>INSERT INTO ContainerCategory (Name) VALUES ();FINISH
eq '*Other - Enter Below'>
SELECT MapStartDate OldMSD,MapEndDate OldMED FROM MapImage WHERE MapImageID=;OUTPUT NIL
UPDATE MapImage SET MapStartDate=,MapEndDate=,CategoryLink=,MapGroup=,MapName=,MapDescription=,Source=,Width=,Height=,LLBoundary=,LLBoundFreeze=,LLAdjust=,TileSetURL=,LMBy=,LastModified=Now() WHERE MapImageID=;OUTPUT NIL - Saved Changes
INSERT INTO MapImage (MapStartDate,MapEndDate,CategoryLink,MapGroup,MapName,MapDescription,Source,Width,Height,LLBoundary,LLAdjust,TileSetURL,FirstBy,FirstEnter,LMBy,LastModified) VALUES (,,,,,,,,,,,,,Now(),,Now());OUTPUT NIL
- Saved New Map
ne ''>
/mapimages/,FILE_DATA>
INSERT INTO MapLocationAttach (MapImageLink,MapLocationLink) VALUES (,);FINISH
UPDATE MapInset SET Name=Name,SQL>,LatMin=LatMin,SQL>,LatMax=LatMax,SQL>,LngMin=LngMin,SQL>,LngMax=LngMax,SQL>,Priority=Priority,F%d> WHERE MapInsetID=;FINISH
SELECT * FROM MapInset WHERE MapImageLink= order by Priority;OUTPUT SaveZoomArea
INSERT INTO MapInset (MapImageLink,Name,LatMin,LatMax,LngMin,LngMax,Priority) VALUES (,Name,SQL>,LatMin,SQL>,LatMax,SQL>,LngMin,SQL>,LngMax,SQL>,Priority,F%d>);FINISH
Pickup
INSERT INTO Cart (Pickup,UserLink,ItemType,ItemID) VALUES ('Y',,'MapLocation',);FINISH
SELECT MapLocationLink as MLID FROM MapLocationAttach WHERE MapImageLink=;OUTPUT
Detach
DELETE FROM MapLocationAttach WHERE MapImageLink= AND MapLocationLink= LIMIT 1;FINISH
SELECT MapLocationLink as MLID FROM MapLocationAttach WHERE MapImageLink=;OUTPUT
Attach
INSERT INTO MapLocationAttach (MapImageLink,MapLocationLink) VALUES (,);FINISH
DELETE FROM Cart WHERE Pickup='Y' AND UserLink= AND ItemType='MapLocation' AND ItemID=;FINISH
SELECT * FROM Cart WHERE UserLink= AND ItemType='MapLocation' AND Pickup='Y';OUTPUT
Empty
DELETE FROM Cart WHERE Pickup='Y' AND UserLink= AND ItemType='MapLocation' AND ItemID=;FINISH
SELECT * FROM Cart WHERE UserLink= AND ItemType='MapLocation' AND Pickup='Y';OUTPUT
Drop
UPDATE MapLocation SET MapImageLink= WHERE MapLocationID=;FINISH
DELETE FROM Cart WHERE Pickup='Y' AND UserLink= AND ItemType='MapLocation' AND ItemID=;FINISH
SELECT * FROM Cart WHERE UserLink= AND ItemType='MapLocation' AND Pickup='Y';OUTPUT
SELECT * FROM MapImage WHERE MapImageID=;OUTPUT NIL
SELECT Nym First_Nym FROM User WHERE UserID=;OUTPUT NIL
SELECT Nym Last_Nym FROM User WHERE UserID=;OUTPUT NIL
MapImage
$url='https://www.ourcampaigns.com/MapImage2JSON.php?MapImageID='.int($in{MapImageLink});
my $curl=`curl -k $url`
print $curl;
SELECT MapLocationID MLID,ContainerLink PCL,Name CNam, c.ParentLink as CPar,CAST(l.StartDate as Date) as StartDate,CAST(l.EndDate as Date) as EndDate FROM MapLocationAttach as a JOIN MapLocation as l ON a.MapImageLink= AND l.MapLocationID=a.MapLocationLink JOIN Container as c ON ContainerID=ContainerLink ORDER BY Name,l.StartDate,l.MapLocationID;
$tfile=$in{BFDIR}.'/PolyCoords/Google'.int($in{MapImageID}).'.js';
($dev,$ino,$mode,$nlink,$uid,$gid,$rdev,$in{LLFSize},$atime,$mtime,$ctime,$blksize,$blocks)= stat($tfile);
|