Your provided link to the first file does not work for me.
--- In [email protected], "Ten Den, Chris" <[EMAIL PROTECTED]> wrote:
>
> There are two files on the website right now:
>
> http://www.ottawascrabbleclub.com/lists/
> <http://www.ottawascrabbleclub.com/lists/MOAWL-HTML-Src.zip>
> 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> <% 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> </td>
>
> <td><%=ucase(wordarray(1,i))%></td>
>
> <td> </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" <tendenc@>
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/quackle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
