Author Topic: Help integrate the database with users Datalife Engine openstats :)  (Read 2104 times)

Artyom91

  • Advanced Member
  • ****
  • Posts: 257
  • Karma: +2/-43
    • View Profile
Help integrate the database with users Datalife Engin openstats :)

Datalife Engine - http://dle-news.ru

I also worth Datalife Engine integration with Invisione Power Board (IPB), you can integrate Invisione Power Board (IPB) and Openstats?

Artyom91

  • Advanced Member
  • ****
  • Posts: 257
  • Karma: +2/-43
    • View Profile
Re: Help integrate the database with users Datalife Engine openstats :)
« Reply #1 on: December 29, 2013, 07:24:59 am »
The users table has the following structure:

Code: [Select]
$tableSchema[] = "CREATE TABLE " . PREFIX . "_users (
  `email` varchar(50) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `name` varchar(40) NOT NULL default '',
  `user_id` int(11) NOT NULL auto_increment,
  `news_num` mediumint(8) NOT NULL default '0',
  `comm_num` mediumint(8) NOT NULL default '0',
  `user_group` smallint(5) NOT NULL default '4',
  `lastdate` varchar(20) default NULL,
  `reg_date` varchar(20) default NULL,
  `banned` varchar(5) NOT NULL default '',
  `allow_mail` tinyint(1) NOT NULL default '1',
  `info` text NOT NULL,
  `signature` text NOT NULL,
  `foto` varchar(50) NOT NULL default '',
  `fullname` varchar(100) NOT NULL default '',
  `land` varchar(100) NOT NULL default '',
  `icq` varchar(20) NOT NULL default '',
  `favorites` text NOT NULL,
  `pm_all` smallint(5) NOT NULL default '0',
  `pm_unread` smallint(5) NOT NULL default '0',
  `time_limit` varchar(20) NOT NULL default '',
  `xfields` text NOT NULL,
  `allowed_ip` varchar(255) NOT NULL default '',
  `hash` varchar(32) NOT NULL default '',
  `logged_ip` varchar(16) NOT NULL default '',
  `restricted` TINYINT(1) NOT NULL default '0',
  `restricted_days` SMALLINT(4) NOT NULL default '0',
  `restricted_date` VARCHAR(15) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */";

If you change the field in the ghost + + on these will work?

Artyom91

  • Advanced Member
  • ****
  • Posts: 257
  • Karma: +2/-43
    • View Profile
Re: Help integrate the database with users Datalife Engine openstats :)
« Reply #2 on: December 29, 2013, 07:31:35 am »
Code: [Select]
user_email replaced by email
user_password replaced by password
user_name replaced by name
user_id replaced by user_id
...............................................................

Grief-Code

  • Guest
Re: Help integrate the database with users Datalife Engine openstats :)
« Reply #3 on: December 31, 2013, 03:03:44 am »
I don't see the point why this should be integrated...

To change this values will fuck up all on the Bot.
Furtheremore this prefix with underscore has a reason to avoid potential double used table names.

Regards

Artyom91

  • Advanced Member
  • ****
  • Posts: 257
  • Karma: +2/-43
    • View Profile
Re: Help integrate the database with users Datalife Engine openstats :)
« Reply #4 on: December 31, 2013, 10:28:44 pm »
I need to integrate users