public static bool PassQuery(string message) { bool temp = false; temp = mysql.ExecuteQuery(message); return(temp); }
public static List <BaseCards> OptainNewCards(DbUser userFromDb, Random rand) { List <BaseCards> tempList = new List <BaseCards>(); BaseCards baseCard; ServerDbConnection dbConn = new ServerDbConnection(); int cost = 25; string query = "SELECT * From cardcollection;"; int temprand = rand.Next(100000); dbConn.CloseDbCon(); if (userFromDb.coins >= cost) { userFromDb.coins -= cost; //coins abziehen for (int i = 0; i < 4; i++) { //welche karte bekommt man int cardsNumber = dbConn.GetCardsCountFromDb(); int cardPlace = rand.Next(0, cardsNumber); baseCard = dbConn.GetOneRandCardFromDb(query, cardsNumber, cardPlace * temprand); Console.WriteLine(baseCard.getCardName()); //karte in datenbank einfügen dbConn.GetCardToUser(baseCard, userFromDb); tempList.Add(baseCard); } //update coin number query = MakeQueryForUpdateCoins(userFromDb); dbConn.ExecuteQuery(query); } else { //nicht genug coins return(null); } return(tempList); }
public static void StartServer() { List <DbUser> clientList = new List <DbUser>(); int port = 6543; Console.Write("Waiting for a connection... "); TcpListener listener = new TcpListener(IPAddress.Any, port); listener.Start(); try { while (true) //akzeptiert alle clients die kommen { if (listener.Pending()) { TcpClient client = listener.AcceptTcpClient(); string data = ""; new Thread(() => { try { Console.WriteLine("\nClient Connected!"); bool loggedIn = false; DbUser userFromDb = new DbUser(); NetworkStream stream = null; RequestContext request = new RequestContext(); ServerDbConnection mypostgresDataClass = new ServerDbConnection(); int attempt = 3; //muss ich noch hinzufügen bool registered = false; while (loggedIn == false) { stream = client.GetStream(); data = ServerClientConnection.ReceiveData(client, stream); //Console.WriteLine("SERVER RECEIVED:\n" + data); //data verwalten und in ein Objekt speichern request = MessageHandler.GetRequest(data); if (request.message.Trim('\n') == "Login") { //check if login if (attempt == 0) { string tempMessage = "AccessDenied"; SendData(stream, tempMessage); //string gabadge = ServerClientConnection.receiveData(client, stream); break; } else { userFromDb = DbFunctions.VerifyLogin(request, stream); } if ((userFromDb == null)) { attempt--; //client antworten und pw und user neu eingeben string message = "please try again\n"; SendData(stream, message); } else { loggedIn = true; } //wieder auf nachricht warten //er ist nun eingeloggt } else if (request.message.Trim('\n') == "Register") { if (attempt == 0) { string tempMessage = "AccessDenied"; ServerClientConnection.SendData(stream, tempMessage); Console.WriteLine("Du hast keine Versuche mehr"); Console.ReadLine(); break; } else { registered = DbFunctions.RegisterAtDb(request, stream); if (registered == true) { string tempMessage = "YouAreRegistred\n"; ServerClientConnection.SendData(stream, tempMessage); userFromDb = DbFunctions.VerifyLogin(request, stream); break; } } //setup for register if (registered == false) { attempt--; string tempMessage = "TryAgain\n"; ServerClientConnection.SendData(stream, tempMessage); } } } while (true) { string sieger = "noOne"; data = ""; //request.message = "empty"; data = ServerClientConnection.ReceiveData(client, stream); //Console.WriteLine("SERVER RECEIVED:\n" + data); //daten wieder einlesen request = MessageHandler.GetRequest(data); //also nach dem einloggen, kann ein client man hier her //brauch ich dann auch für später if (request.message.Trim('\n') == "StartTheBattle") { Console.WriteLine("Das battle beginnt in kürze"); //statt den rand card muss ich jz die von einem user abfragen //request.cardDeck = BattleMaker.GetRandCards(); request.stream = stream; userFromDb.stream = stream; string tempusername = request.GetUsernameFromDict(); string username = ""; string[] tempToken = tempusername.Split(new char[] { '_' }); //falls auch _ im usernamen drinnen sind for (int i = 0; i < tempToken.Length - 1; i++) { username += tempToken[i]; } userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(username); //wenn er zu weinige Karten besitzt if (userFromDb.cardCollection.Count < 3) { SendData(stream, "Du musst zuerst karten kaufen"); continue; } //standardmäßig mal das auswählen if (userFromDb.cardDeck.Count == 0) { userFromDb.cardDeck = BattleMaker.The4BestCards(userFromDb.cardCollection); } clientList.Add(userFromDb); //noch lock hinzufügen while (sieger.Trim('\n') == "noOne") { if (!clientList.Contains(userFromDb)) { break; } _mut.WaitOne(); sieger = BattleMaker.AddToBattleQueue(clientList); Thread.Sleep(1000); _mut.ReleaseMutex(); } if (request.GetUsernameFromDict().Contains(sieger)) { //elo points erhöhen Console.WriteLine(sieger); string query = DbFunctions.MakeQueryForUpdateElo(userFromDb, "+3"); mypostgresDataClass.ExecuteQuery(query); } else { //elo points minus Console.WriteLine(request.GetUsernameFromDict()); string query = DbFunctions.MakeQueryForUpdateElo(userFromDb, "-5"); mypostgresDataClass.ExecuteQuery(query); } //clientList.RemoveAt(0); clientList.Remove(userFromDb); } else if (request.message.Trim('\n') == "OptainNewCards") { List <BaseCards> tempList = new List <BaseCards>(); Console.WriteLine("4 cards cost 25 Coins" !); //string choiceCardShop = Console.ReadLine().Trim(' ', '\n'); var tempListForAnswerToClient = DbFunctions.OptainNewCards(userFromDb, Server.rand); if (tempListForAnswerToClient == null) { SendData(stream, "ZuWenigeCoins"); } else { string tempStringForAnswerToClient = GetAllNames(tempListForAnswerToClient); SendData(stream, tempStringForAnswerToClient); } } else if (request.message.Trim('\n') == "ShowDeck") { userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(userFromDb.userName); string answer; if (userFromDb.cardDeck.Count == 0) { if (userFromDb.cardCollection == null) { answer = "NoCards"; } else { userFromDb.cardDeck = BattleMaker.The4BestCards(userFromDb.cardCollection); answer = GetAllNames(userFromDb.cardDeck); } } else { answer = GetAllNames(userFromDb.cardDeck); } SendData(stream, answer); } else if (request.message.Trim('\n') == "ShowCardCollection") { userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(userFromDb.userName); string answer = String4ShowCardCollection(userFromDb.cardCollection); SendData(stream, answer); } else if (request.message.Trim('\n') == "Trade4Coins") { while (true) { //Console.WriteLine("ready to trade"); userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(userFromDb.userName); string answer = GetAllNames(userFromDb.cardCollection); SendData(stream, answer); data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); if (request.message.Trim('\n') == "END") { break; } else { //die karte an der stelle löschen, coins hochzählen, aus der datenbank löschen //1. aus der datenbank löschen, dann kann man nur die karten neu laden int cardToTrade = Int32.Parse(request.message); //Console.WriteLine(userFromDb.cardCollection[cardToTrade - 1].getCardName()); //eins abziehen, weil die client eingabe bei 1 startet //Console.WriteLine(" "); //noch die coins anzeigen if (cardToTrade > userFromDb.cardCollection.Count) { SendData(stream, "Wrong input\n do you want to continue?"); data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); if (request.message.Trim('\n') == "YES") { continue; } break; } int preis = CalcPreis(userFromDb.cardCollection[cardToTrade - 1]); //answer ob to sell if (preis == 0) { preis = 1; } string message = MakeMessageToSellCoinsAsk(preis); SendData(stream, message); data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); if (request.message.Trim('\n') == "YES") { message = DbFunctions.MakeMessageTradDelete(userFromDb, userFromDb.cardCollection[cardToTrade - 1]); bool successQueryExecute = DbFunctions.PassQuery(message); //coins hochzählen userFromDb.coins += preis; string makeQuery4UpdateCoins = DbFunctions.MakeQueryForUpdateCoins(userFromDb); successQueryExecute = DbFunctions.PassQuery(makeQuery4UpdateCoins); } else if (request.message.Trim('\n') == "NO") { break; } } } } else if (request.message.Trim('\n') == "TradeWithPlayer") { //ähnlich wie battle logic //eine karte auswählen, in queue hinzufügen //zweiten spieler hinzufügen, queue is nicht leer //zweiter spieler wählt eine karte aus, die er tauschen will //datenbank wird aktualisiert //beide werden aus der queue gelöscht string input = ""; //choose a card userFromDb.cardDeck = new List <BaseCards>(); BaseCards tempCard = null; //hier kann man die Karten auswählen, die im deck sein sollen userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(userFromDb.userName); string answer = String4ShowCardCollection(userFromDb.cardCollection); SendData(stream, answer); //schickt die possible karten int number; data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); input = request.message.Trim('\n'); if (input == "1") { //man will eine karte hinzufügen //die zahl kommt als antwort und die will ich hochladen while (true) { data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); number = Int32.Parse(request.message); if (number <= userFromDb.cardCollection.Count) { SendData(stream, "OK"); break; } else { SendData(stream, "False"); } } data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); string spellOrMonster = request.message.Trim('\n'); data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); string requiredDamage = request.message.Trim('\n'); mypostgresDataClass.AddCardsToTrade(userFromDb, number - 1, spellOrMonster, requiredDamage); } else if (input == "2") { //man will nur tauschen //zeigt alle karten in der liste zum tauschen an List <TradingObject> tradingListe = DbFunctions.ReturnCardsToTradeCards(); string answerToTrade = DbFunctions.ReturnCardsToTradeString(); SendData(stream, answerToTrade); data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); string cardWantToHave = request.message.Trim('\n'); //wähle aus eigenen karten aus userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(userFromDb.userName); answer = String4ShowCardCollection(userFromDb.cardCollection); SendData(stream, answer); //schickt die possible karten data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); string choiceToTrade = request.message.Trim('\n'); //prüfe, ob valide bool checker = DbFunctions.ChekTrade(cardWantToHave, tradingListe, choiceToTrade, userFromDb.cardCollection, answerToTrade); //lösche aus eigener kartenliste und tauschliste if (checker == true) { checker = mypostgresDataClass.UpdateCardsByTrade(userFromDb, userFromDb.cardCollection[Int32.Parse(choiceToTrade) - 1], tradingListe[Int32.Parse(cardWantToHave) - 1]); } if (checker == true) { SendData(stream, "correctChoice"); } else { SendData(stream, "wrongChoice"); } //füge in eigene liste ein mypostgresDataClass.PutInLists(userFromDb, userFromDb.cardCollection[Int32.Parse(choiceToTrade) - 1], tradingListe[Int32.Parse(cardWantToHave) - 1]); } } else if (request.message.Trim('\n') == "ChangeTheDeck") { userFromDb.cardDeck = new List <BaseCards>(); BaseCards tempCard = null; //hier kann man die Karten auswählen, die im deck sein sollen userFromDb.cardCollection = mypostgresDataClass.GetCardsFromDb(userFromDb.userName); string answer = String4ShowCardCollection(userFromDb.cardCollection); SendData(stream, answer); while (userFromDb.cardDeck.Count < 4) { data = ReceiveData(client, stream); request = MessageHandler.GetRequest(data); int number = Int32.Parse(request.message) - 1; //wwil bei 0 zu zählen beginnen if (userFromDb.cardCollection.Count < number) { SendData(stream, "NumberToHigh"); continue; } tempCard = userFromDb.cardCollection[number]; //tscheck if falide //eine karte darf z.b nur einmal drinnen sein if (CheckIfAddToDeckIsValide(tempCard, userFromDb)) { userFromDb.cardDeck.Add(tempCard); SendData(stream, GetAllNames(userFromDb.cardDeck)); } else { SendData(stream, "cardAlreadyUsed"); continue; } } } else if (request.message.Trim('\n') == "ShowScoreboard") { string playerScore = mypostgresDataClass.GetEloPoints(); SendData(stream, playerScore); } else { Console.WriteLine("Some unknown error!"); Console.ReadLine(); return; } } } catch (Exception e) { Console.WriteLine("Error {0}!", e); } }).Start(); } } } catch (System.ArgumentException e) { Console.WriteLine(e); } catch (Exception e) { Console.WriteLine("Error {0}!", e); } }