Bitcoin Forum
November 12, 2018, 09:22:59 PM *
News: Latest Bitcoin Core release: 0.17.0 [Torrent].
 
  Home Help Search Login Register More  
  Show Posts
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 39 40 41 42 43 44 45 46 47 48 »
1  Other / Beginners & Help / Re: Green Trust Rate? on: Today at 05:48:05 AM

You cannot buy it. If you try to buy it then you will get  negative trust.
Trust  system is generally for "Marketplace" in this forum.
 If you do successful trade then you might get green trust but if it is suspected that you are doing trade for farming trust then again you can gain -ve trust.
So do trade honestly might you create a name and reputation for yourself.
2  Economy / Speculation / Re: Wall Observer BTC/USD - Bitcoin price movement tracking & discussion on: Today at 05:09:45 AM
Your posts look pretty pretty good and the octosphincter is sated. Choose a picture you would want as an avatar and comrade homer might put it on a cap for you.

Thanks for your words.

Bright Orange Bitcoin logo in Royal Navy Blue hat will definitely make  my day.

https://en.bitcoin.it/wiki/File:BC_Logo_.png

Did I do it right?



Avatar-sized




Thank you xhomerx10 . I love it. Absolutely fantastic.
3  Other / Meta / Re: Ranking based on Merit received by distinct users. on: November 11, 2018, 02:49:04 PM
This is very interesting
Can you show me what this top 50 list looks like if you subtract  merits from those that are currently on that list and then currently top 200 merit holders.

Query for original top 200 .
Code:
select u1.username, A.toid,A.summerit from userdata u1 ,(select m.toid,sum(m.Merit) summerit from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A ) and u1.userid=A.toid;
New Top 200 list after removing the Merit given by Top 200  

Code:
select u1.username,sum(r.merit) from Meritdata r, userdata u1 where r.fromid not in ( select A.toid from (select m.toid,sum(m.Merit) from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A ) and u1.userid=r.toid
group by u1.username order by sum(r.merit) desc limit 200;
   

Below spreadsheet  contain the list original top 200 and the new top 200 will look like

https://docs.google.com/spreadsheets/d/1SAi_b3umCcFJO2dMoLYjWCjNz1JhOLWrsRHhYQK-nb8/edit?usp=sharing


What % of merit given out by the top 100 goes to others that are not in the top 100


Code:
select sum(A.summerit) from (select sum(m.Merit) summerit  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100) A ;
48648  total merit recieved by top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 );  
47776  Total merit given by top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 )
and  m1.toid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 ) ;    
15903 is total number of merit given by top 100 to top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 )
and  m1.toid not in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 ) ;  
31873 is total number of merit given by top 100 that are not in top 100

so (15093/47776)*100 = 31.59%  of merit top 100 is given to top 100



what % of merit given out by the top 200 goes to others that are not in the top 200


Code:
select sum(A.summerit) from (select sum(m.Merit) summerit  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200) A ;  
69120 is total merit recieved by top 200.

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 );  

65641 total merit given by top 200.


select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 )
and  m1.toid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 ) ;  
29958 is total merit given by top 200 to top 200.

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 )
and  m1.toid not in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 ) ;  

35683 is total merit given by top 200 that are not in top 200.


So (29958/65641)*100 =45.63% of merit top 200 is given to top 200




4  Other / Meta / Re: Ranking based on Merit received by distinct users. on: November 11, 2018, 02:44:34 PM
Could someone combine this with the other statistics about users who received merits in most different sections?

You just need the minor modification in the first query to get this result . This result set is interesting because "theymos" is not the leader now.

From the data of sub boards "Suchmoon" is clearly at top, being merited at 15 subboard.

Query used:
Code:
select u.username,count (distinct m.subboard)  from userdata u,meritdata m where u.userid=m.toid
group by u.username having count (distinct m.subboard) >=5  order by count (distinct m.subboard) desc

