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

Antworten: 6

Seite [1]

zuma

Wannabe poster

Beiträge: 23

# Thema - 08.01.2012 um 12:34 Uhr

Guten Tag,

was muss ich in der where Abfrage ändern, damit nur die SPiele ausgegeben werden, welche den status played haben.

Grüße
zuma

Inaktiv

sgraewe

Supporter

Beiträge: 6116

# Antwort: 1 - 08.01.2012 um 12:37 Uhr

{wars:navlast} als platzhalter

Inaktiv

zuma
Thread-Ersteller

Wannabe poster

Beiträge: 23

# Antwort: 2 - 08.01.2012 um 12:51 Uhr

ich habe es so versucht jedoch bekomm ich da nur die reine template datei mit platzhaltern ausgegeben

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

1. / 2. / ...

for ($run = 0; $run < $count_wars; $run++) {

if ($cs_wars[$run]['status']=='played')
{
  $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]['enemyurl'] = cs_url('clans','view','id=' . $cs_wars[$run]['clans_id']);
  $data['wars'][$run]['enemy'] = cs_secure($cs_wars[$run]['clans_short']);
  $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']);
  $data['wars'][$run]['result'] = $cs_wars[$run]['wars_score1'] . ' : ' . $cs_wars[$run]['wars_score2'];
  $data['wars'][$run]['if']['upcoming'] = ($cs_wars[$run]['status'] == 'upcoming') ? true : false;
  $data['wars'][$run]['if']['played'] = ($cs_wars[$run]['status'] == 'played') ? true : false;
  $data['wars'][$run]['if']['running'] = ($cs_wars[$run]['status'] == 'running') ? true : false;
  $data['wars'][$run]['if']['canceled'] = ($cs_wars[$run]['status'] == 'canceled') ? true : false;
  $result = $cs_wars[$run]['wars_score1'] - $cs_wars[$run]['wars_score2'];
  $icon = $result >= 1 ? 'green' : 'red';
  $icon = !empty($result) ? $icon : 'grey';
  $data['wars'][$run]['resulticon'] = cs_html_img('symbols/clansphere/' . $icon . '.gif');
  }
  else
  {}
}

Zuletzt editiert von zuma am 08.01.2012 um 12:55 Uhr (2x Editiert)

Inaktiv

palle

Supporter

Beiträge: 3073

# Antwort: 3 - 08.01.2012 um 13:32 Uhr

08.01.2012 um 12:34 Uhr - zuma:

Guten Tag,

was muss ich in der where Abfrage ändern, damit nur die SPiele ausgegeben werden, welche den status played haben.

Grüße
zuma

Die gesamte /mods/wars/list.php posten.

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

I like the part where it says 'nyan'

Inaktiv

zuma
Thread-Ersteller

Wannabe poster

Beiträge: 23

# Antwort: 4 - 08.01.2012 um 16:36 Uhr

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 2009 - www.clansphere.net
// $Id: list.php 3366 2009-06-27 19:56:19Z hajo $

$cs_lang = cs_translate('wars');

$squads_id = empty($_REQUEST['where']) ? 0 : (int) $_REQUEST['where'];
$where_count = empty($squads_id) ? 0 : "squads_id = '" . $squads_id . "'";
$where = empty($squads_id) ? 0 : "war.squads_id = '" . $squads_id . "'";

$start = empty($_REQUEST['start']) ? 0 : (int) $_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 : (int) $_REQUEST['sort'];
$order = $cs_sort[$sort];
$wars_count = cs_sql_count(__FILE__,'wars',$where_count);

$data = array();
$data['info']['warcount'] = sprintf($cs_lang['count'], $wars_count);
$data['pages']['choice'] = cs_pages('wars','list',$wars_count,$start,$squads_id,$sort);
$data['url']['form'] = cs_url('wars','list');
$cid = "squads_fightus = '0'";
$data['squads'] = cs_sql_select(__FILE__,'squads','squads_name, squads_id',$cid,'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['squads'][$run]['icon'] = cs_html_img('uploads/games/' . $cs_wars[$run]['games_id'] . '.gif');
}

$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.wars_status AS status, war.clans_id AS clans_id, cln.clans_short AS clans_short, 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 ';
$cs_wars = cs_sql_select(__FILE__,$from,$select,$where,$order,$start,45);

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

for ($run = 0; $run < $count_wars; $run++) {
if ($cs_wars[$run]['status']=='played')
{
  $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]['enemyurl'] = cs_url('clans','view','id=' . $cs_wars[$run]['clans_id']);
  $data['wars'][$run]['enemy'] = cs_secure($cs_wars[$run]['clans_short']);
  $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']);
  $data['wars'][$run]['result'] = $cs_wars[$run]['wars_score1'] . ' : ' . $cs_wars[$run]['wars_score2'];
  $data['wars'][$run]['if']['upcoming'] = ($cs_wars[$run]['status'] == 'upcoming') ? true : false;
  $data['wars'][$run]['if']['played'] = ($cs_wars[$run]['status'] == 'played') ? true : false;
  $data['wars'][$run]['if']['running'] = ($cs_wars[$run]['status'] == 'running') ? true : false;
  $data['wars'][$run]['if']['canceled'] = ($cs_wars[$run]['status'] == 'canceled') ? true : false;
  $result = $cs_wars[$run]['wars_score1'] - $cs_wars[$run]['wars_score2'];
  $icon = $result >= 1 ? 'green' : 'red';
  $icon = !empty($result) ? $icon : 'grey';
  $data['wars'][$run]['resulticon'] = cs_html_img('symbols/clansphere/' . $icon . '.gif');
  }
  else
  {}
}

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

