sql querys to delete a member in vbulletin

[mlee]

Greetings all together.

Im writting a vbulleting integration script for an other cms at the moment and
need to know which sql querys i have to run to delete a user.

i know about

delete from $prefix."_user" where userid = '$id'
delete from $prefix."_userfield" where userid = '$id'

are there any more?

In fact i need to know what happens (sql querys) when i delete a user using the control panel.

Can someone help me out with this please?

With kind regards,

mlee

[Lea Verou]

Originally Posted by mlee

Greetings all together.

Im writting a vbulleting integration script for an other cms at the moment and
need to know which sql querys i have to run to delete a user.

i know about

delete from $prefix."_user" where userid = '$id'
delete from $prefix."_userfield" where userid = '$id'

are there any more?

In fact i need to know what happens (sql querys) when i delete a user using the control panel.

Can someone help me out with this please?

With kind regards,

mlee

It is not $prefix, it is TABLE_PREFIX.
It is not _user/_userfield, it is user/userfield.

[mlee]

Originally Posted by Michelle

It is not $prefix, it is TABLE_PREFIX.
It is not _user/_userfield, it is user/userfield.

Well i quoted that from my script
And yes you are right the underline is not needed there. Thx!

I guess you guys know what i mean.

I need the sql querys which are executed if you delete a member using the controlpanel.

So can anyone help me out?

Regards mlee

[Delphiprogrammi]

hi,

PHP Code:


$db->query("DELETE FROM " . TABLE_PREFIX . "user WHERE userid='$vbulletin->userinfo[userid]'"); 


or you could

PHP Code:

$id = $vbulletin->userinfo['userid']
$db->qyery("DELETE FROM " . TABLE_PREFIX . "user WHERE userid=$id"); 


that should work

[mlee]

Originally Posted by Delphiprogrammi

hi,

that should work

Hello Delphiprogrammi,

no you got me wrong, sorry my english is not the best.

I am not writting an vbulletin script but im modifing an other cms to work together with vbulletin.
I need to be able to delete vbulletin members by using the admin panel of the other cms. Therefore i need to know all sql querys which are executed if an user is deleted by the vbulletin control panel.
I dont want to make useless data stay in the database.
There are a lot of tables using userid as foreign key in vbulletin but i need to know which i i should delete when deleting a member.

Regards mlee

[Lea Verou]

Originally Posted by mlee

Hello Delphiprogrammi,

no you got me wrong, sorry my english is not the best.

I am not writting an vbulletin script but im modifing an other cms to work together with vbulletin.
I need to be able to delete vbulletin members by using the admin panel of the other cms. Therefore i need to know all sql querys which are executed if an user is deleted by the vbulletin control panel.
I dont want to make useless data stay in the database.
There are a lot of tables using userid as foreign key in vbulletin but i need to know which i i should delete when deleting a member.

Regards mlee

Try to look at the code that is executed when vb itself deletes a user

[mlee]

Originally Posted by Michelle

Try to look at the code that is executed when vb itself deletes a user

That was what i tryed first but i was not able to find it.

[Lea Verou]

Originally Posted by mlee

That was what i tryed first but i was not able to find it.

Yeah, I know... Those files are huge
I haven't seriously looked at a single vbulletin file for all the hacks I've made... I just can't find my way over there :ermm:
So, the correct answer imho (and more likely to be replied) is "Where can I find the code that vbulletin uses to delete users?"

[mlee]

Originally Posted by Michelle

I just can't find my way over there...
"Where can I find the code that vbulletin uses to delete users?"

Same here.

I can agree on that one
So my new question is:

Where can I find the code that vbulletin uses to delete users?

Regards mlee

[Paul M]

vbulletin deletes the user from user, userfield & usertextfield and sets the userid to zero in all posts they have made. It also removes userid based entries from a whole host of other tables.

It's a bit harder to track the code now because it uses the datamanager.