[REZOLVAT] Problema mysql

[Deagle]

• Username : Deagle
• Problema întâlnită: Nu mi se connecteaza gm-ul la baza de date.
• Detalii despre problemă: -
• Ce ai încercat să faci înainte să postezi?: Sa fac connectiunea la function sqlConnect() si sa pun ConnType pe 1
• Cod sursa (recomandat pastebin.com) : -
• Alte detalii :-

function sqlConnect() {
	    if(ConnType == 1) gSQL = mysql_connect("localhost", "root", "sapphire2", "");
	    else gSQL = mysql_connect("", "", "", "");		</pre>
<li>		

Edited August 28, 2018 by Deagle

[Matt]

Acum 35 minute, Deagle a spus:

• Username : Deagle
• Problema întâlnită: Nu mi se connecteaza gm-ul la baza de date.
• Detalii despre problemă: -
• Ce ai încercat să faci înainte să postezi?: Sa fac connectiunea la function sqlConnect() si sa pun ConnType pe 1
• Cod sursa (recomandat pastebin.com) : -
• Alte detalii :-
•  

function sqlConnect() {
	    if(ConnType == 1) gSQL = mysql_connect("localhost", "root", "sapphire2", "");
	    else gSQL = mysql_connect("", "", "", "");		</pre>
<li>		

Arata si unde ii dai valoarea 1 variabilei ConnType.

[Deagle]

new ConnType = 1;

Si mai este folosita aici:

public OnRconLoginAttempt(ip[], password[], success) {
    new gIP[20], gPlayer;
    foreach(new x: Player) {
        if(IsPlayerConnected(x)) {
            new gip[20]; GetPlayerIp(x, gip, sizeof gip);
            if(strmatch(gip, ip)) format(gIP, sizeof gIP, "%s", ip); gPlayer = x; break;
        }
    }
    if(!strmatch(gIP, "84.117.40.202") && ConnType == 2) return Kick(gPlayer);
    return 1;
}

Acum 5 minute, iMatt a spus:

Arata si unde ii dai valoarea 1 variabilei ConnType.

 

[Matt]

Acum 2 minute, Deagle a spus:

new ConnType = 1;

Si mai este folosita aici:

 

public OnRconLoginAttempt(ip[], password[], success) {
    new gIP[20], gPlayer;
    foreach(new x: Player) {
        if(IsPlayerConnected(x)) {
            new gip[20]; GetPlayerIp(x, gip, sizeof gip);
            if(strmatch(gip, ip)) format(gIP, sizeof gIP, "%s", ip); gPlayer = x; break;
        }
    }
    if(!strmatch(gIP, "84.117.40.202") && ConnType == 2) return Kick(gPlayer);
    return 1;
}

 

 

Hm, arata si ce este in mysql_log..

[Deagle]

 

Acum 36 minute, iMatt a spus:

Hm, arata si ce este in mysql_log..

https://pastebin.com/jD230t5a / https://pastebin.com/xscW1Dkz

[Dennis12]

Ai in localhost/phpmyadmin respectiv 127.0.0.1/phpmyadmin baza de date sapphire2 importata ? 

[Deagle]

Acum 3 minute, Dennis12 a spus:

Ai in localhost/phpmyadmin respectiv 127.0.0.1/phpmyadmin baza de date sapphire2 importata ? 

Da.

 

[Deagle]

UP..

Toate erorile sunt la liniile astea:

	function loadMySQLSystems() {
    mysql_pquery(gSQL, "SELECT * FROM `server_dmv_checkpoints` ORDER BY `dmvCPID` ASC", "loadQuery", "d", DATA_DMV_CP);
    mysql_pquery(gSQL, "SELECT * FROM `server_jobs` ORDER BY `jobID` ASC", "loadQuery", "d", DATA_JOBS);
    mysql_pquery(gSQL, "SELECT * FROM `server_wanted_list` ORDER BY `wantedID` ASC", "loadQuery", "d", DATA_WANTED_OPTIONS);
    mysql_pquery(gSQL, "SELECT * FROM `server_pets` ORDER BY `petID` ASC", "loadQuery", "d", DATA_PETS);
    mysql_pquery(gSQL, "SELECT * FROM `server_groups` ORDER BY `groupID` ASC", "loadQuery", "d", DATA_GROUPS);
    mysql_pquery(gSQL, "SELECT * FROM `server_group_vehicles` ORDER BY `groupVehicleID` ASC", "loadQuery", "d", DATA_GROUP_VEHICLES);
    mysql_pquery(gSQL, "SELECT * FROM `server_group_skins` ORDER BY `skinID` ASC", "loadQuery", "d", DATA_GROUP_SKINS);
    mysql_pquery(gSQL, "SELECT * FROM `server_group_activity` ORDER BY `groupRaportID` ASC", "loadQuery", "d", DATA_GROUP_AR);
    mysql_pquery(gSQL, "SELECT * FROM `server_group_ranknames` ORDER BY `rankNameID` ASC", "loadQuery", "d", DATA_GROUP_RANKNAMES);
    mysql_pquery(gSQL, "SELECT * FROM `server_group_colors` ORDER BY `colorID` ASC", "loadQuery", "d", DATA_GROUP_COLORS);
    mysql_pquery(gSQL, "SELECT * FROM `server_locations` ORDER BY `locationID` ASC", "loadQuery", "d", DATA_LOCATIONS);
    mysql_pquery(gSQL, "SELECT * FROM `server_eat_places` ORDER BY `eatStandID` ASC", "loadQuery", "d", DATA_EATPLACES);
    mysql_pquery(gSQL, "SELECT * FROM `server_atms` ORDER BY `atmID` ASC", "loadQuery", "d", DATA_ATMS);
    mysql_pquery(gSQL, "SELECT * FROM `server_golocations` ORDER BY `goID` ASC", "loadQuery", "d", DATA_GO_LOCATIONS);
    mysql_pquery(gSQL, "SELECT * FROM `server_ticket_list` ORDER BY `ticketID` ASC", "loadQuery", "d", DATA_TICKET_OPTIONS);
    mysql_pquery(gSQL, "SELECT * FROM `server_svars` ORDER BY `svarID` ASC", "loadQuery", "d", DATA_SVARS);
    mysql_pquery(gSQL, "SELECT * FROM `server_treasurehunt` ORDER BY `treasureID` ASC", "loadQuery", "d", DATA_TREASUREHUNT);
    return 1; 
}

[Deagle]

up.

Cineva?

[SorinELCapo2]

Incearca asta

function sqlConnect() {
	    if(ConnType == 1) gSQL = mysql_connect("localhost", "root", "", "sapphire2");
	    else gSQL = mysql_connect("", "", "", "");		</pre>
<li>

PS:

Poate ai #define SQL_HOST si pui datele acolo !

Edited August 31, 2018 by SorinELCapo2