Ecoer Logo
VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS4.99%
Net Worth
1.660USD
STEEM
0.001STEEM
SBD
0.866SBD
Own SP
22.919SP

Detailed Balance

STEEM
balance
0.001STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
22.919SP
Delegated Out
0.000SP
Delegation In
0.000SP
Effective Power
22.919SP
Reward SP (pending)
0.208SP
SBD
sbd_balance
0.056SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
0.810SBD
{
  "balance": "0.001 STEEM",
  "savings_balance": "0.000 STEEM",
  "reward_steem_balance": "0.000 STEEM",
  "vesting_shares": "37319.819034 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "0.000000 VESTS",
  "sbd_balance": "0.056 SBD",
  "savings_sbd_balance": "0.000 SBD",
  "reward_sbd_balance": "0.810 SBD",
  "conversions": []
}

Account Info

nameholudghuri
id333906
rank71,593
reputation364001974088
created2017-08-25T18:32:51
recovery_accountsteem
proxyNone
post_count55
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2018-03-01T14:22:39
last_root_post2018-03-01T14:22:39
last_vote_time2018-02-15T01:56:03
proxied_vsf_votes0, 0, 0, 0
can_vote1
voting_power9,604
delayed_votes0
balance0.001 STEEM
savings_balance0.000 STEEM
sbd_balance0.056 SBD
savings_sbd_balance0.000 SBD
vesting_shares37319.819034 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares0.000000 VESTS
reward_vesting_balance425.218008 VESTS
vesting_balance0.000 STEEM
vesting_withdraw_rate0.000000 VESTS
next_vesting_withdrawal1969-12-31T23:59:59
withdrawn0
to_withdraw0
withdraw_routes0
savings_withdraw_requests0
last_account_recovery1970-01-01T00:00:00
reset_accountnull
last_owner_update1970-01-01T00:00:00
last_account_update2018-01-29T15:46:12
minedNo
sbd_seconds1,920,219,840
sbd_last_interest_payment2018-01-22T18:11:51
savings_sbd_last_interest_payment1970-01-01T00:00:00
{
  "id": 333906,
  "name": "holudghuri",
  "owner": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM5TAxygjMdXNTHmsPi8RAYxEcyJ7ZC42SocJ1QUSWiPcWBFUShh",
        1
      ]
    ]
  },
  "active": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM6jdXKmWL2oQXW8VZZ3xpZi3ivokAaSAQzmyAG7N2WhxrdAi3iw",
        1
      ]
    ]
  },
  "posting": {
    "weight_threshold": 1,
    "account_auths": [
      [
        "busy.app",
        1
      ],
      [
        "dmania.app",
        1
      ],
      [
        "utopian.app",
        1
      ]
    ],
    "key_auths": [
      [
        "STM7oCSwsTpDhPxiMjGuDiMAnSeCWQZ9StQN7TtsVE4Lb7Ansgz9R",
        1
      ]
    ]
  },
  "memo_key": "STM7qgTduzkAgvw4X4VEkAGMZjsaEZtAMwsHqTqVhmHrs7qfKoQf9",
  "json_metadata": "{\"profile\":{\"profile_image\":\"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-9/18740057_10208064316719440_8847351601194015927_n.jpg?oh=a43ba61c6ff81dd5d0d49a8f873cdea0&oe=5A29FFC8\",\"cover_image\":\"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-0/p206x206/424831_3767512600095_357169424_n.jpg?oh=238cc56b0b677eb090b306c68a8f3ebf&oe=5A325F33\",\"name\":\"Sam\",\"location\":\"Kolkata, INDIA\"}}",
  "posting_json_metadata": "{\"profile\":{\"profile_image\":\"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-9/18740057_10208064316719440_8847351601194015927_n.jpg?oh=a43ba61c6ff81dd5d0d49a8f873cdea0&oe=5A29FFC8\",\"cover_image\":\"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-0/p206x206/424831_3767512600095_357169424_n.jpg?oh=238cc56b0b677eb090b306c68a8f3ebf&oe=5A325F33\",\"name\":\"Sam\",\"location\":\"Kolkata, INDIA\"}}",
  "proxy": "",
  "last_owner_update": "1970-01-01T00:00:00",
  "last_account_update": "2018-01-29T15:46:12",
  "created": "2017-08-25T18:32:51",
  "mined": false,
  "recovery_account": "steem",
  "last_account_recovery": "1970-01-01T00:00:00",
  "reset_account": "null",
  "comment_count": 0,
  "lifetime_vote_count": 0,
  "post_count": 55,
  "can_vote": true,
  "voting_manabar": {
    "current_mana": 9604,
    "last_update_time": 1518659763
  },
  "downvote_manabar": {
    "current_mana": 0,
    "last_update_time": 1503685971
  },
  "voting_power": 9604,
  "balance": "0.001 STEEM",
  "savings_balance": "0.000 STEEM",
  "sbd_balance": "0.056 SBD",
  "sbd_seconds": "1920219840",
  "sbd_seconds_last_update": "2018-01-31T17:48:27",
  "sbd_last_interest_payment": "2018-01-22T18:11:51",
  "savings_sbd_balance": "0.000 SBD",
  "savings_sbd_seconds": "0",
  "savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
  "savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
  "savings_withdraw_requests": 0,
  "reward_sbd_balance": "0.810 SBD",
  "reward_steem_balance": "0.000 STEEM",
  "reward_vesting_balance": "425.218008 VESTS",
  "reward_vesting_steem": "0.208 STEEM",
  "vesting_shares": "37319.819034 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "0.000000 VESTS",
  "vesting_withdraw_rate": "0.000000 VESTS",
  "next_vesting_withdrawal": "1969-12-31T23:59:59",
  "withdrawn": 0,
  "to_withdraw": 0,
  "withdraw_routes": 0,
  "curation_rewards": 35,
  "posting_rewards": 30676,
  "proxied_vsf_votes": [
    0,
    0,
    0,
    0
  ],
  "witnesses_voted_for": 0,
  "last_post": "2018-03-01T14:22:39",
  "last_root_post": "2018-03-01T14:22:39",
  "last_vote_time": "2018-02-15T01:56:03",
  "post_bandwidth": 0,
  "pending_claimed_accounts": 0,
  "vesting_balance": "0.000 STEEM",
  "reputation": "364001974088",
  "transfer_history": [],
  "market_history": [],
  "post_history": [],
  "vote_history": [],
  "other_history": [],
  "witness_votes": [],
  "tags_usage": [],
  "guest_bloggers": [],
  "rank": 71593
}

Withdraw Routes

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
2019/08/25 19:40:39
parent authorholudghuri
parent permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
authorsteemitboard
permlinksteemitboard-notify-holudghuri-20190825t194039000z
title
bodyCongratulations @holudghuri! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@holudghuri/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@holudghuri) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=holudghuri)_</sub> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
Transaction InfoBlock #35869884/Trx 2fce83bf14201c3439f88f377c82ab672dd989e2
View Raw JSON Data
{
  "trx_id": "2fce83bf14201c3439f88f377c82ab672dd989e2",
  "block": 35869884,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-08-25T19:40:39",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-holudghuri-20190825t194039000z",
      "title": "",
      "body": "Congratulations @holudghuri! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@holudghuri/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@holudghuri) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=holudghuri)_</sub>\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
    }
  ]
}
2019/04/26 06:09:36
parent authorholudghuri
parent permlinkthe-mask-festival-at-kolkata
authormamalikh13
permlinkre-holudghuri-the-mask-festival-at-kolkata-20190426t060933615z
title
bodyWe wear them everyday! Meeting people and dealing with friends. We have a particular mask for each friend we have hehe :)
json metadata{"tags":["art"],"app":"steemit/0.1"}
Transaction InfoBlock #32374460/Trx a12ab9129d1773c20100b512d5c3124d31a2a0ec
View Raw JSON Data
{
  "trx_id": "a12ab9129d1773c20100b512d5c3124d31a2a0ec",
  "block": 32374460,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-04-26T06:09:36",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "the-mask-festival-at-kolkata",
      "author": "mamalikh13",
      "permlink": "re-holudghuri-the-mask-festival-at-kolkata-20190426t060933615z",
      "title": "",
      "body": "We wear them everyday!\nMeeting people and dealing with friends.\nWe have a particular mask for each friend we have hehe :)",
      "json_metadata": "{\"tags\":[\"art\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2018/08/25 20:35:09
parent authorholudghuri
parent permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
authorsteemitboard
permlinksteemitboard-notify-holudghuri-20180825t203511000z
title
bodyCongratulations @holudghuri! You have received a personal award! [![](https://steemitimages.com/70x70/http://steemitboard.com/@holudghuri/birthday1.png)](http://steemitboard.com/@holudghuri) 1 Year on Steemit <sub>_Click on the badge to view your Board of Honor._</sub> **Do not miss the last post from @steemitboard:** [SteemitBoard and the Veterans on Steemit - The First Community Badge.](https://steemit.com/veterans/@steemitboard/steemitboard-and-the-veterans-on-steemit-the-first-community-badge) > Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
Transaction InfoBlock #25386685/Trx e284ac20449aad7857831d62d202f5a377b76f3c
View Raw JSON Data
{
  "trx_id": "e284ac20449aad7857831d62d202f5a377b76f3c",
  "block": 25386685,
  "trx_in_block": 24,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-08-25T20:35:09",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-holudghuri-20180825t203511000z",
      "title": "",
      "body": "Congratulations @holudghuri! You have received a personal award!\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/@holudghuri/birthday1.png)](http://steemitboard.com/@holudghuri)  1 Year on Steemit\n<sub>_Click on the badge to view your Board of Honor._</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n[SteemitBoard and the Veterans on Steemit - The First Community Badge.](https://steemit.com/veterans/@steemitboard/steemitboard-and-the-veterans-on-steemit-the-first-community-badge)\n\n> Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
    }
  ]
}
2018/03/07 05:48:06
votermagia.cinco
authorholudghuri
permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
weight10000 (100.00%)
Transaction InfoBlock #20458667/Trx 805eeb62910324a0f00b84a6997f1f7ed222f558
View Raw JSON Data
{
  "trx_id": "805eeb62910324a0f00b84a6997f1f7ed222f558",
  "block": 20458667,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-07T05:48:06",
  "op": [
    "vote",
    {
      "voter": "magia.cinco",
      "author": "holudghuri",
      "permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "weight": 10000
    }
  ]
}
2018/03/01 17:21:21
voterwhiteblood
authorholudghuri
permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
weight10000 (100.00%)
Transaction InfoBlock #20299840/Trx efe64ddd5f0f5ce371271c92c44fd8ece369cc9f
View Raw JSON Data
{
  "trx_id": "efe64ddd5f0f5ce371271c92c44fd8ece369cc9f",
  "block": 20299840,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T17:21:21",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "weight": 10000
    }
  ]
}
2018/03/01 15:19:09
votershoot
authorholudghuri
permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
weight6146 (61.46%)
Transaction InfoBlock #20297398/Trx a7e1d4f0bd4b0ead3a580b93184b93229c95b89f
View Raw JSON Data
{
  "trx_id": "a7e1d4f0bd4b0ead3a580b93184b93229c95b89f",
  "block": 20297398,
  "trx_in_block": 43,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T15:19:09",
  "op": [
    "vote",
    {
      "voter": "shoot",
      "author": "holudghuri",
      "permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "weight": 6146
    }
  ]
}
2018/03/01 15:18:57
parent authorholudghuri
parent permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
authorshoot
permlinkre-holudghuri-201831t204855472z
title
bodyHappy holi ![image](https://img.esteem.ws/sbf1igh0oe.jpg)
json metadata{"tags":["esteem","holi","life","blog","fun"],"app":"esteem/1.5.1","format":"markdown+html","community":"esteem"}
Transaction InfoBlock #20297394/Trx 6595d8c51ea87aad6178901e647ccc20d0592589
View Raw JSON Data
{
  "trx_id": "6595d8c51ea87aad6178901e647ccc20d0592589",
  "block": 20297394,
  "trx_in_block": 43,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T15:18:57",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "author": "shoot",
      "permlink": "re-holudghuri-201831t204855472z",
      "title": "",
      "body": "Happy holi  ![image](https://img.esteem.ws/sbf1igh0oe.jpg)",
      "json_metadata": "{\"tags\":[\"esteem\",\"holi\",\"life\",\"blog\",\"fun\"],\"app\":\"esteem/1.5.1\",\"format\":\"markdown+html\",\"community\":\"esteem\"}"
    }
  ]
}
2018/03/01 14:23:51
votersdavignon
authorholudghuri
permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
weight10000 (100.00%)
Transaction InfoBlock #20296292/Trx a86eb4d127f3a1b09541787ef96b0a83a470bd82
View Raw JSON Data
{
  "trx_id": "a86eb4d127f3a1b09541787ef96b0a83a470bd82",
  "block": 20296292,
  "trx_in_block": 51,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T14:23:51",
  "op": [
    "vote",
    {
      "voter": "sdavignon",
      "author": "holudghuri",
      "permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "weight": 10000
    }
  ]
}
2018/03/01 14:22:39
authorholudghuri
permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
max accepted payout1000000.000 SBD
percent steem dollars10000
allow votestrue
allow curation rewardstrue
extensions[[0,{"beneficiaries":[{"account":"esteemapp","weight":1000}]}]]
Transaction InfoBlock #20296268/Trx 7821cbeecb597ac11fb2534d93d86db6f72c83fc
View Raw JSON Data
{
  "trx_id": "7821cbeecb597ac11fb2534d93d86db6f72c83fc",
  "block": 20296268,
  "trx_in_block": 35,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T14:22:39",
  "op": [
    "comment_options",
    {
      "author": "holudghuri",
      "permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "esteemapp",
                "weight": 1000
              }
            ]
          }
        ]
      ]
    }
  ]
}
2018/03/01 14:22:39
parent author
parent permlinkesteem
authorholudghuri
permlinktoday-is-dol-purnima-our-holi-8662c0e5d72ae
titleToday is Dol Purnima our HOLI
bodyToday We celebrate our holi Festival of this year. We play with lots of color and abur ( Gulab) with my family.Here is some snaps from my celebration,— ![image](https://img.esteem.ws/2s1vx5nuls.jpg) ![image](https://img.esteem.ws/vj0f674me1.jpg) ![image](https://img.esteem.ws/qs4krejwlf.jpg) Dol is a festival of colours and enjoyment and so am I. # HAPPY HOLI TO ALL MY STEEMIT FRIENDS, enjoy
json metadata{"links":[],"image":["https://img.esteem.ws/2s1vx5nuls.jpg","https://img.esteem.ws/vj0f674me1.jpg","https://img.esteem.ws/qs4krejwlf.jpg"],"tags":["esteem","holi","life","blog","fun"],"app":"esteem/1.5.1","format":"markdown+html","community":"esteem"}
Transaction InfoBlock #20296268/Trx 7821cbeecb597ac11fb2534d93d86db6f72c83fc
View Raw JSON Data
{
  "trx_id": "7821cbeecb597ac11fb2534d93d86db6f72c83fc",
  "block": 20296268,
  "trx_in_block": 35,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-01T14:22:39",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "esteem",
      "author": "holudghuri",
      "permlink": "today-is-dol-purnima-our-holi-8662c0e5d72ae",
      "title": "Today is Dol Purnima our HOLI",
      "body": "Today We celebrate our holi Festival of this year. We play with lots of color and abur ( Gulab) with my family.Here is some snaps from my celebration,—\n\n ![image](https://img.esteem.ws/2s1vx5nuls.jpg)\n\n ![image](https://img.esteem.ws/vj0f674me1.jpg)\n\n ![image](https://img.esteem.ws/qs4krejwlf.jpg)\n\nDol is a festival of colours and enjoyment and so am I.\n\n# HAPPY HOLI TO ALL MY STEEMIT FRIENDS, enjoy",
      "json_metadata": "{\"links\":[],\"image\":[\"https://img.esteem.ws/2s1vx5nuls.jpg\",\"https://img.esteem.ws/vj0f674me1.jpg\",\"https://img.esteem.ws/qs4krejwlf.jpg\"],\"tags\":[\"esteem\",\"holi\",\"life\",\"blog\",\"fun\"],\"app\":\"esteem/1.5.1\",\"format\":\"markdown+html\",\"community\":\"esteem\"}"
    }
  ]
}
holudghurireceived 0.020 SBD, 0.008 SP author reward for @holudghuri / my-valentine-night-47179ed5e713b
2018/02/22 01:55:03
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
sbd payout0.020 SBD
steem payout0.000 STEEM
vesting payout12.262789 VESTS
Transaction InfoBlock #20079930/Virtual Operation #29
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20079930,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 29,
  "timestamp": "2018-02-22T01:55:03",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "sbd_payout": "0.020 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "12.262789 VESTS"
    }
  ]
}
esteemappreceived 0.001 SP benefactor reward from @holudghuri
2018/02/22 01:55:03
benefactoresteemapp
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout2.043798 VESTS
Transaction InfoBlock #20079930/Virtual Operation #28
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20079930,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 28,
  "timestamp": "2018-02-22T01:55:03",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "esteemapp",
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2.043798 VESTS"
    }
  ]
}
holudghurireceived 0.570 SBD, 0.174 SP author reward for @holudghuri / esteem-review-a46852f69737a
2018/02/21 07:45:48
authorholudghuri
permlinkesteem-review-a46852f69737a
sbd payout0.570 SBD
steem payout0.000 STEEM
vesting payout284.099302 VESTS
Transaction InfoBlock #20058151/Virtual Operation #15
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20058151,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 15,
  "timestamp": "2018-02-21T07:45:48",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "sbd_payout": "0.570 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "284.099302 VESTS"
    }
  ]
}
esteemappreceived 0.038 SP benefactor reward from @holudghuri
2018/02/21 07:45:48
benefactoresteemapp
authorholudghuri
permlinkesteem-review-a46852f69737a
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout61.316396 VESTS
Transaction InfoBlock #20058151/Virtual Operation #14
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20058151,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 14,
  "timestamp": "2018-02-21T07:45:48",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "esteemapp",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "61.316396 VESTS"
    }
  ]
}
2018/02/17 02:05:12
voterwhiteblood
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
weight10000 (100.00%)
Transaction InfoBlock #19936176/Trx 44dad472759b0e09bc3e824a21f2efd152bad756
View Raw JSON Data
{
  "trx_id": "44dad472759b0e09bc3e824a21f2efd152bad756",
  "block": 19936176,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-17T02:05:12",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "weight": 10000
    }
  ]
}
2018/02/15 02:25:09
voteriwanderela
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
weight300 (3.00%)
Transaction InfoBlock #19879024/Trx 650794111881db423b1f95828e84c85d73a478a9
View Raw JSON Data
{
  "trx_id": "650794111881db423b1f95828e84c85d73a478a9",
  "block": 19879024,
  "trx_in_block": 30,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-15T02:25:09",
  "op": [
    "vote",
    {
      "voter": "iwanderela",
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "weight": 300
    }
  ]
}
2018/02/15 01:56:24
voterverbose-jimmy
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
weight10000 (100.00%)
Transaction InfoBlock #19878449/Trx 86550a7365028eb0b19f62029964ea99c652d07a
View Raw JSON Data
{
  "trx_id": "86550a7365028eb0b19f62029964ea99c652d07a",
  "block": 19878449,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-15T01:56:24",
  "op": [
    "vote",
    {
      "voter": "verbose-jimmy",
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "weight": 10000
    }
  ]
}
2018/02/15 01:56:03
voterholudghuri
authorholudghuri
permlinkesteem-review-a46852f69737a
weight10000 (100.00%)
Transaction InfoBlock #19878442/Trx 5104780e40f600d14bfd0b000145f3d119de36e9
View Raw JSON Data
{
  "trx_id": "5104780e40f600d14bfd0b000145f3d119de36e9",
  "block": 19878442,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-15T01:56:03",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 10000
    }
  ]
}
2018/02/15 01:55:24
voterholudghuri
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
weight10000 (100.00%)
Transaction InfoBlock #19878429/Trx d78e7a6f3393c1a23ab7b6679b32e8218a243c5f
View Raw JSON Data
{
  "trx_id": "d78e7a6f3393c1a23ab7b6679b32e8218a243c5f",
  "block": 19878429,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-15T01:55:24",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "weight": 10000
    }
  ]
}
2018/02/15 01:55:03
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
max accepted payout1000000.000 SBD
percent steem dollars10000
allow votestrue
allow curation rewardstrue
extensions[[0,{"beneficiaries":[{"account":"esteemapp","weight":1000}]}]]
Transaction InfoBlock #19878422/Trx d7a96e05d040a4c6fa507f5a801a1bf400a421e3
View Raw JSON Data
{
  "trx_id": "d7a96e05d040a4c6fa507f5a801a1bf400a421e3",
  "block": 19878422,
  "trx_in_block": 49,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-15T01:55:03",
  "op": [
    "comment_options",
    {
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "esteemapp",
                "weight": 1000
              }
            ]
          }
        ]
      ]
    }
  ]
}
2018/02/15 01:55:03
parent author
parent permlinkvalentine
authorholudghuri
permlinkmy-valentine-night-47179ed5e713b
titleMy valentine night
bodyValentine’s Day is gone but it’s memories are not. Here is some from last night At ‘blue and beyond’ restaurant. It’s a very god restaurant with great rooftop view and lovely ambiance. ![image](https://img.esteem.ws/irm4sumizo.jpg) ![image](https://img.esteem.ws/0lh5ni460j.jpg) We enjoying candle in lovely night of valentine. And make the day memorable.
json metadata{"links":[],"image":["https://img.esteem.ws/irm4sumizo.jpg","https://img.esteem.ws/0lh5ni460j.jpg"],"tags":["valentine","esteem","love","life","blog"],"app":"esteem/1.5.1","format":"markdown+html","community":"esteem"}
Transaction InfoBlock #19878422/Trx d7a96e05d040a4c6fa507f5a801a1bf400a421e3
View Raw JSON Data
{
  "trx_id": "d7a96e05d040a4c6fa507f5a801a1bf400a421e3",
  "block": 19878422,
  "trx_in_block": 49,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-15T01:55:03",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "valentine",
      "author": "holudghuri",
      "permlink": "my-valentine-night-47179ed5e713b",
      "title": "My valentine night",
      "body": "Valentine’s Day is gone but it’s memories are not. Here is some from last night At ‘blue and beyond’ restaurant.\nIt’s a very god restaurant with great rooftop view and lovely ambiance.\n ![image](https://img.esteem.ws/irm4sumizo.jpg)\n ![image](https://img.esteem.ws/0lh5ni460j.jpg)\n\nWe enjoying candle in lovely night of valentine. And make the day memorable.",
      "json_metadata": "{\"links\":[],\"image\":[\"https://img.esteem.ws/irm4sumizo.jpg\",\"https://img.esteem.ws/0lh5ni460j.jpg\"],\"tags\":[\"valentine\",\"esteem\",\"love\",\"life\",\"blog\"],\"app\":\"esteem/1.5.1\",\"format\":\"markdown+html\",\"community\":\"esteem\"}"
    }
  ]
}
2018/02/14 23:53:15
votermeysam
authorholudghuri
permlinkesteem-review-a46852f69737a
weight3 (0.03%)
Transaction InfoBlock #19875988/Trx 13c975e1dd0a944cbf0cf9837636ffb581ad4208
View Raw JSON Data
{
  "trx_id": "13c975e1dd0a944cbf0cf9837636ffb581ad4208",
  "block": 19875988,
  "trx_in_block": 0,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T23:53:15",
  "op": [
    "vote",
    {
      "voter": "meysam",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 3
    }
  ]
}
2018/02/14 23:53:12
voterbitcoiner
authorholudghuri
permlinkesteem-review-a46852f69737a
weight6 (0.06%)
Transaction InfoBlock #19875987/Trx 54723e81470896900329366b893700913430ad63
View Raw JSON Data
{
  "trx_id": "54723e81470896900329366b893700913430ad63",
  "block": 19875987,
  "trx_in_block": 46,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T23:53:12",
  "op": [
    "vote",
    {
      "voter": "bitcoiner",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 6
    }
  ]
}
holudghurireceived 0.011 SBD, 0.004 SP author reward for @holudghuri / the-mask-festival-at-kolkata
2018/02/14 19:34:48
authorholudghuri
permlinkthe-mask-festival-at-kolkata
sbd payout0.011 SBD
steem payout0.000 STEEM
vesting payout6.133749 VESTS
Transaction InfoBlock #19870826/Virtual Operation #2
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19870826,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 2,
  "timestamp": "2018-02-14T19:34:48",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "sbd_payout": "0.011 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "6.133749 VESTS"
    }
  ]
}
2018/02/14 18:50:36
voterwhiteblood
authorholudghuri
permlinkesteem-review-a46852f69737a
weight10000 (100.00%)
Transaction InfoBlock #19869945/Trx e785d0fa3f9bc39bd58fb1934b5d0d5fd85e2259
View Raw JSON Data
{
  "trx_id": "e785d0fa3f9bc39bd58fb1934b5d0d5fd85e2259",
  "block": 19869945,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T18:50:36",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 10000
    }
  ]
}
2018/02/14 08:48:30
voteresteemapp
authorholudghuri
permlinkesteem-review-a46852f69737a
weight50 (0.50%)
Transaction InfoBlock #19857923/Trx d284f984c58945d34c66d76abcda7e8046facf16
View Raw JSON Data
{
  "trx_id": "d284f984c58945d34c66d76abcda7e8046facf16",
  "block": 19857923,
  "trx_in_block": 33,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:48:30",
  "op": [
    "vote",
    {
      "voter": "esteemapp",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 50
    }
  ]
}
2018/02/14 08:48:27
votermysteem
authorholudghuri
permlinkesteem-review-a46852f69737a
weight100 (1.00%)
Transaction InfoBlock #19857922/Trx d0d814353543b85f560be4c7ec1e9f9e8e96206b
View Raw JSON Data
{
  "trx_id": "d0d814353543b85f560be4c7ec1e9f9e8e96206b",
  "block": 19857922,
  "trx_in_block": 26,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:48:27",
  "op": [
    "vote",
    {
      "voter": "mysteem",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 100
    }
  ]
}
2018/02/14 08:48:24
voterferuz
authorholudghuri
permlinkesteem-review-a46852f69737a
weight100 (1.00%)
Transaction InfoBlock #19857921/Trx 8ed81aa0de4614913ce12e6652f1ff4e62545b8d
View Raw JSON Data
{
  "trx_id": "8ed81aa0de4614913ce12e6652f1ff4e62545b8d",
  "block": 19857921,
  "trx_in_block": 35,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:48:24",
  "op": [
    "vote",
    {
      "voter": "feruz",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 100
    }
  ]
}
2018/02/14 08:48:21
voterdemo
authorholudghuri
permlinkesteem-review-a46852f69737a
weight100 (1.00%)
Transaction InfoBlock #19857920/Trx 25de7f9a81582f044f44c415623eac3f25711b53
View Raw JSON Data
{
  "trx_id": "25de7f9a81582f044f44c415623eac3f25711b53",
  "block": 19857920,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:48:21",
  "op": [
    "vote",
    {
      "voter": "demo",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 100
    }
  ]
}
2018/02/14 08:48:18
votergood-karma
authorholudghuri
permlinkesteem-review-a46852f69737a
weight6 (0.06%)
Transaction InfoBlock #19857919/Trx 7ff0194d898cf5d620fcf54d0f74d47b5c707b15
View Raw JSON Data
{
  "trx_id": "7ff0194d898cf5d620fcf54d0f74d47b5c707b15",
  "block": 19857919,
  "trx_in_block": 5,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:48:18",
  "op": [
    "vote",
    {
      "voter": "good-karma",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 6
    }
  ]
}
2018/02/14 08:08:27
voterface2face
authorholudghuri
permlinkesteem-review-a46852f69737a
weight4212 (42.12%)
Transaction InfoBlock #19857123/Trx c91f47ae752499b8c593bdd3bdd11759a183458e
View Raw JSON Data
{
  "trx_id": "c91f47ae752499b8c593bdd3bdd11759a183458e",
  "block": 19857123,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:08:27",
  "op": [
    "vote",
    {
      "voter": "face2face",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "weight": 4212
    }
  ]
}
2018/02/14 08:07:57
parent authorholudghuri
parent permlinkesteem-review-a46852f69737a
authorface2face
permlinkre-holudghuri-2018214t133751400z
title
bodyYes you right there is some bug but will resolve soon. However i am working with this app since long. i have find a solution for this. I will tell you via discord.
json metadata{"tags":["esteem","steemit","blog"],"app":"esteem/1.5.1","format":"markdown+html","community":"esteem"}
Transaction InfoBlock #19857113/Trx 8deb1327f27eb06adbb9eccfef4c239f101e8981
View Raw JSON Data
{
  "trx_id": "8deb1327f27eb06adbb9eccfef4c239f101e8981",
  "block": 19857113,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T08:07:57",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "esteem-review-a46852f69737a",
      "author": "face2face",
      "permlink": "re-holudghuri-2018214t133751400z",
      "title": "",
      "body": "Yes you right there is some bug but will resolve soon. However i am working with this app since long. i have find a solution for this. I will tell you via discord.",
      "json_metadata": "{\"tags\":[\"esteem\",\"steemit\",\"blog\"],\"app\":\"esteem/1.5.1\",\"format\":\"markdown+html\",\"community\":\"esteem\"}"
    }
  ]
}
2018/02/14 07:45:48
authorholudghuri
permlinkesteem-review-a46852f69737a
max accepted payout1000000.000 SBD
percent steem dollars10000
allow votestrue
allow curation rewardstrue
extensions[[0,{"beneficiaries":[{"account":"esteemapp","weight":1000}]}]]
Transaction InfoBlock #19856671/Trx c5cb4655b19b5b2765f95c335622c577a6c60d15
View Raw JSON Data
{
  "trx_id": "c5cb4655b19b5b2765f95c335622c577a6c60d15",
  "block": 19856671,
  "trx_in_block": 36,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T07:45:48",
  "op": [
    "comment_options",
    {
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "esteemapp",
                "weight": 1000
              }
            ]
          }
        ]
      ]
    }
  ]
}
2018/02/14 07:45:48
parent author
parent permlinkesteem
authorholudghuri
permlinkesteem-review-a46852f69737a
titleEsteem review
bodyToday I used esteem app for the first time. I heard about many good things and Review about esteem app so finally today this is the first post of mine for esteem. **bold**The review Ah, it’s pretty tuff to use esteem app after a long useage of steemit website. It’s pretty hard to find all buttons and values which I’m regular in website. But after few minutes of use I found the necessary tabs and buttons and also found a new Tab of ‘active’, which I really don’t know the use of it. And secondly oh, so bad to do it From iPhone 5s. Most of the text of this are post are not coming properly in screen. Like this image- ![image](https://img.esteem.ws/ahoh1ivy8g.jpg) I think this an error only for iPhone 5s and its has be resolved. I uploaded Above image nicely from my iPhone. And that’s cool now I can upload directly what I captured. The main think I like in esteem app is the accessibility of steemit from anywhere. And very sorry for my bad English. Thanks
json metadata{"links":[],"image":["https://img.esteem.ws/ahoh1ivy8g.jpg"],"tags":["esteem","steemit","blog"],"app":"esteem/1.5.1","format":"markdown+html","community":"esteem"}
Transaction InfoBlock #19856671/Trx c5cb4655b19b5b2765f95c335622c577a6c60d15
View Raw JSON Data
{
  "trx_id": "c5cb4655b19b5b2765f95c335622c577a6c60d15",
  "block": 19856671,
  "trx_in_block": 36,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-14T07:45:48",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "esteem",
      "author": "holudghuri",
      "permlink": "esteem-review-a46852f69737a",
      "title": "Esteem review",
      "body": "Today I used esteem app for the first time. I heard about many good things and Review about esteem app so finally today this is the first post of mine for esteem.\n\n**bold**The review \nAh,  it’s pretty tuff to use esteem app after a long useage of steemit website. It’s pretty hard to find all buttons and values which I’m regular in website. \nBut after few minutes of use I found the necessary tabs and buttons and also found a new Tab of ‘active’, which I really don’t know the use of it.\n\nAnd secondly oh, so bad to do it From iPhone 5s.\nMost of the text of this are post are not coming properly in screen. Like this image- \n ![image](https://img.esteem.ws/ahoh1ivy8g.jpg)\nI think this an error only for iPhone 5s and its has be resolved.\n\nI uploaded Above image nicely from my iPhone. And that’s cool now I can upload directly what I captured.\n\nThe main think I like in esteem app is the accessibility of steemit from anywhere. \n\nAnd very sorry for my bad English.\n\nThanks",
      "json_metadata": "{\"links\":[],\"image\":[\"https://img.esteem.ws/ahoh1ivy8g.jpg\"],\"tags\":[\"esteem\",\"steemit\",\"blog\"],\"app\":\"esteem/1.5.1\",\"format\":\"markdown+html\",\"community\":\"esteem\"}"
    }
  ]
}
2018/02/12 05:16:48
voterwhiteblood
authorholudghuri
permlinkthe-mask-festival-at-kolkata
weight10000 (100.00%)
Transaction InfoBlock #19796144/Trx 3ddc9332a5419a6c91ba062cb43f1b3f6ecf6a50
View Raw JSON Data
{
  "trx_id": "3ddc9332a5419a6c91ba062cb43f1b3f6ecf6a50",
  "block": 19796144,
  "trx_in_block": 33,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-12T05:16:48",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "weight": 10000
    }
  ]
}
2018/02/12 05:16:39
voterwhiteblood
authorholudghuri
permlinkthe-mask-festival-at-kolkata
weight0 (0.00%)
Transaction InfoBlock #19796141/Trx c2f6608654e40ea0891783fb96d804be928fdf6e
View Raw JSON Data
{
  "trx_id": "c2f6608654e40ea0891783fb96d804be928fdf6e",
  "block": 19796141,
  "trx_in_block": 16,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-12T05:16:39",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "weight": 0
    }
  ]
}
2018/02/09 17:36:21
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
sbd payout0.010 SBD
steem payout0.000 STEEM
vesting payout6.135368 VESTS
Transaction InfoBlock #19724583/Virtual Operation #13
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19724583,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 13,
  "timestamp": "2018-02-09T17:36:21",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "sbd_payout": "0.010 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "6.135368 VESTS"
    }
  ]
}
utopian.payreceived 0.001 SP benefactor reward from @holudghuri
2018/02/09 17:36:21
benefactorutopian.pay
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout2.045122 VESTS
Transaction InfoBlock #19724583/Virtual Operation #12
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19724583,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 12,
  "timestamp": "2018-02-09T17:36:21",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "utopian.pay",
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2.045122 VESTS"
    }
  ]
}
2018/02/07 19:58:39
parent authorholudghuri
parent permlinkthe-mask-festival-at-kolkata
authorcexmad
permlinkre-holudghuri-201828t25836142z
title
bodyvery beautiful picture ok I have vote.jangan forgot vote back
json metadata{"tags":["art","photography","life","blog","photo"],"app":"esteem/1.5.0","format":"markdown+html","community":"esteem"}
Transaction InfoBlock #19670061/Trx 7622e277bd406472ee2d0252e7ebf435ffa437cf
View Raw JSON Data
{
  "trx_id": "7622e277bd406472ee2d0252e7ebf435ffa437cf",
  "block": 19670061,
  "trx_in_block": 38,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-07T19:58:39",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "the-mask-festival-at-kolkata",
      "author": "cexmad",
      "permlink": "re-holudghuri-201828t25836142z",
      "title": "",
      "body": "very beautiful picture ok I have vote.jangan forgot vote back",
      "json_metadata": "{\"tags\":[\"art\",\"photography\",\"life\",\"blog\",\"photo\"],\"app\":\"esteem/1.5.0\",\"format\":\"markdown+html\",\"community\":\"esteem\"}"
    }
  ]
}
2018/02/07 19:58:21
votercexmad
authorholudghuri
permlinkthe-mask-festival-at-kolkata
weight10000 (100.00%)
Transaction InfoBlock #19670055/Trx eef6a07b19ef1aa3efba795f90f03a31d3ac9c69
View Raw JSON Data
{
  "trx_id": "eef6a07b19ef1aa3efba795f90f03a31d3ac9c69",
  "block": 19670055,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-07T19:58:21",
  "op": [
    "vote",
    {
      "voter": "cexmad",
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "weight": 10000
    }
  ]
}
2018/02/07 19:46:48
voterwhiteblood
authorholudghuri
permlinkthe-mask-festival-at-kolkata
weight10000 (100.00%)
Transaction InfoBlock #19669825/Trx 33eb0a5846f6a0e5187482765c54711baad1df5c
View Raw JSON Data
{
  "trx_id": "33eb0a5846f6a0e5187482765c54711baad1df5c",
  "block": 19669825,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-07T19:46:48",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "weight": 10000
    }
  ]
}
2018/02/07 19:35:15
voterholudghuri
authorholudghuri
permlinkthe-mask-festival-at-kolkata
weight10000 (100.00%)
Transaction InfoBlock #19669596/Trx 996915caaa30bdcf0aa62a5f8c34e21f57c5885b
View Raw JSON Data
{
  "trx_id": "996915caaa30bdcf0aa62a5f8c34e21f57c5885b",
  "block": 19669596,
  "trx_in_block": 7,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-07T19:35:15",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "weight": 10000
    }
  ]
}
2018/02/07 19:34:48
parent author
parent permlinkart
authorholudghuri
permlinkthe-mask-festival-at-kolkata
titleThe 'MASK' Festival at Kolkata
bodyRecently a mask festival or exhibition was held at Kolkata under 'West bengal information and cultural department about different masks. It is a collection of Masks which are coming different parts or cities of west Bengal. This are vary as per its local culture and environment and necessity of people. ![IMG_4142.JPG](https://steemitimages.com/DQmQYmx9UcNLFWHKBSRMgh9iD985SjhgimTu5onFE3RYQzv/IMG_4142.JPG) ![IMG_4133.JPG](https://steemitimages.com/DQmciG2NvTBS4jHQrDVqQ2oPi1ZpAhyj7iXJaFdbWaiRwe3/IMG_4133.JPG) ### The mask are "MUKOSH" in Bengali. So in this post I will show you some amazing images of 'Mukosh' and with their origin with details (if any). ##### "CHOOU NACH" Mask - - - - - - - -- - - - - - - - - - - - - - - - - This kind of mask are mainly from Purulia district and used for Chow dance. The peoples of Parulia are making group dance by wearning this kind of Choou mukosh. The dance are mainly on tale of Godess Durga and Asur fighting. -------------------------------------- ![IMG_4157.JPG](https://steemitimages.com/DQmeSjk5wGy2p6hfsjkaVYfuXfBd93sdppHLQRQCvsWNxf3/IMG_4157.JPG) ------------------------------------------------------------------------ ![IMG_4155.JPG](https://steemitimages.com/DQmZNZQ68njzppRUAi7ddcfet8SNyZCmRTgPWwB2K8N917b/IMG_4155.JPG) --------------------------------------------------- ![IMG_4154.JPG](https://steemitimages.com/DQmTU18PtKKZ6T6tj6sWur1FF5uJTXyZCTqHg9zJjxuhuFm/IMG_4154.JPG) ----------------------------------- ##### "Bagpa or Bakpa" Mask - - - - - - - -- - - - - - - - - - - - - - - - - This is also a dance mask.This dance about defeat evil and for better humanity. Thsi mask are mainly used by Buddhist region peoples .Also know as LAMA mask. Mainly red,blue and white colored mask are available. ----------------------------------------- ![IMG_4138.JPG](https://steemitimages.com/DQmTvpM2Bp6zzbdmTCLGfnsKbHiBiqyQSv9ysAQHnZV5ynr/IMG_4138.JPG) ----------------------------------- ![IMG_4136.JPG](https://steemitimages.com/DQmPFSMEgjq4q3KVbYx3amgH9iiXgXkF53UHzgnkLfvNY1V/IMG_4136.JPG) --------------------------------------------- ![IMG_4137.JPG](https://steemitimages.com/DQmPK2RMCMamtdVwWPiFBWGR61WrmSXyxjp95rEEMLHAdvp/IMG_4137.JPG) --------------------------------------------- ##### "Mukha Nach" Mask - - - - - - - -- - - - - - - - - - - - - - - - - This is are created for Mukha dance. This mask are from 'Uttar Dinajpur' District og West Bengal. This mask are created by crating woods. ------------------------------------- ![IMG_4150.JPG](https://steemitimages.com/DQmUxj9x71xGWGrG2eSJQ7GQwXLo7nXboHY4wrUSHtyg8Mw/IMG_4150.JPG) --------------------------- ![IMG_4132.JPG](https://steemitimages.com/DQmfSVQz7m7utgEKPtGhPMiX4Rmnooy5wY4YFufWXfxaNTJ/IMG_4132.JPG) --------------------------------------- ![IMG_4153.JPG](https://steemitimages.com/DQmQZPRcgcdakXkcSH9Z6d7cR2Ate8qN39j8eaMdNsfnxqf/IMG_4153.JPG) ------------------------------- ![IMG_4152.JPG](https://steemitimages.com/DQmPf2WHF98onkKXy1Eq1NS5Hg6FashjmYp4wiZTkYvaaeN/IMG_4152.JPG) ------------------------------------ ![IMG_4148.JPG](https://steemitimages.com/DQmfF7aJbitD4tRy5bMR9JUg2Gc9xPuesBHDyhuR14X4BAq/IMG_4148.JPG) -------------------------- ##### "Parva Nach" Mask - - - - - - - -- - - - - - - - - - - - - - - - - ![IMG_4174.JPG](https://steemitimages.com/DQmXLuF62VAAZj4zCMuZotEoGrgsSjZzwnwe6UHFqUw9MXh/IMG_4174.JPG) -------------------------------------------- ![IMG_4172.JPG](https://steemitimages.com/DQmUtxzUXtuzACJRWjDpi1o7WGSVp9hWmPYzggkUL3UvcZw/IMG_4172.JPG) ----------------------- ![IMG_4171.JPG](https://steemitimages.com/DQmS1i27LX9y58fupxcyT4gbsjWCs9nTnk8sXPKt1y1Qbhz/IMG_4171.JPG) ------------------------------------- ![IMG_4173.JPG](https://steemitimages.com/DQmWwT7L5kg328iW2sJs1Hg557XRPoAv4K14eAFZGszYrDq/IMG_4173.JPG) #### And many other 'MUKHOSH' are coming in exhibition - ![IMG_4167.JPG](https://steemitimages.com/DQmT4jrBuTtgwpw9cC8cSo1nqdr7TYETmVXJKocg3eZ3HLU/IMG_4167.JPG) ------------------------------- ![IMG_4170.JPG](https://steemitimages.com/DQmXrKc8YwkTrNGta3TeXknSMHfM2pnCJ5m4KLxyhwFgcMx/IMG_4170.JPG) ------------------------------- ![IMG_4180.JPG](https://steemitimages.com/DQmUWxj8RvYn7JKACH9KreX9Ud5CgLH1AT5E2yrUSFfkZHD/IMG_4180.JPG) --------------------------------------- ![IMG_4176.JPG](https://steemitimages.com/DQmWbu1rgmiv8K5cLri7qgPHMkLu7CJXD86vkMtLbSgdKew/IMG_4176.JPG) ----------------------------------------- ![IMG_4181.JPG](https://steemitimages.com/DQmZQxZVnfSWpeb6kWXdLsoJFdixgnaVeDoBQBRqnA5jWuK/IMG_4181.JPG) ----------------------------------- ![IMG_4179.JPG](https://steemitimages.com/DQmSsdCPjriAALZRnq9KpX3ojNA9yoG54SfrhuaxPM6b4fh/IMG_4179.JPG) ------------------------------ #### The arranger - ![IMG_4184.JPG](https://steemitimages.com/DQmRpswGvqcjzQt7qFyWZ1aJ4Fo6DBezyhUxbGSvLqVp3uB/IMG_4184.JPG) ![IMG_4185.JPG](https://steemitimages.com/DQmUsae6u7gdUBfPcqP2fy4MofsnsZnmdGzfJknkrGLE571/IMG_4185.JPG) ## Thanks for visiting post,I hope you like this journey of Mask with me.
json metadata{"tags":["art","photography","life","blog","photo"],"image":["https://steemitimages.com/DQmQYmx9UcNLFWHKBSRMgh9iD985SjhgimTu5onFE3RYQzv/IMG_4142.JPG","https://steemitimages.com/DQmciG2NvTBS4jHQrDVqQ2oPi1ZpAhyj7iXJaFdbWaiRwe3/IMG_4133.JPG","https://steemitimages.com/DQmeSjk5wGy2p6hfsjkaVYfuXfBd93sdppHLQRQCvsWNxf3/IMG_4157.JPG","https://steemitimages.com/DQmZNZQ68njzppRUAi7ddcfet8SNyZCmRTgPWwB2K8N917b/IMG_4155.JPG","https://steemitimages.com/DQmTU18PtKKZ6T6tj6sWur1FF5uJTXyZCTqHg9zJjxuhuFm/IMG_4154.JPG","https://steemitimages.com/DQmTvpM2Bp6zzbdmTCLGfnsKbHiBiqyQSv9ysAQHnZV5ynr/IMG_4138.JPG","https://steemitimages.com/DQmPFSMEgjq4q3KVbYx3amgH9iiXgXkF53UHzgnkLfvNY1V/IMG_4136.JPG","https://steemitimages.com/DQmPK2RMCMamtdVwWPiFBWGR61WrmSXyxjp95rEEMLHAdvp/IMG_4137.JPG","https://steemitimages.com/DQmUxj9x71xGWGrG2eSJQ7GQwXLo7nXboHY4wrUSHtyg8Mw/IMG_4150.JPG","https://steemitimages.com/DQmfSVQz7m7utgEKPtGhPMiX4Rmnooy5wY4YFufWXfxaNTJ/IMG_4132.JPG","https://steemitimages.com/DQmQZPRcgcdakXkcSH9Z6d7cR2Ate8qN39j8eaMdNsfnxqf/IMG_4153.JPG","https://steemitimages.com/DQmPf2WHF98onkKXy1Eq1NS5Hg6FashjmYp4wiZTkYvaaeN/IMG_4152.JPG","https://steemitimages.com/DQmfF7aJbitD4tRy5bMR9JUg2Gc9xPuesBHDyhuR14X4BAq/IMG_4148.JPG","https://steemitimages.com/DQmXLuF62VAAZj4zCMuZotEoGrgsSjZzwnwe6UHFqUw9MXh/IMG_4174.JPG","https://steemitimages.com/DQmUtxzUXtuzACJRWjDpi1o7WGSVp9hWmPYzggkUL3UvcZw/IMG_4172.JPG","https://steemitimages.com/DQmS1i27LX9y58fupxcyT4gbsjWCs9nTnk8sXPKt1y1Qbhz/IMG_4171.JPG","https://steemitimages.com/DQmWwT7L5kg328iW2sJs1Hg557XRPoAv4K14eAFZGszYrDq/IMG_4173.JPG","https://steemitimages.com/DQmT4jrBuTtgwpw9cC8cSo1nqdr7TYETmVXJKocg3eZ3HLU/IMG_4167.JPG","https://steemitimages.com/DQmXrKc8YwkTrNGta3TeXknSMHfM2pnCJ5m4KLxyhwFgcMx/IMG_4170.JPG","https://steemitimages.com/DQmUWxj8RvYn7JKACH9KreX9Ud5CgLH1AT5E2yrUSFfkZHD/IMG_4180.JPG","https://steemitimages.com/DQmWbu1rgmiv8K5cLri7qgPHMkLu7CJXD86vkMtLbSgdKew/IMG_4176.JPG","https://steemitimages.com/DQmZQxZVnfSWpeb6kWXdLsoJFdixgnaVeDoBQBRqnA5jWuK/IMG_4181.JPG","https://steemitimages.com/DQmSsdCPjriAALZRnq9KpX3ojNA9yoG54SfrhuaxPM6b4fh/IMG_4179.JPG","https://steemitimages.com/DQmRpswGvqcjzQt7qFyWZ1aJ4Fo6DBezyhUxbGSvLqVp3uB/IMG_4184.JPG","https://steemitimages.com/DQmUsae6u7gdUBfPcqP2fy4MofsnsZnmdGzfJknkrGLE571/IMG_4185.JPG"],"app":"steemit/0.1","format":"markdown"}
Transaction InfoBlock #19669587/Trx 5b9e95fea923cd58e676aa3bafade2311713a6c2
View Raw JSON Data
{
  "trx_id": "5b9e95fea923cd58e676aa3bafade2311713a6c2",
  "block": 19669587,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-07T19:34:48",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "art",
      "author": "holudghuri",
      "permlink": "the-mask-festival-at-kolkata",
      "title": "The 'MASK' Festival at Kolkata",
      "body": "Recently a mask festival or exhibition was held at Kolkata under 'West bengal information and cultural department about different masks.\nIt is a collection of Masks which are coming different parts or cities of west Bengal. This are vary as per its local culture and environment and necessity of people. \n\n![IMG_4142.JPG](https://steemitimages.com/DQmQYmx9UcNLFWHKBSRMgh9iD985SjhgimTu5onFE3RYQzv/IMG_4142.JPG)\n![IMG_4133.JPG](https://steemitimages.com/DQmciG2NvTBS4jHQrDVqQ2oPi1ZpAhyj7iXJaFdbWaiRwe3/IMG_4133.JPG)\n\n### The mask are \"MUKOSH\" in Bengali. So in this post I will show you some amazing images of 'Mukosh' and with their origin with details (if any).\n\n##### \"CHOOU NACH\" Mask\n- - - - - - - -- - - - - - - - - - - - - - - - - \nThis kind of mask are mainly from Purulia district and used for Chow dance. The peoples of Parulia are making group dance by wearning this kind of Choou mukosh. The dance are mainly on tale of Godess Durga and Asur fighting.  \n--------------------------------------\n![IMG_4157.JPG](https://steemitimages.com/DQmeSjk5wGy2p6hfsjkaVYfuXfBd93sdppHLQRQCvsWNxf3/IMG_4157.JPG)\n------------------------------------------------------------------------\n![IMG_4155.JPG](https://steemitimages.com/DQmZNZQ68njzppRUAi7ddcfet8SNyZCmRTgPWwB2K8N917b/IMG_4155.JPG)\n---------------------------------------------------\n![IMG_4154.JPG](https://steemitimages.com/DQmTU18PtKKZ6T6tj6sWur1FF5uJTXyZCTqHg9zJjxuhuFm/IMG_4154.JPG)\n-----------------------------------\n\n\n##### \"Bagpa or Bakpa\" Mask\n- - - - - - - -- - - - - - - - - - - - - - - - - \nThis is also a dance mask.This dance about defeat evil and for better humanity. Thsi mask are mainly used by Buddhist region peoples .Also know as LAMA mask.  Mainly red,blue and white colored mask are available.\n-----------------------------------------\n![IMG_4138.JPG](https://steemitimages.com/DQmTvpM2Bp6zzbdmTCLGfnsKbHiBiqyQSv9ysAQHnZV5ynr/IMG_4138.JPG)\n-----------------------------------\n![IMG_4136.JPG](https://steemitimages.com/DQmPFSMEgjq4q3KVbYx3amgH9iiXgXkF53UHzgnkLfvNY1V/IMG_4136.JPG)\n---------------------------------------------\n![IMG_4137.JPG](https://steemitimages.com/DQmPK2RMCMamtdVwWPiFBWGR61WrmSXyxjp95rEEMLHAdvp/IMG_4137.JPG)\n---------------------------------------------\n\n\n##### \"Mukha Nach\" Mask\n- - - - - - - -- - - - - - - - - - - - - - - - - \nThis is are created for Mukha dance. This mask are from 'Uttar Dinajpur' District og West Bengal. This mask are created by crating woods.\n-------------------------------------\n![IMG_4150.JPG](https://steemitimages.com/DQmUxj9x71xGWGrG2eSJQ7GQwXLo7nXboHY4wrUSHtyg8Mw/IMG_4150.JPG)\n---------------------------\n![IMG_4132.JPG](https://steemitimages.com/DQmfSVQz7m7utgEKPtGhPMiX4Rmnooy5wY4YFufWXfxaNTJ/IMG_4132.JPG)\n---------------------------------------\n![IMG_4153.JPG](https://steemitimages.com/DQmQZPRcgcdakXkcSH9Z6d7cR2Ate8qN39j8eaMdNsfnxqf/IMG_4153.JPG)\n-------------------------------\n![IMG_4152.JPG](https://steemitimages.com/DQmPf2WHF98onkKXy1Eq1NS5Hg6FashjmYp4wiZTkYvaaeN/IMG_4152.JPG)\n------------------------------------\n![IMG_4148.JPG](https://steemitimages.com/DQmfF7aJbitD4tRy5bMR9JUg2Gc9xPuesBHDyhuR14X4BAq/IMG_4148.JPG)\n--------------------------\n\n\n##### \"Parva Nach\" Mask\n- - - - - - - -- - - - - - - - - - - - - - - - - \n![IMG_4174.JPG](https://steemitimages.com/DQmXLuF62VAAZj4zCMuZotEoGrgsSjZzwnwe6UHFqUw9MXh/IMG_4174.JPG)\n--------------------------------------------\n![IMG_4172.JPG](https://steemitimages.com/DQmUtxzUXtuzACJRWjDpi1o7WGSVp9hWmPYzggkUL3UvcZw/IMG_4172.JPG)\n-----------------------\n![IMG_4171.JPG](https://steemitimages.com/DQmS1i27LX9y58fupxcyT4gbsjWCs9nTnk8sXPKt1y1Qbhz/IMG_4171.JPG)\n-------------------------------------\n![IMG_4173.JPG](https://steemitimages.com/DQmWwT7L5kg328iW2sJs1Hg557XRPoAv4K14eAFZGszYrDq/IMG_4173.JPG)\n \n#### And many other 'MUKHOSH' are coming in exhibition - \n![IMG_4167.JPG](https://steemitimages.com/DQmT4jrBuTtgwpw9cC8cSo1nqdr7TYETmVXJKocg3eZ3HLU/IMG_4167.JPG)\n-------------------------------\n![IMG_4170.JPG](https://steemitimages.com/DQmXrKc8YwkTrNGta3TeXknSMHfM2pnCJ5m4KLxyhwFgcMx/IMG_4170.JPG)\n-------------------------------\n![IMG_4180.JPG](https://steemitimages.com/DQmUWxj8RvYn7JKACH9KreX9Ud5CgLH1AT5E2yrUSFfkZHD/IMG_4180.JPG)\n---------------------------------------\n![IMG_4176.JPG](https://steemitimages.com/DQmWbu1rgmiv8K5cLri7qgPHMkLu7CJXD86vkMtLbSgdKew/IMG_4176.JPG)\n-----------------------------------------\n![IMG_4181.JPG](https://steemitimages.com/DQmZQxZVnfSWpeb6kWXdLsoJFdixgnaVeDoBQBRqnA5jWuK/IMG_4181.JPG)\n-----------------------------------\n![IMG_4179.JPG](https://steemitimages.com/DQmSsdCPjriAALZRnq9KpX3ojNA9yoG54SfrhuaxPM6b4fh/IMG_4179.JPG)\n------------------------------\n\n#### The arranger - \n![IMG_4184.JPG](https://steemitimages.com/DQmRpswGvqcjzQt7qFyWZ1aJ4Fo6DBezyhUxbGSvLqVp3uB/IMG_4184.JPG)\n![IMG_4185.JPG](https://steemitimages.com/DQmUsae6u7gdUBfPcqP2fy4MofsnsZnmdGzfJknkrGLE571/IMG_4185.JPG)\n\n## Thanks for visiting post,I hope you like this journey of Mask with me.",
      "json_metadata": "{\"tags\":[\"art\",\"photography\",\"life\",\"blog\",\"photo\"],\"image\":[\"https://steemitimages.com/DQmQYmx9UcNLFWHKBSRMgh9iD985SjhgimTu5onFE3RYQzv/IMG_4142.JPG\",\"https://steemitimages.com/DQmciG2NvTBS4jHQrDVqQ2oPi1ZpAhyj7iXJaFdbWaiRwe3/IMG_4133.JPG\",\"https://steemitimages.com/DQmeSjk5wGy2p6hfsjkaVYfuXfBd93sdppHLQRQCvsWNxf3/IMG_4157.JPG\",\"https://steemitimages.com/DQmZNZQ68njzppRUAi7ddcfet8SNyZCmRTgPWwB2K8N917b/IMG_4155.JPG\",\"https://steemitimages.com/DQmTU18PtKKZ6T6tj6sWur1FF5uJTXyZCTqHg9zJjxuhuFm/IMG_4154.JPG\",\"https://steemitimages.com/DQmTvpM2Bp6zzbdmTCLGfnsKbHiBiqyQSv9ysAQHnZV5ynr/IMG_4138.JPG\",\"https://steemitimages.com/DQmPFSMEgjq4q3KVbYx3amgH9iiXgXkF53UHzgnkLfvNY1V/IMG_4136.JPG\",\"https://steemitimages.com/DQmPK2RMCMamtdVwWPiFBWGR61WrmSXyxjp95rEEMLHAdvp/IMG_4137.JPG\",\"https://steemitimages.com/DQmUxj9x71xGWGrG2eSJQ7GQwXLo7nXboHY4wrUSHtyg8Mw/IMG_4150.JPG\",\"https://steemitimages.com/DQmfSVQz7m7utgEKPtGhPMiX4Rmnooy5wY4YFufWXfxaNTJ/IMG_4132.JPG\",\"https://steemitimages.com/DQmQZPRcgcdakXkcSH9Z6d7cR2Ate8qN39j8eaMdNsfnxqf/IMG_4153.JPG\",\"https://steemitimages.com/DQmPf2WHF98onkKXy1Eq1NS5Hg6FashjmYp4wiZTkYvaaeN/IMG_4152.JPG\",\"https://steemitimages.com/DQmfF7aJbitD4tRy5bMR9JUg2Gc9xPuesBHDyhuR14X4BAq/IMG_4148.JPG\",\"https://steemitimages.com/DQmXLuF62VAAZj4zCMuZotEoGrgsSjZzwnwe6UHFqUw9MXh/IMG_4174.JPG\",\"https://steemitimages.com/DQmUtxzUXtuzACJRWjDpi1o7WGSVp9hWmPYzggkUL3UvcZw/IMG_4172.JPG\",\"https://steemitimages.com/DQmS1i27LX9y58fupxcyT4gbsjWCs9nTnk8sXPKt1y1Qbhz/IMG_4171.JPG\",\"https://steemitimages.com/DQmWwT7L5kg328iW2sJs1Hg557XRPoAv4K14eAFZGszYrDq/IMG_4173.JPG\",\"https://steemitimages.com/DQmT4jrBuTtgwpw9cC8cSo1nqdr7TYETmVXJKocg3eZ3HLU/IMG_4167.JPG\",\"https://steemitimages.com/DQmXrKc8YwkTrNGta3TeXknSMHfM2pnCJ5m4KLxyhwFgcMx/IMG_4170.JPG\",\"https://steemitimages.com/DQmUWxj8RvYn7JKACH9KreX9Ud5CgLH1AT5E2yrUSFfkZHD/IMG_4180.JPG\",\"https://steemitimages.com/DQmWbu1rgmiv8K5cLri7qgPHMkLu7CJXD86vkMtLbSgdKew/IMG_4176.JPG\",\"https://steemitimages.com/DQmZQxZVnfSWpeb6kWXdLsoJFdixgnaVeDoBQBRqnA5jWuK/IMG_4181.JPG\",\"https://steemitimages.com/DQmSsdCPjriAALZRnq9KpX3ojNA9yoG54SfrhuaxPM6b4fh/IMG_4179.JPG\",\"https://steemitimages.com/DQmRpswGvqcjzQt7qFyWZ1aJ4Fo6DBezyhUxbGSvLqVp3uB/IMG_4184.JPG\",\"https://steemitimages.com/DQmUsae6u7gdUBfPcqP2fy4MofsnsZnmdGzfJknkrGLE571/IMG_4185.JPG\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}"
    }
  ]
}
holudghurireceived 0.121 SBD, 0.043 SP author reward for @holudghuri / colorchallenge-wednesday-yellow
2018/02/07 15:36:06
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
sbd payout0.121 SBD
steem payout0.000 STEEM
vesting payout69.541608 VESTS
Transaction InfoBlock #19664823/Virtual Operation #9
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19664823,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 9,
  "timestamp": "2018-02-07T15:36:06",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "sbd_payout": "0.121 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "69.541608 VESTS"
    }
  ]
}
holudghurireceived 0.050 SBD, 0.019 SP author reward for @holudghuri / how-to-install-and-start-python-in-different-os
2018/02/07 06:55:36
authorholudghuri
permlinkhow-to-install-and-start-python-in-different-os
sbd payout0.050 SBD
steem payout0.000 STEEM
vesting payout30.680691 VESTS
Transaction InfoBlock #19654429/Virtual Operation #19
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19654429,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 19,
  "timestamp": "2018-02-07T06:55:36",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "how-to-install-and-start-python-in-different-os",
      "sbd_payout": "0.050 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "30.680691 VESTS"
    }
  ]
}
utopian.payreceived 0.011 SP benefactor reward from @holudghuri
2018/02/07 06:55:36
benefactorutopian.pay
authorholudghuri
permlinkhow-to-install-and-start-python-in-different-os
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout18.408415 VESTS
Transaction InfoBlock #19654429/Virtual Operation #18
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19654429,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 18,
  "timestamp": "2018-02-07T06:55:36",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "utopian.pay",
      "author": "holudghuri",
      "permlink": "how-to-install-and-start-python-in-different-os",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "18.408415 VESTS"
    }
  ]
}
holudghurireceived 0.016 SBD, 0.006 SP author reward for @holudghuri / fully-charged-cat-zg1hbmlh-hdjyc
2018/02/05 16:00:54
authorholudghuri
permlinkfully-charged-cat-zg1hbmlh-hdjyc
sbd payout0.016 SBD
steem payout0.000 STEEM
vesting payout10.227743 VESTS
Transaction InfoBlock #19607763/Virtual Operation #12
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19607763,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 12,
  "timestamp": "2018-02-05T16:00:54",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "fully-charged-cat-zg1hbmlh-hdjyc",
      "sbd_payout": "0.016 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "10.227743 VESTS"
    }
  ]
}
whalepunkreceived 0.000 SP benefactor reward from @holudghuri
2018/02/05 16:00:54
benefactorwhalepunk
authorholudghuri
permlinkfully-charged-cat-zg1hbmlh-hdjyc
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout0.000000 VESTS
Transaction InfoBlock #19607763/Virtual Operation #11
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19607763,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 11,
  "timestamp": "2018-02-05T16:00:54",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "whalepunk",
      "author": "holudghuri",
      "permlink": "fully-charged-cat-zg1hbmlh-hdjyc",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}
