Aşağıdaki Kod sayesinde TBL Değiştirmeye ihtiyaç duymadan Valkyrielarınızı Dupelensede Başka userların giyememesini sağlayabilirsiniz.
Valkyrie alacak olan elemana şunu uygulamanız yeterlidir..
Kod:
update userdata set title = '10' where struserid = 'CharınIsmi'
Valkyrieların Her Parçalarının Her Bonuslularının Title ' ını 10 yapma kodu :
Query Analyzer'a Girilecek kod.
Kod:
update item set reqtitle = '10' where num = '508011510'
update item set reqtitle = '10' where num = '508011520'
update item set reqtitle = '10' where num = '508011530'
update item set reqtitle = '10' where num = '508011540'
update item set reqtitle = '10' where num = '508011020'
update item set reqtitle = '10' where num = '508012530'
update item set reqtitle = '10' where num = '508012510'
update item set reqtitle = '10' where num = '508012020'
update item set reqtitle = '10' where num = '508012520'
update item set reqtitle = '10' where num = '508012540'
update item set reqtitle = '10' where num = '508015510'
update item set reqtitle = '10' where num = '508015520'
update item set reqtitle = '10' where num = '508015540'
update item set reqtitle = '10' where num = '508015020'
update item set reqtitle = '10' where num = '508015530'
update item set reqtitle = '10' where num = '508014530'
update item set reqtitle = '10' where num = '508014020'
update item set reqtitle = '10' where num = '508014520'
update item set reqtitle = '10' where num = '508014510'
update item set reqtitle = '10' where num = '508014540'
update item set reqtitle = '10' where num = '508013540'
update item set reqtitle = '10' where num = '508013530'
update item set reqtitle = '10' where num = '508013020'
update item set reqtitle = '10' where num = '508013520'
update item set reqtitle = '10' where num = '508013510'
Buda AC' leri eşitlemek için kod. ( Bütün Valkyrieların 145 Defance vermesini sağlar )( Upgrade +8 en fazla +9 olan serverlarda Hiç problem çıkarmadan kullanabilirsiniz Defancesi çok fazla çok az gibi bişey yok dengeyi tutturduk denilebilir )
Query Analyzer' a girilecek kod.
Kod:
update item set ac = '145' where num = '508011510'
update item set ac = '145' where num = '508011520'
update item set ac = '145' where num = '508011530'
update item set ac = '145' where num = '508011540'
update item set ac = '145' where num = '508011020'
update item set ac = '145' where num = '508012530'
update item set ac = '145' where num = '508012510'
update item set ac = '145' where num = '508012020'
update item set ac = '145' where num = '508012520'
update item set ac = '145' where num = '508012540'
update item set ac = '145' where num = '508015510'
update item set ac = '145' where num = '508015520'
update item set ac = '145' where num = '508015540'
update item set ac = '145' where num = '508015020'
update item set ac = '145' where num = '508015530'
update item set ac = '145' where num = '508014530'
update item set ac = '145' where num = '508014020'
update item set ac = '145' where num = '508014520'
update item set ac = '145' where num = '508014510'
update item set ac = '145' where num = '508014540'
update item set ac = '145' where num = '508013540'
update item set ac = '145' where num = '508013530'
update item set ac = '145' where num = '508013020'
update item set ac = '145' where num = '508013520'
update item set ac = '145' where num = '508013510'
Valkyrie alacak olan elemana şunu uygulamanız yeterlidir..
Kod:
update userdata set title = '10' where struserid = 'CharınIsmi'
Valkyrieların Her Parçalarının Her Bonuslularının Title ' ını 10 yapma kodu :
Query Analyzer'a Girilecek kod.
Kod:
update item set reqtitle = '10' where num = '508011510'
update item set reqtitle = '10' where num = '508011520'
update item set reqtitle = '10' where num = '508011530'
update item set reqtitle = '10' where num = '508011540'
update item set reqtitle = '10' where num = '508011020'
update item set reqtitle = '10' where num = '508012530'
update item set reqtitle = '10' where num = '508012510'
update item set reqtitle = '10' where num = '508012020'
update item set reqtitle = '10' where num = '508012520'
update item set reqtitle = '10' where num = '508012540'
update item set reqtitle = '10' where num = '508015510'
update item set reqtitle = '10' where num = '508015520'
update item set reqtitle = '10' where num = '508015540'
update item set reqtitle = '10' where num = '508015020'
update item set reqtitle = '10' where num = '508015530'
update item set reqtitle = '10' where num = '508014530'
update item set reqtitle = '10' where num = '508014020'
update item set reqtitle = '10' where num = '508014520'
update item set reqtitle = '10' where num = '508014510'
update item set reqtitle = '10' where num = '508014540'
update item set reqtitle = '10' where num = '508013540'
update item set reqtitle = '10' where num = '508013530'
update item set reqtitle = '10' where num = '508013020'
update item set reqtitle = '10' where num = '508013520'
update item set reqtitle = '10' where num = '508013510'
Buda AC' leri eşitlemek için kod. ( Bütün Valkyrieların 145 Defance vermesini sağlar )( Upgrade +8 en fazla +9 olan serverlarda Hiç problem çıkarmadan kullanabilirsiniz Defancesi çok fazla çok az gibi bişey yok dengeyi tutturduk denilebilir )
Query Analyzer' a girilecek kod.
Kod:
update item set ac = '145' where num = '508011510'
update item set ac = '145' where num = '508011520'
update item set ac = '145' where num = '508011530'
update item set ac = '145' where num = '508011540'
update item set ac = '145' where num = '508011020'
update item set ac = '145' where num = '508012530'
update item set ac = '145' where num = '508012510'
update item set ac = '145' where num = '508012020'
update item set ac = '145' where num = '508012520'
update item set ac = '145' where num = '508012540'
update item set ac = '145' where num = '508015510'
update item set ac = '145' where num = '508015520'
update item set ac = '145' where num = '508015540'
update item set ac = '145' where num = '508015020'
update item set ac = '145' where num = '508015530'
update item set ac = '145' where num = '508014530'
update item set ac = '145' where num = '508014020'
update item set ac = '145' where num = '508014520'
update item set ac = '145' where num = '508014510'
update item set ac = '145' where num = '508014540'
update item set ac = '145' where num = '508013540'
update item set ac = '145' where num = '508013530'
update item set ac = '145' where num = '508013020'
update item set ac = '145' where num = '508013520'
update item set ac = '145' where num = '508013510'