string, sql
Posted: 2011 Nov 12 17:01
Code: Select all
new Operator, OperatorName public select_operator(id){ new opcion[50] formatex(opcion, charsmax(opcion), "%L", id, "OPERATORS_MENU") new menu = menu_create(opcion, "operator_handler") if(g_SqlTuple == Empty_Handle){ log_amx(g_Error) } new ErrorCode, Handle:SqlConnection=SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511), Handle:Query Query = SQL_PrepareQuery(SqlConnection, "SELECT * FROM `vvp_operators`") if(!SQL_Execute(Query)) { SQL_QueryError(Query,g_Error,511) log_amx(g_Error) return PLUGIN_HANDLED } for(new i; i < SQL_NumRows(Query); i++) { Operator = SQL_FieldNameToNum(Query, "operator_name") OperatorName = SQL_ReadResult(Query, Operator) menu_additem(menu, OperatorName, i) // cia meta klaida } SQL_FreeHandle(Query) SQL_FreeHandle(SqlConnection) return PLUGIN_HANDLED}