Results 1 to 2 of 2
Thread: Why dosn't this work...?
-
25-10-2005, 13:42 #1
-= TeamSpeak User =-
- Join Date
- Sep 2005
- Location
- Sweden
- Posts
- 20
Why dosn't this work...?
Today I thought about merging 2 databases and I've been working with this for about 7 hours now and still don't see how this is gona be solved.. When using the default .sql files it all works fine, But I wanna change around the call functions so I use the usernames from my php portal system as well with that password so when you create an account it automaticly opens up a teamspeak account since it will read from the same place.
Could someone please help me out with this, Starting to get Crazy..
This is the idea behind the code "read_client_login.sql"
Here's the error that generates by Teamspeak. As you can see it actauly get's the information (username and password) this only occurs on an account that exsists and if password/username are correct.Code:select * from nuke_users where i_client_server_id = :iServerID and username = :sName and user_password = :sPassword
This is the minor database. For some reason it selected some text in Swedis but you know what it says anyway.Code:25-10-05 14:22:24,ERROR,All,SQL, unknown field descriptor in header: user_id 25-10-05 14:22:24,ERROR,All,CLIENT, SID: 1 DBValidLogin Exception: EDB.unknown field descriptor in header: user_id
Code:-- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Värd: localhost -- Skapad: 25 oktober 2005 kl 14:28 -- Serverversion: 4.0.25 -- PHP-version: 4.4.0 -- -- Databas: `phpnukeplat` -- -- -------------------------------------------------------- -- -- Struktur för tabell `nuke_users` -- CREATE TABLE `nuke_users` ( `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 AUTO_INCREMENT=23 ; -- -- Data i tabell `nuke_users` -- INSERT INTO `nuke_users` VALUES (2, 1, -1, 'Fredrik Samuelsson', 'Tearlow', 'email', 'faemail', 'http://', 'gallery/revenge.gif', 'Oct 01, 2005', '', '', '', 'Web Developing and Computer stuff, Duhh!', '', 0, NULL, '', '', '', 'test', 10, 'thread', 0, 0, 0, '', 0, '', 'subBlack', 4096, 0, 0, 1, 1, 0, 2, 1, 0, 1, 1130211737, 0, 1130148222, 1.00, 0, 'english', 'D M d, Y g:i a', 0, 0, 1130093980, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '213.112.12.29', NULL, NULL, 0, 0, 0, 70, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-
02-11-2005, 22:23 #2
-= TeamSpeak User =-
- Join Date
- Sep 2005
- Location
- Sweden
- Posts
- 20
Isn't there anyone that is expreienced with this or did I lack information that I gave? I still don't know why this odd error occures, I've tracked down the string that teamspeak sends and everything is good except that something fails or is wrong with the User_ID counter...
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Why is it so complicated?
By [NAVA] Steve-O in forum [TeamSpeak 2] Addons & ScriptsReplies: 3Last Post: 04-03-2005, 20:49 -
Merging Server Databases
By andrewk in forum [TeamSpeak 2] Server SupportReplies: 2Last Post: 18-05-2004, 15:38


Reply With Quote