Bitcoin Forum
June 30, 2024, 05:16:25 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: « 1 ... 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 [379] 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 ... 667 »
7561  Economy / Exchanges / Re: New iOS App for Poloniex on: May 13, 2017, 12:14:36 PM
Building a app for the entire exchange could a be very good idea and why not, a bot integrated. Everything should be done using the Public API and should be open source, no one is going to use an app that require access to funds without the code source.
7562  Economy / Web Wallets / Re: Blockchain.info Smartphone wallet restore on: May 13, 2017, 11:55:33 AM
They don't store anything on their servers. If you don't have the passphrase, the wallet password or the private keys then there is nothing you could do to recover your wallet. Its lost.
7563  Economy / Economics / Re: Moment for buying or selling? on: May 13, 2017, 11:16:03 AM
Its really a simple equation. If you are looking for short term profit (which I believe is what you are looking for otherwise you wouldn't care about the price going down a few days after you buy) then don't buy. If you are aiming for the long term and higher prices then anytime (literally) is the best time to buy bitcoins because with years passing, less supply there will be.
7564  Economy / Services / Re: [Need] SQL Expert (Triggers) on: May 13, 2017, 10:05:09 AM
I think problem is because if the same product is bought/inserted more than 1 time at once, the value of bought also increases only by 1. The easiest solution would be only allowing one insert into table 2 at a time

That's not an option I'm willing to take unfortunately, A table should have the ability to get multiple INSERT STATEMENTS. I want to edit the trigger to achieve what I'm looking for.
7565  Economy / Services / [Need] SQL Expert (Triggers) on: May 13, 2017, 08:25:58 AM
Let's assume that I have the following code:

Code:
-- create the two tables
CREATE TABLE TABLE_2 (ID INT NOT NULL IDENTITY(1,1), ProdName VARCHAR(50))
CREATE TABLE TABLE_1 (ProdName VARCHAR(50), Bought INT)
GO

-- create trigger on "TABLE_2" to update "TABLE_1"    
CREATE TRIGGER T2Insert
ON TABLE_2
AFTER INSERT
AS
    UPDATE T1
    SET Bought = Bought + 1
    FROM TABLE_1 T1
    INNER JOIN Inserted i ON T1.ProdName = i.ProdName
    WHERE T1.Bought < 100
GO

-- initialize TABLE_1 with some seed data
INSERT INTO dbo.TABLE_1 (ProdName, Bought)
VALUES ( 'Prod1', 0), ('Prod2', 20), ('Prod3', 40), ('Prod4', 40), ('Prod100', 100)

-- insert new values into TABLE_2
INSERT INTO dbo.TABLE_2 (ProdName)
VALUES  ('Prod1'), ('Prod100'), ('Prod2'), ('Prod4')

-- get data to check
SELECT * FROM dbo.TABLE_1

The trigger works fine. However, If I insert something like this on TABLE_2 :

Code:
INSERT INTO dbo.TABLE_2 (ProdName)
VALUES  ('Prod1'), ('Prod1')

It only gets updated once. basically the SET Bought = Bought + 1 updates once instead of twice/or whatever the number of values I try to insert.

If you can solve this issue, let me know In the thread and how much $ you are looking for
7566  Economy / Service Discussion / Re: Doing a trade on LBC. How long does a bank transfer take to show up? on: May 13, 2017, 07:33:02 AM
The transfer from bank accounts usually takes anywhere between 3-5 days, I believe that those are business days so weekends or holidays are excluded.
7567  Economy / Service Discussion / Re: BTC.com Transaction Accelerator on: May 13, 2017, 06:24:08 AM
I live in Europe and we do not have AliPay. How can I speed up the transcation?

For the moment you can't really do anything about it. You can wait for Stripe to get fixed and implemented again, that should allow you to pay using credit cards and probably PayPal as well.
7568  Bitcoin / Bitcoin Technical Support / Re: Bitcoin 0.14.1 client not reachable on bitnodes.21 on: May 12, 2017, 11:18:59 AM
If the settings are correct, It should be reachable. Are you sure you have the 8333 port opened at least?
7569  Bitcoin / Bitcoin Discussion / Re: What are the best Bitcoin blogs? on: May 12, 2017, 08:58:30 AM
In addition to what has been mentioned already, there is BitcoinMagazine.com . Other sites that mentione are MarketWatch, investopedia but they are not about cryptocurrencies 100%, mostly economics in general.
7570  Economy / Service Discussion / Re: BTC.com Transaction Accelerator on: May 12, 2017, 06:21:34 AM
Is it still down in yours? I checked the site and its working well . It even calculated the fee for accelerating my transaction .
But I'm still hesitating in using their service tho . The reviews on this site is not that good unlike viabtc . So how is this different from viabtc? I accelarated my transaction on viabtc yesterday and still not confirmed (66 confirmations atm) . Will btc.com be quicker than viabtc considering that we will pay for it?

The number of unconfirmed transactions right now is just huge, ViaBTC has an hourly limit of 1000 transaction per hour as I already said. If you really want to get your TX confirmed then I suggest BTC.com accelerator even though, It kinda defeats the whole purpose of using bitcoin because they don't even accept BTC as a payment method (unless they added it recently). It should take a few hours (1-4 hours) as you can see on the description on the picture you posted.
7571  Other / Politics & Society / Re: Keylogger built into HP computers? on: May 12, 2017, 05:55:45 AM
I was just reading about this a few minutes ago, whoever is having a bitcoin wallet installed on his device, should probably move it at this point. It's not really affordable to lose anything at this point with the price going UP. If the malware is on the Audio driver, installing another OS is probably not going to help.
7572  Economy / Exchanges / Re: UQUID restricted countries on: May 12, 2017, 05:23:14 AM
I appreciate the taking the time to answer me, I know can use it without having to worry.

i m using wirex but now i think its time to leave wirex... i m from one of this restrited countries, but curentely i live in one of these 174 countries suported debit card...my question i would like to know if my account will not frozen because my pasport is from  one of  these restrited countries_? thanks for reply

Look at his first answer, he pretty much said everything related to your question.
7573  Economy / Exchanges / UQUID restricted countries on: May 11, 2017, 07:11:14 PM
Alright, so since the fees of Wirexapp are just ridiculous since the last 2.0 update they have made. I decided to look for alternative services and It looks like UQUID is good from the fees perspective. I decided to give them a shoot but like most of the services out there, my country is restricted.

They however said the following:

Quote
Unfortunately, Uquid cannot issue nor ship the Uquid Prepaid Visa Card to users who reside in the following countries:
( In order to get a virtual debit card you should change your country out of this listing)

I see from this that they are encouraging people who have their countries restricted to create virtual cards using fake info (or country). I just want to make sure that I'm not breaking any rules and I won't get my account frozen, could someone confirm that I could create my account with another country and still be able to use it fine as long as I don't reach the limits?
7574  Economy / Web Wallets / Re: BTC.com | BITCOIN WALLET | Safe, secure & trusted on: May 11, 2017, 06:25:59 PM
The bugs that I have reported a few weeks ago: https://bitcointalk.org/index.php?topic=1572823.msg18495547#msg18495547 was fixed on the 8th May update or still not?
7575  Economy / Service Discussion / Re: BTC.com Transaction Accelerator on: May 11, 2017, 05:36:30 PM
We currently have around 140,000 unconfirmed transaction, I thought I should let you guys know that the service is back to work as It could worth using at the moment with ViaBTC have small hourly limits. The payment methods are still somehow limited though.
7576  Economy / Lending / Re: Need 0.50 BTC loan for Exscudo investment on: May 11, 2017, 01:55:24 PM
A collateral is something someone could keep so he could sell it later If you ever don't give the money back. A gift card is a simple code, how would someone not use it for 3 weeks and you expect him to trust you that the code is actually working without trying it? even If he checks the balance, you could eventually redeem it. That's not a valid collateral.
7577  Bitcoin / Bitcoin Discussion / Ulmart.ru to accept Bitcoin on: May 11, 2017, 01:45:01 PM
Ulmart, Russia's largest online retailer, plans to start accepting bitcoin as a form of payment from 1 September, 2017

Ulmart is Russia's largest privately held Internet company specializing in e-commerce. The company was founded in 2008, and its headquarters are located in St. Petersburg. Ulmart has over 450 infrastructure facilities (fulfilment centres and pick-up points) in more than 240 cities and towns across Russia. http://www.ulmart.ru

Read the details here: http://www.prnewswire.com/news-releases/ulmart---the-future-is-today-company-to-look-at-bitcoin-621908663.html
7578  Economy / Exchanges / Re: [Exchange] Liqui - trade and earn 24 APR on BTC, ETH on: May 11, 2017, 01:13:40 PM
Hello;

So.. I can't see the scrollbar. Someone with the same problem?
Chrome, win 7 64..

~image snip~

I use win 7, 32, and if I use chrome, I can't see the scrollbar too, although I can navigate using page up and page down, it is quite inconvenient, though. Problem solved if you use mozilla, the scrollbar will reappear.

I can confirm that I have no problems browsing the website using Mozilla Firefox. (53.0.2 version - Windows 10 - 64bit) as well.
7579  Economy / Currency exchange / Re: HELP with convertion on: May 10, 2017, 06:03:46 PM
i currently have 0.02098306 LTC and there is no website that can convert this little please send me link if you know any website that can help me convert it


If you don't know much technical details (like how to use exchanges etc.) Install Exodus.io wallet, It has a built in exchange, change to whatever currency you want, you will get the funds directly to your wallet otherwise you have Poloniex where you could trade your LTC to BTC for example (but not sure about the minimum deposit though)
7580  Economy / Speculation / Re: $2000 anyone? on: May 10, 2017, 03:33:55 PM
People who are saying that Its just a matter of days/weeks should be more realistic, just because Its increasing and going well, doesn't mean It's going to continue until we reach the moon. The faster It goes high, the faster It will go down and the dump could be huge so Its better to get an increase with stability instead.
Pages: « 1 ... 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 [379] 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 ... 667 »
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!