[Release] Upgrade Scroll/Message

09/05/2014 00:58 Syloxx#16
ok, u really dont know anything about sql

"Check mine.. it does the same function.."

sure it does

2+2=4 (mine query)

(9-3*6-6)+1=4 (your query)

same result but with one is executed faster and wich one is clearer?

your query professionally written:

[Only registered and activated users can see links. Click Here To Register...]
09/05/2014 02:34 ​Exo#17
Quote:
Originally Posted by Syloxx View Post
ok, u really dont know anything about sql

"Check mine.. it does the same function.."

sure it does

2+2=4 (mine query)

(9-3*6-6)+1=4 (your query)

same result but with one is executed faster and wich one is clearer?

your query professionally written:

[Only registered and activated users can see links. Click Here To Register...]
You failed so hard dude you call Editing the format "Professional Written"
Selecting the variables in 1 statement is professional ? you serious...
using different operator makes you so prof. wow you inspired me..
:facepalm:
Go get a life Mr.Professional Query Writer !!!
What you have done to my query..
Code:
Using SELECT Instead of SET
Collecting Vars which depend on same slot in 1 statement
Making it more readable
Different Operator(Var=Var- [-=Var] so pro
09/05/2014 08:37 Devsome#18
So much hate here, I love it.
Thanks for the player who wanna help Silkroad players in anyway.
09/05/2014 09:18 Syloxx#19
Quote:
Originally Posted by xExorcist View Post
You failed so hard dude you call Editing the format "Professional Written"
Selecting the variables in 1 statement is professional ? you serious...
using different operator makes you so prof. wow you inspired me..
:facepalm:
Go get a life Mr.Professional Query Writer !!!
What you have done to my query..
Code:
Using SELECT Instead of SET
Collecting Vars which depend on same slot in 1 statement
Making it more readable
Different Operator(Var=Var- [-=Var] so pro
and again... :D

anyway your query is bugged.

1st no Gold declared.
2nd Arena Coins will not removed.
3rd on error u query don't restore gold / arena coins.

I'm out now if you have the opinion your queries are perfectly OK. I never said you query wont work (except now). sure your query works but Windows 95 works too would u install Windows 95 now? or another example u can choose a car, Ferrari and a scrap barrow which one would u choose, both can drive. SQL is easy everyone can write SQL Queries but the questions is. Can they write queries readable , max performed and safe? Usually its default to write queries like this to improve the performance of the Database it self to avoid lags but looks like u cant follow me. I'm sure u don't even know what is TRAN , NOLOCK , UPDLOCK and Triggers etc , I'm sure u just know the default clauses like select , update etc and if u are not ready to learn from me then i cant help you. i offered you my Skype to give u support but now its too late.
09/05/2014 11:32 ahmed4ever2u#20
this topic is funny
everyone review his coding skills.
like they are born professionals
09/05/2014 13:55 ​Exo#21
Quote:
Originally Posted by Syloxx View Post
and again... :D

anyway your query is bugged.

1st no Gold declared.
2nd Arena Coins will not removed.
3rd on error u query don't restore gold / arena coins.

I'm out now if you have the opinion your queries are perfectly OK. I never said you query wont work (except now). sure your query works but Windows 95 works too would u install Windows 95 now? or another example u can choose a car, Ferrari and a scrap barrow which one would u choose, both can drive. SQL is easy everyone can write SQL Queries but the questions is. Can they write queries readable , max performed and safe? Usually its default to write queries like this to improve the performance of the Database it self to avoid lags but looks like u cant follow me. I'm sure u don't even know what is TRAN , NOLOCK , UPDLOCK and Triggers etc , I'm sure u just know the default clauses like select , update etc and if u are not ready to learn from me then i cant help you. i offered you my Skype to give u support but now its too late.
OMG Such nub...
This was used at a procedure where gold was already declared :facepalm:
Just go try it before claiming it won't work.. i won't share a shit w/o testing it..
09/05/2014 14:55 Crue*#22
thank you bro.
09/05/2014 17:50 [NoReason]#23
Syloxx always acting like a pro while he's nothing some SQL tutorials : iam professional blablablabla your query written professional

your words makes no sense you flame with everyone who want to help
09/06/2014 03:26 鳳凰城#24
Quote:
Originally Posted by Syloxx View Post
i released now..

1 Admin Query
1 Feature
1 Fix

i guess thats enougt ;)


Example how a Professional Query looks like

[Only registered and activated users can see links. Click Here To Register...]
  • code a query
  • press enter much
  • add --#################
  • rearrange it
  • write by shit
  • ??
  • profit
09/06/2014 03:42 ​Exo#25
Quote:
Originally Posted by 鳳凰城 View Post
  • code a query
  • press enter much
  • add --#################
  • rearrange it
  • write by shit
  • ??
  • profit
And call it professional query :D
#KidBadge Earned.
09/06/2014 11:33 Syloxx#26
Quote:
Originally Posted by 鳳凰城 View Post
  • code a query
  • press enter much
  • add comments
  • rearrange it
  • add a "on error or 0 edits" query
jup on this easy query thats it, and you guys cant even do that :D

Quote:
Originally Posted by xExorcist View Post
OMG Such nub...
This was used at a procedure where gold was already declared :facepalm:
Just go try it before claiming it won't work.. i won't share a shit w/o testing it..
a procedure where @Gold is already declared ??

_AddLogItem?

i hope u know @Gold != Player gold :DD

and btw u wrote Scroll / Message

so show me where u can find @Gold in _AddMemo

pff amateur

Quote:
Originally Posted by [NoReason] View Post
Syloxx always acting like a pro while he's nothing some SQL tutorials : iam professional blablablabla your query written professional

your words makes no sense you flame with everyone who want to help
omg learn english menz

me can fyll speek englech meeeenzzz



@all noobs here:

I don't flame everybody who want to help, I flame you because your work does not meet my standards (no / less protection , no arrange code , slow / outdated methods to realize your way. Sure it may help a lot of people, but it help only people they don't have money to pay a SQL Developer. Se they don't have enough money and now this example:

He start a Server with only released shit.. the server is a noob server and will die quickly

He start a Server and after a while he want some new unreleased features... If the Database is shit because unclear / slow / unreadable code, usually tables are edited because noobs cant handle auto identity so the time expense increases and thus the price...

Advice to all who want to open a server:
don't use queries like this it will kill you later!

anyway back to the noobs...

I dont care you like me or not to be honest every prominent have haters and lovers. 100% of my customers loves me and I'm already known by many big developers, if i need cooperation iŽll get it. Trolling you guys is just a promotion for me ;) noobs will hate me, customers will love me and developers will find me :D
09/06/2014 14:48 ​Exo#27
Quote:
Originally Posted by Syloxx View Post
jup on this easy query thats it, and you guys cant even do that :D



a procedure where @Gold is already declared ??

_AddLogItem?

i hope u know @Gold != Player gold :DD

and btw u wrote Scroll / Message

so show me where u can find @Gold in _AddMemo

pff amateur



omg learn english menz

me can fyll speek englech meeeenzzz



@all noobs here:

I don't flame everybody who want to help, I flame you because your work does not meet my standards (no / less protection , no arrange code , slow / outdated methods to realize your way. Sure it may help a lot of people, but it help only people they don't have money to pay a SQL Developer. Se they don't have enough money and now this example:

He start a Server with only released shit.. the server is a noob server and will die quickly

He start a Server and after a while he want some new unreleased features... If the Database is shit because unclear / slow / unreadable code, usually tables are edited because noobs cant handle auto identity so the time expense increases and thus the price...

Advice to all who want to open a server:
don't use queries like this it will kill you later!

anyway back to the noobs...

I dont care you like me or not to be honest every prominent have haters and lovers. 100% of my customers loves me and I'm already known by many big developers, if i need cooperation iŽll get it. Trolling you guys is just a promotion for me ;) noobs will hate me, customers will love me and developers will find me :D
If you can't declare gold @_AddMemo then you shouldn't be reading this...
It's to easy to be mentioned...
If you can't set gold where its already declared then ye you should quit developing... i hate sharing what is 100% done i simply leave some small parts as this one to see nubs *like you* acting cool while finding them or nubs complaining that it doesnt work....
And i will say it for the last time those people that you call them nubs are contributing toward this community they help people not as you said 'promoting' so whatever they share you should be quit and say thanks or share something better and also say thanks..faggot
09/06/2014 15:13 Syloxx#28
Quote:
Originally Posted by xExorcist View Post
If you can't declare gold @_AddMemo then you shouldn't be reading this...
It's to easy to be mentioned...
If you can't set gold where its already declared then ye you should quit developing... i hate sharing what is 100% done i simply leave some small parts as this one to see nubs *like you* acting cool while finding them or nubs complaining that it doesnt work....
And i will say it for the last time those people that you call them nubs are contributing toward this community they help people not as you said 'promoting' so whatever they share you should be quit and say thanks or share something better and also say thanks..faggot
nope i wont say thanks because guys like me have to fix the problems of released queries sure we will get money for it but its fucking boring
09/06/2014 15:24 ​Exo#29
Quote:
Originally Posted by Syloxx View Post
nope i wont say thanks because guys like me have to fix the problems of released queries sure we will get money for it but its fucking boring
You are not supposed to fix what is meant to be fucked for example lets say i didn't declare gold here why? cuz i can't ? :facepalm: cuz if you can't figure out that it is not declared you don't deserve to use it... it's called 'Let people read and understand' not just a copy paste working query,..
Maybe when someone will try to use it and find this error he will read it and learn something new...
I have this working w/o any bug in a scroll and a message just few things modified and scroll is edited and it works just fine but i don't have to say everything here people have to figure it out themselves
09/06/2014 17:52 Syloxx#30
Quote:
Originally Posted by xExorcist View Post
You are not supposed to fix what is meant to be fucked for example lets say i didn't declare gold here why? cuz i can't ? :facepalm: cuz if you can't figure out that it is not declared you don't deserve to use it... it's called 'Let people read and understand' not just a copy paste working query,..
Maybe when someone will try to use it and find this error he will read it and learn something new...
I have this working w/o any bug in a scroll and a message just few things modified and scroll is edited and it works just fine but i don't have to say everything here people have to figure it out themselves
so explain me please why u said "@Gold is already declared in a Procedure"

looks like u didn't know that @Gold in _AddLogItem isn't for the character gold ?