Merhaba beyler bu scp olayında sorun yaşıyorumda yardım edebilecek varsa çok sevinirim sorunum şu şekilde ;
Db ye oluşturduğu tabloda index hatası veriyor Primay diye bişi adam kesince puan gelmiyor birde top10 listesinde bu yüzden isimler
çıkmıyor.
Yardımlarınızın için şimdiden teşekkür ederim.
[events e_geberik]
on=@death
if (<act.isevent.e_geberik>)
if !strmatch('<act.tag0.sonkesilen>','<uid>')
if (<fame> > 3000)
if !(<src.account.lastip> == <act.account.lastip>)
act.tag.kacpuanulen 1
tag.kacpuanulen 1
puanimialit
act.puanimiverit
act.puanimiveramk
puanimidusuramk
act.tag0.sonkesilen <argo.uid>
endif
endif
endif
endif
[function puanimiveramk]
db.connect
db.execute "update istatistik_sys set username='<addslashes <name>>' where uid='<addslashes <uid>>'
db.query select * from istatistik_sys where uid='<addslashes <uid>>'
tag.eklebebegim (1+<eval <db.row.2>>)
db.execute "update istatistik_sys set oldurme='<eval <tag.eklebebegim>>' where uid='<addslashes <uid>>'
db.execute "update istatistik_sys set killsayisi='<kills>' where uid='<addslashes <uid>>'
[function puanimiverit]
db.connect
db.execute "update istatistik_sys set username='<addslashes <name>>' where uid='<addslashes <uid>>'
db.query select * from istatistik_sys where uid='<addslashes <uid>>'
tag.ekleteyze (<eval <tag0.kacpuanulen>>+<eval <db.row.5>>)
db.execute "update istatistik_sys set puan='<eval <tag.ekleteyze>>' where uid='<addslashes <uid>>'
db.execute "update istatistik_sys set killsayisi='<kills>' where uid='<addslashes <uid>>'
sysmessage @38,,1 <eval <tag0.kacpuanulen>> puan aldiniz...
[function puanimialit]
db.connect
db.execute "update istatistik_sys set username='<addslashes <name>>' where uid='<addslashes <uid>>'
db.query select * from istatistik_sys where uid='<addslashes <uid>>'
if !(<eval <db.row.5>> < 1)
tag.ekleteyze (<eval <db.row.5>>-<eval <tag0.kacpuanulen>>)
db.execute "update istatistik_sys set puan='<eval <tag.ekleteyze>>' where uid='<addslashes <uid>>'
db.execute "update istatistik_sys set killsayisi='<kills>' where uid='<addslashes <uid>>'
sysmessage @38,,1 <eval <tag0.kacpuanulen>> puan kaybettiniz...
endif
[function puanimidusuramk]
db.connect
db.execute "update istatistik_sys set username='<addslashes <name>>' where uid='<addslashes <uid>>'
db.query select * from istatistik_sys where uid='<addslashes <uid>>'
tag.eklebebegim (<eval <db.row.1>>+1)
db.execute "update istatistik_sys set olme='<eval <tag.eklebebegim>>' where uid='<addslashes <uid>>'
db.execute "update istatistik_sys set killsayisi='<kills>' where uid='<addslashes <uid>>'
[function bengeldimamk]
if (<eval <tag.sikerler>> == 1)
return 1
else
if (<guild> = 0)
db.connect
DB.EXECUTE "INSERT INTO istatistik_sys (isim, olme, oldurme, killsayisi,username,puan,uid,guild) VALUES('<addslashes <name>>','0','0','<kills>','<addslashes <name>>','0','<uid>','Yok')"
tag.sikerler 1
events +e_geberik
else
DB.EXECUTE "INSERT INTO istatistik_sys (isim, olme, oldurme, killsayisi,username,puan,uid,guild) VALUES('<addslashes <name>>','0','0','<kills>','<addslashes <name>>','0','<uid>','<addslashes <memoryfindtype.memory_guild.link.name>>')"
tag.sikerler 1
events +e_geberik
endif
endif
[function playersorgula]
allplayerchars f_playersorgula
[function pinyoket]
allplayerchars f_pinyoket
[function f_pinyoket]
account.tag.pin 0
[function f_playersorgula]
if (<eval <tag.sikerler>> == 1)
if (<guild> = 0)
db.connect
DB.EXECUTE "INSERT INTO istatistik_sys (isim, olme, oldurme, killsayisi,username,puan,uid,guild) VALUES('<addslashes <name>>','0','0','<kills>','<addslashes <name>>','0','<uid>','Yok')"
tag.sikerler 1
tag.ekleteyze
events +e_geberik
else
DB.EXECUTE "INSERT INTO istatistik_sys (isim, olme, oldurme, killsayisi,username,puan,uid,guild) VALUES('<addslashes <name>>','0','0','<kills>','<addslashes <name>>','0','<uid>','<addslashes <memoryfindtype.memory_guild.link.name>>')"
tag.sikerler 1
tag.ekleteyze
events +e_geberik
endif
endif
[function deneolum]
allplayerchars f_deneolum
[function f_deneolum]
if <isplayer>
fame 3000
endif
[function siksok]
db.connect
db.query select * from istatistik_sys where uid='<uid>'
if (<finduid.(<db.row.6>).isonline>)
sysmessage @07a1 oldu lan ipne
else
sysmessage @07a1 olmadi lan ipne
endif
//-------------------------------------------------\\
[function yenikralsecimi]
top15kaldir
top15ekle
playersorgula
[function top15kaldir]
db.connect
db.execute "drop table if exists istatistik_sys"
[function top15ekle]
db.connect
db.execute "create table istatistik_sys(isim varchar(100), olme int(100), oldurme int(100), killsayisi int(100), username varchar(100), puan int(100), uid varchar(100), guild varchar(100))"
[EOF]