Bitcoin Forum
December 04, 2016, 08:39:07 PM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 [38]
  Print  
Author Topic: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC  (Read 51980 times)
Jude Austin
Legendary
*
Offline Offline

Activity: 1000


The Real Jude Austin


View Profile
November 02, 2013, 12:10:42 AM
 #741

If anyone would like to help me add database functions to P2Pool for a tip, PM ME!

Nothing to see here...
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480883947
Hero Member
*
Offline Offline

Posts: 1480883947

View Profile Personal Message (Offline)

Ignore
1480883947
Reply with quote  #2

1480883947
Report to moderator
1480883947
Hero Member
*
Offline Offline

Posts: 1480883947

View Profile Personal Message (Offline)

Ignore
1480883947
Reply with quote  #2

1480883947
Report to moderator
roy7
Sr. Member
****
Offline Offline

Activity: 434


View Profile
January 29, 2014, 02:55:49 PM
 #742

As someone who sometimes thinks of doing the same thing this pool did, does anyone know why it eventually shut down?

RoyalMiningCo: Pools retired. Was fun!
JayCoin
Sr. Member
****
Offline Offline

Activity: 406


Crypt'n Since 2011


View Profile WWW
January 29, 2014, 03:05:16 PM
 #743

Server crashed/hacked never really figured out what went wrong.  Lost a few bitcoins and didn't want to risk it again. I was novice in setting up server security back then.

Hello There!
roy7
Sr. Member
****
Offline Offline

Activity: 434


View Profile
January 29, 2014, 03:25:38 PM
 #744

Ah okay. Sorry to hear that. The constant threat of hackers, DDOS, etc is frustrating.

RoyalMiningCo: Pools retired. Was fun!
Jude Austin
Legendary
*
Offline Offline

Activity: 1000


The Real Jude Austin


View Profile
January 30, 2014, 11:54:44 PM
 #745

I will certainly contribute to anyone who wants to help implement this into P2Pool.org.


Nothing to see here...
hoquet
Newbie
*
Offline Offline

Activity: 25


View Profile
February 23, 2014, 04:24:22 PM
 #746

I am trying to use the Dameondazz logging, but it skips the entry call command step and outputs to excel. Any clue what is happening?
JayCoin
Sr. Member
****
Offline Offline

Activity: 406


Crypt'n Since 2011


View Profile WWW
February 24, 2014, 05:38:49 AM
 #747

NEW open source P2PMining Software is in development.

It is a fork of p2pool.

Check it out at https://github.com/p2pmining/

Hello There!
roy7
Sr. Member
****
Offline Offline

Activity: 434


View Profile
February 24, 2014, 03:06:16 PM
 #748

JayCoin you may find this of interest:

http://doge.st/

RoyalMiningCo: Pools retired. Was fun!
JayCoin
Sr. Member
****
Offline Offline

Activity: 406


Crypt'n Since 2011


View Profile WWW
February 24, 2014, 08:17:28 PM
 #749

JayCoin you may find this of interest:

http://doge.st/


Thanks, looks interesting.

Hello There!
Jude Austin
Legendary
*
Offline Offline

Activity: 1000


The Real Jude Austin


View Profile
February 25, 2014, 10:41:16 PM
 #750

NEW open source P2PMining Software is in development.

It is a fork of p2pool.

Check it out at https://github.com/p2pmining/

Very excited about this!

Thank you!

Nothing to see here...
PatMan
Hero Member
*****
Offline Offline

Activity: 924


Watch out for the "Neg-Rep-Dogie-Police".....


View Profile WWW
February 25, 2014, 11:18:31 PM
 #751

Watching..... Smiley

"When one person is deluded it is called insanity - when many people are deluded it is called religion" - Robert M. Pirsig.  I don't want your coins, I want change.
Amazon UK BTC payment service - https://bitcointalk.org/index.php?topic=301229.0 - with FREE delivery!
http://www.ae911truth.org/ - http://rethink911.org/ - http://rememberbuilding7.org/
eroxors
Hero Member
*****
Offline Offline

Activity: 756


Think. Positive. Thoughts.


View Profile
March 14, 2014, 01:04:56 PM
 #752

Hey Jay,
I could never get work.py to spit anything out into the miner_data database, tried multiple versions of p2pool (including freicoin version, and the build just before stratum was introduced) and multiple ways to write the SQL insert code. update_blocks / grab_data updates this table, but without difficulty/ontime data. Your new fork does this, however. I've fiddled with the code adding the SQL Insert to get it to populate miner_data in the old database to run the old front-end. I need a small amount of help to figure out where the code should be placed in database.py, I just put it everywhere an execute insert was located.

