Two Questions

[YstreX]

Hi,
Ive 2 Questions and I hope u can help me :)
1: Is there a way to unlock all Elite-Skills?
2: How can I "? give" me Mana-Stones with Stats?

Frendly Greets and thanks for ur time
YstreX

[MentaL]

[Drewww]

Use two 60 elite books in a row and it unlocks all elites for the class combination you are on.
As for mana stones with stats. Cant do with ? give. Read my SQL examples how to use the mail system to send you stuff.

[YstreX]

Ahh thank you :))

- - - Updated - - -

1 more Question: Ive restarted the Server (also Started the Zone where i logged off) and now I cant join the world. I also cannot join Howling Mointains with a new character (zone started).

Someone has an idea what the reason could be?

[Drewww]

Did you edit any data in the SQL database ? Careful when editing directly SQL database, many fields have serial numbers, if they dont match you can not log in.
Try make new character and see if it does the same.

[Turmalin]

function fon(id)
SetFlag(OwnerID(),id,1); --546211
end


function foff(id)
SetFlag(OwnerID(),id,0); --546211
end
function Z25_NPC121917_01()
SetSpeakDetail( OwnerID() , "Do you wanna see some street magic?" )
AddSpeakOption( OwnerID() , TargetID() , "Learn elite skills" , "skilltest(0)" , 0 ) --Єр¦^¤W¤@­¶
AddSpeakOption( OwnerID() , TargetID() , "Forget elite skills" , "skilltest(1)" , 0 ) --Єр¦^¤W¤@­¶
AddSpeakOption( OwnerID() , TargetID() , "Learn dwarf elite skills" , "skilltest(0)" , 0 ) --Єр¦^¤W¤@­¶
AddSpeakOption( OwnerID() , TargetID() , "Forget dwarf elite skills" , "skilltest(1)" , 0 ) --Єр¦^¤W¤@­¶
end


function dwarfskils()
if typeid==1 then
foff(545880)
foff(545881)
foff(545882)
foff(545883)
foff(545884)
foff(545885)
foff(545886)
foff(545887)
foff(545888)
foff(545889)
foff(545890)
foff(545891)
foff(545892)
foff(545893)
foff(545894)
foff(545895)
foff(545896)
foff(545897)
foff(545898)
foff(545899)
foff(545900)
foff(545901)
foff(545902)
foff(545903)
foff(545904)
foff(545905)
foff(545906)
foff(545907)
foff(545908)
foff(545909)
foff(545910)
foff(545910)
foff(545912)
foff(545913)
foff(545914)
foff(545915)
foff(545916)
foff(545917)
foff(545918)
foff(545919)
foff(545908)
foff(545915)
foff(546211)
foff(545920)
foff(545921)
foff(545922)
foff(545923)
foff(545924)
foff(545925)
foff(545926)
foff(545927)
foff(545928)
foff(545929)
foff(545930)
foff(545931)
foff(545932)
foff(545933)
foff(545934)
foff(545935)
foff(545936)
foff(545937)
foff(545938)
foff(545939)
foff(545940)
foff(545941)
foff(545942)
foff(545943)
foff(545944)
foff(545945)
foff(545946)
foff(545947)
foff(545948)
foff(545949)
foff(545950)
foff(545951)
foff(545952)
foff(545953)
foff(545954)
foff(545955)
foff(545956)
foff(545957)
foff(545958)
foff(545959)
foff(545926)
foff(545927)
foff(545954)
foff(545941)
foff(545932)
foff(545930)
else
fon(545880)
fon(545881)
fon(545882)
fon(545883)
fon(545884)
fon(545885)
fon(545886)
fon(545887)
fon(545888)
fon(545889)
fon(545890)
fon(545891)
fon(545892)
fon(545893)
fon(545894)
fon(545895)
fon(545896)
fon(545897)
fon(545898)
fon(545899)
fon(545900)
fon(545901)
fon(545902)
fon(545903)
fon(545904)
fon(545905)
fon(545906)
fon(545907)
fon(545908)
fon(545909)
fon(545910)
fon(545910)
fon(545912)
fon(545913)
fon(545914)
fon(545915)
fon(545916)
fon(545917)
fon(545918)
fon(545919)
fon(545908)
fon(545915)
fon(546211)
fon(545920)
fon(545921)
fon(545922)
fon(545923)
fon(545924)
fon(545925)
fon(545926)
fon(545927)
fon(545928)
fon(545929)
fon(545930)
fon(545931)
fon(545932)
fon(545933)
fon(545934)
fon(545935)
fon(545936)
fon(545937)
fon(545938)
fon(545939)
fon(545940)
fon(545941)
fon(545942)
fon(545943)
fon(545944)
fon(545945)
fon(545946)
fon(545947)
fon(545948)
fon(545949)
fon(545950)
fon(545951)
fon(545952)
fon(545953)
fon(545954)
fon(545955)
fon(545956)
fon(545957)
fon(545958)
fon(545959)
fon(545926)
fon(545927)
fon(545954)
fon(545941)
fon(545932)
fon(545930)
end
end




