generic image
Processing...
  • Games
  • Catalog
  • Develop
  • Robux
  • Search in Players
  • Search in Games
  • Search in Catalog
  • Search in Groups
  • Search in Library
  • Log In
  • Sign Up
  • Games
  • Catalog
  • Develop
  • Robux
   
ROBLOX Forum » Game Creation and Development » Scripters
Home Search
 

Re: ROBLOX SQL

Previous Thread :: Next Thread 
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 06:09 AM
Can I use a SQL for my data store if so how?


Report Abuse
10MilesWide is not online. 10MilesWide
Joined: 06 Aug 2014
Total Posts: 2220
23 Oct 2016 06:12 AM
>Implying you know SQL

https://www.roblox.com/library/322704057/Hillary-Clinton
Report Abuse
TimerHotel is not online. TimerHotel
Joined: 05 Oct 2012
Total Posts: 191
23 Oct 2016 06:13 AM
Idk about SQL bu###ou can store data like this:


script in Workspace named onPlayerAdded:


local DataStore = game:G################################################################game.Players.PlayerAdded:connect(function(player)

local stringExample = Instance.new("StringValue", player)
stringExample.Name = "StringExample"

local key = "player-"..player.userId

local savedValues = DataStore:GetAsync(key)

if savedValues then
stringExample.Value = savedValues[1]
else
local ValuesToSave = {stringExample.Value}
DataStore:SetAsync(key, ValuesToSave)
end


end)



script in Workspace named onPlayerLeaving:


local DataStore = game####################################################################################################################### local stringExample = Instance.new("StringValue", player)
stringExample.Name = "StringExample"

local key = "player-"..player.userId

local savedValues = DataStore:GetAsync(key)

if savedValues then
stringExample.Value = savedValues[1]
else
local ValuesToSave = {stringExample.Value}
DataStore:SetAsync(key, ValuesToSave)
end


end)


Report Abuse
TimerHotel is not online. TimerHotel
Joined: 05 Oct 2012
Total Posts: 191
23 Oct 2016 06:16 AM
Here's a link to the scripts, put them in Workspace

https://www.roblox.com/library/528685431/Datastore-scripts


Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 06:24 AM
Time thank you but I have a datastore script just not sure how to connect it with the SQL.

I use SQL in game servers such as Altis Life (Arma 3)


Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 06:30 AM
Paying up to 15K


Report Abuse
TimerHotel is not online. TimerHotel
Joined: 05 Oct 2012
Total Posts: 191
23 Oct 2016 06:31 AM
I'm pretty sure you can't use SQL for Roblox, ask someone who works for Roblox


Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 06:34 AM
The SQL I am talking about is edit values of the players save such as Shirts/Pants

^ As a start off I have a data store that dose this just wanna edit them


I'm trying to say I wanna edit a players save. And a SQL is what I can come up with..


Report Abuse
TimerHotel is not online. TimerHotel
Joined: 05 Oct 2012
Total Posts: 191
23 Oct 2016 06:39 AM
The scripts I showed you does that, it stores data when you leave, then it loads them when the player joins.

example:
value: 0
*first join*
value is set to 1
value: 1
->*player leaves*
| value saves
| *player joins again*
| value loads with 1
| value: 1
-loop


Report Abuse
TimerHotel is not online. TimerHotel
Joined: 05 Oct 2012
Total Posts: 191
23 Oct 2016 06:40 AM
then with those values you can make a script that changes what the player looks like. It can be any kind of value btw, not only integar. so if for example a value is true you can change the color of a player's limb


Report Abuse
myactivetestplace is not online. myactivetestplace
Joined: 11 Jul 2015
Total Posts: 3733
23 Oct 2016 06:41 AM
You could use an http service.
Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 06:48 AM
SQL uses IP so can that be used as a HTTP?

And I have all that timer lol just need a place where I can edit thos values


Report Abuse
wchar_t is not online. wchar_t
Joined: 11 Oct 2016
Total Posts: 65
23 Oct 2016 07:44 AM
LOL
If you're wanting to actually work with sql you'll need to know php and have a fast running web server (paid hosting).


Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 08:19 AM
I don't know php and yes i do host i own a Dbox.


Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 08:27 AM
What is a alternative to see and edit tho's values then?



Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 08:52 AM
^ Bump



Report Abuse
Mr_King8 is not online. Mr_King8
Joined: 31 Jul 2010
Total Posts: 1633
23 Oct 2016 09:23 AM
^ Bump



Report Abuse
NKM9 is online. NKM9
Joined: 14 Jun 2010
Total Posts: 624
23 Oct 2016 10:37 AM
You can use SQL and PHPMyAdmin since I'm doing so for the RPG I'm making.
Find more information about it here but it's advised to know how to code in php.
https://www.youtube.com/watch?v=25T8GEF4fvg


Report Abuse
Previous Thread :: Next Thread 
Page 1 of 1
 
 
ROBLOX Forum » Game Creation and Development » Scripters
   
 
   
  • About Us
  • Jobs
  • Blog
  • Parents
  • Help
  • Terms
  • Privacy

©2017 Roblox Corporation. Roblox, the Roblox logo, Robux, Bloxy, and Powering Imagination are among our registered and unregistered trademarks in the U.S. and other countries.



Progress
Starting Roblox...
Connecting to Players...
R R

Roblox is now loading. Get ready to play!

R R

You're moments away from getting into the game!

Click here for help

Check Remember my choice and click Launch Application in the dialog box above to join games faster in the future!

Gameplay sponsored by:
Loading 0% - Starting game...
Get more with Builders Club! Join Builders Club
Choose Your Avatar
I have an account
generic image