private bool ICreateRelationship(uint parent, uint child, uint saver) { pnSqlInsertStatement insert = new pnSqlInsertStatement(); insert.AddValue("ParentIdx", parent); insert.AddValue("ChildIdx", child); insert.AddValue("SaverIdx", saver); insert.Table = "NodeRefs"; try { insert.Execute(fDb); return true; } catch (pnDbException e) { Error(e, String.Format("Failed to CreateRelationship {0}->{1}", parent, child)); return false; } }
private void ICreateNode(pnVaultNode node) { pnSqlInsertStatement insert = new pnSqlInsertStatement(); pnVaultNodeFields allFields = node.Fields; for (ulong bit = 1; bit != 0 && bit <= (ulong)allFields; bit <<= 1) { pnVaultNodeFields thisField = allFields & (pnVaultNodeFields)bit; if ((int)thisField == 0) continue; // Some basic sanity checks... switch (thisField) { case pnVaultNodeFields.CreateTime: // I don't care what we were told, it was created NOW insert.AddValue("CreateTime", DateTime.UtcNow); continue; case pnVaultNodeFields.ModifyTime: // I don't care what we were told, it was last modified NOW insert.AddValue("ModifyTime", DateTime.UtcNow); continue; case pnVaultNodeFields.NodeIdx: // Impossible. continue; } string colName = thisField.ToString(); insert.AddValue(colName, node[thisField]); } // We absolutely must have a correct Create/Modify time if (node[pnVaultNodeFields.CreateTime] == null) insert.AddValue("CreateTime", DateTime.UtcNow); if (node[pnVaultNodeFields.ModifyTime] == null) insert.AddValue("ModifyTime", DateTime.UtcNow); insert.Table = "Nodes"; insert.Execute(fDb); node.NodeID = pnDatabase.LastInsert(fDb); }
static void IAddAccount(string[] args) { if (args.Length < 2) { Console.WriteLine("Usage: addacct <username> <password> [permissions]"); Console.Write("Valid Permissions:"); string[] perms = Enum.GetNames(typeof(pnAcctPerms)); foreach (string perm in perms) Console.Write(" " + perm); Console.WriteLine(); return; } // Get our permissions int oPerm = (int)pnAcctPerms.Explorer; Guid oGuid = Guid.NewGuid(); if (args.Length > 2) { try { oPerm = (int)Enum.Parse(typeof(pnAcctPerms), args[2], true); } catch (ArgumentException) { Console.WriteLine(String.Format("Error: Undefined permission level '{0}'", args[2])); return; } } try { IDbConnection db = pnDatabase.Connect(); // Check to see if this account already exists pnSqlSelectStatement check = new pnSqlSelectStatement(); check.AddColumn("Guid"); check.AddWhere("Username", args[0]); check.Limit = 1; check.Table = "Accounts"; IDataReader r = check.Execute(db); if (r.Read()) { Console.WriteLine(String.Format("Account already exists! [GUID: {0}]", r[0])); r.Close(); return; } else r.Close(); // Alright, we can add us an account pnSqlInsertStatement create = new pnSqlInsertStatement(); create.AddValue("Username", args[0]); create.AddValue("Password", pnHelpers.GetString(pnHelpers.HashLogin(args[0], args[1]))); create.AddValue("Permissions", oPerm); create.AddValue("Guid", oGuid); create.Table = "Accounts"; create.Execute(db); } catch (pnDbException e) { Console.WriteLine("---Database Error---"); Console.WriteLine(e.ToString()); } }
private void ICreatePlayer() { pnCli2Vault_PlayerCreateRequest req = new pnCli2Vault_PlayerCreateRequest(); req.Read(fStream); Debug(String.Format("Creating a Player: [N: {0}] [S: {1}]", req.fPlayerName, req.fShape)); // Go ahead and init the response pnVault2Cli_PlayerCreateReply reply = new pnVault2Cli_PlayerCreateReply(); reply.fTransID = req.fTransID; reply.fResult = ENetError.kNetSuccess; reply.fPlayerName = req.fPlayerName; reply.fShape = req.fShape; // Search for a matching PlayerInfo // We check the entire vault because we want to include deleted players as well. pnVaultPlayerInfoNode pi = new pnVaultPlayerInfoNode(); pi.PlayerName = req.fPlayerName; try { if (IFindNode(pi.BaseNode).Length != 0) { reply.fResult = ENetError.kNetErrPlayerAlreadyExists; reply.Send(fStream); return; } } catch (pnDbException e) { Error(e, "Create Player: FindNode Failed"); reply.fResult = ENetError.kNetErrInternalError; reply.Send(fStream); return; } // Prepare the core node pnVaultPlayerNode player = new pnVaultPlayerNode(); player.AccountUuid = req.fAcctGuid; player.AvatarShape = req.fShape; player.CreatorUuid = req.fAcctGuid; player.PlayerName = req.fPlayerName; // Go ahead and insert this node. try { ICreateNode(player.BaseNode); reply.fPlayerID = player.NodeID; } catch (pnDbException e) { Error(e, "Create Player: Couldn't create the PlayerNode"); reply.fResult = ENetError.kNetErrInternalError; reply.Send(fStream); return; } // Player Info pnVaultPlayerInfoNode info = new pnVaultPlayerInfoNode(); info.CreatorID = player.NodeID; info.CreatorUuid = req.fAcctGuid; info.PlayerID = player.NodeID; info.PlayerName = req.fPlayerName; try { ICreateNode(info.BaseNode); } catch (pnDbException e) { Error(e, "Create Player: Couldn't create the PlayerInfoNode"); reply.fResult = ENetError.kNetErrInternalError; reply.Send(fStream); return; } // SimpleStdNodes uint? agejourn = ICreateStdNode(EStandardNode.kAgeJournalsFolder, player.NodeID, req.fAcctGuid); uint? agesicanvisit = ICreateStdNode(EStandardNode.kAgesICanVisitFolder, player.NodeID, req.fAcctGuid); uint? agesiown = ICreateStdNode(EStandardNode.kAgesIOwnFolder, player.NodeID, req.fAcctGuid); uint? avcloset = ICreateStdNode(EStandardNode.kAvatarClosetFolder, player.NodeID, req.fAcctGuid); uint? avoutfit = ICreateStdNode(EStandardNode.kAvatarOutfitFolder, player.NodeID, req.fAcctGuid); uint? buddies = ICreateStdNode(EStandardNode.kBuddyListFolder, player.NodeID, req.fAcctGuid); uint? chrons = ICreateStdNode(EStandardNode.kChronicleFolder, player.NodeID, req.fAcctGuid); uint? ignore = ICreateStdNode(EStandardNode.kIgnoreListFolder, player.NodeID, req.fAcctGuid); uint? inbox = ICreateStdNode(EStandardNode.kInboxFolder, player.NodeID, req.fAcctGuid); uint? recent = ICreateStdNode(EStandardNode.kPeopleIKnowAboutFolder, player.NodeID, req.fAcctGuid); // Create the tree ICreateRelationship(player.NodeID, info.NodeID, player.NodeID); if (agejourn.HasValue) ICreateRelationship(player.NodeID, agejourn.Value, player.NodeID); if (agesicanvisit.HasValue) ICreateRelationship(player.NodeID, agesicanvisit.Value, player.NodeID); if (agesiown.HasValue) ICreateRelationship(player.NodeID, agesiown.Value, player.NodeID); if (avcloset.HasValue) ICreateRelationship(player.NodeID, avcloset.Value, player.NodeID); if (avoutfit.HasValue) ICreateRelationship(player.NodeID, avoutfit.Value, player.NodeID); if (buddies.HasValue) ICreateRelationship(player.NodeID, buddies.Value, player.NodeID); if (chrons.HasValue) ICreateRelationship(player.NodeID, chrons.Value, player.NodeID); if (ignore.HasValue) ICreateRelationship(player.NodeID, ignore.Value, player.NodeID); if (recent.HasValue) ICreateRelationship(player.NodeID, recent.Value, player.NodeID); // Link to the System Node pnVaultSystemNode sys = new pnVaultSystemNode(); uint[] systems = IFindNode(sys.BaseNode); if (systems.Length == 0) Warn("Hmmm... Where's the system node?"); else { if (systems.Length > 1) Warn("Hmmm... We have multiple system nodes. How did that happen?"); ICreateRelationship(player.NodeID, systems[0], player.NodeID); } // Add to the players table... // First, we need to figure out what our account ID is pnSqlSelectStatement selAcctId = new pnSqlSelectStatement(); selAcctId.AddColumn("Idx"); selAcctId.AddWhere("Guid", req.fAcctGuid.ToString()); selAcctId.Limit = 1; selAcctId.Table = "Accounts"; try { IDataReader rsaid = selAcctId.Execute(fDb); if (rsaid.Read()) { // Now, actually insert uint acctIdx = Convert.ToUInt32(rsaid[0]); rsaid.Close(); pnSqlInsertStatement insPlayer = new pnSqlInsertStatement(); insPlayer.AddValue("AcctIdx", acctIdx); insPlayer.AddValue("PlayerIdx", player.NodeID); insPlayer.AddValue("Name", req.fPlayerName); insPlayer.AddValue("Model", req.fShape); insPlayer.Table = "Players"; insPlayer.Execute(fDb); } else { Warn(String.Format("HACK??? New player [#{0}] created for AcctGuid [{1}] not in our Accounts", player.NodeID, req.fAcctGuid)); rsaid.Close(); } } catch (pnDbException e) { Error(e, "Failed to add to Players table"); } catch (Exception e) { Error(e, "Hmmm..."); } // TODO: Add to AllPlayers Folder // Implement me when we can notify clients about node adds. // TODO: Initialize core ages // Neighborhood, Ae'gura // Send the response :) reply.Send(fStream); }