collapse collapse
Menu
  • Home
  • Archives
    • * User Info
     
     
    Welcome, Guest. Please login or register.
    * Search

    * Board Stats
    • stats Total Members: 989
    • stats Total Posts: 18365
    • stats Total Topics: 2500
    • stats Total Categories: 7
    • stats Total Boards: 35
    • stats Most Online: 1144
    « previous next »
    Pages: 1 ... 3 4 [5] 6 7 8   Go Down

    Author Topic: TWC  (Read 86952 times)

    0 Members and 4 Guests are viewing this topic.

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #60 on: September 04, 2008, 10:27:10 pm »
    I am getting Duplicate entry '0' for key 2
    when trying to register...

    Any suggestions?
    Logged

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #61 on: September 04, 2008, 11:05:01 pm »
    It lets me register the initial person but after that I get the Duplicate entry '0' for key 2 whenever someone else tries to register.

    The problem is that when a new user registers it doesnt assign a value to the char_id table. it leaves it at 0, so the next person to register gets the error.
    « Last Edit: September 04, 2008, 11:27:04 pm by Vain »
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #62 on: September 05, 2008, 07:27:23 am »
    the id field should be auto incremental
    code that makes it looks ok, ill do some testing tomorrow
    Logged

    Offline Mardonge

    • BeBot Rookie
    • *
    • Posts: 5
    • Karma: +0/-0
    Re: TWC
    « Reply #63 on: September 10, 2008, 02:41:12 pm »
    Interesting work here, I'll have to try this one out when I get home from work if my line is up again by then.
    Just one question... What phpBB versions are supported for user db? 2.x or 3.x?
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #64 on: September 10, 2008, 02:46:40 pm »
    this doesnt user the DB for phpBB all the data required was in the arrays provided by forum
    this was made useing 3.x no idea if will work with 2.x
    Logged

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #65 on: September 10, 2008, 09:39:15 pm »
    Quote from: Temar on September 05, 2008, 07:27:23 am
    the id field should be auto incremental
    code that makes it looks ok, ill do some testing tomorrow

    Any word Temar?
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #66 on: September 10, 2008, 10:05:19 pm »
    well i check my table just and id is set to auto incremental, please check you table
    if its not set, set it to autoincremental
    if the problem is not caused by this it will prob be the module its self and ill check it
    Logged

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #67 on: September 12, 2008, 12:35:21 am »
    Quote from: Temar on September 10, 2008, 10:05:19 pm
    well i check my table just and id is set to auto incremental, please check you table
    if its not set, set it to autoincremental
    if the problem is not caused by this it will prob be the module its self and ill check it

    users.char_id or users.id?

    users.id is set to autoincrement but users.char_id is not.


    Let me clear a few things up. it is using the same table that the bot uses for org members. Is it supposed to have its own table?
    « Last Edit: September 12, 2008, 12:37:32 am by Vain »
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #68 on: September 12, 2008, 12:38:01 am »
    char_id ? i dont use a column called that and never have as far as i can remember
    « Last Edit: September 12, 2008, 12:39:53 am by Temar »
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #69 on: September 12, 2008, 12:41:14 am »
    its has its own table lol :p
    Logged

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #70 on: September 12, 2008, 12:48:52 am »
    ok i must have my settings wrong....

    Code: [Select]
    $this -> settings["forum_sql_server"] = 'localhost';
    $this -> settings["forum_sql_username"] = 'Bebot';
    $this -> settings["forum_sql_password"] = 'xxxxx';
    $this -> settings["bot_sql_server"] = 'localhost';
    $this -> settings["bot_sql_username"] = 'Bebot';
    $this -> settings["bot_sql_password"] = 'xxxxx';
    $this -> settings["forum_pre"] = '';
    $this -> settings["forum_db"] = 'bebot';
    $this -> settings["orgbot_db"] = 'bebot';
    $this -> settings["orgbot_name"] = 'Havocbot';
    $this -> settings["online_orgbot_names"] = 'Havocbot';
    $this -> settings["orgbot_names"] = 'Havocbot;Havocbot';
    $this -> settings["twc_db"] = 'twc';
    $this -> settings["twc_pre"] = '';
    $this -> settings["login_table"] = '';
    $this -> settings["loginbots_prefix"] = '';
    $this -> settings["orgchat"] = TRUE;
    $this -> settings["loginchat"] = FALSE;
    $this -> settings["forum_root"] = '/var/www/twc';
    $this -> settings["twc_root"] = '/var/www/twc';
    $this -> settings["twc_url"] = 'http://xxx.xxx.193.108';
    $this -> settings["user_data"] = 3;
    $this -> settings["allow_new"] = FALSE;
    For some reason its using the bebot table.
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #71 on: September 12, 2008, 12:57:19 am »
    $this -> settings["forum_db"] = 'bebot';
    this is the DB setting for the user table, yes i know there is also a twc_db ill fix it soon :p

    If useing twc user mode and not a forum
    all forum setting like database are used for the user table it makes
    Logged

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #72 on: September 12, 2008, 01:00:38 am »
    Thanks Temar!

    I changed the forum db to twc and it works great now.
    I was unaware that for a forumless install this is where the users are stored.
    Logged

    Offline Vain

    • BeBot User
    • **
    • Posts: 57
    • Karma: +0/-0
    Re: TWC
    « Reply #73 on: September 12, 2008, 01:03:50 am »
    Although when i goto the install script script, I see an option for create superadmin.

    When I click on the link i get:
    Fatal error: Cannot redeclare select() (previously declared in /var/www/twc/sql.php:42) in /var/www/twc/sql.php on line 42
    Logged

    Offline Temar

    • Contributor
    • *******
    • Posts: 1140
    • Karma: +0/-0
      • AoFiles
    Re: TWC
    « Reply #74 on: September 12, 2008, 01:05:00 am »
    yer im currently in the process of rewriting it alot, this issue will no longer exists when im done
    Logged
    Pages: 1 ... 3 4 [5] 6 7 8   Go Up
    « previous next »
     
    * Recent Posts
    0.8.x updates for AO by bitnykk
    [June 23, 2024, 03:19:47 pm ]
    0.8.x updates for AoC by bitnykk
    [June 23, 2024, 03:19:44 pm ]
    [AoC] special char for items module by bitnykk
    [February 09, 2024, 09:41:18 pm ]
    BeBot still alive & kicking ! by bitnykk
    [December 17, 2023, 12:58:44 am ]
    Bebot and Rasberry by bitnykk
    [November 29, 2023, 11:04:14 pm ]
    * Who's Online
    • Dot Guests: 157
    • Dot Hidden: 0
    • Dot Users: 0

    There aren't any users online.
    * Forum Staff
    bitnykk admin bitnykk
    Administrator
    Khalem admin Khalem
    Administrator
    WeZoN gmod WeZoN
    Global Moderator
    SimplePortal 2.3.7 © 2008-2024, SimplePortal