Inaktiv

zuma
Thread-Ersteller

Wannabe poster

Beiträge: 23

# Antwort: 5 - 09.01.2012 um 19:52 Uhr

jemand eine Idee?

Inaktiv

palle

Supporter

Beiträge: 3073

# Antwort: 6 - 09.01.2012 um 19:57 Uhr

list.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.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.

1. / 2. / ...

<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
  <td class="headb" colspan="3">Forum - Liste</td>
</tr>
<tr>
  <td class="leftb">{info:warcount}</td>
  <td class="rightb" colspan="2">{pages:choice}</td>
</tr>
<tr>
  <td class="leftb">Squad
    <form method="post" id="wars_list" action="{url:wars_list}">
<div style="display:none;"><input type="hidden" name="cs_xsrf_key" value="b28b246fa3bac6a3b2e1d2f7314eff9b" /></div>

      <select name="where">
        <option value="0">----</option>
        {loop:squads}<option value="{squads:squads_id}">{squads:name}</option>{stop:squads}
      </select>
      <input type="submit" name="submit" value="Anzeigen" />
    </form>
  </td>
  <td class="leftb"><a href="{url:ranks}">{lang:ranks}</a></td>
  <td class="rightb"><a href="{url:wars_stats}">Statistik</a></td>
</tr>
</table>
<br />

<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
  <td class="headb">{lang:game}</td>
  <td class="headb">{sort:date}Datum</td>
  <td class="headb">{sort:enemy}{lang:enemy}</td>
  <td class="headb">{sort:category}Kategorie</td>
  <td class="headb" colspan="2">{lang:score}</td>
</tr>
{loop:wars}
<tr>
  <td class="leftc">{wars:gameicon}</td>
  <td class="leftc">{wars:date}</td>
  <td class="leftc"><a href="{wars:enemyurl}">{wars:enemy}</a></td>
  <td class="leftc"><a href="{wars:caturl}">{wars:category}</a></td>
  {if:played}
  <td class="centerc"><a href="{wars:url}">{wars:resulticon}</a></td>
  {stop:played}
</tr>
{stop:wars}
</table>

list.php

1. / 2. / ...

<?php
// ClanSphere 2010 - www.clansphere.net
// $Id$

$cs_lang = cs_translate('wars');

$squads_id = empty($_REQUEST['where']) ? 0 : (int) $_REQUEST['where'];
$where_count = empty($squads_id) ? 0 : "squads_id = '" . $squads_id . "'";
$where = empty($squads_id) ? 0 : "war.squads_id = '" . $squads_id . "' AND war.wars_status = played";

$start = empty($_REQUEST['start']) ? 0 : (int) $_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 : (int) $_REQUEST['sort'];
$order = $cs_sort[$sort];
$wars_count = cs_sql_count(__FILE__,'wars',$where_count);

$data = array();
$data['info']['warcount'] = sprintf($cs_lang['count'], $wars_count);
$data['pages']['choice'] = cs_pages('wars','list',$wars_count,$start,$squads_id,$sort);
$data['url']['form'] = cs_url('wars','list');
$cid = "squads_fightus = '0'";
$data['squads'] = cs_sql_select(__FILE__,'squads','squads_name, squads_id',$cid,'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['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, 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 ';
$cs_wars = cs_sql_select(__FILE__,$from,$select,$where,$order,$start,$account['users_limit']);

$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]['enemyurl'] = cs_url('clans','view','id=' . $cs_wars[$run]['clans_id']);
  $data['wars'][$run]['enemy'] = cs_secure($cs_wars[$run]['clans_short']);
  $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']);
  $data['wars'][$run]['result'] = $cs_wars[$run]['wars_score1'] . ' : ' . $cs_wars[$run]['wars_score2'];
  $result = $cs_wars[$run]['wars_score1'] - $cs_wars[$run]['wars_score2'];
  $icon = $result >= 1 ? 'green' : 'red';
  $icon = !empty($result) ? $icon : 'grey';
  $data['wars'][$run]['resulticon'] = cs_html_img('symbols/clansphere/' . $icon . '.gif');
}

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

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

I like the part where it says 'nyan'

Zuletzt editiert von palle am 09.01.2012 um 19:58 Uhr (1x Editiert)

Inaktiv

Antworten: 6

Seite [1]

Sie müssen sich registrieren, um zu antworten.

Forum - Thema
Nächstes Thema ->
Forum -> ClanSphere -> Allgemein (ClanSphere) -> Änderung Warlist