Jump to content
  • 0

Problema mysql


WiDuAlK

Question

Am o problema ori de la Wamp Server/ Xampp, ori de la windows. Mi-am reinstalat windousul(am acum Viste Basic Home) si , am vazut ca daca importez o baza de date, la server log spune asta:

 
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-RC1, (C)2005-2015 SA-MP Team

[17:55:02] filterscripts = ""  (string)
[17:55:02] 
[17:55:02] Server Plugins
[17:55:02] --------------
[17:55:02]  Loading plugin: mysql
[17:55:03]  >> plugin.mysql: R39-3 successfully loaded.
[17:55:03]   Loaded.
[17:55:03]  Loading plugin: streamer
[17:55:03] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[17:55:03]   Loaded.
[17:55:03]  Loading plugin: sscanf
[17:55:03] 

[17:55:03]  ===============================

[17:55:03]       sscanf plugin loaded.     

[17:55:03]          Version:  2.8.1        

[17:55:03]    (c) 2012 Alex "Y_Less" Cole  

[17:55:03]  ===============================

[17:55:03]   Loaded.
[17:55:03]  Loading plugin: mcmd
[17:55:03] [mcmd] Plugin successfully loaded 0.0.1(Compiled on Sep 26 2014, 22:26:46).
[17:55:03]   Loaded.
[17:55:03]  Loaded 4 plugins.

[17:55:03] 
[17:55:03] Filterscripts
[17:55:03] ---------------
[17:55:03]   Loaded 0 filterscripts.

[17:55:03]  
[17:55:03]  ======================================= 
[17:55:03]  |                                     | 
[17:55:03]  |        YSI version 1.04.0000        | 
[17:55:03]  |        By Alex "Y_Less" Cole        | 
[17:55:03]  |                                     | 
[17:55:03]  ======================================= 
[17:55:03]  
[17:55:03] Iter_OnGameModeInit start: 500
[17:55:03] [MYSQL]: conexiunea la baza (datebase) a esuat!
[17:55:03] Iter_OnGameModeInit: first
[17:55:03]  
[17:55:03]  
[17:55:03]  RPG: Alpha LosSantos
[17:55:03] _____________________
[17:55:03] Number of vehicle models: 44
[17:55:03] --- Server Shutting Down.
[17:55:03] plugin.mysql: Unloading plugin...
[17:55:03] plugin.mysql: Plugin unloaded.
[17:55:03] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[17:55:03] 

[17:55:03]  ===============================

[17:55:03]      sscanf plugin unloaded.    

[17:55:03]  ===============================

[17:55:03] [mcmd] Plugin unloaded.

mysql log

  margin: 0px;
        padding: 6px;
        border: 1px solid #C2C2C2;
        width: 800px;
        height: 498px;
        text-align: left;
        overflow: auto"><html><head><title>MySQL Plugin log</title><style>table {border: 1px solid black; border-collapse: collapse; line-height: 23px; table-layout: fixed; width: 863px;}th, td {border: 1px solid black; word-wrap: break-word;}thead {background-color: #C0C0C0;}        tbody {text-align: center;}        table.left1 {position: relative; left: 36px;}        table.left2 {position: relative; left: 72px;}        .time {width: 80px;}        .func {width: 200px;}        .stat {width: 75px;}        .msg {width: 400px;}    </style>    <script>        var             LOG_ERROR = 1,            LOG_WARNING = 2,            LOG_DEBUG = 4;                var            FirstRun = true,            IsCallbackActive = false,            IsTableOpen = false,            IsThreadActive = false;                function StartCB(cbname) {            StartTable(1, 0, cbname);        }        function EndCB() {            EndTable();            IsCallbackActive = false;        }        function StartTable(iscallback, isthreaded, cbname) {            if(IsTableOpen == true || isthreaded != IsThreadActive)                EndTable();                        if(iscallback == true) {                document.write(                    "<table class=left2>" +                        "<th bgcolor=#C0C0C0 >In callback ""+cbname+""</th>" +                    "</table>"                );            }                        document.write("<table");            if(iscallback == true || (isthreaded != IsThreadActive && isthreaded == false && IsCallbackActive == true) ) {                document.write(" class=left2");                IsCallbackActive = true;            }            else if(isthreaded == true)                 document.write(" class=left1");                        IsThreadActive = isthreaded;            document.write(">");                        if(FirstRun == true) {                FirstRun = false;                document.write("<thead><th class=time>Time</th><th class=func>Function</th><th class=stat>Status</th><th class=msg>Message</th></thead>");            }            document.write("<tbody>");            IsTableOpen = true;        }                function EndTable() {            document.write("</tbody></table>");            IsTableOpen = false;        }                        function Log(time, func, status, msg, isthreaded) {            isthreaded = typeof isthreaded !== 'undefined' ? isthreaded : 0;            if(IsTableOpen == false || isthreaded != IsThreadActive)                StartTable(false, isthreaded, "");            var StatColor, StatText;            switch(status) {            case LOG_ERROR:                StatColor = "RED";                StatText = "ERROR";                break;            case LOG_WARNING:                StatColor = "#FF9900";                StatText = "WARNING";                break;            case LOG_DEBUG:                StatColor = "#00DD00";                StatText = "OK";                break;            }            document.write(                "<tr bgcolor="+StatColor+">" +                     "<td class=time>"+time+"</td>" +                     "<td class=func>"+func+"</td>" +                     "<td class=stat>"+StatText+"</td>" +                     "<td class=msg>"+msg+"</td>" +                 "</tr>"            );        }    </script></head><body bgcolor=grey>    <h2>Logging started at 20:10, 11.01.2015</h2><script>
