ingame cs

[demonlordace]

ok ive been looking around DBs to see what has to do with ingame cs currency and there isnt nething in auth dbo.account table like i thought there would be....the only table i have found that looks like it could be rite istelecaster dbo.globalvariable i know that sum of u have working cs pages but i miss that release and its been removed cuz of drama or what ever u wanna call it so i have nothing to go on rite now as far as db side and help would be welcomed on this

[ismokedrow]

Well from what I can tell it was written mostly in ASP. I'm sure a PHP alternative could be accomplished I myself do not have anywhere near enough knowledge in either ASP or PHP to even begin to give you a place to start. I will tell you that if you can prove your sincerity and deal with mild stupidity and emo'ness on a random basis PM Xijezu. He made the last working CS Shop System.

[TheOnlyOneRaskim]

sum of u have working cs pages but i miss that release and its been removed cuz of drama or what ever


Nope, its about the dum *****, wich try to earn money with the work of other

[demonlordace]

Originally Posted by TheOnlyOneRaskim

sum of u have working cs pages but i miss that release and its been removed cuz of drama or what ever


Nope, its about the dum *****, wich try to earn money with the work of other

lol u know what i ment yea im not all that good with that stuff either smoke like i said in that pm im better when it comes to RF online still getting used to all this stuff with rappelz

[gavsta]

I myself have the working CS its not been publicly released due to all the stupid hamachi servers opening with stupid CS's and the amount of spam the CS would make its just simply not worth it.

[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?

[ismokedrow]

Well even if you have working CS files you need the basic knowledge to configure it all. The shop can be read from a user created database named dbo.shop and can use any in-game currency (Rupee's or Gen Points)

[XavierDeFawks]

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.

[ismokedrow]

Me and Xijezu had it subtracting points. you just had to refresh the item shop by closing and reopening and it some tests it would auto update after the purchase

[demonlordace]

Originally Posted by ismokedrow

Well even if you have working CS files you need the basic knowledge to configure it all. The shop can be read from a user created database named dbo.shop and can use any in-game currency (Rupee's or Gen Points)

lol i myself dont have the knowledge to do it but that is why i have staff to take care of this kinda stuff

so could sum1 tell me the basic structure for this table and im guessing it would be made in auth DB as the cs points r bound to an account not a char

[haxti]

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)

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

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)