Jump to content

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

Hidden Content

    Give reaction or reply to this topic to see the hidden content.

 

 

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 post
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 post
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 post
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
×
×
  • Create New...