Scripts: WCA DB downloader, PDF Scramble Generator, WCA Elo-like rating system

Discussion in 'Software Area' started by Mr.Toad, Feb 17, 2012.

Welcome to the You are currently viewing our boards as a guest which gives you limited access to join discussions and access our other features. By joining our free community of over 30,000 people, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us and we'll help you get started. We look forward to seeing you on the forums!

Already a member? Login to stop seeing this message.
  1. Mr.Toad

    Mr.Toad Member

    Jul 26, 2009

    I've been uploading to GitHub some of my scripts lately. There are three that you might find interesting:

    Download WCA database export and load it to MySQL (Python)
    Go to, download the latest SQL export of the database and update your local MySQL database with it.

    PDF scramble generator for combination puzzles (PHP)
    Generate a number of scrambles / scramble pages for several puzzles and export them to PDF.

    Multiplayer Elo-like rating system (PHP)
    Experimental rating system for all the official events based on Elo which processes the WCA database and takes each round as a multiplayer game.
  2. FatBoyXPC

    FatBoyXPC Member

    Nov 28, 2009
    Not to be nit-picky, but if somebody has access to a mysql server, wouldn't they just run "mysql -u username -p [database if necessary] < dump.sql"? Seems like running a python script would be more overhead than necessary.

    Do you have a demo of the rating system? I don't really feel like importing the WCA db just to take a quick glance :p
    Last edited: Feb 17, 2012

Share This Page