- Home /
using Regular Expressions with mySQL & Facebook?
Hi all.
Okay, so I have a small game which has several vars which I need to be able to track online. These variables are being tracked currently via a mySQL database. I'm connecting to the mySQL database using the WWW to save specific integers, such as score, etc, and then loading those same vars back.
As it's quite a few vars that I'm saving out, when I retrieve the data, it comes back as a single very long string, which I then split using Regex.Split and add it, in pieces, to a string array as well as a string list. I then use a lookup in the list to find the most up to date vars and load those in.
Up to this point, everything is working perfectly in engine, but for some reason when I throw a web build up on facebook apps to test, I run into a few problems. I've integrated games into Facebook apps before, so I don't think it's the FB API specifically that's causing problems. The following code is where the project is getting stuck:
IEnumerator GetScores()
{
if (FB.IsLoggedIn){
pluginGUI.guiText.text = "Loading Scores";
WWW hs_get = new WWW(highscoreURL);
yield return hs_get;
pluginGUI.guiText.text = "Reticulating Splines";
received_data = Regex.Split(hs_get.data,"next");
int scores = (received_data.Length-1)/2;
foreach (string x in received_data)
{
dataList.Add(x);
}
loadData();
}
}
The guiText is reading "reticulating splines", and since I'm using the gui to debug a lot of different areas in the script, I know for a fact this is where it's getting stuck. The thing is, when I comment out the code which follows the WWW call, which splits the incoming data using Regex, the script runs past this section and gets stuck at a further point due to the commented out regex area.
To me, this suggests that for some reason Facebook can't run either the regular expression namespace, or the system namespace (lists?), as that section uses both. This seems strange to me, and google refuses to bring up anything helpful, so I thought maybe somebody here could shed light on this.
I'll happily go into more detail about the project if need be.