Result set:
Code:
UserName count (distinct m.subboard)
suchmoon 15
NeuroticFish 14
hugeblack 14
theymos 14
LeGaulois 13
LoyceV 13
bill gator 13
bitmover 13
gentlemand 13
vit05 13
ETFbitcoin 12
Heisenberg_Hunter 12
Lauda 12
Leteravian 12
OgNasty 12
OmegaStarScream 12
Quickseller 12
Steamtyme 12
iasenko 12
nc50lc 12
seoincorporation 12
xtraelv 12
DarkStar_ 11
Direwolve735 11
HeRetiK 11
Jet Cash 11
The Pharmacist 11
TheQuin 11
aleksej996 11
eternalgloom 11
jhenfelipe 11
mdayonliner 11
mocacinno 11
o_e_l_e_o 11
BitCryptex 10
HCP 10
Parodium 10
TryNinja 10
Vod 10
amishmanish 10
butka 10
coinlocket$ 10
franky1 10
joniboini 10
marlboroza 10
mjglqw 10
shahzadafzal 10
stompix 10
vlad230 10
xhomerx10 10
BTCforJoe 9
DireWolfM14 9
Don Pedro Dinero 9
European Central Bank 9
Gleb Gamow 9
Lafu 9
Samarkand 9
Seetheummerallyeah 9
Thirdspace 9
Trofo 9
bitperson 9
bones261 9
cryptothief 9
d5000 9
mindrust 9
odolvlobo 9
r1s2g3 9
steve_rogers 9
theyoungmillionaire 9
tmfp 9
AverageGlabella 8
BitcoinTurk 8
ChiBitCTy 8
DannyHamilton 8
DaveF 8
DdmrDdmr 8
DooMAD 8
EcuaMobi 8
Flying Hellfish 8
Foxpup 8
Kate Beckett 8
KingScorpio 8
LTU_btc 8
Last of the V8s 8
LastJedi 8
LogitechMouse 8
Raja_MBZ 8
RivAngE 8
RodeoX 8
Sellingaccs 8
Thekool1s 8
adaseb 8
alani123 8
alia 8
aoluain 8
athanz88 8
atrocityx 8
buwaytress 8
edgycorner 8
guybrushthreepwood 8
harizen 8
iluvbitcoins 8
legendster 8
nullius 8
pawel7777 8
paxmao 8
philipma1957 8
pooya87 8
shield132 8
shorena 8
squatter 8
wwzsocki 8
AdolfinWolf 7
Anon136 7
BitMaxz 7
Bonakid 7
Branko 7
CarlosCorreia 7
Carlton Banks 7
Crypto Girl 7
Daboy_Lyle 7
Elwar 7
EthanB 7
Gummybear67 7
Hueristic 7
Kakmakr 7
Kemarit 7
Lucius 7
MadGamer 7
Makkara 7
Mpamaegbu 7
Nestade 7
OriginTrain 7
Paractor 7
Piggy 7
Pursuer 7
RGBKey 7
Slow death 7
Speculatoross 7
TMAN 7
Theb 7
Welsh 7
Wind_FURY 7
Wipro 7
YuTü.Co.in 7
asche 7
audaciousbeing 7
big_daddy 7
bob123 7
cellard 7
criptix 7
denis-z12 7
digaran 7
dooglus 7
eddie13 7
figmentofmyass 7
green547 7
hilariousandco 7
hilariousetc 7
ibminer 7
jackg 7
kenzawak 7
khufuking 7
macartem 7
mithrim 7
nngella 7
orkoso 7
poptok1 7
ranman09 7
spirali 7
sud 7
vapourminer 7
vphasitha01 7
yojodojo21 7
1Referee 6
ACVinegar 6
AngelSky 6
ArkiCrypto 6
Astargath 6
Avirunes 6
BTCMILLIONAIRE 6
Baofeng 6
Baoo 6
BayAreaCoins 6
Beerwizzard 6
BenOnceAgain 6
BillyBobZorton 6
BitcoinFX 6
Bitfort 6
BlockEye 6
Blue Tyrant 6
BobLawblaw 6
BrewMaster 6
CoinEraser 6
Dabs 6
Dread Pirate Roberts 6
Fazlurkhan.kz 6
Flodner 6
FrueGreads 6
Furgon Chino 6
Harlot 6
Hhampuz 6
Hydrogen 6
Jating 6
JayJuanGee 6
Joel_Jantsen 6
Kevin77 6
Kprawn 6
LFC_Bitcoin 6
Liza Soberano 6
LtMotioN 6
Lutpin 6
Neelix 6
Pleione527 6
Pmalek 6
QuestionAuthority 6
SFR10 6
Searing 6
Silent26 6
TECSHARE 6
Taras 6
TeQuiero 6
ThePunisher49X 6
Upgrade00 6
Zandar 6
Zwei 6
achow101 6
ahmad21 6
allahabadi 6
ausbit 6
bbc.reporter 6
bitChipper 6
bitart 6
bitbunnny 6
cissrawk 6
coin8coin8 6
crairezx20 6
crwth 6
crypmike 6
cryptohunter 6
cynical 6
dado7 6
darkangel11 6
dreamax25 6
finaleshot2016 6
friends1980 6
fxstrike 6
haroldtee 6
jseverson 6
jtipt 6
julerz12 6
killyou72 6
kirreev070 6
leea-1334 6
levyashin 6
lolchina 6
maarx 6
markj113 6
mattcode 6
mrcash02 6
mu_enrico 6
nutildah 6
pvk444 6
qwk 6
reflector 6
richardsNY 6
roll on 6
shasan 6
siddartha1492 6
squatz1 6
veleten 6
vladimirhf 6
1993jochico 5
2112 5
8Habits 5
AGD 5
Aikidoka 5
Ale88 5
Altcoindealer 5
Aura 5
BTCHadzija 5
BTCLovingDude 5
BTCeminjas 5
BTRIC 5
Barcode_ 5
BitPotus 5
BitcoinHodler 5
BitcoinSupremo 5
Bushrat Jahan 5
Cobalt9317 5
Cocojam0610 5
Coding Enthusiast 5
CoinClarity 5
Coin_trader 5
Coolcryptovator 5
CryptoBry 5
CryptopreneurBrainboss 5
DimaS1574 5
F2b 5
Febo 5
Gavin Andresen 5
Globb0 5
Guvn0r 5
HabBear 5
Hazaki 5
Helana 5
Heyyyrenz 5
Initscri 5
InvoKing 5
JohnUser 5
JollyGood 5
Jrashid 5
Juggy777 5
JungleOnion 5
Karartma1 5
Klara_karlovna 5
KonstantinosM 5
Lovecove 5
MagicSmoker 5
Mardoker135 5
Mind Control 5
Minnie1928 5
MoonIsBlue 5
Moxivuki 5
NadiaHel 5
Naida_BR 5
Patatas 5
Protected101 5
PsylockReborn 5
Red-Apple 5
S3cco 5
STT 5
SaltySpitoon 5
SergiuDemerji 5
Squishy01 5
Sutters Mill 5
SyGambler 5
TheArchaeologist 5
TheNewAnon135246 5
TheUltraElite 5
Timelord2067 5
TimtheYoutuber 5
TitanAI 5
Titus Maximus 5
TravelMug 5
Traxo 5
Tszunami98 5
Tyrantt 5
Whosdaddy 5
Xynerise 5
Yantoaja 5
Zapo 5
aTriz 5
ace4549 5
actmyname 5
aencarnaci 5
aliashraf 5
allohha 5
alyssa85 5
angel55 5
anjho.ace 5
apoorvlathey 5
bL4nkcode 5
bakasabo 5
baricuri 5
batang_bitcoin 5
botany 5
btc_angela 5
btcltcdigger 5
celtic99 5
coly20032003 5
coolws 5
cry4crypto 5
crypto mania 5
cryptoaddictchie 5
deevan 5
dogtana 5
dothebeats 5
dumbtool45 5
examplens 5
fillippone 5
gmaxwell 5
gunhell16 5
hase0278 5
hous26 5
hubballi 5
hurry_hore 5
iambakov 5
infofront 5
iqlimasyadiqa 5
irfan_pak10 5
jemarleon 5
jjeeppeerrxx 5
jojo69 5
jonemil24 5
jossiel 5
jvdp 5
k0er 5
kiemnhieutien 5
kjnfmplm 5
klaaas 5
knight20 5
kpcian 5
krishnapramod 5
krogothmanhattan 5
kzv 5
leowonderful 5
loicuagio1979 5
magneto 5
magpie_lover 5
malikusama 5
max2607 5
mazdafunsun 5
mharz 5
mikeywith 5
mikfresh 5
minerjones 5
mprep 5
nafantc 5
onrise 5
owlcatz 5
pixie85 5
psycodad 5
pugman 5
qiwoman2 5
rajurathod18 5
ralle14 5
ranochigo 5
raske 5
rhamzter 5
sapta 5
silent17 5
sirazimuth 5
slaman29 5
sluppy 5
sncc 5
solarion 5
ss890 5
starmyc 5
stomachgrowls 5
supermine 5
swogerino 5
tactac 5
target 5
tbct_mt2 5
thehun 5
timoshani 5
togoshigekata 5
tomahawk9 5
tvplus006 5
tylerderden 5
tyz 5
upsidedown75 5
vella85 5
vlom 5
vv181 5
xdrpx 5
yahoo62278 5
zazarb 5
zickle 5


Edited  the query, and result set. (Actually Discrepancy caused due to deleted messages)
Even for boards, theymos is not the winner and couple bunch of users tying the spot , being merited in 6 5 Boards. Some of users here getting benefit of posting in Local board.

Query used
Code:
select u.username,count (distinct m.board)  from userdata u,meritdata m where u.userid=m.toid and m.board not in ('Message DELETED!')
group by u.username having count (distinct m.board) >=4  order by count (distinct m.board) desc;

Result set:
Code:
UserName count (distinct m.board)
Anon136 5
ArkiCrypto 5
Daboy_Lyle 5
DarkStar_ 5
Direwolve735 5
DooMAD 5
Dread Pirate Roberts 5
ETFbitcoin 5
Gleb Gamow 5
Gummybear67 5
HCP 5
Heisenberg_Hunter 5
Kate Beckett 5
KingScorpio 5
Lafu 5
Lauda 5
LeGaulois 5
Liza Soberano 5
LogitechMouse 5
Lutpin 5
NeuroticFish 5
OmegaStarScream 5
RivAngE 5
Samarkand 5
Thirdspace 5
Trofo 5
TryNinja 5
anjho.ace 5
bitmover 5
cissrawk 5
coinlocket$ 5
crairezx20 5
d5000 5
denis-z12 5
edgycorner 5
fxstrike 5
harizen 5
hugeblack 5
iasenko 5
joniboini 5
macartem 5
marlboroza 5
mdayonliner 5
mindrust 5
nc50lc 5
pawel7777 5
paxmao 5
poptok1 5
ranman09 5
rhamzter 5
roll on 5
seoincorporation 5
shahzadafzal 5
spirali 5
steve_rogers 5
suchmoon 5
sud 5
timoshani 5
tmfp 5
vit05 5
vlad230 5
wwzsocki 5
xtraelv 5
yojodojo21 5
1Referee 4
1miau 4
8Habits 4
AdolfinWolf 4
AlisaWhishie 4
Analyst101 4
AngelSky 4
Aura 4
AverageGlabella 4
Avirunes 4
BTCHadzija 4
Baofeng 4
Barcode_ 4
BayAreaCoins 4
Beerwizzard 4
BillyBobZorton 4
BitCryptex 4
BitMaxz 4
BitcoinArsenal 4
BitcoinFX 4
BitcoinTurk 4
BobLawblaw 4
Bonakid 4
CarlosCorreia 4
Cobalt9317 4
Coffee135 4
CoinClarity 4
CoinEraser 4
Coin_trader 4
Crypto Girl 4
CryptoBry 4
CryptoGamblingSites 4
Crypto_Sassy 4
Dabs 4
DaveF 4
DdmrDdmr 4
DimaS1574 4
Don Pedro Dinero 4
EcuaMobi 4
Elwar 4
European Central Bank 4
F2b 4
FlightyPouch 4
Flodner 4
Flying Hellfish 4
FrueGreads 4
GDragon 4
Gordante12 4
HabBear 4
HeRetiK 4
Hueristic 4
Hydrogen 4
Jating 4
JayJuanGee 4
JeremyB 4
Joel_Jantsen 4
Kakmakr 4
Kprawn 4
LTU_btc 4
Last of the V8s 4
LastJedi 4
LoyceV 4
Lucius 4
MadGamer 4
Makkara 4
ManaMan 4
Mc_Moneysack 4
Mind Control 4
Minnie1928 4
Moxivuki 4
Mpamaegbu 4
Mycrypto1222 4
Neelix 4
Neo-Design 4
Nestade 4
OgNasty 4
OriginTrain 4
Paractor 4
Patatas 4
Piggy 4
Pleione527 4
Pmalek 4
ProofOfLambo 4
Protected101 4
PsylockReborn 4
Pursuer 4
Quarantine34 4
Quickseller 4
RGBKey 4
Raja_MBZ 4
RodeoX 4
S3cco 4
SFR10 4
STT 4
Seetheummerallyeah 4
Sellingaccs 4
Silent26 4
Slow death 4
Speculatoross 4
Star_Bucks 4
StartupAnalyst 4
Steamtyme 4
Tankdestroyer 4
Taras 4
Tekno2020 4
The Pharmacist 4
Thekool1s 4
TimtheYoutuber 4
TitanAI 4
ToTheMoon_XOM9IK 4
Traxo 4
Tszunami98 4
Tyr808 4
Upgrade00 4
Urbinklin 4
Vod 4
Wind_FURY 4
Yantoaja 4
Zandar 4
Zebra.Guy 4
ace4549 4
ahmad21 4
aleksej996 4
amishmanish 4
android17 4
aoluain 4
asche 4
athanz88 4
bL4nkcode 4
bakasabo 4
bbc.reporter 4
bill gator 4
bitChipper 4
bitbunnny 4
bitperson 4
blackmagical 4
bob123 4
bones261 4
btc-facebook 4
btcrut2017 4
butka 4
buwaytress 4
cellard 4
codemanX 4
coin8coin 4
coin8coin8 4
coinycoiny 4
coly20032003 4
coolws 4
criptix 4
crwth 4
crypmike 4
cryptohunter 4
cryptothief 4
cynical 4
dado7 4
deadley 4
dooglus 4
electrobit 4
empoy 4
eternalgloom 4
examplens 4
fanatic26 4
fanatic26_ 4
fattyforhire 4
fillippone 4
finaleshot2016 4
franky1 4
gentlemand 4
green547 4
hagiyatmaz 4
haroldtee 4
hilariousandco 4
hilariousetc 4
hopenotlate 4
hubballi 4
ibminer 4
icalical 4
iillaa 4
infofront 4
inv_ker 4
jbreher 4
jhenfelipe 4
jhongzjhong 4
jinksters09 4
john1010 4
jojo69 4
jossiel 4
jseverson 4
julerz12 4
jvdp 4
k0er 4
kenzawak 4
kevoh 4
khufuking 4
kjnfmplm 4
kzv 4
leowonderful 4
loicuagio1979 4
lok8nusa 4
lordquanta 4
lovesybitz 4
maarx 4
mattcode 4
metenjean 4
mharz 4
mikeywith 4
mikfresh 4
mimienamphine 4
mithrim 4
mjglqw 4
mocacinno 4
moneyangel 4
mu_enrico 4
nlcars 4
npredtorch 4
nullius 4
o_e_l_e_o 4
odolvlobo 4
onrise 4
orkoso 4
otandelapaz 4
philipma1957 4
pixie85 4
pugman 4
pvk444 4
qwk 4
ralle14 4
rickbig41 4
rillater 4
ruthbabe 4
sapta 4
sham100899 4
shield132 4
shorena 4
shulio 4
sidehack 4
silent17 4
squatz1 4
ss890 4
stompix 4
swogerino 4
tactac 4
target 4
theymos 4
theyoungmillionaire 4
tim-bc 4
tylerderden 4
vapourminer 4
veleten 4
wantjokull 4
waqasniaz007 4
xhomerx10 4
yahoo62278 4
ymemey 4
zenrol28 4
zlatan07 4
zoran.drobnjak 4
5  Other / Meta / Re: Ranking based on Merit received by distinct users. on: November 11, 2018, 11:26:23 AM
Interesting data presented. 
Really glad to see following members got 100% merits from different Merit senders (1 merit from each merit sender)
162   Claymore   50
163   Daboy_Lyle   50
164   butka   50
165   cAPSLOCK   50
166   kaar   50


 

This simply means that they are merited by 50 distinct users in this forum. It does not mean that there total merits are 50.
6  Other / Meta / Re: How recognized are you in the bitcointalk world? on: November 11, 2018, 10:55:53 AM
There is a rare bug that sometimes awards the merit to the wrong person in a certain situation.

As soon as I launch Trust stats next week, I will squash it.

I have all the correct merit records - I just need to recalculate who the merit was sent to.

I noticed this bug tends to add Merit on the account of Thread Starter instead of the user who commented in that thread and got merited for its comment.
I think this bug is triggered (not sure) if that user merited the OP.
7  Other / Meta / Re: If merit is like A lottery jackpot then it could be so hard to acquire! on: November 11, 2018, 10:44:17 AM
   
Legendary rank has 333.33 % chance on getting 1 merit for it has only few number of users reaches this rank. Newbie and jr. member has the lowest chance of getting merit with only 1.29% and 8.92 chance on getting 1 merit respectively.

From Piggy Database
Code:
Select count(*) from (
Select u.username,sum(m.merit) from userdata u,Meritdata M where u.rank='Legendary' and u.userid=m.toid group by u.username )A;

count come as 1185.  So even having 333.3% more chances , only 56% of legendary are able to get merits.
For Jr.Member it is 100% because new system make you Jr.Member When you get one merit.

I could be attest to the demoted to newbie rank users and now was able to rank up to member.

Are you sure? I am seeing you as Jr. Member Smiley Smiley
8  Other / Meta / Re: Ranking based on Merit received by distinct users. on: November 11, 2018, 10:00:39 AM
I think instead of just looking in the Merits only data of a poster, we should combine it with the number of user that merited that poster to achieve that rank . Poster merited with by multiple user should be worthy of reading instead of somebody getting merits with multiple by few users.

Are you suggesting we create another parameter added to users profiles that would display the number unique members who have merited them?

Of course users who have received merits from multiple users are given credits, but a lot of statistics affect that.
Including when the user joined, as some members have gone inactive, who would have otherwise merited them.
And I don't see why we should place extra attention on it.

I would also have a 100% record by the way. as I have only received merits from unique members.  Grin

Fixed the typo in my OP.
I am not saying to add anything and I am just pointing that when the user gathered 100+ merits it is interesting to see this data. This data actually points if user is really popular or just received few big transactions from some individual. I have encountered an example where user become "Full Member" by just 3 incoming Merit transaction.  This statistics will filter them out.

I only recognize "pitipawn" as Merit abuser who has made up in this list.


--snip--
I guess, in other words it is index of "Proof of Acceptability".
9  Economy / Services / Re: [Merit] Fetch me advertising network information on: November 11, 2018, 05:29:30 AM

I've asked here about it; https://bitcointalk.org/index.php?topic=5053056.msg47030825#msg47030825

If you want to report the thread, it'd be interesting to "arbitrate". I was thinking it belongs in the "altcoin" market because merit is just another sort of digital token.

It is not about my reporting or not reporting. I just like to warn you that every individual see the situation differently. Though few agrees with you and few do not.
Do not risk  your account for -ve trust for checking what responses a merit can bring it to you. 
If some DT decided to give you -ve then you will left with only option to talk with that DT and that DT member wish. Forum administration will not be any help to you. Just a advice for you , avoid doing the things (or test community) in which community is divided.
10  Other / Meta / Re: what's this account ?? on: November 11, 2018, 05:12:04 AM
Just read about below topic and everything will be clear to you.

https://bitcointalk.org/index.php?topic=603586.0

Long back, this forum used to give scammer tag to user who scams. But theymos decided to remove this tag and created a "DT1" account  "OldScammerTag" and give the -ve trust from that account.

If you read the trusted feedback received and sent from that account, then everything will be clear to you.
11  Other / Beginners & Help / Re: Technical Perspective of bitcoins. on: November 11, 2018, 04:52:55 AM
--snip--
Thanks for pointing to that post.


Like every other notable invention. The idea stems from a long line of bright minded individuals, who have started and built on an idea.
Full credit of course goes to the inventor, but others deserve notable mentions.


