root | 2 Aug 2007 01:15
Favicon

[mb-commits] r9290 - mb_server/branches/SubscribeToEditor/htdocs/mod/search

Author: murdos
Date: 2007-08-01 23:15:38 +0000 (Wed, 01 Aug 2007)
New Revision: 9290

Modified:
   mb_server/branches/SubscribeToEditor/htdocs/mod/search/index.html
   mb_server/branches/SubscribeToEditor/htdocs/mod/search/setquery.inc
Log:
Added "My subscribed editors" option in Advanced Edit Search.

Modified: mb_server/branches/SubscribeToEditor/htdocs/mod/search/index.html
===================================================================
--- mb_server/branches/SubscribeToEditor/htdocs/mod/search/index.html	2007-07-31 21:55:37 UTC
(rev 9289)
+++ mb_server/branches/SubscribeToEditor/htdocs/mod/search/index.html	2007-08-01 23:15:38 UTC
(rev 9290)
 <at>  <at>  -227,8 +227,12  <at>  <at> 

 							<input type="radio" name="moderator_type" id="moderator_type6" value="6"
 								<% ($moderator_type eq "6") ? 'checked="checked"' : "" %>
-							/><label for="moderator_type6">Not me and not FreeDB</label>
+							/><label for="moderator_type6">Not me and not FreeDB</label><br />

+							<input type="radio" name="moderator_type" value="7" id="moderator_type7"
+								<% ($moderator_type eq "7") ? 'checked="checked"' : "" %>
+							/><label for="moderator_type7">My subscribed editors</label>
+
 						</div></td>
 				</tr>
 				<tr class="top">
(Continue reading)

root | 2 Aug 2007 01:26
Favicon

[mb-commits] r9291 - in mb_server/branches/TaggingAgain-BRANCH: admin admin/sql admin/sql/vertical admin/sql/vertical/rawdata cgi-bin cgi-bin/MusicBrainz/Server htdocs/show/tag

Author: robert
Date: 2007-08-01 23:26:09 +0000 (Wed, 01 Aug 2007)
New Revision: 9291

Added:
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/vertical/
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/vertical/rawdata/
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/vertical/rawdata/CreateIndexes.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/vertical/rawdata/CreateTables.sql
Modified:
   mb_server/branches/TaggingAgain-BRANCH/admin/InitDb.pl
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreateFKConstraints.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreateFunctions.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreateIndexes.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreatePrimaryKeys.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreateReplicationTriggers.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreateTables.sql
   mb_server/branches/TaggingAgain-BRANCH/admin/sql/CreateTriggers.sql
   mb_server/branches/TaggingAgain-BRANCH/cgi-bin/DBDefs.pm.default
   mb_server/branches/TaggingAgain-BRANCH/cgi-bin/MusicBrainz/Server/Tag.pm
   mb_server/branches/TaggingAgain-BRANCH/htdocs/show/tag/rawtags.html
Log:
The first steps towards vertical database partitioning is complete.
The InitDb.pl script will now properly create the needed
databases/tables on multiple database/hosts. The Tag.pm module
has been modified to make use of the seperate DB. Importing,
exporting data and merging entities is not complete yet.

Modified: mb_server/branches/TaggingAgain-BRANCH/admin/InitDb.pl
===================================================================
(Continue reading)

root | 2 Aug 2007 01:37
Favicon

[mb-commits] r9292 - in mb_server/branches/SubscribeToEditor/htdocs: show/user user

Author: murdos
Date: 2007-08-01 23:37:55 +0000 (Wed, 01 Aug 2007)
New Revision: 9292

Removed:
   mb_server/branches/SubscribeToEditor/htdocs/user/subscriptions.inc
Modified:
   mb_server/branches/SubscribeToEditor/htdocs/show/user/index.html
   mb_server/branches/SubscribeToEditor/htdocs/user/subscriptions.html
Log:
Merged subscriptions.html & subscriptions.inc. Code is now a little more complex but there was a lot of
duplicated code in these files.
Removed unused variables ( <at> colours) and renamed others (s/ <at> info/ <at> artists).

Modified: mb_server/branches/SubscribeToEditor/htdocs/show/user/index.html
===================================================================
--- mb_server/branches/SubscribeToEditor/htdocs/show/user/index.html	2007-08-01 23:26:09 UTC
(rev 9291)
+++ mb_server/branches/SubscribeToEditor/htdocs/show/user/index.html	2007-08-01 23:37:55 UTC
(rev 9292)
 <at>  <at>  -121,7 +121,7  <at>  <at> 

 % 	if ($subscriptions_public or $is_me)
 %	{
-					| <a href="/user/subscriptions.html?user=<% $userid %>">Subscriptions</a>
+					| <a href="/user/subscriptions.html?userid=<% $userid %>">Subscriptions</a>
 % 	}
 				</td>
 			</tr>
 <at>  <at>  -291,7 +291,7  <at>  <at> 
(Continue reading)

root | 3 Aug 2007 01:01
Favicon

[mb-commits] r9293 - mb_server/branches/TaggingAgain-BRANCH/admin

Author: robert
Date: 2007-08-02 23:01:33 +0000 (Thu, 02 Aug 2007)
New Revision: 9293

Modified:
   mb_server/branches/TaggingAgain-BRANCH/admin/ExportAllTables
   mb_server/branches/TaggingAgain-BRANCH/admin/MBImport.pl
Log:
adapted the import and export routines to be vertical database aware.

Modified: mb_server/branches/TaggingAgain-BRANCH/admin/ExportAllTables
===================================================================
--- mb_server/branches/TaggingAgain-BRANCH/admin/ExportAllTables	2007-08-01 23:37:55 UTC (rev 9292)
+++ mb_server/branches/TaggingAgain-BRANCH/admin/ExportAllTables	2007-08-02 23:01:33 UTC (rev 9293)
 <at>  <at>  -104,13 +104,37  <at>  <at> 
 print localtime() . " : Exporting to $dir\n";

 use MusicBrainz;
+use Sql;
+
+# Log in to the main DB
 my $mb = new MusicBrainz;
 $mb->Login(db => 'READWRITE');
-
-use Sql;
 my $sql = Sql->new($mb->{DBH});
 my $dbh = $mb->{DBH};

+# Log in to the raw DB, or duplicate handles to the main DB
+my $rawmb = new MusicBrainz;
(Continue reading)

root | 3 Aug 2007 12:05
Favicon

[mb-commits] r9294 - in mb_server/branches/trivia-and-stats: cgi-bin htdocs/trivia

Author: guelson
Date: 2007-08-03 10:05:52 +0000 (Fri, 03 Aug 2007)
New Revision: 9294

Modified:
   mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm
   mb_server/branches/trivia-and-stats/cgi-bin/Statistic.pm
   mb_server/branches/trivia-and-stats/htdocs/trivia/TestMBTrivia.pl
   mb_server/branches/trivia-and-stats/htdocs/trivia/releases_new.html
Log:
Updated static.pm and MBTrivia.pm to query Artists with the most releases, Recent releases, etc

Modified: mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm
===================================================================
--- mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm	2007-08-02 23:01:33 UTC (rev 9293)
+++ mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm	2007-08-03 10:05:52 UTC (rev 9294)
 <at>  <at>  -216,6 +216,45  <at>  <at> 
 	return $data;
 }

+sub getArtistWithMostReleases()
+{
+	my( $self, %params ) =  <at> _;
+	my $limit = $params{limit};
+	
+	my $sql = Sql->new($self->{DBH});
+	my $strSQL;
+	
+	$strSQL = "SELECT album.artist,  artist.name, count(album.artist) as numberofrelease from album
left join artist on album.artist = artist.id group by album.artist, artist.name order by
(Continue reading)

root | 6 Aug 2007 01:16
Favicon

[mb-commits] r9295 - in mb_server/trunk: . admin htdocs/products

Author: murdos
Date: 2007-08-05 23:16:48 +0000 (Sun, 05 Aug 2007)
New Revision: 9295

Removed:
   mb_server/trunk/htdocs/products/cdlookup/
   mb_server/trunk/htdocs/products/client/
   mb_server/trunk/htdocs/products/index.html
   mb_server/trunk/htdocs/products/trmgen/
Modified:
   mb_server/trunk/CHANGES
   mb_server/trunk/admin/vh_httpd.conf.default
Log:
Drop of some products pages (cdlookup, trmgen & client) already migrated to WikiDocs, plus some
indentation fixes. Closes #2928

Modified: mb_server/trunk/CHANGES
===================================================================
--- mb_server/trunk/CHANGES	2007-08-03 10:05:52 UTC (rev 9294)
+++ mb_server/trunk/CHANGES	2007-08-05 23:16:48 UTC (rev 9295)
 <at>  <at>  -34,6 +34,7  <at>  <at> 
     * Check for label ARs in the artist cleanup script. (#2814)
     * Error in handling track length edits. (#2887)
     * Display TransclusionEditor privilege on editor profile. (#3000)
+    * Drop of some products pages already migrated to WikiDocs. (#2928)

 Release 2007-04-01:

Modified: mb_server/trunk/admin/vh_httpd.conf.default
===================================================================
(Continue reading)

root | 7 Aug 2007 06:14
Favicon

[mb-commits] r9296 - in mb_server/branches/trivia-and-stats: admin/sql cgi-bin htdocs/trivia htdocs/trivia/tests

Author: guelson
Date: 2007-08-07 04:14:00 +0000 (Tue, 07 Aug 2007)
New Revision: 9296

Added:
   mb_server/branches/trivia-and-stats/admin/sql/StatnTrivia.sql
   mb_server/branches/trivia-and-stats/htdocs/trivia/TriviaStatEdit.html
   mb_server/branches/trivia-and-stats/htdocs/trivia/tests/
   mb_server/branches/trivia-and-stats/htdocs/trivia/tests/StatsPorting.pl
   mb_server/branches/trivia-and-stats/htdocs/trivia/tests/TestMBTrivia.pl
Removed:
   mb_server/branches/trivia-and-stats/htdocs/trivia/backups/
   mb_server/branches/trivia-and-stats/htdocs/trivia/cgi-bin/
Modified:
   mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm
   mb_server/branches/trivia-and-stats/cgi-bin/Statistic.pm
   mb_server/branches/trivia-and-stats/htdocs/trivia/Admin.html
   mb_server/branches/trivia-and-stats/htdocs/trivia/releases_new.html
Log:
Update the SQL script, Place StatnTrivia.sql to admin/sql; Make the table names and field more
meaningful; Update MBTrivia.pl to add modules that will fetch for Artists with the most releases, Recent
releases, List of most Subscribed Artist, etc; And also test thoso modules. Have added
TriviaStatEdit.html page as part of creating an admin area to automate the creation of stats and trivia.

Added: mb_server/branches/trivia-and-stats/admin/sql/StatnTrivia.sql

Modified: mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm
===================================================================
--- mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm	2007-08-05 23:16:48 UTC (rev 9295)
+++ mb_server/branches/trivia-and-stats/cgi-bin/MBTrivia.pm	2007-08-07 04:14:00 UTC (rev 9296)
(Continue reading)

root | 7 Aug 2007 06:18
Favicon

[mb-commits] r9297 - mb_server/branches/trivia-and-stats/htdocs/trivia

Author: guelson
Date: 2007-08-07 04:18:12 +0000 (Tue, 07 Aug 2007)
New Revision: 9297

Removed:
   mb_server/branches/trivia-and-stats/htdocs/trivia/StatsPorting.pl
   mb_server/branches/trivia-and-stats/htdocs/trivia/TestMBTrivia.pl
Log:
Remove .pl codes from the trivia folder. I temporarily move them to the tivia/tests folder, they will be
removed once they are no longer needed.

Deleted: mb_server/branches/trivia-and-stats/htdocs/trivia/StatsPorting.pl

Deleted: mb_server/branches/trivia-and-stats/htdocs/trivia/TestMBTrivia.pl
root | 7 Aug 2007 06:19
Favicon

[mb-commits] r9298 - mb_server/branches/trivia-and-stats/htdocs/trivia

Author: guelson
Date: 2007-08-07 04:19:05 +0000 (Tue, 07 Aug 2007)
New Revision: 9298

Removed:
   mb_server/branches/trivia-and-stats/htdocs/trivia/trivia.sql
Log:
Remove trivia.sql

Deleted: mb_server/branches/trivia-and-stats/htdocs/trivia/trivia.sql
root | 7 Aug 2007 06:24
Favicon

[mb-commits] r9299 - mb_server/branches/trivia-and-stats/htdocs/trivia

Author: guelson
Date: 2007-08-07 04:24:01 +0000 (Tue, 07 Aug 2007)
New Revision: 9299

Removed:
   mb_server/branches/trivia-and-stats/htdocs/trivia/test.html
Log:
Remove test.html

Deleted: mb_server/branches/trivia-and-stats/htdocs/trivia/test.html

Gmane