DevAndy | Right Hand of the Head of Development

Handlebars render Funktion wie bei Mustache

Handlebars.registerHelper('select', function (value, options) {
    // Create a select element 
    var select = document.createElement('select');

    // Populate it with the option HTML
    select.innerHTML = options.fn(this);

    // Set the value
    select.value = value;

    // Find the selected node, if it exists, add the selected attribute to it
    if (select.children[select.selectedIndex])
        select.children[select.selectedIndex].setAttribute('selected', 'selected');

    return select.innerHTML;
});

Handlebars.render = Handlebars.render || function(tpl, data) {
    data = data || {};
    var compiled = Handlebars.render.cache[tpl];
    if (!compiled) {
        // Uncached template
        compiled = Handlebars.compile(tpl);
        Handlebars.render.cache[tpl] = compiled;
    }
    return compiled(data);
};
Handlebars.render.cache = {};

Handlebars.registerHelper('select', function (value, options) {

// Create a select element

var select = document.createElement('select');

// Populate it with the option HTML

select.innerHTML = options.fn(this);

// Set the value

select.value = value;

// Find the selected node, if it exists, add the selected attribute to it

if (select.children[select.selectedIndex])

select.children[select.selectedIndex].setAttribute('selected', 'selected');

return select.innerHTML;

});

Handlebars.render = Handlebars.render || function(tpl, data) {

data = data || {};

var compiled = Handlebars.render.cache[tpl];

if (!compiled) {

// Uncached template

compiled = Handlebars.compile(tpl);

Handlebars.render.cache[tpl] = compiled;

}

return compiled(data);

};

Handlebars.render.cache = {};

Posted on 12. Juni 2019 by Andreas in JavaScript

Eigene Adblock uBlock Filterliste

Surface 2019-05-19

! 3.5.2019 https://de.malwarebytes.com
de.malwarebytes.com##.ce-banner

! 3.5.2019 https://www.kaspersky.de
www.kaspersky.de##.bottom.dark.transparent.notification-bar

! 3.5.2019 https://help.kaspersky.com
help.kaspersky.com##.js_cookie_policy.cookie-policy

! 4.5.2019 https://notepad-plus-plus.org
notepad-plus-plus.org##.cc_container--open.cc_container.cc_banner

! 4.5.2019 https://slyxi.com
slyxi.com###yandex_rtb_R-A-388882-3 > .adb-def

! 6.5.2019 https://www.mydealz.de
www.mydealz.de##.vAlign--all-b.tGrid-cell

! 9.5.2019 https://www.fcbarcelona.com
www.fcbarcelona.com##.cookie-notice--show.js-cookie-notice.cookie-notice--hidden.cookie-notice

! 9.5.2019 https://www.kenwoodworld.com
www.kenwoodworld.com##.bannerpadding

! 9.5.2019 https://www.internetworld.de
www.internetworld.de##.cc-color-override--227966932.cc-top.cc-theme-block.cc-type-info.cc-banner.cc-window

! 9.5.2019 https://www.ebay.de
www.ebay.de###gdpr-banner

! 12.5.2019 https://selbermachen.de
selbermachen.de###sliding-popup > div
selbermachen.de###zs_next_article

! 12.5.2019 https://www.obi.de
www.obi.de##.cookiepolicy__container

! 12.5.2019 https://www.sport.de
www.sport.de##.cc-color-override-896100485.cc-bottom.cc-theme-edgeless.cc-type-info.cc-banner.cc-window

! 12.5.2019 https://www.youtube.com
||i.ytimg.com/vi/fMnq5v8yZp4/hqdefault.jpg?sqp=-oaymwEZCNACELwBSFXyq4qpAwsIARUAAIhCGAFwAQ==&rs=AOn4CLCjYTrHeYEdlRyirmTM-tqQfhTokA$image

! 13.5.2019 https://www.beitsarshalom.org
www.beitsarshalom.org##.cookie-notice-container

! 14.5.2019 https://www.ikea.com
www.ikea.com##.cookie-info__panel--show.js-cookie-info__panel.cookie-info__panel

! 14.5.2019 https://www.sitepoint.com
www.sitepoint.com##.qc-cmp-ui-content
www.sitepoint.com###qcCmpUi
www.sitepoint.com##.qc-cmp-showing.qc-cmp-ui-container

! 18.5.2019 https://www.dasheimwerkerforum.de
www.dasheimwerkerforum.de##.noticeContent.baseHtml

! 19.5.2019 https://www.wohntec.de
www.wohntec.de##.page-wrap--cookie-permission
www.wohntec.de###BadgeContent_db8d3657bdbe440c985ae127463eaad4
www.wohntec.de##.etrusted-tb-footer__content
www.wohntec.de###BottomSlantBadge_db8d3657bdbe440c985ae127463eaad4 > svg
www.wohntec.de###BadgeFooter_db8d3657bdbe440c985ae127463eaad4

! 3.5.2019 https://de.malwarebytes.com

de.malwarebytes.com##.ce-banner

! 3.5.2019 https://www.kaspersky.de

www.kaspersky.de##.bottom.dark.transparent.notification-bar

! 3.5.2019 https://help.kaspersky.com

help.kaspersky.com##.js_cookie_policy.cookie-policy

! 4.5.2019 https://notepad-plus-plus.org

notepad-plus-plus.org##.cc_container--open.cc_container.cc_banner

! 4.5.2019 https://slyxi.com

slyxi.com###yandex_rtb_R-A-388882-3 > .adb-def

! 6.5.2019 https://www.mydealz.de

www.mydealz.de##.vAlign--all-b.tGrid-cell

! 9.5.2019 https://www.fcbarcelona.com

www.fcbarcelona.com##.cookie-notice--show.js-cookie-notice.cookie-notice--hidden.cookie-notice

! 9.5.2019 https://www.kenwoodworld.com

www.kenwoodworld.com##.bannerpadding

! 9.5.2019 https://www.internetworld.de

www.internetworld.de##.cc-color-override--227966932.cc-top.cc-theme-block.cc-type-info.cc-banner.cc-window

! 9.5.2019 https://www.ebay.de

www.ebay.de###gdpr-banner

! 12.5.2019 https://selbermachen.de

selbermachen.de###sliding-popup > div

selbermachen.de###zs_next_article

! 12.5.2019 https://www.obi.de

www.obi.de##.cookiepolicy__container

! 12.5.2019 https://www.sport.de

www.sport.de##.cc-color-override-896100485.cc-bottom.cc-theme-edgeless.cc-type-info.cc-banner.cc-window

! 12.5.2019 https://www.youtube.com

||i.ytimg.com/vi/fMnq5v8yZp4/hqdefault.jpg?sqp=-oaymwEZCNACELwBSFXyq4qpAwsIARUAAIhCGAFwAQ==&rs=AOn4CLCjYTrHeYEdlRyirmTM-tqQfhTokA$image

! 13.5.2019 https://www.beitsarshalom.org

www.beitsarshalom.org##.cookie-notice-container

! 14.5.2019 https://www.ikea.com

www.ikea.com##.cookie-info__panel--show.js-cookie-info__panel.cookie-info__panel

! 14.5.2019 https://www.sitepoint.com

www.sitepoint.com##.qc-cmp-ui-content

www.sitepoint.com###qcCmpUi

www.sitepoint.com##.qc-cmp-showing.qc-cmp-ui-container

! 18.5.2019 https://www.dasheimwerkerforum.de

www.dasheimwerkerforum.de##.noticeContent.baseHtml

! 19.5.2019 https://www.wohntec.de

www.wohntec.de##.page-wrap--cookie-permission

www.wohntec.de###BadgeContent_db8d3657bdbe440c985ae127463eaad4

www.wohntec.de##.etrusted-tb-footer__content

www.wohntec.de###BottomSlantBadge_db8d3657bdbe440c985ae127463eaad4 > svg

www.wohntec.de###BadgeFooter_db8d3657bdbe440c985ae127463eaad4

Posted on 19. Mai 2019 by Andreas in Allgemein

Zahl als String mit 2 Nachkommastellen und mit Punkt als Tausendertrennzeichen

1.ToString("#,0.00") // 1,00
1000.ToString("#,0.00") // 1.000,00
1000.12 // 1.000,12
1000.126.ToString("#,0.00") // 1.000,13
0.12.ToString("#,0.00") // 0,12

1.ToString("#,0.00") // 1,00

1000.ToString("#,0.00") // 1.000,00

1000.12 // 1.000,12

1000.126.ToString("#,0.00") // 1.000,13

0.12.ToString("#,0.00") // 0,12

Posted on 8. Februar 2019 by Andreas in C#

Query für Rekursives löschen

