2019-12-22
2019-10-07
query tools openID bearer
invoke-webrequest
$url = "https://webapi.area23.at/api/bearertest"
$headers = @{}
$headers.Add("Accept","application/json")
$headers.Add("Authorization", "bearer myBearer")
invoke-webrequest -Uri $url -Headers $headers
invoke-webrequest -Uri $url -Method GET -Headers $headers
curl
curl -X GET \
-H "accept: application/json" \
-H "Authorization: bearer myBearer" \
"https://webapi.area23.at/api/bearertest"
wget
wget \
--header="Authorization: Bearer myBearer" \
--header="Content-Type: application/json" \
--no-check-certificate \
https://webapi.area23.at/api/bearertest
Postman
2019-06-21
Normand & Anglo-Saxon (after battle of Hastings 1066)
Normand: Alors mon petit, apporte-moi du boeuf!
Anglo-Saxon: Beef, that's cow (Kuh), beef?
Normand: Si doux, prends moi des moutons!!
Anglo-Saxon: Mutton? That's lamb (Lamm), why mutton?
Normand: Hé ma chérie, apporte-moi du porc!!!
Anglo-Saxon: Pork? Thou mean swine (Schwein)?
2019-06-14
2019-04-23
Meta grouping school modules & courses (working draft)
We want to learn more MINT module courses and kess dead languages at highschool & basic college [Draft, still in work]
- mathematics
- basics
- technically drawing geometry
- spreadsheets & business calculation
- logics
- languages
- native or classroom/school language
- mandatory english
- optional foreign languages, e.g. french, spanish, german, chinese, ...
dead languages, e.g. latin, ancient greek
- geopolitics & economics
- geography & earth science
- local & foreign economics
- local & foreign politics
- biochemistry
- biology
- environmental studies
- dietetics
- chemistry
- mechatronics
- physics
- IT OS user level & simple programming
- electronics
- mechanical engineering
- combined mechatronics with LEGO mindstorms
- culture & aesthetics
- history
- music
- art
- aesthetics
- ethics
- theory: religious & ideology studies, later psychology & philosophy
- practice: solving religious, ideologically, gender or special needs problems, group dynamics, NLP, choice & option role games
- sports
- basics [athletics. fitness & stamina training]
- ball games [soccer, basketball, volleyball, handball, hardball, rugby, ...]
- creative [impulse dance, monkey & pirate gymnastics, acrobatics, wrestling]
- outdoor & elements [swimming, skating, ice-skating, cycling, climbing, military, horse riding, sports with dogs]
please notice, that military, horses and hounds is only a final joke. please take not all 100% seriously, but try to understand the message
Mathematics
Geopolitics & Economics
Mechatronics
Instead of physics, IT and additional electronics, I would try to introduce a much more practical mechatronic light little bit more light weight module already in school by introducing something like Lego mindstorms: Children and young people can so easy learn, how to combine mechanics construction, electronics and IT programming with quick and boombastic results.
Culture & Aesthetics
Ethics
I would dump all religious courses in school and provide instead a mandatory ethic coursed for all children. Basic knowledge part of that course should include most important religions, ideologies (like socialism, democratic and totalitarian ideologies, imperialism, love movement of 68, deep state ethics, feminism and so on). At college level, we might include philosophy here too.
Practial part should help to resolve cultural, gender, religious or any other ideologically based conflicts by playing role plays, visiting conflict areas in country, etc.
Strong religious believers could offer their childs excellent private courses during their free time, if they want. But mission in school is different, religion should be more in private and family / community space than in public education. (There are certain expensive private religious schools too, everyone is free to take that choice).
Strong religious believers could offer their childs excellent private courses during their free time, if they want. But mission in school is different, religion should be more in private and family / community space than in public education. (There are certain expensive private religious schools too, everyone is free to take that choice).
2019-04-21
Debt mystery of Luxembourg
All informations according to tradingeconomics.com:
In year 2017 GDP of Luxembourg amounted to 62,40 billion US$ (62.400.000.000 US$).
In year 2011 GDP of Luxembourg amounted to exactly 62 billion US$ (62.000.000.000 US$).
In year 2017 private sector debt of Luxembourg was 474,84% of GDP
62,4 * 4,4784 = 296,30016 billon US$ (296.300.160.000 US$)
In year 2011 private debt to GDP of Luxembourg was 407,9% of GDP.
62 * 4,079 = 252,898 billion US$ (252.898.000.000 US$)
In year 2017 public sector debt of Luxembourg was 23% of GDP.
62,40 * 0,23 = 14,352 billion US$ (14.352.000.000 US$).
In year 2011 public sector debt of Luxembourg was 18,8% of GDP.
62,40 * 0,188 = 11,7312 billion US$ (11.731.200.000 US$).
So,
in year 2017 public & private sector debt of Luxembourg amounted to 310,65216 billion US$ (310.652.160.000 US$).
In year 2011 public & private sector debt of Luxembourg amounted to 264,6292 billion US$ (264.629.200.000 US$).
In year 2017 population of Luxembourg was 590.000 citizen (habitants).
In year 2011 population of Luxembourg was 510.000 citizen (habitants).
So,
in year 2017 public + private debt per citizen amounted to 526.529,08 US$. (= 468.171,23 €)
In year 2011 public + private debt per citizen amounted to 518.880,78 US$. (= 461.370,63 €)
Private & public sector debt per citizen in Luxembourg amounts approximately to ½ million US$ (constantly between 2010 - 2018)Quiet a very high amount per citizen, but dear Hans-Werner Sinn, how do you calculated in 2011 1,9 billion € (maybe trillion, cause german word Billionen means english trillion) of public sector + banking debt per citizen in Luxembourg?
Hans Werner Sinn debt calculation differs to tradingeconomics calculation by 380.000%. (That's really quiet a huge difference, in best case, when he meaned trillion it's another factor 1.000 => 380.000.000%)
Debt comparsion with other countries in year 2017
Germany
Germany pub. + priv. 211,5% debt of 3.677,44 billion US$ GDP7.777,7856 billion US$ = 7.777.785,6 million US$ total debt in Germany.
7.777.785,6 million US$ / 82,52 million citizen = 94.276 US$.
83.827 € total debt per german citizen.
Austria
Austria pub. + priv. 241,6% debt of 416,60 billion US$ GDP1.006,5056 billion US$ = 1.006.505,6 million US$ total debt in Austria.
1.006.505,6 million US$ / 8,77 million austrian citizen = 115.690,30 US$
102.868 € debt per austrian citizen.Austria gdp per capita = 49.129,23 US$
Austria gdp per capita ppp = 45.436,69 US$
Austria gdp per citizen = 47.340,90 US$
Austria gdp per gainfully employed (4,2605 million 82,78% in private sector, 17,21% in public sector) = 97.782 US$ (= 86.944,33 €)
Average income of employed in Austria is (45.345€ labor costs for company) 32.267€ before taxes, 22.640€ after taxes per year (2017).
How gdp per capita ppp is calculated? Are only working people included or retired people too?
Japan
Japan pub. + priv. 483% debt of 4.872,14 billion US$ GDP23.532,4362 billion US$ = 23.532.436,2 million US$ total debt in Japan.
23.532.436,2 million US$ / 126,7 million japanese citizen = 185.734 US$.
20.787.295¥ debt per japanese citizen
United States
United States pub. + priv. 358,4% debt of 19.390,60 billion US$ GDP69.495,9104 billion US$ = 69.495.910,4 million US$ total debt in United States.
69.495.910,4 million US$ / 325,7 million american citizen = 213.374 US$.
213.374 US$ debt per american citizen
Switzerland
pub. + priv. 296% debt of 678,89 billion US$ GDP2.009,5144 billion US$ = 2.009.514,4 million US$ total debt in Switzerland.
2.009.514,4 million US$ / 8,5 million swiss citizen = 236.413,46 US$.
236.413,46 US$ debt per swiss citizen
Ireland
Ireland pub. + priv. 450,27% debt of 333,73 billion US$ GDP1.502,686071 billion US$ = 1.502.686,071 million US$ total debt in Ireland.
1.502.686,071 million US$ / 4,8 million irish citizen = 313.060 US$.
278.362 € debt per irish citizen
https://docs.google.com/spreadsheets/d/1HdcmVGGl0WJPWmcv3vqYp5I1lHNFon3yvK0inYzcL9Y/edit?usp=sharing
When looking at GDP per capita, we see that GDP calculaton is often a very big bullshit.
According to tradingeconomics an irish citizen yields almost twice the GDP per capita performance of average japanese citizen. Japan is an industrial export country with at huge positive balance of trade and current account, while Ireland's current account is tiny positive cause of tourism and US tech giants IT cloud services (like amazon cloud Ireland or Microsoft IT departments). Prices in Ireland are very high compared to the rest of euro-area. But blowing up GDP, by increasing prices is a very evil GDP magick in my point view (Really, really)! (And yes, high prices in Ireland are one reason for that "greater" GDP per capita, but that's not the only reason of this GDP distortion). On the other side, Germany artificially shrinks his GDP (according to all other macroeconomic indicators of Germany).
2019-04-14
ECB press conference April 2019
- Key interest (prime) rates will remain at 0% at least until the end of 2019.
- Inflation in the eurozone is expected little less than 2%.
- Eurozone has no longer same substantial problems as in 2016, progress has been made.
- Economic growth in the eurozone is still weak, and there are still geopolitical and other problems.
- Structural reforms in many countries need to be continued. Member states should implement growth-promoting measures. (still a problem, that too few structural reforms and simultaneously avoiding growth friendly steps).
2019-04-04
Taboo, but legal
I wrote, what I would say to children. (This is only my personal opinion)
LGBT (please be extra sensitive when talking to children, don't talk about sex, only about lovley friend. childs are very sensitive and don't should know details)
male subs (please be extra PLUS sensitive when talking to children, don't talk about sex, only about lovley friend. childs are very sensitive and don't should know details)
traditionell sabre fighting Burschenschaftler (please be extra PLUS sensitive when talking to children, say you're joining an cultural traditional event)
Hijab (say nothing, because you don't know, why a women wears hijab)
Trachtenmode (say that is austrian cultural tradition wearing)
devoted christians
Opus dei (say, that those are very strong believing christians, but with hard rules, that are difficult for the majority to fullfill)
Female grey wolfes in mini-skirt (say, that crazy rebelling girls are sometimes stupid between 15 and 21 years)
Industriellenvereinigung (say, that is the only state free most important non gov organization)
Manga Comics (please be extra sensitive when talking to children, don't talk about sex, only that you're looking comics for Adults)
Communication with Wales (don't tell children about that)
Rallies against surveillance state (say citizen or human rights rally for peoples rights and don't make children fear of an all watching and inspecting surveillance state)
Old white men (say, that they maybe need more care)
Young back dancing female (say, that this is some kind of excotic sport)
Casino gambling (say to children, that this could turn into a disease and problems and don't go to casinos too often)
People, who play with her smartphone (say to children, you work or play)
snoring (say to children, that you have Astma or lung cancer)
AFD (say thats a political party for a special minority)
Die Linke (say that's a political party for a special minority)
Lügenpresse (say, that newspapers and TV and especially internet often make fake stories or jokes)
Female bodybuilders (say, that this is a very special sport, like Ski-Jumping or Triatlon)
Grüninnen (say thats a political party for environment activists)
Atheists (say nothing)
Caritas socialis (say, that Caritas is helping poor people, disabled people, workless people, people with problems)
I'am connected in myself to several minority groups and I don't wanted to show all full details to my children, because that would be a total epic fail and I made too much mistakes already)
LGBT (please be extra sensitive when talking to children, don't talk about sex, only about lovley friend. childs are very sensitive and don't should know details)
male subs (please be extra PLUS sensitive when talking to children, don't talk about sex, only about lovley friend. childs are very sensitive and don't should know details)
traditionell sabre fighting Burschenschaftler (please be extra PLUS sensitive when talking to children, say you're joining an cultural traditional event)
Hijab (say nothing, because you don't know, why a women wears hijab)
Trachtenmode (say that is austrian cultural tradition wearing)
devoted christians
Opus dei (say, that those are very strong believing christians, but with hard rules, that are difficult for the majority to fullfill)
Female grey wolfes in mini-skirt (say, that crazy rebelling girls are sometimes stupid between 15 and 21 years)
Industriellenvereinigung (say, that is the only state free most important non gov organization)
Manga Comics (please be extra sensitive when talking to children, don't talk about sex, only that you're looking comics for Adults)
Communication with Wales (don't tell children about that)
Rallies against surveillance state (say citizen or human rights rally for peoples rights and don't make children fear of an all watching and inspecting surveillance state)
Old white men (say, that they maybe need more care)
Young back dancing female (say, that this is some kind of excotic sport)
Casino gambling (say to children, that this could turn into a disease and problems and don't go to casinos too often)
People, who play with her smartphone (say to children, you work or play)
snoring (say to children, that you have Astma or lung cancer)
AFD (say thats a political party for a special minority)
Die Linke (say that's a political party for a special minority)
Lügenpresse (say, that newspapers and TV and especially internet often make fake stories or jokes)
Female bodybuilders (say, that this is a very special sport, like Ski-Jumping or Triatlon)
Grüninnen (say thats a political party for environment activists)
Atheists (say nothing)
Caritas socialis (say, that Caritas is helping poor people, disabled people, workless people, people with problems)
I'am connected in myself to several minority groups and I don't wanted to show all full details to my children, because that would be a total epic fail and I made too much mistakes already)
2019-03-10
Kommentar zu ORF-Artikel: Breite Front gegen IV-Vorstoß
Zitat:
Ich konnte dieses konkrete Statement bisher weder auf https://twitter.com/iv_news noch unter iv.at, verifizieren.´(nähere Details, siehe: http://goo.gl/SycZxG)
Somit sehe ich die ORF Meldung prinzipiell als unbestätigt. (not acknowledged)
Aber falls der vom Staatsfunk veröffentlichte Artikel korrekt, inhaltlich richtlig ist (und wahrheitsgemäß den Tatsachen entspricht), dann habe ich zum Feiertagsthema folgende Meinung:
IV-Präsident Georg Kapsch hatte vorgeschlagen, das Modell der nunmehrigen Karfreitag-Regelung praktisch auf alle in Österreich geltenden Feiertage umzulegen: Man solle doch sämtliche Feiertage abschaffen – und diese in persönlichen Urlaubsanspruch umwandeln, so Kapschs Vorstoß.Quelle: ORF https://orf.at/stories/3114579/
Ich konnte dieses konkrete Statement bisher weder auf https://twitter.com/iv_news noch unter iv.at, verifizieren.´(nähere Details, siehe: http://goo.gl/SycZxG)
Somit sehe ich die ORF Meldung prinzipiell als unbestätigt. (not acknowledged)
Aber falls der vom Staatsfunk veröffentlichte Artikel korrekt, inhaltlich richtlig ist (und wahrheitsgemäß den Tatsachen entspricht), dann habe ich zum Feiertagsthema folgende Meinung:
Analyse von mehreren Standpunkten (Hut aufsetzen, abgewandelt von de Bono)
- Ich setze mir den traditionell-kulturellen Volksempfinden Hut auf. Von den staatlichen Feiertagen ist der Nationalfeiertag am 26. Oktober unantastbar. Von den kirchlichen Feiertagen sind Weihnachten und Christtag (24. & 25 Dez.)., heilige 3. Könige (6. Jänner), Ostern (Ostermontag), Allerheiligen (1. November) nicht ohne extremen Unmut seitens der indigen Bevölkerung (und auch der heiligen katholischen Kirche) abschaffbar.
- Ich setze mir den Bundesheer (Landesverteidigungs-) Hut auf und bestehe auf den Nationalfeiertag am 26. Oktober, da traditionell die Leistungsschau des Bundesheeres am Heldenplatz stattfindet und auch am 26.10. stets neue Rekruten angelobt werden.
- Ich setze mir jetzt einmal den WKO (Wirtschaftskammer-) Hut auf und analysiere, welche Feiertage welchen Umsatz in welchen Branchen generieren.
Weihnachten (Geschenke aller Art) und Ostern (Schokohasen, Eier, etc. Lebensmittelwirtschaft!) sind aus wirtschaftlichen Gründen komplett unantastbar.
Silvester und Neujahr generieren wahrscheinlich angenehm hohe Umsätze in der Gastronomie und Freizeitwirtschaft und die entsprechenden Fachgruppenobmänner/-obfrauen würden heftigst gegen eine Abschaffung protestieren.
Auch die Spezialregelung beim 8. Dezember (Maria unbefleckte Empfängnis) für Weihnachtseinkäufe wird sich aus wirtschaftlichen Gründen nicht revidieren lassen. - Ich setze mir den Oppositions-SPÖ Hut jetzt auf und sehe eine Mobilisierungswelle der Sozialdemokratie von gewaltigem Ausmaß, sollte es die blau-schwarze Regierung es auch nur ansatzweise erwägen den sozialistischen Tag der Arbeit am 1. Mai abzuschaffen.
- Ganz schnell den Sport-Hut rauf: Das traditionelle Dreikönigsspringen (großes Finale) der 4. Schanzentournee in Bischofshofen macht 3. König unantastbar.
Zusammenfassung aller Hüte:
Neujahr (1.1.), heilige 3 Könige (6.1.), Ostern (Ostermontag), Tag der Arbeit (1.5.), Nationalfeiertag (26.10,), Allerheiligen (1.11.), Maria unbefleckte Empfängnis (8.12.), Weihnachten (24.12.), Christtag (25.12.), Silvester (31.12.) sind nach der kurzen Hut-Analyse unantastbar.
Welche Feiertage bleiben nun übrig?
Es bleiben 6. rein katholisch christliche Feiertage nun übrig, nämlich:
Christi Himmelfahrt (Donnerstag), Pfingsten (Montag), Fronleichnam (Donnerstag), Maria Himmelfahrt (24.8.), Stefanietag (26.12.).
Von mir aus könnte man alle diese Feiertage streichen und Christi-Himmelfahrt und Fronleichnam einfach auf den davor kommenden oder darauf folgenden Sonntag verlegen und in der Sonntagsmesse das entsprechende Evangelium lesen, bzw. die Fronleichnamsprozession durchführen.
Die ersten 3 Feiertage (2x Donnerstage, 1 Pfingstmontag) gehören im Kirchenjahr alle als Folge zu Ostern. (zuerst ist Jesus auferstanden, dann in den Himmel aufgefahren, dann kam der heilige Geist und die Apostel konnten in allen Sprachen sprechen [Babel tower reversed], Fronleichnam kann eh keiner vernünftig erklären, da wird der Leib Christi (die Hostie) in einer Monstranz unter einem Himmel in einer Proozession aus der Kirche hinaus getragen , es gibt eine Feldmesse und sinngemäß geht es darum, dass Jesus Christus wirklich durch die Eucharistie in Brot und Wein drinnen ist, oder so ähnlich) Die katholische Kirche wird hier mindestens auf 2 unbedingt und sehr beharrlich bestehen, wie ich die Situation einschätze.Maria Himmelfahrt und Stefanietag haben weder im katholischen Kontext, noch im traditionellen Brauchtaum tiefere wichtige Bedeutung, am Stefanietag wollen die Leute angegessen von Weihnachten mit Bauchschmerzen vielleicht noch nicht ganz so gerne arbeiten gehen und chillen den Weihnachtsstress an diesem Tag gerne aus.
Wer kann Feiertagsänderungen gesetzlich durchführen?
Ich vermute mal die Bundesregierung / das Parlament mit einfacher Mehrheit, aber das müsste ich mir näher ansehen und dazu bin ich heute zu müde.
Gute Nacht.
2019-03-01
1. Test aus EU Bürgerkunde (mittlere Reife, nach unten nivelliert).
Was sind die 6 wichtigsten Organe der Europäischen Union?
Antwort:
- Europäischer Rat
- Europäisches Parlament
- Europäische Kommission
- Europäischer Gerichtshof
- Europäischer Rechnungshof
- Europäische Zentralbank (EZB)
Welche Aufgabenbereiche hat der Europarat, welche die europäische Kommision und welche das Europaparlament?
Antwort:
Wer ist Ratspräsident und wer ist Kommisionspräsident der europäischen Union?
Antwort:Rat: Donald Tusk
Kommission: Jean Claude Junker
Welche Parteien sind im Europäischen Parlament vertreten und wofür stehen sie?
Antwort:
Was sind die wichtigste Geldpolitische Aufgaben der EZB?
- Preisstabilität (Inflation <= 2% in der Euro-Zone zu halten)
- Hoher Beschäftigungsstand, moderate langfristige Zinsen, Basis für Wirtschaftswachstum, Preisniveaustabilität
- Rettung von insolvenzgefährdeten Staaten und Banken
Antwort:
1. Preisstabilität
2. Arbeitsmarkt, wirtschaftliche Voraussetzungen für Wachstum ist nur ein geldpolitisches Mandat der FED (US-Notenbank), aber keines der EZB.
3. Staaten sind aufgrund der Maastrichtstabilitätskriterien verpflichtet, eigenverantwortlich selbst für die Stabilität zu sorgen, das ist kein Mandat der EZB, war nur eine Feuerwehrmaßnahme von Draghi. Bankenrettungen sind keine Aufgabe der EZB und unüblich, die USA ließ einige Banken und Hedge-Fonds pleite gehen, wie Lehmann Brothers.
Was ist die Aufgabe der EZB bezüglich der Geldpolitik bei europäischen Nicht-Euro Staaten (z.B. Rumänien, Polen)?
Antwort:
Keine.
(Wird erweitert)
2018-12-25
AWS CodePipeline for android Github project
A short summary, how to create an amazon code pipeline and build project by using an android java github as source repository. (inspired by j-a.f)
I have choosen my github schnapslet project android subtree for trial.
Click on "Create pipeline"
In section "Environment", I choosed the simplest way with "Managed image" as environment image, "Ubuntu" as operating system, "Android" as runtime, "aws/codebuild/android-java-8:26.1.1" as runtime version, default new service role.
In subsection "Additional configuration", you can enable a VPC on your virtual Ubuntu build server, e.g. if you want to login with ssh; you can select various performance features here, like "15 GB memory, 8 vCPUs" for your build server, you can set manually environment variables here and so on. We didn't need that here for only a simple proof of concepts.
In section "Buildspec" I choosed "Insert build commands", then switched to source editor and edited the following buildspec.yaml:
Finally click "Continue to CodePipeline".
Now click "Next", when you are back again on "Add build stage" site.
You can configure your "Build project" seperatly now here: https://console.aws.amazon.com/codesuite/codebuild/projects?region=us-east-1
e.g. if you want to change your buildspec.yaml or view different build logs.
I have choosen my github schnapslet project android subtree for trial.
Login into amazon webservices console
https://console.aws.amazon.com/codesuite/codepipeline/pipelines?region=us-east-1#Click on "Create pipeline"
Choose pipeline settings
Enter a "Pipeline name" and a service role for your new pipeline here. Click "Next".
Choose source provider
Choose Gitub, authorize with your github credentials or choose a public github project, choose repositoty, choose branch, then click "Next".
Add build stage
Choose AWS CodeBuild and click on "Create project".
Create build project
In section "Project" configuration fill out "Project name" (Description - optional).In section "Environment", I choosed the simplest way with "Managed image" as environment image, "Ubuntu" as operating system, "Android" as runtime, "aws/codebuild/android-java-8:26.1.1" as runtime version, default new service role.
In subsection "Additional configuration", you can enable a VPC on your virtual Ubuntu build server, e.g. if you want to login with ssh; you can select various performance features here, like "15 GB memory, 8 vCPUs" for your build server, you can set manually environment variables here and so on. We didn't need that here for only a simple proof of concepts.
In section "Buildspec" I choosed "Insert build commands", then switched to source editor and edited the following buildspec.yaml:
version: 0.2
phases:
#install: #commands: # - command
#pre_build: #commands: # - command
build:
commands
- sudo chmod 755 $CODEBUILD_SRC_DIR/android/Schnapslet/gradlew
- $CODEBUILD_SRC_DIR/android/Schnapslet/gradlew init -i
- $CODEBUILD_SRC_DIR/android/Schnapslet/gradlew build -i
- $CODEBUILD_SRC_DIR/android/Schnapslet/gradlew build --build-file $CODEBUILD_SRC_DIR/android/Schnapslet/app/build.gradle -i
#post_build: #commands: # - command
#artifacts: #files: # - location
#cache: #paths: # - paths
Finally click "Continue to CodePipeline".
Now click "Next", when you are back again on "Add build stage" site.
Add deploy stage
I skipped that option for that proof of concept.Review
Rewiew "Pipeline settings", "Add source stage", "Add build stage", "Add deploy stage" here and finally click "Create pipeline".
Release change
Finally "Release change".
You can configure your "Build project" seperatly now here: https://console.aws.amazon.com/codesuite/codebuild/projects?region=us-east-1
e.g. if you want to change your buildspec.yaml or view different build logs.
2018-12-18
Html-Sql-Injection Detection
Original post can be read here: http://blog.darkstar.work/2012/05/simple-html-injection-detection-for-ms.html
A very simple prototype of html injection detection in MS SQLServer, please notice, that real detection is much more complex...
If Exists(Select Top 1 object_id From tempdb.sys.tables Where name = '##InjWatch')
Delete From ##InjWatch
Else
Create Table ##InjWatch ( ctext nvarchar(Max), tab varchar(768), col varchar(768)
);
GO
Delete From ##InjWatch
Else
Create Table ##InjWatch ( ctext nvarchar(Max), tab varchar(768), col varchar(768)
);
GO
Declare InjectCursor Cursor FAST_FORWARD READ_ONLY For
Select 'Cast([' + c.name + '] as nvarchar(max))' as c_cast,
c.name as c_name, '' + s.name + '.[' +T.name + ']' as sT_name
From sys.tables T
Inner Join sys.columns c
On c.object_id = T.object_id
and c.max_length > 16 and c.system_type_id In (Select system_type_id From sys.types Where name In('varchar', 'nvarchar', 'char', 'nchar', 'text', 'ntext'))
Inner Join sys.schemas s
On s.schema_id = T.schema_id
Declare @c_cast varchar(1024), @c_name varchar(768), @sT_name varchar(768)
Open InjectCursor
Fetch Next From InjectCursor Into @c_cast, @c_name, @sT_name
While (@@FETCH_STATUS = 0)
Begin
Declare @execSQL nvarchar(max)
Set @execSQL = 'insert into ##InjWatch (ctext, tab, col) '+
'select ' + @c_cast + ' as ctext, ''' + @sT_name + ''' as tab, ''' + @c_name + ''' as col ' +
' from ' + @sT_name + ' with (nolock) ' +
' where (' + @c_cast + ' like ''%<%'' and ' + @c_cast + ' like ''%>%'') ' +
' or ' + @c_cast + ' like ''%script:%'' or ' + @c_cast + ' like ''%://%''' +
' or ' + @c_cast + ' like ''%href%'' or ' + @c_cast + ' like ''%return %''' +
' or ' + @c_cast + ' like ''%mailto:%'''
Execute sp_executesql @execSQL;
Fetch Next From InjectCursor Into @c_cast, @c_name, @sT_name
End
Close InjectCursor
Deallocate InjectCursor
Select Distinct * From ##InjWatch
GO
Select 'Cast([' + c.name + '] as nvarchar(max))' as c_cast,
c.name as c_name, '' + s.name + '.[' +T.name + ']' as sT_name
From sys.tables T
Inner Join sys.columns c
On c.object_id = T.object_id
and c.max_length > 16 and c.system_type_id In (Select system_type_id From sys.types Where name In('varchar', 'nvarchar', 'char', 'nchar', 'text', 'ntext'))
Inner Join sys.schemas s
On s.schema_id = T.schema_id
Declare @c_cast varchar(1024), @c_name varchar(768), @sT_name varchar(768)
Open InjectCursor
Fetch Next From InjectCursor Into @c_cast, @c_name, @sT_name
While (@@FETCH_STATUS = 0)
Begin
Declare @execSQL nvarchar(max)
Set @execSQL = 'insert into ##InjWatch (ctext, tab, col) '+
'select ' + @c_cast + ' as ctext, ''' + @sT_name + ''' as tab, ''' + @c_name + ''' as col ' +
' from ' + @sT_name + ' with (nolock) ' +
' where (' + @c_cast + ' like ''%<%'' and ' + @c_cast + ' like ''%>%'') ' +
' or ' + @c_cast + ' like ''%script:%'' or ' + @c_cast + ' like ''%://%''' +
' or ' + @c_cast + ' like ''%href%'' or ' + @c_cast + ' like ''%return %''' +
' or ' + @c_cast + ' like ''%mailto:%'''
Execute sp_executesql @execSQL;
Fetch Next From InjectCursor Into @c_cast, @c_name, @sT_name
End
Close InjectCursor
Deallocate InjectCursor
Select Distinct * From ##InjWatch
GO
2018-08-05
Schnapsen in Java and C# .Net
Austrian card game Schnapsen is ported as either
- asp.net C# WebApp (tested on Windows IIS and apache2 mod_mono)
- Android App (.apk)
- Java Applet / Application
Github repository: https://github.com/heinrichelsigan/schnapslet/
Wiki: https://github.com/heinrichelsigan/schnapslet/wiki/
Documentation of Schnapsen a.k.a. 66 (sixty-six) card game can be found at Wikipedia: https://en.wikipedia.org/wiki/Sixty-six_(card_game)
Schnapsen (Schnapslet) as C# .Net WebApp
- area23.at/mono/SchnapsNet/ [ Online ]
- darkstar.work/mono/SchnapsNet/SchnapsenNet.aspx [ Online ]
- Schnaps.Net asp.net [ GitHub ]
Schnapslet android sources:
Use Android Studio to rebuild or modify Schnapslet sources
android APK packages
Abonnieren
Posts (Atom)