[MySQL] samp-server closing
#3


Код:
	if(strcmp(cmd,"/registrar", true) == 0)
	{
		new senha[256];
		new tmp[256];
		new query[256];
		tmp = strtok(cmdtext, idx);
		senha = tmp;
		if(!strlen(tmp)) {
			SendClientMessage(playerid, cor_verde,"Uso: /registrar senha");
		}
		else {
			mysql_real_escape_string(senha, senha);
			format(query, 256,"SELECT * FROM jogadores WHERE nome = '%s'",PlayerName(playerid));
			mysql_query(query);
			new rows = mysql_num_rows();
			if(rows == 0) {
			  jogador[logado][playerid] = 1;
				format(query, 256, "INSERT INTO 'jogadores' ('id', 'nome', 'senha', 'dinheiro', 'dinheiro_banco', 'level', 'profissao') VALUES(null, '%s', '%s', '%d', '%d', '%d', '%d')", PlayerName(playerid), senha, 0, 4000, 0, 0);
				new qquery = mysql_query(query);
				if(qquery) {
					SendClientMessage(playerid, cor_azul,"Vocк acaba de ser registrado e logado");
					printf("Ok no registro");
				}
				else printf("Erro no registro");
			} else SendClientMessage(playerid, cor_azul, "Vocк ja esta registrado");
		}
		return 1;
	}
I made the changes you showed me, but still closing ...
MySQL Server Logs:
Код:
[08:56:08] 
[08:56:08] ---------------------------
[08:56:08] MySQL Debugging activated (11/01/09)
[08:56:08] ---------------------------
[08:56:08] 
[08:56:08] mysql_connect("localhost","root","fuzrpg","******");
[08:56:08] MySQL connection has been established
[08:56:42] mysql_real_escape_string(diogo); Escaped 5 characters
[08:56:42] mysql_query("SELECT * FROM jogadores WHERE nome = 'dioguitos_br'"); Return: 1
Reply


Messages In This Thread
[MySQL] samp-server closing - by bskillerbr - 01.11.2009, 09:07
Re: [MySQL] samp-server closing - by Sergei - 01.11.2009, 09:15
Re: [MySQL] samp-server closing - by bskillerbr - 01.11.2009, 09:59
Re: [MySQL] samp-server closing - by Sergei - 01.11.2009, 10:58

Forum Jump:


Users browsing this thread: 2 Guest(s)