Actually , my main aim in this article is to bring forward the point that bitcoin is a advanced product in modern computing word. If you read the topics about bitcoin,most of them are fully trash that just point you to buy bitcoin because it is rising in value. These type of articles and people making bitcoin to look like some kind of a "ponzi" scheme.

It is very important to advocate bitcoin salient technological feature instead of promoting like that "Buy for 'x' today and sell it for '10x' tomorrow "
12  Other / Meta / Ranking based on Merit received by distinct users + stats requested by users. on: November 11, 2018, 04:31:41 AM
I saw lot of  user in this forum has  interest  in reading the merited post only but I do not think it is not a correct solution because this option is not available as well is it will break the coherency of the discussion.

Some people have suggestion to read the most merited post but I guess some of the ANN threads merited with 50 merits by a single user is skewing the statistics of both the thread and user.

I think instead of just looking in the Merits only data of a poster, we should combine it with the number of user that merited that poster to achieve that rank . Poster merited with by multiple user should be worthy of reading instead of somebody getting merits with multiple by few users.

So with the help of the Piggy Sql Tool, I created a list of posters who are atleast merited by 50 distinct users. Theymos is at top with 565 distinct user meriting Theymos. Overall only 166 postersexists in this list that are merited by 50 or more user of this forum.

Code:
Rank UserName count (distinct m.fromid)
1 theymos 565
2 LoyceV 232
3 Vod 201
4 explorder 192
5 Jet Cash 187
6 DdmrDdmr 158
7 The Pharmacist 156
8 hilariousetc 150
9 bill gator 147
10 suchmoon 147
11 yahoo62278 145
12 satoshi 144
13 Lutpin 141
14 TMAN 141
15 iasenko 136
16 ui_zakharchenko 133
17 nullius 132
18 TheQuin 131
19 bitmover 127
20 xtraelv 124
21 OgNasty 121
22 Last of the V8s 120
23 Lauda 117
24 gentlemand 115
25 o_e_l_e_o 115
26 DarkStar_ 114
27 tvplus006 114
28 LeGaulois 113
29 Piggy 113
30 qwk 112
31 TryNinja 111
32 HCP 109
33 achow101 109
34 marlboroza 109
35 BTCforJoe 108
36 JayJuanGee 108
37 theyoungmillionaire 108
38 Smart man 104
39 coinlocket$ 103
40 krogothmanhattan 103
41 Coolcryptovator 101
42 joniboini 99
43 kirreev070 98
44 mdayonliner 98
45 franky1 96
46 stompix 96
47 Hhampuz 95
48 micgoossens 94
49 pugman 94
50 QuestionAuthority 92
51 pooya87 92
52 HairyMaclairy 91
53 DannyHamilton 90
54 hilariousandco 90
55 sncc 89
56 xhomerx10 89
57 Ranyar 88
58 hugeblack 88
59 HeRetiK 87
60 zentdex 87
61 BobLawblaw 86
62 Torque 84
63 d5000 84
64 infofront 84
65 killyou72 84
66 actmyname 83
67 pandukelana2712 83
68 AlyattesLydia 82
69 Welsh 82
70 Carlton Banks 81
71 Silent26 81
72 athanz88 81
73 mocacinno 79
74 deeperx 78
75 jojo69 78
76 Elwar 77
77 SFR10 77
78 cellard 77
79 mfort312 77
80 mjglqw 77
81 bob123 76
82 buwaytress 76
83 1Referee 75
84 crypmike 75
85 vit05 75
86 Xynerise 74
87 Kakmakr 73
88 Mitchell 73
89 philipma1957 73
90 DooMAD 72
91 dbshck 72
92 Matthias9515 71
93 Steamtyme 71
94 Flying Hellfish 70
95 lemonrabid 69
96 ETFbitcoin 68
97 vlad230 68
98 EcuaMobi 67
99 Heisenberg_Hunter 67
100 AdolfinWolf 66
101 Samarkand 66
102 BitCryptex 65
103 GameKyuubi 65
104 TERA2 65
105 amishmanish 65
106 PHI1618 64
107 paxmao 64
108 Hakamura 62
109 Hydrogen 62
110 ToTheMoon_XOM9IK 62
111 Toxic2040 62
112 OmegaStarScream 61
113 PavelRostov 61
114 bones261 61
115 mindrust 61
116 nc50lc 61
117 shorena 61
118 600watt 60
119 Joel_Jantsen 60
120 bolshojkush 60
121 finaleshot2016 60
122 ibminer 60
123 Co1n 58
124 Goran_ 58
125 Husna QA 58
126 LFC_Bitcoin 58
127 Sylon 58
128 odolvlobo 58
129 pitipawn 58
130 Trofo 57
131 numanoid 57
132 shahzadafzal 57
133 Coin-1 56
134 figmentofmyass 56
135 mithrim 56
136 Ariem 55
137 squatter 55
138 tonych 55
139 Anon136 54
140 BrewMaster 54
141 gmaxwell 54
142 hirozaki faraday 54
143 poptop 54
144 r1s2g3 54
145 taikuri13 54
146 Quickseller 53
147 Speculatoross 53
148 aTriz 53
149 roycilik 53
150 sapta 53
151 BitcoinTurk 52
152 Raja_MBZ 52
153 jseverson 52
154 mu_enrico 52
155 EFS 51
156 MagicSmoker 51
157 Wind_FURY 51
158 chimk 51
159 eternalgloom 51
160 mole0815 51
161 sabotag3x 51
162 Claymore 50
163 Daboy_Lyle 50
164 butka 50
165 cAPSLOCK 50
166 kaar 50

Link to spreadsheet : https://docs.google.com/spreadsheets/d/1e4jPEvdWsJItPmnFKLBK7VmUzM1ONdrFyR_-rDaDtao/edit?usp=sharing

Query used for this data (I used 50 in query, you can increase or decrease the number)
Code:
select u.username,count (distinct m.fromid)  from userdata u,meritdata m where u.userid=m.toid
group by u.username having count (distinct m.fromid) >=50  order by count (distinct m.fromid) desc ;


Now if you are interested about the distributions of merits received by the poster by different users  , then you can use the below query to see the distribution. I used "theymos"  and data shows that "Foxpup" is top merit sender to "theymos". Make sure to use the exact forum name because data in database is case-sensitive.

Query used:
Code:
select A.sum_merits,f.* from
(select sum(m.merit) sum_merits ,m.fromid fid from userdata u,meritdata m where u.userid=m.toid and u.username='theymos' group by m.fromid ) A,userdata f where f.userid=A.fid
order by A.sum_merits desc;

theymos Merit sender
Code:
sum_merits UserId UserName Rank
136 55384 Foxpup Legendary
96 51173 mprep Global Moderator
74 30747 Vod Legendary
66 158505 roslinpl Legendary
50 6822 Scorpion Hero Member
50 81995 peloso Legendary
50 140584 EFS Staff
50 183495 otrkid70 Legendary
50 340026 sofu Legendary
50 346731 minerjones Copper Member
50 406631 Kiritsugu Legendary
50 662288 Palider Hero Member
39 234771 suchmoon Legendary
35 18321 OgNasty Donator
35 459836 LoyceV Legendary
33 553678 rickbig41 Global Moderator
32 358020 Quickseller Copper Member
32 880238 Angelo Santos Sr. Member
32 914465 crwth Sr. Member
30 76847 notaek Legendary
29 915303 TheDistrictsProject Sr. Member
28 164822 hilariousandco Global Moderator
25 81419 ny2cafuse Legendary
25 175302 Avirunes Copper Member
25 390370 keesdewit Copper Member
25 548195 Topknotbam Legendary
25 558519 socks435 Legendary
22 402366 Betwrong Legendary
21 521899 SFR10 Legendary
20 214323 ltcrstrbrt Legendary
20 808310 batang_bitcoin Hero Member
19 23092 malevolent Staff
18 211419 redsn0w Legendary
18 527272 Wapinter Copper Member
18 747519 Sponsoredby15 Sr. Member
16 325061 pugman Legendary
16 355846 yahoo62278 Legendary
16 525058 InvoKing Legendary
15 140827 yogg Legendary
15 219961 --Encrypted-- Copper Member
15 381705 cellard Legendary
15 507936 DarkStar_ Legendary
15 755235 arwin100 Hero Member
15 836384 Frenk Best Hero Member
15 1192397 paxmao Sr. Member
14 153634 dbshck Staff
13 359658 hahay Legendary
13 875360 BicolIsarog Sr. Member
13 1291828 iasenko Sr. Member
12 364070 bitbollo Legendary
12 884853 BlackMambaPH Hero Member
11 397611 Jeremycoin Legendary
11 885934 SamReomo Sr. Member
10 55122 DiamondCardz Legendary
10 97213 deadley Legendary
10 125554 mishax1 Legendary
10 129114 xIIImaL Legendary
10 197395 fearcoka Hero Member
10 334527 izanagi narukami Legendary
10 359716 ETFbitcoin Legendary
10 369699 grandFX Legendary
10 458393 harizen Legendary
10 539350 crairezx20 Legendary
10 557413 chichidori Legendary
10 561804 JanpriX Hero Member
10 661339 Zocadas Hero Member
10 810882 BALIK Copper Member
10 826292 carlisle1 Hero Member
10 851885 jerald125 Hero Member
10 947291 Polar91 Sr. Member
10 969327 Anon11073 Staff
10 986141 Vishnu.Reang Sr. Member
10 1003345 ChipMixer Full Member
9 78147 Cyrus Administrator
9 84866 ibminer Legendary
9 697888 Script3d Hero Member
9 976210 nullius Copper Member
8 24140 qwk Donator
8 151761 CoinCube Legendary
8 249495 Cøbra Member
8 452769 bones261 Legendary
8 543626 jackg Copper Member
8 765632 bL4nkcode Copper Member
7 5797 grue Legendary
7 20174 fcmatt Legendary
7 176777 mindrust Legendary
7 379487 LFC_Bitcoin Copper Member
7 410218 ashmodeus Hero Member
7 543848 newinbtc Legendary
7 806776 digaran Hero Member
7 897509 xtraelv Sr. Member
7 1059021 Arteezy.rtx Copper Member
6 98986 TMAN Hero Member
6 133846 monbux Legendary
6 317618 nutildah Legendary
6 333524 numanoid Legendary
6 372359 krishnapramod Legendary
6 465017 actmyname Copper Member
6 553037 jhenfelipe Hero Member
6 782831 akamit Hero Member
6 841337 shield132 Hero Member
6 884600 Dahman El_Harrachi Hero Member
6 971594 centralbanksequalsbombs Sr. Member
6 1000199 krogothmanhattan Hero Member
6 1188543 o_e_l_e_o Sr. Member
5 554 Elwar Legendary
5 21178 MintCondition Legendary
5 68448 KonstantinosM Hero Member
5 71414 mnightwaffle Hero Member
5 84521 Welsh Staff
5 85981 Abdussamad Legendary
5 113670 Mitchell Staff
5 137541 twbt Legendary
5 140736 nydiacaskey01 Legendary
5 156391 abel1337 Legendary
5 161390 Cloudpost Hero Member
5 173873 xxxgoodgirls Legendary
5 252510 JayJuanGee Legendary
5 372697 Punggawa Legendary
5 393354 julian071 Hero Member
5 397737 hilariousetc Legendary
5 462517 Landak Hero Member
5 516752 DaddyMonsi Legendary
5 519783 asu Hero Member
5 535215 ralle14 Legendary
5 553066 BlockEye Legendary
5 579628 bob123 Hero Member
5 698159 Jet Cash Legendary
5 757564 Bitcoinsummoner Hero Member
5 805497 CREATIVE_Life Hero Member
5 809963 Wowcoin Hero Member
5 838716 bubblebit Sr. Member
5 849178 Mapagmahal Copper Member
5 857883 Yatsan Hero Member
5 888861 merlyn22 Hero Member
5 894829 0t3p0t Sr. Member
5 895005 Cacingkemi Hero Member
5 897586 OculusMan Hero Member
5 909116 Blake_Last Sr. Member
5 916507 liviux Full Member
5 925386 ReLieD Sr. Member
5 932714 BCTBF Sr. Member
5 954930 hirokazu Sr. Member
5 961494 theunbeatable Sr. Member
5 1011165 rjbtc2017 Sr. Member
5 1109214 f150 Full Member
5 1135453 Revenant 02 Full Member
5 1202061 chimk Full Member
5 1359124 sister1001 Member
4 3079 chris200x9 Legendary
4 6706 RodeoX Legendary
4 99837 HeRetiK Hero Member
4 114848 Financisto Hero Member
4 370611 bill gator Copper Member
4 392456 twicezeroiszero Hero Member
4 458761 vizito Legendary
4 546617 npredtorch Legendary
4 560412 Joel_Jantsen Legendary
4 798632 Woshib Hero Member
4 799123 Getcoinsite Sr. Member
4 805820 Lafu Hero Member
4 844914 Wind_FURY Hero Member
4 919736 FlamingFingers Sr. Member
4 935741 cissrawk Sr. Member
4 988740 frodocooper Staff
4 1053456 Ben271286 Full Member
4 1105948 patz22 Full Member
4 1582324 DdmrDdmr Sr. Member
3 11425 gmaxwell Staff
3 23067 FractalUniverse Hero Member
3 138637 btcton Legendary
3 163641 eternalgloom Legendary
3 172217 Matt9301 Legendary
3 182468 RGBKey Hero Member
3 183781 pawel7777 Legendary
3 257071 NeuroticFish Legendary
3 306338 dothebeats Legendary
3 350580 irfan_pak10 Copper Member
3 379147 pooya87 Legendary
3 501333 jtipt Hero Member
3 523235 knuckey Sr. Member
3 525056 BitMaxz Legendary
3 717272 trecore4 Sr. Member
3 729995 SparkyU Hero Member
3 813715 thisappointed Hero Member
3 821995 hatshepsut93 Hero Member
3 876572 limmousine Sr. Member
3 950662 julerz12 Sr. Member
3 967277 speem28 Sr. Member
3 1059032 cuo Full Member
3 1066674 yojodojo21 Full Member
3 1079049 Jessy Mediola Full Member
3 1086882 tweetbit Full Member
3 1117058 kier010 Full Member
3 1147936 rommelzkie Full Member
3 1180530 theyoungmillionaire Full Member
2 33156 vapourminer Legendary
2 62358 Gyrsur Legendary
2 74719 fruit Legendary
2 123417 digit Legendary
2 157691 piebeyb Legendary
2 178657 fr4nkthetank Legendary
2 186520 Initscri Hero Member
2 194811 vit05 Sr. Member
2 223994 Hexah Sr. Member
2 252402 TheStuhlman Legendary
2 313016 owlcatz Legendary
2 314792 examplens Legendary
2 322667 tobeaj2mer01 Legendary
2 334783 seoincorporation Legendary
2 337097 iluvbitcoins Legendary
2 346449 botany Legendary
2 347141 sapta Staff
2 358787 Dudeperfect Hero Member
2 373425 dinda22 Legendary
2 396906 bitcoinmasterlord Legendary
2 398485 xdrpx Hero Member
2 479624 Last of the V8s Legendary
2 511899 RoomBot Legendary
2 533583 Lucius Legendary
2 535846 Aleister Crowley Hero Member
2 544972 yolanda222 Legendary
2 554429 Indrawan77 Hero Member
2 554812 DeathAngel Legendary
2 556382 TheGodFather Hero Member
2 580327 eddie13 Hero Member
2 599866 eye4bd Hero Member
2 640554 Strongkored Legendary
2 688810 Tyrantt Hero Member
2 757107 Bakemat Sr. Member
2 787736 marlboroza Hero Member
2 816788 gandame Hero Member
2 818704 Soranith Hero Member
2 818934 coinmenace Hero Member
2 820936 aliashraf Sr. Member
2 854798 Oceat Sr. Member
2 862738 Astvile Sr. Member
2 877396 AdolfinWolf Hero Member
2 881564 BlackRock Sr. Member
2 894862 DaftAjax Sr. Member
2 917908 Rooster101 Sr. Member
2 926641 seven2smoke1 Full Member
2 947337 Xenrise Sr. Member
2 955917 tanghere02 Sr. Member
2 958159 onecall123 Sr. Member
2 959979 creepyjas Sr. Member
2 960511 nullCoiner Sr. Member
2 969551 SoulBargain Full Member
2 970256 btc_angela Sr. Member
2 984212 llyfee4u Full Member
2 986243 7jaka7 Sr. Member
2 989138 Maykl Sr. Member
2 1000368 LouVandetta Sr. Member
2 1013536 Be_Happy Sr. Member
2 1017434 richminded Sr. Member
2 1020285 Rebisco Full Member
2 1047996 bluefirecorp_ Member
2 1091163 Silent26 Sr. Member
2 1100851 katinko Full Member
2 1107844 amishmanish Sr. Member
2 1109403 BenOnceAgain Member
2 1180810 rodmanqs Full Member
2 1214159 Crypto Capital Member
2 1560793 sncc Sr. Member
2 1574226 mu_enrico Copper Member
2 1605387 cabalism13 Member
2 1649515 hakka Member
2 1701092 Husires Member
2 1938519 butka Full Member
2 2049993 DoriangrayTW Member
1 13544 hdclover Hero Member
1 16392 RakelA96 Member
1 17501 iCEBREAKER Legendary
1 18700 Pipesnake Legendary
1 28719 jbreher Legendary
1 32419 linkme Sr. Member
1 34692 fronti Legendary
1 35501 cAPSLOCK Legendary
1 47593 ajqjjj Hero Member
1 51285 NaXxow Hero Member
1 54791 Dabs Staff
1 58607 FuzzyBear Legendary
1 61202 AmDD Legendary
1 64748 flynn Hero Member
1 65716 CoinEraser Hero Member
1 73389 dave111223 Legendary
1 80810 solosequenosenada Sr. Member
1 85033 d5000 Legendary
1 87229 yefi Legendary
1 87449 pangu Hero Member
1 88912 600watt Legendary
1 100591 veleten Legendary
1 101872 Lauda Legendary
1 110785 AGD Legendary
1 113838 itod Legendary
1 120694 xhomerx10 Legendary
1 122077 AngelSky Hero Member
1 125747 Taras Legendary
1 131361 Timelord2067 Legendary
1 131686 HarHarHar9965 Hero Member
1 135920 aTriz Hero Member
1 136484 figmentofmyass Hero Member
1 152666 Mountaingoat Hero Member
1 153644 tyz Legendary
1 154742 anirgu Legendary
1 154816 cagrund Legendary
1 162290 bitcoinblog Sr. Member
1 162680 squatter Hero Member
1 163318 Torque Legendary
1 164749 stompix Hero Member
1 172868 Gelbstich Hero Member
1 174480 MadZ Hero Member
1 177723 hopenotlate Legendary
1 179437 w0lf0. Hero Member
1 183392 undeadbitcoiner Sr. Member
1 186337 itsonlikedonkeykong Sr. Member
1 192825 _Miracle Hero Member
1 195140 Xtar Hero Member
1 206368 cryptonit Legendary
1 208580 pol5 Legendary
1 231127 adjiadjo Legendary
1 233431 john1010 Hero Member
1 239406 Toxic2040 Sr. Member
1 240233 funsponge Hero Member
1 242809 kimamaxgreen Member
1 255065 ebliever Legendary
1 262695 OROBTC Legendary
1 289817 NotFuzzyWarm Legendary
1 303026 Velkro Legendary
1 311045 hodlcoins Legendary
1 315016 djangocoin Sr. Member
1 318891 Jocuserious Sr. Member
1 320412 5tift Hero Member
1 325680 HI-TEC99 Legendary
1 325777 lite Legendary
1 330633 s1ng Legendary
1 336203 penoze Legendary
1 338580 CrazyCraig Sr. Member
1 339978 bozo333 Sr. Member
1 340795 vanobe Member
1 341170 free-bit.co.in Hero Member
1 344995 saddampbuh Legendary
1 348185 HagssFIN Legendary
1 352642 fitraok09 Hero Member
1 353493 Dread Pirate Roberts Copper Member
1 358471 jesoa Member
1 362644 wanispwnz Full Member
1 362982 KuromaYoichi Sr. Member
1 366549 max2000irc Hero Member
1 368438 ccsang Full Member
1 368837 r1d1 Hero Member
1 369212 zazarb Legendary
1 372249 bitcoin revo Legendary
1 374061 Kakmakr Legendary
1 374598 codenamethisNutz Sr. Member
1 375981 OmegaStarScream Staff
1 378130 andycarrol Hero Member
1 378257 FrueGreads Legendary
1 385855 Patatas Legendary
1 386072 Salmen Legendary
1 387544 oHnK Hero Member
1 389271 Limx Dev Copper Member
1 391624 sonerbo Copper Member
1 393142 stingers Legendary
1 396526 ezeminer Legendary
1 397256 Bitfort Sr. Member
1 401307 zork Legendary
1 405032 rozee Legendary
1 408246 YuTü.Co.in Sr. Member
1 408367 killyou72 Copper Member
1 430390 psycodad Hero Member
1 497745 RealPhotoshoper Legendary
1 508748 Zeroxal Hero Member
1 509986 Emperor of Man Hero Member
1 510707 hanifhadzar Sr. Member
1 514956 freedoge.co Hero Member
1 516369 kamvreto Legendary
1 533006 richardsNY Legendary
1 545598 Isildur (official) Hero Member
1 557798 TryNinja Hero Member
1 569455 BobLawblaw Legendary
1 598528 debutant Hero Member
1 623643 johhnyUA Hero Member
1 643028 Greaves7 Hero Member
1 662310 Kolder Hero Member
1 662570 HabBear Hero Member
1 669141 Xavofat Hero Member
1 675302 leonix007 Sr. Member
1 703997 mrcash02 Hero Member
1 704626 moamin77 Full Member
1 735878 apoorvlathey Hero Member
1 741872 poptok1 Hero Member
1 765554 Quidat Sr. Member
1 771962 Raja_MBZ Hero Member
1 782621 alisafidel58 Full Member
1 808881 eaLiTy Hero Member
1 816300 Jelly0621 Sr. Member
1 816537 ankit10 Sr. Member
1 816896 sunsilk Hero Member
1 817592 IeSua Hero Member
1 819957 prettybuds Full Member
1 824455 nkarm1 Full Member
1 828352 Immor108 Hero Member
1 834384 mrjoy15 Hero Member
1 838362 JayCue Full Member
1 843526 bitcoinsforall Hero Member
1 849797 Loganota Hero Member
1 853829 Adbitco Sr. Member
1 854519 entrepmind23 Sr. Member
1 864005 kaicrypzen Hero Member
1 864332 Hassan02 Hero Member
1 870895 darklus123 Hero Member
1 874477 8Habits Sr. Member
1 876001 SamsungBitcoin Sr. Member
1 876156 Kaznachej123 Hero Member
1 879277 Coding Enthusiast Sr. Member
1 887277 snowyNNN Sr. Member
1 888099 finaleshot2016 Sr. Member
1 897423 spov Full Member
1 902263 carcassone Sr. Member
1 905157 anorganix Copper Member
1 908236 digitalgame4life Full Member
1 908376 MrCrank Sr. Member
1 910477 PHPSELLER Sr. Member
1 914868 ThatRandom8543 Sr. Member
1 919220 Renji Abarai Full Member
1 919836 AlcatelBravo Full Member
1 920544 Tara11 Sr. Member
1 924222 HEWRA Full Member
1 925907 okissabam Sr. Member
1 928004 kurbeks Sr. Member
1 928111 Live.me Full Member
1 932735 Akash1243 Sr. Member
1 937706 iamqw Member
1 938170 Cobalt9317 Copper Member
1 938265 kidsuzudn Full Member
1 952464 scum Member
1 961738 Tesorex Full Member
1 964169 nix_7878 Member
1 969459 Velogin Jr. Member
1 970591 jakirtanvir Full Member
1 971496 necromastery Sr. Member
1 973054 NewStar Sr. Member
1 973996 Chris314 Sr. Member
1 974425 shadowdio Sr. Member
1 978539 revenant2017 Sr. Member
1 984384 Baofeng Sr. Member
1 987982 kissmarx Sr. Member
1 995487 Kawasanz Sr. Member
1 995655 Gekkoo Sr. Member
1 998621 mrcastelo Full Member
1 1004188 Bagaji Sr. Member
1 1006408 caneca Full Member
1 1006592 nioschka Full Member
1 1009071 vinc3 Sr. Member
1 1010389 L1544 Full Member
1 1014315 Mungurul Sr. Member
1 1016829 edgycorner Full Member
1 1016958 Fujiati Full Member
1 1018532 sekapai Member
1 1019229 axiline Full Member
1 1020270 GeniusAko Full Member
1 1025090 DU18 Full Member
1 1025104 bbcolex Full Member
1 1026915 Squishy01 Member
1 1035145 Delphinus Full Member
1 1035841 josephpogi Full Member
1 1037063 Butchick Full Member
1 1045345 jatin729 Full Member
1 1045367 kurian Full Member
1 1047959 pinoyden Full Member
1 1048361 YouShallNotPass Full Member
1 1052329 Mahirap Full Member
1 1054592 Aventhe Full Member
1 1061824 Chrystora123 Full Member
1 1062153 btc78 Full Member
1 1065054 Piratte Full Member
1 1067333 micgoossens Sr. Member
1 1076800 1020kingz Full Member
1 1081647 friends1980 Full Member
1 1083030 Wingo Full Member
1 1086501 ModaFuka1994 Member
1 1095532 blacksky Full Member
1 1098120 TheKeyLongThumbI Full Member
1 1099214 Gracechen17 Full Member
1 1100191 shesheboy Full Member
1 1100242 hothot Member
1 1101238 Highspeed123 Full Member
1 1106178 wiredideas Full Member
1 1109297 Valentina N Full Member
1 1116762 imstillthebest Full Member
1 1118386 NedShift Member
1 1119424 NoMar02 Full Member
1 1121336 shoreno Full Member
1 1122795 jhongzjhong Full Member
1 1126497 Crumple Cat Full Member
1 1127008 NavI_027 Full Member
1 1127855 xXLimbXx Full Member
1 1129436 dirgayeah Full Member
1 1132169 felipe04 Full Member
1 1132999 Zastria Full Member
1 1137497 Kpmaline Jr. Member
1 1138034 dameh2100 Full Member
1 1142832 nioctiB#1 Full Member
1 1143164 LogitechMouse Full Member
1 1143460 mak2017 Full Member
1 1143867 cepedacharles29 Full Member
1 1147321 Fazlurkhan.kz Full Member
1 1148377 Tristan1337 Member
1 1156114 orionluckyse7en Full Member
1 1158586 DRAWDE_3691 Full Member
1 1159221 ferrybitcoin.1996 Full Member
1 1162741 dr.cheema Full Member
1 1171091 Shiroxx Member
1 1178098 nanna Full Member
1 1179651 sheenshane Full Member
1 1189098 sneeze11 Full Member
1 1194201 farhan28 Full Member
1 1196880 aervin11 Full Member
1 1203847 Deathgamer Member
1 1207215 cryptovagas Member
1 1232224 zenrol28 Copper Member
1 1246658 pranazzs Member
1 1249182 Godric-Gryffindor Member
1 1254896 mazdafunsun Member
1 1257516 Rosewater Foundation Full Member
1 1261329 chamika888 Member
1 1276985 WUWARAOLUOXIANG Member
1 1280710 Stamil Member
1 1289764 spiderm4n15 Member
1 1295824 cpmcgrat Member
1 1305518 akashark Member
1 1308233 peach56 Member
1 1311953 t1Zona Member
1 1318827 dxbcoin Member
1 1329214 kingjackoin Member
1 1337707 EnterTheLight Member
1 1341921 krishnaverma Member
1 1346246 orkoso Member
1 1348516 Pantoflascrypt017 Member
1 1369827 tesla80 Member
1 1374659 mightwalker Jr. Member
1 1383162 OlgaAmraie Jr. Member
1 1413633 OWZ1337 Member
1 1427952 snowblack Member
1 1432468 mdayonliner Sr. Member
1 1435147 zenman0 Member
1 1554927 bitmover Sr. Member
1 1634314 shahzadafzal Copper Member
1 1644225 unabomber Newbie
1 1645049 BitExalt Copper Member
1 1781008 Daboy_Lyle Member
1 1825672 morvillz7z Full Member
1 1837238 crypmike Full Member
1 1867995 roda00 Jr. Member
1 1878246 abhiseshakana Full Member
1 1920386 as9ardia Member
1 1980983 Coolcryptovator Copper Member
1 2003859 DireWolfM14 Member
1 2124069 vphasitha01 Full Member
1 2132794 IgorKiselev Jr. Member
1 2307759 TheArchaeologist Member
1 2363935 YOSHIE Jr. Member
1 2391740 Dont trust for money Newbie
1 2423416 S_Therapist Newbie

