public static PartyData LoadCharacterParty(PMDCP.DatabaseConnector.MySql.MySql database, string charID)
{
PartyData partyData = new PartyData();
string query = "SELECT parties.PartyID " +
"FROM parties " +
"WHERE parties.CharID = \'" + charID + "\';";
List <DataColumnCollection> rows = database.RetrieveRows(query);
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
partyData.PartyID = rows[i]["PartyID"].ValueString;
}
}
else
{
return(null);
}
query = "SELECT parties.CharID " +
"FROM parties " +
"WHERE parties.PartyID = \'" + partyData.PartyID + "\';";
rows = database.RetrieveRows(query);
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
partyData.Members.Add(rows[i]["CharID"].ValueString);
}
}
return(partyData);
}
public static void LoadParty(PMDCP.DatabaseConnector.MySql.MySql database, Party partyData)
{
string query = "SELECT parties.CharID " +
"FROM parties " +
"WHERE parties.PartyID = \'" + partyData.PartyID + "\';";
List <DataColumnCollection> rows = database.RetrieveRows(query);
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
partyData.Members.Add(rows[i]["CharID"].ValueString);
}
}
}
public static List <string> LoadPartyIDList(PMDCP.DatabaseConnector.MySql.MySql database)
{
List <string> idList = new List <string>();
string query = "SELECT parties.PartyID " +
"FROM parties;";
List <DataColumnCollection> rows = database.RetrieveRows(query);
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
if (!idList.Contains(rows[i]["PartyID"].ValueString))
{
idList.Add(rows[i]["PartyID"].ValueString);
}
}
}
return(idList);
}
public static void LoadStory(int storyNum, PMDCP.DatabaseConnector.MySql.MySql database)
{
if (stories.Stories.ContainsKey(storyNum) == false)
{
stories.Stories.Add(storyNum, new Story(storyNum.ToString()));
}
Story story = new Story(storyNum.ToString());
string query = "SELECT revision, " +
"name, " +
"story_start, " +
"is_sandboxed, " +
"zone_id " +
"FROM story WHERE story.num = \'" + storyNum + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
story.Revision = row["revision"].ValueString.ToInt();
story.Name = row["name"].ValueString;
story.StoryStart = row["story_start"].ValueString.ToInt();
story.IsSandboxed = row["is_sandboxed"].ValueString.ToBool();
story.ZoneID = row["zone_id"].ValueString.ToInt();
}
query = "SELECT segment, " +
"action, " +
"checkpoint " +
"FROM story_segment WHERE story_segment.num = \'" + storyNum + "\'";
List <DataColumnCollection> columnCollections = database.RetrieveRows(query);
if (columnCollections == null)
{
columnCollections = new List <DataColumnCollection>();
}
foreach (DataColumnCollection columnCollection in columnCollections)
{
StorySegment segment = new StorySegment();
int segmentNum = columnCollection["segment"].ValueString.ToInt();
segment.Action = (Enums.StoryAction)columnCollection["action"].ValueString.ToInt();
bool isCheckpoint = columnCollection["checkpoint"].ValueString.ToBool();
string query2 = "SELECT param_key, " +
"param_val " +
"FROM story_param WHERE story_param.num = \'" + storyNum + "\' AND story_param.segment = \'" + segmentNum + "\'";
List <DataColumnCollection> columnCollections2 = database.RetrieveRows(query2);
if (columnCollections2 == null)
{
columnCollections2 = new List <DataColumnCollection>();
}
foreach (DataColumnCollection columnCollection2 in columnCollections2)
{
string paramKey = columnCollection2["param_key"].ValueString;
string paramVal = columnCollection2["param_val"].ValueString;
segment.Parameters.Add(paramKey, paramVal);
}
story.Segments.Add(segment);
if (isCheckpoint)
{
story.ExitAndContinue.Add(segmentNum);
}
}
stories.Stories[storyNum] = story;
}