snubbermikereceived 0.000 SP benefactor reward from @holudghuri
2018/02/05 16:00:54
benefactorsnubbermike
authorholudghuri
permlinkfully-charged-cat-zg1hbmlh-hdjyc
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout0.000000 VESTS
Transaction InfoBlock #19607763/Virtual Operation #10
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19607763,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 10,
  "timestamp": "2018-02-05T16:00:54",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "snubbermike",
      "author": "holudghuri",
      "permlink": "fully-charged-cat-zg1hbmlh-hdjyc",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}
dmaniareceived 0.000 SP benefactor reward from @holudghuri
2018/02/05 16:00:54
benefactordmania
authorholudghuri
permlinkfully-charged-cat-zg1hbmlh-hdjyc
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout0.000000 VESTS
Transaction InfoBlock #19607763/Virtual Operation #9
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19607763,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 9,
  "timestamp": "2018-02-05T16:00:54",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "dmania",
      "author": "holudghuri",
      "permlink": "fully-charged-cat-zg1hbmlh-hdjyc",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}
cntsreceived 0.000 SP benefactor reward from @holudghuri
2018/02/05 16:00:54
benefactorcnts
authorholudghuri
permlinkfully-charged-cat-zg1hbmlh-hdjyc
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout0.000000 VESTS
Transaction InfoBlock #19607763/Virtual Operation #8
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19607763,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 8,
  "timestamp": "2018-02-05T16:00:54",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "cnts",
      "author": "holudghuri",
      "permlink": "fully-charged-cat-zg1hbmlh-hdjyc",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}
