does anyone have the query to set premium service to all users?
Printable View
does anyone have the query to set premium service to all users?
view cabal register account
have any scrip qb give auto to all user ??????
up .....
- - - Updated - - -
how set ??????Quote:
Originally Posted by samus
cabal_tool_registerAccount
Code:USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_registerAccount] Script Date: 6/9/2020 1:59:03 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] @id varchar(32), @password varchar(256))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo )
values @id, pwdencrypt(@password), '0', 1, '7700000000000' )
set @userNum = @identity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values @id @userNum,0,1000,GETDATE())
select @userNum as usernum
commit
cabal_tool_registerAccount_web
Code:USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_registerAccount_web] Script Date: 6/9/2020 2:00:14 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @id varchar(32),
@password varchar(256), @email varchar(100), @question varchar(200),
@answer varchar(200),
@ip varchar(32)
)
AS
begin tran
declare @userNum as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo,email,question,answer,ip )
values @id, pwdencrypt(@password), '0', 1, '7700000000000' @email @question,@answer,@ip )
set @userNum = @identity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values @id @userNum,0,0,GETDATE())
select @userNum as usernum
commit
1800 = DAYS = 5 YEARS
error code ???????? how fix
Attachment 167607
Remove the extra bracket in the specified line.Quote:
Originally Posted by Onplay
Make sure that you use this procedure during registration. Usually they use the ***_ web procedure, and the first script is not needed.
upd: The scripts really contain a lot of mistakes. Made corrections, but did not check. Check it out. If it does not work - write.I note that these scripts give a premium only to newly registered players.
cabal_tool_registerAccount
cabal_tool_registerAccount_webCode:USE [Account]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] ( @id varchar(32), @password varchar(256))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo)
values ( @id, pwdencrypt(@password), '0', 1, '7700000000000' )
set @userNum = @@identity
insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind)
values ( @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime)
values ( @id, @userNum,0,0,GETDATE())
select @userNum as usernum
commit
Code:USE [Account]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount_web] ( @id varchar(32), @password varchar(256), @email varchar(100), @question varchar(200),@answer varchar(200),@ip varchar(32))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table (ID, Password, Login, AuthType, IdentityNo, email, question, answer, ip )
values ( @id, pwdencrypt(@password), '0', 1, '7700000000000', @email, @question, @answer, @ip )
set @userNum = @@identity
insert into cabal_charge_auth (usernum, type, expiredate, payminutes, servicekind)
values ( @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime)
values ( @id, @userNum,0,0,GETDATE())
select @userNum as usernum
commit
The code will not work, i just gave them example so they can look into they're table and just adjust how i did. Is so simple...Quote:
Originally Posted by HariSeldon
You gave them a working code, but the crooked forum handler destroyed some characters and punctuation marks. Let's be honest.Quote:
Originally Posted by S37uP!Update
Yeah that's why i said the code isn't working :)Quote:
Originally Posted by HariSeldon
USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_registerAccount] Script Date: 15/01/2021 11:12:11 am ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] (@id varchar(32), @password varchar(256))
AS
begin tran
declare @userNum as int
insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo )
values (@id, pwdencrypt(@password), '0', 1, '7700000000000' )
set @userNum = @@identity
insert into cabal_charge_auth(usernum, type, expiredate, payminutes, servicekind)
values @userNum, 0, DATEADD(day, 1800, getdate()), 0, 1)
insert into CabalCash..cashaccount (id,UserNum,Cash,CashBonus,UpdateDateTime) values(@id, @userNum, 0, 1000, GETDATE())
select @userNum as usernum
commit
--------------------------------------------------------------------------------------------------------------------------------------------------------
use that
next time use your logic side to overcome those wrongs syntax
