Hallo liebe Rappelz Community habe eine frage und zwar habe ich von jemanden einen vote shop bekommen wo ich via diesen befehl punkte adden kann
insert_vote_point 'Account_Name',1
ich würde das aber gerne in eine lua schreiben das ich via ein item das ingame nutzen kann
der befehl führt im grunde das hier aus
ALTER PROCEDURE [dbo].[insert_vote_point]
@[Only registered and activated users can see links. Click Here To Register...]_name NVARCHAR(MAX),
@[Only registered and activated users can see links. Click Here To Register...]_reward int
AS
DECLARE @[Only registered and activated users can see links. Click Here To Register...]_id int
set @[Only registered and activated users can see links. Click Here To Register...]_id = (SELECT account_id from Auth.dbo.Accounts where login_name = @[Only registered and activated users can see links. Click Here To Register...]_name)
IF EXISTS(SELECT * FROM dbo.user_points where account = @[Only registered and activated users can see links. Click Here To Register...]_id)
BEGIN
UPDATE dbo.user_points set punkte += @[Only registered and activated users can see links. Click Here To Register...]_reward,gesamt_punkte += @[Only registered and activated users can see links. Click Here To Register...]_reward where account = @[Only registered and activated users can see links. Click Here To Register...]_id
END
ELSE
BEGIN
INSERT INTO dbo.user_points VALUES @[Only registered and activated users can see links. Click Here To Register...]_id @[Only registered and activated users can see links. Click Here To Register...]_reward @[Only registered and activated users can see links. Click Here To Register...]_reward,GETDATE()-1,0,0)
END
aber wie schreibe ich das am besten in die lua
insert_vote_point 'Account_Name',1
ich würde das aber gerne in eine lua schreiben das ich via ein item das ingame nutzen kann
der befehl führt im grunde das hier aus
ALTER PROCEDURE [dbo].[insert_vote_point]
@[Only registered and activated users can see links. Click Here To Register...]_name NVARCHAR(MAX),
@[Only registered and activated users can see links. Click Here To Register...]_reward int
AS
DECLARE @[Only registered and activated users can see links. Click Here To Register...]_id int
set @[Only registered and activated users can see links. Click Here To Register...]_id = (SELECT account_id from Auth.dbo.Accounts where login_name = @[Only registered and activated users can see links. Click Here To Register...]_name)
IF EXISTS(SELECT * FROM dbo.user_points where account = @[Only registered and activated users can see links. Click Here To Register...]_id)
BEGIN
UPDATE dbo.user_points set punkte += @[Only registered and activated users can see links. Click Here To Register...]_reward,gesamt_punkte += @[Only registered and activated users can see links. Click Here To Register...]_reward where account = @[Only registered and activated users can see links. Click Here To Register...]_id
END
ELSE
BEGIN
INSERT INTO dbo.user_points VALUES @[Only registered and activated users can see links. Click Here To Register...]_id @[Only registered and activated users can see links. Click Here To Register...]_reward @[Only registered and activated users can see links. Click Here To Register...]_reward,GETDATE()-1,0,0)
END
aber wie schreibe ich das am besten in die lua