SA-MP Forums Archive
(MySQL_NameExists(inputtext)) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: (MySQL_NameExists(inputtext)) (/showthread.php?tid=529230)


(MySQL_NameExists(inputtext)) - RayC - 01.08.2014

Something weird is going on..
Each time I log onto my server, I can't register anymore, it keeps saying That name is already registered, but I've checked my MySql database and it's literally clear, I've tried many different names but still the same thing, all plugins loaded successfully, there's no errors when I compile, everything fine. It just automatically thinks every person who connects is registered, please help me.

Re: (MySQL_NameExists(inputtext)) - JacobEdwards - 01.08.2014

Well we can't help you without code, can we?

Re: (MySQL_NameExists(inputtext)) - RayC - 01.08.2014

I seriously don't know what part of my script I should actually show you..
but..

Код:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
	new File:file = fopen("mysql_error_log.txt", io_append);
	if (file)
	{
	    new string[512], day, month, year, hour, minute, second;
	    gettime(hour, minute, second);
	    getdate(year, month, day);
	    format(string, sizeof(string), "[%02d/%02d/%02d %02d:%02d:%02d] Query error (errorid: %d, error: %s, callback: %s, connectionHandle: %d)\r\n", day, month, year, hour, minute, second, errorid, error, callback, connectionHandle);
		fwrite(file, string);
		fclose(file);
	}
	return 1;
}

stock MySQL_NameExists(const account[])
{
	new
	    szQuery[128],
		iRows = 0;

	format(szQuery, sizeof(szQuery), "SELECT `Username` FROM `accounts` WHERE `Username` = '%s'", account);
	mysql_query(szQuery);
	mysql_store_result();
	if (mysql_num_rows())
	{
	    iRows = 1;
	}
	else iRows = 0;
	mysql_free_result();
	return iRows;
}

stock MySQL_UpdateFieldInt(const account[], const fieldname[], iValue)
{
	new query[512];
	format(query, sizeof(query), "UPDATE `accounts` SET `%s` = '%d' WHERE `Username` = '%s'", fieldname, iValue, account);
	mysql_query(query);
	return 1;
}

stock MySQL_UpdateFieldFloat(const account[], const fieldname[], Float:iValue)
{
	new query[512];
	format(query, sizeof(query), "UPDATE `accounts` SET `%s` = '%f' WHERE `Username` = '%s'", fieldname, iValue, account);
	mysql_query(query);
	return 1;
}

stock MySQL_UpdateFieldString(const account[], const fieldname[], szValue[])
{
	new query[512];
	format(query, sizeof(query), "UPDATE `accounts` SET `%s` = '%s' WHERE `Username` = '%s'", fieldname, szValue, account);
	mysql_query(query);
	return 1;
}

stock MySQL_GetAccountField(const account[], const fieldname[], destination[])
{
	new query[128];
	format(query, sizeof(query), "SELECT `%s` FROM `accounts` WHERE `Username` = '%s'", fieldname, account);
	mysql_query(query);
	mysql_store_result();
	mysql_retrieve_row();
	mysql_fetch_field_row(destination, fieldname);
	mysql_free_result();
	return 1;
}

stock MySQL_GetAccountInt(const account[], const fieldname[])
{
	new destination[128];
	MySQL_GetAccountField(account, fieldname, destination);
	return strval(destination);
}

stock Float:MySQL_GetAccountFloat(const account[], const fieldname[])
{
	new destination[128];
	MySQL_GetAccountField(account, fieldname, destination);
	return floatstr(destination);
}


Re: (MySQL_NameExists(inputtext)) - kamiliuxliuxliux - 01.08.2014

In MySQL_NameExists() try to get everything (*) and then check for rows.

Re: (MySQL_NameExists(inputtext)) - RayC - 01.08.2014

Quote:
Originally Posted by kamiliuxliuxliux
Посмотреть сообщение
In MySQL_NameExists() try to get everything (*) and then check for rows.
What do you mean by (*) sorry?

Re: (MySQL_NameExists(inputtext)) - kamiliuxliuxliux - 01.08.2014

SELECT * FROM ........ (* means everything)

Re: (MySQL_NameExists(inputtext)) - dirigent00 - 01.08.2014

Код:
format(szQuery, sizeof(szQuery), "SELECT * FROM `accounts` WHERE `Username` = '%s'", account);
He means this.

Re: (MySQL_NameExists(inputtext)) - RayC - 01.08.2014

Dirigent00 and kamiliuxliuxliux thanks for your reply and support but I am still getting the same error, just to show the rest and hopyfully get it up and running again this is the error.

Quote:

error 025: function heading differs from prototype
According to the error, it is on line 3365 which reads the follow:

Quote:

public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
new File:file = fopen("mysql_error_log.txt", io_append);
if (file)
{
new string[512], day, month, year, hour, minute, second;
gettime(hour, minute, second);
getdate(year, month, day);
format(string, sizeof(string), "[%02d/%02d/%02d %02d:%02d:%02d] Query error (errorid: %d, error: %s, callback: %s, connectionHandle: %d)\r\n", day, month, year, hour, minute, second, errorid, error, callback, connectionHandle);
fwrite(file, string);
fclose(file);
}
return 1;
}

stock MySQL_NameExists(const account[])
{
new
szQuery[128],
iRows = 0;

format(szQuery, sizeof(szQuery), "SELECT * FROM `accounts` WHERE `Username` = '%e'", account);
mysql_query(szQuery);
mysql_store_result();
if (mysql_num_rows())
{
iRows = 1;
}
else iRows = 0;
mysql_free_result();
return iRows;
}
This is what I see when I try to login... even if I have no account (Never registered an account). I am using a Linux hosting and it use to work on my localhosting. Picture below shows the ingame error:



Please HELP, I have been trying to figure this out all NIGHT.

Re: (MySQL_NameExists(inputtext)) - Zex Tan - 01.08.2014

EDIT: Nevermind, got the wrong idea of solving it.

Re: (MySQL_NameExists(inputtext)) - kamiliuxliuxliux - 03.08.2014

That error means your callback is different from the prototype (forward and forward is created by default). I'm not sure, but as MySQL R33 says, try using OnQueryError(errorid, error[], callback[], query[], connectionHandle).