Log("20:10:39","CMySQLConnection::Connect",4,"establishing connection to database...",1);
Log("20:10:39","CMySQLConnection::Connect",4,"establishing connection to database...",1);
Log("20:10:39","CMySQLConnection::Connect",4,"establishing connection to database...",1);
Log("20:10:39","CMySQLConnection::Connect",4,"connection was successful",1);
Log("20:10:39","CMySQLConnection::Connect",4,"auto-reconnect has been enabled",1);
Log("20:10:39","CMySQLConnection::Connect",4,"connection was successful",1);
Log("20:10:39","CMySQLConnection::Connect",4,"auto-reconnect has been enabled",1);
Log("20:10:39","CMySQLConnection::Connect",4,"connection was successful",1);
Log("20:10:39","CMySQLConnection::Connect",4,"auto-reconnect has been enabled",1);
Log("20:10:39","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:10:39","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'Dj_Nexotronix'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 0.817 milliseconds",1);
Log("20:10:39","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:10:39","cache_get_data",4,"connection: 1",0);
Log("20:10:39","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:10:39","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:10:39","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'BarGirl'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 0.602 milliseconds",1);
Log("20:10:39","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:10:39","cache_get_data",4,"connection: 1",0);
Log("20:10:39","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:10:39","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:10:39","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'Administrator'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 0.811 milliseconds",1);
Log("20:10:39","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:10:39","cache_get_data",4,"connection: 1",0);
Log("20:10:39","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:11:20","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:11:20","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'WiDuAlK'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:11:20","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:11:20","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 1.489 milliseconds",1);
Log("20:11:20","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:11:20","cache_get_data",4,"connection: 1",0);
Log("20:11:20","cache_get_field_content",4,"row: 0, field_name: "LastLogin", connection: 1, max_len: 256",0);
Log("20:11:20","CMySQLResult::GetRowDataByName",4,"row: '0', field: "LastLogin", data: "2015-01-11 20:04:04"",0);
Log("20:11:20","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:11:27","mysql_escape_string",4,"source: "parkour01", connection: 1, max_len: 64",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username`='%e' AND `password`='%e'"",0);
Log("20:11:27","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username`='WiDuAlK' AND `password", callback: "WhenPlayerLogin", format: "i"",0);
Log("20:11:27","CMySQLQuery::Execute[WhenPlayerLogin]",4,"starting query execution",1);
Log("20:11:27","CMySQLQuery::Execute[WhenPlayerLogin]",4,"query was successfully executed within 1.280 milliseconds",1);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenPlayerLogin");Log("20:11:27","cache_get_data",4,"connection: 1",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "password", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "password", data: "PARKOUR01"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Level", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Level", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "AdminLevel", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "AdminLevel", data: "6"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "HelperLevel", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "HelperLevel", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Cash", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Cash", data: "300"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Account", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Account", data: "500"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Email", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Email", data: "[email protected]"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Registred", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Registred", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Tutorial", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Tutorial", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Sex", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Sex", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Age", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Age", data: "15"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "PhoneNumber", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PhoneNumber", data: "7373009"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "PremiumAccount", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PremiumAccount", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Banned", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Banned", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Warns", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Warns", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Leader", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Leader", data: "8"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Member", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Member", data: "8"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Rank", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Rank", data: "6"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Skin", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Skin", data: "115"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "RespectPoint", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "RespectPoint", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "IP", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "IP", data: "25.129.144.2"",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `Cash`='%d' WHERE `username`='%e'"",0);
Log("20:11:27","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `Cash`='300' WHERE `username`='WiDuAlK'", use_cache: true",0);
Log("20:11:27","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:11:27","CMySQLQuery::Execute",4,"query was successfully executed within 0.896 milliseconds",0);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:11:27","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 1)",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `username`='%e'"",0);
Log("20:11:27","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `usern", use_cache: true",0);
Log("20:11:27","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:11:27","CMySQLQuery::Execute",4,"query was successfully executed within 0.772 milliseconds",0);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:11:27","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 2)",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `IP`='%e' WHERE `username`='%e'"",0);
Log("20:11:27","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `IP`='25.129.144.2' WHERE `username`='WiDuA", use_cache: true",0);
Log("20:11:27","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:11:27","CMySQLQuery::Execute",4,"query was successfully executed within 0.468 milliseconds",0);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:11:27","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 3)",0);
EndCB();Log("20:13:03","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:13:03","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'WiDuAlK'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:13:03","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:13:03","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 1.382 milliseconds",1);
Log("20:13:03","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:13:03","cache_get_data",4,"connection: 1",0);
Log("20:13:03","cache_get_field_content",4,"row: 0, field_name: "LastLogin", connection: 1, max_len: 256",0);
Log("20:13:03","CMySQLResult::GetRowDataByName",4,"row: '0', field: "LastLogin", data: "2015-01-11 20:11:27"",0);
Log("20:13:03","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:13:08","mysql_escape_string",4,"source: "parkour01", connection: 1, max_len: 64",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username`='%e' AND `password`='%e'"",0);
Log("20:13:08","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username`='WiDuAlK' AND `password", callback: "WhenPlayerLogin", format: "i"",0);
Log("20:13:08","CMySQLQuery::Execute[WhenPlayerLogin]",4,"starting query execution",1);
Log("20:13:08","CMySQLQuery::Execute[WhenPlayerLogin]",4,"query was successfully executed within 1.7 milliseconds",1);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenPlayerLogin");Log("20:13:08","cache_get_data",4,"connection: 1",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "password", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "password", data: "PARKOUR01"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Level", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Level", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "AdminLevel", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "AdminLevel", data: "6"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "HelperLevel", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "HelperLevel", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Cash", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Cash", data: "300"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Account", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Account", data: "500"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Email", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Email", data: "[email protected]"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Registred", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Registred", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Tutorial", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Tutorial", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Sex", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Sex", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Age", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Age", data: "15"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "PhoneNumber", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PhoneNumber", data: "7373009"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "PremiumAccount", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PremiumAccount", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Banned", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Banned", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Warns", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Warns", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Leader", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Leader", data: "8"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Member", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Member", data: "8"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Rank", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Rank", data: "6"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Skin", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Skin", data: "115"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "RespectPoint", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "RespectPoint", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "IP", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "IP", data: "25.129.144.2"",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `Cash`='%d' WHERE `username`='%e'"",0);
Log("20:13:08","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `Cash`='300' WHERE `username`='WiDuAlK'", use_cache: true",0);
Log("20:13:08","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:13:08","CMySQLQuery::Execute",4,"query was successfully executed within 1.127 milliseconds",0);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:13:08","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 4)",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `username`='%e'"",0);
Log("20:13:08","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `usern", use_cache: true",0);
Log("20:13:08","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:13:08","CMySQLQuery::Execute",4,"query was successfully executed within 0.570 milliseconds",0);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:13:08","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 5)",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `IP`='%e' WHERE `username`='%e'"",0);
Log("20:13:08","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `IP`='25.129.144.2' WHERE `username`='WiDuA", use_cache: true",0);
Log("20:13:08","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:13:08","CMySQLQuery::Execute",4,"query was successfully executed within 0.430 milliseconds",0);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:13:08","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 6)",0);
EndCB();</script>[13:33:40] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[14:46:14] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:37:17] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[13:14:34] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[20:05:42] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[14:34:36] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[09:16:03] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[21:59:26] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:20:49] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:20:54] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[19:44:50] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:36:31] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[21:59:45] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:08:46] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:09:28] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:13:10] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:17:28] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:18:30] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:28:45] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:50:56] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[17:55:03] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
#define mysql_host "localhost"
#define mysql_user "root"
#define mysql_password ""
#define mysql_database "datebase"

