Help Prime Shop Points

[sir34l]

Can someone take me out of this doubt, would like to know where I can add the points to use in Prime Shop, I am using the AdvExt Gracia Final server.

[Jojo_]

Can you try that an tell if that right ? 
(I can not check i do not have working primeshop working for Gracia Final.)

Go in "Lin2World" then in "user_point"
Search for your desired character by ID 
I row point type search id 0 of your desired character (I suggest that for test you use your builder account.)
And in count if that 0 change it to something else so you can see that change in game.

If that does not change it be sure to reload character.
If that still not work try to add different Point type ID (ID 6 = Pc cafe point), all other I have no idea yet sorry.)
It does Not require server reboot when you give point. 

If after sometime you still have not found it I suggest to contact Advext and ask them some documentation after all you should have payed for their files :)

When I read their SQL it seem point id is 0 check bellow after "@account_id" :)

CREATE PROCEDURE lin_AddPointsJob
(
    @account_id INT,
    @points INT
)
AS
SET NOCOUNT ON;
INSERT INTO dbo.user_pending_job (account_id, job_type, job_param, job_create_time) VALUES (@account_id, 0, @points, GETDATE())
go

Edited November 8, 2017 by Jojo_

[sir34l]

I tried to use all the existing tables and information and could not add the points

 

Edit: my server did not really have the system, I had to add more tables, in my case it was the account_balance

Edited November 14, 2017 by sir34l
solved

[iPlay.GG - KromBacher]

On ‎11‎/‎11‎/‎2017 at 6:26 PM, sir34l said:

I tried to use all the existing tables and information and could not add the points

 

Edit: my server did not really have the system, I had to add more tables, in my case it was the account_balance

did you enable prime in L2Server.exe?  did you installed primestore sql's x 2 of them? 

Edited January 10, 2018 by iPlay.GG - KromBacher