It was the Bitcointalk forum that inspired us to create Bitcointalksearch.org - Bitcointalk is an excellent site that should be the default page for anybody dealing in cryptocurrency, since it is a virtual gold-mine of data. However, our experience and user feedback led us create our site; Bitcointalk's search is slow, and difficult to get the results you need, because you need to log in first to find anything useful - furthermore, there are rate limiters for their search functionality.
The aim of our project is to create a faster website that yields more results and faster without having to create an account and eliminate the need to log in - your personal data, therefore, will never be in jeopardy since we are not asking for any of your data and you don't need to provide them to use our site with all of its capabilities.
We created this website with the sole purpose of users being able to search quickly and efficiently in the field of cryptocurrency so they will have access to the latest and most accurate information and thereby assisting the crypto-community at large.
-- phpMyAdmin SQL Dump
-- version 3.3.2deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2011 at 03:34 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.2-1ubuntu4.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `miningfarm`
--
-- --------------------------------------------------------
--
-- Table structure for table `accountBalance`
--
CREATE TABLE IF NOT EXISTS `accountBalance` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userId` int(255) NOT NULL,
`balance` varchar(10) NOT NULL,
`payoutAddress` varchar(255) NOT NULL,
`threshhold` varchar(5) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userId` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `accountBalance`
--
-- --------------------------------------------------------
--
-- Table structure for table `blogPosts`
--
CREATE TABLE IF NOT EXISTS `blogPosts` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`timestamp` int(255) NOT NULL,
`title` varchar(255) NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `blogPosts`
--
INSERT INTO `blogPosts` (`id`, `timestamp`, `title`, `message`) VALUES
(4, 0, 'What we do?', '\r\nmeborder="0" allowfullscreen>\r\n\r\n\r\nFirst off welcome to the "Mining Farm" yo');
u can run your computer to mine an Internet Commodity known as "Bitcoins". These Bitcoins can be used to purchase many things su
ch as Alpaca socks, Webhosting, or even VOIP phone services, the list goes on.
\r\n\r\nWikipedia explains bitcoins a little bi
t better by stating: Bitcoin enables rapid payments (and micropayments) at very low cost, and avoids the need for central authorities a
nd issuers. Digitally signed transactions, with one node signing over some amount of the currency to another node, are broadcast to all
nodes in a peer-to-peer network. A proof-of-work system is used as measurement against double-spending and initial currency distributi
on mechanism.
\r\nWikiePedia Source\r\n
-- --------------------------------------------------------
--
-- Table structure for table `donationList`
--
CREATE TABLE IF NOT EXISTS `donationList` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`locked` int(1) NOT NULL,
`display` varchar(255) NOT NULL,
`bitcoinAddress` varchar(255) NOT NULL,
`coinAddresstype` int(3) NOT NULL COMMENT '1=Bitcoin donation address; 2 = namecoind donation address',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `donationList`
--
INSERT INTO `donationList` (`id`, `locked`, `display`, `bitcoinAddress`, `coinAddresstype`) VALUES
(2, 1, 'Mining Farm (The software this website runs off of)', 'MwSnUuXvrsfa35BSGMhUymtWUkXKSnJie9', 2),
(3, 1, 'Mining Farm (The website software you are using)', '1Fc2ScswXAHPUgj3qzmbRmwWJSLL2yv8Q', 1),
(4, 1, 'RedCross', '1HRQGDVYvQAkVh5xJetKeNfdKYWcx62cKt', 1);
-- --------------------------------------------------------
--
-- Table structure for table `menuAddition`
--
CREATE TABLE IF NOT EXISTS `menuAddition` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`displayTitle` varchar(255) NOT NULL,
`url` varchar(1000) NOT NULL,
`matches` varchar(1000) NOT NULL COMMENT 'This is for matching file names',
`requireLogin` int(1) NOT NULL,
`requireAdmin` int(1) NOT NULL,
`order` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `menuAddition`
--
INSERT INTO `menuAddition` (`id`, `displayTitle`, `url`, `matches`, `requireLogin`, `requireAdmin`, `order`) VALUES
(1, 'Welcome', '/', 'index.php, /', 0, 0, 1),
(2, 'Account Details', '/accountDetails.php', '/accountDetails.php', 1, 0, 3),
(3, 'Statistics', '/stats.php', '/stats.php', 0, 0, 2),
(4, 'Administration', '/adminPanel.php', '/adminPanel.php', 1, 1, 4),
(5, 'User Privileges', '/adminPanel.php?show=editUsers', '/adminPanel.php?show=editUsers', 1, 1, 5),
(6, 'Workers', '/workers.php', '/workers.php', 1, 0, 7),
(11, 'Blog Editor', '/adminPanel.php?show=blogEditor', '/adminPanel.php?show=blogEditor', 1, 1, 12);
-- --------------------------------------------------------
--
-- Table structure for table `networkBlocks`
--
CREATE TABLE IF NOT EXISTS `networkBlocks` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`blockNumber` int(255) NOT NULL,
`timestamp` int(255) NOT NULL,
`txid` varchar(255) NOT NULL,
`confirms` int(255) NOT NULL,
`orphan` int(1) NOT NULL,
`serverFeeCollected` int(1) NOT NULL COMMENT 'Lets blockFound.php know that the server fee was collected from this block to prevent m
ultiple server fee collections',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=400 ;
--
-- Dumping data for table `networkBlocks`
--
-- --------------------------------------------------------
--
-- Table structure for table `pool_worker`
--
CREATE TABLE IF NOT EXISTS `pool_worker` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`associatedUserId` int(255) NOT NULL,
`username` varchar(50) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `pool_worker`
--
-- --------------------------------------------------------
--
-- Table structure for table `shares`
--
CREATE TABLE IF NOT EXISTS `shares` (
`id` bigint(30) NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`epochTimestamp` int(50) NOT NULL,
`rem_host` varchar(255) NOT NULL,
`username` varchar(120) NOT NULL,
`our_result` enum('Y','N') NOT NULL,
`upstream_result` enum('Y','N') DEFAULT NULL,
`reason` varchar(50) DEFAULT NULL,
`solution` varchar(257) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=41452 ;
--
-- Dumping data for table `shares`
--
-- --------------------------------------------------------
--
-- Table structure for table `shares_dead`
--
CREATE TABLE IF NOT EXISTS `shares_dead` (
`id` bigint(30) NOT NULL AUTO_INCREMENT,
`blockNumber` int(255) NOT NULL,
`time` varchar(255) NOT NULL,
`rem_host` varchar(255) NOT NULL,
`username` varchar(120) NOT NULL,
`our_result` enum('Y','N') NOT NULL,
`upstream_result` enum('Y','N') DEFAULT NULL,
`reason` varchar(50) DEFAULT NULL,
`solution` varchar(257) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `shares_dead`
--
-- --------------------------------------------------------
--
-- Table structure for table `shares_history`
--
CREATE TABLE IF NOT EXISTS `shares_history` (
`id` bigint(30) NOT NULL AUTO_INCREMENT,
`shareCounted` int(1) NOT NULL,
`blockNumber` int(255) NOT NULL,
`time` varchar(255) NOT NULL,
`rem_host` varchar(255) NOT NULL,
`username` varchar(120) NOT NULL,
`our_result` enum('Y','N') NOT NULL,
`upstream_result` enum('Y','N') DEFAULT NULL,
`reason` varchar(50) DEFAULT NULL,
`solution` varchar(257) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `shares_history`
--
-- --------------------------------------------------------
--
-- Table structure for table `stats_bitcoinConversionHistory`
--
CREATE TABLE IF NOT EXISTS `stats_bitcoinConversionHistory` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`tradehill` varchar(25) NOT NULL,
`mtgox` int(5) NOT NULL,
`timestamp` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=842 ;
--
-- Dumping data for table `stats_bitcoinConversionHistory`
--
-- --------------------------------------------------------
--
-- Table structure for table `stats_poolMHashHistory`
--
CREATE TABLE IF NOT EXISTS `stats_poolMHashHistory` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`totalMhash` varchar(50) NOT NULL,
`averageMhash` varchar(20) NOT NULL,
`totalValidShares` int(255) NOT NULL,
`timestamp` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6538 ;
--
-- Dumping data for table `stats_poolMHashHistory`
--
-- --------------------------------------------------------
--
-- Table structure for table `stats_topHashers`
--
CREATE TABLE IF NOT EXISTS `stats_topHashers` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userId` int(255) NOT NULL,
`totalHashes` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Dumping data for table `stats_topHashers`
--
INSERT INTO `stats_topHashers` (`id`, `userId`, `totalHashes`) VALUES
(31, 5, 63);
-- --------------------------------------------------------
--
-- Table structure for table `stats_topSharers`
--
CREATE TABLE IF NOT EXISTS `stats_topSharers` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userId` varchar(255) NOT NULL,
`shares` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;
--
-- Dumping data for table `stats_topSharers`
--
'7', 0);
-- --------------------------------------------------------
--
-- Table structure for table `stats_userMHashHistory`
--
CREATE TABLE IF NOT EXISTS `stats_userMHashHistory` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`mhashes` varchar(20) NOT NULL,
`efficiency` varchar(5) NOT NULL,
`timestamp` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18471 ;
--
-- Dumping data for table `stats_userMHashHistory`
--
-- --------------------------------------------------------
--
-- Table structure for table `websiteSettings`
--
CREATE TABLE IF NOT EXISTS `websiteSettings` (
`noreplyEmail` text NOT NULL,
`confirmEmailPrefix` text NOT NULL COMMENT 'The text or HTML written email that is sent for email confirmation',
`browserTitle` varchar(255) NOT NULL,
`cashoutMinimum` varchar(5) NOT NULL COMMENT 'The minimum balance required before a user can cash out',
`serverFeePercentage` varchar(20) NOT NULL COMMENT 'Server fee in percents',
`serverFeeRemoteAddress` varchar(255) NOT NULL COMMENT 'This will house any server fees',
`serverFeeAccountBalance` varchar(255) NOT NULL,
`tradeHillWorth` varchar(20) NOT NULL COMMENT 'Current worth of bitcoins',
`mtgoxWorth` varchar(10) NOT NULL,
`currencyData` varchar(20) NOT NULL COMMENT 'Three letter identifiers what the general default currency should be set too',
`stats_showallusers` int(1) NOT NULL COMMENT 'Although not recommended for commerical sites it is very usefull for private pools',
`enableRequiredEmail` int(1) NOT NULL COMMENT 'Boolean for enabled emails to be authorized',
`coinType` int(3) NOT NULL COMMENT '1=Bitcoin website; 2 = namecoind website'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `websiteSettings`
--
INSERT INTO `websiteSettings` (`noreplyEmail`, `confirmEmailPrefix`, `browserTitle`, `cashoutMinimum`, `serverFeePercentage`, `serverFe
eRemoteAddress`, `serverFeeAccountBalance`, `tradeHillWorth`, `mtgoxWorth`, `currencyData`, `stats_showallusers`, `enableRequiredEmail`
, `coinType`) VALUES
('[email protected]', 'Welcome to the Pool, You must activate your account before we can progress you any further. Click the link bel
ow and type in your credentials(if necessary) then we should be able to activate your account from there and start mining miners. :)\\n
', 'Mining Farm Official Vendor website', '0.02', '1', '', '211', '13.55', '0', 'btc', 1, 0, 2);
-- --------------------------------------------------------
--
-- Table structure for table `websiteUsers`
--
CREATE TABLE IF NOT EXISTS `websiteUsers` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`isAdmin` int(1) NOT NULL,
`disabled` int(1) NOT NULL DEFAULT '0',
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`randomSecret` varchar(10) NOT NULL COMMENT 'Generated at login, this secret secures cookies when hashing',
`sessTimestamp` int(255) NOT NULL COMMENT 'Session timestamp for valid cookie checking',
`loggedIp` varchar(255) NOT NULL COMMENT 'Validating hashed cookies',
`email` varchar(255) NOT NULL,
`emailAuthorised` int(1) NOT NULL DEFAULT '0',
`emailAuthorisePin` varchar(64) NOT NULL,
`authPin` varchar(255) NOT NULL COMMENT 'A pin that must be supplied when changing details to various things',
`failedLoginAttempts` int(5) NOT NULL,
`failedLoginTimestampLock` int(255) NOT NULL COMMENT 'Epoch time until user is allowed access to page',
`apiToken` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `websiteUsers`
--
delimiter $$
CREATE TABLE `pool_worker` (
`ID` int(8) NOT NULL default '100000',
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID_UNIQUE` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$
CREATE TABLE `shares` (
`id` bigint(30) NOT NULL auto_increment,
`time` int(4) NOT NULL,
`rem_host` varchar(255) NOT NULL,
`username` varchar(120) NOT NULL,
`our_result` enum('Y','N') NOT NULL,
`upstream_result` enum('Y','N') default NULL,
`reason` varchar(50) default NULL,
`solution` varchar(255) NOT NULL,
`timestamp` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1$$
delimiter $$
CREATE TABLE `pool_worker` (
`ID` int(8) NOT NULL default '100000',
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID_UNIQUE` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$
CREATE TABLE `shares` (
`id` bigint(30) NOT NULL auto_increment,
`time` int(4) NOT NULL,
`rem_host` varchar(255) NOT NULL,
`username` varchar(120) NOT NULL,
`our_result` enum('Y','N') NOT NULL,
`upstream_result` enum('Y','N') default NULL,
`reason` varchar(50) default NULL,
`solution` varchar(255) NOT NULL,
`timestamp` timestamp NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1$$
-- phpMyAdmin SQL Dump
-- version 3.3.10.2
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 23 Jul 2011 om 06:28
-- Serverversie: 5.0.92
-- PHP-Versie: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `pool_worker` (
`username` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `pool_worker` (`username`, `password`) VALUES
('test', 'test');
CREATE TABLE IF NOT EXISTS `shares` (
`id` bigint(30) NOT NULL auto_increment,
`time` int(4) NOT NULL,
`rem_host` varchar(255) NOT NULL,
`username` varchar(120) NOT NULL,
`our_result` enum('Y','N') NOT NULL,
`upstream_result` enum('Y','N') default NULL,
`reason` varchar(50) default NULL,
`solution` varchar(257) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=344576 ;
Listening on host :: port 8342
Listening on host :: port 8347
Listening on host :: port 8344
Listening on host 127.0.0.1 port 8338
initialized
mysql sharelog failed at execute
shutting down