DECLARE @ObjectID UNIQUEIDENTIFIER = '18AAF1E3-FBFC-4BB1-957A-60AD7EFC0276' 
 WITH RowsToDelete AS (
     SELECT [ID]
     FROM [Security].[PermissionLevel]
     WHERE [ID] = @ObjectID

UNION ALL

SELECT [Child].[ID]
FROM [Security].[PermissionLevel] Child 
INNER JOIN RowsToDelete Parent ON Parent.[ID] = [Child].[ParentID]
)
 DELETE FROM [Security].[PermissionLevel]
 FROM [Security].[PermissionLevel] h 
 INNER JOIN RowsToDelete d on h.ID = d.ID
 go

Posted on 29. Januar 2019 by Andreas in SQL

Tags: Rekursiv

Query um eine UI Tabelle darzustellen. Mit Filter pro Spalte, Sortierung pro Spalte, variablen Paging und Anzahl Zeilen ohne Filterung

DECLARE @Page INT = 1
, @PageSize INT = 50	
, @LanguageID INT = 46
, @ObjectID UNIQUEIDENTIFIER = '27461EA1-6EAC-47C5-8500-50A411C440D6'

, @Sort_Key BIT = NULL
, @Sort_Default BIT = NULL
, @Sort_Translation BIT = NULL

, @Filter_Key NVARCHAR(50) = NULL
, @Filter_Default NVARCHAR(255) = NULL
, @Filter_Translation NVARCHAR(MAX) = NULL 

SELECT 

 [KeyStore].[ID] AS [KeyStore_ID]
, [KeyStore].[Key] AS [KeyStore_Key]
, [KeyStore].[Default] AS [KeyStore_Default]
, [KeyStore].[ApplicationID] AS [KeyStore_ApplicationID]

, [Value].[ID] AS [Value_ID]
, [Value].[Value] AS [Trans]
, [Value].[LanguageID] AS [Value_LanguageID]

, [Language].[EnglishName] AS [Language_EnglishName] 
, TotalRows = COUNT(*) OVER() -- Return Total Rows. Without Offset

FROM [Translation].[KeyStore]
LEFT JOIN [Translation].[Value] [Value] ON [Value].[KeyStoreID] = [KeyStore].[ID]
INNER JOIN [Translation].[Language] [Language] ON [Language].[ID] = @LanguageID

WHERE 
([ApplicationID] = @ObjectID AND ([Value].LanguageID IS NULL OR [Value].LanguageID = @LanguageID))  	

-- Filter: Key
AND ( (@Filter_Key IS NULL OR @Filter_Key = '') OR ([KeyStore].[Key] LIKE REPLACE(@Filter_Key, '*', '%') OR (DIFFERENCE([KeyStore].[Key], @Filter_Key) > 3) ) )

-- Filter: Default
AND ( (@Filter_Default IS NULL OR @Filter_Default = '') OR ([KeyStore].[Default] LIKE REPLACE(@Filter_Default, '*', '%') OR (DIFFERENCE([KeyStore].[Default], @Filter_Default) > 3) ) )

-- Filter: Translation
AND ( (@Filter_Translation IS NULL OR @Filter_Translation = '') OR ([Value].[Value] LIKE REPLACE(@Filter_Translation, '*', '%') OR (DIFFERENCE([Value].[Value], @Filter_Translation) > 3) ) )
 
ORDER BY	
	-- Sort: Key		
	CASE @Sort_Key WHEN 0 THEN [KeyStore].[Key] END DESC, CASE @Sort_Key WHEN 1 THEN [KeyStore].[Key] END ASC
	-- Sort: Default
	, CASE @Sort_Default WHEN 0 THEN [KeyStore].[Default] END DESC, CASE @Sort_Default WHEN 1 THEN [KeyStore].[Default] END ASC
	-- Sort: Value
	, CASE @Sort_Translation WHEN 0 THEN [Value].[Value] END DESC, CASE @Sort_Translation WHEN 1 THEN [Value].[Value] END ASC
	-- Default Sort	
	, CASE WHEN @Sort_Key IS NULL AND @Sort_Default IS NULL AND @Sort_Translation IS NOT NULL THEN 	[KeyStore].[Key] END ASC
	-- Offset paging
	OFFSET ((@Page - 1) * @PageSize) ROWS FETCH NEXT @PageSize ROWS ONLY

DECLARE @Page INT = 1

, @PageSize INT = 50

, @LanguageID INT = 46

, @ObjectID UNIQUEIDENTIFIER = '27461EA1-6EAC-47C5-8500-50A411C440D6'