aici se face conexiunea

Am incercat cu mai multe GM-uri inafara de asta pe care il construiesc eu, si la fel face... Vro idee?

 

Link to comment
Share on other sites

13 answers to this question

Recommended Posts

  • 0
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-RC1, (C)2005-2015 SA-MP Team

[17:55:02] filterscripts = ""  (string)
[17:55:02] 
[17:55:02] Server Plugins
[17:55:02] --------------
[17:55:02]  Loading plugin: mysql
[17:55:03]  >> plugin.mysql: R39-3 successfully loaded.
[17:55:03]   Loaded.
[17:55:03]  Loading plugin: streamer
[17:55:03] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[17:55:03]   Loaded.
[17:55:03]  Loading plugin: sscanf
[17:55:03] 

[17:55:03]  ===============================

[17:55:03]       sscanf plugin loaded.     

[17:55:03]          Version:  2.8.1        

[17:55:03]    (c) 2012 Alex "Y_Less" Cole  

[17:55:03]  ===============================

[17:55:03]   Loaded.
[17:55:03]  Loading plugin: mcmd
[17:55:03] [mcmd] Plugin successfully loaded 0.0.1(Compiled on Sep 26 2014, 22:26:46).
[17:55:03]   Loaded.
[17:55:03]  Loaded 4 plugins.

