KidRock
Administrator
Data inscrierii: 29/Aug/2008
Mesaje: 145
Localitate: Galaty
|
 Trimis: 29/08/2008 20:22 Titlul subiectului: Asa Faci Sa-ti Dea Urmatoarea Clasa Pe 0.99b! |
 |
|
Am facut acest tutorial pentru cei care vor sa-si faca servere fara sa faca questu-l, este teribil de 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 |
|
