https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?action=history&feed=atom&title=Mpetredi_Week_6
Mpetredi Week 6 - Revision history
2026-06-02T22:09:55Z
Revision history for this page on the wiki
MediaWiki 1.20.3
https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?title=Mpetredi_Week_6&diff=2549&oldid=prev
Mpetredi: Added remaining requirements for assignment
2013-10-03T21:07:33Z
<p>Added remaining requirements for assignment</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:07, 3 October 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>==Movies from Text File to Tables==</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">==[[user:mpetredi|'''Mitchell Petredis''']]==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">===Assignment Reference===</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">[[Week 6]]</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">=</ins>==Movies from Text File to Tables<ins class="diffchange diffchange-inline">=</ins>==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#select * from movie where year < 1915</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#select * from movie where year < 1915</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#*4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#*4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 91:</td>
<td colspan="2" class="diff-lineno">Line 97:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#**"The Legend of Zelda: Ganon's Evil Tower";5;"Doug"</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#**"The Legend of Zelda: Ganon's Evil Tower";5;"Doug"</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#**"Zatoichi's Conspiracy";5;"Doug"</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#**"Zatoichi's Conspiracy";5;"Doug"</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[Category: Individual Homework]]</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[Category: Journal Entry]]</ins></div></td></tr>
</table>
Mpetredi
https://xmlpipedb.lmucs.io/biodb/fall2013/index.php?title=Mpetredi_Week_6&diff=2548&oldid=prev
Mpetredi: added last question answer
2013-10-03T21:01:41Z
<p>added last question answer</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:01, 3 October 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 82:</td>
<td colspan="2" class="diff-lineno">Line 82:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#select avg(rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star'</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#select avg(rating) from movie inner join rating on (movie.id = rating.movie) where title ~ '^Star'</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#*2.6</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>#*2.6</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#What are the best movies according to each member?</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#*select title, rating, name from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member) where rating = 5 order by title</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"Bruce Lee: A Warrior's Journey";5;"Doug"</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"Donnie Darko: Director's Cut";5;"Doug"</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"Star Trek: Deep Space Nine: Season 5";5;"Natalie"</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"Star Trek: The Next Generation: Season 5";5;"Natalie"</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"Star Wars: Episode VI: Return of the Jedi";5;"Boomer"</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"The Legend of Zelda: Ganon's Evil Tower";5;"Doug"</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">#**"Zatoichi's Conspiracy";5;"Doug"</ins></div></td></tr>
</table>
Mpetredi
Unexpected non-MediaWiki exception encountered, of type "Error"
Error: Call to undefined function each() in /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php:374
Stack trace:
#0 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(480): _DiffEngine->_diag()
#1 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(291): _DiffEngine->_compareseq()
#2 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(175): _DiffEngine->diff_local()
#3 /apps/xmlpipedb/biodb/fall2013/includes/diff/DairikiDiff.php(653): _DiffEngine->diff()
#4 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(763): Diff->__construct()
#5 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(655): DifferenceEngine->generateDiffBody()
#6 /apps/xmlpipedb/biodb/fall2013/includes/diff/DifferenceEngine.php(593): DifferenceEngine->getDiffBody()
#7 /apps/xmlpipedb/biodb/fall2013/includes/FeedUtils.php(147): DifferenceEngine->getDiff()
#8 /apps/xmlpipedb/biodb/fall2013/includes/actions/HistoryAction.php(303): FeedUtils::formatDiffRow()
#9 /apps/xmlpipedb/biodb/fall2013/includes/actions/HistoryAction.php(268): HistoryAction->feedItem()
#10 /apps/xmlpipedb/biodb/fall2013/includes/actions/HistoryAction.php(121): HistoryAction->feed()
#11 /apps/xmlpipedb/biodb/fall2013/includes/Action.php(541): HistoryAction->onView()
#12 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(427): FormlessAction->show()
#13 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(304): MediaWiki->performAction()
#14 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(536): MediaWiki->performRequest()
#15 /apps/xmlpipedb/biodb/fall2013/includes/Wiki.php(446): MediaWiki->main()
#16 /apps/xmlpipedb/biodb/fall2013/index.php(59): MediaWiki->run()
#17 {main}