2018/02/05 08:48:12
voterholudghuri
authorkvadrascope
permlinkhow-to-see-a-casual-view-in-an-unfamiliar-and-hypnotizing-perspective
weight10000 (100.00%)
Transaction InfoBlock #19599112/Trx 7779efd801b9571cb81af58ec2b571de9f0ce73d
View Raw JSON Data
{
  "trx_id": "7779efd801b9571cb81af58ec2b571de9f0ce73d",
  "block": 19599112,
  "trx_in_block": 58,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-05T08:48:12",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "kvadrascope",
      "permlink": "how-to-see-a-casual-view-in-an-unfamiliar-and-hypnotizing-perspective",
      "weight": 10000
    }
  ]
}
2018/02/05 07:10:18
authorholudghuri
permlinkasp-net-tutorial-an-introduction-to-asp-net-mobile-issue-1
sbd payout0.012 SBD
steem payout0.000 STEEM
vesting payout6.136758 VESTS
Transaction InfoBlock #19597156/Virtual Operation #15
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19597156,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 15,
  "timestamp": "2018-02-05T07:10:18",
  "op": [
    "author_reward",
    {
      "author": "holudghuri",
      "permlink": "asp-net-tutorial-an-introduction-to-asp-net-mobile-issue-1",
      "sbd_payout": "0.012 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "6.136758 VESTS"
    }
  ]
}
utopian.payreceived 0.001 SP benefactor reward from @holudghuri
2018/02/05 07:10:18
benefactorutopian.pay
authorholudghuri
permlinkasp-net-tutorial-an-introduction-to-asp-net-mobile-issue-1
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout2.045586 VESTS
Transaction InfoBlock #19597156/Virtual Operation #14
View Raw JSON Data
{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 19597156,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 14,
  "timestamp": "2018-02-05T07:10:18",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "utopian.pay",
      "author": "holudghuri",
      "permlink": "asp-net-tutorial-an-introduction-to-asp-net-mobile-issue-1",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2.045586 VESTS"
    }
  ]
}
holudghuripublished a new post: post
2018/02/05 06:42:57
parent author
parent permlinktest
authorholudghuri
permlinkpost
titlepost
bodyTEST
json metadata{"tags":["test"],"app":"steemit/0.1","format":"markdown"}
Transaction InfoBlock #19596610/Trx b9742923ebdd9f9b139598a5e0bbf68c9ed15efc
View Raw JSON Data
{
  "trx_id": "b9742923ebdd9f9b139598a5e0bbf68c9ed15efc",
  "block": 19596610,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-05T06:42:57",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "test",
      "author": "holudghuri",
      "permlink": "post",
      "title": "post",
      "body": "TEST",
      "json_metadata": "{\"tags\":[\"test\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}"
    }
  ]
}
2018/02/04 08:13:09
parent authorholudghuri
parent permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
authorrufans
permlinkre-holudghuri-how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org-20180204t081310311z
title
bodyYour contribution cannot be approved because it does not follow the [Utopian Rules](https://utopian.io/rules), and is considered as **plagiarism**. Plagiarism is not allowed on Utopian, and posts that engage in plagiarism will be flagged and hidden forever. * The whole of you tutorial was gotten from a [PDF](https://www.openoffice.org/fr/Documentation/How-to/Bdd/05jdbc_mysqlfr-v2.pdf) file. You can contact us on [Discord](https://discord.gg/uTyJkNm). **[[utopian-moderator]](https://utopian.io/moderators)**
json metadata{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
Transaction InfoBlock #19569628/Trx 83f2009d87f9f1e50954c57dbc09a6f14092efc6
View Raw JSON Data
{
  "trx_id": "83f2009d87f9f1e50954c57dbc09a6f14092efc6",
  "block": 19569628,
  "trx_in_block": 38,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-04T08:13:09",
  "op": [
    "comment",
    {
      "parent_author": "holudghuri",
      "parent_permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "author": "rufans",
      "permlink": "re-holudghuri-how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org-20180204t081310311z",
      "title": "",
      "body": "Your contribution cannot be approved because it does not follow the [Utopian Rules](https://utopian.io/rules), and is considered as **plagiarism**. Plagiarism is not allowed on Utopian, and posts that engage in plagiarism will be flagged and hidden forever.\n\n* The whole of you tutorial was gotten from a [PDF](https://www.openoffice.org/fr/Documentation/How-to/Bdd/05jdbc_mysqlfr-v2.pdf) file.\n\nYou can contact us on [Discord](https://discord.gg/uTyJkNm).\n**[[utopian-moderator]](https://utopian.io/moderators)**",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}"
    }
  ]
}
2018/02/04 08:11:51
parent author
parent permlinkutopian-io
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
titleHow to Connect a MySQL Database via a JDBC Driver With OpenOffice.org
body #### What Will I Learn? In this you will leaRN How to Connect a MySQL Database via a JDBC Driver With OpenOffice.org Broadcast by The OpenOffice.org Documentation Project. A short introduction to know how to use a MySQL database via a JDBC driver, under Windows. - Tutorial object Introduction - Creation of the database - Installing the JDBC driver - Connection with OOo - Examples #### Requirements Download and install MySQL: At the following address: http://www.mysql.org/downloads you will find the database and a graphical interface for `MYSQLGUI`, as well as JDBC driver APIs. A very good choice for driving MySQL is `PhpMyAdmin`. For this, you need to do to run a web server with PHP. It's very simple if you use `PHPTriad` or `FOXServer` in the extent that these two tools are made to install and configure, very simply, a `Web server Apache with MySQL, PHP and PHPMyAdmin`. You can find them at the following addresses: http://sourceforge.net/projects/foxserv http://sourceforge.net/projects/phptriad #### Difficulty - Intermediate #### Tutorial Contents ------------------------------------------------- #### <center>1 . Introduction</center> ---------------------------------- Here I use `PHPTriad` because it is smaller and everything is included without the JDBC drivers. After launching the installer, you have an Apache web server with PHP, PhpMyAdmin and MySQL as database. Since the user master is root, without a password, it's not very secure, but on a local PC, it's very convenient for learning. Later, you will be able to create users with their password, but after you will be assured that everything will work properly and that you will have gained more experience with a real database and its applications. Start your browser and try: `localhost`, while Apache and PHP are started. With `PhpPMyAdmin`, check the MySQL database. To check that nothing is missing, start with `Start - Program - PHPTriad - Apache and MySQL`. The `winmysqladmin.exe, mysqlmanager.exe` and maybe `mysql.exe` programs (from a shell DOS) can also be useful. You will find them in the / bin directory at the following address: `c: \ apache \ mysql \ bin`. With these simple programs, we can run the system, thanks to the PhpMyAdmin interface which is quite simple and powerful. ------------------------------------------------- #### <center>2. Creation of the database</center> ---------------------------------- We will now create a new Database with PhpMyAdmin. For our example it will be named mydb and the table will be named person with the fields described below. Here are the SQL statements and their definitions. We have defined p_id as Primary Key. ``` CREATE TABLE person ( p_nr int (10) NOT NULL, p_anrede char (20), p_titel char (20), p_vname char (30), p_name char (30), p_strasse char (30), p_hnr char (10), p_land char (3), p_plz char (5), p_ort char (30), p_zusatz char (50), p_art smallint (6), p_tel1 char (20), p_id int (10) NOT NULL AUTO_INCREMENT, p_tel2 char (20), p_telm char (20), PRIMARY KEY (p_id) ) ``` As OOo has some problems connecting via JDBC, use PhpMyAdmin to create or delete tables and databases, or use native SQL statements outside of OOo. It works well too. ------------------------------------------------- #### <center>3 . Installing the JDBC driver</center> ---------------------------------- ###### 3 .1 Original method for version 1.0 ---------------------------------- Then you need to install `JDBC driver`. We copy the file mm.mysql-02.4-bin.jar, in the directory `c: \ javaclasses` that we created before. OOo needs to know the way to find the driver. Edit the file: `<Openoffice-InstallDirectory> \ user \ config \ java.ini` with a text editor and completed at `[JAVA]` under `SystemClasspath = this .jar` - file, as below: ``` [Java] Java = 1 JavaScript = 1 Applets = 1 Home = F: \ jdk1.3.1_01 VMType = jdk Version 1.3.1 = RuntimeLib = F: \ jdk1.3.1_01 \ jre \ bin \ hotspot \ jvm.dll SystemClasspath = F: \ javaclasses \ mm.mysql-2.0.11-bin.jar; ... <the old entries are here> ``` ###### 3 .2 Simplified method ---------------------------------- This method can be used from the X.Y.Z version of OpenOffice and does not require editing a ini. It basically consists of adding the connector in the extensions of the Java environment. 1. Download the java plugin for MySQL on the following page: http://www.mysql.com/products/connector-j/ 2. Uncompress the `"mysql-connector-java-3.0.11-stable-bin.jar"` file in the `\ lib \ ext` directory its java installation, typically: `"C: \ Program Files \ Java \ j2re1.4.1_01 \ lib \ ext"` (names can vary by facility and version). 3. Restart OOo, after quitting the quick start. 4. It's close! ------------------------------------------------- #### <center>4 . Connection with OOo</center> ---------------------------------- Now we can start OOo - Under Tools - Data Sources a window opens that will allow you to configure your data source for OpenOffice.org. Here we choose `[New data source]`. On the `[General]` tab Name: `JDBCTest1 (= it's a free name under OOo)` Connection: type of `Bd: JDBC` Url of the data source: `jdbc: mysql: // localhost / mydb` where `localhost` can also be the DNS name of a local network, or the DNS name of your own PC, mydb is the name of the database we created earlier with PhpMyAdmin. Now choose `[JDBC]` `JDBC Driverclass: org.gjt.mm.mysql.Driver` URL: `jdbc: mysql: // localhost / mydb` (which should be inserted now) `Username: root` (since we have not changed the username in MySQL) Password: we leave it empty. Character set: System (you can change later) On the [Tables] tab you should now see the person table that we created earlier. You can create other tables here, as well as other queries, and so on. From this menu you can exit simply by pressing the `F4` key. Here you can now run and work on your MySQL databases via `JDBC`. ------------------------------------------------- #### <center>5 . Examples</center> ---------------------------------- Since I could not write to the database with normal formulas, I tried with Basic and I could write in the database. It seems that when you sent a direct SQL statement or via Basic, you have access rights to the database. With some OpenOffice.org's normal formulas, you can only read them, with the 641C. Here are some examples to connect to a database:- 'Connect to an active connection through a formula:' ``` oConn = thiscomponent.drawpage.forms (0) .ActiveConnection oTables = oConn.Tables () mTableNames = oTables.getElementNames () ``` 'Connecting to an existing DB:' ``` Function GetConnection (sDBName as String) If Not IsNull (oConn) Then oConn.Dispose () End If oDB = CreateUnoService ("com.sun.star.sdb.DatabaseContext") oConn = oDB.GetByName (sDBName) .GetConnection ("", "") end function ``` 'Load a Dialog that is in another Library:' ``` DialogLibraries.LoadLibrary ("Standard") 'Falls of the Dalog in anderer Lib wäre dDB = CreateUnoDialog (DialogLibraries.Standard.DBDia1 dDB.execute () ``` 'For all tables in a DB:' ``` for n = LBound (mTableNames) to UBound (mTableNames) print "Table" + CStr (n) + ":" + mTableNames (n) oMetadata = oConn.getMetadata () if oTables.hasbyName (mTableNames (n)) then msgbox "Tabelle:" + oTables.getbyName (mTableNames (n) + "existiert." end if ``` 'What the DB can:' ``` sSubQuery = oMetadata.supportsSubqueriesInComparisons () sSQL = oMetadata.supportsANSI92EntryLevelSQL () sKeyWords = oMetadata.getSQLKeywords () sMsg = "Subquery support in comparisons" + sSubquery sMsg = sMsg + Chr (13) + "ANSI-SQL:" + sSQL sMsg = sMsg + Chr (13) + sKeywords msgbox sMsg oColumns = oConn.Tables (n) .columns mColumnNames = oColumns.getElementNames () ``` 'For all Columns of the current table:' ``` for n1 = LBound (mColumnNames) to UBound (mColumnNames) sName = mColumnNames (n1) oColumn = oColumns.getByName (sName) sMsg = "Column:" + sName sMsg = sMsg + Chr (13) + "Default Value:" + oColumn.DefaultValue sMsg = sMsg + Chr (13) + "Description:" + oColumn.Description sMsg = sMsg + Chr (13) + "IsAutoIncrement:" + oColumn.IsAutoIncrement sMsg = sMsg + Chr (13) + "IsNullable:" + oColumn.IsNullable sMsg = sMsg + Chr (13) + "IsRowVersion:" + oColumn.IsRowVersion sMsg = sMsg + Chr (13) + "Precision:" + oColumn.Precision sMsg = sMsg + Chr (13) + "Scale:" + oColumn.Scale sMsg = sMsg + Chr (13) + "Type:" + oColumn.Type msgbox sMsg next n1 Next n ``` 'a simple selection' ``` if oTables.hasbyName ("person") then oStatement = oConn.createStatement () oResultset = oStatement.executeQuery ("Select p_id, p_anrede, p_titel, p_vname," _ + "p_name from person where p_anrede = 'Herr'") while oResultset.next print oResultset.getString (1) + ":" + _ oResultset.getString (2) + oResultset.getString (3) + _ oResultset.getString (4) + oResultset.getString (5) Wend end if dim iOK as integer iOK = msgbox ("Neuen Datensatz anlegen?", 1) while iOK = 1 Dim sText As String sText = InputBox ("Irgendwas eingeben:", "Lieber User") MsgBox (sText, 64, "Bitte bestätigen Sie die Eingabe!") iOK = msgbox ("Neuen Datensatz anlegen?", 1) Wend 'exit sub ``` This inserts a function only once, because p_id is a primary key, 'it's only a test to write in the DB:' ``` if oTables.hasbyName ("person") then oStatement = oConn.createStatement () oInsert = oStatement.execute ("insert into person(p_id, p_anrede," + _ "P_titel, p_vname, p_name) values ​​(4, 'Herr', 'Prof. Nat. Rer.'," + _ "Mathias', 'irgendwer')" end if End Sub ``` Exit Dialog ``` sub exit_dialog dDB.endExecute () end sub ``` <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@holudghuri/how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
json metadata{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":24494032,"name":"mysql-server","full_name":"mysql/mysql-server","html_url":"https://github.com/mysql/mysql-server","fork":false,"owner":{"login":"mysql"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","utopian-io","tutorials","mysql"],"moderator":{"account":"rufans","time":"2018-02-04T08:11:50.544Z","flagged":true,"reviewed":false,"pending":false}}
Transaction InfoBlock #19569602/Trx e7af46fcb411e3f2ebc82f7b52d2151442bf5753
View Raw JSON Data
{
  "trx_id": "e7af46fcb411e3f2ebc82f7b52d2151442bf5753",
  "block": 19569602,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-04T08:11:51",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "title": "How to Connect a MySQL Database via a JDBC Driver With OpenOffice.org",
      "body": "\n#### What Will I Learn?\nIn this you will leaRN How to Connect a MySQL Database via a JDBC Driver With OpenOffice.org\nBroadcast by The OpenOffice.org Documentation Project. A short introduction to know how to use a MySQL database via a JDBC driver, under Windows.\n\n- Tutorial object Introduction\n- Creation of the database\n- Installing the JDBC driver\n- Connection with OOo\n- Examples\n\n#### Requirements\nDownload and install MySQL: At the following address: http://www.mysql.org/downloads you will find the database and a graphical interface for `MYSQLGUI`, as well as JDBC driver APIs.\nA very good choice for driving MySQL is `PhpMyAdmin`. For this, you need to do to run a web server with PHP. It's very simple if you use `PHPTriad` or `FOXServer` in the extent that these two tools  are made to install and configure, very simply, a `Web server Apache with MySQL, PHP and PHPMyAdmin`. You can find them at the following addresses:\n\nhttp://sourceforge.net/projects/foxserv\n \nhttp://sourceforge.net/projects/phptriad\n\n#### Difficulty\n- Intermediate\n\n#### Tutorial Contents\n-------------------------------------------------\n#### <center>1 . Introduction</center>\n----------------------------------\nHere I use `PHPTriad` because it is smaller and everything is included without the JDBC drivers.\nAfter launching the installer, you have an Apache web server with PHP, PhpMyAdmin and MySQL as database. Since the user master is root, without a password, it's not very secure, but on a local PC, it's very convenient for learning. Later, you will be able to create users with their password, but after you will be assured that everything will work properly and that you will have gained more experience with a real database and its applications.\n\nStart your browser and try: `localhost`, while Apache and PHP are started. With `PhpPMyAdmin`, check the MySQL database.\nTo check that nothing is missing, start with `Start - Program - PHPTriad - Apache and MySQL`.\nThe `winmysqladmin.exe, mysqlmanager.exe` and maybe `mysql.exe` programs (from a shell DOS) can also be useful. You will find them in the / bin directory at the following address:\n`c: \\ apache \\ mysql \\ bin`. With these simple programs, we can run the system, thanks to the PhpMyAdmin interface which is quite simple and powerful.\n\n-------------------------------------------------\n#### <center>2. Creation of the database</center>\n----------------------------------\nWe will now create a new Database with PhpMyAdmin. For our example it will be named mydb and the table will be named person with the fields described below.\nHere are the SQL statements and their definitions. We have defined p_id as Primary Key.\n```\nCREATE TABLE person (\np_nr int (10) NOT NULL,\np_anrede char (20),\np_titel char (20),\np_vname char (30),\np_name char (30),\np_strasse char (30),\np_hnr char (10),\np_land char (3),\np_plz char (5),\np_ort char (30),\np_zusatz char (50),\np_art smallint (6),\np_tel1 char (20),\np_id int (10) NOT NULL AUTO_INCREMENT,\np_tel2 char (20),\np_telm char (20),\nPRIMARY KEY (p_id)\n)\n```\nAs OOo has some problems connecting via JDBC, use PhpMyAdmin to create or delete tables and databases, or use native SQL statements outside of OOo. It works well too.\n\n-------------------------------------------------\n#### <center>3 . Installing the JDBC driver</center>\n----------------------------------\n###### 3 .1 Original method for version 1.0\n----------------------------------\nThen you need to install `JDBC driver`. We copy the file mm.mysql-02.4-bin.jar, in the directory `c: \\ javaclasses` that we created before.\nOOo needs to know the way to find the driver. Edit the file:\n`<Openoffice-InstallDirectory> \\ user \\ config \\ java.ini` with a text editor and completed at `[JAVA]`\nunder `SystemClasspath = this .jar` - file, as below:\n```\n[Java]\nJava = 1\nJavaScript = 1\nApplets = 1\nHome = F: \\ jdk1.3.1_01\nVMType = jdk\nVersion 1.3.1 =\nRuntimeLib = F: \\ jdk1.3.1_01 \\ jre \\ bin \\ hotspot \\ jvm.dll\nSystemClasspath = F: \\ javaclasses \\ mm.mysql-2.0.11-bin.jar; ... <the old entries are here>\n```\n###### 3 .2 Simplified method\n----------------------------------\nThis method can be used from the X.Y.Z version of OpenOffice and does not require editing a ini. It basically consists of adding the connector in the extensions of the Java environment.\n\n1. Download the java plugin for MySQL on the following page:\nhttp://www.mysql.com/products/connector-j/\n2. Uncompress the `\"mysql-connector-java-3.0.11-stable-bin.jar\"` file in the `\\ lib \\ ext` directory\nits java installation, typically: `\"C: \\ Program Files \\ Java \\ j2re1.4.1_01 \\ lib \\ ext\"` (names can\nvary by facility and version).\n3. Restart OOo, after quitting the quick start.\n4. It's close!\n\n-------------------------------------------------\n#### <center>4 . Connection with OOo</center>\n----------------------------------\nNow we can start OOo - \nUnder Tools - Data Sources a window opens that will allow you to configure your data source for OpenOffice.org.\nHere we choose `[New data source]`.\n\nOn the `[General]` tab\nName: `JDBCTest1 (= it's a free name under OOo)`\nConnection:\ntype of `Bd: JDBC`\nUrl of the data source: `jdbc: mysql: // localhost / mydb`\nwhere `localhost` can also be the DNS name of a local network, or the DNS name of your own PC, mydb is the name of the database we created earlier with PhpMyAdmin.\nNow choose `[JDBC]`\n`JDBC Driverclass: org.gjt.mm.mysql.Driver`\nURL: `jdbc: mysql: // localhost / mydb` (which should be inserted now)\n`Username: root` (since we have not changed the username in MySQL)\nPassword: we leave it empty.\nCharacter set: System (you can change later)\nOn the [Tables] tab you should now see the person table that we created earlier. You can create other tables here, as well as other queries, and so on. From this menu you can exit simply by pressing the `F4` key.\nHere you can now run and work on your MySQL databases via `JDBC`.\n\n-------------------------------------------------\n#### <center>5 . Examples</center>\n----------------------------------\nSince I could not write to the database with normal formulas, I tried with Basic and I could write in the database. It seems that when you sent a direct SQL statement or via Basic, you have access rights to the database. With some OpenOffice.org's normal formulas, you can only read them, with the 641C.\n\nHere are some examples to connect to a database:- \n\n'Connect to an active connection through a formula:'\n```\noConn = thiscomponent.drawpage.forms (0) .ActiveConnection\noTables = oConn.Tables ()\nmTableNames = oTables.getElementNames ()\n```\n\n'Connecting to an existing DB:'\n```\nFunction GetConnection (sDBName as String)\nIf Not IsNull (oConn) Then\noConn.Dispose ()\nEnd If\noDB = CreateUnoService (\"com.sun.star.sdb.DatabaseContext\")\noConn = oDB.GetByName (sDBName) .GetConnection (\"\", \"\")\nend function\n```\n\n'Load a Dialog that is in another Library:'\n```\nDialogLibraries.LoadLibrary (\"Standard\") 'Falls of the Dalog in anderer Lib wäre\ndDB = CreateUnoDialog (DialogLibraries.Standard.DBDia1\ndDB.execute ()\n```\n\n'For all tables in a DB:'\n```\nfor n = LBound (mTableNames) to UBound (mTableNames)\nprint \"Table\" + CStr (n) + \":\" + mTableNames (n)\noMetadata = oConn.getMetadata ()\nif oTables.hasbyName (mTableNames (n)) then\nmsgbox \"Tabelle:\" + oTables.getbyName (mTableNames (n) + \"existiert.\"\nend if\n```\n\n'What the DB can:'\n```\nsSubQuery = oMetadata.supportsSubqueriesInComparisons ()\nsSQL = oMetadata.supportsANSI92EntryLevelSQL ()\nsKeyWords = oMetadata.getSQLKeywords ()\nsMsg = \"Subquery support in comparisons\" + sSubquery\nsMsg = sMsg + Chr (13) + \"ANSI-SQL:\" + sSQL\nsMsg = sMsg + Chr (13) + sKeywords\nmsgbox sMsg\noColumns = oConn.Tables (n) .columns\nmColumnNames = oColumns.getElementNames ()\n```\n\n'For all Columns of the current table:'\n```\nfor n1 = LBound (mColumnNames) to UBound (mColumnNames)\nsName = mColumnNames (n1)\noColumn = oColumns.getByName (sName)\nsMsg = \"Column:\" + sName\nsMsg = sMsg + Chr (13) + \"Default Value:\" + oColumn.DefaultValue\nsMsg = sMsg + Chr (13) + \"Description:\" + oColumn.Description\nsMsg = sMsg + Chr (13) + \"IsAutoIncrement:\" + oColumn.IsAutoIncrement\nsMsg = sMsg + Chr (13) + \"IsNullable:\" + oColumn.IsNullable\nsMsg = sMsg + Chr (13) + \"IsRowVersion:\" + oColumn.IsRowVersion\nsMsg = sMsg + Chr (13) + \"Precision:\" + oColumn.Precision\nsMsg = sMsg + Chr (13) + \"Scale:\" + oColumn.Scale\nsMsg = sMsg + Chr (13) + \"Type:\" + oColumn.Type\nmsgbox sMsg\nnext n1\nNext n\n```\n\n'a simple selection'\n```\nif oTables.hasbyName (\"person\") then\noStatement = oConn.createStatement ()\noResultset = oStatement.executeQuery (\"Select p_id, p_anrede, p_titel, p_vname,\"\n_ +\n\"p_name from person where p_anrede = 'Herr'\")\nwhile oResultset.next\nprint oResultset.getString (1) + \":\" + _\noResultset.getString (2) + oResultset.getString (3) + _\noResultset.getString (4) + oResultset.getString (5)\nWend\nend if\ndim iOK as integer\niOK = msgbox (\"Neuen Datensatz anlegen?\", 1)\nwhile iOK = 1\nDim sText As String\nsText = InputBox (\"Irgendwas eingeben:\", \"Lieber User\")\nMsgBox (sText, 64, \"Bitte bestätigen Sie die Eingabe!\")\niOK = msgbox (\"Neuen Datensatz anlegen?\", 1)\nWend\n'exit sub\n```\nThis inserts a function only once, because p_id is a primary key,\n'it's only a test to write in the DB:'\n```\nif oTables.hasbyName (\"person\") then\noStatement = oConn.createStatement ()\noInsert = oStatement.execute (\"insert into person(p_id, p_anrede,\" + _\n\"P_titel, p_vname, p_name) values ​​(4, 'Herr', 'Prof. Nat. Rer.',\" + _\n\"Mathias', 'irgendwer')\"\nend if\nEnd Sub\n```\nExit Dialog\n```\nsub exit_dialog\ndDB.endExecute ()\nend sub\n```\n   \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@holudghuri/how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":24494032,\"name\":\"mysql-server\",\"full_name\":\"mysql/mysql-server\",\"html_url\":\"https://github.com/mysql/mysql-server\",\"fork\":false,\"owner\":{\"login\":\"mysql\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"utopian-io\",\"tutorials\",\"mysql\"],\"moderator\":{\"account\":\"rufans\",\"time\":\"2018-02-04T08:11:50.544Z\",\"flagged\":true,\"reviewed\":false,\"pending\":false}}"
    }
  ]
}
2018/02/04 06:09:15
voterpinksugar
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
weight10000 (100.00%)
Transaction InfoBlock #19567152/Trx 117be1a98ed103cf89e3c5460648a8147d3fe296
View Raw JSON Data
{
  "trx_id": "117be1a98ed103cf89e3c5460648a8147d3fe296",
  "block": 19567152,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-04T06:09:15",
  "op": [
    "vote",
    {
      "voter": "pinksugar",
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "weight": 10000
    }
  ]
}
holudghurideleted a comment or post
2018/02/04 04:28:39
authorholudghuri
permlinkre-gamer00-2000-followers-wow-20180204t042701227z
Transaction InfoBlock #19565140/Trx f3f65f5a937b798317c60bb8e13721ae980cc5db
View Raw JSON Data
{
  "trx_id": "f3f65f5a937b798317c60bb8e13721ae980cc5db",
  "block": 19565140,
  "trx_in_block": 13,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-04T04:28:39",
  "op": [
    "delete_comment",
    {
      "author": "holudghuri",
      "permlink": "re-gamer00-2000-followers-wow-20180204t042701227z"
    }
  ]
}
2018/02/04 04:27:06
parent authorgamer00
parent permlink2000-followers-wow
authorholudghuri
permlinkre-gamer00-2000-followers-wow-20180204t042701227z
title
bodyHey, Congrats Dear. And I'm happy that i'm one of among them. Continue your good work, It will continue increasing.
json metadata{"tags":["steem"],"app":"steemit/0.1"}
Transaction InfoBlock #19565109/Trx 9905ec0dbb9aa325f05e5c0c4484c74dae4a11db
View Raw JSON Data
{
  "trx_id": "9905ec0dbb9aa325f05e5c0c4484c74dae4a11db",
  "block": 19565109,
  "trx_in_block": 40,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-04T04:27:06",
  "op": [
    "comment",
    {
      "parent_author": "gamer00",
      "parent_permlink": "2000-followers-wow",
      "author": "holudghuri",
      "permlink": "re-gamer00-2000-followers-wow-20180204t042701227z",
      "title": "",
      "body": "Hey, Congrats Dear. And I'm happy that i'm one of among them. Continue your good work, It will continue increasing.",
      "json_metadata": "{\"tags\":[\"steem\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}
2018/02/03 09:28:30
voterwhiteblood
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
weight10000 (100.00%)
Transaction InfoBlock #19542447/Trx 028440986d349d7978bb3653fce9ac7300b28378
View Raw JSON Data
{
  "trx_id": "028440986d349d7978bb3653fce9ac7300b28378",
  "block": 19542447,
  "trx_in_block": 22,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-03T09:28:30",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "weight": 10000
    }
  ]
}
2018/02/03 09:28:18
voterwhiteblood
authorholudghuri
permlinkhow-to-install-and-start-python-in-different-os
weight10000 (100.00%)
Transaction InfoBlock #19542443/Trx 5ea7a0637eba2fe6d6601d662a77a746143f3ae7
View Raw JSON Data
{
  "trx_id": "5ea7a0637eba2fe6d6601d662a77a746143f3ae7",
  "block": 19542443,
  "trx_in_block": 30,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-03T09:28:18",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "how-to-install-and-start-python-in-different-os",
      "weight": 10000
    }
  ]
}
2018/02/03 09:28:06
voterwhiteblood
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
weight10000 (100.00%)
Transaction InfoBlock #19542439/Trx 8f0c7c87fac31103f6c99b1c25eba41f10c9341f
View Raw JSON Data
{
  "trx_id": "8f0c7c87fac31103f6c99b1c25eba41f10c9341f",
  "block": 19542439,
  "trx_in_block": 24,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-03T09:28:06",
  "op": [
    "vote",
    {
      "voter": "whiteblood",
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "weight": 10000
    }
  ]
}
2018/02/02 17:49:33
voterholudghuri
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
weight10000 (100.00%)
Transaction InfoBlock #19523689/Trx 9207c72f80fdae172bb5a6b934167cd4a4907c45
View Raw JSON Data
{
  "trx_id": "9207c72f80fdae172bb5a6b934167cd4a4907c45",
  "block": 19523689,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-02T17:49:33",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "weight": 10000
    }
  ]
}
2018/02/02 17:36:21
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
max accepted payout1000000.000 SBD
percent steem dollars10000
allow votestrue
allow curation rewardstrue
extensions[[0,{"beneficiaries":[{"account":"utopian.pay","weight":2500}]}]]
Transaction InfoBlock #19523426/Trx 53f53d3e5a6e9d93125fe948f561dc380fe6474e
View Raw JSON Data
{
  "trx_id": "53f53d3e5a6e9d93125fe948f561dc380fe6474e",
  "block": 19523426,
  "trx_in_block": 38,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-02T17:36:21",
  "op": [
    "comment_options",
    {
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "utopian.pay",
                "weight": 2500
              }
            ]
          }
        ]
      ]
    }
  ]
}
2018/02/02 17:36:21
parent author
parent permlinkutopian-io
authorholudghuri
permlinkhow-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org
titleHow to Connect a MySQL Database via a JDBC Driver With OpenOffice.org
body #### What Will I Learn? In this you will leaRN How to Connect a MySQL Database via a JDBC Driver With OpenOffice.org Broadcast by The OpenOffice.org Documentation Project. A short introduction to know how to use a MySQL database via a JDBC driver, under Windows. - Tutorial object Introduction - Creation of the database - Installing the JDBC driver - Connection with OOo - Examples #### Requirements Download and install MySQL: At the following address: http://www.mysql.org/downloads you will find the database and a graphical interface for `MYSQLGUI`, as well as JDBC driver APIs. A very good choice for driving MySQL is `PhpMyAdmin`. For this, you need to do to run a web server with PHP. It's very simple if you use `PHPTriad` or `FOXServer` in the extent that these two tools are made to install and configure, very simply, a `Web server Apache with MySQL, PHP and PHPMyAdmin`. You can find them at the following addresses: http://sourceforge.net/projects/foxserv http://sourceforge.net/projects/phptriad #### Difficulty - Intermediate #### Tutorial Contents ------------------------------------------------- #### <center>1 . Introduction</center> ---------------------------------- Here I use `PHPTriad` because it is smaller and everything is included without the JDBC drivers. After launching the installer, you have an Apache web server with PHP, PhpMyAdmin and MySQL as database. Since the user master is root, without a password, it's not very secure, but on a local PC, it's very convenient for learning. Later, you will be able to create users with their password, but after you will be assured that everything will work properly and that you will have gained more experience with a real database and its applications. Start your browser and try: `localhost`, while Apache and PHP are started. With `PhpPMyAdmin`, check the MySQL database. To check that nothing is missing, start with `Start - Program - PHPTriad - Apache and MySQL`. The `winmysqladmin.exe, mysqlmanager.exe` and maybe `mysql.exe` programs (from a shell DOS) can also be useful. You will find them in the / bin directory at the following address: `c: \ apache \ mysql \ bin`. With these simple programs, we can run the system, thanks to the PhpMyAdmin interface which is quite simple and powerful. ------------------------------------------------- #### <center>2. Creation of the database</center> ---------------------------------- We will now create a new Database with PhpMyAdmin. For our example it will be named mydb and the table will be named person with the fields described below. Here are the SQL statements and their definitions. We have defined p_id as Primary Key. ``` CREATE TABLE person ( p_nr int (10) NOT NULL, p_anrede char (20), p_titel char (20), p_vname char (30), p_name char (30), p_strasse char (30), p_hnr char (10), p_land char (3), p_plz char (5), p_ort char (30), p_zusatz char (50), p_art smallint (6), p_tel1 char (20), p_id int (10) NOT NULL AUTO_INCREMENT, p_tel2 char (20), p_telm char (20), PRIMARY KEY (p_id) ) ``` As OOo has some problems connecting via JDBC, use PhpMyAdmin to create or delete tables and databases, or use native SQL statements outside of OOo. It works well too. ------------------------------------------------- #### <center>3 . Installing the JDBC driver</center> ---------------------------------- ###### 3 .1 Original method for version 1.0 ---------------------------------- Then you need to install `JDBC driver`. We copy the file mm.mysql-02.4-bin.jar, in the directory `c: \ javaclasses` that we created before. OOo needs to know the way to find the driver. Edit the file: `<Openoffice-InstallDirectory> \ user \ config \ java.ini` with a text editor and completed at `[JAVA]` under `SystemClasspath = this .jar` - file, as below: ``` [Java] Java = 1 JavaScript = 1 Applets = 1 Home = F: \ jdk1.3.1_01 VMType = jdk Version 1.3.1 = RuntimeLib = F: \ jdk1.3.1_01 \ jre \ bin \ hotspot \ jvm.dll SystemClasspath = F: \ javaclasses \ mm.mysql-2.0.11-bin.jar; ... <the old entries are here> ``` ###### 3 .2 Simplified method ---------------------------------- This method can be used from the X.Y.Z version of OpenOffice and does not require editing a ini. It basically consists of adding the connector in the extensions of the Java environment. 1. Download the java plugin for MySQL on the following page: http://www.mysql.com/products/connector-j/ 2. Uncompress the `"mysql-connector-java-3.0.11-stable-bin.jar"` file in the `\ lib \ ext` directory its java installation, typically: `"C: \ Program Files \ Java \ j2re1.4.1_01 \ lib \ ext"` (names can vary by facility and version). 3. Restart OOo, after quitting the quick start. 4. It's close! ------------------------------------------------- #### <center>4 . Connection with OOo</center> ---------------------------------- Now we can start OOo - Under Tools - Data Sources a window opens that will allow you to configure your data source for OpenOffice.org. Here we choose `[New data source]`. On the `[General]` tab Name: `JDBCTest1 (= it's a free name under OOo)` Connection: type of `Bd: JDBC` Url of the data source: `jdbc: mysql: // localhost / mydb` where `localhost` can also be the DNS name of a local network, or the DNS name of your own PC, mydb is the name of the database we created earlier with PhpMyAdmin. Now choose `[JDBC]` `JDBC Driverclass: org.gjt.mm.mysql.Driver` URL: `jdbc: mysql: // localhost / mydb` (which should be inserted now) `Username: root` (since we have not changed the username in MySQL) Password: we leave it empty. Character set: System (you can change later) On the [Tables] tab you should now see the person table that we created earlier. You can create other tables here, as well as other queries, and so on. From this menu you can exit simply by pressing the `F4` key. Here you can now run and work on your MySQL databases via `JDBC`. ------------------------------------------------- #### <center>5 . Examples</center> ---------------------------------- Since I could not write to the database with normal formulas, I tried with Basic and I could write in the database. It seems that when you sent a direct SQL statement or via Basic, you have access rights to the database. With some OpenOffice.org's normal formulas, you can only read them, with the 641C. Here are some examples to connect to a database:- 'Connect to an active connection through a formula:' ``` oConn = thiscomponent.drawpage.forms (0) .ActiveConnection oTables = oConn.Tables () mTableNames = oTables.getElementNames () ``` 'Connecting to an existing DB:' ``` Function GetConnection (sDBName as String) If Not IsNull (oConn) Then oConn.Dispose () End If oDB = CreateUnoService ("com.sun.star.sdb.DatabaseContext") oConn = oDB.GetByName (sDBName) .GetConnection ("", "") end function ``` 'Load a Dialog that is in another Library:' ``` DialogLibraries.LoadLibrary ("Standard") 'Falls of the Dalog in anderer Lib wäre dDB = CreateUnoDialog (DialogLibraries.Standard.DBDia1 dDB.execute () ``` 'For all tables in a DB:' ``` for n = LBound (mTableNames) to UBound (mTableNames) print "Table" + CStr (n) + ":" + mTableNames (n) oMetadata = oConn.getMetadata () if oTables.hasbyName (mTableNames (n)) then msgbox "Tabelle:" + oTables.getbyName (mTableNames (n) + "existiert." end if ``` 'What the DB can:' ``` sSubQuery = oMetadata.supportsSubqueriesInComparisons () sSQL = oMetadata.supportsANSI92EntryLevelSQL () sKeyWords = oMetadata.getSQLKeywords () sMsg = "Subquery support in comparisons" + sSubquery sMsg = sMsg + Chr (13) + "ANSI-SQL:" + sSQL sMsg = sMsg + Chr (13) + sKeywords msgbox sMsg oColumns = oConn.Tables (n) .columns mColumnNames = oColumns.getElementNames () ``` 'For all Columns of the current table:' ``` for n1 = LBound (mColumnNames) to UBound (mColumnNames) sName = mColumnNames (n1) oColumn = oColumns.getByName (sName) sMsg = "Column:" + sName sMsg = sMsg + Chr (13) + "Default Value:" + oColumn.DefaultValue sMsg = sMsg + Chr (13) + "Description:" + oColumn.Description sMsg = sMsg + Chr (13) + "IsAutoIncrement:" + oColumn.IsAutoIncrement sMsg = sMsg + Chr (13) + "IsNullable:" + oColumn.IsNullable sMsg = sMsg + Chr (13) + "IsRowVersion:" + oColumn.IsRowVersion sMsg = sMsg + Chr (13) + "Precision:" + oColumn.Precision sMsg = sMsg + Chr (13) + "Scale:" + oColumn.Scale sMsg = sMsg + Chr (13) + "Type:" + oColumn.Type msgbox sMsg next n1 Next n ``` 'a simple selection' ``` if oTables.hasbyName ("person") then oStatement = oConn.createStatement () oResultset = oStatement.executeQuery ("Select p_id, p_anrede, p_titel, p_vname," _ + "p_name from person where p_anrede = 'Herr'") while oResultset.next print oResultset.getString (1) + ":" + _ oResultset.getString (2) + oResultset.getString (3) + _ oResultset.getString (4) + oResultset.getString (5) Wend end if dim iOK as integer iOK = msgbox ("Neuen Datensatz anlegen?", 1) while iOK = 1 Dim sText As String sText = InputBox ("Irgendwas eingeben:", "Lieber User") MsgBox (sText, 64, "Bitte bestätigen Sie die Eingabe!") iOK = msgbox ("Neuen Datensatz anlegen?", 1) Wend 'exit sub ``` This inserts a function only once, because p_id is a primary key, 'it's only a test to write in the DB:' ``` if oTables.hasbyName ("person") then oStatement = oConn.createStatement () oInsert = oStatement.execute ("insert into person(p_id, p_anrede," + _ "P_titel, p_vname, p_name) values ​​(4, 'Herr', 'Prof. Nat. Rer.'," + _ "Mathias', 'irgendwer')" end if End Sub ``` Exit Dialog ``` sub exit_dialog dDB.endExecute () end sub ``` <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@holudghuri/how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
json metadata{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":24494032,"name":"mysql-server","full_name":"mysql/mysql-server","html_url":"https://github.com/mysql/mysql-server","fork":false,"owner":{"login":"mysql"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","utopian-io","tutorials","mysql"]}
Transaction InfoBlock #19523426/Trx 53f53d3e5a6e9d93125fe948f561dc380fe6474e
View Raw JSON Data
{
  "trx_id": "53f53d3e5a6e9d93125fe948f561dc380fe6474e",
  "block": 19523426,
  "trx_in_block": 38,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-02T17:36:21",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "author": "holudghuri",
      "permlink": "how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org",
      "title": "How to Connect a MySQL Database via a JDBC Driver With OpenOffice.org",
      "body": "\n#### What Will I Learn?\nIn this you will leaRN How to Connect a MySQL Database via a JDBC Driver With OpenOffice.org\nBroadcast by The OpenOffice.org Documentation Project. A short introduction to know how to use a MySQL database via a JDBC driver, under Windows.\n\n- Tutorial object Introduction\n- Creation of the database\n- Installing the JDBC driver\n- Connection with OOo\n- Examples\n\n#### Requirements\nDownload and install MySQL: At the following address: http://www.mysql.org/downloads you will find the database and a graphical interface for `MYSQLGUI`, as well as JDBC driver APIs.\nA very good choice for driving MySQL is `PhpMyAdmin`. For this, you need to do to run a web server with PHP. It's very simple if you use `PHPTriad` or `FOXServer` in the extent that these two tools  are made to install and configure, very simply, a `Web server Apache with MySQL, PHP and PHPMyAdmin`. You can find them at the following addresses:\n\nhttp://sourceforge.net/projects/foxserv\n \nhttp://sourceforge.net/projects/phptriad\n\n#### Difficulty\n- Intermediate\n\n#### Tutorial Contents\n-------------------------------------------------\n#### <center>1 . Introduction</center>\n----------------------------------\nHere I use `PHPTriad` because it is smaller and everything is included without the JDBC drivers.\nAfter launching the installer, you have an Apache web server with PHP, PhpMyAdmin and MySQL as database. Since the user master is root, without a password, it's not very secure, but on a local PC, it's very convenient for learning. Later, you will be able to create users with their password, but after you will be assured that everything will work properly and that you will have gained more experience with a real database and its applications.\n\nStart your browser and try: `localhost`, while Apache and PHP are started. With `PhpPMyAdmin`, check the MySQL database.\nTo check that nothing is missing, start with `Start - Program - PHPTriad - Apache and MySQL`.\nThe `winmysqladmin.exe, mysqlmanager.exe` and maybe `mysql.exe` programs (from a shell DOS) can also be useful. You will find them in the / bin directory at the following address:\n`c: \\ apache \\ mysql \\ bin`. With these simple programs, we can run the system, thanks to the PhpMyAdmin interface which is quite simple and powerful.\n\n-------------------------------------------------\n#### <center>2. Creation of the database</center>\n----------------------------------\nWe will now create a new Database with PhpMyAdmin. For our example it will be named mydb and the table will be named person with the fields described below.\nHere are the SQL statements and their definitions. We have defined p_id as Primary Key.\n```\nCREATE TABLE person (\np_nr int (10) NOT NULL,\np_anrede char (20),\np_titel char (20),\np_vname char (30),\np_name char (30),\np_strasse char (30),\np_hnr char (10),\np_land char (3),\np_plz char (5),\np_ort char (30),\np_zusatz char (50),\np_art smallint (6),\np_tel1 char (20),\np_id int (10) NOT NULL AUTO_INCREMENT,\np_tel2 char (20),\np_telm char (20),\nPRIMARY KEY (p_id)\n)\n```\nAs OOo has some problems connecting via JDBC, use PhpMyAdmin to create or delete tables and databases, or use native SQL statements outside of OOo. It works well too.\n\n-------------------------------------------------\n#### <center>3 . Installing the JDBC driver</center>\n----------------------------------\n###### 3 .1 Original method for version 1.0\n----------------------------------\nThen you need to install `JDBC driver`. We copy the file mm.mysql-02.4-bin.jar, in the directory `c: \\ javaclasses` that we created before.\nOOo needs to know the way to find the driver. Edit the file:\n`<Openoffice-InstallDirectory> \\ user \\ config \\ java.ini` with a text editor and completed at `[JAVA]`\nunder `SystemClasspath = this .jar` - file, as below:\n```\n[Java]\nJava = 1\nJavaScript = 1\nApplets = 1\nHome = F: \\ jdk1.3.1_01\nVMType = jdk\nVersion 1.3.1 =\nRuntimeLib = F: \\ jdk1.3.1_01 \\ jre \\ bin \\ hotspot \\ jvm.dll\nSystemClasspath = F: \\ javaclasses \\ mm.mysql-2.0.11-bin.jar; ... <the old entries are here>\n```\n###### 3 .2 Simplified method\n----------------------------------\nThis method can be used from the X.Y.Z version of OpenOffice and does not require editing a ini. It basically consists of adding the connector in the extensions of the Java environment.\n\n1. Download the java plugin for MySQL on the following page:\nhttp://www.mysql.com/products/connector-j/\n2. Uncompress the `\"mysql-connector-java-3.0.11-stable-bin.jar\"` file in the `\\ lib \\ ext` directory\nits java installation, typically: `\"C: \\ Program Files \\ Java \\ j2re1.4.1_01 \\ lib \\ ext\"` (names can\nvary by facility and version).\n3. Restart OOo, after quitting the quick start.\n4. It's close!\n\n-------------------------------------------------\n#### <center>4 . Connection with OOo</center>\n----------------------------------\nNow we can start OOo - \nUnder Tools - Data Sources a window opens that will allow you to configure your data source for OpenOffice.org.\nHere we choose `[New data source]`.\n\nOn the `[General]` tab\nName: `JDBCTest1 (= it's a free name under OOo)`\nConnection:\ntype of `Bd: JDBC`\nUrl of the data source: `jdbc: mysql: // localhost / mydb`\nwhere `localhost` can also be the DNS name of a local network, or the DNS name of your own PC, mydb is the name of the database we created earlier with PhpMyAdmin.\nNow choose `[JDBC]`\n`JDBC Driverclass: org.gjt.mm.mysql.Driver`\nURL: `jdbc: mysql: // localhost / mydb` (which should be inserted now)\n`Username: root` (since we have not changed the username in MySQL)\nPassword: we leave it empty.\nCharacter set: System (you can change later)\nOn the [Tables] tab you should now see the person table that we created earlier. You can create other tables here, as well as other queries, and so on. From this menu you can exit simply by pressing the `F4` key.\nHere you can now run and work on your MySQL databases via `JDBC`.\n\n-------------------------------------------------\n#### <center>5 . Examples</center>\n----------------------------------\nSince I could not write to the database with normal formulas, I tried with Basic and I could write in the database. It seems that when you sent a direct SQL statement or via Basic, you have access rights to the database. With some OpenOffice.org's normal formulas, you can only read them, with the 641C.\n\nHere are some examples to connect to a database:- \n\n'Connect to an active connection through a formula:'\n```\noConn = thiscomponent.drawpage.forms (0) .ActiveConnection\noTables = oConn.Tables ()\nmTableNames = oTables.getElementNames ()\n```\n\n'Connecting to an existing DB:'\n```\nFunction GetConnection (sDBName as String)\nIf Not IsNull (oConn) Then\noConn.Dispose ()\nEnd If\noDB = CreateUnoService (\"com.sun.star.sdb.DatabaseContext\")\noConn = oDB.GetByName (sDBName) .GetConnection (\"\", \"\")\nend function\n```\n\n'Load a Dialog that is in another Library:'\n```\nDialogLibraries.LoadLibrary (\"Standard\") 'Falls of the Dalog in anderer Lib wäre\ndDB = CreateUnoDialog (DialogLibraries.Standard.DBDia1\ndDB.execute ()\n```\n\n'For all tables in a DB:'\n```\nfor n = LBound (mTableNames) to UBound (mTableNames)\nprint \"Table\" + CStr (n) + \":\" + mTableNames (n)\noMetadata = oConn.getMetadata ()\nif oTables.hasbyName (mTableNames (n)) then\nmsgbox \"Tabelle:\" + oTables.getbyName (mTableNames (n) + \"existiert.\"\nend if\n```\n\n'What the DB can:'\n```\nsSubQuery = oMetadata.supportsSubqueriesInComparisons ()\nsSQL = oMetadata.supportsANSI92EntryLevelSQL ()\nsKeyWords = oMetadata.getSQLKeywords ()\nsMsg = \"Subquery support in comparisons\" + sSubquery\nsMsg = sMsg + Chr (13) + \"ANSI-SQL:\" + sSQL\nsMsg = sMsg + Chr (13) + sKeywords\nmsgbox sMsg\noColumns = oConn.Tables (n) .columns\nmColumnNames = oColumns.getElementNames ()\n```\n\n'For all Columns of the current table:'\n```\nfor n1 = LBound (mColumnNames) to UBound (mColumnNames)\nsName = mColumnNames (n1)\noColumn = oColumns.getByName (sName)\nsMsg = \"Column:\" + sName\nsMsg = sMsg + Chr (13) + \"Default Value:\" + oColumn.DefaultValue\nsMsg = sMsg + Chr (13) + \"Description:\" + oColumn.Description\nsMsg = sMsg + Chr (13) + \"IsAutoIncrement:\" + oColumn.IsAutoIncrement\nsMsg = sMsg + Chr (13) + \"IsNullable:\" + oColumn.IsNullable\nsMsg = sMsg + Chr (13) + \"IsRowVersion:\" + oColumn.IsRowVersion\nsMsg = sMsg + Chr (13) + \"Precision:\" + oColumn.Precision\nsMsg = sMsg + Chr (13) + \"Scale:\" + oColumn.Scale\nsMsg = sMsg + Chr (13) + \"Type:\" + oColumn.Type\nmsgbox sMsg\nnext n1\nNext n\n```\n\n'a simple selection'\n```\nif oTables.hasbyName (\"person\") then\noStatement = oConn.createStatement ()\noResultset = oStatement.executeQuery (\"Select p_id, p_anrede, p_titel, p_vname,\"\n_ +\n\"p_name from person where p_anrede = 'Herr'\")\nwhile oResultset.next\nprint oResultset.getString (1) + \":\" + _\noResultset.getString (2) + oResultset.getString (3) + _\noResultset.getString (4) + oResultset.getString (5)\nWend\nend if\ndim iOK as integer\niOK = msgbox (\"Neuen Datensatz anlegen?\", 1)\nwhile iOK = 1\nDim sText As String\nsText = InputBox (\"Irgendwas eingeben:\", \"Lieber User\")\nMsgBox (sText, 64, \"Bitte bestätigen Sie die Eingabe!\")\niOK = msgbox (\"Neuen Datensatz anlegen?\", 1)\nWend\n'exit sub\n```\nThis inserts a function only once, because p_id is a primary key,\n'it's only a test to write in the DB:'\n```\nif oTables.hasbyName (\"person\") then\noStatement = oConn.createStatement ()\noInsert = oStatement.execute (\"insert into person(p_id, p_anrede,\" + _\n\"P_titel, p_vname, p_name) values ​​(4, 'Herr', 'Prof. Nat. Rer.',\" + _\n\"Mathias', 'irgendwer')\"\nend if\nEnd Sub\n```\nExit Dialog\n```\nsub exit_dialog\ndDB.endExecute ()\nend sub\n```\n   \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@holudghuri/how-to-connect-a-mysql-database-via-a-jdbc-driver-with-openoffice-org\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":24494032,\"name\":\"mysql-server\",\"full_name\":\"mysql/mysql-server\",\"html_url\":\"https://github.com/mysql/mysql-server\",\"fork\":false,\"owner\":{\"login\":\"mysql\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"utopian-io\",\"tutorials\",\"mysql\"]}"
    }
  ]
}
2018/02/01 17:15:45
voterholudghuri
authorbikash-tutor
permlinkwhat-will-be-the-price-of-bitcoin-ab00af5ccb102
weight10000 (100.00%)
Transaction InfoBlock #19494262/Trx 2fbbb8b4f1ee5261ba2bb24d24111ccd595781d6
View Raw JSON Data
{
  "trx_id": "2fbbb8b4f1ee5261ba2bb24d24111ccd595781d6",
  "block": 19494262,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T17:15:45",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "bikash-tutor",
      "permlink": "what-will-be-the-price-of-bitcoin-ab00af5ccb102",
      "weight": 10000
    }
  ]
}
2018/02/01 17:15:36
voterholudghuri
authorface2face
permlinkthe-roadside-drum-proof-of-artist-talent-61bf0d061e5a2
weight10000 (100.00%)
Transaction InfoBlock #19494259/Trx 367cd2b8cefc70797ad10de2d51ebb4aa69fd8d3
View Raw JSON Data
{
  "trx_id": "367cd2b8cefc70797ad10de2d51ebb4aa69fd8d3",
  "block": 19494259,
  "trx_in_block": 50,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T17:15:36",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "face2face",
      "permlink": "the-roadside-drum-proof-of-artist-talent-61bf0d061e5a2",
      "weight": 10000
    }
  ]
}
2018/02/01 17:15:30
voterholudghuri
authorface2face
permlinkesteem-app-calculate-less-time-than-steemit-or-utopian
weight10000 (100.00%)
Transaction InfoBlock #19494257/Trx 3cc774d2cb26a406f1400c8c12b04f6e5b250452
View Raw JSON Data
{
  "trx_id": "3cc774d2cb26a406f1400c8c12b04f6e5b250452",
  "block": 19494257,
  "trx_in_block": 33,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T17:15:30",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "face2face",
      "permlink": "esteem-app-calculate-less-time-than-steemit-or-utopian",
      "weight": 10000
    }
  ]
}
2018/02/01 17:15:24
voterholudghuri
authorface2face
permlinkthe-slate-it-was-my-first-writing-pad-did-you-use-it-48b91fcc217d
weight10000 (100.00%)
Transaction InfoBlock #19494255/Trx 44ced5656dae6db20c5ac53e975b0c5e4e393990
View Raw JSON Data
{
  "trx_id": "44ced5656dae6db20c5ac53e975b0c5e4e393990",
  "block": 19494255,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T17:15:24",
  "op": [
    "vote",
    {
      "voter": "holudghuri",
      "author": "face2face",
      "permlink": "the-slate-it-was-my-first-writing-pad-did-you-use-it-48b91fcc217d",
      "weight": 10000
    }
  ]
}
2018/02/01 01:25:36
votervishalsingh4997
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
weight5000 (50.00%)
Transaction InfoBlock #19475296/Trx 0bee7859a89c5eac24e95aad3d10afc31e9486c8
View Raw JSON Data
{
  "trx_id": "0bee7859a89c5eac24e95aad3d10afc31e9486c8",
  "block": 19475296,
  "trx_in_block": 29,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T01:25:36",
  "op": [
    "vote",
    {
      "voter": "vishalsingh4997",
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "weight": 5000
    }
  ]
}
2018/02/01 01:25:36
voterjatinhota
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
weight2000 (20.00%)
Transaction InfoBlock #19475296/Trx 832131b4a7f8281b4a19df3ac480c1f3ef7a9f4f
View Raw JSON Data
{
  "trx_id": "832131b4a7f8281b4a19df3ac480c1f3ef7a9f4f",
  "block": 19475296,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T01:25:36",
  "op": [
    "vote",
    {
      "voter": "jatinhota",
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "weight": 2000
    }
  ]
}
2018/02/01 01:25:36
voterinuke
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
weight5000 (50.00%)
Transaction InfoBlock #19475296/Trx b43907e2e252273a883e1163a68aafb929e33dac
View Raw JSON Data
{
  "trx_id": "b43907e2e252273a883e1163a68aafb929e33dac",
  "block": 19475296,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T01:25:36",
  "op": [
    "vote",
    {
      "voter": "inuke",
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "weight": 5000
    }
  ]
}
2018/02/01 01:25:36
voterbobinson
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
weight2500 (25.00%)
Transaction InfoBlock #19475296/Trx beee6caa12ec3eafc98faa5ca71405de14cf97f6
View Raw JSON Data
{
  "trx_id": "beee6caa12ec3eafc98faa5ca71405de14cf97f6",
  "block": 19475296,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T01:25:36",
  "op": [
    "vote",
    {
      "voter": "bobinson",
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "weight": 2500
    }
  ]
}
2018/02/01 01:25:09
voterindiaunited
authorholudghuri
permlinkcolorchallenge-wednesday-yellow
weight5000 (50.00%)
Transaction InfoBlock #19475287/Trx 324f9f5dae8a78ad2c52ec5e187699bd2f617ba7
View Raw JSON Data
{
  "trx_id": "324f9f5dae8a78ad2c52ec5e187699bd2f617ba7",
  "block": 19475287,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-01T01:25:09",
  "op": [
    "vote",
    {
      "voter": "indiaunited",
      "author": "holudghuri",
      "permlink": "colorchallenge-wednesday-yellow",
      "weight": 5000
    }
  ]
}

Account Metadata

POSTING JSON METADATA
profile{"profile_image":"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-9/18740057_10208064316719440_8847351601194015927_n.jpg?oh=a43ba61c6ff81dd5d0d49a8f873cdea0&oe=5A29FFC8","cover_image":"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-0/p206x206/424831_3767512600095_357169424_n.jpg?oh=238cc56b0b677eb090b306c68a8f3ebf&oe=5A325F33","name":"Sam","location":"Kolkata, INDIA"}
JSON METADATA
profile{"profile_image":"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-9/18740057_10208064316719440_8847351601194015927_n.jpg?oh=a43ba61c6ff81dd5d0d49a8f873cdea0&oe=5A29FFC8","cover_image":"https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-0/p206x206/424831_3767512600095_357169424_n.jpg?oh=238cc56b0b677eb090b306c68a8f3ebf&oe=5A325F33","name":"Sam","location":"Kolkata, INDIA"}
{
  "posting_json_metadata": {
    "profile": {
      "profile_image": "https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-9/18740057_10208064316719440_8847351601194015927_n.jpg?oh=a43ba61c6ff81dd5d0d49a8f873cdea0&oe=5A29FFC8",
      "cover_image": "https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-0/p206x206/424831_3767512600095_357169424_n.jpg?oh=238cc56b0b677eb090b306c68a8f3ebf&oe=5A325F33",
      "name": "Sam",
      "location": "Kolkata, INDIA"
    }
  },
  "json_metadata": {
    "profile": {
      "profile_image": "https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-9/18740057_10208064316719440_8847351601194015927_n.jpg?oh=a43ba61c6ff81dd5d0d49a8f873cdea0&oe=5A29FFC8",
      "cover_image": "https://scontent.fccu4-1.fna.fbcdn.net/v/t1.0-0/p206x206/424831_3767512600095_357169424_n.jpg?oh=238cc56b0b677eb090b306c68a8f3ebf&oe=5A325F33",
      "name": "Sam",
      "location": "Kolkata, INDIA"
    }
  }
}

