Hello guys, I wanna upgrade my D11 Server, I want some clean and fine D12 Database and its own media.pk2.
Please I need it as soon as possible and hope it is not uploaded on depoist files.
you don't need to find a database to upgrade your server like that,just make service of 12dg items 1 in your database and get pk2 files from a server which one got 12dg items.
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620
Skills
Code:
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
Take the bsr files by yourself from any client else or from isro.
vSRO database 07/22/2012 - SRO Private Server - 5 Replies I need 80 or 90 cap vsro files database with edit.HELP ME !! :confused:
[VSRO] how to edit mobs level in media/database ? 07/08/2012 - SRO Private Server - 2 Replies how to edit mobs level in media/database ?
or how to replace mobs in database
replace lvl 70 for 120 mobs for an example
i tried to make them and i met a smal problem
i kill the mobs and thier hp is not lowing down at the first hit
then when i hit the 2nd one it begins to get low
how to edit them with the right way
if anyone knows please share :)
Extract Media.pk2 / Database 06/01/2012 - SRO Private Server - 3 Replies Hello, like a topic, im looking for Media.pk2 extractor (i need extract all files, no once file like in Pk2Extractor...), and i looking for Full Database with some Avatars etc. for D12 or D13 and skills 120 / 130 vsro files, v. 1.1198
Thanks!
media.pk2 from vsro 09/26/2011 - SRO Private Server - 2 Replies ive tried edit with xvi32 but only getting memory errors since my ip is bigger than the one already on the file
mediapatcher not working aswell
tried also by editing division info and gateport also no luck
all kind of help or sugestion is welcome
> got teamviewer :)