A3 Heaven-Server Guide
Would you like to react to this message? Create an account in a few clicks or log in to continue.

A3 Heaven-Server Guide

A3-the AwEsOmE MMORPG Server Guide forums.-Shaikh Danish
 
HomeSearchLatest imagesRegisterLog in

 

 Modifying Item's Option's through SQL (Microsoft)

Go down 
AuthorMessage
Danni
Admin
Danni


Posts : 24
Join date : 2007-11-22
Location : Mumbai

Modifying Item's Option's through SQL (Microsoft) Empty
PostSubject: Modifying Item's Option's through SQL (Microsoft)   Modifying Item's Option's through SQL (Microsoft) Icon_minitimeMon Nov 26, 2007 9:51 am

take a look at ur item (i mean clean option, let say G10 mace with no option except lvl2) in ur SQL, it will consist something like this

1093;1441;25431063;0 --> G10 mace, lvl2

the first column (1093) is the id of the G10 mace n the 2nd column (1441) is the attribute for the mace. The 3rd column (i think.....) is the id of randomly created by server to differ from the other G10 mace as INS@NE has mention earlier in his previous post. 4th column?? figure it out urself.... Razz

1) Now we gonna make our mace have a blessing, so we add 32768 to the 1st column

1093+32768=33861

33861;1441;25431063;0 --> G10 mace, lvl2, blessing

2) mount?? add 65536 to the 1st column

33861+65536=99397

99397:1441;25431063;0 --> G10 mace, lvl2, blessing, mount 10%

for mount 30%... add 65536 for 2 times more to the 1st column n it will be like this

230469;1441;25431063;0 --> G10 mace, lvl2, blessing, mount 30%

3) now we make our mace lvl 15.... (only for weapon, for armor n etc can only lvl up to lvl 10 only, if not the item will crashed or unstable) so we need to plus 13 to 2nd column i.e

1441+13=1454 (bcos our mace is now lvl 2, it needs 13 more lvl to be lvl 15...)

230469;1454;25431063;0 --> G10 mace, lvl15, blessing, mount 30%

4) we need additional attack power to our mace, simply plus 16 to 2nd column

1454+16=1470

230469;1470;25431063;0 --> G10 mace, lvl15, blessing, mount 30%, add att power

5) the hardest part (for someone who has fear at math (even simple math) better stop here.... just joking....lol... no need to be serious all the time....), we got to mount a jewel to our mace.... let say ruby.. ( ruby can cause a red option to appear at our mace which is equivalent as garnet at other part of eq such as pants, glove and etc....) we call it red option..

we add 1048576 to the 2nd column

1470+1048576=1050046

230469;1050046;25431063;0 --> G10 mace, lvl15, blessing, mount 30%, add att power, fire attack 1

to make it fire attack 63, hmmm.... try urself..not gonna type all day here...

6) for blue option, add 16384 to 2nd column...

1050046+16384=1066430

230469;1066430;25431063;0 --> G10 mace, lvl15, blessing, mount 30%, add att power, fire attack 1, ice attack 1

7) for grey option, add 67108864 to the 2nd column...

1066430+67108864=68175294

230469;68175294;25431063;0 --> G10 mace, lvl15, blessing, mount 30%, add att power, fire attack 1, ice attack 1 and lightning attack 1

230469;4294952382;25431063;0 --> G10 mace, lvl15, blessing, mount 30%, add att power, fire attack 63, ice attack 63 and lightning attack 63 (GODLY MACE????)

Hmm I remember I posted a similar thread like this explaining how to custom create your own items. Almost everything can be custom made. I even did up a 30% mount bless ap/ad 63% items list.

For all those lazy to do up all the adding and subtraction,

G10 Spear Set 30% Mount + Bless + Ad/Ap + 63% Opts
33839;4294953082;136228;0

36204;4294955066;136228;0

36214;4294956090;136228;0

36224;4294954042;136228;0

36234;4294958138;136228;0

36244;4294957114;136228;0

G10 Sword Set 30% Mount + Bless + Ad/Ap + 63% Opts
33834;4294953082;136228;0;

3386;4294955066;136228;1;

3396;4294956090;136228;2;

3406;4294954042;136228;3;

3416;4294958138;136228;4;

3426;4294957114;136228;5

G10 Axe Set 30% Mount + Bless + Ad/Ap + 63% Opts
33829;4294953082;136228;0;

3356;4294955066;136228;1;

3361;4294956090;136228;2;

3366;4294954042;136228;3;

3371;4294958138;136228;4;

3376;4294957114;136228;5

G10 Sword HK 30% Mount + Bless + Ad/Ap + 63% Opts
230464;4294953082;136228;0;

232882;4294951418;136228;0

232857;4294955066;136228;0

232862;4294956090;136228;0

232867;4294954042;136228;0

232872;4294958138;136228;0

232877;4294957114;136228;0

G10 Mace HK 30% Mount + Bless + Ad/Ap + 63% Opts
230469;4294952378;136228;0

232942;4294951418;136228;0

232892;4294955066;136228;0

232902;4294956090;136228;0

232912;4294954042;136228;0

232922;4294958138;136228;0

232932;4294957114;136228;0

G9 UNIQUE
230522;4294953087;396823;0; WARR SWORD
230523;4294953151;396823;2; WARR SPEAR
230524;4294953215;396823;1; WARR AXE
230527;4294952319;396823;3; HK SWORD
230528;4294952383;396823;4; HK MACE
230529;4294952511;396823;5; BOW
230530;4294952575;396823;6; CROSS BOW
231549;4294953279;790039;7; DEX STAFF
231550;4294953663;658967;8 INTEL STAFF
Back to top Go down
http://www.a3india.com
 
Modifying Item's Option's through SQL (Microsoft)
Back to top 
Page 1 of 1
 Similar topics
-
» Modifying Experience rate
» Portable Microsoft Mathematics 4.0.325.rar
» Microsoft Office 2013 Activated Torrent Torrent Download

Permissions in this forum:You cannot reply to topics in this forum
A3 Heaven-Server Guide :: The great Server Guide-
Jump to: