The Mobile Application Security Verification Standard (MASVS) is a standard for mobile app security
استاندارد امنیتی MASVS شامل موضوعات زیر میباشد :
<?xml version="1.0" encoding="utf-8"?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <url> <loc>Url Page 1</loc> <lastmod>2014-02-20</lastmod> <changefreq>always</changefreq> <priority>1</priority> </url> <url> <loc>Url Page 2</loc> <lastmod>2014-02-20</lastmod> <changefreq>always</changefreq> <priority>1</priority> </url> </urlset>
public void UpdateSiteMap(string Addr,string NewOpr)
if (NewOpr != "add")
{
XmlElement xmlElement = xmlDoc.DocumentElement;
if (xmlElement.ChildNodes != null)
{
foreach (XmlElement myElement in xmlDoc.DocumentElement)
{
if (myElement.ChildNodes[0].InnerText == Addr)
{
if (NewOpr != "delete")
myElement.ChildNodes[1].InnerText = DateTime.Now.ToString("yyyy-MM-dd");
else
myElement.ParentNode.RemoveChild(myElement);
break;
}
}
}
} else
{
string ns="http://www.sitemaps.org/schemas/sitemap/0.9";
XmlNode url = xmlDoc.CreateNode(XmlNodeType.Element, "url",ns );
XmlNode loc = xmlDoc.CreateNode(XmlNodeType.Element, "loc", ns);
XmlNode lastmod = xmlDoc.CreateNode(XmlNodeType.Element, "lastmod", ns);
XmlNode changefreq = xmlDoc.CreateNode(XmlNodeType.Element, "changefreq", ns);
XmlNode priority = xmlDoc.CreateNode(XmlNodeType.Element, "priority", ns);
loc.InnerText = Addr;
lastmod.InnerText = DateTime.Now.ToString("yyyy-MM-dd");
changefreq.InnerText = "always";
priority.InnerText = "1";
url.AppendChild(loc);
url.AppendChild(lastmod);
url.AppendChild(changefreq);
url.AppendChild(priority);
xmlDoc.DocumentElement.AppendChild(url);
} //
Add Info In Table
//
updateSiteMap updateSiteMap = new updateSiteMap();
updateSiteMap.UpdateSiteMap("Url Page", "add"); updateSiteMap updateSiteMap = new updateSiteMap();
updateSiteMap.UpdateSiteMap("Url Page", "edit"); updateSiteMap updateSiteMap = new updateSiteMap();
updateSiteMap.UpdateSiteMap("Url Page", "delete"); CREATE TABLE xmlTest
(
id INT IDENTITY PRIMARY KEY,
doc XML
)
GO
INSERT xmlTest VALUES('<Person name="Vahid" />')
INSERT xmlTest VALUES('<Person name="Farid" />')
INSERT xmlTest VALUES('<Person name="Mehdi" /><Person name="Hamid" />')
GO SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
')
FROM xmlTest <li>Vahid has id = 1</li>
SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
')
FROM xmlTest
WHERE doc.exist('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
')=1 SELECT * FROM
(
(SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has id = {sql:column("xmlTest.id")}</li>
') AS col1
FROM xmlTest)
) A
WHERE CONVERT(VARCHAR(8000), col1)<>'' DECLARE @number INT = 1
SELECT doc.query('
for $p in //Person
where $p/@name="Vahid"
return <li>{data($p/@name)} has number = {sql:variable("@number")}</li>
')
FROM xmlTest SELECT doc.query('/Person') FROM xmlTest DECLARE @doc XML
SET @doc = (SELECT * FROM xmlTest FOR XML AUTO, ELEMENTS)
SELECT @doc.query('/xmlTest/doc/Person') DECLARE @doc XML =' <people> <person><name>Vahid</name></person> <person><name id="2">Farid</name></person> <person><name>Mehdi</name></person> <person><name>Hooshang</name><name id="1">Hooshi</name></person> <person></person> </people> '
SELECT @doc.value('/people/person/name', 'varchar(50)') SELECT @doc.value('(/people/person/name)[1]', 'varchar(50)') SELECT @doc.query('/people/person/name') <name>Vahid</name> <name id="2">Farid</name> <name>Mehdi</name> <name>Hooshang</name> <name id="1">Hooshi</name>
SELECT
tab.col.value('text()[1]', 'varchar(50)') AS name,
tab.col.query('.'),
tab.col.query('..')
from @doc.nodes('/people/person/name') AS tab(col) tab.col.query('.'), SELECT
tab.col.value('.', 'varchar(50)') AS name,
tab.col.query('data(.)'),
tab.col.query('.'),
tab.col.query('..')
from @doc.nodes('/people/person/name') AS tab(col) SELECT
tab.col.value('name[.="Farid"][1]', 'varchar(50)') AS name,
tab.col.value('name[.="Farid"][1]/@id', 'varchar(50)') AS id,
tab.col.query('.')
from @doc.nodes('/people/person[name="Farid"]') AS tab(col) DECLARE @tblXML TABLE (
id INT IDENTITY PRIMARY KEY,
doc XML
)
INSERT @tblXML VALUES('<person name="Vahid" />')
INSERT @tblXML VALUES('<person name="Farid" />')
INSERT @tblXML VALUES('<person />')
INSERT @tblXML VALUES(NULL)
SELECT
id,
doc.value('(/person/@name)[1]', 'varchar(50)') AS name
FROM @tblXML CREATE PROCEDURE LookForPhysicalOps (@op VARCHAR(30))
AS
SELECT sql.text, qs.EXECUTION_COUNT, qs.*, p.*
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(sql_handle) sql
CROSS APPLY sys.dm_exec_query_plan(plan_handle) p
WHERE query_plan.exist('
declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/showplan";
/ShowPlanXML/BatchSequence/Batch/Statements//RelOp/@PhysicalOp[. = sql:variable("@op")]
') = 1
GO
EXECUTE LookForPhysicalOps 'Table Scan'
EXECUTE LookForPhysicalOps 'Clustered Index Scan'
EXECUTE LookForPhysicalOps 'Hash Match' WITH XMLNAMESPACES(DEFAULT N'http://schemas.microsoft.com/sqlserver/2004/07/showplan') SELECT RelOp.op.value(N'../../@NodeId', N'int') AS ParentOperationID, RelOp.op.value(N'@NodeId', N'int') AS OperationID, RelOp.op.value(N'@PhysicalOp', N'varchar(50)') AS PhysicalOperator, RelOp.op.value(N'@LogicalOp', N'varchar(50)') AS LogicalOperator, RelOp.op.value(N'@EstimatedTotalSubtreeCost ', N'float') AS EstimatedCost, RelOp.op.value(N'@EstimateIO', N'float') AS EstimatedIO, RelOp.op.value(N'@EstimateCPU', N'float') AS EstimatedCPU, RelOp.op.value(N'@EstimateRows', N'float') AS EstimatedRows, cp.plan_handle AS PlanHandle, st.TEXT AS QueryText, qp.query_plan AS QueryPlan, cp.cacheobjtype AS CacheObjectType, cp.objtype AS ObjectType FROM sys.dm_exec_cached_plans cp CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp CROSS APPLY qp.query_plan.nodes(N'//RelOp') RelOp(op)
DECLARE @doc XML = ' <Invoice> <InvoiceId>100</InvoiceId> <CustomerName>Vahid</CustomerName> <LineItems> <LineItem> <Sku>134</Sku> <Quantity>10</Quantity> <Description>Item 1</Description> <UnitPrice>9.5</UnitPrice> </LineItem> <LineItem> <Sku>150</Sku> <Quantity>5</Quantity> <Description>Item 2</Description> <UnitPrice>1.5</UnitPrice> </LineItem> </LineItems> </Invoice> '
SET @doc.modify('
insert <InvoiceInfo><InvoiceDate>2014-02-10</InvoiceDate></InvoiceInfo>
after /Invoice[1]/CustomerName[1]
')
SELECT @doc <Invoice>
<InvoiceId>100</InvoiceId>
<CustomerName>Vahid</CustomerName>
<InvoiceInfo>
<InvoiceDate>2014-02-10</InvoiceDate>
</InvoiceInfo>
<LineItems>
... SET @x.modify('insert sql:variable("@x") into /doc[1]') The argument 1 of the XML data type method "modify" must be a string literal.
SET @doc.modify('
insert attribute status{"backorder"}
into /Invoice[1]
')
SELECT @doc <Invoice status="backorder"> <InvoiceId>100</InvoiceId> ....
SET @doc.modify('delete /Invoice/LineItems/LineItem')
SELECT @doc <Invoice status="backorder">
<InvoiceId>100</InvoiceId>
<CustomerName>Vahid</CustomerName>
<InvoiceInfo>
<InvoiceDate>2014-02-10</InvoiceDate>
</InvoiceInfo>
<LineItems />
</Invoice> SET @doc.modify('replace value of
/Invoice[1]/CustomerName[1]/text()[1]
with "Farid"
')
SELECT @doc <Invoice status="backorder">
<InvoiceId>100</InvoiceId>
<CustomerName>Farid</CustomerName>
<InvoiceInfo>
<InvoiceDate>2014-02-10</InvoiceDate>
</InvoiceInfo>
<LineItems />
</Invoice> The target of 'replace value of' must be a non-metadata attribute or an element with simple typed content.
DECLARE @tblTest AS TABLE (xmlField XML)
INSERT INTO @tblTest(xmlField)
VALUES
(
'<Sample>
<Node1>Value1</Node1>
<Node2>Value2</Node2>
<Node3/>
</Sample>'
)
DECLARE @newValue VARCHAR(50) = 'NewValue'
UPDATE @tblTest
SET xmlField.modify(
'insert text{sql:variable("@newValue")} into
(/Sample/Node3)[1] [not(text())]'
)
SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest UPDATE @tblTest
SET xmlField.modify(
'replace value of (/Sample/Node3/text())[1]
with sql:variable("@newValue")'
) PM> Install-Package OpenCvSharp-AnyCPU
PM> Install-Package OpenCvSharp-WithoutDll
using OpenCvSharp;
namespace OpenCVSharpSample01
{
class Program
{
static void Main(string[] args)
{
var img = Cv.CreateImage(new CvSize(128, 128), BitDepth.U8, 1);
for (var y = 0; y < img.Height; y++)
{
for (var x = 0; x < img.Width; x++)
{
Cv.Set2D(img, y, x, x + y);
}
}
Cv.NamedWindow("window");
Cv.ShowImage("window", img);
Cv.WaitKey();
Cv.DestroyWindow("window");
Cv.ReleaseImage(img);
}
}
} 
{
"version": "0.1.0",
// The command is tsc. Assumes that tsc has been installed using npm install -g typescript
"command": "tsc",
// The command is a shell script
"isShellCommand": true,
// Show the output window only if unrecognized errors occur.
"showOutput": "silent",
// args is the HelloWorld program to compile.
"args": ["HelloWorld.ts"],
// use the standard tsc problem matcher to find compile problems
// in the output.
"problemMatcher": "$tsc"
} "args": [
"--target", "ES5",
"--outdir", "js",
"--sourceMap",
"--watch",
"test.ts"
], 
error TS5023: Unknown option 'watch' Use the '--help' flag to see options.
15:33:52 - Compilation complete. Watching for file changes.
