|
Geek Auto-Linker GAL automatically links keywords that users type in posts to advertising hover pop-ups. |
Advertisement | |
This is an HTML example. Isn't it just wonderful?!?!
|
|
Learn how to remove ads |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Latest entry in glossary?
Is it possible to use
GAL
to display the Latest Entry in the Glossary on a forum homepage? I used the following code (from this hack for the vBadvanced Links Directory) to show the latest link:
Code:
if ($forum['forumid'] == 'XX') { global $db; $tot = $db->query_first("SELECT COUNT(*) as count FROM " . TABLE_PREFIX . "adv_links"); $link = $db->query_first("SELECT linkid , name, posts, username, userid, dateline FROM " . TABLE_PREFIX . "adv_links ORDER BY linkid DESC"); $date = vbdate($vbulletin->options['dateformat'], $link['dateline'], 1); $time = vbdate($vbulletin->options['timeformat'], $link['dateline']); $forum['lastpostinfo'] = '<div align="left" class="smallfont"><strong><a href="/showcase/showlink.php?do=showdetails&l='.$link[linkid].'">'.$link[name].'</a></strong><br />by <a href="member.php?find=lastposter&f='.$link[userid].'">'.$link[username].'</a><br /><span style="float:right;">'.$date.' '.$time.' <a href="/showcase/showlink.php?do=showdetails&l='.$link[linkid].'"><img src="images/buttons/lastpost.gif" border="0" alt="View showcase"></a></span></div>'; $forum['threadcount'] = $tot['count']; $forum['replycount'] = $link['posts']; } |
#2
|
||||
|
||||
Custom coding really falls outside the realm of support and is not typically offered, especially for larger requests, but here is a query you could try to get the most recent entry in the
gal
database table:
Code:
# add your vB table prefix to the gal table name if you use a prefix SELECT * FROM gal ORDER BY id DESC LIMIT 1;
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks. While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams |
#3
|
|||
|
|||
Thanks, Morgan. I'll give that a try.
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Entry Column | RaceJunkie | Geek Auto-Linker | 1 | 02-04-2008 03:52 PM |
Making a new entry.. | gldtn | Geek Auto-Linker | 7 | 01-29-2008 09:48 PM |
Glossary with 4.81 | Cliff | Geek Auto-Linker | 3 | 01-10-2007 04:35 PM |
valid GAL entry | joh | Geek Auto-Linker | 20 | 10-25-2006 06:28 PM |
What is the userid entry for? | Brent | Geek Advertising Banner System | 2 | 02-13-2006 09:53 PM |