questions about saving to web
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
questions about saving to web
Hello, I have the php/mysql setup correct, but exactly how this works is a little unclear.
The upload example (from the "saving-and-loading-from-web guild) shows a URL creation like this.
myURL += "?webfilename=myFile.txt&webusername=user&webpassword=pass";
But it's not clear what the purpose of myFile.txt is. There's no mention of what this is used for. If the uploaded data gets store in mySql, why the .txt file?
Here's what I'm looking to do:
I already have a save script in place that I use to save my scene locally. These scripts save all the gameobject transforms, material choices, attacked script states etc.
I need to now make the exact same thing get saved on the server. Since I already have this save file created, can I make a single ES2.php call to save this on the server? How would I do this?
The upload example does this:
web.Upload(mesh)
And it's not clear to me what other types of parameters can be passed. Can I pass in file that was saved locally? An example would be helpful because I don't even see how to instantiate a "File" object in C# (I'm more experienced with Java), so am not even sure what I would pass into the upload method. Let me know, thanks!
The upload example (from the "saving-and-loading-from-web guild) shows a URL creation like this.
myURL += "?webfilename=myFile.txt&webusername=user&webpassword=pass";
But it's not clear what the purpose of myFile.txt is. There's no mention of what this is used for. If the uploaded data gets store in mySql, why the .txt file?
Here's what I'm looking to do:
I already have a save script in place that I use to save my scene locally. These scripts save all the gameobject transforms, material choices, attacked script states etc.
I need to now make the exact same thing get saved on the server. Since I already have this save file created, can I make a single ES2.php call to save this on the server? How would I do this?
The upload example does this:
web.Upload(mesh)
And it's not clear to me what other types of parameters can be passed. Can I pass in file that was saved locally? An example would be helpful because I don't even see how to instantiate a "File" object in C# (I'm more experienced with Java), so am not even sure what I would pass into the upload method. Let me know, thanks!
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
It occurred to me that I could read my entire save file into a string, and then use the web upload method to upload it. But I have a feeling this may be the wrong way to go about this.
I'm probably being dense here, but a little guidance would be helpful. thanks.
I'm probably being dense here, but a little guidance would be helpful. thanks.
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
I changed to using web.UploadFile which is what I needed. So you can ignore this question. thanks.
Re: questions about saving to web
Hi there,
Glad you found the UploadFile method. Let me clarify regarding the webFilename parameter.
The webFilename is used to group tags in the same way as a file would locally. For example, you can download all tags with a given webFilename by specifying the webFilename parameter when you download, and leaving the tag parameter out entirely.
All the best,
Joel
Glad you found the UploadFile method. Let me clarify regarding the webFilename parameter.
The webFilename is used to group tags in the same way as a file would locally. For example, you can download all tags with a given webFilename by specifying the webFilename parameter when you download, and leaving the tag parameter out entirely.
All the best,
Joel
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
thanks. I did figure that out eventually.
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
But I do have another question. I see the DownloadFilenames() which is sort of what I need. But is there any way to do a LIKE filter on the query so that only certain names are returned?
My users will save game to the server with a unique identifier in the name and I want to retrieve the list of all their saved games. I'm sure I can figure out how to do this, but it seems like the kind of thing a lot of people might want, so I thought I'd ask.
My users will save game to the server with a unique identifier in the name and I want to retrieve the list of all their saved games. I'm sure I can figure out how to do this, but it seems like the kind of thing a lot of people might want, so I thought I'd ask.
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
I tried adding "&filefilter=myfilefiler" to the URL, and was going to check for this within ES2.php, but am getting an unknown parameter error. Am I correct to assume that this check is within ES2.dll?
If so then perhaps doing what I want might be more difficult that I expected. You should allow us to pass custom URL parameters in the URL so that we can modify ES2.php to meet our custom needs. What do you think?
If so then perhaps doing what I want might be more difficult that I expected. You should allow us to pass custom URL parameters in the URL so that we can modify ES2.php to meet our custom needs. What do you think?
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
Looks like someone asked the exact same question:
http://www.moodkie.com/forum/viewtopic. ... .php#p1320
I'll try using your advice. thanks!
http://www.moodkie.com/forum/viewtopic. ... .php#p1320
I'll try using your advice. thanks!
-
- Posts: 21
- Joined: Wed Jun 08, 2016 9:31 pm
Re: questions about saving to web
For anyone interested, this works. You'll need to google for the CalculateMD5Hash method.
C# method
Change to ES2.php
C# method
Code: Select all
public IEnumerator LogFilenames() {
Debug.Log("in LogFileNames");
WWWForm form = new WWWForm();
// This data will be sent to our PHP script via POST.
form.AddField("username", "yourusername");
form.AddField("password", CalculateMD5Hash("yourpassword").ToLower());
form.AddField("mode", "getfilenames");
form.AddField("filefilter", "png");
WWW web = new WWW("http://www.yourhost.com/ES2.php", form);
yield return web;
// Handle any errors that might occur.
if (web.error != null) {
Debug.LogError("An error occurred when trying to upload the data.");
}
// Now get the output.
string output = web.text;
Debug.Log("output=" + output);
}
Code: Select all
else if($_POST["mode"] == "getfilenames")
{
$filefilter=$_POST["filefilter"];
$getFilenamesStatement = $mysqli -> prepare("SELECT $fileFieldName FROM $fileTableName where $fileFieldName LIKE '%".$filefilter."%' ");
$getFilenamesStatement -> execute();
$getFilenamesStatement -> bind_result($data);
while($getFilenamesStatement->fetch())
//echo $data."\n";
echo $data.",";
$getFilenamesStatement->close();
}
// Close our connection.
$mysqli -> close();
?>
Re: questions about saving to web
Hi there,
Glad you managed to find a solution to your problem!
All the best,
Joel
Glad you managed to find a solution to your problem!
All the best,
Joel