Okej I gonna do this pretty simple to read it for you guys I have this code and i wonder why this pmtop15 wont work.
PHP Code:
public Show_Top(id) {
new name[32], temp[64]
for(new i; i < MaxPlayers; i++) {
if(is_user_connected(i))
Save_MySql(i)
}
format(SQL_Query, charsmax(SQL_Query), "SELECT id, name, totalpund FROM Pundmod ORDER BY totalpund DESC LIMIT 0,15")
new Handle:Query = SQL_PrepareQuery(SQLite_Connection, SQL_Query)
if(!SQL_Execute(Query)) {
SQL_QueryError(Query, SQL_Error, sizeof(SQL_Query)-1)
server_print("[%s][SQLite] %s", PLUGIN, SQL_Error)
return PLUGIN_HANDLED
}
new menu = menu_create("Tc3 Top 15", "TopMenu")
new sztempid[2]
new rows1 = SQL_NumResults(Query)
new key[6], tcash[15], name1[15][64];
for(new i=0;i<rows1;i++) {
new temp[512];
format(temp, 511, "%s:\r %i", name1[i], tcash[i])
num_to_str(i,key,sizeof(key)-1)
menu_additem(menu, temp, key, 0);
}
menu_display(id, menu)
while(SQL_MoreResults(Query)) {
SQL_ReadResult(Query, 1, name, 31)
formatex(temp, 63, "", SQL_ReadResult(Query, 2))
num_to_str(SQL_ReadResult(Query, 0), sztempid, charsmax(sztempid))
menu_additem(menu, temp, sztempid, 0)
SQL_NextRow(Query)
}
menu_display(id, menu)
SQL_FreeHandle(Query)
return PLUGIN_HANDLED
}
public TopMenu(id, menu, item) {
menu_destroy(menu);
return PLUGIN_HANDLED;
}
Could someone help me to make this work!?.
__________________