- Joined
- Apr 8, 2008
- Messages
- 1,125
- Reaction score
- 330
* Requires OCDB set up.
I RECOMMEND
SVN link:
HSLess Client
SQL
I RECOMMEND
You must be registered to see links
.SVN link:
You must be registered to see links
HSLess Client
THIS IS NOT A LOCALHOST.
You must be registered to see links
SQL
Code:
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50139
Source Host : localhost:3306
Source Database : wonderking
Target Server Type : MYSQL
Target Server Version : 50139
File Encoding : 65001
Date: 2010-03-01 22:30:05
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`ID` int(11) NOT NULL DEFAULT '0',
`Username` char(32) DEFAULT NULL,
`Password` char(20) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of accounts
-- ----------------------------
INSERT INTO `accounts` VALUES ('1', 'admin', '123123');
-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
`PlayerID` smallint(2) NOT NULL DEFAULT '0',
`ItemID` smallint(2) DEFAULT NULL,
`Count` smallint(2) DEFAULT NULL,
`Position` tinyint(1) unsigned DEFAULT NULL,
`HasAttributes` tinyint(1) unsigned DEFAULT NULL,
`IsEquipment` tinyint(1) unsigned DEFAULT NULL,
`Level` tinyint(1) unsigned DEFAULT NULL,
`RareType` tinyint(1) unsigned DEFAULT NULL,
`AddOption` tinyint(1) unsigned DEFAULT NULL,
`AddOption2` tinyint(1) unsigned DEFAULT NULL,
`AddOption3` tinyint(1) unsigned DEFAULT NULL,
`Option` smallint(2) DEFAULT NULL,
`Option2` smallint(2) DEFAULT NULL,
`Option3` smallint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('1', '393', '55', '0', '0', '0', null, null, null, null, null, null, null, null);
INSERT INTO `items` VALUES ('1', '3222', '1', '0', '1', '0', '11', '3', '1', '6', '4', '152', '24', '36');
-- ----------------------------
-- Table structure for `players`
-- ----------------------------
DROP TABLE IF EXISTS `players`;
CREATE TABLE `players` (
`ID` smallint(6) NOT NULL,
`UserID` int(11) NOT NULL,
`Name` char(20) NOT NULL,
`Level` tinyint(4) unsigned NOT NULL DEFAULT '0',
`Money` bigint(20) DEFAULT NULL,
`HP` smallint(6) NOT NULL DEFAULT '0',
`MP` smallint(6) NOT NULL DEFAULT '0',
`MaxHP` smallint(6) NOT NULL DEFAULT '0',
`MaxMP` smallint(6) NOT NULL DEFAULT '0',
`Map` smallint(6) NOT NULL DEFAULT '0',
`Str` smallint(6) NOT NULL DEFAULT '0',
`Dex` smallint(6) NOT NULL DEFAULT '0',
`Int` smallint(6) NOT NULL DEFAULT '0',
`Luck` smallint(6) NOT NULL DEFAULT '0',
`Vit` smallint(6) NOT NULL DEFAULT '0',
`Wis` smallint(6) NOT NULL DEFAULT '0',
`Job1` tinyint(4) unsigned NOT NULL DEFAULT '0',
`Job2` tinyint(4) unsigned NOT NULL DEFAULT '0',
`Job3` tinyint(4) unsigned NOT NULL DEFAULT '0',
`Job4` tinyint(4) unsigned NOT NULL DEFAULT '0',
`X` smallint(6) NOT NULL DEFAULT '0',
`Y` smallint(6) NOT NULL DEFAULT '0',
`Hair` smallint(6) NOT NULL,
`Eyes` smallint(6) NOT NULL,
`SP` smallint(6) NOT NULL DEFAULT '0',
`AP` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of players
-- ----------------------------
INSERT INTO `players` VALUES ('1', '1', 'Admin', '200', '1000000', '900', '100', '900', '100', '300', '999', '999', '999', '999', '999', '999', '3', '9', '17', '0', '400', '536', '15', '37', '999', '999');
-- ----------------------------
-- Procedure structure for `ChangePassword`
-- ----------------------------
DROP PROCEDURE IF EXISTS `ChangePassword`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `ChangePassword`(IN `User` char(32),IN `Pass` varchar(20))
BEGIN
UPDATE Accounts SET Password = Pass WHERE Username = User;
END
;;
DELIMITER ;
-- ----------------------------
-- Procedure structure for `FullLogin`
-- ----------------------------
DROP PROCEDURE IF EXISTS `FullLogin`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `FullLogin`(IN `User` char(32),IN `Pass` char(20))
BEGIN
select ID from Accounts where Username = User and Password = Pass;
END
;;
DELIMITER ;
-- ----------------------------
-- Procedure structure for `GetItems`
-- ----------------------------
DROP PROCEDURE IF EXISTS `GetItems`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetItems`(IN `pID` smallint, IN `bool` tinyint)
BEGIN
select * from Items where PlayerID = pID and IsEquipment = bool;
END
;;
DELIMITER ;
-- ----------------------------
-- Procedure structure for `GetPlayer`
-- ----------------------------
DROP PROCEDURE IF EXISTS `GetPlayer`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetPlayer`(IN `uID` int, IN `pName` char(20))
BEGIN
select * from Players where UserID = uID and Name = pName;
END
;;
DELIMITER ;
-- ----------------------------
-- Procedure structure for `GetPlayers`
-- ----------------------------
DROP PROCEDURE IF EXISTS `GetPlayers`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetPlayers`(IN `uID` int)
BEGIN
select * from Players where UserID = uID;
END
;;
DELIMITER ;
-- ----------------------------
-- Procedure structure for `Login`
-- ----------------------------
DROP PROCEDURE IF EXISTS `Login`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `Login`(IN User char(32))
BEGIN
select ID,Password from Accounts where Username = User;
END
;;
DELIMITER ;
Last edited:
