want to make a encylopedia using current DB

[aussiev8]

i used to use nuke, and i have a db table with all of the encylopedia terms, i was wondering if someone could give me a kick in the right direction on how i'd get this into a nice addon..

maybe something like:

[ a b c d e f g h i j k l m n o p q r s t u v w x y z ]

then they pick a letter and all of the definitions starting with that letter are displayed, they can then click on the title and presto the definition pops up!

the table layout goes as follows:

article_id,
title,
text,

any gurus out there wanting to lend a hand?

[aussiev8]

bump
anyone?

[rake]

to get all the terms from the database starting with a certain letter, you could use this query:

SELECT * FROM table WHERE title LIKE '$letter%'

then loop through all rows to display the list of entries for that letter..

[aussiev8]

how can i make it look like the forum?
is there an addrow() function or somethin i can use?
i'd prefer to do it that way then create my own tables?

[Dean C]

I did make DC Glossary a while ago but I haven't had time to pick it up again (got frustrated with having to support phrases which broke everything).

[aussiev8]

bump someone out there should know this!

[rake]

Seems like you need to learn a lot more about vbulletin and coding in general before you can do this. You can't expect someone to walk you through creating a hack.

[aussiev8]

so where do i learn? :)
shouldn't i ask questions, to find the answers? I've searched the net without much help.
i've created php websites before, but asked a few simple questions, i can add dynamic tables to pages, do encryption, secured transfers ect.ect, but just not sure what functions/procedures vb gives everyone..

[aussiev8]

anyone?

[memobug]

Seems like you need to learn a lot more about vbulletin and coding in general before you can do this. You can't expect someone to walk you through creating a hack.
In what way would this integrate with vB

?

[Marco van Herwaarden]

anyone?
Start by looking through the function libraries in your includes directory, then look how those functions are being learned.

You already got the best manual there is: the vB source code.

[aussiev8]

uhmm cool, i don't want someone to walk me through it, for an open source project the documentation is limited and the community help is shocking...

nobody wants to help a new coder get off his feet...
i think you guys are stuck up!

[cinq]

to get all the terms from the database starting with a certain letter, you could use this query:

SELECT * FROM table WHERE title LIKE '$letter%'

then loop through all rows to display the list of entries for that letter..

rake already provided the solution to what you are asking :)

[Marco van Herwaarden]

Well i consider myself a new coder as well, but i learned myself the way i described it. And in my view that is the only way you can (good) learn something like this.

If you have any specific questions, you will find to community and the members/coders/staff to be very willing to answer and help you solve your problems.

[memobug]

uhmm cool, i don't want someone to walk me through it, for an open source project the documentation is limited and the community help is shocking...

nobody wants to help a new coder get off his feet...
i think you guys are stuck up!
I tried to help. It seems you just wouldn't answer my question

-- A stuck-up coder

[aussiev8]

its just an addon, never mind
i'll go about it on my own..
thanks to the guys that helpd.

[cinq]

I tried to help. It seems you just wouldn't answer my question

I think aussie knows how to code php/mysql in general, just that he wants to learn how to tie it in with vb using vb's various functions.

Please correct me if I am wrong.

[memobug]

Yes. I (still have) no clue from his post how, even generally, this encyclopedia was going to integrate with vbulletin. Did it appear on thread view and list every term on that page for definition? Did it appear beside a post? Was it somehow related to search? Maybe I'll never know.

Regards,

Matt

[aussiev8]

as i stated, i wanted it to be a thread view, (hence asking about how to make it look like the forum) sorry if i wasn't clear enough..

i just wanted it to act, for instance the same as "articles" this is the best way i could think of setting it out...

it'll have [a b c d e f g h i j k l m n o p q r s t u v w x y z ] in a bar
and when you click on a letter all of the definitions for that letter will come up!

ant
apple
ashtay

then when you click on the "ashtray" link it'll take you to a thread like view with the definition..

?? follow??

ps. i'm sorry i lost the plot, was just getting fed up with it not working the way i wanted it too.. i scrapped the previous attempt and will be a bit calmer and ask for help :)
i can't bevelie i make coporate fully interactive php styled secure sites, but i'm having trouble with this!

please someone either help me, or shoot me ;)

[rake]

start with a blank page,
require("./global.php");
to get the vb back-end, so you can access vb resources..

Get your database structure straight. One table should be enough to start with. Something like id ; title ; definition will work.

if($_REQUEST['do'] == showletter)
{
globalize($_REQUEST, array ('l' => STR));

$l = $DB_site->query("SELECT * FROM table WHERE title LIKE '$letter%' ORDER BY title ASC");
while($def = $DB_site->fetch_array("$l"))
{
.....
}
}

This should be enough to get you started. You can work your way up from there. If you don't know what something is, just search here, or through the vb files, and you'll find it.

[aussiev8]

how is it displayed on the screen for the user?

echo and print doesn't work,
i don't quite understand how it works