Help me pls

[pondzas]

UPDATE MEMB_CREDITS
SET Credits = Credits + 50
FROM MEMB_CREDITS JOIN MEMB_STAT ON MEMB_CREDITS.memb___id = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE OnlineHours = 1 And ConnectStat = 1


how to use it ?

i need use script




im bad english

[MentaL]

[19871986]

you must make Job for this query

but my suggest is you can do credit / hours system with Stored Procedure

i remember the ' WZ_DISCONNECTMEMBER ' or like this, make SP Query here and when player Disconnect in game credits will be add to account automatic.

also you can use this query manually on ' Sql Query Analyzer '
( don't forgot the choose DB name at left corner )

[KarLi]

Just run Query Analyzer > Login with ur ID:
sa and SQL Password
then just paste the SQL Code and there is on top a "Green button to run the query" then ur done.

[pondzas]

i Use database Enc2.0.7.0