help.. with premium system.. please

Results 1 to 4 of 4
  1. #1
    Apprentice SAERWEN is offline
    MemberRank
    Jul 2009 Join Date
    venezuelaLocation
    18Posts

    help.. with premium system.. please

    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 ..


  2. #2
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: help.. with premium system.. please

    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'

  3. #3
    Apprentice SAERWEN is offline
    MemberRank
    Jul 2009 Join Date
    venezuelaLocation
    18Posts

    Re: help.. with premium system.. please

    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..

    Code:
    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,,>

  4. #4
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: help.. with premium system.. please

    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.



Advertisement