iriyoka

i have some problem, but it's resolve because structure in sample is #Body: it must be like this Header: Type: ITEM_DB Version: 1 Body:

you can use code like this FRank: query_sql("SELECT name, `flvl`, `fexp`, `fpts`, `fcot` FROM `fishing_system` ORDER BY flvl DESC LIMIT 5",.@n$,.@fl,.@fe,.@fp,.@fc); mes "Hall Of Fame: Fishing Ladder"; mes "^ff0000Name^000000:^ff5500[ FL ]^000000:^005500[ FE ]^000000:^55007f[ FP ]^000000:^55ffff[ FC ]^000000"; //cutin $@FishingLadderRank$,3; mes "1. ["+.@n$[0]+"] ("+.@fl[0]+") ("+.@fe[0]+") ("+.@fp[0]+") ("+.@fc[0]+")"; mes "2. ["+.@n$[1]+"] ("+.@fl[1]+") ("+.@fe[1]+") ("+.@fp[1]+") ("+.@fc[1]+")"; mes "3. ["+.@n$[2]+"] ("+.@fl[2]+") ("+.@fe[2]+") ("+.@fp[2]+") ("+.@fc[2]+")"; mes "4. ["+.@n$[2]+"] ("+.@fl[3]+") ("+.@fe[3]+") ("+.@fp[3]+") ("+.@fc[3]+")"; mes "5. ["+.@n$[2]+"] ("+.@fl[3]+") ("+.@fe[3]+") ("+.@fp[3]+") ("+.@fc[3]+")"; next; menu "^005500[ Return ]^000000",mainmenu; close; FExpe: query_sql("SELECT `name`, `fsuc`, `ffail`, `fenc`, `fmom` FROM `fishing_system` ORDER BY fsuc DESC LIMIT 5",.@n1$,.@fs,.@ff,.@fn,.@fm); mes "Hall Of Fame: Fishing Ladder"; if($@FishingMode == 0 ) { mes "^ff0000Name^000000:^005500[ FS ]^000000:^55aa00[ FF ]^000000:^ff5500[ FN ]^000000:^55ffff[ FM ]^000000"; } if($@FishingMode == 1 ) { mes "^ff0000Name^000000:^005500[ FS ]^000000:^55aa00[ FF ]^000000:^ff5500"; } if($@FishingMode == 0 ) { mes "1. ["+.@n1$[0]+"] ("+.@fs[0]+") ("+.@ff[0]+") ("+.@fn[0]+") ("+.@fm[0]+")"; mes "2. ["+.@n1$[1]+"] ("+.@fs[1]+") ("+.@ff[1]+") ("+.@fn[1]+") ("+.@fm[1]+")"; mes "3. ["+.@n1$[2]+"] ("+.@fs[2]+") ("+.@ff[2]+") ("+.@fn[2]+") ("+.@fm[2]+")"; mes "4. ["+.@n1$[3]+"] ("+.@fs[3]+") ("+.@ff[3]+") ("+.@fn[3]+") ("+.@fm[3]+")"; mes "5. ["+.@n1$[4]+"] ("+.@fs[4]+") ("+.@ff[4]+") ("+.@fn[4]+") ("+.@fm[4]+")"; } if($@FishingMode == 1 ) { mes "1. ["+.@n1$[0]+"] ("+.@fs[0]+") ("+.@ff[0]+")"; mes "2. ["+.@n1$[1]+"] ("+.@fs[1]+") ("+.@ff[1]+")"; mes "3. ["+.@n1$[2]+"] ("+.@fs[2]+") ("+.@ff[2]+")"; mes "4. ["+.@n1$[3]+"] ("+.@fs[3]+") ("+.@ff[3]+")"; mes "5. ["+.@n1$[4]+"] ("+.@fs[4]+") ("+.@ff[4]+")"; } //cutin $@FishingLadderExpe$,3; next; menu "^005500[ Return ]^000000",mainmenu; close; OnInit: waitingroom "Fishing Ladder Board",0; end;