If you are further interested in breakup of the posts in which poster received merits then use the  below query. Replace r.username with the poster forum username , In my case I used theymos and replace u.username with the senders username,in my case it is Foxpup.
 Make sure to use the exact forum name because data in database is case-sensitive.

Query used:
Code:
select A.username MeritGiver,A.Date,A.Merit,A.msg,r.username MeritReciever,A.board,a.subboard,a.titlethread from (select * from userdata u ,meritdata m where u.username='Foxpup' and u.userid=m.fromid) A, userdata r where a.toid=r.userid
and r.username='theymos';
 

Distribution of data:
Code:
MeritGiver Date Merit Msg MeritReciever Board SubBoard TitleThread
Foxpup 2018-10-18T12:26:26 4 5047729.msg46740675 theymos Bitcoin Development & Technical Discussion How is bitcoind “shy” when exchanging `version` packets?
Foxpup 2018-10-18T12:25:56 4 4659296.msg46290617 theymos Other Politics & Society Supreme Court pick Brett Kavanaugh
Foxpup 2018-09-29T03:07:28 2 5035303.msg46042843 theymos Other Meta Growing Blackmarket for Merit trading
Foxpup 2018-09-22T09:17:17 9 5035144.msg46014777 theymos Bitcoin Development & Technical Discussion The duplicate input vulnerability shouldn*t be forgotten
Foxpup 2018-09-20T11:35:58 4 5031079.msg45923426 theymos Bitcoin Development & Technical Discussion Flaws in LN (Lightning Network).
Foxpup 2018-09-20T05:11:43 4 5032980.msg45922658 theymos Bitcoin Development & Technical Discussion When Schnorr will be added?
Foxpup 2018-09-20T05:10:47 3 5032980.msg45920204 theymos Bitcoin Development & Technical Discussion When Schnorr will be added?
Foxpup 2018-09-18T04:29:09 1 5030366.msg45823950 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-09-18T04:06:47 2 5030366.msg45814117 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-09-18T04:04:16 5 2818350.msg45849233 theymos Other Meta Merit & new rank requirements
Foxpup 2018-09-18T03:57:23 4 5030366.msg45810953 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-09-18T03:56:13 15 5030366.msg45810047 theymos Other Meta Enhanced newbie restrictions & requirements
Foxpup 2018-08-29T03:40:45 2 4967555.msg44845552 theymos Other Meta FAO MODS: Why not charge a fee to recover hacked accounts?
Foxpup 2018-08-16T10:05:51 3 4905191.msg44172369 theymos Other Serious discussion What would the top coins be if people were sane?
Foxpup 2018-08-16T03:53:12 1 4897173.msg44101782 theymos Other Meta Can we get whoever the mod is who did this banned?
Foxpup 2018-08-05T17:05:29 4 2260983.msg43473905 theymos Bitcoin Development & Technical Discussion Creating private key from 2 different RNG:s?
Foxpup 2018-08-05T17:05:28 3 2260983.msg43445376 theymos Bitcoin Development & Technical Discussion Creating private key from 2 different RNG:s?
Foxpup 2018-07-16T02:07:15 2 4675898.msg42257358 theymos Other Meta Anunymint ban
Foxpup 2018-07-13T07:08:26 4 4659296.msg42066357 theymos Other Politics & Society Supreme Court pick Brett Kavanaugh
Foxpup 2018-07-06T14:23:51 6 4609442.msg41610959 theymos Other Meta Idea: Courses
Foxpup 2018-05-20T04:48:26 15 3920469.msg37611040 theymos Alternate cryptocurrencies Announcements (Altcoins) [ANN][PRE-ICO]HoweyCoins: the only BitcoinTalk-endorsed ICO - GUARANTEED PROFIT
Foxpup 2018-05-10T02:17:26 1 3683184.msg36818653 theymos Other Meta Report to the moderator -Deserve some rewards  
Foxpup 2018-05-05T03:29:22 1 3540892.msg36329486 theymos Other Meta Image caching
Foxpup 2018-05-01T03:49:39 3 3432369.msg35976937 theymos Other Meta Banned Account Question
Foxpup 2018-04-21T03:42:30 6 3341237.msg34961604 theymos Other Politics & Society Anacyclosis - cycles of society/government
Foxpup 2018-03-16T07:13:03 3 2945878.msg32334739 theymos Other Meta overwhelming consensus excludes Lauda, remains in DT2, went in2 buz w sold act  
Foxpup 2018-03-13T04:08:28 3 2986106.msg32186049 theymos Other Meta Newbie, Jr Members, Members suffering from merit-phobia: Explanations and Advice
Foxpup 2018-03-07T07:06:12 6 1469099.msg14823618 theymos Bitcoin Bitcoin Discussion Theymos: “Bitcoins Belonging to Satoshi Should Be Destroyed”
Foxpup 2018-03-07T07:05:55 1 1469099.msg14823504 theymos Bitcoin Bitcoin Discussion Theymos: “Bitcoins Belonging to Satoshi Should Be Destroyed”
Foxpup 2018-02-27T15:33:38 3 3030477.msg31180145 theymos Bitcoin Development & Technical Discussion Thoughts on the early bugs discovered by Peter Todd in LN?
Foxpup 2018-02-04T01:55:44 6 2818350.msg29540717 theymos Other Meta Merit & new rank requirements
Foxpup 2018-01-25T03:09:51 6 2818350.msg28856522 theymos Other Meta Merit & new rank requirements


