v0.53-v0.54.sql

JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-

    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `memo` WHERE `memo`.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_party01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_party01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `party` WHERE `party`.`party_id`=id;
END;

#
# Definition for the `MFJA_delete_pet01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_pet01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `pet` WHERE `pet`.`pet_id`=id;
END;

#
# Definition for the `MFJA_delete_skill01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_skill01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `skill` WHERE `skill`.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_storage01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_storage01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `storage` WHERE `storage`.`account_id`=id;
END;

#
# Definition for the `MFJA_insert_char01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_char01`(IN id INTEGER(11), IN char_num TINYINT(4), IN name_ VARCHAR(255), IN zeny INTEGER(11), IN str INTEGER(11), IN agi INTEGER(11), IN vit INTEGER(11), IN int_ INTEGER(11), IN dex INTEGER(11), IN luk INTEGER(11), IN max_hp INTEGER(11), IN hp INTEGER(11), IN max_sp INTEGER(11), IN sp INTEGER(11), IN hair TINYINT(4), IN hair_color INTEGER(11), IN last_map VARCHAR(20), IN last_x TINYINT(4), IN last_y TINYINT(4), IN save_map VARCHAR(20), IN save_x TINYINT(4), IN save_y TINYINT(4))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `char`(`account_id`, `char_num`, `name`, `zeny`, `str`, `agi`, `vit`, `int`, `dex`, `luk`, `max_hp`,
			   `hp`, `max_sp`, `sp`, `hair`, `hair_color`, `last_map`, `last_x`, `last_y`, `save_map`, `save_x`,
			   `save_y`)
VALUES (id, char_num, name_, zeny, str, agi, vit, int_, dex, luk, max_hp, hp, max_sp, sp, hair, hair_color, last_map, last_x,
	last_y, save_map, save_x, save_y);
END;

#
# Definition for the `MFJA_insert_charlog01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_charlog01`(IN log_ TEXT)
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `charlog` (`charlog`.`time`,`charlog`.`log`) VALUES (NOW(),log_);
END;

#
# Definition for the `MFJA_insert_friend01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_friend01`(IN id INTEGER(11), IN id1 INTEGER(11), IN id2 INTEGER(11), IN name_ VARCHAR(255))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `friend`(`friend`.`char_id`, `friend`.`id1`, `friend`.`id2`, `friend`.`name`)
VALUES (id, id1, id2, name_);
END;

#
# Definition for the `MFJA_insert_global_reg_value01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_global_reg_value01`(IN id INTEGER(11), IN str VARCHAR(255), IN val INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `global_reg_value`(`global_reg_value`.`char_id`, `global_reg_value`.`str`, `global_reg_value`.`value`)
VALUES (id, str, val);
END;

#
# Definition for the `MFJA_insert_global_reg_value02` procedure : 
#

CREATE PROCEDURE `MFJA_insert_global_reg_value02`(IN type_ INTEGER(11), IN id INTEGER(11), IN str VARCHAR(255), IN value_ VARCHAR(255))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `global_reg_value`(`global_reg_value`.`type`, `global_reg_value`.`account_id`, `global_reg_value`.`str`,
				       `global_reg_value`.`value`)
VALUES (type_, id, str, value_);
END;

#
# Definition for the `MFJA_insert_guild01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_guild01`(IN id INTEGER(11), IN name_ VARCHAR(255))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `guild`(`guild`.`guild_id`,`guild`.`name`,`guild`.`guild_lv`) VALUES (id,name_,'1');
END;

#
# Definition for the `MFJA_insert_homunculus01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_homunculus01`(IN class MEDIUMINT(9), IN name_ VARCHAR(24), IN account_id INTEGER(11), IN char_id INTEGER(11), IN base_level TINYINT(4), IN base_exp BIGINT(20), IN max_hp INTEGER(11), IN hp INTEGER(11), IN max_sp INTEGER(11), IN sp INTEGER(11), IN str INTEGER(11), IN agi INTEGER(11), IN vit INTEGER(11), IN int_ INTEGER(11), IN dex INTEGER(11), IN luk INTEGER(11), IN status_point INTEGER(11), IN skill_point INTEGER(11), IN equip MEDIUMINT(8), IN intimate MEDIUMINT(9), IN hungry MEDIUMINT(9), IN rename_flag TINYINT(4), IN incubate INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `homunculus`(`class`, `name`, `account_id`, `char_id`, `base_level`, `base_exp`, `max_hp`, `hp`,
				 `max_sp`, `sp`, `str`, `agi`, `vit`, `int`, `dex`, `luk`, `status_point`, `skill_point`,
				 `equip`, `intimate`, `hungry`, `rename_flag`, `incubate`)
VALUES (class, name_, account_id, char_id, base_level, base_exp, max_hp, hp, max_sp, sp, str, agi, vit, int_, dex, luk,
	status_point, skill_point, equip, intimate, hungry, rename_flag, incubate);
END;

#
# Definition for the `MFJA_insert_interlog01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_interlog01`(IN log VARCHAR(255))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `interlog` (`interlog`.`time`,`interlog`.`log`) VALUES (NOW(),log);
END;

#
# Definition for the `MFJA_insert_inventory01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_inventory01`(IN id INTEGER(11), IN nameid INTEGER(11), IN amount INTEGER(11), IN equip MEDIUMINT(8), IN identify SMALLINT(6))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `inventory`(`inventory`.`char_id`, `inventory`.`nameid`, `inventory`.`amount`, `inventory`.`equip`,
				`inventory`.`identify`)
VALUES (id, nameid, amount, equip, identify);
END;

#
# Definition for the `MFJA_insert_login01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_login01`(IN userid VARCHAR(255), IN user_pass VARCHAR(32), IN sex CHAR(1), IN email VARCHAR(60))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `login`(`login`.`userid`, `login`.`user_pass`, `login`.`lastlogin`, `login`.`sex`, `login`.`logincount`,
		    `login`.`level`, `login`.`state`, `login`.`email`)
VALUES(userid,user_pass,NOW(),sex,'0','0','0',email);
END;

#
# Definition for the `MFJA_insert_loginlog01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_loginlog01`(IN str VARCHAR(255))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `loginlog`(`loginlog`.`time`,`loginlog`.`log`) VALUES (NOW(), str);
END;

#
# Definition for the `MFJA_insert_memo01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_memo01`(IN id INTEGER(11), IN map VARCHAR(255), IN x_ INTEGER(11), IN y_ INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `memo`(`memo`.`char_id`, `memo`.`map`, `memo`.`x`, `memo`.`y`) VALUES (id, map, x_, y_);
END;

#
# Definition for the `MFJA_insert_party01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_party01`(IN id INTEGER(11), IN name_ VARCHAR(100), IN exp_ INTEGER(11), IN item INTEGER(11), IN leader_id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `party`(`party`.`party_id`, `party`.`name`, `party`.`exp`, `party`.`item`, `party`.`leader_id`)
VALUES (id, name_, exp_, item, leader_id);
END;

#
# Definition for the `MFJA_insert_pet01` procedure : 
#

CREATE PROCEDURE `MFJA_insert_pet01`(IN class MEDIUMINT(9), IN name_ VARCHAR(24), IN account_id INTEGER(11), IN char_id INTEGER(11), IN level_ TINYINT(4), IN egg_id INTEGER(11), IN equip MEDIUMINT(8), IN intimate MEDIUMINT(9), IN hungry MEDIUMINT(9), IN rename_flag TINYINT(4), IN incubate INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `pet`(`class`, `name`, `account_id`, `char_id`, `level`, `egg_id`, `equip`, `intimate`, `hungry`,
			  `rename_flag`, `incubate`)
VALUES (class, name_, account_id, char_id, level_, egg_id, equip, intimate, hungry, rename_flag, incubate);
END;

#
# Definition for the `MFJA_UpdateGuildStorage` procedure : 
#

CREATE PROCEDURE `MFJA_UpdateGuildStorage`(IN amount INTEGER(11), IN id INTEGER(11), IN nameid INTEGER(11), IN card0 INTEGER(11), IN card1 INTEGER(11), IN card2 INTEGER(11), IN card3 INTEGER(11), IN broken VARCHAR(20))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
UPDATE `guild_storage` set `guild_storage`.`amount`=amount
WHERE `guild_storage`.`guild_id`=id and `guild_storage`.`nameid`=nameid and `guild_storage`.`card0`=card0 and
      `guild_storage`.`card1`=card1 and `guild_storage`.`card2`=card2 and `guild_storage`.`card3`=card3 and
      `guild_storage`.`broken`=broken LIMIT 1;
END;

#
# Definition for the `MFJA_UpdateStorage` procedure : 
#

CREATE PROCEDURE `MFJA_UpdateStorage`(IN amount INTEGER(11), IN id INTEGER(11), IN nameid INTEGER(11), IN card0 INTEGER(11), IN card1 INTEGER(11), IN card2 INTEGER(11), IN card3 INTEGER(11), IN broken VARCHAR(20))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
UPDATE `storage` set `storage`.`amount`=amount
WHERE `storage`.`account_id`=id and `storage`.`nameid`=nameid and `storage`.`card0`=card0 and `storage`.`card1`=card1 and
      `storage`.`card2`=card2 and `storage`.`card3`=card3 and `storage`.`broken`=broken LIMIT 1;
END;

#
# Definition for the `MFJA_update_party01` procedure : 
#

CREATE PROCEDURE `MFJA_update_party01`(IN name_ VARCHAR(100), IN exp_ INTEGER(11), IN item INTEGER(11), IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
UPDATE `party` SET `party`.`name`=name_,`party`.`exp`=exp_,`party`.`item`=item
WHERE `party`.`party_id`=id;
END;

#
# Definition for the `MFJA_update_pet01` procedure : 
#

CREATE PROCEDURE `MFJA_update_pet01`(IN class MEDIUMINT(9), IN name_ VARCHAR(24), IN account_id INTEGER(11), IN char_id INTEGER(11), IN level_ TINYINT(4), IN egg_id INTEGER(11), IN equip MEDIUMINT(8), IN intimate MEDIUMINT(9), IN hungry MEDIUMINT(9), IN rename_flag TINYINT(4), IN incubate INTEGER(11), IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
UPDATE `pet` SET `pet`.`class`=class, `pet`.`name`=name_, `pet`.`account_id`=account_id, `pet`.`char_id`=char_id,
		 `pet`.`level`=level_, `pet`.`egg_id`=egg_id, `pet`.`equip`=equip, `pet`.`intimate`=intimate,
		 `pet`.`hungry`=hungry, `pet`.`rename_flag`=rename_flag, `pet`.`incubate`=incubate
WHERE `pet`.`pet_id`=id;
END;