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

HelloInThere

newbie

Activity: 1

Merit: 0

Worng thread

eroxors

legendary

Activity: 924

Merit: 1000

Think. Positive. Thoughts.

Quote from: JayCoin on March 14, 2014, 08: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, 08: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

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, 08: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.

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.

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".....

Watching.....

Jude Austin

legendary

Activity: 1140

Merit: 1000

The Real Jude Austin

Quote from: JayCoin on February 24, 2014, 12: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

Quote from: roy7 on February 24, 2014, 10:06:16 AM

JayCoin you may find this of interest:

http://doge.st/

Thanks, looks interesting.

roy7

sr. member

Activity: 434

Merit: 250

JayCoin you may find this of interest:

http://doge.st/

JayCoin

sr. member

Activity: 409

Merit: 251

Crypt'n Since 2011

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

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

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

roy7

sr. member

Activity: 434

Merit: 250

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

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

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

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

Quote from: JayCoin on September 25, 2013, 10: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

is share data showing up in lminer_data table?

Jude Austin

legendary

Activity: 1140

Merit: 1000

The Real Jude Austin

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

Quote from: JayCoin on September 25, 2013, 09:33:31 PM

You need to set the id column in you database table to auto increment.

Trying this now.

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