Bitcoin Forum
May 27, 2024, 02:27:07 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: « 1 ... 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 [68] 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 »
1341  Other / Off-topic / Re: When will people start closing their bank accounts? on: April 28, 2011, 11:37:07 PM
i am using bitcoins as my bank account
1342  Local / Other languages/locations / Re: Esperanto ! on: April 26, 2011, 10:07:56 PM
Mi klopodis traduki la softvaron al Esperanto, tamen ne finis gxin. http://pastebin.com/KcgUBaU7
Kompletigu gxin, se oni deziras.
1343  Bitcoin / Bitcoin Discussion / Re: BitCon! When and Where? on: April 26, 2011, 05:11:36 PM
If it's in Europe, it should be in London.

Can you please explain why?

I am french, I'm the #3 most prolific writer on this forum and as such I am offended by this proposition.
1344  Economy / Marketplace / Re: Donate to WikiLeaks on: April 26, 2011, 04:52:48 PM
SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM SCAM
1345  Economy / Marketplace / Wikileaks Donation Rally [200 BTC] on: April 26, 2011, 04:50:23 PM
OK,

17EoYD55TKto6Jk6R9jzQoFWuC6nMaXwYj

One that address either reaches 2k BTC or 1 month passes, then I'll try to get Wikileaks to accept the funds.

If they don't accept, then everybody will have their funds sent back to the originating address.
1346  Economy / Marketplace / Re: Buying catastrophe insurance on: April 26, 2011, 02:19:38 PM
Check your PMs
1347  Bitcoin / Bitcoin Discussion / Re: BitCon! When and Where? on: April 25, 2011, 10:33:14 PM
Vote London too. It's the hub of the world. If anything is organised there, then I might be able to setup free hosting for a bunch of people by asking around.
1348  Local / Other languages/locations / Re: Esperanto ! on: April 25, 2011, 07:27:54 PM
Saluton!

Ankaux al vi!
1349  Bitcoin / Bitcoin Discussion / Re: What goods & services have you purchased with bitcoin? on: April 25, 2011, 08:21:54 AM
Mainly I've used it to pay people for work.

Also bought hosting.
1350  Bitcoin / Bitcoin Technical Support / Re: help with Bitcoin development in php (variable parameters) on: April 25, 2011, 08:09:19 AM

$id                Integer  No quotes
$received_address  String   Quotes
$amount            Float    No Quotes


Your problem is that $userid needs to be a string. You can cast it using (string)$userid.
1351  Other / Off-topic / Re: MySQL table pointers on: April 25, 2011, 12:51:21 AM
Thanks.
1352  Bitcoin / Development & Technical Discussion / Re: OP_TIMESTAMP in script on: April 24, 2011, 09:35:02 PM
How does this apply to OP_TIMESTAMP? The time is always the same on all systems.
1353  Bitcoin / Development & Technical Discussion / OP_TIMESTAMP in script on: April 24, 2011, 06:30:58 PM
Wouldn't it be cool to have OP_TIMESTAMP in script to get the current time in POSIX (or something else that lasts beyond 2038).
1354  Other / Off-topic / Re: GBP Parity on: April 24, 2011, 05:12:44 PM
https://britcoin.co.uk/?page=orderbook

Crazy. 1 GBP parity has been reached.
1355  Other / Off-topic / Re: MySQL table pointers on: April 23, 2011, 11:34:42 AM
Well your query does a cartesian join then filters out some rows using a WHERE and is less efficient than JOIN ... ON ...  Grin

So how could I tell whether reqid='133' is from either Bitcoin, international_requests or uk_requests in a single query? I know I could do SELECT 1 FROM uk_requests WHERE reqid='133'; to see whether it exists in uk_requests, but how about for all 3 in one go?

Is an extra field in requests the way to go?
1356  Other / Off-topic / Re: MySQL table pointers on: April 23, 2011, 10:46:18 AM
For Britcoin there are 3 different types of withdrawal: Bitcoin, UK-domestic, UK-international:

Code:
mysql> describe requests;
+-----------+---------------------+------+-----+-------------------+----------------+
| Field     | Type                | Null | Key | Default           | Extra          |
+-----------+---------------------+------+-----+-------------------+----------------+
| reqid     | int(10) unsigned    | NO   | PRI | NULL              | auto_increment |
| req_type  | varchar(6)          | NO   |     | NULL              |                |
| uid       | int(10) unsigned    | NO   |     | NULL              |                |
| amount    | bigint(20) unsigned | NO   |     | NULL              |                |
| curr_type | varchar(6)          | NO   |     | NULL              |                |
| timest    | timestamp           | NO   |     | CURRENT_TIMESTAMP |                |
| status    | varchar(6)          | NO   |     | VERIFY            |                |
+-----------+---------------------+------+-----+-------------------+----------------+
7 rows in set (0.00 sec)

mysql> describe bitcoin_requests;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| reqid | int(10) unsigned | NO   | PRI | NULL    |       |
| addy  | varchar(44)      | NO   |     | NULL    |       |
+-------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe international_requests;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| reqid | int(10) unsigned | NO   | PRI | NULL    |       |
| iban  | varchar(36)      | NO   |     | NULL    |       |
| swift | varchar(12)      | NO   |     | NULL    |       |
+-------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> describe uk_requests;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| reqid     | int(10) unsigned | NO   | PRI | NULL    |       |
| name      | varchar(40)      | NO   |     | NULL    |       |
| bank      | varchar(40)      | NO   |     | NULL    |       |
| acc_num   | varchar(8)       | NO   |     | NULL    |       |
| sort_code | varchar(6)       | NO   |     | NULL    |       |
+-----------+------------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

Each of those requests 'shares' the requests tables but adds their own specific data.

I'd like some way to tell which data should be joined to the requests tables and what type of request it was (Bitcoin, UK-domestic, UK-international).

Maybe an accounts field or using views is the way to go.
1357  Other / Off-topic / MySQL table pointers on: April 22, 2011, 04:12:27 PM
Is there a way to have a field in MySQL that acts as a pointer to another table?

I want to have a bunch of different records with different fields but sharing some common ones.

common field A | common field B | pointer

then I could do:

SELECT mytbl ... JOIN POINTER(mytbl.pointer) ...;

Or do I need to have a VARCHAR(6) ident field and simply have a switch... case in my application that joins depending on which "other" table is needed?
1358  Bitcoin / Development & Technical Discussion / Re: How to find total number of nodes? on: April 22, 2011, 04:08:30 PM
https://en.bitcoin.it/wiki/Protocol_specification#getaddr

or use IRC boostrap nodes
1359  Bitcoin / Development & Technical Discussion / Re: [PULL] bitcoind send genjix@foo.org 2 on: April 22, 2011, 10:31:37 AM
12:14 < sipa> genjix: i mean even further, it should be clear that you're able to have a name-lookup service without any ability to log in on a server, fiddle with
              public keys, know that it uses rsa signatures, ...

FYI there are several parts to my branch:

- It's a simple name lookup from a webserver.*
- An example PHP implementation that returns the addresses.
- An RSA keypair class which supports displaying a public key in PEM format.
- An example PHP implementation for a service which allows you to update your public key using an OpenID login (supports Facebook, Google, Yahoo, Wordpress, Launchpad .etc)
- A name lookup update which takes your nickname+address+a timestamp in the POST request and signs it so the server can verify it's you.
- An example PHP name lookup which allows you to set your address.

* This latest pull request is only for this first part. We can make subsequent pull requests for each feature as we go along and decide.
1360  Bitcoin / Project Development / Re: UK exchange: Britcoin on: April 22, 2011, 09:23:31 AM
any idea why apache keeps working for a bit, then stops showing pages? i get this:

Code:
myuser:/tmp$ sudo /etc/init.d/apache2 stop
 * Stopping web server apache2                                   [ OK ]
myuser:/tmp$ sudo /etc/init.d/apache2 start
 * Starting web server apache2                  
(98)Address already in use: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs                                                       [fail]
myuser:/tmp$ sudo lsof -i :80
COMMAND PID USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
apache2 690 root    3u  IPv4   4322      0t0  TCP *:www (LISTEN)
myuser:/tmp$
myuser/tmp$ ps aux | grep apache
root       676  0.0  0.0   1836   612 ?        S    04:10   0:00 /bin/sh -e /etc/rc4.d/S91apache2 start
root       685  0.0  0.0   1836   560 ?        S    04:10   0:00 /bin/sh /usr/sbin/apache2ctl start
root       690  0.0  0.7  18672  4964 ?        S    04:10   0:00 /usr/sbin/apache2 -k start
myuser   7193  0.0  0.1   3328   816 pts/0    S+   09:19   0:00 grep --color=auto apache
myuser:/tmp$ sudo /etc/init.d/apache2 stop
 * Stopping web server apache2                                  [ OK ]

EDIT: Was an issue with my hosting service.
Pages: « 1 ... 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 [68] 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 »
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!