N!ku Administrator


Data inscrierii: 13/Dec/2008 Mesaje: 2939 Localitate: Liberty City
|
Trimis: 12/03/2011 09:34 Titlul subiectului: Asa faci sa-ti dea urmatoarea clasa automat 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 |
Sper ca ati inteles !!! |
|