maybe there is a problem with date format definition.
do you have the same results if you are switching your XOOPS to english?
'repo_user' is equal to my variable $dirName
'repo_status' should be 2 or should be 3
'repo_prerelease' should be 1 or 'repo_release' should be 1
('repo_user' = $dirName) AND ('repo_status' = 2 OR 'repo_status' = 3) AND ('repo_prerelease' = 1 OR 'repo_release' = 1)
$crRepositories = new CriteriaCompo();
$crRepositories->add(new Criteria('repo_user', $dirName));
$crRepositories->add(new Criteria('repo_status', 2));
$crRepositories->add(new Criteria('repo_status', 3), 'OR');
$crRepositories->add(new Criteria('repo_prerelease', 1) );
$crRepositories->add(new Criteria('repo_release', 1), 'OR');
$repositoriesAll = $repositoriesHandler->getAll($crRepositories);
SELECT * FROM `wggithub_repositories` WHERE (`repo_user` = 'XoopsModulesArchive' AND `repo_status` = '2' OR `repo_status` = '3' AND `repo_prerelease` = '1' OR `repo_release` = '1')
//first block/parentheses
$crRepo1 = new CriteriaCompo();
$crRepo1->add(new Criteria('repo_user', $dirName));
//second
$crRepo2 = new CriteriaCompo();
$crRepo2->add(new Criteria('repo_status', Constants::STATUS_UPDATED));
$crRepo2->add(new Criteria('repo_status', Constants::STATUS_UPTODATE), 'OR');
//third
$crRepo3 = new CriteriaCompo();
$crRepo3->add(new Criteria('repo_prerelease', 1) );
$crRepo3->add(new Criteria('repo_release', 1), 'OR');
//final combination
$crRepoFinal = new CriteriaCompo();
$crRepoFinal->add($crRepo1);
$crRepoFinal->add($crRepo2);
$crRepoFinal->add($crRepo3);
//get data
$repositoriesAll = $repositoriesHandler->getAll($crRepoFinal);
unset($crRepo1, $crRepo2, $crRepo3, $crRepoFinal);
SELECT C* FROM `wggithub_repositories` WHERE ((`repo_user` = 'XoopsModules25x') AND (`repo_status` = '2' OR `repo_status` = '3') AND (`repo_prerelease` = '1' OR `repo_release` = '1'))