All the queries were executed in Piggy's database on Nov 10 2018.



13  Economy / Services / Re: [Merit] Fetch me advertising network information on: November 11, 2018, 03:47:13 AM


The reward may be a precious merit when you make a decent unique post. Any offtopic posts may be removed.


Merit is not intended to be used as the way you are trying to use it. You are using "Services" section and payment should be in BTC here.

Remove your ad immediately . Your intentions are also not looking good as you are using Moderated thread.
14  Other / Meta / Re: Is the new ERA of merit dying again? on: November 11, 2018, 03:01:31 AM
Merit not only kept shit poster on the bay but it also kept large number of average Joe also in bay without any fault of theirs.
It is really worrying trend that even source merits are not getting used fully.

No idea, what steps Theymos is doing but I guess current situation is not good for forum.
 It is a natural human desire to progress and even  if earnest effort  did  not help then I guess in coming days ratio of shitposter vs average user will going to increase.


My source sMerits aren't getting replenished as fast as I figured they'd be, so I've been using up my own supply of sMerits lately.

But still all the source Merits are not getting used completely. Might Theymos need to reshuffle the quota of everybody. Increase the quota of those who are using it fully and decrease of those who are not able to use it fully.
15  Other / Meta / Re: [Suggestion]To draw more attention to the rules! on: November 10, 2018, 08:44:13 PM

