API 개발

[ehdgks0627]

CREATE TABLE `user`(
`id` VARCHAR(32) NOT NULL,
`pw` VARCHAR(32) NOT NULL,
`nick_name` VARCHAR(32) NOT NULL
)ENGINE=InnoDB;
CREATE TABLE `room`(
`id` INTEGER NOT NULL,
`max` INTEGER NOT NULL,
`now` INTEGER NOT NULL,
`started` BOOL NOT NULL
)ENGINE=InnoDB;
CREATE TABLE `character`(
`id` INTEGER NOT NULL,
`x` INTEGER NOT NULL,
`y` INTEGER NOT NULL,
`power` INTEGER NOT NULL,
`vehicle` INTEGER NOT NULL,
`boubled` BOOL NOT NULL,
`lived` BOOL NOT NULL
)ENGINE=InnoDB;
CREATE TABLE `item`(
`x` INTEGER NOT NULL,
`y` INTEGER NOT NULL,
`type` INTEGER NOT NULL,
`ate` BOOL NOT NULL
)ENGINE=InnoDB;
CREATE TABLE `bubble`(
`x` INTEGER NOT NULL,
`y` INTEGER NOT NULL,
`power` INTEGER NOT NULL,
`lived` BOOL NOT NULL
)ENGINE=InnoDB;
================================
usage : server/login.php
method : post
data : id=( );pw=( );
return : 1 or 0 (success, failure)
================================
usage : server/room.php
method : post
data : type=list
return : id-max-now-started;...
data : type=join;id=( );
return : 1 or 0
data : type=leave;id=( );
return : 1 or 0
data : type=create;
return : 1 or 0
data : type=destroy;id=( );
return : 1 or 0
================================
usage : server/character.php?room_id=( )
method : get
return : id=( );lived=( );/*lived if False, than pass*/x=( );y=( );power=( );vehicle=( );boubled=( );
================================
server/item.pho?room_id=( )
method : get
return : x=( );y=( );type=( );ate=( );
================================
server/bubble.php?room_id=( )
method : get
return : x=( );y=( );power=( );lived=( );
all return result ended with '@'

[ehdgks0627]

fin