AutoQuest pe 0.99b

by **MeG@DaN** Sat Feb 19, 2011 7:11 pm

Am facut acest tutorial pentru cei care vor sa-si faca servere fara sa faca questu-l, este foarte simplu:

Pune-ti urmatoarele scripturi in SQL Query Analizer:

DK in BK

Cod:UPDATE Character
SET Class = ('17')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 16 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DW in SM

Cod:UPDATE Character
SET Class = ('1')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 0 AND Memb_Stat.ConnectStat = 0 AND clevel>149

ELF in MUSE ELF

Cod:UPDATE Character
SET Class = ('33')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 32 AND Memb_Stat.ConnectStat = 0 AND clevel>149