vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Query to add user on VB 3.6.8 (SQL) (https://vborg.vbsupport.ru/showthread.php?t=163572)

stoppy 11-25-2007 02:05 PM
Query to add user on VB 3.6.8 (SQL)
 
Hi!

I'm looking for a correct SQL query to add a user on the db of vbulletin.

I have these variables:

username, email, SAL, password (md5(md5(userpasswd).SAL))

I'm trying to bypass vbulletin registration using the one I use on my system.

Can someone help me?


Thanks
Peppe

Opserty 11-25-2007 04:00 PM
<a href="https://vborg.vbsupport.ru/showthread.php?t=82836" target="_blank">Add new Users (automatically)</a>

For an exact SQL you'll probably have to look through the User Datamanger

stoppy 11-25-2007 04:26 PM
Quote:
Originally Posted by Opserty (Post 1389211)
Add new Users (automatically)

For an exact SQL you'll probably have to look through the User Datamanger
What do you mean exactly?

Thanks

Eikinskjaldi 11-25-2007 08:39 PM
vbulletin uses datamanager classes for manipulating complex objects (such as users, threads, forums) in the database. They can be found in the includes directory, with names like class_dm_user.php.

If you look inside this file you will see how VB adds users, and even if you are bypassing the vb login page you could still use the vb system for user addition.

stoppy 11-25-2007 08:49 PM
Quote:
Originally Posted by Eikinskjaldi (Post 1389324)
vbulletin uses datamanager classes for manipulating complex objects (such as users, threads, forums) in the database. They can be found in the includes directory, with names like class_dm_user.php.

If you look inside this file you will see how VB adds users, and even if you are bypassing the vb login page you could still use the vb system for user addition.

I will take a look.

Right now I wrote a code that could solve the problem.

I will post, we can talk about it if you want.

:rolleyes:

--------------- Added [DATE]1196031048[/DATE] at [TIME]1196031048[/TIME] ---------------

I wrote this. I looked the database trying to add a testuser and seeing what appens inside...

What do you think about?

PHP Code:
<?php

/* Here there is a code I wrote for test and to discuss with you*/

$usergroupid = 2;
$username = *USERNAME*;
$password = *PASSWORD* //md5(md5(inputpassword).*SALTCODE*)
$passworddate = YYYY-MM-DD; //of today
$email= *EMAIL*;
$usertitle = *"Junior Member"*;
$joindate = $lastvisit = $lastactivity = time();
$timezoneoffset = 1; //CET +1
$options = 159; // what is it??? I copyed it from my user regular registered by vb
$languageid = 2; //for me is Italian
$autosubscribe = 1; // I want it, -1 value to disable.
$salt = *SALTCODE*;

$location = *MYLOCATION*;

$tabprefix = "vb_";

//BEGIN

$query_insert_user="INSERT INTO `".$tabprefix."user` (`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `importuserid`) VALUES (NULL, '2', '', '0', '$username', '$password', '$passworddate', '$email', '0', '', '', '', '', '', '', '', '1', '2', '$usertitle', '0', '$joindate', '0', '$lastvisit', '$lastactivity', '0', '0', '0', '10', '5', '1', '1', '0', '0', '0', '0', '$option', '', '0000-00-00', '-1', '-1', '', '0', '$languageid', '0', '0', '$autosubscribe', '0', '0', '$salt', '0', '0', '0', '', '0', '0', '0')";

mysql_query($query_insert_user);

$lastid=mysql_insert_id();

$query_insert_user_field = "INSERT INTO `".$tabprefix."user_field` VALUES ('$lastid','NULL','$location','','')";

mysql_query($query_insert_user_field);

$query_insert_user_textfield = "INSERT INTO `".$tabprefix."user_textfield` VALUES('$lastid','NULL','NULL','NULL','NULL','','NULL','NULL')";

mysql_query($query_insert_user_textfield);

//END

?>
:up::down:???

--------------- Added [DATE]1196031963[/DATE] at [TIME]1196031963[/TIME] ---------------

Quote:
Originally Posted by Opserty (Post 1389211)
Add new Users (automatically)

For an exact SQL you'll probably have to look through the User Datamanger
Sorry :eek: I had not seen the link you gave me!!!

Marco van Herwaarden 11-26-2007 04:17 AM
Dont use queries to directly insert a user, use the DataManagers.

stoppy 11-26-2007 05:41 AM
Quote:
Originally Posted by Marco van Herwaarden (Post 1389474)
Dont use queries to directly insert a user, use the DataManagers.
I saw the thread that explain how to use it but I think is for an old version respect 3.6.8 I'm using.

The constructor of the class take 3 parameters, I have 2 parameters.
Can someone tell me ho to exactly use it in my code?

Thanks


All times are GMT. The time now is 02:52 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.00989 seconds
  • Memory Usage 1,749KB
  • 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
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete