Quote:
Originally Posted by xXExiledXx
I have tried to reconfigure my cs to use rupees but it's not easy because the server won't update your rupees.:( I have even tried using wh rupees and it's the same thing. As far as gen points I haven't tried but i'm guessing it might be the same thing.
|
there is a function with update_gold_chaos or something like that is used in several luas. Just search it, this could help you. (Chipexchange should contain it)
Quote:
Originally Posted by demonlordace
meh fk it im not that good to be able to make the ingame CS can sum1 atleast tell me what table the cs currency gets inserted to?
|
This is the SQL Query I wrote.
Maybe you can use it :)
Code:
Use Telecaster
DECLARE @id int; --accountid
DECLARE @itemcount int; --Itemcount
DECLARE @item int;
DECLARE @avatarid int;
-----------Insert Settings here-----------------
SET @item = '910005' --INSERT ITEM ID (e.g. 910005 for GMFB)
SET @itemcount = '1' --INSERT THE NUMBER OF ITEMS
SELECT @avatarid = sid FROM Character WHERE name = 'Troll' --INSERT CHARACTER NAME
------------------------------------------------
SELECT @id = account_id FROM Character WHERE sid = @avatarid
--Warning
IF @id IS NULL
BEGIN
PRINT 'WARNING: This Character does not exist. No Rows affected!'
RETURN
END
--DB Update
INSERT INTO [telecaster].[dbo].[PaidItem]([account_id],[avatar_id],[avatar_name],[item_code],[item_count],[rest_item_count],[bought_time],[valid_time],[server_name],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[taken_time],[taken_account_id],[confirmed],[confirmed_time]) VALUES (@id,@avatarid,NULL,@item,@itemcount,@itemcount,'2011-10-01 12:00:00.000',NULL,NULL,NULL,NULL,NULL,NULL,@id,NULL,NULL)