2019/12/01
2019/10/31
How to match not string with C# regular expression ?
Regular expression:
INSERT INTO \[TABLICA_REJ\](?:(?!VALUES).)*VALUES \(([^,]+,){4}'(?[A-Z0-9]+)'
input:
IF NOT EXISTS (SELECT 1 FROM VEHICLE_PLATES WHERE id = 2191007153548014038060268115) INSERT INTO [VEHICLE_PLATES] ([id],[id2],[name],[name2],[number],[date]) VALUES (2191007153548014038060268115,2190926111229058038052754,'00','0','PZ407TV','2019-10-07 15:27:27');
Check in http://regexstorm.net
example and check
http://regexstorm.net/tester?p=INSERT+INTO+%5c%5bTABLICA_REJ%5c%5d%28%3f%3a%28%3f!VALUES%29.%29*VALUES+%5c%28%28%5b%5e%2c%5d%2b%2c%29%7b4%7d%27%28%3f%3ctab_rej%3e%5bA-Z0-9%5d%2b%29%27&i=IF+NOT+EXISTS+%28SELECT+1+FROM+TABLICA_REJ+WHERE+idr+%3d+2191007153548014038060268115%29%0d%0aINSERT+INTO+%5bTABLICA_REJ%5d+%28%5bidr%5d%2c%5bidw%5d%2c%5bwt_tr%5d%2c%5bkt_rej%5d%2c%5bnr_tab_rej%5d%2c%5bnr_tab_rej_dr%5d%2c%5bdt_wyd%5d%2c%5bdod_tab%5d%2c%5bdt_dodania_dod_tab%5d%2c%5bidentyfikatorSystemowyCepik%5d%2c%5bidentyfikatorStanuCepik%5d%2c%5bzwezone_litery%5d%29+VALUES+%282191007153548014038060268115%2c2190926111229058038052754%2c%2700%27%2c%270%27%2c%27PZ407TV%27%2c%27PZ+407TV%27%2c%272019-10-07+15%3a27%3a27%27%2c%270%27%2cNULL%2c4977814074663942%2c4619151641798971%2c1%29%3b%0d%0a&o=s
INSERT INTO \[TABLICA_REJ\](?:(?!VALUES).)*VALUES \(([^,]+,){4}'(?
input:
IF NOT EXISTS (SELECT 1 FROM VEHICLE_PLATES WHERE id = 2191007153548014038060268115) INSERT INTO [VEHICLE_PLATES] ([id],[id2],[name],[name2],[number],[date]) VALUES (2191007153548014038060268115,2190926111229058038052754,'00','0','PZ407TV','2019-10-07 15:27:27');
Check in http://regexstorm.net
example and check
http://regexstorm.net/tester?p=INSERT+INTO+%5c%5bTABLICA_REJ%5c%5d%28%3f%3a%28%3f!VALUES%29.%29*VALUES+%5c%28%28%5b%5e%2c%5d%2b%2c%29%7b4%7d%27%28%3f%3ctab_rej%3e%5bA-Z0-9%5d%2b%29%27&i=IF+NOT+EXISTS+%28SELECT+1+FROM+TABLICA_REJ+WHERE+idr+%3d+2191007153548014038060268115%29%0d%0aINSERT+INTO+%5bTABLICA_REJ%5d+%28%5bidr%5d%2c%5bidw%5d%2c%5bwt_tr%5d%2c%5bkt_rej%5d%2c%5bnr_tab_rej%5d%2c%5bnr_tab_rej_dr%5d%2c%5bdt_wyd%5d%2c%5bdod_tab%5d%2c%5bdt_dodania_dod_tab%5d%2c%5bidentyfikatorSystemowyCepik%5d%2c%5bidentyfikatorStanuCepik%5d%2c%5bzwezone_litery%5d%29+VALUES+%282191007153548014038060268115%2c2190926111229058038052754%2c%2700%27%2c%270%27%2c%27PZ407TV%27%2c%27PZ+407TV%27%2c%272019-10-07+15%3a27%3a27%27%2c%270%27%2cNULL%2c4977814074663942%2c4619151641798971%2c1%29%3b%0d%0a&o=s
2018/09/01
How to set up xampp Php on Windows 10 ?
1/ Download xamp for Windows
from https://www.apachefriends.org/pl/download.html and install it
2/ Run xampp manage window
Xampp window -> Apache -> Config -> httpd.conf
Change:
Listen 80 -> Listen 8080
localhost:80 -> localhost:8080
4/ Modify httpd-vhosts.conf
C:\xampp\apache\conf\extra
C:\Windows\System32\drivers\etc
127.0.0.1 my.gumtree.pl
6/ Create directory with application content
at C:/vhosts/my.gumtree.pl
from https://www.apachefriends.org/pl/download.html and install it
2/ Run xampp manage window
Xampp window -> Apache -> Config -> httpd.conf
Change:
Listen 80 -> Listen 8080
localhost:80 -> localhost:8080
4/ Modify httpd-vhosts.conf
C:\xampp\apache\conf\extra
<VirtualHost *:8080>
ServerAdmin admin@gmail.com
DocumentRoot "C:/vhosts/my.gumtree.pl"
ServerName my.gumtree.pl
ErrorLog "my.gumtree.pl-error.log"
CustomLog "logs/my.gumtree.pl-access.log" common
<Directory "C:/vhosts/my.gumtree.pl">
# --New way of doing it
Require all granted
<Directory>
</VirtualHost>
C:\Windows\System32\drivers\etc
127.0.0.1 my.gumtree.pl
6/ Create directory with application content
at C:/vhosts/my.gumtree.pl
2017/08/09
Visual Studio cannot start debugging because the debug target ...
The problem was I had bad nuget source configuration It was not enough to change nugget source url, I just had to remove nugget source and add it again with proper url
Subscribe to:
Posts (Atom)