Jump to content

Correção de linha


Anderson Fabris
 Share

Recommended Posts

Buenas Comunidade, Novamente.

Gostaria de pedir a ajuda de vocês nesse código, ele está quebrado, alguém conseguiria me auxiliar na forma correta que ela deve ser escrita?

Segue o Código:

 

Spoiler

	// Sistema especial de ranking da batalha campal
	std::auto_ptr<SQLMsg> pFindSQL(DBManager::instance().DirectQuery(
		"SELECT memberName, memberEmpire, memberPoints, "
		"FIND_IN_SET (memberPoints, (SELECT GROUP_CONCAT(memberPoints ORDER BY memberPoints DESC) "
			"FROM (%s) AS rank "
		"FROM %s WHERE memberName = '%s'", szQuery, szQuery, ch->GetName()
	));

 

 

Também estou com o seguinte problema referente a guerra:

Spoiler

SYSERR: Jun 29 08:34:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

 

Edited by Anderson Fabris
Link to comment
Share on other sites

3 horas atrás, PsyRullez disse:

Posta ai o core do ch1 sff

Spoiler

SYSERR: Jun 29 08:34:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank FROM player.combat_zone_ranking_weekly WHERE memberName = 'RelampagoNeg'' at line 1
query: SELECT memberName, memberEmpire, memberPoints, FIND_IN_SET (memberPoints, (SELECT GROUP_CONCAT(memberPoints ORDER BY memberPoints DESC) FROM (player.combat_zone_ranking_weekly) AS rank FROM player.combat_zone_ranking_weekly WHERE memberName = 'RelampagoNeg'

 

7 minutos atrás, tierrilopes disse:

Coloca o objectivo e estrutura da tabela sff

Assim como o valor que queres receber em return

Por favor, tem como você ser mais detalhado?

Link to comment
Share on other sites

57 minutos atrás, Anderson Fabris disse:
  Ocultar conteúdo

SYSERR: Jun 29 08:34:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank FROM player.combat_zone_ranking_weekly WHERE memberName = 'RelampagoNeg'' at line 1
query: SELECT memberName, memberEmpire, memberPoints, FIND_IN_SET (memberPoints, (SELECT GROUP_CONCAT(memberPoints ORDER BY memberPoints DESC) FROM (player.combat_zone_ranking_weekly) AS rank FROM player.combat_zone_ranking_weekly WHERE memberName = 'RelampagoNeg'

 

Por favor, tem como você ser mais detalhado?

se eu não estiver errado, ele quer as colunas que a tabela tem, e que tipo de valores tem cada coluna, também o objetivo desta querry

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...