[17:55:03] 
[17:55:03] Filterscripts
[17:55:03] ---------------
[17:55:03]   Loaded 0 filterscripts.

[17:55:03]  
[17:55:03]  ======================================= 
[17:55:03]  |                                     | 
[17:55:03]  |        YSI version 1.04.0000        | 
[17:55:03]  |        By Alex "Y_Less" Cole        | 
[17:55:03]  |                                     | 
[17:55:03]  ======================================= 
[17:55:03]  
[17:55:03] Iter_OnGameModeInit start: 500
[17:55:03] [MYSQL]: conexiunea la baza (datebase) a esuat!
[17:55:03] Iter_OnGameModeInit: first
[17:55:03]  
[17:55:03]  
[17:55:03]  RPG: Alpha LosSantos
[17:55:03] _____________________
[17:55:03] Number of vehicle models: 44
[17:55:03] --- Server Shutting Down.
[17:55:03] plugin.mysql: Unloading plugin...
[17:55:03] plugin.mysql: Plugin unloaded.
[17:55:03] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[17:55:03] 

[17:55:03]  ===============================

[17:55:03]      sscanf plugin unloaded.    

[17:55:03]  ===============================

[17:55:03] [mcmd] Plugin unloaded.

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-RC1, (C)2005-2015 SA-MP Team

[20:59:02] filterscripts = ""  (string)
[20:59:02] 
[20:59:02] Server Plugins
[20:59:02] --------------
[20:59:02]  Loading plugin: mysql
[20:59:03]  >> plugin.mysql: R39-3 successfully loaded.
[20:59:03]   Loaded.
[20:59:03]  Loading plugin: streamer
[20:59:03] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[20:59:03]   Loaded.
[20:59:03]  Loading plugin: sscanf
[20:59:03] 

[20:59:03]  ===============================

[20:59:03]       sscanf plugin loaded.     

[20:59:03]          Version:  2.8.1        

[20:59:03]    (c) 2012 Alex "Y_Less" Cole  

[20:59:03]  ===============================

[20:59:03]   Loaded.
[20:59:03]  Loading plugin: mcmd
[20:59:03] [mcmd] Plugin successfully loaded 0.0.1(Compiled on Sep 26 2014, 22:26:46).
[20:59:03]   Loaded.
[20:59:03]  Loaded 4 plugins.

[20:59:03] 
[20:59:03] Filterscripts
[20:59:03] ---------------
[20:59:03]   Loaded 0 filterscripts.

[20:59:03]  
[20:59:03]  ======================================= 
[20:59:03]  |                                     | 
[20:59:03]  |        YSI version 1.04.0000        | 
[20:59:03]  |        By Alex "Y_Less" Cole        | 
[20:59:03]  |                                     | 
[20:59:03]  ======================================= 
[20:59:03]  
[20:59:03] Iter_OnGameModeInit start: 500
[20:59:03] [MYSQL]: conexiunea la baza (datebase) a esuat!
[20:59:03] Iter_OnGameModeInit: first
[20:59:03]  
[20:59:03]  
[20:59:03]  RPG: Alpha LosSantos
[20:59:03] _____________________
[20:59:03] Number of vehicle models: 44
[20:59:03] --- Server Shutting Down.
[20:59:03] plugin.mysql: Unloading plugin...
[20:59:03] plugin.mysql: Plugin unloaded.
[20:59:03] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[20:59:03] 

[20:59:03]  ===============================

[20:59:03]      sscanf plugin unloaded.    

[20:59:03]  ===============================

[20:59:03] [mcmd] Plugin unloaded.

Editare facuta, recompilare facuta, la fel

Edited by WiDuAlK.SaMp
Link to comment
Share on other sites

  • 0

deci server log cel nou:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-RC1, (C)2005-2015 SA-MP Team

[17:55:02] filterscripts = ""  (string)
[17:55:02] 
[17:55:02] Server Plugins
[17:55:02] --------------
[17:55:02]  Loading plugin: mysql
[17:55:03]  >> plugin.mysql: R39-3 successfully loaded.
[17:55:03]   Loaded.
[17:55:03]  Loading plugin: streamer
[17:55:03] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[17:55:03]   Loaded.
[17:55:03]  Loading plugin: sscanf
[17:55:03] 

[17:55:03]  ===============================

[17:55:03]       sscanf plugin loaded.     

[17:55:03]          Version:  2.8.1        

[17:55:03]    (c) 2012 Alex "Y_Less" Cole  

[17:55:03]  ===============================

