public function genRessourcesLink()
{
global $bdd;
foreach (Ressource::Ressources() as $row) {
$req = "INSERT INTO COUTE_TECH(idTech, idRessource, quantite) VALUES ('" . $this->idTech . "', '" . $row['idRessource'] . "','" . $row['quantite'] . "')";
$req = $bdd->exec($req);
}
}
public function genRessourcesLink()
{
global $bdd;
foreach (Ressource::Ressources() as $row) {
$req = "INSERT INTO COUTE_UNITE(idUnite, idRessource, quantite) VALUES ('" . $this->idUnite . "', '" . $row['idRessource'] . "', 500)";
$req = $bdd->exec($req);
}
}
public function genRessourcesLink()
{
global $bdd;
foreach (Ressource::Ressources() as $row) {
$req = "INSERT INTO POSSEDE_RESSOURCE(idJoueur, idRessource, quantite) VALUES ('" . $this->idJoueur . "', '" . $row['idRessource'] . "', 500)";
$req = $bdd->exec($req);
}
}
public function genRessourcesLink()
{
global $bdd;
foreach (Ressource::Ressources() as $row) {
$req = "INSERT INTO COUTE_BATIMENT(quantite, idRessource, idBatiment) VALUES ( 500, '" . $row['idRessource'] . "','" . $this->idBatiment . "')";
$req = $bdd->exec($req);
}
}
@extends('layouts.master')
@section('meta_title')
Réservations
@stop
<?php
$ressources = Ressource::whereIsBookable(true)->get();
?>
@section('breadcrumb')
<div class="row wrapper border-bottom white-bg page-heading">
<div class="col-sm-10">
<h2>Réservations</h2>
@if(count($ressources)>1)
<form id="ressource_filter" action="#" autocomplete="off">
Légende:
@foreach($ressources as $ressource)
<div class="label" style="{{$ressource->labelCss}}">
<input type="checkbox" name="filter_ressource_{{$ressource->id}}"
id="filter_ressource_{{$ressource->id}}" value="{{$ressource->id}}"
checked="checked"/>
<label for="filter_ressource_{{$ressource->id}}"
style="font-weight: 600;">{{$ressource->name}}</label>
</div>
@endforeach
</form>
@endif
</div>
<div class="col-sm-2">
<div class="title-action">
/**
* Rècupère une ligne de résultat
*
* Récupère la ligne suivante d'une ressource de résultat
*
* @param Ressource $r Ressource de résultat (issu de sql_select)
* @param string $t Structure de résultat attendu (défaut ASSOC)
* @param string $serveur Nom de la connexion
* @param bool $requeter Inutilisé
* @return array Ligne de résultat
*/
function spip_sqlite_fetch($r, $t = '', $serveur = '', $requeter = true)
{
$link = _sqlite_link($serveur);
$is_v3 = _sqlite_is_version(3, $link);
if (!$t) {
$t = $is_v3 ? SPIP_SQLITE3_ASSOC : SPIP_SQLITE2_ASSOC;
}
$retour = false;
if ($r) {
$retour = $is_v3 ? $r->fetch($t) : sqlite_fetch_array($r, $t);
}
// les version 2 et 3 parfois renvoie des 'table.titre' au lieu de 'titre' tout court ! pff !
// suppression de 'table.' pour toutes les cles (c'est un peu violent !)
// c'est couteux : on ne verifie que la premiere ligne pour voir si on le fait ou non
if ($retour and strpos(implode('', array_keys($retour)), '.') !== false) {
foreach ($retour as $cle => $val) {
if (($pos = strpos($cle, '.')) !== false) {
$retour[substr($cle, $pos + 1)] =& $retour[$cle];
unset($retour[$cle]);
}
}
}
return $retour;
}
<?php include_once './modele/get_statistiques.php'; include_once './modele/ressource.php'; $titre = "Accueil"; $nbJoueurs = get_nbJoueurs(); $t = Ressource::Ressources(); include_once './vue/accueil.php';
function getRessourceInfoBar()
{
if ($this->getUserRow() == null) {
return new Div();
}
$dbTbl = new DbTable($_SESSION['config']->DBCONNECT, "game_ressourcen_art", array("*"), "", "", "", "");
$tbl = new Table(array("Level", "", "EP", "", "Spacer", "Gold", "", "Erz", "", "Felsen", "", "Holz", "", "Wasser", "", "Nahrung", ""));
$tbl->setWidth("670");
$tbl->setColSizes(array(16, 30, 16, 40, 10, 13, 80, 13, 80, 13, 80, 13, 80, 13, 80, 13, 80));
$tbl->setAlign("left");
$r = $tbl->createRow();
$r->setAttribute(0, "Level: ");
$r->setAttribute(1, $this->getLevel());
$r->setAttribute(2, "EP: ");
$r->setAttribute(3, $this->getEP());
$r->setAttribute(4, "");
$ress = new Ressource($this->getRessourceRowByName($dbTbl, "Gold"));
$gTx = new Text($this->getGold());
$gTx->setToolTip("Gold");
$gImg = $ress->getRessourceImage();
$gImg->setWidth(10);
$gImg->setHeight(10);
$gImg->setToolTip("Gold");
$r->setAttribute(5, $gImg);
$r->setAttribute(6, $gTx);
$ress = new Ressource($this->getRessourceRowByName($dbTbl, "Erz"));
$eTx = new Text($this->getErz());
$eTx->setToolTip("Felsen");
$eImg = $ress->getRessourceImage();
$eImg->setWidth(10);
$eImg->setHeight(10);
$eImg->setToolTip("Erz");
$r->setAttribute(7, $eImg);
$r->setAttribute(8, $eTx);
$ress = new Ressource($this->getRessourceRowByName($dbTbl, "Felsen"));
$fTx = new Text($this->getFelsen());
$fTx->setToolTip("Felsen");
$fImg = $ress->getRessourceImage();
$fImg->setWidth(10);
$fImg->setHeight(10);
$fImg->setToolTip("Felsen");
$r->setAttribute(9, $fImg);
$r->setAttribute(10, $fTx);
$ress = new Ressource($this->getRessourceRowByName($dbTbl, "Holz"));
$hTx = new Text($this->getHolz());
$hTx->setToolTip("Holz");
$hImg = $ress->getRessourceImage();
$hImg->setWidth(10);
$hImg->setHeight(10);
$hImg->setToolTip("Holz");
$r->setAttribute(11, $hImg);
$r->setAttribute(12, $hTx);
$ress = new Ressource($this->getRessourceRowByName($dbTbl, "Wasser"));
$wTx = new Text($this->getWasser());
$wTx->setToolTip("Wasser");
$wImg = $ress->getRessourceImage();
$wImg->setWidth(10);
$wImg->setHeight(10);
$wImg->setToolTip("Wasser");
$r->setAttribute(13, $wImg);
$r->setAttribute(14, $wTx);
$ress = new Ressource($this->getRessourceRowByName($dbTbl, "Nahrung"));
$nTx = new Text($this->getNahrung());
$nTx->setToolTip("Nahrung");
$nImg = $ress->getRessourceImage();
$nImg->setWidth(10);
$nImg->setHeight(10);
$nImg->setToolTip("Nahrung");
$r->setAttribute(15, $nImg);
$r->setAttribute(16, $nTx);
$tbl->addRow($r);
return $tbl;
}
public function addResource($docId)
{
$resource = new Ressource($this->addSubElement("resource"));
$resource->setId($this->getId() . "_resource_" . $this->getNewResourceId());
$resource->setDocument($docId);
$this->saveDOM();
return $resource;
}
<hr>
</div>
<div class="row" >
<div class="small-4 columns">
<img style="opacity: 0.4" src="<?php
echo $te[0]->getImage();
?>
" /> </div>
<div class="small-8 columns" >
<h4 style="color: lightgrey"> Coût de la Technologie:</h4>
<p style="color: lightgrey">
<span>
<?php
foreach ($te[1] as $rez) {
$rezA = new Ressource($rez[1]);
echo "<span>" . $rez[0] . "</span><img src=\"" . $rezA->getImage() . "\" style=\"width:35px; height:35px; opacity: 0.4\" title=\"" . $rezA->getNomRessource() . "\" />";
}
?>
</span>
</p>
<h5 style="color: lightgrey"> Description:</h5>
<p style="color: lightgrey"><?php
echo ucfirst($te[0]->getDescriptionTech());
?>
</p>
</div>
</div>
<a href="index.php?page=post_tech&tech=create&id=<?php
echo $te[0]->getIdTech();
?>
<?php include_once './modele/ressource.php'; include_once './modele/Batiment.php'; $titre = "Mes batiments"; $res = Ressource::Ressources(); $bat = Batiment::Batiments(); include_once './vue/Batiment.php';
public function getTag()
{
$tpl = new CopixTpl();
$tpl->assign('TITLE_PAGE', CopixI18N::get('ressource.title.module') . ' » ' . CopixI18N::get('ressource.title.tag') . ' : "' . _request("tag") . '"');
// Kernel::MyDebug( Ressource::alltags() );
$ressource_list = Ressource::tag2ressources(_request("tag"), _request("id"));
$tplList = new CopixTpl();
$tplList->assign('ressource_list', $ressource_list);
$alltags = Ressource::similarTags(_request("tag"), _request("id"));
$tplList->assign('tags_list', $alltags);
$tplList->assign('annu_id', _request("id"));
$menu = array();
$menu[] = array('url' => CopixUrl::get('|getSearchAdvanced', array('id' => _request("id"))), 'txt' => CopixI18N::get('ressource.menu.parCriteres'));
$menu[] = array('url' => CopixUrl::get('ressource||getList', array('id' => _request("id"))), 'txt' => CopixI18N::get('ressource.menu.retourListe'));
if (Ressource::checkRight("ANNU", _request("id"), PROFILE_CCV_WRITE)) {
$menu[] = array('url' => CopixUrl::get('ressource||getRessource', array('id' => _request("id"), 'mode' => 'new')), 'txt' => CopixI18N::get('ressource.menu.ajouterRessource'));
}
$result = $tplList->fetch("gettag.tpl");
$tpl->assign('MENU', $menu);
$tpl->assign('MAIN', $result);
return new CopixActionReturn(COPIX_AR_DISPLAY, $tpl);
}
public function savetags($res_id)
{
$ressource_dao = CopixDAOFactory::create("ressource_ressources");
$ressource = $ressource_dao->get($res_id);
$tags_dao = CopixDAOFactory::create("ressource_tags");
$tags_dao->delRessource($res_id);
$tags = Ressource::motcles2tags($ressource->ressources_mots);
$restag = CopixDAOFactory::createRecord("ressource_ressources");
foreach ($tags as $tag_key => $tag_val) {
$restag->annu = $ressource->ressources_id_annu;
$restag->res = $res_id;
$restag->tag = $tag_key;
@$tags_dao->insert($restag);
}
}
/**
* Order DOWN
*/
public function order_down($ressource)
{
$ressource = $this->dataExist($ressource);
$ressource->order_index += 1;
$next = Ressource::whereOrderIndex($ressource->order_index)->first();
if ($ressource->save()) {
$next->order_index -= 1;
$next->save();
return Redirect::route('ressource_list');
} else {
return Redirect::route('ressource_list')->with('mError', 'Impossible de descendre cette ressource');
}
}
