hoffentlich endlich mal eins was auch deathmatch mitmacht XD
in der zeit mach ich noch meinen media manager fertig
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
function profilefields_show_spez_goodies($value, $uid) { $output = ''; $sql = "SELECT a.url, a.gname, a.lbesch FROM `prefix_goodies` a INNER JOIN prefix_goodiebuy b ON a.id = b.goodieid WHERE b.userid = $uid "; while($row = db_fetch_assoc($sql) ) { $output .= (!empty($row['url']) ? '<img src="include/images/goodies/'.$row['url'].'" alt="'.$row['gname'].'" title="'.$row['lbesch'].'"/><br /><font class="smalfont">'.$row['gname'].'</font></span><br />'; } return profilefields_show_echo_standart( 'Goodies', $output); }
INSERT INTO prefix_profilefields (`show`, `pos`, `func`) SELECT 'goodies', MAX(pos) + 1, 3 FROM prefix_profilefields;
function profilefields_show_spez_goodies($value, $uid) { $output = ''; $sql = db_query("SELECT a.url, a.gname, a.lbesch FROM `prefix_goodies` a INNER JOIN prefix_goodiebuy b ON a.id = b.goodieid WHERE b.userid = $uid"); while($row = db_fetch_assoc($sql) ) { $output .= (!empty($row['url']) ? '<img src="include/images/goodies/'.$row['url'].'" alt="'.$row['gname'].'"/>' : $row['gname']).'<br /><font class="smalfont">'.$row['lbesch'].'</font><br />'; } return profilefields_show_echo_standart( 'Goodies', $output); }
CREATE TABLE `ic2_goodies` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `gname` varchar(50) character set latin1 NOT NULL, `kbesch` varchar(75) character set latin1 NOT NULL, `url` varchar(100) character set latin1 NOT NULL, `preis` mediumint(9) unsigned NOT NULL, `lbesch` varchar(250) character set latin1 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=2 ; -- -- Daten für Tabelle `ic2_goodies` -- INSERT INTO `ic2_goodies` VALUES (1, 'TEST', 'test blau', 'blue.png', 200, 'langblaa');
das kann ja nicht das prob sein x_X CREATE TABLE `ic2_goodiebuy` ( `userid` int(10) NOT NULL, `goodieid` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci; -- -- Daten für Tabelle `ic2_goodiebuy` -- INSERT INTO `ic2_goodiebuy` VALUES (1, 1);
Geschlossen | ||
Zurück zu Module und Modifikationen |