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

[eddynator]

Hello, i know that this post is a little old but this interest me a lot.

i though the same as you, i want to use my comunity page web usernames nad pass as TS logins.

After doing the necesary changes on ts sql arrays i was getting your same err.
so i though, well ill do changes on the sql array from read_client_login.sql to only read 3 columns from the DB, the column username, pswrd and server id. then i got that

SELECT eqdkp_users.username,
eqdkp_users.user_password,
eqdkp_users.serverid
FROM eqdkp_users
WHERE eqdkp_users.serverid = :iServerID
AND eqdkp_users.username = :sName
AND eqdkp_users.user_password = MD5(:sPassword) ;

so i tried to login to ts and woah i got another error on log


24-01-09 13:48:12,ERROR,All,SQL, unknown field descriptor in header: username
24-01-09 13:48:12,ERROR,All,CLIENT, SID: 1 DBValidLogin Exception: EDB.unknown field descriptor in header: username

from 2006, have you got the goal? :P

Thx for your help!

[Katana*GFR*]

Maybe check this mod?
http://forum.teamspeak.com/showthread.php?t=32348

Don't forget to ask gryphon if youre allowed to customize it..

[eddynator]

Well I went there, and... I need to pay 100$ to be licenced and to be able to download that script? or is there another way?

Thanks katana, this mod seems nice.

[Katana*GFR*]

might want to search google for it, or contact Gryphon if he's willing to share it for modding purposes.