1. Check out the Store if you're looking to Buy HL2RP or other schemas for your server. You can click Buy Schemas on the very top navigation bar to visit the store.
  2. Use the Plugin Center to easily subscribe to and auto-install Clockwork plugins to your server, or submit and share plugins you have developed.
  3. Having trouble setting up or developing with Clockwork? Check out the Wiki or post in the Support Forum for advice from fellow users.
Dismiss Notice
Hi Guest, you need a Steam account to register and post on these forums. Login with Steam at the top of the forums to get started!
Dismiss Notice
Hi Guest, do you want to buy HL2RP or another Clockwork schema? Visit the Cloud Sixteen Store to get started!

Help Clockwork hl2rp Encoding database problem

Discussion in 'Support Desk' started by GhettoV1pster, Jun 14, 2017.

  1. Hi guys, there was a problem with the display of Russian characters. I changed several encodings:
    - UTF8_general_ci
    - UTF8_unicode_ci
    - cp1251_general_ci
    - latin1 -- default charset in sv.hooks.lua(clockwork)
    and... result: endcode cp1251_general_ci
    utf8_general_ci/utf8_unicode_ci
    use default latin1 = same
    Code:
    -- Called when the Clockwork database has connected.
    function cwXCS:ClockworkDatabaseConnected()
        local CREATE_MESSAGES_TABLE = [[
        CREATE TABLE IF NOT EXISTS `]]..Clockwork.config:Get("mysql_xsc_table"):Get()..[[` (
            `_Key` int(11) NOT NULL AUTO_INCREMENT,
            `_ServerName` varchar(255) NOT NULL,
            `_PlayerName` varchar(255) NOT NULL,
            `_Text` text NOT NULL,
            `_Color` varchar(255) NOT NULL,
            PRIMARY KEY (`_Key`)
        ) ENGINE=InnoDB DEFAULT CHARSET=cp1251_general_ci AUTO_INCREMENT=1 ;]];
       
        Clockwork.database:Query(string.gsub(CREATE_MESSAGES_TABLE, "%s", " "), nil, nil, true);
    end;
    *where CHARSET= i changed from latin1 to cp1251 and utf8. and don't work...
    pls help me :(
    ------------------
    clockwork : 0.925
    hl2rp: 1.07
    mysql 5.5.25
     

Previous Readers (Total: 0)