#### Repository https://github.com/programarivm/pgn-chess  PGN Chess for PHP is a simple, friendly, and powerful PGN (Portable Game Notation) library for running chess games from within PHP applications. It is a chess board representation that can be used in chess engines, chess applications and chess algorithms. ### New Features A command line interface (CLI) is created with the aim to convert PGN files into MySQL scripts. More specifically, [Feature/pgntosql](https://github.com/programarivm/pgn-chess/pull/2) implements the following two commands. Creates a MySQL PGN Chess database: php cli/createdb.php This will remove the current PGN Chess database and the data will be lost. Do you want to proceed? (Y/N): y Converts a PGN file into a MySQL INSERT statement: php cli/pgntomysql.php example.pgn > example.sql > **Note**: `pgntomysql.php` works okay with a syntactically valid PGN file as a precondition. #### Roadmap A command that checks the syntax of PGN files has to be created in another PR. - `pgnsyntax.php` For further information visit section [4. Command Line Interface (CLI)](https://github.com/programarivm/pgn-chess#4-command-line-interface-cli) #### Would you help make this library better? Contributions are welcome. - Feel free to send a pull request - Drop an email at info@programarivm.com with the subject "PGN Chess Contributions" - Leave me a comment on [Twitter](https://twitter.com/programarivm) - Say hello on [Google+](https://plus.google.com/+Programarivm) Many thanks. #### GitHub Account https://github.com/programarivm/pgn-chess
author | programarivm |
---|---|
permlink | php-command-that-converts-a-pgn-file-into-a-mysql-script |
category | utopian-io |
json_metadata | {"tags":["utopian-io","development","pgn","chess","php"],"image":["https://cdn.steemitimages.com/DQmSw8n37fh2Y7wMLnVuXwpoocrH5rEWA4tRhtbceZ4Zwbx/black-chess-pieces.jpg"],"links":["https://github.com/programarivm/pgn-chess","https://github.com/programarivm/pgn-chess/pull/2","https://github.com/programarivm/pgn-chess#4-command-line-interface-cli","https://twitter.com/programarivm","https://plus.google.com/+Programarivm"],"app":"steemit/0.1","format":"markdown"} |
created | 2018-08-18 11:31:15 |
last_update | 2018-08-19 21:43:06 |
depth | 0 |
children | 8 |
last_payout | 2018-08-25 11:31:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 36.450 HBD |
curator_payout_value | 12.108 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,731 |
author_reputation | 2,631,258,794,707 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,592,498 |
net_rshares | 36,428,144,424,224 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
steemitboard | 0 | 917,414,783 | 1% | ||
doughtaker | 0 | 9,717,253,272 | 50% | ||
rafalski | 0 | 13,219,342,208 | 26% | ||
jamescash | 0 | 810,462,361 | 100% | ||
andrejcibik | 0 | 81,525,134,293 | 100% | ||
crokkon | 0 | 19,742,329,319 | 40% | ||
osm0sis | 0 | 8,477,053,312 | 20% | ||
utopian-io | 0 | 34,922,431,610,451 | 22.88% | ||
jaff8 | 0 | 83,134,823,779 | 100% | ||
zapncrap | 0 | 19,531,871,029 | 50% | ||
amosbastian | 0 | 25,843,463,740 | 41.6% | ||
tdre | 0 | 4,472,709,496 | 100% | ||
curx | 0 | 17,867,861,044 | 50% | ||
jjay | 0 | 854,401,658 | 100% | ||
aldenio | 0 | 416,188,227 | 100% | ||
nafestw | 0 | 10,642,237,021 | 70% | ||
iauns | 0 | 19,064,708,017 | 100% | ||
alphabot | 0 | 81,247,303 | 1% | ||
steem-ua | 0 | 1,189,394,312,911 | 51.96% |
Hi there, Welcome to STEEM blockchain. A couple for feedbacks for your future contributions: It would be better starting the post with a little explanation about the project, before going deep on the new features/changes. Also, regarding the *"How did I implement it?"* instead of sharing the code/PR directly, you may add a couple of sentences to enrich the content that what was the challenge, how did you solve them, what can be done in the feature, etc. *** Your contribution has been evaluated according to [Utopian policies and guidelines](https://join.utopian.io/guidelines), as well as a predefined set of questions pertaining to the category. To view those questions and the relevant answers related to your post, [click here](https://review.utopian.io/result/3/3322221). ---- Need help? Write a ticket on https://support.utopian.io/. Chat with us on [Discord](https://discord.gg/uTyJkNm). [[utopian-moderator]](https://join.utopian.io/)
author | emrebeyler |
---|---|
permlink | re-programarivm-php-command-that-converts-a-pgn-file-into-a-mysql-script-20180818t130745769z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"links":["https://join.utopian.io/guidelines","https://review.utopian.io/result/3/3322221","https://support.utopian.io/","https://discord.gg/uTyJkNm","https://join.utopian.io/"],"app":"steemit/0.1"} |
created | 2018-08-18 13:07:45 |
last_update | 2018-08-18 13:07:45 |
depth | 1 |
children | 2 |
last_payout | 2018-08-25 13:07:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 7.612 HBD |
curator_payout_value | 2.507 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 956 |
author_reputation | 448,535,049,068,622 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,599,545 |
net_rshares | 7,627,661,981,512 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
mys | 0 | 12,516,893,662 | 13.29% | ||
espoem | 0 | 17,097,092,469 | 15% | ||
utopian-io | 0 | 7,591,870,276,528 | 4.74% | ||
amosbastian | 0 | 5,857,851,781 | 8.95% | ||
mops2e | 0 | 319,867,072 | 10% |
Thank you for the feedback.
author | programarivm |
---|---|
permlink | re-emrebeyler-re-programarivm-php-command-that-converts-a-pgn-file-into-a-mysql-script-20180818t151915857z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"app":"steemit/0.1"} |
created | 2018-08-18 15:19:15 |
last_update | 2018-08-18 15:19:15 |
depth | 2 |
children | 0 |
last_payout | 2018-08-25 15:19:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 27 |
author_reputation | 2,631,258,794,707 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,610,658 |
net_rshares | 0 |
Thank you for your review, @emrebeyler! So far this week you've reviewed 4 contributions. Keep up the good work!
author | utopian-io |
---|---|
permlink | re-re-programarivm-php-command-that-converts-a-pgn-file-into-a-mysql-script-20180818t130745769z-20180820t171007z |
category | utopian-io |
json_metadata | "{"app": "beem/0.19.42"}" |
created | 2018-08-20 17:10:09 |
last_update | 2018-08-20 17:10:09 |
depth | 2 |
children | 0 |
last_payout | 2018-08-27 17:10:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 113 |
author_reputation | 152,955,367,999,756 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,825,728 |
net_rshares | 0 |
Hi @programarivm! We are @steem-ua, a new Steem dApp, computing UserAuthority for all accounts on Steem. We are currently in test modus upvoting quality Utopian-io contributions! Nice work!
author | steem-ua |
---|---|
permlink | re-php-command-that-converts-a-pgn-file-into-a-mysql-script-20180818t152106z |
category | utopian-io |
json_metadata | "{"app": "beem/0.19.54"}" |
created | 2018-08-18 15:21:06 |
last_update | 2018-08-18 15:21:06 |
depth | 1 |
children | 1 |
last_payout | 2018-08-25 15:21:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.069 HBD |
curator_payout_value | 0.022 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 189 |
author_reputation | 23,214,230,978,060 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,610,837 |
net_rshares | 69,980,144,467 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
scipio | 0 | 69,980,144,467 | 100% |
Hi @steem-ua. Thank you, that sounds encouraging! Now I am writing the PGN syntax checker.
author | programarivm |
---|---|
permlink | re-steem-ua-re-php-command-that-converts-a-pgn-file-into-a-mysql-script-20180818t152106z-20180818t153133871z |
category | utopian-io |
json_metadata | {"tags":["utopian-io"],"users":["steem-ua"],"app":"steemit/0.1"} |
created | 2018-08-18 15:31:33 |
last_update | 2018-08-18 15:31:33 |
depth | 2 |
children | 0 |
last_payout | 2018-08-25 15:31:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.063 HBD |
curator_payout_value | 0.020 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 90 |
author_reputation | 2,631,258,794,707 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,611,823 |
net_rshares | 63,275,459,967 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
scipio | 0 | 63,275,459,967 | 100% |
Congratulations @programarivm! You have completed the following achievement on Steemit and have been rewarded with new badge(s) : [](http://steemitboard.com/@programarivm) Award for the number of upvotes received <sub>_Click on the badge to view your Board of Honor._</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> To support your work, I also upvoted your post! > 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**!
author | steemitboard |
---|---|
permlink | steemitboard-notify-programarivm-20180818t210914000z |
category | utopian-io |
json_metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
created | 2018-08-18 21:09:12 |
last_update | 2018-08-18 21:09:12 |
depth | 1 |
children | 0 |
last_payout | 2018-08-25 21:09:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 736 |
author_reputation | 38,975,615,169,260 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,637,069 |
net_rshares | 0 |
@programarivm, thank you for supporting @steemitboard as a witness. [](http://steemitboard.com/@programarivm) Here is a small present to show our gratitude <sub>_Click on the badge to view your Board of Honor._</sub> Once again, thanks for your support! **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)
author | steemitboard |
---|---|
permlink | steemitboard-notify-programarivm-20180819t000129000z |
category | utopian-io |
json_metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
created | 2018-08-19 00:01:27 |
last_update | 2018-08-19 00:01:27 |
depth | 1 |
children | 0 |
last_payout | 2018-08-26 00:01:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 580 |
author_reputation | 38,975,615,169,260 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,647,326 |
net_rshares | 0 |
Hey @programarivm **Thanks for contributing on Utopian**. Weβre already looking forward to your next contribution! **Want to chat? Join us on Discord https://discord.gg/h52nFrV.** <a href='https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1'>Vote for Utopian Witness!</a>
author | utopian-io |
---|---|
permlink | re-php-command-that-converts-a-pgn-file-into-a-mysql-script-20180820t084532z |
category | utopian-io |
json_metadata | "{"app": "beem/0.19.42"}" |
created | 2018-08-20 08:45:33 |
last_update | 2018-08-20 08:45:33 |
depth | 1 |
children | 0 |
last_payout | 2018-08-27 08:45:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.017 HBD |
curator_payout_value | 0.004 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 305 |
author_reputation | 152,955,367,999,756 |
root_title | "PHP Command That Converts a PGN File into a MySQL Script" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 68,782,198 |
net_rshares | 16,389,741,722 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
espoem | 0 | 16,050,013,546 | 15% | ||
mops2e | 0 | 339,728,176 | 10% |