using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace Blizzard
{
    class SoundTrackData
    {
        internal int Id;
        internal string Title;
        internal string SoundTrack;
        internal int CreatorId;
        internal string CreatorName;

        public static List<SoundTrackData> SoundTracks;

        public static void InitSoundTracks()
        {
            SoundTracks = new List<SoundTrackData>();
            DataRow S = BlizzardSystem.MySQL.ReadDataRow("SELECT * FROM soundtracks");

            foreach (DataRow Row in S.Table.Rows)
            {
                SoundTrackData So = new SoundTrackData();
                So.Id = (int)Row["id"];
                So.Title = (string)Row["title"];
                So.SoundTrack = (string)Row["soundtrack"];
                So.CreatorId = (int)Row["creator_id"];
                So.CreatorName = (string)Row["creator_name"];

                SoundTracks.Add(So);
            }

            BlizzardSystem.WriteLine("@Server >> " + SoundTracks.Count + " soundtracks loaded");
        }

        public static SoundTrackData GetSoundTrack(int id)
        {
            foreach (SoundTrackData s in SoundTracks)
            {
                if (s.Id == id)
                    return s;
                else
                    continue;
            }
            return null;
        }
    }
}