[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE `SP_CREATE_ACCOUNTS`(IN Str CHAR(32), IN TheStrat INT, IN TheEnd INT)
' at line 1
[Err] CREATE DEFINER=`ragezone`@`localhost` PROCEDURE `SP_CREATE_ACCOUNTS`(IN Str CHAR(32), IN TheStrat INT, IN TheEnd INT)
BEGIN
DECLARE Num int DEFAULT 0;
DECLARE acc CHAR(32) default "";
SET Num=TheStrat;
myloop: LOOP
IF Num>TheEnd THEN
LEAVE myloop;
END IF;
SET acc = CAST( Num AS CHAR(32) );
SET acc=CONCAT(Str, acc );
INSERT INTO gamearea_info VALUES (NULL, 1, 0, acc, acc, null, 0,0);
SET Num = Num + 1;
END LOOP myloop;
END;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE `SP_SELECT_ACCOUNTS_INFO`(IN Name CHAR(32) , IN cPassword CHAR(32),I' at line 1
[Err] CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_SELECT_ACCOUNTS_INFO`(IN Name CHAR(32) , IN cPassword CHAR(32),IN cIP CHAR(32))
BEGIN
DECLARE num TINYINT DEFAULT 0;
DECLARE ban_account TINYINT DEFAULT 0;
DECLARE ban_ip TINYINT DEFAULT 0;
SELECT count(*)
FROM gamearea_info
WHERE PassName = Name AND PassPwd = cPassword
INTO num;
IF num = 1 THEN
SELECT COUNT(*)
FROM accounts_ban
WHERE id = ( SELECT GID FROM gamearea_info WHERE PassName = Name ) AND NOW()<unbandate
INTO ban_account;
SELECT COUNT(*)
FROM ip_ban
WHERE ip = cIP AND NOW()<unbandate
INTO ban_ip;
END IF;
SELECT num,ban_account,ban_ip;
END;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE `SP_WEB_SELECT_LV`(IN F_LV INT, IN S_LV INT)
BEGIN
SELECT account' at line 1
[Err] CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_WEB_SELECT_LV`(IN F_LV INT, IN S_LV INT)
BEGIN
SELECT accounts,name,fighter_job_lv,scholar_job_lv
FROM godswar.character_base
WHERE fighter_job_lv >= F_LV
AND scholar_job_lv >= S_LV
ORDER BY accounts;
END;
[Msg] Finished - Unsuccessfully
------------------------------------------
