Most visitors online was 12542 , on 28 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!UPDATE point SET time=time-@point WHERE @userid=uid AND @aid=aid AND time>=@point
IF @@rowcount = 1
INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, @sn, @aid, @point, @cash, @status, getdate() )
ELSE
BEGIN
INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn
SELECT @error = -8
END
INSERT INTO usecashnow (userid,zoneid,sn,aid,point,cash,status,creatime) VALUES (32,904,0,9,9000000,100000,1,GetDate());
Where 32 is the userid in the users table
This query adds 100.000 zen , if you need more or less you have to multiply that amount by 90 and replace the 9.000.000 value also.
so if your user id is 48 and want 1000 zen the query would be like this:
INSERT INTO usecashnow (userid,zoneid,sn,aid,point,cash,status,creatime) VALUES (48,904,0,9,90000,1000,1,GetDate());
Always worked for me, even when it says -1.
MSSQL
Code:EXEC [PassportBOI].[dbo].[pipiload_addcash] 'Account', 'ZEN-Value'
don't work for me