, @Sort_Key BIT = NULL

, @Sort_Default BIT = NULL

, @Sort_Translation BIT = NULL

, @Filter_Key NVARCHAR(50) = NULL

, @Filter_Default NVARCHAR(255) = NULL

, @Filter_Translation NVARCHAR(MAX) = NULL

SELECT

[KeyStore].[ID] AS [KeyStore_ID]

, [KeyStore].[Key] AS [KeyStore_Key]

, [KeyStore].[Default] AS [KeyStore_Default]

, [KeyStore].[ApplicationID] AS [KeyStore_ApplicationID]

, [Value].[ID] AS [Value_ID]

, [Value].[Value] AS [Trans]

, [Value].[LanguageID] AS [Value_LanguageID]

, [Language].[EnglishName] AS [Language_EnglishName]

, TotalRows = COUNT(*) OVER() -- Return Total Rows. Without Offset

FROM [Translation].[KeyStore]

LEFT JOIN [Translation].[Value] [Value] ON [Value].[KeyStoreID] = [KeyStore].[ID]

INNER JOIN [Translation].[Language] [Language] ON [Language].[ID] = @LanguageID

WHERE

([ApplicationID] = @ObjectID AND ([Value].LanguageID IS NULL OR [Value].LanguageID = @LanguageID))

-- Filter: Key

AND ( (@Filter_Key IS NULL OR @Filter_Key = '') OR ([KeyStore].[Key] LIKE REPLACE(@Filter_Key, '*', '%') OR (DIFFERENCE([KeyStore].[Key], @Filter_Key) > 3) ) )

-- Filter: Default

AND ( (@Filter_Default IS NULL OR @Filter_Default = '') OR ([KeyStore].[Default] LIKE REPLACE(@Filter_Default, '*', '%') OR (DIFFERENCE([KeyStore].[Default], @Filter_Default) > 3) ) )

-- Filter: Translation

AND ( (@Filter_Translation IS NULL OR @Filter_Translation = '') OR ([Value].[Value] LIKE REPLACE(@Filter_Translation, '*', '%') OR (DIFFERENCE([Value].[Value], @Filter_Translation) > 3) ) )

ORDER BY

-- Sort: Key

CASE @Sort_Key WHEN 0 THEN [KeyStore].[Key] END DESC, CASE @Sort_Key WHEN 1 THEN [KeyStore].[Key] END ASC

-- Sort: Default

, CASE @Sort_Default WHEN 0 THEN [KeyStore].[Default] END DESC, CASE @Sort_Default WHEN 1 THEN [KeyStore].[Default] END ASC

-- Sort: Value

, CASE @Sort_Translation WHEN 0 THEN [Value].[Value] END DESC, CASE @Sort_Translation WHEN 1 THEN [Value].[Value] END ASC

-- Default Sort

, CASE WHEN @Sort_Key IS NULL AND @Sort_Default IS NULL AND @Sort_Translation IS NOT NULL THEN [KeyStore].[Key] END ASC

-- Offset paging

OFFSET ((@Page - 1) * @PageSize) ROWS FETCH NEXT @PageSize ROWS ONLY

Posted on 5. November 2018 by Andreas in SQL

Spalteninformationen zu Prozeduren anzeigen

Der Profiler ist schon eine tolle Sache. Wenn man im SQL Management Studio eine Prozedur ausklappt, dann macht das Management Studio folgende Abfrage um die Informationen auszulesen:

