A3server Guide forums

A3server Guide forums

A3game server development guides can be seen in this forums
 
HomeCalendarGalleryFAQSearchUsergroupsRegisterLog in

Share | 
 

 how to add option through SQL

View previous topic View next topic Go down 
AuthorMessage
Admin
Admin


Posts : 20
Points : 45000051
Join date : 2010-07-10
Location : Hyderabad

PostSubject: how to add option through SQL   Sat Jul 10, 2010 3:39 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????)

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
Back to top Go down
View user profile http://a3server.forumakers.com
 
how to add option through SQL
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Skyrim - Enable Data Files Option
» Never got the option to save Heather Poe
» WoW "Development" Server
» 360 Totally Wireless Headphones pt. 2- Turtle beach option.
» Thoughts on Forza 4

Permissions in this forum:You cannot reply to topics in this forum
A3server Guide forums :: Development guides-
Jump to: