public void Register(String username)
{
if (ssh == null)
{
try
{
ssh = new SshClient("137.112.128.188", "mpd", "mpd");
ssh.Connect();
}
catch (Exception ex)
{
System.Console.WriteLine("Problems connecting to music server, try registering later!");
DBAccessor.deleteEntry("Users", "Username = "******"cat port");
String portnum = cmd1.Execute();
int portnumnum = int.Parse(portnum);
int streamPort = portnumnum + 1;
SshCommand command = ssh.CreateCommand("echo 'user \"mpd\"\nport \"" + portnumnum + "\"\nrestore_paused \"no\"\npid_file \"/run/mpd/" + username + ".pid\"\ndb_file \"/var/lib/mpd/mpd.db\"\nstate_file \"/var/lib/mpd/userstates/" + username + ".mpdstate\"\nplaylist_directory \"/var/lib/mpd/playlists\"\nmusic_directory \"/var/lib/mpd/music\"\naudio_output {\n\ttype\t\"httpd\"\n\tbind_to_address\t\"137.112.128.188\"\n\tname\t\"My HTTP Stream\"\n\tencoder\t\"lame\"\n\tport\t\"" + streamPort + "\" \n\tbitrate\t\"320\"\n\tformat\t\"44100:16:1\"\n}' > userconfs/" + username + ".conf");
command.Execute();
//StreamPort = portnumnum;
portnumnum += 2;
SshCommand cmd2 = ssh.CreateCommand("echo \"" + portnumnum + "\" > port");
cmd2.Execute();
// ssh.Disconnect();
}
private void RemoveButton_Click(object sender, EventArgs e)
{
int firstRow = this.CurrentPlaylistDataGrid.Rows.GetFirstRow(DataGridViewElementStates.Selected);
if (firstRow == -1)
{
return;
}
DBAccessor.deleteEntry("Belongs_To", "MediaFilepath = '" + (string)CurrentPlaylistDataGrid.Rows[firstRow].Cells["MediaFilepath"].Value + "' and PlaylistAuthor = '" + this.Username + "'");
UpdateTables();
}
private void removeFavoriteToolStripMenuItem_Click(object sender, EventArgs e)
{
int index = GetSelectedRowNumber();
if (index == -1)
{
return;
}
DBAccessor.deleteEntry("Likes", "Username = '******' and MediaFilepath = '"
+ (string)this.dataGridView1.Rows[index].Cells["MediaFilepath"].Value + "'");
selectFavorites();
}
private void unFollowPlaylistToolStripMenuItem_Click(object sender, EventArgs e)
{
int index = GetSelectedRowNumber();
if (index == -1)
{
return;
}
DBAccessor.deleteEntry("Follows", "Username = '******' and PlaylistDateCreated = '"
+ (DateTime)this.dataGridView1.Rows[index].Cells["DateCreated"].Value + "' and PlaylistAuthor = '"
+ (string)this.dataGridView1.Rows[index].Cells["Author"].Value + "'");
selectFollowed();
}
/*
* public void UploadAlbum(String songFilepath)
* {
* SftpClient sftpClient = new SftpClient("137.112.128.188", "mpd", "mpd");
* SshClient ssh = new SshClient("137.112.128.188", "mpd", "mpd");
* ssh.Connect();
* SshCommand cmd = ssh.CreateCommand("mkdir -p " + "'/var/lib/mpd/music/" + this.ArtistTextbox.Text + "/" + this.albumTextBox.Text + "'");
* cmd.Execute();
* ssh.Disconnect();
* sftpClient.Connect();
* char[] split = { '\\', '\\' };
* String[] path = songFilepath.Split(split);
* System.IO.FileStream file = new System.IO.FileStream(songFilepath, System.IO.FileMode.Open);
* String uploadFilepath = this.ArtistTextbox.Text + "/" + this.albumTextBox.Text + "/" + path[path.Length - 1];
* //uploadFilepath.Replace(" ", "\\ ");
* DBAccessor.insertEntry("'" + uploadFilepath + "'|'" + this.NameTextBox.Text + "'|'" + this.ArtistTextbox.Text + "'|NULL|'" + GenreTextBox.Text + "'|'" + TypeBox.Text + "'|'" + 300 + "'|" + ReleaseDateBox.Text, "Media");
* try
* {
* sftpClient.UploadFile(file, "/var/lib/mpd/music/" + uploadFilepath);
* }
* catch (Renci.SshNet.Common.SshException sshe)
* {
* System.Console.WriteLine(sshe.Message);
* }
* file.Close();
* sftpClient.Disconnect();
* }*/
public void Unregister(String username)
{
DBAccessor.deleteEntry("Users", "Username = '******'");
}
