Frend Williams
Умник
Доброй ночи. Возникли ошибки с базой данных, а именно с запросами. Буду рад любой помощи.
Ошибки
Код из мода:
И из другой:
Ошибки
Код:
che_get_field_content_int - invalid datatype
[11:11:24 08/24/21] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name`='N_N'")
[11:11:24 08/24/21] [ERROR] cache_get_field_content_int - invalid datatype
[11:37:30 08/24/21] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name`='N_N'")
[11:37:30 08/24/21] [ERROR] cache_get_field_content_int - invalid datatype
[12:45:16 08/24/21] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name`='N_N'")
[12:45:16 08/24/21] [ERROR] cache_get_field_content_int - invalid datatype
[13:19:52 08/24/21] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name` = 'N_N' AND `u_a_password` = '0000000' LIMIT 1")
[13:19:52 08/24/21] [ERROR] cache_get_field_content_int - invalid datatype
[13:58:10 08/24/21] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name` = 'N_N' AND `u_a_password` = '000000' LIMIT 1")
Код:
mysql_format ( sql_connection, text_string, sizeof ( text_string ), "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name` = '%s' AND `u_a_password` = '%e' LIMIT 1", p_info [ playerid ] [ name ], inputtext ) ;
mysql_tquery ( sql_connection, text_string, "alogin_step_two", "i", playerid ) ;
Код:
new query_str [ 128 ] ;
format ( query_str, sizeof ( query_str ), "SELECT `u_a_level` FROM `users_admins` WHERE `u_a_name`='%s'", p_info [ targetid ] [ name ] ) ;
new Cache:result = mysql_query ( sql_connection, query_str ) ;
new admin_level = cache_get_field_content_int ( 0, "u_a_level", sql_connection ) ;
cache_delete ( result ) ;
