Most visitors online was 12542 , on 28 Apr 2024
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
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