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

Latest 5 Showrooms

Demo

Probiere ClanSphere aus und teste daran herum. Demo

Spenden

ClanSphere ist freie OpenSource Software.
Bitte unterstützt uns. Spenden

Antworten: 7

Seite [1]

malice

Try to beat me

Beiträge: 122

# Thema - 14.02.2008 um 14:07 Uhr

hi ich hab mal ne frage, ich hab die wars/list.php foldendermaßen umgebaut:

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.

1. / 2. / ...

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: list.php 101 2006-07-12 09:36:29Z hajo $

$cs_lang = cs_translate('wars');

$squads_id = empty($_REQUEST['where']) ? '' : $_REQUEST['where'];
settype($squads_id,'integer');
$where = empty($squads_id) ? 0 : "squads_id = '" . $squads_id . "'";

$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$cs_sort[1] = 'war.wars_date DESC';
$cs_sort[2] = 'war.wars_date ASC';
$cs_sort[3] = 'cln.clans_name DESC';
$cs_sort[4] = 'cln.clans_name ASC';
$cs_sort[5] = 'cat.categories_name DESC';
$cs_sort[6] = 'cat.categories_name ASC';
$sort = empty($_REQUEST['sort']) ? 1 : $_REQUEST['sort'];
$order = $cs_sort[$sort];
$wars_count = cs_sql_count(__FILE__,'wars',$where);

$data = array();
$data['info']['warcount'] = sprintf($cs_lang['count'], $wars_count);
$data['pages']['choice'] = cs_pages('wars','list',$wars_count,$start,$squads_id,$sort,100);
$data['url']['form'] = cs_url('wars','list');
$data['squads'] = cs_sql_select(__FILE__,'squads','squads_name, squads_id',0,'squads_name',0,0);
$count_squads = count($data['squads']);

for ($run = 0; $run < $count_squads; $run++) {
  $data['squads'][$run]['name'] = cs_secure($data['squads'][$run]['squads_name']);
}

$data['url']['ranks'] = cs_url('ranks','list');
$data['url']['stats'] = cs_url('wars','stats');

$data['sort']['date'] = cs_sort('wars','list',$start,$squads_id,1,$sort);
$data['sort']['enemy'] = cs_sort('wars','list',$start,$squads_id,3,$sort);
$data['sort']['category'] = cs_sort('wars','list',$start,$squads_id,5,$sort);

$select = 'war.games_id AS games_id, war.wars_date AS wars_date, war.clans_id AS clans_id, cln.clans_short AS clans_short, cln.clans_country AS clans_country, sqd.squads_name AS squads_name, cln.clans_name AS clans_name, cat.categories_name AS categories_name, war.categories_id AS categories_id, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id';
$from = 'wars war INNER JOIN {pre}_categories cat ON war.categories_id = cat.categories_id ';
$from .= 'INNER JOIN {pre}_clans cln ON war.clans_id = cln.clans_id INNER JOIN {pre}_squads sqd ON war.squads_id = sqd.squads_id';
$cs_wars = cs_sql_select(__FILE__,$from,$select,$where,$order,$start,100);

$data['wars'] = '';
$count_wars = count($cs_wars);

for ($run = 0; $run < $count_wars; $run++) {
  $data['wars'][$run]['gameicon'] = cs_html_img('uploads/games/' . $cs_wars[$run]['games_id'] . '.gif');
  $data['wars'][$run]['date'] = cs_date('unix',$cs_wars[$run]['wars_date']);
    $data['wars'][$run]['squads_name'] = cs_secure($cs_wars[$run]['squads_name']);
    $data['wars'][$run]['enemy_flag'] = cs_html_img('symbols/countries/' . $cs_wars[$run]['clans_country'] . '.gif',12,18);
  $data['wars'][$run]['enemyurl'] = cs_url('clans','view','id=' . $cs_wars[$run]['clans_id']);
  $data['wars'][$run]['enemy'] = cs_secure($cs_wars[$run]['clans_name']);
  $data['wars'][$run]['caturl'] = cs_url('categories','view','id=' . $cs_wars[$run]['categories_id']);
  $data['wars'][$run]['category'] = cs_secure($cs_wars[$run]['categories_name']);
  $data['wars'][$run]['url'] = cs_url('wars','view','id=' . $cs_wars[$run]['wars_id']);
  $result = $cs_wars[$run]['wars_score1'] - $cs_wars[$run]['wars_score2'];
        if($result >= 1) {
        $cs_wars[$run]['wars_score1'] = cs_html_span(1,'color:#009900') . $cs_wars[$run]['wars_score1'] . cs_html_span(0);
        $cs_wars[$run]['wars_score2'] = cs_html_span(1,'color:#009900') . $cs_wars[$run]['wars_score2'] . cs_html_span(0);
        } elseif(empty($result)) {
        $cs_wars[$run]['wars_score1'] = cs_html_span(1,'color:#666666') . $cs_wars[$run]['wars_score1'] . cs_html_span(0);
        $cs_wars[$run]['wars_score2'] = cs_html_span(1,'color:#666666') . $cs_wars[$run]['wars_score2'] . cs_html_span(0);
        } else {
        $cs_wars[$run]['wars_score1'] = cs_html_span(1,'color:#FF0000') . $cs_wars[$run]['wars_score1'] . cs_html_span(0);
        $cs_wars[$run]['wars_score2'] = cs_html_span(1,'color:#FF0000') . $cs_wars[$run]['wars_score2'] . cs_html_span(0);
        }
        $data['wars'][$run]['result'] = $cs_wars[$run]['wars_score1'] . ' : ' . $cs_wars[$run]['wars_score2'];$data['wars'][$run]['result'] = $cs_wars[$run]['wars_score1'] . ' : ' . $cs_wars[$run]['wars_score2'];
}

echo cs_subtemplate(__FILE__,$data,'wars','list');

?>

jetzt funktioniert allerdings diese match auswahl nach squads nicht mehr. der zeigt mir da immer ne leere liste an, wenn ich nen squad auswhäle (beim start is die liste voll). auschnitt aus der tpl:

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

1. / 2. / ...

<?php <table border="0" cellpadding="0" cellspacing="0" width="700">
<tr>
  <td class="headb">{sort:date}{lang:date}</td>
  <td class="headb"> </td>
  <td class="headb"> </td>
  <td class="headb"> </td>
  <td class="headb"> </td>
  <td class="headb"> </td>
  <td class="headb"> </td>
  <td class="headb">{sort:enemy}{lang:enemy}</td>
  <td class="headb">{sort:category}{lang:category}</td>
  <td class="centerb">Details</td>
</tr>
{loop:wars}
<tr>
  <td class="leftb">{wars:date}</td>
  <td class="left"> </td>
  <td class="left">{wars:squads_name}</td>
  <td class="left"> </td>
  <td class="left">vs</td>
  <td class="left"> </td>
  <td class="rightb">{wars:enemy_flag}</td>
  <td class="leftb"><a href="{wars:enemyurl}">{wars:enemy}</a></td>
  <td class="leftb"><a href="{wars:caturl}">{wars:category}</a></td>
  <td class="centerb"><a href="{wars:url}">{wars:result}</a></td>
</tr>
{stop:wars}
</table> ?>

ich denke es liegt an meinen änderungen von zeile 40-56. aber was kann ich tun, damit der fehler behoben wird, ich aber meine "neue" anzeige behalte

Zuletzt editiert von malice am 14.02.2008 um 15:31 Uhr (1x Editiert)

Inaktiv

malice
Thread-Ersteller

Try to beat me

Beiträge: 122

# Antwort: 1 - 17.02.2008 um 01:53 Uhr

keiner kann helfen?

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 2 - 17.02.2008 um 10:00 Uhr

link ?

------------------
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

malice
Thread-Ersteller

Try to beat me

Beiträge: 122

# Antwort: 3 - 18.02.2008 um 00:28 Uhr

http://www.diesel-s.de/TheScore/ihf_bw_3/cms/index.php?mod=wars

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 4 - 18.02.2008 um 09:00 Uhr

Error: /customers/diesel-s.de/diesel-s.de/httpd.www/TheScore/ihf_bw_3/cms/mods/wars/lis t.php -> cs_sql_select - Column 'squads_id' in where clause is ambiguous

1. / 2. / ...

$select = 'war.games_id AS games_id, war.wars_date AS wars_date, war.clans_id AS clans_id, cln.clans_short AS clans_short, cln.clans_country AS clans_country, sqd.squads_name AS squads_name, cln.clans_name AS clans_name, cat.categories_name AS categories_name, war.categories_id AS categories_id, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id';

ich denke mal das dort squads_id fehlt

1. / 2. / ...

$select = 'war.games_id AS games_id, war.wars_date AS wars_date, war.clans_id AS clans_id, cln.clans_short AS clans_short, cln.clans_country AS clans_country, sqd.squads_name AS squads_name, sqd.squads_id AS squads_id, cln.clans_name AS clans_name, cat.categories_name AS categories_name, war.categories_id AS categories_id, war.wars_score1 AS wars_score1, war.wars_score2 AS wars_score2, war.wars_id AS wars_id';

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

Inaktiv

malice
Thread-Ersteller

Try to beat me

Beiträge: 122

# Antwort: 5 - 18.02.2008 um 15:06 Uhr

jo hab ich ersetzt, allerdings is der fehler geblieben

Inaktiv

Fr33z3m4n

Medal of Honor

Herkunft: Hamm
Beiträge: 11094

# Antwort: 6 - 19.02.2008 um 10:32 Uhr

1.	1. / 2. / ... $where = empty($squads_id) ? 0 : "squads_id = '" . $squads_id . "'";

ändern in

1.	1. / 2. / ... $where = empty($squads_id) ? 0 : "sqd.squads_id = '" . $squads_id . "'";

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

Inaktiv

malice
Thread-Ersteller

Try to beat me

Beiträge: 122

# Antwort: 7 - 19.02.2008 um 14:43 Uhr

jo korrekt, nu geht es

Inaktiv

Dieses Thema wurde von Fr33z3m4n ClanSphere Team

geschlossen.

Antworten: 7

Seite [1]

Clansphere :: FREE Clan Content Management System

Latest 5 Showrooms

Demo

Spenden

Usermenu

User Birthdays

Users Online

Banners / Partner

Contact

Forum - Thema
Nächstes Thema ->
Forum -> Support -> Allgemein (Support) -> wars/list.php