Usage

No longer functional, please checkout https://devforum.roblox.com/t/bloxsql-reloaded-mysql-databases-for-your-roblox-game/1393960

POST

POST https://public.api.rampagestudios.org/v1/bloxsql/

We require your administrative login details same as the ROBLOX Script to protect your Database from unwanted users going into them.

Headers

Name	Type	Description
HTTPS	string	HTTPS Headers are required for any API connection on any of the RAMPAGE Interactive Websites.

Request Body

Name	Type	Description
SubAction	string	SELECT or QUERY
Query	string	MySQL Action, for example, "INSERT INTO... "
action	string	Leave as "execute"
Database	string	MySQL Database
Passowrd	string	MySQL Admin Password
Admin	string	MySQL Admin username
Host	string	MySQL Host (use localhost if rampage hosts)

200 Went OK completely fine and will return a JSON Encoded table like this.

{"code":"200","json":[["jake"],["nate"],["nate 2.0"]],"method":"SELECT"}

304 We couldn't find any data from the database.

{"code":304}

403 Forbidden access, you didn't supply valid administrative login

{"status":403}

404 We couldn't find the table.

{"status":404}

PHP Example

$url = 'https://public.api.rampagestudios.org/v1/bloxsql/';
$data = array("Host" => "rampage","Admin" => "rampage_admin","Password"=>"1234567890","Database" => "rampage_main");

$postdata = json_encode($data);

$ch = curl_init($url);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
$result = curl_exec($ch);
curl_close($ch);
print_r ($result);

Overview

This supports all MySQL Functions, from INSERT INTO, DELETE, and more!