function skilltest(typeid)
if typeid==1 then
foff(542106)
foff(543150)
foff(542125)
foff(542123)
foff(542122)
foff(542121)
foff(542111)
foff(542112)
foff(542113)
foff(542114)
foff(542115)
foff(542111)
foff(542111)
foff(542112)
foff(542113)
foff(543151)
foff(543152)
foff(542107)
foff(542108)
foff(542109)
foff(542110)
foff(542106)
foff(542110)
foff(542110)
foff(543076)
foff(543077)
foff(545983)
foff(545991)
foff(542124)
foff(543154)
foff(543153)
foff(542115)
foff(542115)
foff(542119)
foff(542118)
foff(542117)
foff(542116)
foff(546787)
foff(542120)
foff(542119)
foff(542118)
foff(542116)
foff(542117)
foff(542118)
foff(542119)
foff(542120)
foff(542116)
foff(542120)
foff(542116)
foff(543078)
foff(543079)
foff(545999)
foff(546022)
foff(546038)
foff(546030)
foff(542119)
foff(542117)
foff(542116)
foff(542116)
foff(542120)
foff(542119)
foff(542118)
foff(542117)
foff(542117)
foff(542097)
foff(545919)
foff(545903)
foff(545895)
foff(545887)
foff(546740)
foff(546743)
foff(542101)
foff(542102)
foff(542103)
foff(542104)
foff(542105)
foff(542101)
foff(542101)
foff(542102)
foff(545927)
foff(545935)
foff(542098)
foff(542099)
foff(542100)
foff(542100)
foff(542097)
foff(542099)
foff(543072)
foff(543073)
foff(545967)
foff(545975)
foff(545927)
foff(545959)
foff(545951)
foff(545943)
foff(542105)
foff(542102)
foff(542096)
foff(543156)
foff(543075)
foff(543075)
foff(543159)
foff(543158)
foff(543157)
foff(543156)
foff(543155)
foff(546755)
foff(543074)
foff(546833)
foff(546829)
foff(546831)
foff(546823)
foff(546831)
foff(546851)
foff(546849)
foff(546847)
foff(546845)
foff(546859)
foff(546853)
foff(546857)
foff(546833)
foff(546835)
foff(546861)
foff(546841)
foff(546837)
foff(546839)
foff(546855)
foff(546799)
foff(546801)
foff(546837)
foff(546837)
foff(546815)
foff(546821)
foff(546819)
foff(546803)
foff(546805)
foff(546807)
foff(546805)
foff(546817)
foff(546815)
foff(546813)
foff(546835)
foff(546839)
foff(546803)
foff(546843)
foff(546829)
foff(546805)
foff(546807)
foff(546809)
foff(546811)
foff(546866)
foff(546799)
foff(546827)
foff(546825)
foff(546823)
foff(546827)
foff(546748)
foff(546752)
foff(546764)
foff(546768)
foff(546776)
foff(546740)
foff(546766)
foff(542046)
foff(546738)
foff(546754)
foff(546742)
foff(546774)
foff(546776)
foff(546778)
foff(546774)
foff(546750)
foff(546772)
foff(546758)
foff(546746)
foff(546770)
foff(546744)
foff(546772)
foff(546736)
foff(546780)
foff(546788)
foff(546762)
foff(546786)
foff(546835)
foff(546782)
foff(546730)
foff(546790)
foff(546732)
foff(546792)
foff(546794)
foff(546760)
foff(546797)
foff(546784)
foff(546756)
foff(546764)
foff(546782)
foff(546734)
foff(541917)
foff(542052)
foff(541931)
foff(542112)
foff(542113)
foff(541932)
foff(542112)
foff(541977)
foff(546749)
foff(546796)
foff(546814)
foff(546842)
foff(546840)
foff(546834)
foff(546757)
foff(546838)
foff(546753)
foff(546836)
foff(546755)
foff(546751)
foff(546836)
foff(546739)
foff(546852)
foff(546737)
foff(546735)
foff(546733)
foff(546858)
foff(546854)
foff(546731)
foff(546856)
foff(546860)
foff(546850)
foff(546848)
foff(546745)
foff(546840)
foff(546735)
foff(546747)
foff(546844)
foff(546745)
foff(546743)
foff(546844)
foff(546846)
foff(546741)
foff(546862)
foff(546798)
foff(546808)
foff(546810)
foff(546812)
foff(546796)
foff(546800)
foff(546802)
foff(546777)
foff(546804)
foff(546806)
foff(546808)
foff(546806)
foff(546806)
foff(546804)
foff(546798)
foff(546796)
foff(546793)
foff(546791)
foff(546789)
foff(546787)
foff(546785)
foff(546783)
foff(546800)
foff(546781)
foff(546802)
foff(546775)
foff(546773)
foff(546824)
foff(546769)
foff(546826)
foff(546828)
foff(546767)
foff(546830)
foff(546832)
foff(546765)
foff(546763)
foff(546830)
foff(546761)
foff(546771)
foff(546773)
foff(546769)
foff(546769)
foff(546765)
foff(546816)
foff(546779)
foff(546818)
foff(546820)
foff(546777)
foff(546822)
foff(546818)
foff(546775)
foff(546759)




