Inspiron
May 19 2005, 03:17 PM
| | Hi, I've just created a new forum.. I've also create many test accounts to make sure my groups are working with its permissions. Now these test accounts takes up "member number". When I remove these test account, the "member number" don't seem to reset, instead it keeps raising.. So in the end, there's a huge gap in member number before the next real member.
I'm wondering anyone knows how to reset this member number thing so the gaps are removed. Board is Invision version 1.3 |
Reply
Hamtaro
May 19 2005, 09:53 PM
Well, the member number, I believe, is an auto increment number in the MySQL database. So, you would have to run this query: CODE ALTER TABLE table_name AUTO_INFREMENT=# Set table_name to the name of the table with the member data in it. And set # to the number that you need to reset it to.
Reply
Inspiron
May 20 2005, 04:48 AM
How do I start ? I have no knowledge in SQL... Step by step guide is very much appreciated.. Thanks Hamtaro in advance..
Reply
hype
May 20 2005, 07:59 AM
Go to AdminCP => SQL Management => SQL Toolbox Scroll down to the very end and there's a text area input there. Copy the code posted by Hamtaro and paste it into the box, then run the query by click the submit or whatever it is( I forgotten the name of it.)
Reply
Inspiron
May 20 2005, 03:29 PM
I couldn't find the option "SQL Management => SQL Toolbox" I'm using the free remote forum provided and hosted by Invision itself.. Is there another way of doing it ?
Reply
guangdian
Oct 21 2005, 02:03 AM
i'm afraid you can not do something with that. it hiden in the mysql database,.how you will change it from that/ you can not i think.
Reply
Ao)K-General
Oct 21 2005, 02:50 AM
Those are really old. I wish we could get a better version of IPB. But I think thats the best it will go. It sucks really.
Reply
Gyad
Oct 21 2005, 02:57 AM
Yeah, I don't think you can change the number then. You could always just register for another account. Its one of those free ones right? And yes, it does suck that IPB asked Fantastico to removed 1.3 from it and changed it to 1.2 .
Reply
michaelper22
Jan 5 2007, 03:03 AM
If you are using one of the freely hosted forums, they might not provide you with the SQL Toolbox (which I must say s pretty neat). Generally they won't give several other advanced features either.
Reply
Recent Queries:--
ipb member number - 51.87 hr back. (1)
-
ipb remove inactive member forum - 93.80 hr back. (1)
Similar Topics
Keywords : invision forums member reset member- Get Paid To Post On Forums?
- Links, Resources for Pay for Writing, Earn from Forums (17)
Get Paid to Post on Forums I have seen these all over, could people maybe give me a
short list on where I could post on forums and get paid? I am a freelance writer, and I know this
is one option. I tried searching it, but word of mouth always works best. Thanks in advance!
Note: Please move if needed, I wasn't sure if I should do it in the Make Money forum, or not.
At Trap17.com - This very site, You get paid in terms of CREDITS. These credits are used to keep up
your Web Hosting account (which we give for FREE). The Web Hosting is of top ...
I'm A Hosted Member... Right? [resolved]
- I got my hosting request accepted, but where's my account? (11)
I already had my account closed (which means accepted) but I can't post in the members' only
forum! How come? Please help me....
Which Forums Would You Prefer?
- Good for people creating communities... (13)
I'm using InvisionFree board... I wanna know what others think about other boards and their
reasons for it......
Get A Hosting Space With Post In This Forums ?
- (1)
Downloading From The Forums
- (4)
I hope this is the right place for this. I tried searching a couple of different ways, but
didn't find anything. I guess this would be for an admin, but if anybody knows the answer.... I
saw an e-book I wanted to download from the forum, everytime I try to, I get a board message telling
me something about I don't have access for this. What do I have to do to be able to download
attachments from the forums?...
Hello Everybody (new Member)
- (6)
Hello everybody. i am a new member. Hope your help much. Thanks...
Which Forums Should I Use
- (2)
I am going to get hosted again in the near future. i do not feel like going through that hassle of a
home page and stuff. I was wondering what is the best forum that can be installed from Fantastico in
the Cpanel. In your opinion which is the best. I have already tried phpbb and i liked it. But i
would also like to know about any other ones that might be good. If you have an example of one of
the other forums please leave a link so i may check it out. Thanks....
Flashback - Trap17 - 5 Years Ago
- Before the Free Hosting and Forums! (7)
Flashback... Well I was browsing Archive.org and figured what the heck... so I typed in Trap17
and WOW. Would you believe what a long way we have come with the main page and stuff. Also the
quality, if I had seen the main page back in 2001 or 2002 before July 25... it looked bad and looked
like a crappy hosting. But like anything else over time it gets better and we improve on our
mistakes. /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> And
thats what made Trap17.com the place it is today. And what was with that red spider web an...
Daylight Savings Time
- Reset tonight (17)
Just in case there are questions about it, this is a reminder to check the Clock settings of your
computer and also the Time Zone settings on all of the Forums you attend. Some Forums do not allow
for Timezone and Daylight Savings Time to be adjusted automatically....
Do You Ever Feel Like Giving It All Up?
- Forums, websites, the internet... (15)
I've made all sorts of online friends in the past, and I got bored and just moved on. Now
there's a new group and I just don't know. Maybe it's because I've spent this
Saturday night having a few drinks and sitting on the internet with nothing to do. Does anyone else
ever feel like just giving it all up? I feel like I am stuck in a rut. I haven't learned
anything new design wise lately, either. That usually makes all of this exciting again. Has anyone
else ever thought like this? What did you do about it? I'm such a nerd. /sad.gif" style="...
Changing Webhosts
- I won't leave the forums, though. (2)
Hello all, I will soon be looking at some paid web hosting. I loved every minute of being with
Trap17 and I would like to say that I will not be leaving the forums. I enjoy reading some of the
material on this site and I have adopted it as one of my often visited communities. Also, a big
thanks goes out to buffaloHELP for helping me when I made a mistake and approving me for hosting.
Trap17 is a great web hosting solution and I am surprised that not many people know about it. But
anyways, not too sure that too many people really care as this thread was directed more towa...
Rate The Person Who Posted Before You
- rate them on what you think, and how good they are to the forums (2)
I have seen this on other forums where someone starts a topic and the person who posts after that
will rate the person before them...make sence?? ok well if it does why not give it a try? So
since there is noone for me to rate i will not rate anyone >_ /laugh.gif"
style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> *edit* gunna be more
descriptive on the rating... you can give them a #/10 and also give a reason why you give this
number rating so high, or so low....explain why you like them, maybe even what you know about
them...etc *edit*...
Activex Error Messages? And Popups?
- Are these normally on the forums? (2)
While browsing the trap17 forums today, two things strike me as weird. While I was hanging around
the forum index, I get a popup from a website , which my browser claims came from this website. But
since when did Trap17 use pop-up advertising? At the same time, the following error message
appears: QUOTE Your current security settings prevent ActiveX from being displayed. As a
result, this page may not work correctly. (Or something very close to that, you can't copy
error message text.) This message popped up again while I visited a few topics, but I have ...
Can You Use A Login Script To Login To Forums
- from outside of the forum itself? (3)
The title and description of this topic should tell you my basic question, but it's never enough
detail just to read a question, so I will explain my intention. Basically, on my website I have a
php script for users to register to my site. I then use this data to create forum accounts (I do not
use the main forum Registration form because I cannot change it's contents and there are some
questions I'd like to ask before registration). Later I also plan to make hidden areas that you
need to register for to enter. Anyway, I wondered if it was possible to make ...
I Must Be Confused (returning Member)
- is this the same place from a year back (1)
1) Is this or was this originally kalacreations.com run by Mstr aka Dediana87 (or close) 2) if yes
then why doesnt my old log in of andover work 3) wow this place changed ALOT Refrain using
expletive words! Editing your title. ...
Color Codes For Forums
- (3)
Anyone here know the color code thingies for forums. you know like yyyyy is yellow or whatever, i
need to know the codes for Gray, Black, Red, and white so please pm me if you know them...
Need Some Help With Website
- im a new host member but I have no idea what to do know... (2)
was so glad My application for free hosting Package 2 was approved! I'm now at the cpanel
site...you now http://yoursite.com/cpanel and I have noooo idea what to do next!! I want
to make a site...I have a site saved in Frontpage...so does anyone know how to upload it or
something...I've never did this before so I have no idea. I also would like to work with
HTML....but how do I do this...I mean is there anywhere a place in the menus where I can upload it ?
I'd really appreciate anyone helping me. I couldn't find a help topic anywhere on t...
How Do You Make A Thingy Like Marquee
- How To Do Whats On Top of TRAP17 Forums Pages (5)
How Do You Do This: Its Like a Marque, But Acts Like a GIF, The One On the Top of TRAP17 Forum
Pages. I Really like to know how to do this....
Cool Forums!
- (1)
Look this forums! /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' />
PLEASE REGISTER THERE!! /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> They are great how do you rate them!!...
Forums Hacks
- (2)
Is there any chance of having either:
http://www.phpbbhacks.com/download/248 or
http://www.phpbbhacks.com/download/2331
this hack installed? The first one would allow
moderators to lock a topic as they post. Saving the trouble of going back to it after posting.
The second allows you to move a topic at the same time as you lock it (ideal for account creators).
Thoughts?...
phpnuke forums....
- (5)
hi i get this when i access the forums admin cp
Parse error: parse error in
/home/www/ngageroms.freeownhost.com/modules/Forums/admin/index.php on line 623
code
attached <?php /*************************************************************************** *
(admin) index.php *
------------------- * begin : Saturday, Feb 13, 2001 * copyright
: (C) 2001 The phpBB Group * email : support@phpbb.com * *
$Id: index.p...
Suggestion: clean up the forums :
- (16)
It seemed like a good idea to me that when FNH officially merges, this forum should be cleaned up.
With this I mean getting all non stickied posts out of the way, because the forum is filling up too
much now (my opinion), what do you think?...
Before open request hosting - remove all old inactive member
- (11)
Just a suggestion, also the members have been asking that we remove all the old inactive members
from the forum.
I feel that if you guys wanna do this, it is done before we open the request
forum. This will make it easier to remove hosting from those who have been inactive.
Thoughts?...
Forums Rules & Important Information ~ Updated 12/03/05
- (0)
Welcome To Free Nuke Hosting
Index
1. Forum Rules
2. Terms of Service
3. Music Rules
4. FAQs
5. Trading Market
********************************************************************
Please read carefully so that
you do not get in trouble with the site staff.
*********************************************************************
1. Forum Rules
You are not allowed to Post:
Links To:
Child Pornography
Adult Content
Torrents files
Warez (P2P)
Illegal Content
Posts Should Not Include:
Spam
Cracks Or Ser...
Stoned Devil Inc. & Free Nuke Hostin Forums?
- (14)
Might I make a suggestion regarding the recent partnership of Stoned Devil Inc. and Free Nuke
Hosting.
My suggestion is that instead of having a forum at Free Nuke Hosting and a forum at
Stoned Devil Inc. why not just have the one? I feel that the larger community is here, at FNH
rather than at Stoned Devil Inc.
Surely it would benefit both sites if the main area where
webhost and web design was in the same forum.
Any way this is just my thoughts. What do you
think?
Haz...
remove spam corner forums google rules
- (1)
Hello please remove the spam corner forums google will shut the down the ads because of the spam
corner....
Invision board VS phpbb
- (84)
which one do you like better?
feel free to post your comments here!
* I like IBP better,
because it's easy to manage and other than that, it's has more modifications than Phpbb.
I am using
a 2.0.0 now, and i really like it! /smile.gif' border='0' style='vertical-align:middle'
alt='smile.gif' /> ...
New Forums
- (51)
If you want new forums to be added, please reply to this message /smile.gif' border='0'
style='vertical-align:middle' alt='smile.gif' />
Tell me clearly the title of the forum and what
it's about /wink.gif' border='0' style='vertical-align:middle' alt='wink.gif' /> ...
PHPbb or invision?
- (16)
can somebody help me what are the benefits of both?
TNX
Poll added by CodeFX ...
Our Blessed FNH Forums
- (5)
Uhm... Is it just me - i miss these forums, they're nicer to post in than the constricted - not nice
layout VAIO forums...
Can admin transfer the forums over? Surely he can...
Oh and, plz post
your comments and opinions below too /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> ...
Looking for invision, forums, member, number, reset, member, number
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for invision, forums, member, number, reset, member, number
*MORE FROM TRAP17.COM*
|
advertisement
|
|