Community Forums Today's Posts     Member List     Archive    
Results 1 to 2 of 2
  1. #1
    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"
    Code:
    select * from nuke_users where i_client_server_id = :iServerID and username = :sName and user_password = :sPassword
    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:
    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
    This is the minor database. For some reason it selected some text in Swedis but you know what it says anyway.
    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);

  2. #2
    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

  1. Why is it so complicated?
    By [NAVA] Steve-O in forum [TeamSpeak 2] Addons & Scripts
    Replies: 3
    Last Post: 04-03-2005, 20:49
  2. Merging Server Databases
    By andrewk in forum [TeamSpeak 2] Server Support
    Replies: 2
    Last Post: 18-05-2004, 15:38

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •