make a new table as stated above by coly and lyncus, ex. tbl_ranksystem
grab your information from tbl_character (fld_character) and set the appropiate rank level that character has achieved.
--------------------------------------------------------------
[@Main]
#ACT
FormatStr "FLD_CHARACTER='%s'" %USERNAME
ReadValueSql "TBL_CHARACTER" %A9 "FLD_CHARACTER" [@GetCharaName]
[@GetCharaName()]
#ACT
MOV A0 %ARG(1) ; stores username in A0 after checking that it is correct in the characters table.
--------------------------------------------------------------
Depending on how you want to do your scores, below is the script for updating that ranksystem table.
[@AddRank]
FormatStr "FLD_CHARACTER='%s'" %A0
UPDATEVALUESQL "TBL_RANKSYSTEM" %A9
---------------------------------------------------------------
depending on what fields you have in that table you could have a fld_rank1, fld)rank2 etc, and set it to either 1 or 0.
or you could have fld_rank and set it from 0-X (X being the maximum rank you want to use) that, all you have to do then is add the check in the quest script to make sure the fld_rank is at the correct level to comtinue the script.
sorry i havent explained things in a while so this might be a little rusty, but it looked you were really trying to learn the scripts. so i thought i'd offer some help, since its been a while since i have
/cheekyvimto