Module1.cs

//
//        GOOMBAServer
//
//  Created by: FreeBSoD on GitHub
//  Aka GoombaProgrammer
//          ----
//
//
//     Thanks for viewing!
//

#define BUILDTYPE_WINDOWS

using System;
using System.IO;
using System.Text;
using System.Net;
using System.Threading.Tasks;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using System.Xml;
using System.Collections.Specialized;
using System.CodeDom.Compiler;
using System.CodeDom;
using System.Linq;

namespace GOOMBAServer
{

    public static class ExtensionClass
    {
        // Extension method to append the element
        public static T[] Append<T>(this T[] array, T item)
        {
            List<T> list = new List<T>(array);
            list.Add(item);

            return list.ToArray();
        }
    }
    class Module1
    {
        // Vars
        public static XmlDocument doc = new XmlDocument();

        public static string version = "0.2";
        public static HttpListener listener;
        public static string url = "";
        public static int requestCount = 0;
        public static string pageData =
            "<h1 style=\"font-family: verdana;\">GOOMBAServer Error</h1><h3 style=\"font-family: verdana;\">HTTP 500 Server Error <small>(GoombaErr #2)</small></h3><br /><br /><p style=\"font-family: verdana;\">GOOMBAServer v0.2</p>";

        public static List<string> vs1 = new List<string>();
        public static string[] StringSplit(string StringToSplit, string Delimitator)
        {
            return StringToSplit.Split(new[] { Delimitator }, StringSplitOptions.None);
        }
        public static void ErrorHandler(string error)
        {
            pageData = error;
#if BUILDTYPE_WINDOWS
            File.AppendAllText(Environment.CurrentDirectory + @"\www\goomba_errors", error);
#else
            File.AppendAllText(Environment.CurrentDirectory + @"/www/goomba_errors", error);
#endif

        }
        //open connection to database
        private static bool OpenConnection()
        {
            try
            {
                SQL.connection.Open();
                return true;
            }
            catch (MySqlException ex)
            {
                switch (ex.Number)
                {
                    case 0:
                        Console.WriteLine("SQL #0 Says: Cannot connect to server.");
                        ErrorHandler("SQL #0 Says: Cannot connect to server.");
                        break;

                    case 1045:
                        Console.WriteLine("SQL #1045 Says: Invalid user name and/or password.");
                        ErrorHandler("SQL #1045 Says: Incorrect username/password");
                        break;
                }
                Console.WriteLine(ex.Message);
                ErrorHandler(ex.Message);
                return false;
            }
        }

        //Close connection
        public static bool CloseConnection()
        {
            try
            {
                SQL.connection.Close();
                return true;
            }
            catch
            {
                return false;
            }
        }

