Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen der Seite angezeigt.

--- playground:playgrounddb [2020/07/28 16:44] – admin
+++ playground:playgrounddb [2020/11/06 10:20] – admin
@@ Zeile 1: / Zeile 1: @@
 <php>
 // load the helper plugin
 /** @var helper_plugin_sqlite $sqlite */
@@ Zeile 12: / Zeile 11: @@
 // initialize the database connection
-if(!$sqlite->init('struct',DOKU_PLUGIN.'struct/db/')){
+if(!$sqlite->init('pf2wiki',DOKU_PLUGIN.'starocotes')){
     return;
 }
 // use the plugin
-$res = $sqlite->query("select * from data_talent left join (select rid, count(*) as zahl from multi_talent where value In ("Abstammung","Elf") group by rid) as m on data_talent.rid = m.rid where zahl = 2");
+$res = $sqlite->query("select * from data_talent left join (select rid, count(*) as zahl from multi_talent where value In ('Abstammung','Elf') group by rid) as m on data_talent.rid = m.rid where zahl = 2");
 $arr = $sqlite->res2arr($res);
-print_r($val);
+foreach ($arr as $val)
+{
+  // use the plugin
+  $res2 = $sqlite->query("select * from multi_talent where colref = 5 and rid = ".$val['rid']);
+  $arr2 = $sqlite->res2arr($res2);
+  $cat = "";
-//foreach($arr => $val)
+  foreach ($arr2 as $val2)
-//{
+  {
-//  print_r($val);
+     $cat .= '<span class="wrap_notice ">'.$val2['value'].'</span> ';
-//}
+  }
+print('<div class="wrap_box plugin_wrap">');
+print('<p>');
+print('<strong>'.$val['col1'].'</strong>');
+print(' <img src="/lib/exe/fetch.php?media='.$val['col6'].'" class="media" alt="" /> <strong>'.$val['col7'].'</strong><br/>');
+print('<span class="wrap_safety ">'.$val['col3']." ".$val['col9']."</span><br/>");
+print($cat."<br/>");
+if($val['col4'] !== '')
+{
+print('<strong>Voraussetzungen:</strong> '.$val['col4'].'<br/>');
+}
+if($val['col8'] !== '')
+{
+print('<strong>Häufigkeit:</strong> '.$val['col8'].'<br/>');
+}
+if($val['col10'] !== '')
+{
+print('<strong>Auslöser:</strong> '.$val['col10'].'<br/>');
+}
+print('<br/>'.$val['col2'].'<br/>');
+if($val['col12'] !== '')
+{
+print('<strong>Kritischer Erfolg:</strong> '.$val['col12'].'<br/>');
+}
+if($val['col13'] !== '')
+{
+print('<strong>Erfolg:</strong> '.$val['col13'].'<br/>');
+}
+if($val['col14'] !== '')
+{
+print('<strong>Fehlschlag:</strong> '.$val['col14'].'<br/>');
+}
+if($val['col15'] !== '')
+{
+print('<strong>Kritischer Fehlschlag:</strong> '.$val['col15'].'<br/>');
+}
+print('</p>');
+print('</div>');
+}
 </php>

PF2 Regel Wiki

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Unterschiede

Seiten-Werkzeuge