[OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC

[Jude Austin]

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

[1713557146]

1713557146

[1713557146]

1713557146

[1713557146]

1713557146

[1713557146]

1713557146

[1713557146]

1713557146

[roy7]

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

[JayCoin]

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.

[roy7]

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

[Jude Austin]

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

[hoquet]

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]

NEW open source P2PMining Software is in development.

It is a fork of p2pool.

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

[roy7]

JayCoin you may find this of interest:

http://doge.st/

[JayCoin]

JayCoin you may find this of interest:

http://doge.st/

Thanks, looks interesting.

[Jude Austin]

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!

[PatMan]

Watching.....

[eroxors]

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!

[eroxors]

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'

[JayCoin]

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.

[eroxors]

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?

[HelloInThere]

Worng thread