hlmod.hu

public query(id)
{
	new name[32]
	get_user_name(id, name, 31)
	new uID = get_user_userid(id)
 
//Create a connection
	new Sql:mysql = dbi_connect("localhost", "dvander", "pass", "dbase")
 
//If the connection is less than 1, it is bad	
	if (mysql < SQL_OK) {
		new err[255]
		new errNum = dbi_error(mysql, err, 254)
		server_print("error1: %s|%d", err, errNum)
		return 1
	}
 
	server_print("Connection handle: %d", mysql)
//Run a query
	//new Result:ret = dbi_query(mysql, "INSERT INTO config (keyname, val) VALUES ('ok', 'ok')")
 
	new Result:ret = dbi_query(mysql, namepass)
	formatex(namepass, "INSERT INTO `config` (`keyname`, `val`) VALUES (^"%s^", ^"%s^");", name)

 
formatex(namepass, "INSERT INTO `config` (`keyname`, `val`) VALUES (^"%s^", ^"%s^");", name)
 

//Run a query
	new Result:ret = dbi_query(mysql, "INSERT INTO config (keyname, val) VALUES ('%s', 'aa')" , name)

 
if(dbi_num_rows(res) > 0)
{
//Van adat
}
else {
 //nincs adat
 }

 
//res = lekérdezés (query)
//resf[]= fetch array
//resfn = num rows