SOL
SAĞ
Simya sistemi SQL'den okutma +basma gibi bugları kapatma
SİDEBAR REKLAMI

Bazı filesler txt de den sql e geçince simya sisteminde bir bug meydana geliyor + basılma veya saflık derecesine + basma gibi olaylarda bug oluşuyor bunu çözmek için yapılması gerekenler

db/src/ClientManagerBoot.cpp açın içerisinde
 

Kod:

bool CClientManager::InitializeItemTable()

kod bloğunun 3 - 4 satır altında
 

Kod:

"SELECT vnum, name, %s, type, subtype, gold, shop_buy_price, weight, size, flag, wearflag, "

yazacaktır buradaki vnum, ardına hemen vnum_range ekleyin yani son hali
 

Kod:

"SELECT vnum, vnum_range, name, %s, type, subtype, gold, shop_buy_price, weight, size, flag, wearflag, "

olacaktır ardından
 

Kod:

str_to_number(item_table->dwVnum, data[col++]);

altına
 

str_to_number(item_table->dwVnumRange, data[col++]);

ekleyin kaydedin game ve db yi baştan derleyin ardından item_proto.sql inize
 

`vnum_range` tinyint(4) NOT NULL DEFAULT '0',

tinyint türünde vnum_range ekleyin uzunluk 4 boş bırakılamaz ve standart değeri 0 olacak şekilde.

Son olarak item_protonuzu navicattan açın F6 tuşu ile consolu açın ve alttaki tüm kodları yapıştırıp çalıştırın.
 

Kod:

UPDATE item_proto SET vnum_range = '99' WHERE vnum=110000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=110100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=110200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=110300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=110400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=111000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=111100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=111200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=111300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=111400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=112000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=112100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=112200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=112300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=112400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=113000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=113100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=113200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=113300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=113400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=114000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=114100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=114200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=114300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=114400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=120000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=120100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=120200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=120300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=120400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=121000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=121100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=121200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=121300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=121400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=122000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=122100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=122200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=122300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=122400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=123000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=123100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=123200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=123300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=123400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=124000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=124100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=124200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=124300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=124400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=130000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=130100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=130200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=130300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=130400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=131000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=131100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=131200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=131300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=131400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=132000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=132100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=132200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=132300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=132400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=133000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=133100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=133200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=133300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=133400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=134000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=134100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=134200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=134300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=134400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=140000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=140100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=140200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=140300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=140400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=141000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=141100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=141200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=141300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=141400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=142000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=142100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=142200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=142300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=142400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=143000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=143100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=143200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=143300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=143400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=144000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=144100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=144200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=144300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=144400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=150000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=150100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=150200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=150300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=150400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=151000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=151100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=151200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=151300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=151400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=152000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=152100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=152200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=152300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=152400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=153000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=153100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=153200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=153300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=153400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=154000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=154100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=154200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=154300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=154400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=160000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=160100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=160200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=160300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=160400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=161000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=161100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=161200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=161300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=161400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=162000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=162100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=162200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=162300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=162400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=163000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=163100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=163200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=163300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=163400;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=164000;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=164100;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=164200;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=164300;
UPDATE item_proto SET vnum_range = '99' WHERE vnum=164400;

Bitirdikten sonra mysql i sql den okutan kişilerde simya sorunu çözülecektir.

Not : Herkes aynı sql sistemini kullanmıyor sizin ClientManagerBoot.cpp içerisindeki kodlar farklı olabilir vnum u kopyalarak yapabilirsiniz sadece yeni değeri vnum_range yapacaksınız.

YAZAR HAKKINDA;
arcface
Admin

Web Developer

KONU YORUMLARI
YORUM YAP
Image

C++ / C# / Python

Simya sistemi SQL'den okutma +basma gibi bugları kapatma

Simya sistemi SQL'den okutma +basma gibi bugları kapatma Simya sistemi SQL'den okutma +basma gibi bugları kapatma Simya sistemi SQL'den okutma +basma gibi bugları kapatma Simya sistemi SQL'den okutma +basma gibi bugları kapatma

EN ÇOK OKUNAN 5 MAKALELER
arcface
Admin Yazdı;

2 ay önce

Yarı insan denilince ne anlıyoruz önce ona bir bakalım. Yarı insan; bi..

arcface
Admin Yazdı;

2 ay önce

Afro2 Web Panel Kodlaması Afro2 Web Panel Kodlaması Afro2 Web Pane..

arcface
Admin Yazdı;

2 ay önce

Rubinum2 Web Panel Rubinum2 Web Panel Rubinum2 Web PanelRubinum2 Web..

arcface
Admin Yazdı;

2 ay önce

Discord Widget Discord Widget Discord Widget Discord Widget Di..

arcface
Admin Yazdı;

2 ay önce

Aegea2 Site Teması İndir Aegea2 Site Teması İndir Aegea2 Site Teması..