How to Change Join Date on InvisionFree?

[xxxtentacion]

Hey Guys, I have a question about InvisionFree.

 

I was wondering if there is a code or anything similar to allow Admins to change a users join date? I know this forum doesn't run on InvisionFree, but for example, illspirit's join date is on a certain date in 1976, and I would like something similar to that to be done. I also heard that it is possible via phpMyAdmin and MySql, and if this is the only way possible, I would like to know how to do that method.

 

Regards, Pyro.

[K^2]

You need to run a querry on database that will update the join date value in the relevant table. The simplest way would be to try and find a plugin that does that for you. Failing that, you can run that querry by hand. phpMyAdmin should let you run a custom querry. Or you can just SSH into the server and rum mysql.

 

Either way, if you have to do it by hand, the querry will look something like this.

 

 

 

UPDATE users SET joinDate = 'date string with right format' WHERE userID = 123

Now, the tricky part is that you need to know the correct name for the table (it's probably not just users), the name of the value you are trying to change (e.g. joinDate), the name of the field that holds user's ID (e.g. userID) and the actual user ID (e.g. 123). You can also try locating the relevant row via user's name. Procedure would be similar.

 

There are ways to find out all of these things by running other querries. Specifically, once you have the database selected (hopefully, phpMyAdmin will handle that for you, other wise, you have to use querry with the USE command) you can ask it to show all of the tables with querry SHOW TABLES. Once you find the table there that looks like it's the one you want to modify, you can querry for the names of the fields it contains.

 

 

 

SHOW COLUMNS FROM users

Again, "users" here is just for sake of example. Use whatever table name that you found in the step above. Once you found out what the relevant fields are called, you need to take a look at the actual format of the join date string. To do that, you can just pull up the record for the user you are going to modify.

 

 

SELECT * FROM users WHERE userID = 123

This will show you all of the info stored for a particular user.

 

 

If you want to be able to do all of the above quickly, without having to log into the database every time, and you can't find a ready plugin for your forum, you can write your own PHP script for it. Since it doesn't need to be terribly secure, you can just make it accept a form with some sort of a pass code you'll give out to admins. Then, all that script needs to do is run the UPDATE querry via mysql. You can look at example code for database manipulations with PHP. It's very easy stuff. Of course, if you have zero experience with PHP or coding in general, that might still be a bit much. You can always ask someone to write that script for you, though.

[Spider-Vice]

There is a small issue with that. InvisionFree is a pre-hosted forum solution. You would need to have access to the whole server (i.e. if you bought yourself a dedicated web server) to access phpMyAdmin or execute an SSH shell (via either CPanel or remotely). I don't think you can do that at all, given InvisionFree, well... it's basically you being a customer on someone else's server, which means you don't get to access the databases, for obvious reasons.

[K^2]

Hm. Don't they usually give you phpMyAdmin, at least?

[BamBamtheBlonde]

Hm. Don't they usually give you phpMyAdmin, at least?

You get a Admin Control Panel but doesn't allow you to change the join date of registered members.

 

It may be possible to change it using a JavaScript of some kind. (Not 100% sure though as I haven't looked for InvisionFree codes for a while, used to sign up and experiment with the Board Wrappers myself. I also inserted other peoples code to see how it looked on my forum(s) and figure out how the code actually worked, sometimes try to do my own version.)

But try these two forums, they have a huge database of IF codes and modifications.

InvisionFree's Code Support Forum -> http://if.invisionfree.com/forum/1000324/

Big Boards -> http://s7.zetaboards.com/bigboards/index/

 

Sorry I couldn't help you any further, good luck on those support forums with hopfully finding what you require.

[Sentrion]

A bit of old topic though, but you can't change any database related details on InvisionFree Forums as they do not give any access to cPanel or phpMyAdmin. The best thing is to migrate from IF, if you want to have any such modification ability.