:: ClanSphere :: Free OpenSource Clan CMS :: - Forum - [Php

Antworten: 14

Seite [1]

Tybo

Wannabe poster

Beiträge: 21

# Thema - 21.11.2007 um 17:47 Uhr

Hi,

On my site, I want to have the first banner (order=1) in a separate box (from the other banners).
To show all the other banners, I change the code in mod/banners/navlist.php like this :

1.	1. / 2. / ... $cs_banners = cs_sql_select(__FILE__,'banners',$cells,$where,'banners_order ASC',1,10);

but I don't know what I have to change to show only the first one...

Any Idea?

Tybo

------------------

Zuletzt editiert von Tybo am 22.11.2007 um 22:09 Uhr (1x Editiert)

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 1 - 21.11.2007 um 18:22 Uhr

1.	1. / 2. / ... $cs_banners = cs_sql_select(__FILE__,'banners',$cells,$where,'banners_order ASC',0,1);

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Antoine de Saint-Exupéry: Wenn Du ein Schiff bauen willst, so trommle nicht Männer zusammen, um Holz zu beschaffen, Aufgaben zu verteilen, sondern lehre die Männer die Sehnsucht nach dem endlosen weiten Meer.

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 2 - 21.11.2007 um 18:41 Uhr

This is not working... it show some characters like this :

h
M
t
2

(and my code doesn't seem to work)

------------------

Zuletzt editiert von Tybo am 21.11.2007 um 19:29 Uhr (2x Editiert)

Inaktiv

duRiel

Weltmeister

Herkunft: Cambridge
Beiträge: 7300

# Antwort: 3 - 21.11.2007 um 21:23 Uhr

hi!
can you send us your php sourcecode?

that would help..

duRiel

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 4 - 21.11.2007 um 21:32 Uhr

Sure!

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.

1. / 2. / ...

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: navlist.php 343 2006-09-21 22:22:08Z hajo $

$cat_id = empty($_GET['cat_id']) ? 0 : (int) $_GET['cat_id'];

$where = empty($cat_id) ? 0 : "categories_id = '" . $cat_id . "'";

$cells = 'banners_picture, banners_alt, banners_url, categories_id';
$cs_banners = cs_sql_select(__FILE__,'banners',$cells,$where,'banners_order ASC',0,1);

if(empty($cs_banners)) {
    echo '----';
}
else {
    foreach ($cs_banners AS $banner) {
        $go = cs_secure($banner['banners_picture']);
      $picture = cs_html_img($go,0,0," style=\"margin-bottom:1px\"",cs_secure($banner['banners_alt']));
        echo cs_html_link('http://' . cs_secure($banner['banners_url']),$picture) . cs_html_br(1);
    }
}

?>

------------------

Inaktiv

duRiel

Weltmeister

Herkunft: Cambridge
Beiträge: 7300

# Antwort: 5 - 21.11.2007 um 21:39 Uhr

foreach () { .. } is a loop.
because you are selecting only one row, a loop doesnt make sense and is wrong. so try it with this:

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.

1. / 2. / ...

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: navlist.php 343 2006-09-21 22:22:08Z hajo $

$cat_id = empty($_GET['cat_id']) ? 0 : (int) $_GET['cat_id'];

$where = empty($cat_id) ? 0 : "categories_id = '" . $cat_id . "'";

$cells = 'banners_picture, banners_alt, banners_url, categories_id';
$banner = cs_sql_select(__FILE__,'banners',$cells,$where,'banners_order ASC',0,1);

if(empty($banner)) {
    echo '----';
}
else {
    $go = cs_secure($banner['banners_picture']);
    $picture = cs_html_img($go,0,0," style=\"margin-bottom:1px\"",cs_secure($banner['banners_alt']));
    echo cs_html_link('http://' . cs_secure($banner['banners_url']),$picture) . cs_html_br(1);
}

?>

greetings

duRiel

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 6 - 21.11.2007 um 21:59 Uhr

ok, this is working, thanks!
but I see that this show the first of the list, and not the one with banners_order = 1 (if there are no banners_order = 1, it show the first banner with banners_order=2)...

------------------

Inaktiv

duRiel

Weltmeister

Herkunft: Cambridge
Beiträge: 7300

# Antwort: 7 - 21.11.2007 um 22:02 Uhr

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

1. / 2. / ...

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: navlist.php 343 2006-09-21 22:22:08Z hajo $

$cells = 'banners_picture, banners_alt, banners_url, categories_id';
$banner = cs_sql_select(__FILE__,'banners',$cells,"banners_order = '1'",0,0,1);

if(empty($banner)) {
    echo '----';
}
else {
    $go = cs_secure($banner['banners_picture']);
    $picture = cs_html_img($go,0,0," style=\"margin-bottom:1px\"",cs_secure($banner['banners_alt']));
    echo cs_html_link('http://' . cs_secure($banner['banners_url']),$picture) . cs_html_br(1);
}

?>

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 8 - 21.11.2007 um 22:14 Uhr

Many thanks

Last question I was wondering for something else too:

How is the code to order (for exemple the banners by banners_order) without the banners with banners_order=1?

------------------

Inaktiv

duRiel

Weltmeister

Herkunft: Cambridge
Beiträge: 7300

# Antwort: 9 - 21.11.2007 um 22:27 Uhr

thats what i posted before then.

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 10 - 22.11.2007 um 22:07 Uhr

Hum... ok

Another php question :
In this code :

1.	1. / 2. / ... $cs_wars = cs_sql_select(__FILE__,$from,$select,"war.wars_status = 'played'",$order,0,4);

what can I write to have the match 'played' AND 'running'?

------------------

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 11 - 22.11.2007 um 22:09 Uhr

1.	1. / 2. / ... $cs_wars = cs_sql_select(__FILE__,$from,$select,"war.wars_status = 'played' OR war.wars_status = 'running'",$order,0,4);

------------------
mfg
Patrick "Fr33z3m4n" Jaskulski

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 12 - 23.11.2007 um 12:17 Uhr

Great, this is what I was looking for.

You can see the result of all my question on this site we made for a team.

------------------

Inaktiv

Zoeff

Wannabe poster

Beiträge: 30

# Antwort: 13 - 23.11.2007 um 13:09 Uhr

Looks really good, one lil remark though, when you watch the movie on your main page (using Firefox), at the end of it your entire screen fades out a little and then switches back to normal.

------------------

Ich bin kein coder aber wann jemand fragen hat fur Photoshop.. bitte frag es!

Inaktiv

Tybo
Thread-Ersteller

Wannabe poster

Beiträge: 21

# Antwort: 14 - 26.11.2007 um 22:19 Uhr

That's a temporary video module, I'm looking for something else that can be administrate by clansphere admin menu...

------------------

Inaktiv

Antworten: 14

Seite [1]

Sie müssen sich registrieren, um zu antworten.

Forum - Thema
Nächstes Thema ->
Forum -> International -> Support -> [Php - SQL Question] about banners and co