topek

Disabled all 3rd part apps and...:

SELECT main.*, ((MATCH(index_title) AGAINST ('opiekunka' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('opiekunka' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `ibpo_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) ) AND MATCH(index_content,index_title) AGAINST ('opiekunka' IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_SET('m1093',index_permissions) OR FIND_IN_SET('ca',index_permissions) OR FIND_IN_SET('cm',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25
IPS\Db\Exception: DOUBLE value is out of range in '(((match `ciya3o_opiekunk`.`main`.`index_title` against ('opiekunka' in boolean mode)) * 5) + (match `ciya3o_opiekunk`.`main`.`index_content`,`ciya3o_opiekunk`.`main`.`index_title` against ('opiekunka' in boolean mode)))' (1690)
#0 //system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 [internal function]: IPS\Db\_Select->rewind()
#2 //system/Content/Search/Mysql/Query.php(1302): iterator_to_array(Object(IPS\Db\Select))
#3 //applications/core/modules/front/search/search.php(729): IPS\Content\Search\Mysql\_Query->search('opiekunka', NULL, 17, 'or')
#4 //applications/core/modules/front/search/search.php(109): IPS\core\modules\front\search\_search->_results()
#5 //system/Dispatcher/Controller.php(101): IPS\core\modules\front\search\_search->manage()
#6 //system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#7 //index.php(13): IPS\_Dispatcher->run()
#8 {main}

SQL support tool:

What next then?

Hello,

could you be more specific what number and how to fix it? It's a default search operation. I have 3rd party apps but the problem is in the main search code so please give me an advice how should I fix it.

Thanks.

Step 1

step 2

step 3

step 4 click on the link. On the last question. Before the quiz ends

step 5 return to this quiz. It is not blocked

3 hours ago, Adriano Faria said:

Card? Renew? I’m really not sure what you mean. 

I’ll reply based in what I understood: you have a 10 questions and you allow people to play more than once. Then player goes to another page. Quiz is finished due to protection. So he chooses to play again and..... OBVIOUSLY he will see same 10 question if he is playing the same quiz. Honestly, what do you expect here? Other questions for same quiz?

If that’s what you tried to describe above, then you can either:

1: allow people to play only once

2: update leaderboard only in first play

There are settings for both.

This is how it is set: allow people to play only once

The player enters the quiz and when the last question clicks, for example, on the logo and exit from this quiz (before finishing). Then he can go back to the same quiz. He already knows all the questions and suggestions for answers. Protection does not work. It works only when it changes the card.

On 3/4/2018 at 2:39 PM, SerialNoob said:

I wish I had noticed that before making a quiz with gift cards rewards  damn cheaters  

Unfortunately, there is an easy way to deceive the game system on time. Only need to on the last question cross in the same card to the main page of the website or the general address of the quizzes, and then return to the quiz, that just left and play in it from the beginning, but you already know the questions and proposed answers. The protection of the quiz works only when the card is changed, unfortunately it does not protect against the above mentioned way.

In my opinion, the beginning of the quiz for the first time should make it impossible to renew it regardless of the circumstances of quiz exits.

4 hours ago, Martin A. said:

Both will be fixed by the release that's due in a short time.

Cool! Thank you. I have 2 suggestions may head all the bosses take them into account; )

1. Search town

2. Ability to remove its designation

Greetings! t .

Hello, I write with the translator. I'm sorry, but I do not know English.

I found 2 errors in the module Members Map and ask for help.

1. link does not work to change the location. After selecting the page reloads, but nothing happens. Link has the form : /?_fromLogin=1#

2. The profile group of guests who do not have access to me Member map see user profiles small homepage.

Please help.

IPS4 4.1.8.1

P.S.
Great module . Should be paid !

Greetings from Poland!
Thomas