ClanTemplates

[NamUrPosion]

I need help finding a code which will allow me to send information to a custom sql database table when a user registers on the site.. I cannot find any website which has the information i need..

I need the plugin to send information to the following database table..

cs_bio

pemail varchar(100) cp1257_general_ci No
id int(11) No auto_increment
username varchar(25) cp1257_general_ci No
alias varchar(75) cp1257_general_ci No
country varchar(10) cp1257_general_ci No
facebook varchar(150) cp1257_general_ci No
rig varchar(120) cp1257_general_ci No
processor varchar(50) cp1257_general_ci No
ram varchar(120) cp1257_general_ci No
videocard varchar(50) cp1257_general_ci No
mouse varchar(50) cp1257_general_ci No
keyboard varchar(50) cp1257_general_ci No
headset varchar(50) cp1257_general_ci No
favoritegame varchar(50) cp1257_general_ci No
monitor varchar(50) cp1257_general_ci No
msn varchar(50) cp1257_general_ci No
gmail varchar(50) cp1257_general_ci No
skype varchar(50) cp1257_general_ci No
xfire varchar(50) cp1257_general_ci No
aim varchar(50) cp1257_general_ci No
age varchar(10) cp1257_general_ci No
avatar varchar(100) cp1257_general_ci No /uploads/avatars/noav.jpg
joined date No
xp varchar(255) cp1257_general_ci No
teamname varchar(255) cp1257_general_ci No
email varchar(50) cp1257_general_ci No
kills varchar(50) cp1257_general_ci No
deaths varchar(50) cp1257_general_ci No
fid int(11) No
rank varchar(50) cp1257_general_ci No
quote varchar(150) cp1257_general_ci No
website varchar(100) cp1257_general_ci No
guid varchar(50) cp1257_general_ci No
fa varchar(3) cp1257_general_ci No
fam varchar(255) cp1257_general_ci No
banned varchar(1) cp1257_general_ci No 0
bandate date No
reason varchar(255) cp1257_general_ci No
admin varchar(100) cp1257_general_ci No
xbox varchar(100) cp1257_general_ci No
PS3 varchar(100) cp1257_general_ci No
credits varchar(100) cp1257_general_ci No 0
chat

If someone with VB knowledge could help, i would really be grateful...:notworth y

The entries i would like auto matic entered are in red text..

[Russ]

You might have better luck posting over at vbulletin.org, they handle a lot of the modding for vbulletin and it would be a great asset to you.

[CS-Chris]

Also you need to remove this database from public view as well . Thanks

[NamUrPosion]

whelp.. no harm in this, it is just a database post.. im just trying to get something usefull done chris..

[NamUrPosion]

ill post on the vb site too.. i tried there before, but not much on the answer side..

[pqrs633]

这是新加的空白文章13，可以在ubb可视化编辑器中，添加和修改文章内容。

[510carlos]

Who handles the register? vBulletin or CS script?

[Huggy]

Just add another query in where the new user is added in the database.

[NamUrPosion]

where at in the vbulletin settings do i add this?

[NamUrPosion]

vbulletin is the main database, CS is just an addon to the systems back end.. right now you have to double register with the site.. and in doing so, the ID's do not match and make programing additions to the system harder.. i am trying to defeat this problem by making vbulletin send the requested data to the cs table on register.. i know this can be done, but looking at vbulletin code is like trying to read the chines posted before you.. lol.. but if anyone can help me or point me in the right direction i would be grateful.

[JoshuaG]

this is really simple to do and carlos has it right you will have to change the CS database details to add into the VB Database tables.

or vise versa.

you will have to find the Database connection in CS and all the query's and chnage them to where you need them to go etc..VB Database.

[Kalle]

What you need to do is to write a php script and attach it to the registration plugin hook in the Administration Control Panel. We do the very same for various things here at CT.