Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 02 Jan 2016, 17:36
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
Issue with MyBB to vBulletin Import

Okay so, I went to import MyBB to vBulletin. The importing was successful, however there we're two issues.

1. The account birthdays we're imported as invalid dates.
2. The IP's we're imported incorrectly because of the way they are stored in the MyBB database, which is different from vBulletin.

The first was fixed by running a sql query that resets everyone's birthdays

For the IP issue, I want to run a sql query that will reset everyone's IP to nothing, which will auto-correct as people login.

If you can help me with a sql query that will take care of the second issue, I would appreciate it.

Thank you,
Reply With Quote
Comments
  #2  
Old 02 Jan 2016, 20:50
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Are you talking about the IPs that show in the posts? Or the IP that shows in the admincp when you look up a user?

(And if you set either of those to nothing, they will not auto-correct unless you write some code to do that)?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 02 Jan 2016, 21:13
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
I thought that when you look up a person's ip, that the ip you find, is the one that is recorded as of the person's last login/post?
Reply With Quote
  #4  
Old 03 Jan 2016, 21:58
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
Anyone able to offer any support?
Reply With Quote
  #5  
Old 03 Jan 2016, 22:02
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
vBulletin does not store the last login IP. The IP you see in the admincp is the IP address of the user when they made the account.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #6  
Old 04 Jan 2016, 01:14
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
Are you sure about that? Then what about the ip address that gets recorded when someone makes a post?
Reply With Quote
  #7  
Old 04 Jan 2016, 01:28
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
That's stored in the post table.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #8  
Old 04 Jan 2016, 01:41
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
Hmm. Then, I'm not sure how to fix this problem then...
Reply With Quote
  #9  
Old 04 Jan 2016, 14:49
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
You could create a hook at login_verify_success with the following query:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This will update the IP address column in the user table every time the user logged in.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #10  
Old 04 Jan 2016, 19:23
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by Seraphyn View Post
Are you sure about that? Then what about the ip address that gets recorded when someone makes a post?
Positive. The ipaddress in the user table, the same one that shows in the admincp, is the one the user used to register the account. The IPs in the post table are the IP used to make that specific post.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #11  
Old 04 Jan 2016, 19:38
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
Originally Posted by Dave View Post
You could create a hook at login_verify_success with the following query:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This will update the IP address column in the user table every time the user logged in.
Any idea how to implement this? Is this just a query I need to run or a template edit?

Thank you,
Reply With Quote
  #12  
Old 04 Jan 2016, 19:44
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by Seraphyn View Post
Any idea how to implement this? Is this just a query I need to run or a template edit?

Thank you,
You need to create a plugin. Follow:

AdminCP -> Plugins & Products -> Add New Plugin

Product: vBulletin

Hook Location: login_verify_success

Title: Add IP Address To user Table

Execution Order: 5

Plugin PHP Code:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Plugin is Active: Yes

Then click "Save".
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #13  
Old 04 Jan 2016, 19:45
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
https://www.vbulletin.com/docs/html/...rsion=30506500

Product name: vBulletin
Hook: login_verify_success
PHP code: the one I just posted
Active: yes

Edit: Mark faster than me.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #14  
Old 04 Jan 2016, 19:58
Alice Alice is offline
 
Join Date: Mar 2013
Real name: Alice
Thank you, everyone in this thread has been very helpful and I appreciate it.

Thank you,
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 10:26.

Layout Options | Width: Wide Color: