1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese

Threaded Mode
[Ajuda] Pq с entra um novo registro MYSQL casa
maikons
Gangsta
****
Posts: 537
Threads: 147
Joined: Jun 2013
Reputation: 0
#1

09.01.2015, 23:11
Em DINI todo o sistema de casa funcionava perfeito, mas em mysql nгo consigo salvar as casas que eu crio no jogo, to tentando fazer com base num tutorial gringo q eu vi de sistema de login/registro

Nem quando eu crio a casa:
pawn Код:
format(query, sizeof(query), "INSERT INTO houses SET ID = %d, InPosX = %f, InPosY = %f, InPosZ = %f, OutPosX = %f, OutPosY = %f, OutPosZ = %f, World = %d, Price = %d, Owner = %d, Dono = '%s', Money = %d, Maconha = %d, FHQ = %d, Interior = %d",
            HouseInfo[houseid][ID], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Owner], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][FHQ], HouseInfo[houseid][Interior] );
pawn Код:
CMD:makehouse(playerid, params[]) {
        if(admin[playerid] < 6) return 0;
        new houseid, type;
        new query[1024];
        new string[80];
        if(sscanf(params,"ii", houseid, type)) {
            SendClientMessage(playerid, -1, "Use: /makehouse [houseid] [type]");
            SendClientMessage(playerid, -1, "types: 1-pequena 2-media 3-grande 4-mansгo 5-vip");
            return 1;
        }
        switch( type ) {
            case 1: { // Pequena
                HouseInfo[houseid][InPosX] = 223.20;
                HouseInfo[houseid][InPosY] = 1287.08;
                HouseInfo[houseid][InPosZ] = 1082.14;
                HouseInfo[houseid][Interior] = 1;
                HouseInfo[houseid][Price] = 500000;
            }
            case 2: { // media
                HouseInfo[houseid][InPosX] = 2365.31;
                HouseInfo[houseid][InPosY] = -1135.60;
                HouseInfo[houseid][InPosZ] = 1050.88;
                HouseInfo[houseid][Interior] = 8;
                HouseInfo[houseid][Price] = 3000000;
            }
            case 3: { // grande
                HouseInfo[houseid][InPosX] = 446.99;
                HouseInfo[houseid][InPosY] = 1397.07;
                HouseInfo[houseid][InPosZ] = 1084.30;
                HouseInfo[houseid][Interior] = 2;
                HouseInfo[houseid][Price] = 10000000;
            }
            case 4: { // mansгo
                HouseInfo[houseid][InPosX] = 2196.85;
                HouseInfo[houseid][InPosY] = -1204.25;
                HouseInfo[houseid][InPosZ] = 1049.02;
                HouseInfo[houseid][Interior] = 6;
                HouseInfo[houseid][Price] = 100000000;

            }
            case 5: { // VIP
                HouseInfo[houseid][InPosX] = 140.17;
                HouseInfo[houseid][InPosY] = 1366.07;
                HouseInfo[houseid][InPosZ] = 1083.65;
                HouseInfo[houseid][Interior] = 5;
                HouseInfo[houseid][Price] = 3000; // abaixo de 10000 vai ser DP
            }
        }
        HouseInfo[houseid][Owner] = 0;
        HouseInfo[houseid][FHQ] = 0;
        HouseInfo[houseid][ID] = houseid;
        GetPlayerPos(playerid, HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ]);
        

        
        format(query, sizeof(query), "INSERT INTO houses SET ID = %d, InPosX = %f, InPosY = %f, InPosZ = %f, OutPosX = %f, OutPosY = %f, OutPosZ = %f, World = %d, Price = %d, Owner = %d, Dono = '%s', Money = %d, Maconha = %d, FHQ = %d, Interior = %d",
            HouseInfo[houseid][ID], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Owner], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][FHQ], HouseInfo[houseid][Interior] );
        
        format(string, sizeof(string), "%s criou uma nova casa!", PlayerName(playerid) );
        SendClientMessage(playerid, COLOR_LIGHTRED, string);
        RefreshHouses();
        return 1;
    }
Nem quando o servidor reinicia depois de ter criado
Ongamemodeexit: SalvarCasas();
pawn Код:
stock SalvarCasas() {   
    for(new houseid; houseid < MAX_HOUSES; houseid++)
    {
        new query[1024];
        format(query, sizeof(query), "UPDATE houses SET OutPosX = %f , OutPosY = %f, OutPosZ = %f, InPosX = %f, InPosY = %f, InPosZ = %f, ",
            HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
        format(query, sizeof(query), "%s World = %d, Price = %d, Interior = %d, Locked = %d, Dono = %s, FHQ = %d, Money = %d, Maconha = %d, Owner = %d WHERE ID = %d",
            query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
        mysql_pquery(ConnectMYSQL, query);
    }
}
Find
Reply
Skream
Banned
Posts: 225
Threads: 19
Joined: Apr 2012
#2

09.01.2015, 23:12
Sйrio, busca no ****** como se usar SQL. isso aqui tб super errado
pawn Код:
"INSERT INTO houses SET ID = %d, InPosX = %f, InPosY = %f, InPosZ = %f, OutPosX = %f, OutPosY = %f, OutPosZ = %f, World = %d, Price = %d, Owner = %d, Dono = '%s', Money = %d, Maconha = %d, FHQ = %d, Interior = %d"
Find
Reply
PT
Godfather
*****
Posts: 7,185
Threads: 5
Joined: Nov 2012
Reputation: 0
#3

09.01.2015, 23:22
http://www.w3schools.com/sql/sql_insert.asp

Ajudara voce bastante a entender.
Find
Reply
mau.tito
High-roller
*****
Posts: 1,989
Threads: 84
Joined: Jan 2012
Reputation: 0
#4

09.01.2015, 23:31
pawn Код:
INSERT INTO `tabela` ( `coluna` ) VALUES ('resposta')
Find
Reply
maikons
Gangsta
****
Posts: 537
Threads: 147
Joined: Jun 2013
Reputation: 0
#5

10.01.2015, 03:59
Nгo estб certo assim?
pawn Код:
CMD:makehouse(playerid, params[]) {
        if(admin[playerid] < 6) return 0;
        new houseid, type;
        new query[1024];
        new string[80];
        if(sscanf(params,"ii", houseid, type)) {
            SendClientMessage(playerid, -1, "Use: /makehouse [houseid] [type]");
            SendClientMessage(playerid, -1, "types: 1-pequena 2-media 3-grande 4-mansгo 5-vip");
            return 1;
        }
        switch( type ) {
            case 1: { // Pequena
                HouseInfo[houseid][InPosX] = 223.20;
                HouseInfo[houseid][InPosY] = 1287.08;
                HouseInfo[houseid][InPosZ] = 1082.14;
                HouseInfo[houseid][Interior] = 1;
                HouseInfo[houseid][Price] = 500000;
            }
            case 2: { // media
                HouseInfo[houseid][InPosX] = 2365.31;
                HouseInfo[houseid][InPosY] = -1135.60;
                HouseInfo[houseid][InPosZ] = 1050.88;
                HouseInfo[houseid][Interior] = 8;
                HouseInfo[houseid][Price] = 3000000;
            }
            case 3: { // grande
                HouseInfo[houseid][InPosX] = 446.99;
                HouseInfo[houseid][InPosY] = 1397.07;
                HouseInfo[houseid][InPosZ] = 1084.30;
                HouseInfo[houseid][Interior] = 2;
                HouseInfo[houseid][Price] = 10000000;
            }
            case 4: { // mansгo
                HouseInfo[houseid][InPosX] = 2196.85;
                HouseInfo[houseid][InPosY] = -1204.25;
                HouseInfo[houseid][InPosZ] = 1049.02;
                HouseInfo[houseid][Interior] = 6;
                HouseInfo[houseid][Price] = 100000000;

            }
            case 5: { // VIP
                HouseInfo[houseid][InPosX] = 140.17;
                HouseInfo[houseid][InPosY] = 1366.07;
                HouseInfo[houseid][InPosZ] = 1083.65;
                HouseInfo[houseid][Interior] = 5;
                HouseInfo[houseid][Price] = 3000; // abaixo de 10000 vai ser DP
            }
        }
        HouseInfo[houseid][Owner] = 0;
        HouseInfo[houseid][FHQ] = 0;
        HouseInfo[houseid][ID] = houseid;
        GetPlayerPos(playerid, HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ]);
        
        format(query, sizeof(query), "INSERT INTO `houses` SET `OutPosX` = '%f' , `OutPosY` = '%f', `OutPosZ` = '%f', `InPosX` = '%f', `InPosY` = '%f', `InPosZ` = '%f', ",
            HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
        format(query, sizeof(query), "%s `World` = '%d', `Price` = '%d', `Interior` = '%d', `Locked` = '%d', `Dono` = '%s', `FHQ` = '%d', `Money` = '%d', `Maconha` = '%d', `Owner` = '%d' WHERE `ID` = '%d'",
            query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
        mysql_pquery(ConnectMYSQL, query);
        
        format(string, sizeof(string), "%s criou uma nova casa!", PlayerName(playerid) );
        SendClientMessage(playerid, COLOR_LIGHTRED, string);
        RefreshHouses();
        return 1;
    }
Pq nгo estб registrando?
Qnd troca a linha tem q colocar um %s? Pq?
Find
Reply
CLANdok
Huge Clucker
****
Posts: 346
Threads: 27
Joined: Oct 2013
Reputation: 0
#6

10.01.2015, 04:05
Tenta trocar
Код:
mysql_pquery(ConnectMYSQL, query);
Por
Код:
mysql_query(ConnectMYSQL, query);
Mande o seu
Код:
mysql_log.txt
mas certamente vocк deve estar errando no format
Find
Reply
maikons
Gangsta
****
Posts: 537
Threads: 147
Joined: Jun 2013
Reputation: 0
#7

10.01.2015, 13:34
To tentando assim:
pawn Код:
CMD:makehouse(playerid, params[]) {
        if(admin[playerid] < 6) return 0;
        new houseid, type;
        new query[1024];
        new string[80];
        if(sscanf(params,"ii", houseid, type)) {
            SendClientMessage(playerid, -1, "Use: /makehouse [houseid] [type]");
            SendClientMessage(playerid, -1, "types: 1-pequena 2-media 3-grande 4-mansгo 5-vip");
            return 1;
        }
        switch( type ) {
            case 1: { // Pequena
                HouseInfo[houseid][InPosX] = 223.20;
                HouseInfo[houseid][InPosY] = 1287.08;
                HouseInfo[houseid][InPosZ] = 1082.14;
                HouseInfo[houseid][Interior] = 1;
                HouseInfo[houseid][Price] = 500000;
            }
            case 2: { // media
                HouseInfo[houseid][InPosX] = 2365.31;
                HouseInfo[houseid][InPosY] = -1135.60;
                HouseInfo[houseid][InPosZ] = 1050.88;
                HouseInfo[houseid][Interior] = 8;
                HouseInfo[houseid][Price] = 3000000;
            }
            case 3: { // grande
                HouseInfo[houseid][InPosX] = 446.99;
                HouseInfo[houseid][InPosY] = 1397.07;
                HouseInfo[houseid][InPosZ] = 1084.30;
                HouseInfo[houseid][Interior] = 2;
                HouseInfo[houseid][Price] = 10000000;
            }
            case 4: { // mansгo
                HouseInfo[houseid][InPosX] = 2196.85;
                HouseInfo[houseid][InPosY] = -1204.25;
                HouseInfo[houseid][InPosZ] = 1049.02;
                HouseInfo[houseid][Interior] = 6;
                HouseInfo[houseid][Price] = 100000000;

            }
            case 5: { // VIP
                HouseInfo[houseid][InPosX] = 140.17;
                HouseInfo[houseid][InPosY] = 1366.07;
                HouseInfo[houseid][InPosZ] = 1083.65;
                HouseInfo[houseid][Interior] = 5;
                HouseInfo[houseid][Price] = 3000; // abaixo de 10000 vai ser DP
            }
        }
        HouseInfo[houseid][Owner] = 0;
        HouseInfo[houseid][FHQ] = 0;
        HouseInfo[houseid][ID] = houseid;
        GetPlayerPos(playerid, HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ]);
        
        format(query, sizeof(query), "INSERT INTO `houses` SET `OutPosX` = '%f' , `OutPosY` = '%f', `OutPosZ` = '%f', `InPosX` = '%f', `InPosY` = '%f', `InPosZ` = '%f', ",
            HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
        format(query, sizeof(query), "%s `World` = '%d', `Price` = '%d', `Interior` = '%d', `Locked` = '%d', `Dono` = '%s', `FHQ` = '%d', `Money` = '%d', `Maconha` = '%d', `Owner` = '%d' WHERE `ID` = '%d'",
            query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
        mysql_pquery(ConnectMYSQL, query);
        
        format(string, sizeof(string), "%s criou uma nova casa!", PlayerName(playerid) );
        SendClientMessage(playerid, COLOR_LIGHTRED, string);
        RefreshHouses();
        return 1;
    }
Onde estб o erro de sintaxe?
%d precisa de ''?
qnd pula uma linha tem q botar %s? pq?


[12:15:47] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `ID` = '1'' at line 1
Find
Reply
maikons
Gangsta
****
Posts: 537
Threads: 147
Joined: Jun 2013
Reputation: 0
#8

10.01.2015, 17:19
??
Find
Reply
s4kuL
High-roller
*****
Posts: 1,114
Threads: 183
Joined: Apr 2012
Reputation: 0
#9

10.01.2015, 17:29
Criou a tabela certinho ? pelo visto parece que nгo ..
Find
Reply
Seidel
Little Clucker
**
Posts: 38
Threads: 0
Joined: Nov 2014
Reputation: 0
#10

10.01.2015, 17:52
Filho, mau.tito, PT e Skream jб disseram o que vocк errou e onde errou.

Para usar insert vocк deve seguir este padrгo (como o mau.tito falou):
Код:
INSERT INTO `tabela` ( `coluna` ) VALUES ('resposta')
OU SEJA:
Код:
"INSERT INTO TABELA = houses (COLUNAS = OutPosX, OutPosY... ) VALUES (RESPOSTAS = '%f', '%f' ...)
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese