Plus Auto Notice(Sample + Source)

Page 15 of 25 FirstFirst ... 57891011121314151617181920212223 ... LastLast
Results 211 to 225 of 372
  1. #211
    Account Upgraded | Title Enabled! saxz is offline
    MemberRank
    Jul 2010 Join Date
    1,293Posts

    Re: Plus Auto Notice(Sample + Source)

    well i am using a bit diff query
    here it's
    Code:
    declare @iname varchar(200)
        declare @iid int
        declare @nombre varchar(200)
        declare @plus varchar(200)    
        declare @cname varchar(64)
        select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
        select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)
        select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
        select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
        select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
        SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
        select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
        SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
    i have no idea how to make it read only + 8 and above -.-

  2. #212
    Proficient Member pr0xy1337 is offline
    MemberRank
    Aug 2012 Join Date
    182Posts

    Re: Plus Auto Notice(Sample + Source)

    Quote Originally Posted by saxz View Post
    well i am using a bit diff query
    here it's
    Code:
    declare @iname varchar(200)
        declare @iid int
        declare @nombre varchar(200)
        declare @plus varchar(200)    
        declare @cname varchar(64)
        select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
        select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)
        select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
        select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
        select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
        SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
        select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
        SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
    i have no idea how to make it read only + 8 and above -.-
    Well I am using the original query from the first post and also the old tool that had the auto notice thingie (the original version)... Modified the query to read weapon names from a table and it works great it has a delay from around 4 seconds but I think it's okay. :) pm me if you need the query :)

  3. #213
    Account Upgraded | Title Enabled! lemoniscool is offline
    MemberRank
    Nov 2009 Join Date
    GermanyLocation
    579Posts

    Re: Plus Auto Notice(Sample + Source)

    Code:
        declare @iname varchar(200)
        declare @iid int
        declare @nombre varchar(200)
        declare @plus varchar(200)    
        declare @cname varchar(64)
        select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
        select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)
        select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
        select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
        select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
        SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
        select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
        if (@plus >= 15) begin
            SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
        end
    this code should work for you saxz

  4. #214
    SilkRoad loveme is offline
    MemberRank
    Sep 2011 Join Date
    JanganLocation
    498Posts

    Re: Plus Auto Notice(Sample + Source)

    dont login _

  5. #215
    In the Emperor name Caosfox is offline
    MemberRank
    Jun 2011 Join Date
    Balcora GateLocation
    1,608Posts

    Re: Plus Auto Notice(Sample + Source)

    you dont login on that part, you login at oyun part

  6. #216
    SilkRoad loveme is offline
    MemberRank
    Sep 2011 Join Date
    JanganLocation
    498Posts

    Re: Plus Auto Notice(Sample + Source)

    login and +9 puss dont hava notice ?


  7. #217
    Account Upgraded | Title Enabled! saxz is offline
    MemberRank
    Jul 2010 Join Date
    1,293Posts

    Re: Plus Auto Notice(Sample + Source)

    Quote Originally Posted by lemoniscool View Post
    Code:
        declare @iname varchar(200)
        declare @iid int
        declare @nombre varchar(200)
        declare @plus varchar(200)    
        declare @cname varchar(64)
        select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
        select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)
        select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
        select @plus = SUBSTRING(@strDesc, CHARINDEX('+',@strDesc,0) + 1, LEN(0)) 
        select @veremos = '[' + @cname +']'+' has Succeeded in Plusing '+'[' + @iname + ']'+' to Plus [' + @plus + ']'
        SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
        select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
        if (@plus >= 15) begin
            SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
        end
    this code should work for you saxz
    this one for above + 15 or + 8 ? xD

  8. #218
    SilkRoad loveme is offline
    MemberRank
    Sep 2011 Join Date
    JanganLocation
    498Posts

    Re: Plus Auto Notice(Sample + Source)

    2. notice

    Last edited by loveme; 09-07-13 at 09:26 PM.

  9. #219
    In the Emperor name Caosfox is offline
    MemberRank
    Jun 2011 Join Date
    Balcora GateLocation
    1,608Posts

    Re: Plus Auto Notice(Sample + Source)

    and what that mean? i only speak (and read) spanish and english

  10. #220
    SilkRoad loveme is offline
    MemberRank
    Sep 2011 Join Date
    JanganLocation
    498Posts

    Re: Plus Auto Notice(Sample + Source)


  11. #221
    In the Emperor name Caosfox is offline
    MemberRank
    Jun 2011 Join Date
    Balcora GateLocation
    1,608Posts

    Re: Plus Auto Notice(Sample + Source)

    and you created c:\mssqltips folder on same machine you are running the notice program?

  12. #222
    SilkRoad loveme is offline
    MemberRank
    Sep 2011 Join Date
    JanganLocation
    498Posts

    Re: Plus Auto Notice(Sample + Source)

    Quote Originally Posted by Caosfox View Post
    and you created c:\mssqltips folder on same machine you are running the notice program?
    now program open dont error and now dont notice ? puss for

  13. #223
    Account Upgraded | Title Enabled! lemoniscool is offline
    MemberRank
    Nov 2009 Join Date
    GermanyLocation
    579Posts

    Re: Plus Auto Notice(Sample + Source)

    Quote Originally Posted by loveme View Post
    now program open dont error and now dont notice ? puss for
    the error tells you that you need to create the folder C:\MSSQLTips

    Quote Originally Posted by saxz View Post
    this one for above + 15 or + 8 ? xD
    its for +15 and above you can edit if (@plus >= 15) begin to make it +8 and above or any other number you want

  14. #224
    Proficient Member a22345875 is offline
    MemberRank
    Aug 2009 Join Date
    London, UnitedLocation
    194Posts

    Re: Plus Auto Notice(Sample + Source)

    C:\MSSQLTips can not create any files,my os is win2003 x64

  15. #225
    In the Emperor name Caosfox is offline
    MemberRank
    Jun 2011 Join Date
    Balcora GateLocation
    1,608Posts

    Re: Plus Auto Notice(Sample + Source)

    procedure create files at mssqltips, check procedure



Advertisement