Code:
class P2PminingData:
    def __init__(self):
        try:
            self.workDB = mysql.connector.connect(user=configure.db_username,password=configure.db_password,host=configure.db_location,database=configure.db_name)
            self.autocommit = False
            self.workDBcursor = self.workDB.cursor()
             
        except mysql.connector.Error as err:
            print(err)
        self.bitcoin = bitcoin.Bitcoin(configure.args)
   
    def add_shares(self,user,difficulty,on_time):
        try:
           [b] self.workDBcursor.execute("INSERT INTO miner_data (id,address,hashrate,timestamp,difficulty,ontime) VALUES (NULL, %s, %s, UNIX_TIMESTAMP(), %s, %s)",(user[:36],difficulty * on_time,difficulty,on_time))[/b]
            self.workDBcursor.execute("""INSERT INTO live_shares (id,userid,shares) VALUES (NULL, %s , %s ) ON DUPLICATE KEY UPDATE shares=shares + %s""", (user[:36], difficulty * on_time, difficulty * on_time) )
            self.workDB.commit()
        except mysql.connector.Error as err:
            self.workDB.rollback()
            print(err)
   
    def check_for_shift_completion(self):
        try:
            self.workDBcursor.execute("SELECT sum(shares) AS share_total FROM live_shares")
            returned = self.workDBcursor.fetchone()
            if (0 if returned[0] is None else int(returned[0])) > configure.shares_per_shift:
                self.workDBcursor.execute("SELECT * FROM live_shares")
                returned = self.workDBcursor.fetchall()
                self.workDBcursor.execute("INSERT INTO shifts (id, timestamp, shiftpay, lastblockheight, confirmed) VALUES (NULL, UNIX_TIMESTAMP(), '0', '0', FALSE)")
                shift_id = self.workDBcursor.lastrowid
                for row in returned:
                    self.workDBcursor.execute("INSERT INTO shift_data (id,userid,shares,shiftid) VALUES (NULL, %s, %s, %s)", (row[1],row[2],shift_id))
                self.workDBcursor.execute("UPDATE live_shares SET shares = '0'")
                [b]self.workDBcursor.execute("INSERT INTO miner_data (id,address,hashrate,timestamp,difficulty,ontime) VALUES (NULL, %s, %s, UNIX_TIMESTAMP(), %s, %s)",(user[:36],difficulty * on_time,difficulty,on_time))[/b]
                self.workDB.commit()
        except mysql.connector.Error as err:
            self.workDB.rollback()
            print(err)
   
    def record_p2pool_share(self,user,difficulty,on_time):
        try:
            [b]self.workDBcursor.execute("INSERT INTO miner_data (id,address,hashrate,timestamp,difficulty,ontime) VALUES (NULL, %s, %s, UNIX_TIMESTAMP(), %s, %s)",(user[:36],difficulty * on_time,difficulty,on_time))[/b]
            self.workDBcursor.execute("INSERT INTO p2pool_shares (id,userid,share_hash,on_time,timestamp) VALUES (NULL, %s, %s, %s, UNIX_TIMESTAMP())",(user[:36],share_hash,on_time))
            self.workDB.commit()
        except mysql.connector.Error as err:
            self.workDB.rollback()
            print(err)   
   
    def record_block_from_miner(self,user,block_hash,on_time):
        try:
            [b]self.workDBcursor.execute("INSERT INTO miner_data (id,address,hashrate,timestamp,difficulty,ontime) VALUES (NULL, %s, %s, UNIX_TIMESTAMP(), %s, %s)",(user[:36],difficulty * on_time,difficulty,on_time))[/b]
            self.workDBcursor.execute("INSERT INTO found_blocks (id,userid,block_hash,on_time,timestamp) VALUES (NULL, %s, %s, %s, UNIX_TIMESTAMP())",(user[:36],block_hash,on_time))
            self.workDB.commit()
        except mysql.connector.Error as err:
            self.workDB.rollback()
            print(err)

Also, I've modified the SQL database creation from what was posted earlier with a few fixes, using some settings from Jay's new database creation script. I think I've got all references to the database host / username / password / name referenced back to cred.php in the original. I'll post that when confirmed working.

