|
You last visited: Today at 04:41
Advertisement
[Release] Query To Add Skill 120 in Data Base ^^
Discussion on [Release] Query To Add Skill 120 in Data Base ^^ within the SRO Private Server forum part of the Silkroad Online category.
03/05/2012, 14:47
|
#1
|
elite*gold: 0
Join Date: Apr 2011
Posts: 590
Received Thanks: 774
|
[Release] Query To Add Skill 120 in Data Base ^^
Query To Add Skill 120 in Data Base D11 ^^
PHP Code:
############################################Query By:King$########################################################### UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 5409 ############################################Query By:King$###########################################################
Sry Query with wrong Fix
PHP Code:
############################################Query By:King$########################################################### UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 5409 AND 5409 ############################################Query By:King$###########################################################
press thanks ^^
|
|
|
03/05/2012, 15:38
|
#2
|
elite*gold: 0
Join Date: Apr 2011
Posts: 590
Received Thanks: 774
|
Quote:
Originally Posted by Nova1337
|
as you like ^^
|
|
|
03/05/2012, 15:57
|
#3
|
elite*gold: 0
Join Date: Jun 2009
Posts: 205
Received Thanks: 6
|
didnt works for me
|
|
|
03/05/2012, 17:02
|
#4
|
elite*gold: 0
Join Date: Sep 2011
Posts: 419
Received Thanks: 59
|
thanks
|
|
|
03/05/2012, 17:40
|
#5
|
elite*gold: 0
Join Date: Jan 2012
Posts: 1,867
Received Thanks: 1,091
|
Thanks as Like in facebook now ! wat a faq .. Anyway thanks for this release
|
|
|
03/05/2012, 18:05
|
#6
|
elite*gold: 0
Join Date: Jun 2010
Posts: 86
Received Thanks: 50
|
Quote:
Originally Posted by BestOnWorld
Query To Add Skill 120 in Data Base D11 ^^
PHP Code:
############################################Query By:King$########################################################### UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 1 AND 273 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 276 AND 3481 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3486 AND 3491 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3493 AND 8321 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8328 AND 8328 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8331 AND 12176 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12178 AND 12186 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12188 AND 12196 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12198 AND 12199 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12201 AND 12206 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12210 AND 12216 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12218 AND 12222 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12225 AND 12306 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12323 AND 20309 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20311 AND 20501 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20503 AND 21266 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 21268 AND 29693 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 29696 AND 30897 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31038 AND 31086 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31088 AND 31103 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31105 AND 31181 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31190 AND 31196 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31198 AND 31924 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32088 AND 32874 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32891 AND 32894 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32897 AND 32904 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33042 AND 33045 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33077 AND 33287 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33289 AND 33294 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33296 AND 33300 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33302 AND 33307 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33309 AND 33312 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33314 AND 33338 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33340 AND 33347 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33349 AND 33372 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33374 AND 33382 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33740 AND 33785 UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 7182 AND 7184 UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 3436 AND 3440 UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 5409 ############################################Query By:King$###########################################################
press thanks ^^
|
Seriously ?
More Copy PASTA
BTW look at the end of the query there's a mistake
|
|
|
03/05/2012, 18:18
|
#7
|
elite*gold: 35
Join Date: Dec 2011
Posts: 467
Received Thanks: 426
|
Quote:
Originally Posted by ™_Bassm_™
thanks
|
Actually 9 of 10 posts from you are like "thx" "good luck" "nice" "keep it up" "gl" and others , just press thx button and shut up.I will not report you for that atm.
|
|
|
03/05/2012, 21:55
|
#8
|
elite*gold: 60
Join Date: Feb 2012
Posts: 3,942
Received Thanks: 6,475
|
Quote:
Originally Posted by skinner1337
Actually 9 of 10 posts from you are like "thx" "good luck" "nice" "keep it up" "gl" and others , just press thx button and shut up.I will not report you for that atm.
|
He thinks it silkroad4shit.com where you can increase your post count by posting such *****
|
|
|
03/05/2012, 22:11
|
#9
|
elite*gold: 0
Join Date: Jan 2012
Posts: 1,867
Received Thanks: 1,091
|
Quote:
Originally Posted by LastThief*
He thinks it silkroad4shit.com where you can increase your post count by posting such *****
|
s4a = humiliate king li to them
|
|
|
03/06/2012, 01:44
|
#10
|
elite*gold: 0
Join Date: Apr 2011
Posts: 590
Received Thanks: 774
|
Sry Query with wrong Fix
PHP Code:
############################################Query By:King$########################################################### UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 5409 AND 5409 ############################################Query By:King$###########################################################
|
|
|
03/06/2012, 02:14
|
#11
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
|
Great work
|
|
|
03/06/2012, 06:37
|
#12
|
elite*gold: 60
Join Date: Feb 2012
Posts: 3,942
Received Thanks: 6,475
|
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
Doesn't need between condition
|
|
|
03/06/2012, 06:42
|
#13
|
elite*gold: 0
Join Date: Mar 2012
Posts: 4
Received Thanks: 0
|
why ofline
|
|
|
03/06/2012, 10:48
|
#14
|
elite*gold: 0
Join Date: Dec 2011
Posts: 651
Received Thanks: 266
|
S4Shit got new kingLI but speaking arabic !
|
|
|
03/06/2012, 13:16
|
#15
|
elite*gold: 0
Join Date: Apr 2011
Posts: 590
Received Thanks: 774
|
Quote:
Originally Posted by LastThief*
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
Doesn't need between condition
|
i know but i try without between and failed
|
|
|
|
|
Similar Threads
|
wtb a better data base PVE D13
01/29/2012 - SRO Private Server - 1 Replies
hello guyz im tried to make a Good DataBase With Dops Items D13 Or D12
And got already a mops 120-130 or got a Jupiter Working 100%
for that i want to pay a better database D13 Or D12 PVE
i can pay 40$ For DataBase D13
And Pay 25$ For a Better Database D12
|
Help Telecaster New Data Base
07/05/2011 - Rappelz - 2 Replies
Hi all I did Deleted mySql Frome My Pc then i Installe it When I try to Make the Telcaster New database Error Come for me Like thatplz Help and Thank you
ImageShack® - Online Photo and Video Hosting
|
help with data base
06/28/2009 - Dekaron Private Server - 3 Replies
hi staff I would like to know who has the database action 5 that can send by email or put a link to download.
or a server really dekaron action 4.
Man anybody will help me
|
New server SQL data base
02/22/2009 - Dekaron Private Server - 1 Replies
Hey
I need someone who knows how to set up a data base in sql server.
It would be much appreciated, and in return with help i could make
you a GM if you are interested in my dekaron server. I will be having
action 6 Files.
Dekaron Destiny will be released as soon as i get this working.
So i need top programmers
|
EO Server - Data Base?!?
04/29/2008 - EO PServer Hosting - 0 Replies
heya evry one!
i want to make my server wih help of light _knightxx (spy dude)
and i know now how to connect to navicat with my connection - but i need the db forthe server! can anyy one give me a link for a db?! (download)
pls
|
All times are GMT +2. The time now is 04:41.
|
|