[Release]Message System (create Your Own Automtic reply& reward )

[ahmed4ever2u]

• Well after showed their new krall server
• i saw gr8 stuff they made in the server.
• but i love to keep everything to public
• so by the time I'll post every thing they made on their server .
• starting with (Message system for getting titles or Even Giving gold or Silks for VIP members its based on your imagination)
• i will post krall query's and scripts for making my tool much more better :-p

download from

-------------------
Advanced title Request Query

 Spoiler

Ludoworks titles messages request has been emulated successfully

just Customize this query and you are done

DECLARE  @CustOmTitleRequest Varchar(30)=(select Message from _Memo where ID64 =  (select MIN(ID64)from _Memo where CharID = @CharID and Message like  @MessageCustom))
    IF @CustOmTitleRequest like 'Title%:%Captian%'
        Begin
            update _Char set HwanLevel = 2 where CharID = @CharID
        End
    IF @CustOmTitleRequest like 'Title%:%General%'
        Begin
            update _Char set HwanLevel = 3 where CharID = @CharID
        End
    IF @CustOmTitleRequest not like 'Title%:%Captian%' and @CustOmTitleRequest not like 'Title%:%General%'
        Begin
            SET @ReplayMessage = 'Errr Please Check your spelling'
        End

how my setting looks in my program ?

--------------------
first krall usage from this tool
Bug Report !

 Spoiler

Put this Query in the program

if exists (select charName16 from _Char where CharID = @CharID) BEGIN DECLARE @CharName Varchar(16)= (select charName16 from _Char where CharID = @CharID)DECLARE @MessageBUG varchar(1000)= (select Message from _Memo where ID64=(select MAX(ID64)from _Memo where CharID = @CharID))INSERT INTO BugReport VALUES(@CharName,@MessageBUG,GETDATE(),'Nope')END

you will need this table to record your bugs

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[BugReport] Script Date: 01/16/2013 11:53:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BugReport](
[Character_Name] [varchar](16) NOT NULL,
[BugReport] [varchar](1000) NOT NULL,
[Date] [varchar](100) NOT NULL,
[Readed] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[BugReport] ADD CONSTRAINT [DF_BugReport_Readed] DEFAULT ('nope') FOR [Readed]
GO

[PortalDark]

#approved

[xXMagicalXx]

Well done, well done

[ahmed4ever2u]

oqq menz



Ludoworks titles messages request has been emulated successfully



just Customize this query and you are done

DECLARE  @CustOmTitleRequest Varchar(30)=(select Message from _Memo where ID64 =  (select MIN(ID64)from _Memo where CharID = @CharID and Message like  @MessageCustom))
    IF @CustOmTitleRequest like 'Title%:%Captian%'
        Begin
            update _Char set HwanLevel = 2 where CharID = @CharID
        End
    IF @CustOmTitleRequest like 'Title%:%General%'
        Begin
            update _Char set HwanLevel = 3 where CharID = @CharID
        End
    IF @CustOmTitleRequest not like 'Title%:%Captian%' and @CustOmTitleRequest not like 'Title%:%General%'
        Begin
            SET @ReplayMessage = 'Errr Please Check your spelling'
        End

how my setting looks in my program ?

[Haze*]

Oh snap, not even close!

[ahmed4ever2u]

Originally Posted by Haze*

Oh snap, not even close!

hahah because its simple? huh?

[IceAmStiel]

Congratulations for "emulating" the simplest part of my work - bragging about it that you allegedly managed it makes me feel embarrassed for you cause it's not even converting the string input from the procedure dynamically.

So please stop using "Ludoworks" - you do know well that I am the one who does such stuff there and you should know that I'm not someone who's afraid of for example using JOIN's. I do know that SQL is extremely easy but there are still plenty of ways of realizing ideas. Lastly, I can ensure you that I did it completely different without the use of a redundant tool.


Yes folks, Caipi just got butthurt.

[鳳凰城]

Some announcements should be written .
1. this system was at overlimit in the first place . not ludoworoks
2. since both of servers has the same developer ' caipi ' - then he should add same tweeks . otherwise he has no new ideas to put

Well , some basic releases should rock entire developers ( if you know what i mean )

[Devsome]

Guys this is offtopic, if you gona love/hating you please write PNs.

Nvm. thanks for the tool

[PortalDark]

I only read bhlahblahblabhbalbahaq, me wery kral, blahblbhalbhba, stea much, blahblahb
#cleaned
stop this spam
is a little(no offense, i mean simple) release, there is no need to make a fuzz

btw, why I always find NoN_Stop on your combo options?

[IceAmStiel]

Originally Posted by ahmed4ever2u

[..]so tool will be 100x easier and faster

Neither nor. It might be easier for you, but inconvenient for your users. Keeping everything on MSSQL layer is faster than executing the same queries with your tool.

I highly doubt that you use performant and flawless queries in your tools. If you ever gonna create something more complex you'll face serious problems with your current state of knowledge.

And please stop comparing your tools with what I do, you may say that you tried to emulate one feature to show us what you've accomplished - I'd be glad to congratulate you if it's well done - but don't say it is equal even though it's not even close.

Originally Posted by Phoenix 1337

2. since both of servers has the same developer ' caipi ' - then he should add same tweeks . otherwise he has no new ideas to put

Well , some basic releases should rock entire developers ( if you know what i mean )

Glad that your english isn't understandable, so I won't bother deciphering what you were saying about me.
No, I don't know what you mean, it sounds like you want to stone the developers to death.

[PortalDark]

Originally Posted by IceAmStiel

Glad that your english isn't understandable, so I won't bother deciphering what you were saying about me.
No, I don't know what you mean, it sounds like you want to stone the developers to death.

i think he means that even small release can make big dev worry about their "unique" skills, am I right?

ok, lets leave this here
i hope this is the last time i come to clean

[鳳凰城]

Originally Posted by IceAmStiel

Neither nor. It might be easier for you, but inconvenient for your users. Keeping everything on MSSQL layer is faster than executing the same queries with your tool.

I highly doubt that you use performant and flawless queries in your tools. If you ever gonna create something more complex you'll face serious problems with your current state of knowledge.

And please stop comparing your tools with what I do, you may say that you tried to emulate one feature to show us what you've accomplished - I'd be glad to congratulate you if it's well done - but don't say it is equal even though it's not even close.





Glad that your english isn't understandable, so I won't bother deciphering what you were saying about me.
No, I don't know what you mean, it sounds like you want to stone the developers to death.

What I meant that a small tool makes alot of work . Sorry if you dont get it No harm feelings for you , Hands down to your overlimit/ludoworks develope .

[ahmed4ever2u]

Originally Posted by PortalDark

btw, why I always find NoN_Stop on your combo options?

idk also xD
its an old Database with many characters thats why its always there

[TheB1QB0SS]

i Should Send the Messege to My Self ?