Code:
CREATE TABLE `pool_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `miner_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(48) NOT NULL,
  `hashrate` varchar(64) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `difficulty` bigint(20) NOT NULL,
  `ontime` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `miner_hist` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(48) NOT NULL,
  `hashrate` varchar(64) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `difficulty` bigint(20) NOT NULL,
  `ontime` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `pay_address` (
  `address` varchar(48) NOT NULL,
  `paddress` varchar(48) NOT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `pool_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `hashrate` varchar(64) NOT NULL,
  `shares` bigint(20) NOT NULL,
  `stale_doa` bigint(20) NOT NULL,
  `stale_orphan` bigint(20) NOT NULL,
  `p2pool_hashrate` bigint(20) NOT NULL,
  `p2pool_stale_rate` bigint(20) NOT NULL,
  `block_value` decimal(16,8) NOT NULL,
  `peers_out` int(11) NOT NULL,
  `peers_in` int(11) NOT NULL,
  `current_payout` decimal(16,8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `signtime` (
  `address` varchar(48) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `lminer_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(48) NOT NULL,
  `hashrate` varchar(64) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `difficulty` bigint(20) NOT NULL,
  `ontime` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `lminer_hist` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `address` varchar(48) NOT NULL,
  `hashrate` varchar(64) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `difficulty` bigint(20) NOT NULL,
  `ontime` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `lpayouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `lpool_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `lpool_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `hashrate` varchar(64) NOT NULL,
  `shares` bigint(20) NOT NULL,
  `stale_doa` bigint(20) NOT NULL,
  `stale_orphan` bigint(20) NOT NULL,
  `p2pool_hashrate` bigint(20) NOT NULL,
  `p2pool_stale_rate` bigint(20) NOT NULL,
  `block_value` decimal(16,8) NOT NULL,
  `peers_out` int(11) NOT NULL,
  `peers_in` int(11) NOT NULL,
  `current_payout` decimal(16,8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `namecoin_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `namecoin_payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `namecoin_reg` (
  `BTC_address` varchar(36) NOT NULL,
  `NMC_address` varchar(36) NOT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `devcoin_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `devcoin_payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `devcoin_reg` (
  `BTC_address` varchar(36) NOT NULL,
  `NMC_address` varchar(36) NOT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `i0coin_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `i0coin_payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `i0coin_reg` (
  `BTC_address` varchar(36) NOT NULL,
  `NMC_address` varchar(36) NOT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `ixcoin_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `ixcoin_payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `ixcoin_reg` (
  `BTC_address` varchar(36) NOT NULL,
  `NMC_address` varchar(36) NOT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `coiledcoin_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `coiledcoin_payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `coiledcoin_reg` (
  `BTC_address` varchar(36) NOT NULL,
  `NMC_address` varchar(36) NOT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `groupcoin_blocks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `type` varchar(64) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `confirmations` int(11) NOT NULL,
  `blk_num` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `groupcoin_payouts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `address` varchar(48) NOT NULL,
  `amount` decimal(16,8) NOT NULL,
  `txid` varchar(64) NOT NULL DEFAULT 'NONE',
  `paddress` varchar(48) NOT NULL,
  `paid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `groupcoin_reg` (
  `BTC_address` varchar(36) NOT NULL,
  `NMC_address` varchar(36) NOT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Thanks for the help!

Don't get caught up in the game and have a nice day!
eroxors
Hero Member
*****
Offline Offline

Activity: 756


Think. Positive. Thoughts.


View Profile
March 14, 2014, 01:06:54 PM
 #753

Also, the new fork is giving me this error, but might be from my changes:

2014-03-13 17:01:16.011113 1054: Unknown column 'cointype' in 'where clause'
2014-03-13 17:01:16.012629 1054: Unknown column 'cointype' in 'field list'

Don't get caught up in the game and have a nice day!
JayCoin
Sr. Member
****
Offline Offline

Activity: 406


Crypt'n Since 2011


View Profile WWW
March 14, 2014, 01:35:21 PM
 #754

I have a bunch of fixes to push out this weekend.  I tested on terracoin and with more blocks being found, I found more bugs. I will be moving functions that are not for logging shares to another script so that any problems with the other functions won't bog down p2pool.

Also, the new fork is giving me this error, but might be from my changes:

2014-03-13 17:01:16.011113 1054: Unknown column 'cointype' in 'where clause'
2014-03-13 17:01:16.012629 1054: Unknown column 'cointype' in 'field list'

The newer code fixes this issue.

Hello There!
eroxors
Hero Member
*****
Offline Offline

Activity: 756


Think. Positive. Thoughts.


View Profile
March 14, 2014, 02:03:11 PM
 #755

I have a bunch of fixes to push out this weekend.  I tested on terracoin and with more blocks being found, I found more bugs. I will be moving functions that are not for logging shares to another script so that any problems with the other functions won't bog down p2pool.

Also, the new fork is giving me this error, but might be from my changes:

2014-03-13 17:01:16.011113 1054: Unknown column 'cointype' in 'where clause'
2014-03-13 17:01:16.012629 1054: Unknown column 'cointype' in 'field list'

The newer code fixes this issue.

Ahh, nice!

FYI: I have added groupcoin and coiledcoin to the configure.py and it merges just fine. I am still working on huntercoin and geistgeld.

Off the top of your head, where would be the best place in database.py to put:

Code:
self.workDBcursor.execute("INSERT INTO miner_data (id,address,hashrate,timestamp,difficulty,ontime) VALUES (NULL, %s, %s, UNIX_TIMESTAMP(), %s, %s)",(user[:36],difficulty * on_time,difficulty,on_time))

or do you have plans on doing a front-end?

Don't get caught up in the game and have a nice day!
HelloInThere
Newbie
*
Offline Offline

Activity: 1


View Profile
June 25, 2016, 03:18:04 PM
 #756

Worng thread
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 [38]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!