SMF 2.0.19 has been released! Please update. Read more.
Started by LostProphecy, September 21, 2004, 04:24:35 AM
SELECT m.userName, t.ID_THEME FROM smf_members AS m, smf_themes AS t WHERE t.value = 'yourthemename' AND m.ID_THEME = t.ID_THEME;
SELECT userName FROM smf_members WHERE ID_THEME='x'
SELECT mem.memberName AS Login, mem.realName AS Name, th.value AS ThemeFROM smf_members AS mem, smf_themes AS thWHERE mem.ID_THEME = th.ID_THEME and th.variable='name'ORDER BY mem.memberName ASC LIMIT 0, 30
Quote from: epyon on July 28, 2005, 04:30:25 PMhey i think this is a good idea too, i was looking for somthing liek this on the admin panel but wtvr, any ways im kindov new to this but how would i add this setting? i mean i see the codes u guys have provided but where do i put it?