Loading...
 
Skip to main content

Features / Usability


3 small problems

Hello,

I am developing a site for my internship and I need a little help.
I am only 2-3 small problems and the solution may be obvious, but I do not find it.

My first problem is in the use of "dBReport".
I create a link by concatenation and it works. The link is successfully created.
My problem: I want display an image with this link, but we don't see it :/
Here is the code to show you:

Copy to clipboard
{DBREPORT(db=>stageAP)} SQL "SELECT nom, site, CONCAT('\"http://www.lanup.be/images/partenaires/big/',image,'\"') AS logo, description FROM partenaires" GROUP [nom] "[nom]":h1 TABLE HEADER :even{cursor:pointer;} :odd{cursor:pointer;} CELL :{text-align:left;background-color:white;color:black;} "Site officiel" :i HEADER CELL :{text-align:left;background-color:white;color:black;} "{IMG(src="[logo]")}{IMG}" HEADER CELL :{text-align:left;background-color:white;color:black;} "Description : " "[description]" {DBREPORT}

The question, can we display images with "dBReport? You can see the page hereQuestion


Second problem is an SQL query (I start in SQL queries 😛). I must make a "COUNT" on a field. I must say by event, how many people are registered.
I have 2 tables, "JoueursInscrit" and "Evenements". In "JoueurInscrit" I have a foreign key that points to "Evenements".
Currently, here's my query:

Copy to clipboard
SQL "SELECT DISTINCT joueurInscrit.nomJoueur, joueurInscrit.evenements_id, evenements.id, evenements.nom, evenements.nbrJoueurMax, evenements.lieu FROM joueurInscrit, evenements WHERE joueurInscrit.evenements_id=evenements.id" GROUP [evenements_id] "[nom]":h1

The display of these informations is correct, it only remains for me the "COUNT " where I stuck.
If someone is good in SQL, can he help me with this? ^^
You can see my result hereQuestion.


Latest problem, I would like that the homepage is the page of items.
I go to general administration, I choose as my home page "Articles".
I save my preferences. But the homepage still is a Wiki page ...
Is this a known bug or did I make a mistake somewhere?

Thank you in advance for those who read this message and try to help me:)
Have a nice day

hardy021 wrote:

Hello,


Second problem is an SQL query (I start in SQL queries 😛). I must make a "COUNT" on a field. I must say by event, how many people are registered.
I have 2 tables, "JoueursInscrit" and "Evenements". In "JoueurInscrit" I have a foreign key that points to "Evenements".
Currently, here's my query:

Copy to clipboard
SQL "SELECT DISTINCT joueurInscrit.nomJoueur, joueurInscrit.evenements_id, evenements.id, evenements.nom, evenements.nbrJoueurMax, evenements.lieu FROM joueurInscrit, evenements WHERE joueurInscrit.evenements_id=evenements.id" GROUP [evenements_id] "[nom]":h1

The display of these informations is correct, it only remains for me the "COUNT " where I stuck.
If someone is good in SQL, can he help me with this? ^^
You can see my result hereQuestion.


I'll skip right to your second problem: Here is a link to the MySQL Reference ManualQuestion and the COUNT() functionQuestion.

hardy021 wrote:

Latest problem, I would like that the homepage is the page of items.
I go to general administration, I choose as my home page "Articles".
I save my preferences. But the homepage still is a Wiki page ...
Is this a known bug or did I make a mistake somewhere?

When I look at your site it's just a site, a homepage. No editing possible.
If your ordinary registered users can edit when logged in - and they are not supposed to - then create a group of editors with permission to edit pages and a group of ordinary users without permission to edit.

You should have an account in each group yourself to check how the site looks, when a person in that group logs in. Also take a look when not logged in, to see the site as an anonymous user.

I hope this helps and that someone can help you with the first problem.
Good luck.

./mich


Hi,

thanks to help me 😊

For my second problem, it's not important for me now, i can try to resolve it an other day 😛

For my last problem, i don't think you understand what i mean.

I want that the home page is my page of articles, so this pageQuestion.

But, i don't find the way to do that :/
In the "tiki-admin.php?page=general" or in the general administration, in the navigation's tab, we can choose under the home page option :

"Use a different page for the home page"

And we can choose a functionality like wiki or article

But, after that i chose "article" and saved my preferences, the home page still a page called "HomePage" of the wiki functionality :/

If i don't find the solution, i'll keep my current solution :
==> if it's an anonymous, he sees a page inviting him to register, and if the person il logged in, he sees an other page with a little description of the website

but thanks a lot trying to help me 😉

Thony aka Hardy


hardy021 wrote:

In the "tiki-admin.php?page=general" or in the general administration, in the navigation's tab, we can choose under the home page option :

"Use a different page for the home page"

And we can choose a functionality like wiki or article

But, after that i chose "article" and saved my preferences, the home page still a page called "HomePage" of the wiki functionality :/

Yes, it seems there are several options to select a different page but I haven't used them, so I don't know how they work.

I have a site for a limited group, where the homepage (index page, start page, whatever you call it) is a wiki-page. To anonymous users it is read only, you have to log in to see the other pages.
It is called HomePage too, though, and I would like to change that, and I'll figure out some day how to do it, I think 😎. If I do, I'll let you know 😊.

./mich