A Favour

[Dean C]

Hi,

Firstly i'd like to ask a few questions which lead to a request. This willl be a vbulletin hack but should only lead to the upload of a file to the forum directory. It will have relevance to anyone here and no importance. Basically it's to help my cousin with some maths coursework he's doing.

Now to the questions:

- What is the purpose of the 'word' table in the vbulletin database?
- Are duplicate words stored in the word table?

Thanks in Advance

- miSt

[Dominick]

bash-2.05a$ grep 'DB' *.* | grep 'word'

search.php: if ($DB_site->num_rows($sqlwords)) {
search.php: while($thisword=$DB_site->fetch_array($sqlwords)) {
search.php: $DB_site->free_result($sqlwords);
search.php: $posts=$DB_site->query("SELECT postid,wordid FROM searchindex WHERE $andor $intitle");
search.php~: $sqlwords=$DB_site->query("SELECT wordid,title FROM word WHERE title LIKE '".addslashes($val)."'");
search.php~: if ($DB_site->num_rows($sqlwords)) {
search.php~: while($thisword=$DB_site->fetch_array($sqlwords)) {
search.php~: $DB_site->free_result($sqlwords);
search.php~: $posts=$DB_site->query("SELECT postid,wordid FROM searchindex WHERE $andor $intitle");
bash-2.05a$

looks to be part of the search engine

[Xenon]

in the word table all words which occurs in posts and are indexed are saved there.

no, no duplicate words are saved.

each word get's a unique id, and whenever a word occurs in a new post which already exists in the word table, nothing will be added. the searchindex instead stores just the wordid's which occur in the posts.

[Dean C]

Ahhh this is perfect for what i need. Now comes the hard part. I'll post it up tonight.

Thanks

- miSt