« előző következő »
Oldalak: [1] 2   Le

Szerző Téma: MySQL betöltés probléma  (Megtekintve 3435 alkalommal)

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Dátum: 2015. március 27. - 14:37:03 »
0 Show voters
Sziasztok!
Elkezdtem írogatni egy modot, és mysql-al szeretné menteni.... csakhogy nem vagyok túl jó mysql-ban :( na mind1 találtam egy jó tutorialt YT-n és azalapján megcsináltam. Ezzel eddig nincs gond, csakhogy betöltésnél egyszerűn nem csinál semmit, majd leáll a szerver. Fogalmam nincs miért hátha ti tudtok segíteni :hmmm:
 

            format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_query(query);
            mysql_store_result();
            
            
            INFO(playerid, \"Kérlek várj!\");
            new pos[32];
            new int[32];
            while(mysql_fetch_row_format(query, \"|\"))
            {
                mysql_fetch_field_row(int, \"Created1\"); pInfo[playerid][1][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created2\"); pInfo[playerid][2][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created3\"); pInfo[playerid][3][Created] = strval(int);
                mysql_fetch_field_row(nstr[1][playerid], \"CharName1\");
                mysql_fetch_field_row(nstr[2][playerid], \"CharName2\");
                mysql_fetch_field_row(nstr[3][playerid], \"CharName3\");
                mysql_fetch_field_row(int, \"Age1\"); pInfo[playerid][1][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age2\"); pInfo[playerid][2][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age3\"); pInfo[playerid][3][Age] = strval(int);
                mysql_fetch_field_row(int, \"Hati1\"); pInfo[playerid][1][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati2\"); pInfo[playerid][2][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati3\"); pInfo[playerid][3][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Sex1\"); pInfo[playerid][1][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex2\"); pInfo[playerid][2][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex3\"); pInfo[playerid][3][sex] = strval(int);
                mysql_fetch_field_row(int, \"Skin1\"),pInfo[playerid][1][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin2\"); pInfo[playerid][2][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin3\"); pInfo[playerid][3][skin] = strval(int);
                mysql_fetch_field_row(pos, \"pX1\"); pInfo[playerid][1][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX2\"); pInfo[playerid][2][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX3\"); pInfo[playerid][3][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY1\"); pInfo[playerid][1][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY2\"); pInfo[playerid][2][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY3\"); pInfo[playerid][3][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ1\"); pInfo[playerid][1][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ2\"); pInfo[playerid][2][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ3\"); pInfo[playerid][3][pZ] = floatstr(pos);
                mysql_fetch_field_row(int, \"Money1\"); pInfo[playerid][1][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money2\"); pInfo[playerid][2][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money3\"); pInfo[playerid][3][Money] = strval(int);
                mysql_fetch_field_row(int, \"Admin1\"); pInfo[playerid][1][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin2\"); pInfo[playerid][2][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin3\"); pInfo[playerid][3][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Ora1\"); pInfo[playerid][1][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora2\"); pInfo[playerid][2][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora3\"); pInfo[playerid][3][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Perc1\"); pInfo[playerid][1][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc2\"); pInfo[playerid][2][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc3\"); pInfo[playerid][3][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio1\"); pInfo[playerid][1][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio2\"); pInfo[playerid][2][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio3\"); pInfo[playerid][3][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Leader1\"); pInfo[playerid][1][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader2\"); pInfo[playerid][2][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader3\"); pInfo[playerid][3][Leader] = strval(int);
                mysql_fetch_field_row(int, \"FFizu1\"); pInfo[playerid][1][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu2\"); pInfo[playerid][2][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu3\"); pInfo[playerid][3][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu1\"); pInfo[playerid][1][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu2\"); pInfo[playerid][2][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu3\"); pInfo[playerid][3][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz1\"); pInfo[playerid][1][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz2\"); pInfo[playerid][2][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz3\"); pInfo[playerid][3][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Munka1\"); pInfo[playerid][1][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka2\"); pInfo[playerid][2][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka3\"); pInfo[playerid][3][Munka] = strval(int);
                
                mysql_fetch_field_row(int, \"INV_Slot1_1\"); pInfo[playerid][1][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_2\"); pInfo[playerid][2][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_3\"); pInfo[playerid][3][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_1\"); pInfo[playerid][1][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_2\"); pInfo[playerid][2][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_3\"); pInfo[playerid][3][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_1\"); pInfo[playerid][1][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_2\"); pInfo[playerid][2][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_3\"); pInfo[playerid][3][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_1\"); pInfo[playerid][1][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_2\"); pInfo[playerid][2][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_3\"); pInfo[playerid][3][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_1\"); pInfo[playerid][1][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_2\"); pInfo[playerid][2][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_3\"); pInfo[playerid][3][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_1\"); pInfo[playerid][1][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_2\"); pInfo[playerid][2][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_3\"); pInfo[playerid][3][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_1\"); pInfo[playerid][1][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_2\"); pInfo[playerid][2][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_3\"); pInfo[playerid][3][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_1\"); pInfo[playerid][1][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_2\"); pInfo[playerid][2][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_3\"); pInfo[playerid][3][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_1\"); pInfo[playerid][1][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_2\"); pInfo[playerid][2][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_3\"); pInfo[playerid][3][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_1\"); pInfo[playerid][1][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_2\"); pInfo[playerid][2][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_3\"); pInfo[playerid][3][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_1\"); pInfo[playerid][1][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_2\"); pInfo[playerid][2][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_3\"); pInfo[playerid][3][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_1\"); pInfo[playerid][1][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_2\"); pInfo[playerid][2][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_3\"); pInfo[playerid][3][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_1\"); pInfo[playerid][1][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_2\"); pInfo[playerid][2][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_3\"); pInfo[playerid][3][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_1\"); pInfo[playerid][1][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_2\"); pInfo[playerid][2][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_3\"); pInfo[playerid][3][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_1\"); pInfo[playerid][1][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_2\"); pInfo[playerid][2][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_3\"); pInfo[playerid][3][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_1\"); pInfo[playerid][1][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_2\"); pInfo[playerid][2][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_3\"); pInfo[playerid][3][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_1\"); pInfo[playerid][1][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_2\"); pInfo[playerid][2][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_3\"); pInfo[playerid][3][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_1\"); pInfo[playerid][1][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_2\"); pInfo[playerid][2][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_3\"); pInfo[playerid][3][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_1\"); pInfo[playerid][1][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_2\"); pInfo[playerid][2][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_3\"); pInfo[playerid][3][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_1\"); pInfo[playerid][1][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_2\"); pInfo[playerid][2][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_3\"); pInfo[playerid][3][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_1\"); pInfo[playerid][1][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_2\"); pInfo[playerid][2][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_3\"); pInfo[playerid][3][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_1\"); pInfo[playerid][1][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_2\"); pInfo[playerid][2][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_3\"); pInfo[playerid][3][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_1\"); pInfo[playerid][1][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_2\"); pInfo[playerid][2][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_3\"); pInfo[playerid][3][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_1\"); pInfo[playerid][1][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_2\"); pInfo[playerid][2][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_3\"); pInfo[playerid][3][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_1\"); pInfo[playerid][1][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_2\"); pInfo[playerid][2][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_3\"); pInfo[playerid][3][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_1\"); pInfo[playerid][1][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_2\"); pInfo[playerid][2][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_3\"); pInfo[playerid][3][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_1\"); pInfo[playerid][1][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_2\"); pInfo[playerid][2][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_3\"); pInfo[playerid][3][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_1\"); pInfo[playerid][1][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_2\"); pInfo[playerid][2][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_3\"); pInfo[playerid][3][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_1\"); pInfo[playerid][1][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_2\"); pInfo[playerid][2][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_3\"); pInfo[playerid][3][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_1\"); pInfo[playerid][1][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_2\"); pInfo[playerid][2][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_3\"); pInfo[playerid][3][iNV_Star15] = strval(int);
                
            }

 
Ez lenne felelős betölteni az adatokat, minden a videó alapján van és mégse jó.... Tapasztalat: azt még kiírja h várjak, de a while-t egyszerűen \"nem indítja el\".
Itt az a videó(sorozat) és annak a része:

 Remélem valaki tud segíteni, előre is köszi :)
« Utoljára szerkesztve: 2015. március 27. - 21:39:56 írta RusH. »
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #1 Dátum: 2015. március 27. - 18:01:51 »
0 Show voters
így elég nehézkes rá jönni de nem tudom milyen mód az amiben így kell betölteni 1 DB koordinátát..
 

                              mysql_fetch_field_row(pos, \"pX1\"); pInfo[playerid][1][pX] = floatstr(pos);
                                mysql_fetch_field_row(pos, \"pX2\"); pInfo[playerid][2][pX] = floatstr(pos);
                                mysql_fetch_field_row(pos, \"pX3\"); pInfo[playerid][3][pX] = floatstr(pos);

 
és az érdekesség az hogy ez Y al és Z vel is megvan...
Naplózva

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #2 Dátum: 2015. március 27. - 18:05:34 »
0 Show voters
3 karit lehet létrehozni egy acc-on ha kicsit gondolkodsz(nem sértés) rájössz hogy a \"pX1\" az X pozícióját jelenti az 1 karakternek, és ugyan így a töbinél, nem tudod miért nem akar jó lenni? elv. működnie kéne
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #3 Dátum: 2015. március 27. - 19:02:59 »
0 Show voters
sajnálom bocsi ne bánts... bár érdekes... Az én \"gondolkodási módszerem szerint\"
1 ucp_fh tábla + 1 playerek tábla és akkor lehet hogy nem néz ki így... sry bocsi akkor [Így néz ki az én módomban de én tulajdonképpen kivagyok?]
viszont bizonyára azt tudod hogy a crashdetect lehet hogy ki írja mi a baj + spawnplayer(playerid); nem látok tehát ezért nehezebb a dolgok...
Naplózva

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #4 Dátum: 2015. március 27. - 19:25:15 »
0 Show voters
upc-t nem tudok mivel nem értek PHP-hoz, crashdetect-t mingy kipróbálom amúgy bemásolom azzal eggyüt ami van a betöltés után
 

format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_query(query);
            mysql_store_result();
            
            
            INFO(playerid, \"Kérlek várj!\");
            new pos[32];
            new int[32];
            while(mysql_fetch_row_format(query, \"|\"))
            {
                mysql_fetch_field_row(int, \"Created1\"); pInfo[playerid][1][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created2\"); pInfo[playerid][2][Created] = strval(int);
                mysql_fetch_field_row(int, \"Created3\"); pInfo[playerid][3][Created] = strval(int);
                mysql_fetch_field_row(nstr[1][playerid], \"CharName1\");
                mysql_fetch_field_row(nstr[2][playerid], \"CharName2\");
                mysql_fetch_field_row(nstr[3][playerid], \"CharName3\");
                mysql_fetch_field_row(int, \"Age1\"); pInfo[playerid][1][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age2\"); pInfo[playerid][2][Age] = strval(int);
                mysql_fetch_field_row(int, \"Age3\"); pInfo[playerid][3][Age] = strval(int);
                mysql_fetch_field_row(int, \"Hati1\"); pInfo[playerid][1][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati2\"); pInfo[playerid][2][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Hati3\"); pInfo[playerid][3][Hatizsak] = strval(int);
                mysql_fetch_field_row(int, \"Sex1\"); pInfo[playerid][1][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex2\"); pInfo[playerid][2][sex] = strval(int);
                mysql_fetch_field_row(int, \"Sex3\"); pInfo[playerid][3][sex] = strval(int);
                mysql_fetch_field_row(int, \"Skin1\"),pInfo[playerid][1][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin2\"); pInfo[playerid][2][skin] = strval(int);
                mysql_fetch_field_row(int, \"Skin3\"); pInfo[playerid][3][skin] = strval(int);
                mysql_fetch_field_row(pos, \"pX1\"); pInfo[playerid][1][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX2\"); pInfo[playerid][2][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pX3\"); pInfo[playerid][3][pX] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY1\"); pInfo[playerid][1][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY2\"); pInfo[playerid][2][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pY3\"); pInfo[playerid][3][pY] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ1\"); pInfo[playerid][1][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ2\"); pInfo[playerid][2][pZ] = floatstr(pos);
                mysql_fetch_field_row(pos, \"pZ3\"); pInfo[playerid][3][pZ] = floatstr(pos);
                mysql_fetch_field_row(int, \"Money1\"); pInfo[playerid][1][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money2\"); pInfo[playerid][2][Money] = strval(int);
                mysql_fetch_field_row(int, \"Money3\"); pInfo[playerid][3][Money] = strval(int);
                mysql_fetch_field_row(int, \"Admin1\"); pInfo[playerid][1][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin2\"); pInfo[playerid][2][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Admin3\"); pInfo[playerid][3][Admin] = strval(int);
                mysql_fetch_field_row(int, \"Ora1\"); pInfo[playerid][1][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora2\"); pInfo[playerid][2][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Ora3\"); pInfo[playerid][3][Ora] = strval(int);
                mysql_fetch_field_row(int, \"Perc1\"); pInfo[playerid][1][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc2\"); pInfo[playerid][2][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Perc3\"); pInfo[playerid][3][Perc] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio1\"); pInfo[playerid][1][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio2\"); pInfo[playerid][2][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Frakcio3\"); pInfo[playerid][3][Frakcio] = strval(int);
                mysql_fetch_field_row(int, \"Leader1\"); pInfo[playerid][1][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader2\"); pInfo[playerid][2][Leader] = strval(int);
                mysql_fetch_field_row(int, \"Leader3\"); pInfo[playerid][3][Leader] = strval(int);
                mysql_fetch_field_row(int, \"FFizu1\"); pInfo[playerid][1][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu2\"); pInfo[playerid][2][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"FFizu3\"); pInfo[playerid][3][FFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu1\"); pInfo[playerid][1][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu2\"); pInfo[playerid][2][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"MFizu3\"); pInfo[playerid][3][MFizu] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz1\"); pInfo[playerid][1][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz2\"); pInfo[playerid][2][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Felfiz3\"); pInfo[playerid][3][Felfiz] = strval(int);
                mysql_fetch_field_row(int, \"Munka1\"); pInfo[playerid][1][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka2\"); pInfo[playerid][2][Munka] = strval(int);
                mysql_fetch_field_row(int, \"Munka3\"); pInfo[playerid][3][Munka] = strval(int);
                
                mysql_fetch_field_row(int, \"INV_Slot1_1\"); pInfo[playerid][1][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_2\"); pInfo[playerid][2][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot1_3\"); pInfo[playerid][3][iNV_Slot1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_1\"); pInfo[playerid][1][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_2\"); pInfo[playerid][2][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot2_3\"); pInfo[playerid][3][iNV_Slot2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_1\"); pInfo[playerid][1][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_2\"); pInfo[playerid][2][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot3_3\"); pInfo[playerid][3][iNV_Slot3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_1\"); pInfo[playerid][1][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_2\"); pInfo[playerid][2][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot4_3\"); pInfo[playerid][3][iNV_Slot4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_1\"); pInfo[playerid][1][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_2\"); pInfo[playerid][2][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot5_3\"); pInfo[playerid][3][iNV_Slot5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_1\"); pInfo[playerid][1][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_2\"); pInfo[playerid][2][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot6_3\"); pInfo[playerid][3][iNV_Slot6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_1\"); pInfo[playerid][1][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_2\"); pInfo[playerid][2][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot7_3\"); pInfo[playerid][3][iNV_Slot7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_1\"); pInfo[playerid][1][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_2\"); pInfo[playerid][2][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot8_3\"); pInfo[playerid][3][iNV_Slot8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_1\"); pInfo[playerid][1][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_2\"); pInfo[playerid][2][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot9_3\"); pInfo[playerid][3][iNV_Slot9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_1\"); pInfo[playerid][1][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_2\"); pInfo[playerid][2][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot10_3\"); pInfo[playerid][3][iNV_Slot10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_1\"); pInfo[playerid][1][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_2\"); pInfo[playerid][2][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot11_3\"); pInfo[playerid][3][iNV_Slot11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_1\"); pInfo[playerid][1][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_2\"); pInfo[playerid][2][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot12_3\"); pInfo[playerid][3][iNV_Slot12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_1\"); pInfo[playerid][1][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_2\"); pInfo[playerid][2][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot13_3\"); pInfo[playerid][3][iNV_Slot13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_1\"); pInfo[playerid][1][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_2\"); pInfo[playerid][2][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot14_3\"); pInfo[playerid][3][iNV_Slot14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_1\"); pInfo[playerid][1][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_2\"); pInfo[playerid][2][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Slot15_3\"); pInfo[playerid][3][iNV_Slot15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_1\"); pInfo[playerid][1][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_2\"); pInfo[playerid][2][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star1_3\"); pInfo[playerid][3][iNV_Star1] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_1\"); pInfo[playerid][1][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_2\"); pInfo[playerid][2][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star2_3\"); pInfo[playerid][3][iNV_Star2] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_1\"); pInfo[playerid][1][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_2\"); pInfo[playerid][2][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star3_3\"); pInfo[playerid][3][iNV_Star3] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_1\"); pInfo[playerid][1][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_2\"); pInfo[playerid][2][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star4_3\"); pInfo[playerid][3][iNV_Star4] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_1\"); pInfo[playerid][1][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_2\"); pInfo[playerid][2][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star5_3\"); pInfo[playerid][3][iNV_Star5] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_1\"); pInfo[playerid][1][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_2\"); pInfo[playerid][2][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star6_3\"); pInfo[playerid][3][iNV_Star6] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_1\"); pInfo[playerid][1][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_2\"); pInfo[playerid][2][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star7_3\"); pInfo[playerid][3][iNV_Star7] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_1\"); pInfo[playerid][1][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_2\"); pInfo[playerid][2][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star8_3\"); pInfo[playerid][3][iNV_Star8] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_1\"); pInfo[playerid][1][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_2\"); pInfo[playerid][2][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star9_3\"); pInfo[playerid][3][iNV_Star9] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_1\"); pInfo[playerid][1][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_2\"); pInfo[playerid][2][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star10_3\"); pInfo[playerid][3][iNV_Star10] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_1\"); pInfo[playerid][1][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_2\"); pInfo[playerid][2][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star11_3\"); pInfo[playerid][3][iNV_Star11] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_1\"); pInfo[playerid][1][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_2\"); pInfo[playerid][2][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star12_3\"); pInfo[playerid][3][iNV_Star12] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_1\"); pInfo[playerid][1][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_2\"); pInfo[playerid][2][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star13_3\"); pInfo[playerid][3][iNV_Star13] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_1\"); pInfo[playerid][1][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_2\"); pInfo[playerid][2][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star14_3\"); pInfo[playerid][3][iNV_Star14] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_1\"); pInfo[playerid][1][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_2\"); pInfo[playerid][2][iNV_Star15] = strval(int);
                mysql_fetch_field_row(int, \"INV_Star15_3\"); pInfo[playerid][3][iNV_Star15] = strval(int);
                
            }
            
          IsLoggedIn[playerid] = true;
          
          INFO(playerid, \"Sikeres bejelentkezés!\");
          IsLoggedIn[playerid] = true;
          format(str,sizeof(str),\"Karaktereid:\");
          if(pInfo[playerid][1][Created] == 1)
          {
              format(str,sizeof(str),\"%s %s\",str, nstr[1][playerid]);
          }
          if(pInfo[playerid][2][Created] == 1)
          {
              format(str,sizeof(str),\"%s, %s\",str, nstr[2][playerid]);
          }
          if(pInfo[playerid][3][Created] == 1)
          {
              format(str,sizeof(str),\"%s, %s\",str, nstr[3][playerid]);
          }
          INFO(playerid, str);
          CancelSelectTextDraw(playerid);
          TextDrawHideForPlayer(playerid, td_LOG_LEC1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_LEC2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_LEC3[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BOX1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BOX2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BOX3[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG3[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG4[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_MSG5[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BFEL1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BFEL2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BJEL1[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BJEL2[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BLOG[playerid]);
         TextDrawHideForPlayer(playerid, td_LOG_BREG[playerid]);
          SetPlayerColor(playerid, -1);
          TakePlayerToCharChanger(playerid);// ez beviszi a karakterválasztóba(ez úgymond a spawnplayer helyett van itt érted)

 
E: megnéztem, crashdetect nem ír ki semmit
« Utoljára szerkesztve: 2015. március 27. - 19:40:11 írta norbinator09 »
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #5 Dátum: 2015. március 27. - 19:54:00 »
0 Show voters
Hogy nehogy úgy tűnjön hogy nem válaszolok , szóval válaszolok inkább...
1. körben nem tudom mi lehet a baj..... pasz fogalmam sincs...
2. körben senki nem mondta hogy UCP-t kell rá írni... egyszerűen át tekinthetőbb... és egyszerűbb de te érzed.
3. körben mysql R37 / R39 et ajánlanám... NEM R7 est ....
Naplózva

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #6 Dátum: 2015. március 27. - 19:56:49 »
0 Show voters
rendben, kössz a jó tanácsokat, amúgy ez R5-ös xD nemtom mibaj van az R5-el amúgy, de kipróbálom az R39-t(a témát azért hagyom még egy ideig, hátha valaki tud valamit)
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #7 Dátum: 2015. március 27. - 20:40:59 »
0 Show voters
R5 - R7 lényegében ugyan az a hibája [ Elavult.]
Naplózva

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #8 Dátum: 2015. március 27. - 20:58:58 »
0 Show voters
ja értem, de most próbálom az R39(-3 asszem) és egy csmó faszgáot kiírt mysql_store_result-ra meg...(valószínűleg ezek ki lettek cserélve) most nézelődök hogy lehetne ezeket javítani
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #9 Dátum: 2015. március 27. - 21:42:44 »
0 Show voters
Igen. Többek közt ez is!
Én picit másabb helyzetben voltam mivel én mysql 3.1.1 ről mentem át mysql R37 re [Ez 2 külön kiadó mysqlja és hidd el nagyon megérte :D kuvva nehéz volt de megérte :D]
 
[21:42:15] [DEBUG] CMySQLQuery::Execute[LoadPorno] - query was successfully executed within 227.113 milliseconds

 
ez tetszik benne majdnem a legjobban :$ hogy ki írja hogy mennyi idő alatt töltötte be XDDD
meg sokkal átláthatóbb tehát ha 1x megszokod onnastól kezdve gyerek játék... és mindent tehát MINDENT megtudsz írni... [Hidd el elég sok gyökérséget megírtam azzal pluginnal x\"DDD 26767 soros az én módom ami mysql R39-3 as]
« Utoljára szerkesztve: 2015. március 27. - 21:45:08 írta Kyosuke_Hiroshi »
Naplózva

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #10 Dátum: 2015. március 27. - 22:29:08 »
0 Show voters
nah sikerült megtalálni hogy mit mire kel és hogy lecserélni, legyen türelmem átírni és akkor megnézem miújság vele(mert eddig jó)
 
[21:42:15] [DEBUG] CMySQLQuery::Execute[LoadPorno] - query was successfully executed within 227.113 milliseconds[/quote]
ezt hogyan lehet kiiratni konzolba?
 am khm...
[LoadPorno][/quote]  xD
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #11 Dátum: 2015. március 27. - 23:04:31 »
0 Show voters
consolba sehogy nem fogod tudni a mysql_log.txt
 
mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG, LOG_TYPE_TEXT);
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #12 Dátum: 2015. március 27. - 23:33:20 »
0 Show voters
Idézetet írta: norbinator09 date=1427491748\" data-ipsquote-contentapp=\"forums\" data-ipsquote-contenttype=\"forums\" data-ipsquote-contentid=\"53468\" data-ipsquote-contentclass=\"forums_Topic
am khm...
[LoadPorno]
  xD
[/quote]
Mondtam hogy gyökerséget megcsinálok HCRPs szerón dolgozok xd
Naplózva

Nem elérhető norbinator09

  • 218
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #13 Dátum: 2015. március 30. - 21:56:32 »
0 Show voters
hát beraktam mindent, az 1 dolog hogy nem fagy ki  aszerver viszont nem tölt be lószart se...
 

            format(query,sizeof(query), \"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
            mysql_query(MySQL, query,);
            
            new rows, fields;
            cache_get_data(rows, fields);
            
            pInfo[playerid][1][Created] = cache_get_field_content_int(rows, \"Created1\");
            pInfo[playerid][2][Created] = cache_get_field_content_int(rows, \"Created2\");
            pInfo[playerid][3][Created] = cache_get_field_content_int(rows, \"Created3\");
            cache_get_field_content(rows, \"CharName1\", nstr[1][playerid]);
            cache_get_field_content(rows, \"CharName2\", nstr[2][playerid]);
            cache_get_field_content(rows, \"CharName3\", nstr[3][playerid]);
            pInfo[playerid][1][skin] = cache_get_field_content_int(rows, \"Skin1\");
            pInfo[playerid][2][skin] = cache_get_field_content_int(rows, \"Skin2\");
            pInfo[playerid][3][skin] = cache_get_field_content_int(rows, \"Skin3\");
           

 
először betöltetem vele a karakterek 3 fő információját aztán amelyikre klikkel azt töltöm be:
 

   new now = hasznal[playerid];
    
    INFO(playerid, \"Karakter betöltése...\");
    new query[512];
    format(query, sizeof(query),\"SELECT * FROM `karakterek` WHERE `UserName` = \'%s\'\",UserName[playerid]);
    mysql_query(MySQL, query, true);
    
new rows, fields, int[256];
cache_get_data(rows, fields);
switch(now)
{
    case 1:
    {
        pInfo[playerid][1][Age] = cache_get_field_content_int(rows, \"Age1\");
        pInfo[playerid][1][Hatizsak] = cache_get_field_content_int(rows, \"Hati1\");
        pInfo[playerid][1][sex] = cache_get_field_content_int(rows, \"Sex1\");
        cache_get_field_content(rows, \"pX1\", int), pInfo[playerid][1][pX] = floatstr(int);
        cache_get_field_content(rows, \"pY1\", int), pInfo[playerid][1][pY] = floatstr(int);
        cache_get_field_content(rows, \"pZ1\", int), pInfo[playerid][1][pZ] = floatstr(int);
        pInfo[playerid][1][Money] = cache_get_field_content_int(rows, \"Money1\");
        pInfo[playerid][1][Admin] = cache_get_field_content_int(rows, \"Admin1\");
        pInfo[playerid][1][Ora] = cache_get_field_content_int(rows, \"Ora1\");
        pInfo[playerid][1][Perc] = cache_get_field_content_int(rows, \"Perc1\");
        pInfo[playerid][1][Frakcio] = cache_get_field_content_int(rows, \"Frakcio1\");
        pInfo[playerid][1][Munka] = cache_get_field_content_int(rows, \"Munka1\");
        pInfo[playerid][1][Leader] = cache_get_field_content_int(rows, \"Leader1\");
        pInfo[playerid][1][FFizu] = cache_get_field_content_int(rows, \"FFizu1\");
        pInfo[playerid][1][MFizu] = cache_get_field_content_int(rows, \"MFizu1\");
        pInfo[playerid][1][Felfiz] = cache_get_field_content_int(rows, \"Felfiz1\");
        
        pInfo[playerid][now][iNV_Slot1] = cache_get_field_content_int(rows, \"INV_Slot1_1\");
        pInfo[playerid][now][iNV_Slot2] = cache_get_field_content_int(rows, \"INV_Slot2_1\");
        pInfo[playerid][now][iNV_Slot3] = cache_get_field_content_int(rows, \"INV_Slot3_1\");
        pInfo[playerid][now][iNV_Slot4] = cache_get_field_content_int(rows, \"INV_Slot4_1\");
        pInfo[playerid][now][iNV_Slot5] = cache_get_field_content_int(rows, \"INV_Slot5_1\");
        pInfo[playerid][now][iNV_Slot6] = cache_get_field_content_int(rows, \"INV_Slot6_1\");
        pInfo[playerid][now][iNV_Slot7] = cache_get_field_content_int(rows, \"INV_Slot7_1\");
        pInfo[playerid][now][iNV_Slot8] = cache_get_field_content_int(rows, \"INV_Slot8_1\");
        pInfo[playerid][now][iNV_Slot9] = cache_get_field_content_int(rows, \"INV_Slot9_1\");
        pInfo[playerid][now][iNV_Slot10] = cache_get_field_content_int(rows, \"INV_Slot10_1\");
        pInfo[playerid][now][iNV_Slot11] = cache_get_field_content_int(rows, \"INV_Slot11_1\");
        pInfo[playerid][now][iNV_Slot12] = cache_get_field_content_int(rows, \"INV_Slot12_1\");
        pInfo[playerid][now][iNV_Slot13] = cache_get_field_content_int(rows, \"INV_Slot13_1\");
        pInfo[playerid][now][iNV_Slot14] = cache_get_field_content_int(rows, \"INV_Slot14_1\");
        pInfo[playerid][now][iNV_Slot15] = cache_get_field_content_int(rows, \"INV_Slot15_1\");
        pInfo[playerid][now][iNV_Star1] = cache_get_field_content_int(rows, \"INV_Star1_1\");
        pInfo[playerid][now][iNV_Star2] = cache_get_field_content_int(rows, \"INV_Star2_1\");
        pInfo[playerid][now][iNV_Star3] = cache_get_field_content_int(rows, \"INV_Star3_1\");
        pInfo[playerid][now][iNV_Star4] = cache_get_field_content_int(rows, \"INV_Star4_1\");
        pInfo[playerid][now][iNV_Star5] = cache_get_field_content_int(rows, \"INV_Star5_1\");
        pInfo[playerid][now][iNV_Star6] = cache_get_field_content_int(rows, \"INV_Star6_1\");
        pInfo[playerid][now][iNV_Star7] = cache_get_field_content_int(rows, \"INV_Star7_1\");
        pInfo[playerid][now][iNV_Star8] = cache_get_field_content_int(rows, \"INV_Star8_1\");
        pInfo[playerid][now][iNV_Star9] = cache_get_field_content_int(rows, \"INV_Star9_1\");
        pInfo[playerid][now][iNV_Star10] = cache_get_field_content_int(rows, \"INV_Star10_1\");
        pInfo[playerid][now][iNV_Star11] = cache_get_field_content_int(rows, \"INV_Star11_1\");
        pInfo[playerid][now][iNV_Star12] = cache_get_field_content_int(rows, \"INV_Star12_1\");
        pInfo[playerid][now][iNV_Star13] = cache_get_field_content_int(rows, \"INV_Star13_1\");
        pInfo[playerid][now][iNV_Star14] = cache_get_field_content_int(rows, \"INV_Star14_1\");
        pInfo[playerid][now][iNV_Star15] = cache_get_field_content_int(rows, \"INV_Star15_1\");
    }
case 2:
{
    pInfo[playerid][2][Age] = cache_get_field_content_int(rows, \"Age2\");
    pInfo[playerid][2][Hatizsak] = cache_get_field_content_int(rows, \"Hati2\");
    pInfo[playerid][2][sex] = cache_get_field_content_int(rows, \"Sex2\");
    cache_get_field_content(rows, \"pX2\", int), pInfo[playerid][2][pX] = floatstr(int);
        cache_get_field_content(rows, \"pY2\", int), pInfo[playerid][2][pY] = floatstr(int);
        cache_get_field_content(rows, \"pZ2\", int), pInfo[playerid][2][pZ] = floatstr(int);
    pInfo[playerid][2][Money] = cache_get_field_content_int(rows, \"Money2\");
    pInfo[playerid][2][Admin] = cache_get_field_content_int(rows, \"Admin2\");
    pInfo[playerid][2][Ora] = cache_get_field_content_int(rows, \"Ora2\");
    pInfo[playerid][2][Perc] = cache_get_field_content_int(rows, \"Perc2\");
    pInfo[playerid][2][Frakcio] = cache_get_field_content_int(rows, \"Frakcio2\");
    pInfo[playerid][2][Munka] = cache_get_field_content_int(rows, \"Munka2\");
            pInfo[playerid][2][Leader] = cache_get_field_content_int(rows, \"Leader2\");
            pInfo[playerid][2][FFizu] = cache_get_field_content_int(rows, \"FFizu2\");
            pInfo[playerid][2][MFizu] = cache_get_field_content_int(rows, \"MFizu2\");
            pInfo[playerid][2][Felfiz] = cache_get_field_content_int(rows, \"Felfiz2\");
            
            pInfo[playerid][now][iNV_Slot1] = cache_get_field_content_int(rows, \"INV_Slot1_2\");
        pInfo[playerid][now][iNV_Slot2] = cache_get_field_content_int(rows, \"INV_Slot2_2\");
        pInfo[playerid][now][iNV_Slot3] = cache_get_field_content_int(rows, \"INV_Slot3_2\");
        pInfo[playerid][now][iNV_Slot4] = cache_get_field_content_int(rows, \"INV_Slot4_2\");
        pInfo[playerid][now][iNV_Slot5] = cache_get_field_content_int(rows, \"INV_Slot5_2\");
        pInfo[playerid][now][iNV_Slot6] = cache_get_field_content_int(rows, \"INV_Slot6_2\");
        pInfo[playerid][now][iNV_Slot7] = cache_get_field_content_int(rows, \"INV_Slot7_2\");
        pInfo[playerid][now][iNV_Slot8] = cache_get_field_content_int(rows, \"INV_Slot8_2\");
        pInfo[playerid][now][iNV_Slot9] = cache_get_field_content_int(rows, \"INV_Slot9_2\");
        pInfo[playerid][now][iNV_Slot10] = cache_get_field_content_int(rows, \"INV_Slot10_2\");
        pInfo[playerid][now][iNV_Slot11] = cache_get_field_content_int(rows, \"INV_Slot11_2\");
        pInfo[playerid][now][iNV_Slot12] = cache_get_field_content_int(rows, \"INV_Slot12_2\");
        pInfo[playerid][now][iNV_Slot13] = cache_get_field_content_int(rows, \"INV_Slot13_2\");
        pInfo[playerid][now][iNV_Slot14] = cache_get_field_content_int(rows, \"INV_Slot14_2\");
        pInfo[playerid][now][iNV_Slot15] = cache_get_field_content_int(rows, \"INV_Slot15_2\");
        pInfo[playerid][now][iNV_Star1] = cache_get_field_content_int(rows, \"INV_Star1_2\");
        pInfo[playerid][now][iNV_Star2] = cache_get_field_content_int(rows, \"INV_Star2_2\");
        pInfo[playerid][now][iNV_Star3] = cache_get_field_content_int(rows, \"INV_Star3_2\");
        pInfo[playerid][now][iNV_Star4] = cache_get_field_content_int(rows, \"INV_Star4_2\");
        pInfo[playerid][now][iNV_Star5] = cache_get_field_content_int(rows, \"INV_Star5_2\");
        pInfo[playerid][now][iNV_Star6] = cache_get_field_content_int(rows, \"INV_Star6_2\");
        pInfo[playerid][now][iNV_Star7] = cache_get_field_content_int(rows, \"INV_Star7_2\");
        pInfo[playerid][now][iNV_Star8] = cache_get_field_content_int(rows, \"INV_Star8_2\");
        pInfo[playerid][now][iNV_Star9] = cache_get_field_content_int(rows, \"INV_Star9_2\");
        pInfo[playerid][now][iNV_Star10] = cache_get_field_content_int(rows, \"INV_Star10_2\");
        pInfo[playerid][now][iNV_Star11] = cache_get_field_content_int(rows, \"INV_Star11_2\");
        pInfo[playerid][now][iNV_Star12] = cache_get_field_content_int(rows, \"INV_Star12_2\");
        pInfo[playerid][now][iNV_Star13] = cache_get_field_content_int(rows, \"INV_Star13_2\");
        pInfo[playerid][now][iNV_Star14] = cache_get_field_content_int(rows, \"INV_Star14_2\");
        pInfo[playerid][now][iNV_Star15] = cache_get_field_content_int(rows, \"INV_Star15_2\");
}
case 3:
{
    pInfo[playerid][3][Age] = cache_get_field_content_int(rows, \"Age3\");
    pInfo[playerid][3][Hatizsak] = cache_get_field_content_int(rows, \"Hati3\");
    pInfo[playerid][3][sex] = cache_get_field_content_int(rows, \"Sex3\");
    cache_get_field_content(rows, \"pX3\", int), pInfo[playerid][3][pX] = floatstr(int);
        cache_get_field_content(rows, \"pY3\", int), pInfo[playerid][3][pY] = floatstr(int);
        cache_get_field_content(rows, \"pZ3\", int), pInfo[playerid][3][pZ] = floatstr(int);
    pInfo[playerid][3][Money] = cache_get_field_content_int(rows, \"Money3\");
    pInfo[playerid][3][Admin] = cache_get_field_content_int(rows, \"Admin3\");
    pInfo[playerid][3][Ora] = cache_get_field_content_int(rows, \"Ora3\");
    pInfo[playerid][3][Perc] = cache_get_field_content_int(rows, \"Perc3\");
    pInfo[playerid][3][Frakcio] = cache_get_field_content_int(rows, \"Frakcio3\");
    pInfo[playerid][3][Munka] = cache_get_field_content_int(rows, \"Munka3\");
    pInfo[playerid][3][Leader] = cache_get_field_content_int(rows, \"Leader3\");
    pInfo[playerid][3][FFizu] = cache_get_field_content_int(rows, \"FFizu3\");
    pInfo[playerid][3][MFizu] = cache_get_field_content_int(rows, \"MFizu3\");
    pInfo[playerid][3][Felfiz] = cache_get_field_content_int(rows, \"Felfiz3\");
    
    pInfo[playerid][now][iNV_Slot1] = cache_get_field_content_int(rows, \"INV_Slot1_3\");
        pInfo[playerid][now][iNV_Slot2] = cache_get_field_content_int(rows, \"INV_Slot2_3\");
        pInfo[playerid][now][iNV_Slot3] = cache_get_field_content_int(rows, \"INV_Slot3_3\");
        pInfo[playerid][now][iNV_Slot4] = cache_get_field_content_int(rows, \"INV_Slot4_3\");
        pInfo[playerid][now][iNV_Slot5] = cache_get_field_content_int(rows, \"INV_Slot5_3\");
        pInfo[playerid][now][iNV_Slot6] = cache_get_field_content_int(rows, \"INV_Slot6_3\");
        pInfo[playerid][now][iNV_Slot7] = cache_get_field_content_int(rows, \"INV_Slot7_3\");
        pInfo[playerid][now][iNV_Slot8] = cache_get_field_content_int(rows, \"INV_Slot8_3\");
        pInfo[playerid][now][iNV_Slot9] = cache_get_field_content_int(rows, \"INV_Slot9_3\");
        pInfo[playerid][now][iNV_Slot10] = cache_get_field_content_int(rows, \"INV_Slot10_3\");
        pInfo[playerid][now][iNV_Slot11] = cache_get_field_content_int(rows, \"INV_Slot11_3\");
        pInfo[playerid][now][iNV_Slot12] = cache_get_field_content_int(rows, \"INV_Slot12_3\");
        pInfo[playerid][now][iNV_Slot13] = cache_get_field_content_int(rows, \"INV_Slot13_3\");
        pInfo[playerid][now][iNV_Slot14] = cache_get_field_content_int(rows, \"INV_Slot14_3\");
        pInfo[playerid][now][iNV_Slot15] = cache_get_field_content_int(rows, \"INV_Slot15_\");
        pInfo[playerid][now][iNV_Star1] = cache_get_field_content_int(rows, \"INV_Star1_3\");
        pInfo[playerid][now][iNV_Star2] = cache_get_field_content_int(rows, \"INV_Star2_3\");
        pInfo[playerid][now][iNV_Star3] = cache_get_field_content_int(rows, \"INV_Star3_3\");
        pInfo[playerid][now][iNV_Star4] = cache_get_field_content_int(rows, \"INV_Star4_3\");
        pInfo[playerid][now][iNV_Star5] = cache_get_field_content_int(rows, \"INV_Star5_3\");
        pInfo[playerid][now][iNV_Star6] = cache_get_field_content_int(rows, \"INV_Star6_3\");
        pInfo[playerid][now][iNV_Star7] = cache_get_field_content_int(rows, \"INV_Star7_3\");
        pInfo[playerid][now][iNV_Star8] = cache_get_field_content_int(rows, \"INV_Star8_3\");
        pInfo[playerid][now][iNV_Star9] = cache_get_field_content_int(rows, \"INV_Star9_3\");
        pInfo[playerid][now][iNV_Star10] = cache_get_field_content_int(rows, \"INV_Star10_3\");
        pInfo[playerid][now][iNV_Star11] = cache_get_field_content_int(rows, \"INV_Star11_3\");
        pInfo[playerid][now][iNV_Star12] = cache_get_field_content_int(rows, \"INV_Star12_3\");
        pInfo[playerid][now][iNV_Star13] = cache_get_field_content_int(rows, \"INV_Star13_3\");
        pInfo[playerid][now][iNV_Star14] = cache_get_field_content_int(rows, \"INV_Star14_3\");
        pInfo[playerid][now][iNV_Star15] = cache_get_field_content_int(rows, \"INV_Star15_3\");
}
}

 
alap belépéskor sem tölti be a dolgotkat a szerver így esélyem sincs arra hogy a  karakter betöltésést leteszteljem :( (jah tudom kicsit retardáltan néz ki a 3 karakter miatt xD)
nemtod mit csesztem el? esetleg valamit kifelejtettem belőle?
Naplózva

Nem elérhető Kyosuke_Hiroshi

  • 507
    • Profil megtekintése
MySQL betöltés probléma
« Válasz #14 Dátum: 2015. március 30. - 22:46:26 »
0 Show voters
Én nem így csinálgattam.
Én ezt használtam : http://wiki.sa-mp.com/wiki/MySQL/R33#mysql_tquery
A lényeg hogy kell mindenre egy külön public..
http://sampforum.hu/index.php?topic=57995.msg534822#msg534822 Nézd meg itt segítettem egy tagnak aki r39-3 ast használt és ez jó így próbálkozz
Naplózva
Oldalak: [1] 2   Fel
« előző következő »
 
SimplePortal 2.3.7 © 2008-2024, SimplePortal