PHPNuke/Teamspeak?

[Tearlow]

What I'am doing is integrating the userbase into my already
existing Web portal. It's a modefied version of PHP Nuke.

This is basicly how the struc. Looks like. As you can see
iam not completly done with the names. But this should work
just fine anyway.

CREATE TABLE `nuke_users_testing` (
`user_id` int(11) NOT NULL auto_increment,
`i_client_server_id` int(11) NOT NULL default '1',
`b_client_privilege_serveradmin` int(11) NOT NULL default '0',
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '1',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'english',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '0',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`last_ip` varchar(15) NOT NULL default '0',
`user_color_gc` varchar(6) default NULL,
`user_color_gi` text,
`user_quickreply` tinyint(1) NOT NULL default '0',
`user_allow_arcadepm` tinyint(4) NOT NULL default '0',
`kick_ban` int(2) NOT NULL default '0',
`user_wordwrap` smallint(2) NOT NULL default '70',
`agreedtos` tinyint(1) NOT NULL default '0',
`user_view_log` tinyint(4) NOT NULL default '0',
`user_effects` varchar(255) default NULL,
`user_privs` varchar(255) default NULL,
`user_custitle` text,
`user_specmsg` text,
`user_items` text,
`user_trade` text,
`dt_client_created` varchar(20) default NULL,
`dt_client_lastonline` varchar(20) default NULL,
PRIMARY KEY (`user_id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=16 ;

and as most of you know, Teamspeak own looks like this:

CREATE TABLE `ts2_clients` (
`i_client_id` int(11) NOT NULL auto_increment,
`i_client_server_id` int(11) default NULL,
`b_client_privilege_serveradmin` int(11) default NULL,
`s_client_name` varchar(40) default NULL,
`s_client_password` varchar(80) default NULL,
`dt_client_created` varchar(20) default NULL,
`dt_client_lastonline` varchar(20) default NULL,
PRIMARY KEY (`i_client_id`)
) TYPE=MyISAM AUTO_INCREMENT=131 ;

so, With the .SQL files I've edited all of them to point to
the right things. First I started using a Search/Replace but
after a reboot I had some strange errors so i did it all over
again but this time im getting more "Human" errors.

21-03-06 03:54:55,ALL,Info,server, Server init initialized
21-03-06 03:54:55,ALL,Info,server, Server version: 2.0.20.1 Win32
21-03-06 03:54:56,ALL,Info,server, Starting VirtualServer id:1 with port:8767
21-03-06 03:54:56,ALL,Info,server, Starting VirtualServer id:3 with port:5678
21-03-06 03:54:57,ALL,Info,server, Server init finished
22-03-06 07:44:29,ERROR,All,SQL, unknown field descriptor in header: user_id
22-03-06 07:44:29,ERROR,All,CLIENT, SID: 1 DBValidLogin Exception: EDB.unknown field descriptor in header: user_id
22-03-06 07:44:49,ERROR,All,SQL, unknown field descriptor in header: user_id
22-03-06 07:44:49,ERROR,All,CLIENT, SID: 1 DBValidLogin Exception: EDB.unknown field descriptor in header: user_id
22-03-06 07:46:25,ERROR,All,SQL, unknown field descriptor in header: user_id
22-03-06 07:46:25,ERROR,All,WEBINTERFACE, Progress_COMMAND Exception: EDB.unknown field descriptor in header: user_id

I don't know how much more info I need to provide, so please
let me know if theres something missing to aid this "major"
problem..


Thanks
Tearlow