SELECT
param.name AS [Name],
'Server[@Name=' + quotename(CAST(
        serverproperty(N'Servername')
       AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/StoredProcedure[@Name=' + quotename(sp.name,'''') + ' and @Schema=' + quotename(SCHEMA_NAME(sp.schema_id),'''') + ']' + '/Param[@Name=' + quotename(param.name,'''') + ']' AS [Urn],
usrt.name AS [DataType],
ISNULL(baset.name, N'') AS [SystemType],
CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND param.max_length <> -1 THEN param.max_length/2 ELSE param.max_length END AS int) AS [Length],
CAST(param.precision AS int) AS [NumericPrecision],
CAST(param.scale AS int) AS [NumericScale],
param.default_value AS [DefaultValue],
param.is_output AS [IsOutputParameter],
param.is_cursor_ref AS [IsCursorParameter],
sp.object_id AS [IDText],
db_name() AS [DatabaseName],
param.name AS [ParamName],
CAST(
 case 
    when sp.is_ms_shipped = 1 then 1
    when (
        select 
            major_id 
        from 
            sys.extended_properties 
        where 
            major_id = sp.object_id and 
            minor_id = 0 and 
            class = 1 and 
            name = N'microsoft_database_tools_support') 
        is not null then 1
    else 0
end          
             AS bit) AS [ParentSysObj],
1 AS [Number]
FROM
sys.all_objects AS sp
INNER JOIN sys.all_parameters AS param ON param.object_id=sp.object_id
LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = param.user_type_id
LEFT OUTER JOIN sys.types AS baset ON (baset.user_type_id = param.system_type_id and baset.user_type_id = baset.system_type_id) or ((baset.system_type_id = param.system_type_id) and (baset.user_type_id = param.user_type_id) and (baset.is_user_defined = 0) and (baset.is_assembly_type = 1))

SELECT

param.name AS [Name],

'Server[@Name=' + quotename(CAST(

serverproperty(N'Servername')

AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/StoredProcedure[@Name=' + quotename(sp.name,'''') + ' and @Schema=' + quotename(SCHEMA_NAME(sp.schema_id),'''') + ']' + '/Param[@Name=' + quotename(param.name,'''') + ']' AS [Urn],

usrt.name AS [DataType],

ISNULL(baset.name, N'') AS [SystemType],

CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND param.max_length <> -1 THEN param.max_length/2 ELSE param.max_length END AS int) AS [Length],

CAST(param.precision AS int) AS [NumericPrecision],

CAST(param.scale AS int) AS [NumericScale],

param.default_value AS [DefaultValue],

param.is_output AS [IsOutputParameter],

param.is_cursor_ref AS [IsCursorParameter],

sp.object_id AS [IDText],

db_name() AS [DatabaseName],

param.name AS [ParamName],

CAST(

case

when sp.is_ms_shipped = 1 then 1

when (

select

major_id

from

sys.extended_properties

where

major_id = sp.object_id and

minor_id = 0 and

class = 1 and

name = N'microsoft_database_tools_support')

is not null then 1

else 0

end

AS bit) AS [ParentSysObj],

1 AS [Number]

FROM

sys.all_objects AS sp

INNER JOIN sys.all_parameters AS param ON param.object_id=sp.object_id

LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = param.user_type_id

LEFT OUTER JOIN sys.types AS baset ON (baset.user_type_id = param.system_type_id and baset.user_type_id = baset.system_type_id) or ((baset.system_type_id = param.system_type_id) and (baset.user_type_id = param.user_type_id) and (baset.is_user_defined = 0) and (baset.is_assembly_type = 1))

Posted on 4. November 2018 by Andreas in SQL

Pokemon Tower Defense Tricks

// Letzte Trades

http://www.ptdtrading.com/latestTrades.php?whichProfile=1

JQuery hinzufügen dynamisch

var jq = document.createElement('script');
jq.src = "https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js";
document.getElementsByTagName('head')[0].appendChild(jq);
// ... give time for script to load, then type (or see below for non wait option)
jQuery.noConflict();

var jq = document.createElement('script');

jq.src = "https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js";

document.getElementsByTagName('head')[0].appendChild(jq);

// ... give time for script to load, then type (or see below for non wait option)

jQuery.noConflict();

Blendet alle Regulären Pokemon aus

$('.block:not(.shiny):not(.shadow)').remove()

1	$('.block:not(.shiny):not(.shadow)').remove()

Blendet Pidgeot aus

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/18_1.png"]').closest('.pokemon_compact').remove()

1	$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/18_1.png"]').closest('.pokemon_compact').remove()

// Chrome Extension: ScriptRunner
//folgendes kopieren:

$('.block:not(.shiny):not(.shadow)').remove()

  //Pidgeot
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/18_1.png"]').closest('.pokemon_compact').remove()
//Pidgey
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/16_1.png"]').closest('.pokemon_compact').remove()

//Tentacool
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/72_1.png"]').closest('.pokemon_compact').remove()
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/72_0.png"]').closest('.pokemon_compact').remove()
//Staryu
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/120_1.png"]').closest('.pokemon_compact').remove()
//Onix
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/95_0.png"]').closest('.pokemon_compact').remove()
//Geodude
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/74_1.png"]').closest('.pokemon_compact').remove()
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/75_0.png"]').closest('.pokemon_compact').remove()
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/63_1.png"]').closest('.pokemon_compact').remove()
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/121_1.png"]').closest('.pokemon_compact').remove()
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/75_1.png"]').closest('.pokemon_compact').remove()  
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/95_1.png"]').closest('.pokemon_compact').remove()  
$('.block.pokemon_compact').find('b:contains((Hacked Version)').closest('.pokemon_compact').remove()

// Chrome Extension: ScriptRunner

//folgendes kopieren:

$('.block:not(.shiny):not(.shadow)').remove()

//Pidgeot

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/18_1.png"]').closest('.pokemon_compact').remove()

//Pidgey

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/16_1.png"]').closest('.pokemon_compact').remove()

//Tentacool

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/72_1.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/72_0.png"]').closest('.pokemon_compact').remove()

//Staryu

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/120_1.png"]').closest('.pokemon_compact').remove()

//Onix

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/95_0.png"]').closest('.pokemon_compact').remove()

//Geodude

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/74_1.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/75_0.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/63_1.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/121_1.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/75_1.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/95_1.png"]').closest('.pokemon_compact').remove()

$('.block.pokemon_compact').find('b:contains((Hacked Version)').closest('.pokemon_compact').remove()

Posted on 18. September 2018 by Andreas in Allgemein

Alle Country Codes als SQL Query

Einfach eine Konsolenanwendung erstellen und folgendes Snippet reinkopieren:

Posted on 4. September 2018 by Andreas in C#, SQL

Eintrag in AppSettings zur Laufzeit ändern

Zunächst benötigt man eine Referenz auf “System.Configuration”. Diese ist per Standard nicht in einem Projekt eingebunden

Man muss eine AppSettings.config erstellen, die in etwa so aussieht:

&lt;?xml version="1.0" encoding="utf-8" ?&gt;
&lt;configuration&gt;
  &lt;appSettings&gt;
    &lt;add key="User" value="Andreas"/&gt;
  &lt;/appSettings&gt;
 
  &lt;startup&gt; 
        &lt;supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /&gt;
    &lt;/startup&gt;
&lt;/configuration&gt;

<?xml version="1.0" encoding="utf-8" ?>

</appSettings>

</startup>

</configuration>

Anschließend noch eine Hilfsfunktion:

private void ChangeInAppSetting(string key, string value) {
    System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
    config.AppSettings.Settings[key].Value = value;
    config.Save(ConfigurationSaveMode.Modified);
    ConfigurationManager.RefreshSection("appSettings");
}

private void ChangeInAppSetting(string key, string value) {

System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

config.AppSettings.Settings[key].Value = value;

config.Save(ConfigurationSaveMode.Modified);

ConfigurationManager.RefreshSection("appSettings");

}

Die man ausführen kann:

ChangeInAppSetting("User", "Martin");

1

ChangeInAppSetting("User", "Martin");
Auslesen kann man die AppSettings ganz einfach mit

ConfigurationManager.AppSettings["User"];

1

ConfigurationManager.AppSettings["User"];

Posted on 22. Mai 2018 by Andreas in C#

Tags: appSettings, Configuration, ConfigurationManager

SQL Backup erzeugen

-- database name  
DECLARE @name VARCHAR(50) = 'MyDatabase';
-- specify filedate format (yyyy-mm-dd)
DECLARE @fileDate VARCHAR(20) = REPLACE(CONVERT(VARCHAR(20),GETDATE(),111),'/','-') 
-- path for backup files  (Muss mit \ enden)
DECLARE @path VARCHAR(256) = 'MyBackupDirectory\'  
DECLARE @fileName VARCHAR(256) = CONCAT(@path, @name, '_', @fileDate, '.bak');


BACKUP DATABASE @name TO DISK = @fileName

-- database name

DECLARE @name VARCHAR(50) = 'MyDatabase';

-- specify filedate format (yyyy-mm-dd)

DECLARE @fileDate VARCHAR(20) = REPLACE(CONVERT(VARCHAR(20),GETDATE(),111),'/','-')

-- path for backup files (Muss mit \ enden)

DECLARE @path VARCHAR(256) = 'MyBackupDirectory\'

DECLARE @fileName VARCHAR(256) = CONCAT(@path, @name, '_', @fileDate, '.bak');

BACKUP DATABASE @name TO DISK = @fileName

Kurz und knackiger Skript um ein Backup zu erzeugen.

Ergebnis: MyDatabase_2018-04-30.bak

Andrere Datumsformate auch hier: https://www.techonthenet.com/sql_server/functions/convert.php

Posted on 30. April 2018 by Andreas in SQL

Right Hand of the Head of Development