vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Change Username via UserCP v2.0 (https://vborg.vbsupport.ru/showthread.php?t=24722)

Pie'oh'pah 08-29-2001 12:40 PM

Yes mate the line is applied.

Usernames are mostly like this:

[NÐE]-=Pie'oh'pah=-

and this one is working perfectly, even with the ' in it.

It only happens to a few poeple. [LoC]Racoon for example

-Alex

Writers Blockk 09-03-2001 06:36 PM

I'm not sure how to do the beginning part:

Quote:

The first thing you got to do is run these two sql queries which will create variables for use, either via phpMyAdmin

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Posts to change username', 'postuserchange', '50', 'Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.', '', '18')

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Days between user change', 'dayuserchange', '7', 'Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.', '', '19')

OR

go to http://www.yourdomain.com/forums/adm...php?action=add
Setting Category: User and registration options
Title: Posts to change username
Variable Name: postuserchange
Value: 50
Description: Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.
Code to generate option: LEAVE THIS BLANK
Display Order: 18

Setting Category: User and registration options
Title: Days between user change
Variable Name: dayuserchange
Value: 7
Description: Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.
Code to generate option: LEAVE THIS BLANK
Display Order: 18

Adding a table to your forums database
I saw that in my phpadmincenter but I had no idea how to change it or what, I didn't see any add or edit button. It's a bunch of stuff I'm not sure to do, that's the only part I'm not sure what to do on. Can someone help me?

Pie'oh'pah 09-03-2001 11:53 PM

You need to have phpMyAdmin installed.

If you do, you go to your database by clicking it's name on the left.

You'll see it's tables listed and right under it, there's a textfield named

Run SQL query/queries on database 'database name'

This is the field where you drop the text (querries)

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Posts to change username', 'postuserchange', '50', 'Number of posts required for the user to change their own username within the user control panel. If you wish anyone to be able to change username set to 0.', '', '18')

INSERT INTO setting (settingid, settinggroupid, title, varname, value, description, optioncode, displayorder) VALUES ('', '6', 'Days between user change', 'dayuserchange', '7', 'Number of days between each time a user is allowed to change their nickname. If you wish the user to be able to change username at any time set to 0.', '', '19')

and run them by pressing GO

You can run both INSERT's mentioned at the same time, or one after another.

However, since you are obviously not familiar with phpMyAdmin, make sure you backup your database before messing with it!

-Alex

Writers Blockk 09-04-2001 08:51 PM

Ok I see that now, I just put that stuff in that big box then hit go?

Well in that box it says this before I did anything:

Quote:

SELECT * FROM setting WHERE 1
That was already in there, do I remove that then add that stuff and hit go?

Also how do I back up my database? lol

Sorry, fairly new at this heh.

Thanks

Pie'oh'pah 09-04-2001 10:23 PM

No problem :)

Yes, just remove that line

afterwards run those querries mentioned above.

The backup is done either via the adminCP of you vBulletin or the phpMyAdmin tool.

Using phpMyAdmin, you need to dump (thats the term for backing up) the database, by selecting Structure and Data and Send.

You may select Add drop tables, too. This tells it, to drop existing tables before restoring your database from the backup. It prevents the Table already exists error.

When you checked all the boxes I suggested, press GO and you should be getting a dialog on where to store the file on your local PC.

Depending on the size of you database, the connection and the speed of Server, the proceedure may take some minutes.

hth

-alex

Writers Blockk 09-04-2001 10:48 PM

Ok I'm pretty sure thats finished lol.

I'm now not sure about this part :(

Quote:

Adding a table to your forums database
---------------------------------------
Now you will need to create this table for logging of the username and last time they updated.

CREATE TABLE namelogs (userid INT (5) not null , usernames LONGTEXT not null , lastchange INT (12) not null )

Adding New Templates
Am I still in the the phpadmincenter for this? If so I see nothing about create new table, I see rename to: and Copy table to:

Then I see table maintenance and table comments.

I'm confused lol

Writers Blockk 09-04-2001 11:22 PM

Now I get an erroer when people try to register and when I tried to access the edit options and change profile and change password all in user control panel. It says

Quote:

Parse error: parse error in /home/ashleigh/public_html/forum/member.php on line 1337
Hmmmph

Pie'oh'pah 09-05-2001 12:59 PM

Hey,

sorry i havent said this, yes

CREATE TABLE namelogs (userid INT (5) not null , usernames LONGTEXT not null , lastchange INT (12) not null )

is to run with phpMyAdmin, too. Just paste this and hit GO
This is the last you need to do within phpMyAdmin.

Regarding the parse error you get, thats probably because the hack is not yet completely done.

As for the next step, adding templates, this is to be done in your adminCP

After you created those templates, the last step is to edit the necessary php-files.

I recommend making a copy of the orignals as well.
Just in case you haven't got a good editor, I would also recommend UltraEdit

Ok, hope this is it :)

-Alex

Writers Blockk 09-05-2001 03:20 PM

I did everything and the only wrong still is the pasre error, I redid it and everything

Scott MacVicar 09-05-2001 04:33 PM

paste the contents of member.php

1330 to 1340 please

I'm thinking you have pasted some code in at the wrong point.


All times are GMT. The time now is 08:21 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01141 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete