[Release]Unique Slayer System ,, grant title + write notice + reward

Page 2 of 2 1 2
09/29/2014 08:25 aw_elkady#16
Dear
Done add 2 tabel
but whe i add
Code:
ELSE IF (@CharNameCountKERB >= '10')
 begin
 IF @hwan = '90'
 begin
 Update SRO_VT_SHARD.dbo._Char Set HwanLevel='91' where (CharName16 = @Charname)
 insert into SRO_VT_SHARDLOG.dbo.PlusNotice ([Sent],[message],[date]) Values ('0','** Unique Slayer System** : '+@Charname+' has now recived ( Cerberus Slayer) title for killing Cerberus 10 times ',GETDATE())
 delete from SRO_VT_SHARDLOG.dbo._Uniques where ((CharName = @Charname) and MonsterCodeName like 'MOB_EU_KERBEROS')
 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_02',10,0 
 end
 end
in _AddLogItem
reblay this
Code:
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 48
Must declare the scalar variable "@CharNameCountKERB".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 50
Must declare the scalar variable "@hwan".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 52
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 53
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 54
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 55
Must declare the scalar variable "@Charname".
what can i do?
09/29/2014 08:39 鳳凰城#17
This one's not that so legit. it has no conditions for the specified sections what so ever! any shit beginner can easily code this shit if he has a brain. For an automatic system, you can't do this shit
Code:
IF @hwan = '90'
Update .. Set HwanLevel='91'
IT FUCKING SUPPOSE TO BE AUTOMATIC.
09/29/2014 10:28 [NoReason]#18
Quote:
Originally Posted by 鳳凰城 View Post
This one's not that so legit. it has no conditions for the specified sections what so ever! any shit beginner can easily code this shit if he has a brain. For an automatic system, you can't do this shit
Code:
IF @hwan = '90'
Update .. Set HwanLevel='91'
IT FUCKING SUPPOSE TO BE AUTOMATIC.
ROFL :D
09/29/2014 14:59 ​Exo#19
Quote:
Originally Posted by 鳳凰城 View Post
brain
People lost it long ago...
09/29/2014 16:10 Trinity^#20
Quote:
Originally Posted by Flowushy View Post
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 46
Must declare the scalar variable "@CharNameCountKERB".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 48
Must declare the scalar variable "@hwan".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 50
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 51
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 52
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 53
Must declare the scalar variable "@Charname".

While trying to add the addlogitem lines,

Any Solution?
You see how it tells you to declare the variable... that means you have to declare the variable... much hard.

DECLARE @CharNameCountKERB VARCHAR(128)
etc
etc
09/29/2014 17:04 KingDollar#21
When noobs release something :awesome:
09/29/2014 21:51 Dallin¥#22
Quote:
Originally Posted by _Joe View Post
What's Wrong with you -_- say it's not working too :3
why i have to use your crap i just was wondering what the point in the addlogitem lel
10/02/2014 18:02 tamermido#23
actually he take some shit from valthea db and release it btw it won't work because you miss some shit i won't tell you about it [onwer valthea] :)
10/03/2014 01:07 bestprem#24
else if at 1st o.O
10/04/2014 15:36 Muhab*#25
Quote:
Originally Posted by Syloxx View Post
blame other ppl SQL is mine job not yours

usally i would do the System better but no idea where to start here :D
actually you can't do that using sql only.
10/04/2014 23:15 bestprem#26
dat huge shit :3
10/09/2014 16:58 Syloxx#27
Quote:
Originally Posted by Muhab Ashraf View Post
actually you can't do that using sql only.
sure, its very simple if u begin from zero :DD

but usually i use the "noob" released shit and improve it but here it isnt possible :D
10/23/2014 22:54 *C0RE#28
That piece of code on _addLogItem will not work haha
You copied those lines from a db developed by someone else and you couldnt even copy them well.. lol.
12/10/2014 08:19 ValtheaOnline#29
before you post that shit please test it
12/10/2014 08:35 Anonymous-6723#30
Not a bad idea to release a system, but at least you could release it as a complete system not only a part of it.. You are missing conditions, as you can see some people don't really know how to declare even the variables themselves => IF @hwan = 90 ... this is most likely something like

Code:
SELECT @hwan = hwanlevel from shardname.._Char where charid = @charid
If we assume I am right.. how this has anything to do with the unique killing itself? You are using the item procedure.. On which event does this executes?

Page 2 of 2 1 2