        //Query
        public static string[] Query(string cmad, bool useSafeStr)
        {
   
                Console.WriteLine("Query Started.");
                string query = cmad;

                if (query.ToUpper().StartsWith("SELECT"))
                {
                    Console.WriteLine("ooOOH, a select query!");

                    //Open connection
                    if (OpenConnection() == true)
                    {
                        string[] forSelect = query.Split(' ');
                        Console.WriteLine("Open");
                        //create mysql command
                        MySqlCommand cmd = new MySqlCommand();
                        //Assign the query using CommandText
                        cmd.CommandText = query;
                        //Assign the connection using Connection
                        cmd.Connection = SQL.connection;

                        //Execute query
                        var ret = cmd.ExecuteReader();
                        string[] vs = { };
                        var i = -1;
                        vs1.Clear();
                        if (forSelect[1] != "*")
                        {
                            while (ret.Read())
                            {
                                i++;
                                vs1.Add(ret[forSelect[1]].ToString());
                            }
                        }
                        else
                        {
                            while (ret.Read())
                            {
                                for (var f = 0; f < ret.FieldCount; f++)
                                {
                                    i++;
                                    vs1.Add(ret[ret.GetName(f)].ToString());
                                }
                            }
                        }
                        ret.Close();
                        Console.WriteLine("Done");
                        SQL.connection.Close();
                        return vs;
                    }
                }
                else
                {
                    //Open connection
                    if (OpenConnection() == true)
                    {
                        Console.WriteLine("Open");
                        //create mysql command
                        MySqlCommand cmd = new MySqlCommand();
                        //Assign the query using CommandText
                        cmd.CommandText = query;
                        //Assign the connection using Connection
                        cmd.Connection = SQL.connection;

                        //Execute query
                        cmd.ExecuteNonQuery();
                        Console.WriteLine("Done");
                        string[] strtoret = { };
                        SQL.connection.Close();
                        return strtoret;

                    }
                    string[] strtorets = { };
                    return strtorets;
                }
                string[] strtoretss = { };
                return strtoretss;
            
          

        }
        public static void print(object text)
        {
            Console.WriteLine(text);
        }
        public static string Escape(string input)
        {
            using (var writer = new StringWriter())
            {
                using (var provider = CodeDomProvider.CreateProvider("CSharp"))
                {
                    provider.GenerateCodeFromExpression(new CodePrimitiveExpression(input), writer, null);
                    return writer.ToString();
                }
            }
        }
        public static bool IsNumeric(string value)
        {
            return value.All(char.IsNumber);
        }
        public static string SafeINSERT(string INTO, NameValueCollection VALUES)
        {
            print(VALUES.Count);
            string queryString = "INSERT INTO " + INTO + " (";
            for (int i = 0; i < VALUES.Count; i++)
            {
                if(i + 1 == VALUES.Count)
                {
                    queryString += VALUES.Keys[i];
                }
                else
                {
                    queryString += VALUES.Keys[i] + ",";
                }
            }
            queryString += ") VALUES (";

            for (int i = 0; i < VALUES.Count; i++)
            {
                queryString += "@a" + i + (i + 1 == VALUES.Count ? (")") : (","));
            }
            Console.WriteLine(queryString);
            //create mysql command
            MySqlCommand cmd = new MySqlCommand();

            //Assign the query using CommandText
            cmd.CommandText = queryString;
            for (int i = 0; i < VALUES.Count; i++)
            {
                if(!IsNumeric(VALUES[i]))
                {
                    print("oops");
                    cmd.Parameters.Add("@a" + Convert.ToString(i), MySqlDbType.String);
                    cmd.Parameters["@a" + Convert.ToString(i)].Value = VALUES[i];
                    continue;
                }
             
             
                cmd.Parameters.Add("@a" + Convert.ToString(i), MySqlDbType.Int32);
                cmd.Parameters["@a" + Convert.ToString(i)].Value = VALUES[i];
                print("INT");
            }

            //Assign the connection using Connection
            cmd.Connection = SQL.connection;

            //Execute query
            cmd.ExecuteNonQuery();
            Console.WriteLine("Done");
            queryString += ");";
            return queryString;
        }
        public static string[] QuerySAFE(string cmad, bool useSafeStr)
        {
            Console.WriteLine("Query Started.");
            string query = cmad;

            if (query.ToUpper().StartsWith("SELECT"))
            {
                Console.WriteLine("ooOOH, a select query!");

                //Open connection
                if (OpenConnection() == true)
                {
                    string[] forSelect = query.Split(' ');
                    Console.WriteLine("Open");
                    //create mysql command
                    MySqlCommand cmd = new MySqlCommand();
                    //Assign the query using CommandText
                    cmd.CommandText = query;
                    //Assign the connection using Connection
                    cmd.Connection = SQL.connection;

                    //Execute query
                    var ret = cmd.ExecuteReader();
                    string[] vs = { };
                    var i = -1;
                    vs1.Clear();
                    if (forSelect[1] != "*")
                    {
                        while (ret.Read())
                        {
                            i++;
                            vs1.Add(ret[forSelect[1]].ToString().Replace("<", "").Replace("&lt;", "").Replace("%3c", "").Replace(">", "").Replace("&gt;", "").Replace("%3e", ""));
                        }
                    }
                    else
                    {
                        while (ret.Read())
                        {
                            for (var f = 0; f < ret.FieldCount; f++)
                            {
                                i++;
                                vs1.Add(ret[ret.GetName(f)].ToString().Replace("<", "").Replace("&lt;", "").Replace("%3c", "").Replace(">", "").Replace("&gt;", "").Replace("%3e", ""));
                            }
                        }
                    }
                    ret.Close();
                    Console.WriteLine("Done");
                    SQL.connection.Close();
                    return vs;
                }
            }
            else if(query.ToUpper().StartsWith("INSERT"))
            {
                Console.WriteLine("Insert");
                //Open connection
                if (OpenConnection() == true)
                {
                    Console.WriteLine("Open");
                    NameValueCollection coolValueCollection0 = new NameValueCollection();
                    NameValueCollection coolValueCollection1 = new NameValueCollection();
                    var donextpart0 = false;
                    var donextpart = false;
                    var q1 = query.Split(' ');
                    Console.WriteLine("Done with " + q1.Length);
                    var i = -69;
                    for (i = 0; i < q1.Length; i++)
                    {
                        if (q1[i].StartsWith("(") && i < 4)
                        {
                            
            
                             
                            donextpart0 = true;
                            donextpart = false;
                            continue;
                        }
                        if (donextpart0) // DO IT JUST, DO IT!!!!
                        {
                  
                            i--;
                            coolValueCollection0.Add(q1[i].Replace("(", "").Replace(")", ""), null);
                            i++;
                            continue;
                        }
                     
                        
                    }
                    var y = i - 1;
                    donextpart = true;
                    for (y = i - 2;  y < q1.Length - 1; y++)
                    {
                        print("ran"); 
                        if(donextpart) // DO IT, JUST, DO IT!!!
                        {
                            print(q1.Length - i);
                            coolValueCollection1.Add(coolValueCollection0.Keys[q1.Length - i], q1[y + 1].Replace("(", "").Replace(")", "").Replace("'", "").Replace("`", "").Replace(";", ""));
                        }
                    }

                    print(coolValueCollection1.Count);
                    SafeINSERT(query.Split(' ')[2], coolValueCollection1);
                    string[] strtoret = { };
                    SQL.connection.Close();
                    return strtoret;

                }
                string[] strtorets = { };
                return strtorets;
            }
            string[] strtoretss = { };
            return strtoretss;
        }

        public static void runGoombaCode(HttpListenerRequest req, string file = "", bool isFunc = false)
        {
            List<List<string>> arrays = new List<List<string>>();
            List<string> arrays2 = new List<string>();
            List<string> strVars = new List<string>();
            List<string> strVars2 = new List<string>();
            List<string> functions = new List<string>();
            List<int> functionLengths = new List<int>();
            List<string> functionCodes = new List<string>();
            var isIndex = false;
            if (req.Url.AbsolutePath == "" || req.Url.AbsolutePath == "/")
            {
                isIndex = true;
            }
            var i = 0;
            var goombaMode = false;
            if (!isFunc)
            {
                pageData = "";
            }
            StreamReader streamReader = new StreamReader(file);
            var toread = streamReader.ReadToEnd();
            streamReader.Close();
            if (isIndex == true)
            {
#if BUILDTYPE_WINDOWS
                streamReader = new StreamReader(Environment.CurrentDirectory + @"\www\" + "index.goomba");
#else
                streamReader = new StreamReader(Environment.CurrentDirectory + @"/www/" + "index.goomba");
#endif

                toread = streamReader.ReadToEnd();
                streamReader.Close();
            }
            using (var reader = new StringReader(toread))
            {
                for (string line = reader.ReadLine(); line != null; line = reader.ReadLine())
                {
                    var commandline = line.Split(' ');
                    i += 1;
                    if (goombaMode)
                    {
                        if (line == "->STOPITGOOMBA<-")
                        {
                            if (goombaMode == true)
                            {
                                goombaMode = false;
                            }
                            else
                            {
                                pageData = "Goomba says: Unexpected STOPITGOOMBA at line " + i + ". Code will not continue.";
                                ErrorHandler("\nGoomba says: Unexpected STOPITGOOMBA at line " + i + ". Code will not continue.");
                                return;
                            }
                        }
                        else if (line == "->GOOMBATIME<-")
                        {
                            if (goombaMode == false)
                            {
                                goombaMode = true;
                            }
                            else
                            {
                                pageData = "Goomba says: Unexpected GOOMBATIME at line " + i + ". Code will not continue.";
                                ErrorHandler("Goomba says: Unexpected GOOMBATIME at line " + i + ". Code will not continue.");
                                return;
                            }
                        }
                        // First command ever added to GOOMBA!
                        else if (commandline[0] == "SPELLWORD:")
                        {
                            pageData += commandline[1] + " ";
                        }
                        // Comments but think??? what???
                        else if (line.StartsWith("THINK"))
                        {

                        }
                        // Array things.
                        else if (line.StartsWith("ARRAYADD:"))
                        {
                            if (commandline.Length != 2)
                            {
                                ErrorHandler("\nGoomba says: Expecting 1 argument after ARRAYADD at line " + i + ". Code will not continue.");
                                return;
                            }
                            arrays.Add(vs1);
                            arrays2.Add(commandline[1]);
                        }
                        else if (line.StartsWith("SPELLARRAY:"))
                        {
                            if (commandline.Length != 3)
                            {
                                ErrorHandler("\nGoomba says: Expecting 2 arguments after SPELLARRAY at line " + i + ". Code will not continue.");
                                return;
                            }
                            if (arrays2.Contains(commandline[1]) && IsNumeric(commandline[2]) && arrays[arrays2.IndexOf(commandline[1])].Count > int.Parse(commandline[2]))
                            {
                                pageData += arrays[arrays2.IndexOf(commandline[1])][int.Parse(commandline[2])];
                            }
                        }
                        // Function support
                        else if (line.StartsWith("FUNCTION:"))
                        {
                            if (!isFunc)
                            {
                                if (commandline.Length < 3)
                                {
                                    ErrorHandler("\nGoomba says: Expecting 2 or more arguments after FUNCTION at line " + i + ". Code will not continue.");
                                    pageData = "Goomba says: Expecting 2 or more arguments after FUNCTION at line " + i + ". Code will not continue.";
                                    return;
                                }
                                functions.Add(commandline[1]);
                                var txt = "";
                                for (int j = 2, loopTo = commandline.Length - 1; j <= loopTo; j++)
                                    txt += commandline[j] + " ";
                                var c = StringSplit(txt, ";;");
                                functionLengths.Add(c.Length);
                                functionCodes.AddRange(c);
                            }
                            else
                            {
                                ErrorHandler("\nGoomba says: A function in a function at function code " + i + ".");
                            }
                        }
                        // Function support Pt.2 (RUNFUN runs a function, while running with fun!)
                        else if (line.StartsWith("RUNFUN:"))
                        {
                            if (!isFunc)
                            {
                                if (commandline.Length != 2)
                                {
                                    ErrorHandler("\nGoomba says: Expecting 1 or more argument after RUNFUN at line " + i + ". Code will not continue.");
                                    pageData = "Goomba says: Expecting 1 argument after RUNFUN at line " + i + ". Code will not continue.";
                                    return;
                                }
                                if (functions.Contains(commandline[1]))
                                {
                                    int ok = functions.FindIndex(commandline[1].StartsWith);
                                    int len = functionLengths[ok];
                                    string codes = "";
                                    foreach (string s in functionCodes)
                                    {

                                        if (functionCodes.FindIndex(s.StartsWith) < len)
                                        {
                                            if (functionCodes.FindIndex(s.StartsWith) != len - 1) { codes += s + "\n"; } else { codes += s; }
                                        }
                                    }
                                    int rn = new Random().Next(1, 999999999);
#if BUILDTYPE_WINDOWS
                                    File.WriteAllText(Environment.CurrentDirectory + @"\www\" + rn + ".goomba", "->GOOMBATIME<-\n" + codes + "->STOPITGOOMBA<-");
                                    runGoombaCode(req, Environment.CurrentDirectory + @"\www\" + rn + ".goomba", true);
#else
                                    File.WriteAllText(Environment.CurrentDirectory + @"/www/" + rn + ".goomba", "->GOOMBATIME<-\n" + codes + "->STOPITGOOMBA<-");
                                    runGoombaCode(req, Environment.CurrentDirectory + @"/www/" + rn + ".goomba", true);
#endif

                                }
                                else
                                {
                                    ErrorHandler("Goomba says: RUNFUN could not find function " + commandline[1] + " at line " + i + ". Code will not continue.");
                                    pageData = "Goomba says: RUNFUN could not find function " + commandline[1] + " at line " + i + ". Code will not continue.";
                                    return;
                                }
                            }
                            else
                            {
                                ErrorHandler("\nGoomba says: A function in a function at function code " + i + ".");
                            }
                        }
                        else if (commandline[0] == "STR:")
                        {
                            var txt = "";
                            for (int j = 2, loopTo = commandline.Length - 1; j <= loopTo; j++)
                                txt += commandline[j] + " ";
                            strVars.Add(commandline[1]);
                            strVars2.Add(txt);
                        }
                        // Create variable
                        else if (commandline[0] == "CREATEHTMLVAR:")
                        {
                            if (commandline.Length != 3)
                            {
                                ErrorHandler("\nGoomba says: Expecting 2 arguments after CREATEHTMLVAR at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 2 arguments after CREATEHTMLVAR at line " + i + ". Code will not continue.";
                                return;
                            }
                            else
                            {
                                var rng = new Random().Next(65535);
                                if (rng == 69)
                                {
                                    rng = 69420;
                                }
#if BUILDTYPE_WINDOWS
                                string theName = Environment.CurrentDirectory + @"\www\" + "AksTEMPMethod" + rng + ".xml";
#else
                                string theName = Environment.CurrentDirectory + @"/www/" + "AksTEMPMethod" + rng + ".xml";
#endif

                                File.WriteAllText(theName, pageData);
                                try
                                {
                                    doc.Load(theName);
                                    XmlElement elem = doc.GetElementById(commandline[2]);
                                    if (elem != null)
                                    {
                                        strVars.Add(commandline[1]);
                                        strVars2.Add(elem.InnerText);
                                        File.Delete(theName);
                                    }
                                    else
                                    {
                                        ErrorHandler("\nGoomba says: Expecting valid ID at line " + i + ". Code will not continue.");
                                        pageData = "Goomba says: Expecting valid ID at line " + i + ". Code will not continue.";
                                        return;
                                    }
                                }
                                catch
                                {
                                    ErrorHandler("\nGoomba says: Unexpected error at line " + i + ". Code will not continue.");
                                    pageData = "Goomba says: Unexpected error at line " + i + ". Code will not continue.";
                                    File.Delete(theName);
                                    return;
                                }
                            }
                        }
                        // Get variable and print it
                        else if (commandline[0] == "SPELLVAR:")
                        {
                            if (strVars.Contains(commandline[1]))
                            {
                                int ok = strVars.FindIndex(commandline[1].StartsWith);
                                pageData += strVars2[ok];
                            }
                            else
                            {
                                ErrorHandler("\nGoomba says: Undefined variable " + commandline[1] + " at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Undefined variable " + commandline[1] + " at line " + i + ". Code will not continue.";
                                return;
                            }
                        }
                        // Write a file.
                        else if (commandline[0] == "WRITEPAPER:")
                        {
                            if (commandline.Length == 1)
                            {
                                ErrorHandler("\nGoomba says: Expecting 2 arguments after WRITEPAPER at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 2 arguments after WRITEPAPER at line " + i + ". Code will not continue.";
                                return;
                            }
                            if (commandline.Length == 2)
                            {
                                ErrorHandler("\nGoomba says: Expecting 2 arguments after WRITEPAPER at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 2 arguments after WRITEPAPER at line " + i + ". Code will not continue.";
                                return;
                            }
                            if (commandline.Length > 1000)
                            {
                                ErrorHandler("Goomba says: WRITEPAPER does not accept " + commandline.Length + " arguments at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: WRITEPAPER does not accept " + commandline.Length + " arguments at line " + i + ". Code will not continue.";
                                return;
                            }
                            var txt = "";
                            for (int j = 2, loopTo = commandline.Length - 1; j <= loopTo; j++)
                                txt += commandline[j] + " ";
#if BUILDTYPE_WINDOWS
                            File.WriteAllText((Environment.CurrentDirectory + @"\www\" + commandline[1]).Replace("..", ""), txt.Replace(@"\n", "\n"));
#else
                            File.WriteAllText((Environment.CurrentDirectory + @"/www/" + commandline[1]).Replace("..", ""), txt.Replace(@"\n", "\n"));
#endif

                        }
                        // SPELLSENTENCE is the same as SPELLWORD, but it allows spaces.
                        else if (commandline[0] == "SPELLSENTENCE:")
                        {
                            if (commandline.Length == 1)
                            {
                                ErrorHandler("\nGoomba says: Expecting 1 argument after SPELLSENTENCE at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 1 argument after SPELLSENTENCE at line " + i + ". Code will not continue.";
                                return;
                            }
                            if (commandline.Length > 1000)
                            {
                                ErrorHandler("\nGoomba says: SPELLSENTENCE does not accept " + commandline.Length + " arguments at line " + i + ".Code will not continue.");
                                pageData = "Goomba says: SPELLSENTENCE does not accept " + commandline.Length + " arguments at line " + i + ". Code will not continue.";
                                return;
                            }
                            var txt = "";
                            for (int j = 1, loopTo = commandline.Length - 1; j <= loopTo; j++)
                                txt += commandline[j] + " ";
                            pageData += txt.Replace(@"\n", "<br />");
                        }
                        else if (commandline[0] == "APPENDTOPAPER:")
                        {
                            if (commandline.Length == 1)
                            {
                                ErrorHandler("\nGoomba says: Expecting 2 arguments after APPENDTOPAPER at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 2 arguments after APPENDTOPAPER at line " + i + ". Code will not continue.";
                                return;
                            }
                            if (commandline.Length == 2)
                            {
                                ErrorHandler("\nGoomba says: Expecting 2 arguments after APPENDTOPAPER at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 2 arguments after APPENDTOPAPER at line " + i + ". Code will not continue.";
                                return;
                            }
                            if (commandline.Length > 1000)
                            {
                                ErrorHandler("\nGoomba says: APPENDTOPAPER does not accept " + commandline.Length + " arguments at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: APPENDTOPAPER does not accept " + commandline.Length + " arguments at line " + i + ". Code will not continue.";
                                return;
                            }
                            var txt = "";
                            for (int j = 2, loopTo = commandline.Length - 1; j <= loopTo; j++)
                                txt += commandline[j] + " ";
#if BUILDTYPE_WINDOWS
                            File.AppendAllText((Environment.CurrentDirectory + @"\www\" + commandline[1]).Replace("..", ""), txt.Replace(@"\n", "\n"));
#else
                            File.AppendAllText((Environment.CurrentDirectory + @"/www/" + commandline[1]).Replace("..", ""), txt.Replace(@"\n", "\n"));
#endif

                        }
                        else if (commandline[0] == "READPAPER:")
                        {
                            if (commandline.Length < 2)
                            {
                                ErrorHandler("\nGoomba says: Expecting 1 or more arguments after READPAPER, not " + commandline.Length + " at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 1 or more arguments after READPAPER, not " + commandline.Length + " at line " + i + ". Code will not continue.";
                                return;
                            }
                            if (commandline[1] == "USEADVANCEDTEXT:")
                            {
                                StreamReader streamReader2 = new StreamReader(Environment.CurrentDirectory + @"\www\" + commandline[2]);
                                var ok = streamReader2.ReadToEnd();
                                pageData += ok.Replace(@"\n", "<br />");
                                return;
                            }

                            try
                            {
#if BUILDTYPE_WINDOWS
                                StreamReader streamReader1 = new StreamReader(Environment.CurrentDirectory + @"\www\" + commandline[1]);
#else
                            StreamReader streamReader1 = new StreamReader(Environment.CurrentDirectory + @"/www/" + commandline[1]);
#endif
                                var txt = streamReader1.ReadToEnd();
                                pageData += txt;
                            }
                            catch
                            {
                                ErrorHandler("Goomba says: Undefined error");
                            }

                        }
                        else if (commandline[0] == "CONNECT:")
                        {
                            if (commandline.Length != 5)
                            {
                                ErrorHandler("\nGoomba says: Expecting 4 arguments after CONNECT, not " + commandline.Length + " at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting 4 arguments after CONNECT, not " + commandline.Length + " at line " + i + ". Code will not continue.";
                                return;
                            }
                            SQL.InitializeSQL(commandline[1], commandline[2], commandline[3], commandline[4]);
                        }
                        else if (commandline[0] == "REMOVE:")
                        {
                            if (commandline.Length != 2)
                            {
                                ErrorHandler("\nGoomba says: REMOVE accepts 1 argument at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: REMOVE accepts 1 argument at line " + i + ". Code will not continue.";
                            }
                            pageData = pageData.Replace(commandline[1], "");
                        }
                        // Query a MySQL query.
                        else if (commandline[0] == "QUERY:")
                        {
                            var useSafeStr = false;
                            if (commandline[1] == "USESAFESTR:")
                            {
                                useSafeStr = true;
                            }
                            if (useSafeStr)
                            {
                                if (line.Substring(19, 1) == "\"")
                                {
                                    if (line.LastIndexOf('"') > 18)
                                    {
                                        QuerySAFE(line.Substring(line.IndexOf('"') + 1, line.LastIndexOf('"') - 1 - line.IndexOf('"')), useSafeStr);
                                    }
                                    else
                                    {
                                        ErrorHandler("\nGoomba says: Expecting \" after QUERY, at line " + i + ". Code will not continue.");
                                        pageData = "Goomba says: Expecting \" after QUERY, at line " + i + ". Code will not continue.";
                                    }
                                }
                            } 
                            else if (!useSafeStr)
                            {
                                if (line.Substring(7, 1) == "\"")
                                {
                                    if (line.LastIndexOf('"') > 7)
                                    {
                                        Query(line.Substring(line.IndexOf('"') + 1, line.LastIndexOf('"') - 1 - line.IndexOf('"')), useSafeStr);
                                    }
                                    else
                                    {
                                        ErrorHandler("\nGoomba says: Expecting \" after QUERY, at line " + i + ". Code will not continue.");
                                        pageData = "Goomba says: Expecting \" after QUERY, at line " + i + ". Code will not continue.";
                                    }
                                }
                            }
                            else
                            {
                                ErrorHandler("\nGoomba says: Expecting \" right after QUERY, at line " + i + ". Code will not continue.");
                                pageData = "Goomba says: Expecting \" right after QUERY, at line " + i + ". Code will not continue.";
                            }
                        }
                        else
                        {
                            ErrorHandler("\nUndefined GOOMBA_THING " + commandline[0] + " at line " + i + ". Code will not continue.");
                            pageData = "Undefined GOOMBA_THING " + commandline[0] + " at line " + i + ". Code will not continue.";
                            return;
                        }
                    }
                    else
                    {
                        if (line == "->GOOMBATIME<-")
                        {
                            // Is GOOMBA running?
                            if (goombaMode == false)
                            {
                                // No!
                                goombaMode = true;
                            }
                            else
                            {
                                // yep...
                                pageData = "Goomba says: Unexpected GOOMBATIME at line " + i + ". Code will not continue.";

                                return;
                            }
                        }
                        else if (line == "->STOPITGOOMBA<-")
                        {
                            if (goombaMode == true)
                            {
                                goombaMode = false;
                            }
                            else
                            {
                                pageData = "Goomba says: Unexpected STOPITGOOMBA at line " + i + ". Code will not continue.";

                                return;
                            }
                        }
                        else
                        {
                            pageData += "\n" + line;
                            goombaMode = false;
                        }
                    }

                }
                goombaMode = false;
            }
        }
        public static async Task HandleIncomingConnections()
        {
            bool runServer = true;

            // While a user hasn't visited the `shutdown` url, keep on handling requests
            while (runServer)
            {
                // Will wait here until we hear from a connection
                HttpListenerContext ctx = await listener.GetContextAsync();

                // Peel out the requests and response objects
                HttpListenerRequest req = ctx.Request;
                HttpListenerResponse resp = ctx.Response;

                // Print out some info about the request
                Console.WriteLine("Request #: {0}", ++requestCount);
                Console.WriteLine(req.Url.ToString());
                Console.WriteLine(req.HttpMethod);
                Console.WriteLine(req.UserHostName);
                Console.WriteLine(req.UserAgent);
                Console.WriteLine();


                // Find all files to check
#if BUILDTYPE_WINDOWS
                List<string> allFiles = GetFilesFromPath(Environment.CurrentDirectory + @"\www");
#else
                List<string> allFiles = GetFilesFromPath(Environment.CurrentDirectory + @"/www");
#endif
                foreach (string file in allFiles)
                {
#if BUILDTYPE_WINDOWS
                    string thething = "/" + file.Replace(Environment.CurrentDirectory + @"\www\", "").Replace("\\", "/");
#else
                string thething = "/" + file.Replace(Environment.CurrentDirectory + @"/www/", "").Replace("\\", "/");
#endif

                    if (req.Url.AbsolutePath == thething || req.Url.AbsolutePath == "" || req.Url.AbsolutePath == "/")
                    {
                        if (req.Url.AbsolutePath.EndsWith(".goomba"))
                        {
                            runGoombaCode(req, file);
                        }
                        else
                        {
                            var isIndex = false;
                            if (req.Url.AbsolutePath == "" || req.Url.AbsolutePath == "/")
                            {
                                isIndex = true;
                            }
                            if (isIndex)
                            {
                                runGoombaCode(req, file);
                            }
                            else
                            {
                                StreamReader sr = new StreamReader(file);
                                pageData = sr.ReadToEnd();
                                sr.Close();
                            }
                        }
                        goto foundfile;
                    }
                    else
                    {
                        pageData = "<h1 style=\"font-family: verdana;\">GOOMBAServer Error</h1><h3 style=\"font-family: verdana;\">HTTP 404 Not Found <small>(GoombaErr #1)</small></h3><br /><br /><p style=\"font-family: verdana;\">GOOMBAServer v0.2</p>";
                    }
                }
            // File is found
            foundfile:
                // Write the response info
                byte[] data = Encoding.UTF8.GetBytes(pageData);
                resp.ContentType = "text/html";
                resp.ContentEncoding = Encoding.UTF8;
                resp.ContentLength64 = data.LongLength;

                // Write out to the response stream (asynchronously), then close it
                await resp.OutputStream.WriteAsync(data, 0, data.Length);
                resp.Close();
            }
        }

        static List<string> GetFilesFromPath(string path)
        {
            List<string> files = new List<string>();
            try
            {
                files.AddRange(Directory.GetFiles(path));

                foreach (string dir in Directory.GetDirectories(path))
                {
                    files.AddRange(GetFilesFromPath(dir));
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            return files;
        }

        public static void Main(string[] args)
        {
#if BUILDTYPE_WINDOWS
            if (!Directory.Exists(Environment.CurrentDirectory + "\\www\\"))
            {
                Directory.CreateDirectory(Environment.CurrentDirectory + "\\www\\");
            }
#else
            if (!Directory.Exists(Environment.CurrentDirectory + "/www"))
            {
                Directory.CreateDirectory(Environment.CurrentDirectory + "/www");
            }
#endif
#if BUILDTYPE_WINDOWS
            if (!File.Exists(Environment.CurrentDirectory + "\\GOOMBA.cfg"))
            {
                File.WriteAllText(Environment.CurrentDirectory + "\\GOOMBA.cfg", "http://localhost:8000/");
            }
#else
            if (!File.Exists(Environment.CurrentDirectory + "/GOOMBA.cfg"))
            {
                File.WriteAllText(Environment.CurrentDirectory + "/GOOMBA.cfg", "http://localhost:8000/");
            }
#endif
            url = File.ReadAllText(Environment.CurrentDirectory + "/GOOMBA.cfg");
#if BUILDTYPE_WINDOWS
            url = File.ReadAllText(Environment.CurrentDirectory + "\\GOOMBA.cfg");
#endif
            // Create a Http server and start listening for incoming connections
            listener = new HttpListener();
            listener.Prefixes.Add(url);
            listener.Start();
            Console.WriteLine("Listening for connections on {0}", url);
            Console.WriteLine("Make sure you have index.goomba in your /www folder.");
            // Handle requests
            Task listenTask = HandleIncomingConnections();
            listenTask.GetAwaiter().GetResult();
            // Close the listener
            listener.Close();
            Console.ReadKey();
        }
    }
}