RE: [quackle] Re: Quackle VS. Quackle Stats

Wed, 12 Apr 2006 11:47:26 -0700

There are two files on the website right now:

http://www.ottawascrabbleclub.com/lists/MOAWL-HTML-Src.zip

http://www.ottawascrabbleclub.com/lists/MOAWL_entire.zip

The first is the HTML output of the 4 groups of pages before converted to PDF.  Use at your own risk.  They eat up your computers resources very handily.

The second is the raw tab delimited data.

Played      OrderScore  Ordered         Front                      Word            Back                      
----------- ----------- --------------- -------------------------- --------------- --------------------------
797453      797453      IQ                                         QI              S
502366      502366      ER              AEIO                       RE              BCDEFGIMPSTVX
407830      502366      ER              FHPS                       ER              AEGNRS
403355      403355      EW              AEO                        WE              BDENT
393720      393720      IN              ABDFGHJKLPRSTWYZ           IN              KNS
390743      390743      AZ                                         ZA              GPSX
378778      378778      ET              BFGHJLMNPRSTVWY            ET              AH
If you load this into a database, you can then run the following .asp script against it to produce the lists.  You can then alter the style and the columns/rows and column width.  The first page is probably the least useful for anyway playing scrabble for a little while and just happens to take up the most width.  So if you drop the first page, you can increase the size a bit without sacrificing the number of columns.  You could easily modify the script to handle parameters for a page-page request. 
 
Other option is to convert the script to go against the file  (it is already ordered properly) and build the same list from that.  If there is a PHP or PERL expert that can covert this script (using a file / no db) to do that I could post it on my website.  I've never bother to learn php or perl.



buildMOAWL.asp

 <STYLE TYPE="text/css">
        TD
        {
                FONT-SIZE:7px;
                FONT-FAMILY:COURIER NEW;
                LINE-HEIGHT:7px;
        }
        .break { page-break-before: always; }
</style>
<%
        server.ScriptTimeout=10000000
        dim word
       
        set conn = server.CreateObject("adodb.connection")
        conn.Open("provider=SQLOLEDB;Data Source=servername;Initial Catalog=words; User Id=user; Password=password")
        set rs = conn.Execute("select Front,Word,Ordered,Back from orderedwords order by orderscore desc,ordered,score desc,word")
        wordarray = rs.getRows()
        max = ubound(wordarray,2)-1
        on error resume next
       
        columns = 4                        'This will change depending on font size
        rows = 137                         'This will change depending on font size
        previous = ""
        columnwidth = 178          'This will change depending on font size
        i=(10960) * 9              'Starting Word       -->     (columns*rows*pages) * whichgroupofpages
        while i <= 124901          'Finishing Word      -->     (columns*rows*pages) * (whichgroupofpages+1)
                %>
                        <table border=0 cellspacing=0>
                                <tr>
                <%
                for j = 1 to columns
                        %>
                                        <td>
                                                <table width="<%=columnwidth%>" cellpadding="0" cellspacing="0" style="border:1px #888888 solid">
                        <%
                        for k = 1 to rows
                                %>
                                                        <tr>
                                                                <td>&nbsp;<% if ucase(wordarray(2,i)) <> previous then
                                                                                previous = ucase(wordarray(2,i))
                                                                                Response.Write(ucase(wordarray(2,i)))
                                                                                end if %></td>
                                                                <td align="right"><%=ucase(wordarray(0,i))%></td>
                                                                <td>&nbsp;</td>
                                                                <td><%=ucase(wordarray(1,i))%></td>
                                                                <td>&nbsp;</td>
                                                                <td><%=ucase(wordarray(3,i))%></td>
                                                        </tr>
                                <%
                                i=i+1
                        next
                        %>
                                                </table>
                                        </td>
                        <%
                        if i >= max then
                                j = 5000        'Exit the column
                        end if
                next
                %>
                                </tr>
                        </table>
                        <p class="break"></p>
                <%
                ' Page Break
        wend
%>

________________________________

From: [email protected] [mailto:[email protected]] On Behalf Of Jason E Katz-Brown
Sent: April 12, 2006 11:40 AM
To: [email protected]
Subject: Re: [quackle] Re: Quackle VS. Quackle Stats


On Wed, 2006-04-12 at 15:35 +0000, Steve Hartsman wrote:
> Chris,
>
> Awesome work! While the list is similar to John's playability lists,
> I like that you've included all the hooks. I think it's a great
> study tool.

I'll second that the documents you've got online, Chris, are bloody
awesome. Thank you for the time and effort you put in!

How did you format them with hooks and anagrams etcetera? Letterbox can
output to that kind of thing but just in plain text.

I might integrate the rest of letterbox into quackle (the word search
dialog of quackle is copied [almost] straight from letterbox) some point
soon so it'd be cool to put that kind of functionality in :)

thanks!
Jason

> --- In [email protected], "Ten Den, Chris" <[EMAIL PROTECTED]> wrote:
> >
> > Good day all,
> > 
> > I finished compiling the word list.  I broke it down into 4 files,
> or
> > else it is too big.  Right now it is 228 pages long.*
> [snip]
> > You can find the volumes on http://www.ottawascrabbleclub.com/
> then go
> > to the study room and look under lists.
> > 
> > Make sure you double side your printer.  Save a few trees.[snip]
YAHOO! GROUPS LINKS



Reply via email to