Auth Keys

Owner
Single Signature
Public Keys
STM5TAxygjMdXNTHmsPi8RAYxEcyJ7ZC42SocJ1QUSWiPcWBFUShh1/1
Active
Single Signature
Public Keys
STM6jdXKmWL2oQXW8VZZ3xpZi3ivokAaSAQzmyAG7N2WhxrdAi3iw1/1
Posting
Single Signature
Public Keys
STM7oCSwsTpDhPxiMjGuDiMAnSeCWQZ9StQN7TtsVE4Lb7Ansgz9R1/1
App Permissions
Memo
STM7qgTduzkAgvw4X4VEkAGMZjsaEZtAMwsHqTqVhmHrs7qfKoQf9
{
  "owner": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM5TAxygjMdXNTHmsPi8RAYxEcyJ7ZC42SocJ1QUSWiPcWBFUShh",
        1
      ]
    ]
  },
  "active": {
    "weight_threshold": 1,
    "account_auths": [],
    "key_auths": [
      [
        "STM6jdXKmWL2oQXW8VZZ3xpZi3ivokAaSAQzmyAG7N2WhxrdAi3iw",
        1
      ]
    ]
  },
  "posting": {
    "weight_threshold": 1,
    "account_auths": [
      [
        "busy.app",
        1
      ],
      [
        "dmania.app",
        1
      ],
      [
        "utopian.app",
        1
      ]
    ],
    "key_auths": [
      [
        "STM7oCSwsTpDhPxiMjGuDiMAnSeCWQZ9StQN7TtsVE4Lb7Ansgz9R",
        1
      ]
    ]
  },
  "memo": "STM7qgTduzkAgvw4X4VEkAGMZjsaEZtAMwsHqTqVhmHrs7qfKoQf9"
}

Witness Votes

0 / 30
No active witness votes.
[]