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",[email protected]$,[email protected],[email protected],[email protected],[email protected]); mes "Hall Of Fame: Fishing Ladder"; mes "^ff0000Name^000000:^ff5500[ FL ]^000000:^005500[ FE ]^000000:^55007f[ FP ]^000000:^55ffff[ FC ]^000000"; //cutin [email protected]$,3; mes "1. ["[email protected]$[0]+"] ("[email protected][0]+") ("[email protected][0]+") ("[email protected][0]+") ("[email protected][0]+")"; mes "2. ["[email protected]$[1]+"] ("[email protected][1]+") ("[email protected][1]+") ("[email protected][1]+") ("[email protected][1]+")"; mes "3. ["[email protected]$[2]+"] ("[email protected][2]+") ("[email protected][2]+") ("[email protected][2]+") ("[email protected][2]+")"; mes "4. ["[email protected]$[2]+"] ("[email protected][3]+") ("[email protected][3]+") ("[email protected][3]+") ("[email protected][3]+")"; mes "5. ["[email protected]$[2]+"] ("[email protected][3]+") ("[email protected][3]+") ("[email protected][3]+") ("[email protected][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",[email protected]$,[email protected],[email protected],[email protected],[email protected]); mes "Hall Of Fame: Fishing Ladder"; if([email protected] == 0 ) { mes "^ff0000Name^000000:^005500[ FS ]^000000:^55aa00[ FF ]^000000:^ff5500[ FN ]^000000:^55ffff[ FM ]^000000"; } if([email protected] == 1 ) { mes "^ff0000Name^000000:^005500[ FS ]^000000:^55aa00[ FF ]^000000:^ff5500"; } if([email protected] == 0 ) { mes "1. ["[email protected]$[0]+"] ("[email protected][0]+") ("[email protected][0]+") ("[email protected][0]+") ("[email protected][0]+")"; mes "2. ["[email protected]$[1]+"] ("[email protected][1]+") ("[email protected][1]+") ("[email protected][1]+") ("[email protected][1]+")"; mes "3. ["[email protected]$[2]+"] ("[email protected][2]+") ("[email protected][2]+") ("[email protected][2]+") ("[email protected][2]+")"; mes "4. ["[email protected]$[3]+"] ("[email protected][3]+") ("[email protected][3]+") ("[email protected][3]+") ("[email protected][3]+")"; mes "5. ["[email protected]$[4]+"] ("[email protected][4]+") ("[email protected][4]+") ("[email protected][4]+") ("[email protected][4]+")"; } if([email protected] == 1 ) { mes "1. ["[email protected]$[0]+"] ("[email protected][0]+") ("[email protected][0]+")"; mes "2. ["[email protected]$[1]+"] ("[email protected][1]+") ("[email protected][1]+")"; mes "3. ["[email protected]$[2]+"] ("[email protected][2]+") ("[email protected][2]+")"; mes "4. ["[email protected]$[3]+"] ("[email protected][3]+") ("[email protected][3]+")"; mes "5. ["[email protected]$[4]+"] ("[email protected][4]+") ("[email protected][4]+")"; } //cutin [email protected]$,3; next; menu "^005500[ Return ]^000000",mainmenu; close; OnInit: waitingroom "Fishing Ladder Board",0; end;