Buy Ripple with PayPal or credit card

https://platform.twitter.com/widgets.js

Advertisements

Oracle Tips

Oracle SQL reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions183.htm (useless)
http://www.sqlines.com/oracle-to-sql-server/to_date (GOOD)

Last X records

SELECT res.* FROM 
(
    SELECT t.* FROM schema.table t
    ORDER BY t.field [ASC|DESC]
) res
WHERE ROWNUM < 10

Dates in queries

SELECT * FROM  schema.table
WHERE date_field > TO_DATE('2018-04-21', 'YYYY-MM-DD')
BEGIN
   schema.package.procedure(
      p_start_date   => TO_DATE ('27/05/2018 09:00:00',                                  'dd/mm/yyyy hh24:mi:ss'),
      p_end_date     => TO_DATE ('28/05/2018 09:00:00',                                'dd/mm/yyyy hh24:mi:ss'));
   COMMIT;
END;

Cannot delete my (suspended) account on Twitter

I create an account on Twitter on 14 March 2018.
I made apparently 5 tweet:

twitter 02b

I purposely created a Twitter account to advertise my website (www.xrp-shop.com).
As many other people and organization do.
So I thought it was legit.
Probably I violated the Twitter rules and my account was suspended.

twitter 03

I follow the instruction in the link:

twitter 04
and I filed an appeal.

Around 2 Days after I received this email:

twitter 05

Permanently suspended. “This account will not be restored”.
This is bad.

I still can access to my account but I cannot tweet or make any other activity.
So, my tweets are still visible?
Are them removed.
What can I do?
Nothing.

In this situation seems logic to delete the account.
On the help page they says:

twitter 06

I’m using a web browser on my desktop PC, not a mobile, but in the account settings page there noting for “Deactivate my account”.

I searched also in other sections but nothing.

I checked on the PC of a colleague and in its account settings page that link is available:

MaxthonSnap20180403150037

This is the HTML code, I tried to inject and use it for my account but it does not work:

<div class="control-group">
    <div class="controls">
        <p><a id="account_deactivate_link" href="/settings/accounts/confirm_deactivation" rel="noopener">Deactivate your account</a></p>
    </div>
</div>

How can I delete my Twitter account ?

Buy ripple with PayPal is no more a problem

Many people ask on web sites where to buy ripple (XRP) with a credit card or with PayPal.
Many web site suggest procedures where the user have to register on one or more web sites, buy a different cryptocurrency (usually Ethereum) and then exchange it for XRP.
This procedure is long and not simple.

Some example of this request:
https://www.quora.com/Where-can-I-buy-Ripple-XRP-with-PayPal
https://www.quora.com/How-do-I-buy-Ripple-XRP

In the last couple of months many web sites were creatd just to supply this demand.
You can buy XRP directly with a credit card or with PayPal.
Unfortunately the majority of them offer a really bad price or require time for the transaction.
I created one web site were the transaction is IMMEDIATE because I sell XRP that are already in my possession and the price is really competitive.

xrp-shop

It is fast.
I does not need verification.
Available for any country.

It is needed to provide an existent XRP wallet. To create a new one I suggest to use an exchange like Bitstamp, GateHub, Binance or a Toast Wallet.

MongoDB tips

Change user password

db.updateUser(){ , { pwd: ""}}

Choose the ID field

We do not want to pollute our entities/classes with MongoDB attributes.
WE want to store the “Email” property as ID in mongoDB (the “_id” field of the document).

SetIdMember … does not work.
MapIdMember is the right one.


protected override void MapEntity()
{
if (!BsonClassMap.IsClassMapRegistered(typeof(Account)))
{
BsonClassMap.RegisterClassMap(map =>
{
map.AutoMap();
map.MapIdMember(c => c.Email);
map.SetIgnoreExtraElements(true);
});
}
}

MM revelation

This page is not finished, for now it is only a bunch of notes.

How it started?

(meetup Andrew Gray)
Meetup group title: “FREE – LIFE CHANGING EVENTS & SEMINARS IN LONDON”
Title of the meetup: Learn how to make a min of $5k p/m passive income! Exclusive opp ENDS 11th 7pm!!

Learn how to make a min of $5k p/m passive income! Exclusive opp ENDS 11th 7pm!!

Saturday, Jul 22, 2017, 3:00 PM

Location details are available to members only.

13 Members Attending

****Third PRE LAUNCH event – Not sure if there will be another one! *****Hello everyone, Andrew Gray, the Founder of this group here. I have an EXCLUSIVE opportunity from my mentor Eric Ho – (Google him, he is a serial entrepreneur!).I am not going to say much here, but there is the potential to earn a minimum of $5,000 per month, passive income,…

Check out this Meetup →

The meetup post contains only a link. The link get you to a registration form.

Place, revealed by email 1 day before.
Plaza River bank
forced to be there soon
5 emails with a stupid video (I’m exciting, pre-launh, like Facebook) before the event.

auditorium
water (no beer, orange joice or something to eat)

yuhuuu, gimme five and big smile, and videos and photos all the time.

high volume music
Singer, horrible pop music, promotion of her album
another singer,

A women was the speaker and then present Eric Ho.
It is like in the videos on youtube.
Good speaker, bla bla bla and trickes to get attention.
Bla bla bla. Some photos
At 24 years old he was financial independent.
Some images with cars (some out of the shop winmdow!)
Some in SPA or yatch (clearly not his, because he was not manouvering”).
A lot os self-videos, some embarassing for the stupidity.

He present Mister Wong. An idiot that has 20 million like for a video on youtube, So? How can this makew ME rich?

All the time generic questions to the crowd and “raise your and if/who”…

All the links in the email before the event are tracked with funnel.

SQL Server connection fails

– IDK: I don’t know
– Y: yes
– N: no

Which version is your SQL Server ?
– I don’t know
– 2016
– 2014
– 2005

Are you using an IP in the conenction string?
– Y
– N

Is the application that need to conenct on the same machine of SQL Server ?
– Y
– N

Are you using a Trusted conenction?
– IDK
– Y
– N

Are you using “localhost” as server name?
– IDK
– Y
– N

Do you know which connection string are you using?
– IDN
– Y
– N

Are the TCP inbound/outboundport allowed for port 1433?
– IDN
– Y
– N

The Login user in SQL Server is allowed to connect and login?
– IDN
– Y
– N

+ A001: use “(local)” instead of “localhost”
+ A002: check this: https://support.microsoft.com/en-us/help/328306/potential-causes-of-the-sql-server-does-not-exist-or-access-denied-err
+ A003: use “(local)” or instead of the IP address
+ A004: check this settings in Server/Security/Logins/User/(right click)/Properties/(Status section)
[attach image]

Connection fail to SQL Server after a database restore

Scenario.

Restore SQL Server database X.
Try to conenct using the usual connection string. Conenction fail.

Yes
Yes
Delete the user in “Security” of SQL Server.
Delete the user from the “Users” of the database.
Create a new user in Server/Securit6y/Logins:
– User name: seelct a user that exists in the machine, ex.: \user
– leave everything unchaged
Create a user in the database in database/Security/Users:
– Login namne: seelct <achine\
– User name: select \
No
Todo
> Yes
< Do you use an IP address in the connection string?

in the database:
– User name: select / using hhe selector
– Login name:
– Default schema:
> No
Yes
Check the user defined in the Application Pool of the current web site
> No
Todo
> No
Todo

MVC API tests – manage unknown error raised by HttpServer

Scenario: integration tests against ASP.Net MVC API.
MVC version 5.2

Create a base class test to manage the repetitive API GET/POST calls like:

protected HttpResponseMessage Execute(HttpMethod method, string url, T data)
{
url = BASE_URL + url;

HttpRequestMessage request = new HttpRequestMessage(method, url);
request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

JsonMediaTypeFormatter formatter = new JsonMediaTypeFormatter();
formatter.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
if (method == HttpMethod.Post && data != null)
request.Content = new ObjectContent(data, formatter);

using (var server = new HttpServer(GetConfiguration()))
using (var client = new HttpClient(server))
{
var response = client.SendAsync(request).Result;
return response;
}
}

Boom.

500. Internal server Error.

The server is set like this:
private HttpConfiguration GetConfiguration()
{
HttpConfiguration configuration = new HttpConfiguration();
//var dependencyResolver = new WindsorDependencyResolver(container);
//configuration.DependencyResolver = dependencyResolver;
WebApiConfig.Register(configuration);

// remove all HostAuthenticationFilter due to the error “no OWIN Authentication manager…”
foreach (var filter in configuration.Filters.Where(f => f.Instance is HostAuthenticationFilter).ToList())
configuration.Filters.Remove(filter.Instance);

return configuration;
}

mmhh… try to debug:
It enter in the ApiController, get the data from the REpository and it exit from the class with a nice colelction of data… what is wrong ???

Routing is ok, it is actually passing the request to the right controller.
Injection of repositories is ok, it is fetching and returning data.
Log4Net is ok, I’m not calling the “log4net.Config.XmlConfigurator.Configure();” without a proper configuration in app.config.

Adding “configuration.IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always;”
is absolutely useless for this problem.

What to do now?

I’ll check one of 2 or 3 previous project where I’ve already done this a where I spent 1,2 or 7 days to figure out this ALL THE TIMES fucking problem !