CloseSpeak(OwnerID());
else
fon(542106)
fon(543150)
fon(542125)
fon(542123)
fon(542122)
fon(542121)
fon(542111)
fon(542112)
fon(542113)
fon(542114)
fon(542115)
fon(542111)
fon(542111)
fon(542112)
fon(542113)
fon(543151)
fon(543152)
fon(542107)
fon(542108)
fon(542109)
fon(542110)
fon(542106)
fon(542110)
fon(542110)
fon(543076)
fon(543077)
fon(545983)
fon(545991)
fon(542124)
fon(543154)
fon(543153)
fon(542115)
fon(542115)
fon(542119)
fon(542118)
fon(542117)
fon(542116)
fon(546787)
fon(542120)
fon(542119)
fon(542118)
fon(542116)
fon(542117)
fon(542118)
fon(542119)
fon(542120)
fon(542116)
fon(542120)
fon(542116)
fon(543078)
fon(543079)
fon(545999)
fon(546022)
fon(546038)
fon(546030)
fon(542119)
fon(542117)
fon(542116)
fon(542116)
fon(542120)
fon(542119)
fon(542118)
fon(542117)
fon(542117)
fon(542097)
fon(545919)
fon(545903)
fon(545895)
fon(545887)
fon(546740)
fon(546743)
fon(542101)
fon(542102)
fon(542103)
fon(542104)
fon(542105)
fon(542101)
fon(542101)
fon(542102)
fon(545927)
fon(545935)
fon(542098)
fon(542099)
fon(542100)
fon(542100)
fon(542097)
fon(542099)
fon(543072)
fon(543073)
fon(545967)
fon(545975)
fon(545927)
fon(545959)
fon(545951)
fon(545943)
fon(542105)
fon(542102)
fon(542096)
fon(543156)
fon(543075)
fon(543075)
fon(543159)
fon(543158)
fon(543157)
fon(543156)
fon(543155)
fon(546755)
fon(543074)
fon(546833)
fon(546829)
fon(546831)
fon(546823)
fon(546831)
fon(546851)
fon(546849)
fon(546847)
fon(546845)
fon(546859)
fon(546853)
fon(546857)
fon(546833)
fon(546835)
fon(546861)
fon(546841)
fon(546837)
fon(546839)
fon(546855)
fon(546799)
fon(546801)
fon(546837)
fon(546837)
fon(546815)
fon(546821)
fon(546819)
fon(546803)
fon(546805)
fon(546807)
fon(546805)
fon(546817)
fon(546815)
fon(546813)
fon(546835)
fon(546839)
fon(546803)
fon(546843)
fon(546829)
fon(546805)
fon(546807)
fon(546809)
fon(546811)
fon(546866)
fon(546799)
fon(546827)
fon(546825)
fon(546823)
fon(546827)
fon(546748)
fon(546752)
fon(546764)
fon(546768)
fon(546776)
fon(546740)
fon(546766)
fon(542046)
fon(546738)
fon(546754)
fon(546742)
fon(546774)
fon(546776)
fon(546778)
fon(546774)
fon(546750)
fon(546772)
fon(546758)
fon(546746)
fon(546770)
fon(546744)
fon(546772)
fon(546736)
fon(546780)
fon(546788)
fon(546762)
fon(546786)
fon(546835)
fon(546782)
fon(546730)
fon(546790)
fon(546732)
fon(546792)
fon(546794)
fon(546760)
fon(546797)
fon(546784)
fon(546756)
fon(546764)
fon(546782)
fon(546734)
fon(541917)
fon(542052)
fon(541931)
fon(542112)
fon(542113)
fon(541932)
fon(542112)
fon(541977)
fon(546749)
fon(546796)
fon(546814)
fon(546842)
fon(546840)
fon(546834)
fon(546757)
fon(546838)
fon(546753)
fon(546836)
fon(546755)
fon(546751)
fon(546836)
fon(546739)
fon(546852)
fon(546737)
fon(546735)
fon(546733)
fon(546858)
fon(546854)
fon(546731)
fon(546856)
fon(546860)
fon(546850)
fon(546848)
fon(546745)
fon(546840)
fon(546735)
fon(546747)
fon(546844)
fon(546745)
fon(546743)
fon(546844)
fon(546846)
fon(546741)
fon(546862)
fon(546798)
fon(546808)
fon(546810)
fon(546812)
fon(546796)
fon(546800)
fon(546802)
fon(546777)
fon(546804)
fon(546806)
fon(546808)
fon(546806)
fon(546806)
fon(546804)
fon(546798)
fon(546796)
fon(546793)
fon(546791)
fon(546789)
fon(546787)
fon(546785)
fon(546783)
fon(546800)
fon(546781)
fon(546802)
fon(546775)
fon(546773)
fon(546824)
fon(546769)
fon(546826)
fon(546828)
fon(546767)
fon(546830)
fon(546832)
fon(546765)
fon(546763)
fon(546830)
fon(546761)
fon(546771)
fon(546773)
fon(546769)
fon(546769)
fon(546765)
fon(546816)
fon(546779)
fon(546818)
fon(546820)
fon(546777)
fon(546822)
fon(546818)
fon(546775)
fon(546759)
CloseSpeak(OwnerID());
end
end


Add this script to new file named like "a_*.lua"(this file must be loaded last, so use any non-numeric symbol at start or just create script with number higher than latest existing script). After this do ? reloadplot or restart location and spawn 121917. This npc would have 4 dialog options with elite/dwarf elite skills(didn't remember, are there all skills or part only).