elitepvpers

elitepvpers (https://www.elitepvpers.com/forum/)
-   SRO PServer Guides & Releases (https://www.elitepvpers.com/forum/sro-pserver-guides-releases/)
-   -   [Release]Message System (create Your Own Automtic reply& reward ) (https://www.elitepvpers.com/forum/sro-pserver-guides-releases/2363146-release-message-system-create-your-own-automtic-reply-reward.html)

ahmed4ever2u 01/16/2013 10:39

[Release]Message System (create Your Own Automtic reply& reward )
 
  • Well after [Only registered and activated users can see links. Click Here To Register...] 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
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

download from [Only registered and activated users can see links. Click Here To Register...]

-------------------
Advanced title Request Query :D
Spoiler:
Ludoworks titles messages request has been emulated successfully ;)

just Customize this query and you are done ;)



Code:


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 ?

[Only registered and activated users can see links. Click Here To Register...]

--------------------
first krall usage from this tool
Bug Report !
Spoiler:
Put this Query in the program
Code:

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

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 01/17/2013 17:45

#approved

xXMagicalXx 01/17/2013 18:02

Well done, well done :D

ahmed4ever2u 01/17/2013 19:38

oqq menz



Ludoworks titles messages request has been emulated successfully ;)



just Customize this query and you are done ;)



Code:


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 ?

[Only registered and activated users can see links. Click Here To Register...]

Haze* 01/17/2013 19:42

Oh snap, not even close!

ahmed4ever2u 01/17/2013 19:53

Quote:

Originally Posted by Haze* (Post 20751016)
Oh snap, not even close!

hahah because its simple? huh?:bandit:

IceAmStiel 01/18/2013 09:58

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.

鳳凰城 01/18/2013 11:04

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 :D

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

Devsome 01/18/2013 14:48

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

Nvm. thanks for the tool ;)

PortalDark 01/18/2013 15:51

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 01/18/2013 16:05

Quote:

Originally Posted by ahmed4ever2u (Post 20758498)
[..]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.



Quote:

Originally Posted by Phoenix 1337 (Post 20757607)
2. since both of servers has the same developer ' caipi ' - then he should add same tweeks . otherwise he has no new ideas to put :D

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 01/18/2013 16:21

Quote:

Originally Posted by IceAmStiel (Post 20761638)
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

鳳凰城 01/18/2013 18:15

Quote:

Originally Posted by IceAmStiel (Post 20761638)
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 01/18/2013 20:42

Quote:

Originally Posted by PortalDark (Post 20761408)
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 10/26/2013 00:05

i Should Send the Messege to My Self ?

asanoftw 10/26/2013 02:51

Quote:

Originally Posted by TheB1QB0SS (Post 25591685)
i Should Send the Messege to My Self ?

yeah dude

Power Road 11/05/2013 20:02

niceeeeeeeeeeeeeeeeeeee

tk69ok 12/04/2013 17:16

it not work with me,any help plz ?
[Only registered and activated users can see links. Click Here To Register...]


All times are GMT +2. The time now is 11:51.

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.