help.. with premium system.. please

[SAERWEN]

hi.. I need urgent help ..
I need to explain how I put all players on premium so .. since many of them since last week said that his premium finish I am 26 and not extend hayado as everyone once your premium .. by the editors but I can do it player by player .. and I have not found a way to do it all at once .. since so many .. thanks ..

[MentaL]

[chumpywumpy]

This is nothing more that an sql query to update multiple values. Don't rely on tools to do everything, sql is your friend.

update account.dbo.cabal_charge_auth set expiredate='2020-010-01 00:00:00'

[SAERWEN]

mmm ... sorry but not much of it .. sent you the
code the query that I throw myself ... not want
invent .. because I'm afraid to damage something in the DB .. me
can illuminate .. I put the data where I
say? please..

UPDATE [ACCOUNT].[dbo].[cabal_charge_auth]
   SET [UserNum] = <UserNum, int,>
      ,[Type] = <Type, int,>
      ,[ExpireDate] = <ExpireDate, datetime,>
      ,[PayMinutes] = <PayMinutes, int,>
      ,[ServiceKind] = <ServiceKind, int,>
 WHERE <Condiciones de búsqueda,,>

[chumpywumpy]

You don't need to do it like that, what you have there is a much more specific type of query. If you run mine it will simply update all "expiredate" entries in cabal_charge_auth. You can't cause any damage with my query.