public function genDownloadBadge() { $html = ''; if ($this->hasDownloadUri()) { $downloadUri = htmlspecialchars($this->downloadUri); $title = htmlspecialchars($this->title); $html .= "<div class=\"icon\">" . "<a href=\"{$downloadUri}\"" . " title=\"Download '{$title}'\">" . "<img src=\"images/packageicon.png\" alt=\"Package icon\" /></a></div>"; $html .= "<a href=\"{$downloadUri}\"" . " title=\"Download '{$title}'\">"; } else { if ($this->hasHomepageUri()) { $title = htmlspecialchars($this->title); $homepageUri = htmlspecialchars($this->homepageUri()); $homepageUriLabel = htmlspecialchars("Visit '{$this->title}' homepage"); $html .= "<a href=\"{$homepageUri}\"" . " title=\"{$homepageUriLabel}\">"; } } $html .= '<span class="name">' . htmlspecialchars($this->title()) . '</span>'; if ($this->hasDescription()) { $html .= '<span class="description">' . htmlspecialchars($this->description()) . '</span>'; } if ($this->hasDownloadUri() || $this->hasHomepageUri()) { $html .= '</a>'; } $html .= '<div class="metadata">'; if ($this->hasDownloadUri()) { $html .= '<span class="version">Version: ' . htmlspecialchars($this->version()) . '</span>'; if (!isset($this->games)) { $gameString = '<label title="For use with all games">Any</label>'; } else { if ($this->supportsAllGameModes(AddonRepositoryPlugin::$doomGameModes)) { $gameString = '<label title="For use with any version of DOOM">Any DOOM</label>'; } else { if ($this->supportsAllGameModes(AddonRepositoryPlugin::$hereticGameModes)) { $gameString = '<label title="For use with any version of Heretic">Any Heretic</label>'; } else { if ($this->supportsAllGameModes(AddonRepositoryPlugin::$hexenGameModes)) { $gameString = '<label title="For use with any version of Hexen">Any Hexen</label>'; } else { $gameString = '<label title="For use with these games only">' . htmlspecialchars(implode_keys('|', $this->games)) . '</label>'; } } } } $html .= '<br /><span class="games">Games: ' . $gameString . '</span>'; } else { // We have no interesting meta data for simple links. What to say here? } $html .= '</div>'; /*if($this->hasNotes()) { $html .= '<br /><p>'. $this->notes() .'</p>'; }*/ return '<div class="addon_badge">' . $html . '</div>'; }
function insert_array_db_multi($table, $arr_columns) { # multiple inserts allowed in one sentence # input $arr_columns must be like: /*Array ( [Temperature] => Array ( [0] => 16.4 [1] => 16.4 [2] => 16.4 ) [Wattage] => Array ( [0] => 00383 [1] => 00403 [2] => 00395 ) [CC_Time] => Array ( [0] => 2015-02-06 06:00:03 [1] => 2015-02-06 06:00:09 [2] => 2015-02-06 06:00:15 ) )*/ global $conex; $columns = '(' . implode_keys(', ', $arr_columns) . ')'; $arr_keys = array_keys($arr_columns); $str_values = ''; $first = true; foreach ($arr_columns[$arr_keys[0]] as $i => $value) { if ($first) { $first = false; } else { $str_values .= ','; } $str_values .= '('; $first2 = true; foreach ($arr_keys as $key) { if ($first2) { $first2 = false; } else { $str_values .= ','; } $str_values .= '\'' . $arr_columns[$key][$i] . '\''; } $str_values .= ')'; } $sql = 'INSERT INTO ' . $table . $columns . ' VALUES ' . $str_values; $insert = my_query($sql, $conex); if ($insert) { return true; } else { return false; } }