1. Create a Forum Rules Button on the Top Buttons Bar and when you click on it you get to the Forum Rules.


I think it is time for Theymos to write the "Official" rules and create the button in top as you suggested.

Just my thinking , "Unofficial" word in rules does not sound great.
16  Other / Beginners & Help / Technical Perspective of bitcoins. on: November 10, 2018, 09:06:52 AM
It is almost a year when I come to know about  bitcoin for first time. I started taking interest in bitcoin and large number of altcoins for investment purpose. Anyways within months I understood that most of the altcoins are scam and I put my full focus in understanding the bitcoin. Recently I understood how much of the facts that were hidden from us when we generally read the introductory articles on bitcoin.
I think most of us here thought that Satoshi was one of the first to create a crytocurrency so bitcoin become popular but it is not true. In reality Satoshi is first to create a Proof of work consensus method that can work in decentralized way and that is the real backbone of bitcoin and real genius of Satoshi. When most of the literature point to the anoynomus Satoshi in bitcoin development, they really writing off all the researches already done in this field by the people like  Hal Finney and Nick Szabo and numerous other with whom Satoshi corresponded. I am not denying Satoshi acheivement but I am trying to make emphasize on point that Bitcoin is not something that is got created on one fine day of 2009 but instead it is a result of decade of research of many .

Bitcoin in technical side solve the "Byzantine General's Problem" by the use of blockchain and Proof of Work consensus algorithim. Byzantine Fault tolerance or Byzantine General's Problem is a real challenge for any distributed system to work flawlessly.This is the reason that government/people who do not want bitcoin but still embracing the block chain technology.

CAP (Consistency,Availability, Partition Tolerance) theorem in distributed sytem put a limit that you can have only 2 out of these 3 available parameters. Bitcoin distributed cannot ovefride this theorem but it is designed is such a way that it is least impacted with the limitation put in by this theorem by the mechanism of eventual Consistency.

Bitcoin still functioning well to be used as to make your own bank, giving you freedom to transact without being restricted by countries boundaries and making it truly global in Nature.

So friends, when next time if someone ask you about bitcoin, try to tell them about some computational problems that bitcoin solves. Try to read some technical documents and books instead of relying on some random articles.

I hope Bitcoin will keep gaining popularity and its usage and might be Satoshi will be awarded  Turing_Award in future.


Refernces: https://en.wikipedia.org/wiki/Cryptocurrency
                 https://en.wikipedia.org/wiki/CAP_theorem
                 https://paulkernfeld.com/2016/01/15/bitcoin-cap-theorem.html
                 Mastering Blockchain by Imran Bashir
                 Mastering Bitcoin -  by Andreas M. Antonopoulos


17  Other / Meta / Re: Can there be other ways to earn merit? on: November 09, 2018, 05:16:42 PM
The problem is not only getting 1 merit but instead it is also about how one could rank up.

That is now a different problem. I think might we should lower merit requirement for rank up. But in reality the question will come why you want rank up here?
If you say for gaining knowledge, then you do not need to rank up.
If you say for taking part in discussion, then again you do not need to rank up.
If you say for earning, you just frowned the community here and now community wants you to prove your worth.

where you have gone some hard days before you rank up.

In reality, those hard days never made me impatient. I am always  gathering hints and I become more refined .



It was not only me, I feel those newbie posting in this section just to get merit. I know they have done it wrong and they were just impatient to get at least one merit. But, they will not going to learn anyway if we will tolerate it also on giving free merits. So, let us just say to continue what the admin wants for the new comers and let them feel that learning is still the best way to be here in this forum. But, after getting some basics helping some users to rank up would be ideal.

That's the key, impatience will not help you to get get Merits.
18  Other / Meta / Re: Can there be other ways to earn merit? on: November 09, 2018, 09:45:28 AM
 
No free merits should be given on basis of activity. It will again encourage activity based spam.
Those who got the desire ultimately find the way.

1 merit is really not that hard to find if you are really contributing in this forum.Newbies who are creating thread in Meta saying that 1 merit is impossible actually want free airdrop of rank/Merit.

19  Economy / Speculation / Re: Wall Observer BTC/USD - Bitcoin price movement tracking & discussion on: November 09, 2018, 06:41:29 AM
Your posts look pretty pretty good and the octosphincter is sated. Choose a picture you would want as an avatar and comrade homer might put it on a cap for you.

Thanks for your words.

Bright Orange Bitcoin logo in Royal Navy Blue hat will definitely make  my day.

https://en.bitcoin.it/wiki/File:BC_Logo_.png
20  Other / Beginners & Help / Re: Why isn't Meta considered to be an earnable board? on: November 09, 2018, 05:50:46 AM
To be honest, I would not count posts from meta if I would be a bounty manager, at least, it would help to reduce spamming on meta.

Going by this logic, I will not pay anything in Altcoin Discussion then.
As a bounty manager you are supposed to not to count any post that looks spam irrespective of board.

@OP
Actually, It fully depends upon what kind of target audience that project is looking. Meta is generally for forum rules and regulations. 50% of thread in Meta are of banned user and some user complaining about merits. They do not make a good target audience for a project.
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 39 40 41 42 43 44 45 46 47 48 »
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!