Sphere-wiki^sw

on=@kill //sadece playerları öldürmesi gerektiğini sorgulatmak size kalıyor
//if (<argo.isplayer>) // player sorgusunuda ekledim isteyen aktifedebilir.
toplist
//endif

[defname topplayer]
topplayer 30 //değiştirilebilir topplayer değeri
database dat_example
table_1 dat_example_2
table_2 dat_example_3

[function toplist]
tag0.puan_action +=1
if <db.row.numrows>
db.execute "update <def.database> set point = '<def.table,_1>' where uid='<uid>'"
else
db.execute "insert into `<def.database>` (`<def.table,_1>` ,`<def.table_2>`) values  ('<uid>', '<dtag0.puan_action>');"
endif

[function tabloyap]
if !(<DB.CONNECTED>)
db.connect
endif
db.execute "create table if not exists <def.database> (<def.table,_1> text, <def.table_2> int);"
db.close

[function f_toplist]
if !(<DB.CONNECTED>)
db.connect
endif
db.query "select * from <def.database> order by <def.table_2> desc";
for order 0 <eval <db.row.numrows> - 1>
sysmessage @1153,,1 <uid.<db.row.<dlocal.order>.<def.table_1>>.name> isimli oyuncu <db.row.<dlocal.order>.<def.table_2>> puana sahip. // dialog olarak yapmak size kalmı$.
endfor