You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#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
Pages: 1