You are not logged in.

#1 2007-12-14 5:58 am

Russ
Guest

vBulletin info needed

I've had requests from people for an SQL script designed for vBulletin. vBulletin is not free software, and I don't own a copy so I do not know how the database is set up.

If you have access to a vBulletin site, I'm looking for info on the database schema so I can create a compatible SQL file.

#2 2007-12-22 5:00 pm

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

will sent you an layout later mate, what format would best suit you ????

edit : cant seem to find the mysql command to create the schema if you can post it i'll run it for you

Last edited by forrie (2007-12-22 5:22 pm)

Offline

#3 2007-12-24 3:49 am

Russ
Guest

Re: vBulletin info needed

Any format is fine, I can work with most anything. Do you need to email it to me?

#4 2007-12-25 12:25 pm

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

email inbound

Offline

#5 2007-12-31 6:55 pm

Russ
Guest

Re: vBulletin info needed

Hey, I got your email. Trying to get caught up here after the holidays. I think this has everything I need, thanks. I will try to start generating vB banlists now too.

#6 2008-01-01 5:58 am

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

np mate

here is the format on the admin side for banning users

for ip

66.36.229.205 219.84.134.235 200.89.251.61 87.118.106.177

for email domain

@mail.ru @bigmir.net @mymail-in.net

Offline

#7 2008-01-11 6:50 pm

Russ
Guest

Re: vBulletin info needed

Ok, so I've got a copy of the database schema (thanks again BTW) and I'm trying to figure out what I need to write an SQL file that can be used to import into vBulletin. I'm kind of stumped on which table is used for bans.

#8 2008-01-12 10:17 am

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

no specific table is used to ban users they are moved to the user group with a ID of 8 ( not the same for all forums depends on set up ), that when the user trys to logon the system pulls up that users access detials and moderates as required.

here is the list of standard usergroup ID's

unregistered/not loged in = 1
registered users = 2
users awaiting email confirmation = 3
COPPA = 4
super moderators = 5
admin = 6
moderators = 7

the system then uses

<if condition="!is_member_of($bbuserinfo, 5,6,7)"> <!-- hides stuff from all staff, for example forum adds -->

content to hide here

</if>

i hope that helps mate

Offline

#9 2008-01-12 10:22 am

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

i dont belive that information was in the data base in the first place.

i am also willing to give you access to the programmers documation that comes with VB. i will need to be emailed @ forrie@laventrix.com please make the title stand out as i get far to much spam every day

Offline

#10 2008-04-05 12:57 am

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

curious to know how you went on with that file mate???

Offline

#11 2008-04-16 4:56 pm

pedigree
uıɐbɐ ʎɐqǝ ɯoɹɟ pɹɐoqʎǝʞ ɐ buıʎnq ɹǝʌǝu ɯ,ı
From: New Zealand
Registered: 2008-04-16
Posts: 7,054

Re: vBulletin info needed

Just emailled you.  I run a vb site, have coded some plugins before and will start on a package for vb 3.6.8 (its all I have at the moment), that will start with

- ip / email / nick testing
- submit ip / email / nick from the user options, whos online and control panel if youre an admin and have a API key.

and move on to
- rbl dns looking on ip

Ive got a very large site onboard for using it as well, they get a lot of spam and are gagging for something like this.

Offline

#12 2008-04-18 12:04 am

pedigree
uıɐbɐ ʎɐqǝ ɯoɹɟ pɹɐoqʎǝʞ ɐ buıʎnq ɹǝʌǝu ɯ,ı
From: New Zealand
Registered: 2008-04-16
Posts: 7,054

Re: vBulletin info needed

latest vBulletin version here

http://www.vbulletin.org/forum/showthread.php?t=176481

There maybe a mirrored version on this site but keep an eye out for any updated versions on vBulletin.org.

This version does remote tests (and caches them locally) on new registrations (IP , username and email)

For those people without completely legal version of vbulletin, who cant download it from vbulletin.org, you can get a copy here

http://www.fizzleblood.net/vbStopForumSpam_v0.61.zip

Edit : 21 May 2008 - Uploaded version 0.4
Edit : 26 May 2008 - Uploaded version 0.6
Edit : 29 May 2008 - Uploaded version 0.61

Last edited by pedigree (2008-06-02 9:56 am)

Offline

#13 2008-05-02 3:06 pm

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

at a quick look the new vb software is going to reduce the spam on the site dramiticly

Offline

#14 2008-05-04 8:47 pm

pedigree
uıɐbɐ ʎɐqǝ ɯoɹɟ pɹɐoqʎǝʞ ɐ buıʎnq ɹǝʌǝu ɯ,ı
From: New Zealand
Registered: 2008-04-16
Posts: 7,054

Re: vBulletin info needed

Since I wrote it (make sure youre running v0.2 or better), its blocking about 2-10 registrations a day, not bad for a "what the hell, why not code it" plugin.  If I hadnt of been drinking at the time, I doubt I wouldve started

Offline

#15 2008-05-06 8:27 am

forrie
Member
Registered: 2007-12-22
Posts: 15

Re: vBulletin info needed

i'll test in in vb 3.7 once i finish updating my style should be with in the week

Offline

#16 2008-05-21 10:24 am

pedigree
uıɐbɐ ʎɐqǝ ɯoɹɟ pɹɐoqʎǝʞ ɐ buıʎnq ɹǝʌǝu ɯ,ı
From: New Zealand
Registered: 2008-04-16
Posts: 7,054

Re: vBulletin info needed

Bump as I uploaded version 0.4

Offline

#17 2008-05-21 10:44 pm

skippybosco
Member
Registered: 2008-05-21
Posts: 160

Re: vBulletin info needed

Great mod Pedigree, stopping quite a few on my site after just 8 hours.

Couple of suggestions:

1) Make the usernames in the VBStopForumSpam Log linkable to the user record so that when reviewing the log we can easily click to open that user and delete / ban

2) When adding the ability to "Add user to StopForum" I would love to see it in 2 places: a) the thread/post itself for deleting thread/post, deleting (or banning?) user and reporting to StopForum in one click b) the user drop down within a thread/post to delete and report user c) in the User record in Admin to select delete and report as a drop down option.

Offline

#18 2008-05-26 8:41 pm

pedigree
uıɐbɐ ʎɐqǝ ɯoɹɟ pɹɐoqʎǝʞ ɐ buıʎnq ɹǝʌǝu ɯ,ı
From: New Zealand
Registered: 2008-04-16
Posts: 7,054

Re: vBulletin info needed

Bump as I uploaded version 0.61

Last edited by pedigree (2008-06-02 9:50 am)

Offline

Board footer

Powered by FluxBB

Close
Close