[17:55:03]   Loaded.
[17:55:03]  Loading plugin: mcmd
[17:55:03] [mcmd] Plugin successfully loaded 0.0.1(Compiled on Sep 26 2014, 22:26:46).
[17:55:03]   Loaded.
[17:55:03]  Loaded 4 plugins.

[17:55:03] 
[17:55:03] Filterscripts
[17:55:03] ---------------
[17:55:03]   Loaded 0 filterscripts.

[17:55:03]  
[17:55:03]  ======================================= 
[17:55:03]  |                                     | 
[17:55:03]  |        YSI version 1.04.0000        | 
[17:55:03]  |        By Alex "Y_Less" Cole        | 
[17:55:03]  |                                     | 
[17:55:03]  ======================================= 
[17:55:03]  
[17:55:03] Iter_OnGameModeInit start: 500
[17:55:03] [MYSQL]: conexiunea la baza (datebase) a esuat!
[17:55:03] Iter_OnGameModeInit: first
[17:55:03]  
[17:55:03]  
[17:55:03]  RPG: Alpha LosSantos
[17:55:03] _____________________
[17:55:03] Number of vehicle models: 44
[17:55:03] --- Server Shutting Down.
[17:55:03] plugin.mysql: Unloading plugin...
[17:55:03] plugin.mysql: Plugin unloaded.
[17:55:03] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[17:55:03] 

[17:55:03]  ===============================

[17:55:03]      sscanf plugin unloaded.    

[17:55:03]  ===============================

[17:55:03] [mcmd] Plugin unloaded.

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-RC1, (C)2005-2015 SA-MP Team

[20:59:02] filterscripts = ""  (string)
[20:59:02] 
[20:59:02] Server Plugins
[20:59:02] --------------
[20:59:02]  Loading plugin: mysql
[20:59:03]  >> plugin.mysql: R39-3 successfully loaded.
[20:59:03]   Loaded.
[20:59:03]  Loading plugin: streamer
[20:59:03] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[20:59:03]   Loaded.
[20:59:03]  Loading plugin: sscanf
[20:59:03] 

[20:59:03]  ===============================

[20:59:03]       sscanf plugin loaded.     

[20:59:03]          Version:  2.8.1        

[20:59:03]    (c) 2012 Alex "Y_Less" Cole  

[20:59:03]  ===============================

[20:59:03]   Loaded.
[20:59:03]  Loading plugin: mcmd
[20:59:03] [mcmd] Plugin successfully loaded 0.0.1(Compiled on Sep 26 2014, 22:26:46).
[20:59:03]   Loaded.
[20:59:03]  Loaded 4 plugins.

[20:59:03] 
[20:59:03] Filterscripts
[20:59:03] ---------------
[20:59:03]   Loaded 0 filterscripts.

[20:59:03]  
[20:59:03]  ======================================= 
[20:59:03]  |                                     | 
[20:59:03]  |        YSI version 1.04.0000        | 
[20:59:03]  |        By Alex "Y_Less" Cole        | 
[20:59:03]  |                                     | 
[20:59:03]  ======================================= 
[20:59:03]  
[20:59:03] Iter_OnGameModeInit start: 500
[20:59:03] [MYSQL]: conexiunea la baza (datebase) a esuat!
[20:59:03] Iter_OnGameModeInit: first
[20:59:03]  
[20:59:03]  
[20:59:03]  RPG: Alpha LosSantos
[20:59:03] _____________________
[20:59:03] Number of vehicle models: 44
[20:59:03] --- Server Shutting Down.
[20:59:03] plugin.mysql: Unloading plugin...
[20:59:03] plugin.mysql: Plugin unloaded.
[20:59:03] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[20:59:03] 

[20:59:03]  ===============================

[20:59:03]      sscanf plugin unloaded.    

[20:59:03]  ===============================

[20:59:03] [mcmd] Plugin unloaded.

si mysql nou

<html><head><title>MySQL Plugin log</title><style>table {border: 1px solid black; border-collapse: collapse; line-height: 23px; table-layout: fixed; width: 863px;}th, td {border: 1px solid black; word-wrap: break-word;}thead {background-color: #C0C0C0;}		tbody {text-align: center;}		table.left1 {position: relative; left: 36px;}		table.left2 {position: relative; left: 72px;}		.time {width: 80px;}		.func {width: 200px;}		.stat {width: 75px;}		.msg {width: 400px;}	</style>	<script>		var 			LOG_ERROR = 1,			LOG_WARNING = 2,			LOG_DEBUG = 4;				var			FirstRun = true,			IsCallbackActive = false,			IsTableOpen = false,			IsThreadActive = false;				function StartCB(cbname) {			StartTable(1, 0, cbname);		}		function EndCB() {			EndTable();			IsCallbackActive = false;		}		function StartTable(iscallback, isthreaded, cbname) {			if(IsTableOpen == true || isthreaded != IsThreadActive)				EndTable();						if(iscallback == true) {				document.write(					"<table class=left2>" +						"<th bgcolor=#C0C0C0 >In callback ""+cbname+""</th>" +					"</table>"				);			}						document.write("<table");			if(iscallback == true || (isthreaded != IsThreadActive && isthreaded == false && IsCallbackActive == true) ) {				document.write(" class=left2");				IsCallbackActive = true;			}			else if(isthreaded == true) 				document.write(" class=left1");						IsThreadActive = isthreaded;			document.write(">");						if(FirstRun == true) {				FirstRun = false;				document.write("<thead><th class=time>Time</th><th class=func>Function</th><th class=stat>Status</th><th class=msg>Message</th></thead>");			}			document.write("<tbody>");			IsTableOpen = true;		}				function EndTable() {			document.write("</tbody></table>");			IsTableOpen = false;		}						function Log(time, func, status, msg, isthreaded) {			isthreaded = typeof isthreaded !== 'undefined' ? isthreaded : 0;			if(IsTableOpen == false || isthreaded != IsThreadActive)				StartTable(false, isthreaded, "");			var StatColor, StatText;			switch(status) {			case LOG_ERROR:				StatColor = "RED";				StatText = "ERROR";				break;			case LOG_WARNING:				StatColor = "#FF9900";				StatText = "WARNING";				break;			case LOG_DEBUG:				StatColor = "#00DD00";				StatText = "OK";				break;			}			document.write(				"<tr bgcolor="+StatColor+">" + 					"<td class=time>"+time+"</td>" + 					"<td class=func>"+func+"</td>" + 					"<td class=stat>"+StatText+"</td>" + 					"<td class=msg>"+msg+"</td>" + 				"</tr>"			);		}	</script></head><body bgcolor=grey>	<h2>Logging started at 20:10, 11.01.2015</h2><script>
Log("20:10:39","CMySQLConnection::Connect",4,"establishing connection to database...",1);
Log("20:10:39","CMySQLConnection::Connect",4,"establishing connection to database...",1);
Log("20:10:39","CMySQLConnection::Connect",4,"establishing connection to database...",1);
Log("20:10:39","CMySQLConnection::Connect",4,"connection was successful",1);
Log("20:10:39","CMySQLConnection::Connect",4,"auto-reconnect has been enabled",1);
Log("20:10:39","CMySQLConnection::Connect",4,"connection was successful",1);
Log("20:10:39","CMySQLConnection::Connect",4,"auto-reconnect has been enabled",1);
Log("20:10:39","CMySQLConnection::Connect",4,"connection was successful",1);
Log("20:10:39","CMySQLConnection::Connect",4,"auto-reconnect has been enabled",1);
Log("20:10:39","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:10:39","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'Dj_Nexotronix'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 0.817 milliseconds",1);
Log("20:10:39","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:10:39","cache_get_data",4,"connection: 1",0);
Log("20:10:39","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:10:39","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:10:39","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'BarGirl'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 0.602 milliseconds",1);
Log("20:10:39","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:10:39","cache_get_data",4,"connection: 1",0);
Log("20:10:39","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:10:39","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:10:39","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'Administrator'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:10:39","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 0.811 milliseconds",1);
Log("20:10:39","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:10:39","cache_get_data",4,"connection: 1",0);
Log("20:10:39","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:11:20","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:11:20","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'WiDuAlK'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:11:20","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:11:20","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 1.489 milliseconds",1);
Log("20:11:20","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:11:20","cache_get_data",4,"connection: 1",0);
Log("20:11:20","cache_get_field_content",4,"row: 0, field_name: "LastLogin", connection: 1, max_len: 256",0);
Log("20:11:20","CMySQLResult::GetRowDataByName",4,"row: '0', field: "LastLogin", data: "2015-01-11 20:04:04"",0);
Log("20:11:20","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:11:27","mysql_escape_string",4,"source: "parkour01", connection: 1, max_len: 64",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username`='%e' AND `password`='%e'"",0);
Log("20:11:27","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username`='WiDuAlK' AND `password", callback: "WhenPlayerLogin", format: "i"",0);
Log("20:11:27","CMySQLQuery::Execute[WhenPlayerLogin]",4,"starting query execution",1);
Log("20:11:27","CMySQLQuery::Execute[WhenPlayerLogin]",4,"query was successfully executed within 1.280 milliseconds",1);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenPlayerLogin");Log("20:11:27","cache_get_data",4,"connection: 1",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "password", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "password", data: "PARKOUR01"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Level", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Level", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "AdminLevel", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "AdminLevel", data: "6"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "HelperLevel", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "HelperLevel", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Cash", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Cash", data: "300"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Account", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Account", data: "500"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Email", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Email", data: "[email protected]"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Registred", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Registred", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Tutorial", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Tutorial", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Sex", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Sex", data: "1"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Age", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Age", data: "15"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "PhoneNumber", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PhoneNumber", data: "7373009"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "PremiumAccount", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PremiumAccount", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Banned", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Banned", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Warns", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Warns", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Leader", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Leader", data: "8"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Member", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Member", data: "8"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Rank", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Rank", data: "6"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "Skin", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Skin", data: "115"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "RespectPoint", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "RespectPoint", data: "0"",0);
Log("20:11:27","cache_get_field_content",4,"row: 0, field_name: "IP", connection: 1, max_len: 256",0);
Log("20:11:27","CMySQLResult::GetRowDataByName",4,"row: '0', field: "IP", data: "25.129.144.2"",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `Cash`='%d' WHERE `username`='%e'"",0);
Log("20:11:27","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `Cash`='300' WHERE `username`='WiDuAlK'", use_cache: true",0);
Log("20:11:27","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:11:27","CMySQLQuery::Execute",4,"query was successfully executed within 0.896 milliseconds",0);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:11:27","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 1)",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `username`='%e'"",0);
Log("20:11:27","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `usern", use_cache: true",0);
Log("20:11:27","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:11:27","CMySQLQuery::Execute",4,"query was successfully executed within 0.772 milliseconds",0);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:11:27","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 2)",0);
Log("20:11:27","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `IP`='%e' WHERE `username`='%e'"",0);
Log("20:11:27","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `IP`='25.129.144.2' WHERE `username`='WiDuA", use_cache: true",0);
Log("20:11:27","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:11:27","CMySQLQuery::Execute",4,"query was successfully executed within 0.468 milliseconds",0);
Log("20:11:27","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:11:27","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 3)",0);
EndCB();Log("20:13:03","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username` = '%e'"",0);
Log("20:13:03","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username` = 'WiDuAlK'", callback: "WhenAccountCheck", format: "i"",0);
Log("20:13:03","CMySQLQuery::Execute[WhenAccountCheck]",4,"starting query execution",1);
Log("20:13:03","CMySQLQuery::Execute[WhenAccountCheck]",4,"query was successfully executed within 1.382 milliseconds",1);
Log("20:13:03","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenAccountCheck");Log("20:13:03","cache_get_data",4,"connection: 1",0);
Log("20:13:03","cache_get_field_content",4,"row: 0, field_name: "LastLogin", connection: 1, max_len: 256",0);
Log("20:13:03","CMySQLResult::GetRowDataByName",4,"row: '0', field: "LastLogin", data: "2015-01-11 20:11:27"",0);
Log("20:13:03","CMySQLResult::~CMySQLResult()",4,"deconstructor called",0);
EndCB();Log("20:13:08","mysql_escape_string",4,"source: "parkour01", connection: 1, max_len: 64",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "SELECT * FROM `players` WHERE `username`='%e' AND `password`='%e'"",0);
Log("20:13:08","mysql_tquery",4,"connection: 1, query: "SELECT * FROM `players` WHERE `username`='WiDuAlK' AND `password", callback: "WhenPlayerLogin", format: "i"",0);
Log("20:13:08","CMySQLQuery::Execute[WhenPlayerLogin]",4,"starting query execution",1);
Log("20:13:08","CMySQLQuery::Execute[WhenPlayerLogin]",4,"query was successfully executed within 1.7 milliseconds",1);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",1);
StartCB("WhenPlayerLogin");Log("20:13:08","cache_get_data",4,"connection: 1",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "password", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "password", data: "PARKOUR01"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Level", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Level", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "AdminLevel", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "AdminLevel", data: "6"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "HelperLevel", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "HelperLevel", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Cash", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Cash", data: "300"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Account", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Account", data: "500"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Email", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Email", data: "[email protected]"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Registred", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Registred", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Tutorial", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Tutorial", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Sex", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Sex", data: "1"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Age", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Age", data: "15"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "PhoneNumber", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PhoneNumber", data: "7373009"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "PremiumAccount", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "PremiumAccount", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Banned", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Banned", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Warns", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Warns", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Leader", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Leader", data: "8"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Member", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Member", data: "8"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Rank", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Rank", data: "6"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "Skin", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "Skin", data: "115"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "RespectPoint", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "RespectPoint", data: "0"",0);
Log("20:13:08","cache_get_field_content",4,"row: 0, field_name: "IP", connection: 1, max_len: 256",0);
Log("20:13:08","CMySQLResult::GetRowDataByName",4,"row: '0', field: "IP", data: "25.129.144.2"",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `Cash`='%d' WHERE `username`='%e'"",0);
Log("20:13:08","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `Cash`='300' WHERE `username`='WiDuAlK'", use_cache: true",0);
Log("20:13:08","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:13:08","CMySQLQuery::Execute",4,"query was successfully executed within 1.127 milliseconds",0);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:13:08","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 4)",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `username`='%e'"",0);
Log("20:13:08","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `LastLogin`= CURRENT_TIMESTAMP WHERE `usern", use_cache: true",0);
Log("20:13:08","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:13:08","CMySQLQuery::Execute",4,"query was successfully executed within 0.570 milliseconds",0);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:13:08","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 5)",0);
Log("20:13:08","mysql_format",4,"connection: 1, len: 256, format: "UPDATE `players` SET `IP`='%e' WHERE `username`='%e'"",0);
Log("20:13:08","mysql_query",4,"connection: 1, query: "UPDATE `players` SET `IP`='25.129.144.2' WHERE `username`='WiDuA", use_cache: true",0);
Log("20:13:08","CMySQLQuery::Execute",4,"starting query execution",0);
Log("20:13:08","CMySQLQuery::Execute",4,"query was successfully executed within 0.430 milliseconds",0);
Log("20:13:08","CMySQLResult::CMySQLResult()",4,"constructor called",0);
Log("20:13:08","CMySQLHandle::SaveActiveResult",4,"cache saved (id: 6)",0);
EndCB();</script>[13:33:40] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[14:46:14] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:37:17] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[13:14:34] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[20:05:42] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[14:34:36] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[09:16:03] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[21:59:26] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:20:49] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[23:20:54] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[19:44:50] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[18:36:31] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[21:59:45] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on 'localhost' (10061)
[17:08:46] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:09:28] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:13:10] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:17:28] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:18:30] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:28:45] [ERROR] CMySQLConnection::Connect - (error #1049) Base 'datebase' inconnue
[17:50:56] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[17:55:03] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[20:59:03] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[20:59:03] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'

Link to comment
Share on other sites

  • 0

aaa la mysql log

[21:05:58] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[21:05:58] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[21:05:58] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'
[21:05:58] [ERROR] CMySQLConnection::Connect - (error #1049) Unknown database 'datebase'


----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-RC1, (C)2005-2015 SA-MP Team

[21:05:57] filterscripts = ""  (string)
[21:05:57] 
[21:05:57] Server Plugins
[21:05:57] --------------
[21:05:57]  Loading plugin: mysql
[21:05:58]  >> plugin.mysql: R39-3 successfully loaded.
[21:05:58]   Loaded.
[21:05:58]  Loading plugin: streamer
[21:05:58] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[21:05:58]   Loaded.
[21:05:58]  Loading plugin: sscanf
[21:05:58] 

[21:05:58]  ===============================

[21:05:58]       sscanf plugin loaded.     

[21:05:58]          Version:  2.8.1        

[21:05:58]    (c) 2012 Alex "Y_Less" Cole  

[21:05:58]  ===============================

[21:05:58]   Loaded.
[21:05:58]  Loading plugin: mcmd
[21:05:58] [mcmd] Plugin successfully loaded 0.0.1(Compiled on Sep 26 2014, 22:26:46).
[21:05:58]   Loaded.
[21:05:58]  Loaded 4 plugins.

[21:05:58] 
[21:05:58] Filterscripts
[21:05:58] ---------------
[21:05:58]   Loaded 0 filterscripts.

[21:05:58]  
[21:05:58]  ======================================= 
[21:05:58]  |                                     | 
[21:05:58]  |        YSI version 1.04.0000        | 
[21:05:58]  |        By Alex "Y_Less" Cole        | 
[21:05:58]  |                                     | 
[21:05:58]  ======================================= 
[21:05:58]  
[21:05:58] Iter_OnGameModeInit start: 500
[21:05:58] [MYSQL]: conexiunea la baza (datebase) a esuat!
[21:05:58] Iter_OnGameModeInit: first
[21:05:58]  
[21:05:58]  
[21:05:58]  RPG: Alpha LosSantos
[21:05:58] _____________________
[21:05:58] Number of vehicle models: 44
[21:05:58] --- Server Shutting Down.
[21:05:58] plugin.mysql: Unloading plugin...
[21:05:58] plugin.mysql: Plugin unloaded.
[21:05:58] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[21:05:58] 

[21:05:58]  ===============================

[21:05:58]      sscanf plugin unloaded.    

[21:05:58]  ===============================

[21:05:58] [mcmd] Plugin unloaded.

Link to comment
Share on other sites

  • 0
  • 0
  • 0

Nu stiu care poate sa fie problema atunci.

 

Esti sigur ca are acelasi nume?

hai ma wopss, chiar crezi ca nu am mai umblat cu bazele de date? sti prea bine ca inainte de a-mi reinstala windows-ul "ma laudam" la tine cu ce am mai facut din R33  ideal pentru RPG pe care l-ai postat tu... Am importat corect baza cu new>numele bazei(am dat rename>copy>si paste la new basedate), import>search>GO si mi-a aparut tabelurile, deci am importat-o corect. Probabil de la windows, ii fac un update cv si vin cu un reply daca a mers sau nu

Link to comment
Share on other sites

  • 0
Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.