| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/New folder/New folder/software/Services/statuscpp/MessageStatusCPP/Release/ |
Upload File : |
use smartsmsrouter;
DELIMITER //
CREATE PROCEDURE get_username (IN musername varchar(60), Out musername_out varchar(60))
BEGIN
SET musername_out = '0';
select username INTO musername_out from userlogin where username = musername;
END//
DELIMITER ;
DELIMITER //
CREATE PROCEDURE get_StatusCode(IN statecode varchar(50), Out myResponse varchar(100))
BEGIN
SET myResponse = '0';
select description INTO myResponse from messagestate where code = statecode;
END//
DELIMITER ;
DELIMITER //
CREATE PROCEDURE get_NetworkCode(IN networkcode varchar(50), Out myResponse varchar(100))
BEGIN
SET myResponse = '0';
select description INTO myResponse from status where code = networkcode;
END//
DELIMITER ;
DELIMITER //
CREATE PROCEDURE update_Messagesent(
IN mstatus varchar(100),
IN mfailurereason varchar(100),
IN messageID varchar(100))
BEGIN
UPDATE messagesent SET status =mstatus,failurereason=mfailurereason ,track ='2' where messageID = messageID;
END//
DELIMITER ;
Call update_Messagesent("Delivered","No Error","854656720504258390",@response);
DELIMITER //
CREATE PROCEDURE update_Messagestatus(
IN serial varchar(100))
BEGIN
UPDATE messagestatus set status ='1' where sn = serial order by sn;
END//
DELIMITER ;