The Arcive of vBulletin Modifications Site.

I am going to go insane..... · **Released**: 04-01-2002

Ok....I know my php...im just not to good with mysql because my comp won't let me install mysql so I have no way to view my database and get a better understanding of it. Any ways here is my problem....

the admin/functions.php file uses the $post[field7] for custom fields.(the custom ones are 7, 8, 9, 10 and so on...) anyways I want to put them on my forum homes as well as any other page I think it would belong on. I figured this would be easy to find the mysql command to pull from database...well i was wrong...
So basicaly i need to know the coding to type to
A.) gather custom fields into a array on my index page
B.) Update the changes to the database fields for the custom fields section.

I am barely maintaining sanity becuase of this so please help.
Also if you know a way to make it custom fields global variables I would very much appriciate it.

*sigh*

Logician · #2 04-01-2002, 08:46 AM

ok I am not writing this at home so I cant access my vbulletin db and I may be wrong, but this should work:

There is pre-definded object in vb code that make queries for you in vb db and you can use it for your queries. Eg.

Defeine your query like that:
$your_query=$DB_site->query("
SELECT s.userid, u.username FROM subscribethread s, user u WHERE u.userid=s.userid AND s.threadid='$threadid' ORDER BY u.username");

Then get the result like this:
$your_result=$DB_site->fetch_array($your_query);

As for profile fields I need to take a look at table structure, but if I'm not wrong it was in "user(s)" table.

Regards,

zajako · #3 04-01-2002, 02:54 PM

I knew about the query object...
but I just don't know where the acutal custom profile fields are. plus I am not good at formating the actual query.

I wish I was able to see my mysql database...but mysql rejects my comp when i try to install it. I need to make a dual boot for win 98 so i can...