Question about SQL JOB

[Proxynear]

Is there any way to make a SQL Job giving ppoint per time the player plays in DKSquare ?
and where can i edit the auto-event or create my own(ive tried to find in data but i dont think so is there)

[DK-]

Originally Posted by Proxynear

Is there any way to make a SQL Job giving ppoint per time the player plays in DKSquare ?
and where can i edit the auto-event or create my own(ive tried to find in data but i dont think so is there)

I don't know about sql Job but i can give you SQL script for it

[guesswho-.-]

It's possible only if you make PP tradable. PP is like dil, it's saved in session's memory and it gets flushed every so often so even if you update the value, it'll be overwritten in a few minutes. Your best way is to make an item which you can exchange for PP and send it via mail

[Proxynear]

But is there possible to make any npc selling some rings for ppoints right?
Ive tried to look out and find what his the npc job for define the npc as ppoint items and not dil

[guesswho-.-]

as far as I know its impossible to sell stuff for PP without editing the exe

[[DEV]Dekaron]

Lol do i need show you its is possible without editing exe and other just look closer to item and shopset thats all you can put in this shop all what you want.

I don't have old screen but i put to shop NPC Love and all works perfect.



If you want you can put there even item from D-shop

Look closer in files itemetc.csv column named PurchasePoint (o **** there is a price for PP PurchasePoint)

Then look what that item and BOOM look at shopset.csv for correct index and change this index on another or just add new item in shopset (Love or any shop you like) set the price in itemetc item weapon or what you want.

Just look:


And one more thing if you add some item in shopset increase TotalCount row for more item if don't do this item not show in shop

Sample:

[freez00]

You can sell any item you want for ppoints or even B and/or P coins without editing the exe.

As for the SQL job, you can't give ppoints to a player that's logged in game. So, you can do a query to give ppoints if the login_flag = 0 (not logged in).

Make a SQL Agent Job with the query and then add a schedule to the Agent to run every day at a specific time.

[Farius~]

Anyone have job for giving coins per time player online in game?.

[Proxynear]

About make an auto-event is that possible , and if yes where i can go to edit or make one
?

The job for give players online coins is this :

Step 1
UPDATE
cash.dbo.user_cash
SET
amount = amount + 8
where
user_no in (
select user_no from account.dbo.user_profile where login_flag = '1100'
)

schedeul every 1 hour

[guesswho-.-]

Originally Posted by [DEV]Dekaron

Lol do i need show you its is possible without editing exe and other just look closer to item and shopset thats all you can put in this shop all what you want.

I don't have old screen but i put to shop NPC Love and all works perfect.



If you want you can put there even item from D-shop

Look closer in files itemetc.csv column named PurchasePoint (o shit there is a price for PP PurchasePoint)

Then look what that item and BOOM look at shopset.csv for correct index and change this index on another or just add new item in shopset (Love or any shop you like) set the price in itemetc item weapon or what you want.

Just look:


And one more thing if you add some item in shopset increase TotalCount row for more item if don't do this item not show in shop

Sample:

go take some reading lessons. I clearly said sell items, not buy them.
I'm not an idiot and I know you can buy items for PP since a9. there is no way to sell an item for PP though. Like, for example, you have a bow and you want to sell it for 5k PP. No can do without certain edits on the exe side.

@Proxynear your SQL query is sketchy, it means they just have to log in right before the job executes.
anyways I found another way to solve your issue, create a new column in your user_character table and update it when a char is online for an hour. then hook SP_CHAR_CHECK_IN (or OUT was it? I always mix these two together) and update the PP based on that column.

[[DEV]Dekaron]

Proxynear
but if you want give player more PP ther is another way i make this for my server.

[guesswho-.-]

easiest way I can think of:
add a new column in user_character, call it whatever you want. lets say dwPPBonus
now wrap this code in a job (100 is an example of how much PP you should give):
update user_character set dwPPBonus = dwPPBonus + 100 where login_flag <> 0

now modify SP_CHAR_CHECK_IN and put a check at the end which will execute after all the info is saved:
update user_character set dwLowPPoint = (dwLowPPoint + dwPPBonus), dwPPBonus = 0 where character_no = @character_no
now each time you log out your PP should be updated. if that doesnt work then you'll have to modify SP_ACC_LOGOUT, then it'll surely work.

[[DEV]Dekaron]

Just edit monster.csv on server side in two columns thats all And then player will get P Point when kill any monster or only selected.

The .csv files give really nice possibility to make unique server.

[Proxynear]

About moster.csv i know , but my objetive was making an even for they login and for hours they play get more ppoints (thx guesswho , thats what i was looking for).

About shield monster, is there an need to edit exe or is just a code for monster job.
I wanna make an buff giving shield as Rising dekaron

[elfulll]

Originally Posted by [DEV]Dekaron

Lol do i need show you its is possible without editing exe and other just look closer to item and shopset thats all you can put in this shop all what you want.

I don't have old screen but i put to shop NPC Love and all works perfect.



If you want you can put there even item from D-shop

Look closer in files itemetc.csv column named PurchasePoint (o shit there is a price for PP PurchasePoint)

Then look what that item and BOOM look at shopset.csv for correct index and change this index on another or just add new item in shopset (Love or any shop you like) set the price in itemetc item weapon or what you want.

Just look:


And one more thing if you add some item in shopset increase TotalCount row for more item if don't do this item not show in shop

Sample:

You clearly have absolutely NO idea what Paul meant to say. Next time you post please post something smart don't post because you felt like you should post something.