1111
goffy
Re: All about M.A.S.K. runs XOOPS 2.5.11.
  • 2020/12/28 8:59

  • goffy

  • Just can't stay away

  • Posts: 542

  • Since: 2010/12/27


yes, congratultaions, looks great



1112
heyula
Re: All about M.A.S.K. runs XOOPS 2.5.11.
  • 2020/12/27 20:30

  • heyula

  • Theme Designer

  • Posts: 595

  • Since: 2008/4/24


congratulations, a nice xoops example



1113
AxelF
All about M.A.S.K. runs XOOPS 2.5.11.
  • 2020/12/27 17:41

  • AxelF

  • Theme Designer

  • Posts: 238

  • Since: 2004/7/12


Hi XOOPSers,

today I want to show you my websitre All about M.A.S.K. . But before I do so, I need to thank goffy for his support at myxoops.org. Without him, the site wasn´t possible.

What I use atAll about M.A.S.K. :

XOOPS: XOOPS 2.5.11 Beta 1
Theme: Goffys wgskiclub theme and modifyed it for my site
Modules: - Most parts of the site is using the myalbum-p module, back from the early days of xoops. With help of goffy the module is now running under the lastest XOOPS version. It is used in 6 installations, all with unique names.
- adslight
- contact-
- mylinks
- publisher
- waiting content
- wflinks
- wggallery
- xlanguage
- xoopstube (modified)
- xsitemap

I also included a lot of features, not included in XOOPS, to the site.

Like Flipbooks or 360° views

Resized Image


Resized Image


Enjoy the site, any feedback is welcome

XOOPS IS STILL ALIVE



1114
AxelF
Re: xoRewriteModule - Simplified, Short URLs?
  • 2020/12/27 9:04

  • AxelF

  • Theme Designer

  • Posts: 238

  • Since: 2004/7/12


Does a coder has the chance to have a look to the xlanguage module? I really need that fearure.

Thank you!



1115
Mamba
Re: Combine AND/OR in a CriteriaCompo
  • 2020/12/25 20:09

  • Mamba

  • Moderator

  • Posts: 11391

  • Since: 2004/4/23


Thank you for sharing!!!
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



1116
goffy
Combine AND/OR in a CriteriaCompo
  • 2020/12/25 15:01

  • goffy

  • Just can't stay away

  • Posts: 542

  • Since: 2010/12/27


Sometime maybe you have the problem to combine AND and OR in a CriteriaCompo, but for this you should know how to to this.

Explanation of problem:
I want to filter my data from table 'Repositories' by following params:

'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


From perspective of the query it must be solve like this:
('repo_user' $dirName) AND ('repo_status' OR 'repo_status' 3) AND ('repo_prerelease' OR 'repo_release' 1)


If you are using CriteriaCompo and combine all criterias in this way:

$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);


then XOOPS creates following query:
SELECT FROM `wggithub_repositoriesWHERE (`repo_user` = 'XoopsModulesArchive' AND `repo_status` = '2' OR `repo_status` = '3' AND `repo_prerelease` = '1' OR `repo_release` = '1')


but as the parentheses are missing this query will not give the result you want.

Therefore the question is, how can we force XOOPS to add the necessary parentheses?

The solution is to create a separate CriteriaCompo for each block and combine them in a new CriteriaCompo
//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);


Now XOOPS creates following query:
SELECT CFROM `wggithub_repositoriesWHERE ((`repo_user` = 'XoopsModules25x') AND (`repo_status` = '2' OR `repo_status` = '3') AND (`repo_prerelease` = '1' OR `repo_release` = '1'))


and now we get expected results :)

If someone have another solution you are welcome to share :)



1117
Mamba
Re: Merry Christmas
  • 2020/12/24 11:55

  • Mamba

  • Moderator

  • Posts: 11391

  • Since: 2004/4/23


Same to you and to the whole XOOPS Community!!!

And Happy New Year to everybody!!!
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



1118
Mamba
Re: wgGithub on myXoops
  • 2020/12/24 11:53

  • Mamba

  • Moderator

  • Posts: 11391

  • Since: 2004/4/23


Great job!

Thank you for sharing it with us!
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs



1119
goffy
Merry Christmas
  • 2020/12/24 8:01

  • goffy

  • Just can't stay away

  • Posts: 542

  • Since: 2010/12/27


I wish you Merry Christmas and a Happy New Year



1120
goffy
wgGithub on myXoops
  • 2020/12/23 21:04

  • goffy

  • Just can't stay away

  • Posts: 542

  • Since: 2010/12/27


Hi

wggithub is now online on myXoops

On the various tabs you can see the XOOPS-repositories on GitHub.
Besides basic information like date of creation or update you can see the content of readme file (if available).
Additional you can find also a button to download last releases.
Have fun with exploring the world of XOOPS.

If you find bugs or if you have ideas for improvements you can post here
Goffy




TopTop
« 1 ... 109 110 111 (112) 113 114 115 ... 29430 »



Login

Who's Online

397 user(s) are online (113 user(s) are browsing Support Forums)


Members: 0


Guests: 397


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits