Bitcoin Forum>Alternate cryptocurrencies>Mining (Altcoins)
Pages:
Author

Topic: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC (Read 56568 times)

HelloInThere
newbie
Activity: 1
Merit: 0
[OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
June 25, 2016, 11:18:04 AM
#756
Worng thread
eroxors
legendary
Activity: 924
Merit: 1000
Think. Positive. Thoughts.
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
March 14, 2014, 10:03:11 AM
#755
Quote from: JayCoin on March 14, 2014, 09:35:21 AM
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.

Quote from: eroxors on March 14, 2014, 09:06:54 AM
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?
JayCoin
sr. member
Activity: 409
Merit: 251
Crypt'n Since 2011
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
March 14, 2014, 09:35:21 AM
#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.

Quote from: eroxors on March 14, 2014, 09:06:54 AM
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
legendary
Activity: 924
Merit: 1000
Think. Positive. Thoughts.
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
March 14, 2014, 09:06:54 AM
#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'
eroxors
legendary
Activity: 924
Merit: 1000
Think. Positive. Thoughts.
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
March 14, 2014, 09:04:56 AM
#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!
PatMan
hero member
Activity: 924
Merit: 1000
Watch out for the "Neg-Rep-Dogie-Police".....
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
February 25, 2014, 07:18:31 PM
#751
Watching..... Smiley
Jude Austin
legendary
Activity: 1140
Merit: 1000
The Real Jude Austin
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
February 25, 2014, 06:41:16 PM
#750
Quote from: JayCoin on February 24, 2014, 01:38:49 AM
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!
JayCoin
sr. member
Activity: 409
Merit: 251
Crypt'n Since 2011
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
February 24, 2014, 04:17:28 PM
#749
Quote from: roy7 on February 24, 2014, 11:06:16 AM
JayCoin you may find this of interest:

http://doge.st/


Thanks, looks interesting.
roy7
sr. member
Activity: 434
Merit: 250
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
February 24, 2014, 11:06:16 AM
#748
JayCoin you may find this of interest:

http://doge.st/
JayCoin
sr. member
Activity: 409
Merit: 251
Crypt'n Since 2011
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
February 24, 2014, 01: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/
hoquet
newbie
Activity: 25
Merit: 0
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
February 23, 2014, 12: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?
Jude Austin
legendary
Activity: 1140
Merit: 1000
The Real Jude Austin
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
January 30, 2014, 07:54:44 PM
#745
I will certainly contribute to anyone who wants to help implement this into P2Pool.org.

roy7
sr. member
Activity: 434
Merit: 250
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
January 29, 2014, 11:25:38 AM
#744
Ah okay. Sorry to hear that. The constant threat of hackers, DDOS, etc is frustrating.
JayCoin
sr. member
Activity: 409
Merit: 251
Crypt'n Since 2011
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
January 29, 2014, 11:05:16 AM
#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.
roy7
sr. member
Activity: 434
Merit: 250
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
January 29, 2014, 10:55:49 AM
#742
As someone who sometimes thinks of doing the same thing this pool did, does anyone know why it eventually shut down?
Jude Austin
legendary
Activity: 1140
Merit: 1000
The Real Jude Austin
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
November 01, 2013, 08:10:42 PM
#741
If anyone would like to help me add database functions to P2Pool for a tip, PM ME!
Jude Austin
legendary
Activity: 1140
Merit: 1000
The Real Jude Austin
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
September 25, 2013, 11:20:21 PM
#740
Quote from: JayCoin on September 25, 2013, 11:17:40 PM
is share data showing up in lminer_data table?

Ha, nope.

For an FYI I am using the database structure a few posts above.
JayCoin
sr. member
Activity: 409
Merit: 251
Crypt'n Since 2011
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
September 25, 2013, 11:17:40 PM
#739
is share data showing up in lminer_data table?
Jude Austin
legendary
Activity: 1140
Merit: 1000
The Real Jude Austin
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
September 25, 2013, 11:00:36 PM
#738
Excellent, thank you so much!

No more issues in P2Pool console.

Now issues with displaying the current miners and litecoin blocks tabs.

Been digging through all the code and can't seem to find the issue.

I am guessing it has something to do with the database.

If you want to see it in action: http://192.3.117.102/index.php?method=lpool

Again thank you for your help.
Jude Austin
legendary
Activity: 1140
Merit: 1000
The Real Jude Austin
Re: [OFFLINE]P2Pmining.com-Hybrid P2Pool-NO FEE!!!-BTC/NMC/IXC/I0C/DEV/LTC
September 25, 2013, 10:41:29 PM
#737
Quote from: JayCoin on September 25, 2013, 10:33:31 PM
You need to set the id column in you database table to auto increment.

Trying this now.
Pages:
Bitcoin Forum>Alternate cryptocurrencies>Mining (Altcoins)
Jump to: