Alliance Tag & Alliance Name Search does not work

[BassXX]

Hello guys, just want to inform you, that the Alliance Tag and Name is not working for me. Player and Planet Search is working fine for me.

Hope we can fix that soon! Thank you guys!

[BassXX]

Hey, I have changed the coden (2 line insertions, 1 line removal) in ShowAlliancePage.class.php, but unfortunately the search is still giving me no results :(

[lilmnm-kamikaze-]

Is there any kind of error that's being displayed or does it just not do anything?

Date: Tue, 15 Mar 2016 03:58:54 -0700
From: [email protected]
To: [email protected]
Subject: Re: [2Moons] Alliance Tag & Alliance Name Search does not work (#154)

Hey, I have changed the coden (2 line insertions, 1 line removal) in ShowAlliancePage.class.php, but unfortunately the search is still giving me no results :(

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
#154 (comment)

[BassXX]

Hey there,

No error at all, it just displays no results, although allies are existing

[Jbaukens]

can you try updated the file

[BassXX]

Greetings Hilarious001,

I just modified the file, but still get an empty result when performing the search.

Thank you guys for trying to help me out. Hopefully we can fix this

[Jbaukens]

its working for me so i probably changed somethin else on the alliance page i will look when i am home so i can give you all modification or add me skype xterium.support

[BassXX]

i have added you to skype already, but there was no reply yet. Pls take a look at your skype :)

[BassXX]

Or maybe you could just upload the complete .php file, so I could make the search work

[lilmnm-kamikaze-]

HE did. that's whats in the pull request. what is the link to your version of the game? maybe he can look from there

[BassXX]

Okay here it is: http://ddclan.mrtv.biz/game
Thanks for helping me guys

[BassXX]

By the way: If I search for allies not from search page, but from the allies page, i receive the following SQL error:

Message: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Query-Code:SELECT id, ally_name, ally_tag, ally_members FROM uni1_alliance WHERE ally_universe = 1 AND ally_name LIKE %Admin Team% ORDER BY ( IF(ally_name = %Admin Team%t, 1, 0) + IF(ally_name LIKE %Admin Team%, 1, 0) ) DESC,ally_name ASC LIMIT 25;
File: /includes/classes/Database.class.php
Line: 109
URL: http://ddclan.mrtv.biz/game/game.php?page=alliance&mode=search
PHP-Version: 5.5.9-1ubuntu4.14
PHP-API: fpm-fcgi
MySQL-Cleint-Version: mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
2Moons Version: 1.8.git
Debug Backtrace:
#0 /includes/classes/Database.class.php(176): Database->_query('SELECT id, ally...', Array, 'select')
#1 /includes/pages/game/ShowAlliancePage.class.php(252): Database->select('SELECT id, ally...', Array)
#2 /game.php(57): ShowAlliancePage->search()
#3 {main}

[lilmnm-kamikaze-]

shouldnt this also look to see if the search text is like the Alliance tag instead of trying to search for the alliance name twice?

[BassXX]

I receive the same error if I search for the Alliance Tag

[lilmnm-kamikaze-]

that error shows its only looking for the name not the alliance tag

[BassXX]

Sorry, I don´t understand properly. What do you exactly recommend me to do?