Stark.sys

fa un update la mysql.dll si a_mysql.inc .

Ce am eu pt connect static sql, Name[MAX_PLAYERS][32], IP[MAX_PLAYERS][16]; /* MySQL Host */ MySQLHost(); mysql_log(LOG_DEBUG | LOG_ERROR | LOG_WARNING,LOG_TYPE_HTML); /* MySQL Host */ stock MySQLHost() { sql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS); if(mysql_errno(sql) != 0) { printf("MySQL Database"); printf("---------------"); printf(" MySQL Database has not respond.n"); } else { printf("MySQL Database"); printf("---------------"); printf(" MySQL Database has been respond.n"); } return 1; }

la mine sql = mysql_connect(sql,host {etc...});

mysql_tquery(sql, query, "OnGetVehicle", "i", id); adica asa ?

Try again #define D_Login 1 #define D_Register 2 static Name[MAX_PLAYERS][32]; new rows, fields; public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { switch(dialogid) { case D_Login: { if(response) { new query[124]; if(!strcmp(inputtext, P_DATA[playerid][Pass], true)) { mysql_format(sql, query, sizeof(query), "SELECT * FROM `Users` WHERE `Name`='%e'", Name[playerid]); mysql_tquery(sql, query, "OnAccountLoad", "i", playerid); SpawnPlayer(playerid); SendClientMessage(playerid, -1, "Welcome back. You have been logged."); } else { new str[256]; format(str, sizeof(str), "{D12900}Wrong password, enter the password again more carefully !"); ShowPlayerDialog(playerid, D_Login, DIALOG_STYLE_PASSWORD, "SERVER: Login", str, "Login", "Quit"); } }else return Kick(playerid); } case D_Register: { if(response) { new query[500]; if(strlen(inputtext) < 6) return ShowPlayerDialog(playerid, D_Register, DIALOG_STYLE_PASSWORD, "SERVER: Register", "You have insert a short password, plase enter a long password.", "Register", "Quit"); strcat(query, "INSERT INTO `Users`(Name,Password,Kills,Deaths,Money) VALUES('%e','%s','0','0','0')"); mysql_format(sql, query, sizeof(query), query, Name[playerid], inputtext); mysql_tquery(sql, query, "OnAccountRegister", "i", playerid); SpawnPlayer(playerid); } else return Kick(playerid); } } return 1; } public OnAccountRegister() { P_DATA[playerid][gID] = cache_insert_id(); return 1; } public OnAccountLoad() { P_DATA[playerid][ID] = cache_get_field_content_int(0, "ID"); P_DATA[playerid][pKills] = cache_get_field_content_int(0, "Kills"); P_DATA[playerid][pDeaths] = cache_get_field_content_int(0, "Deaths"); P_DATA[playerid][pMoney] = cache_get_field_content_int(0, "Money"); return 1; } public OnAccountCheck(playerid) { cache_get_data(rows, fields, 1); if(rows) { new str[256]; cache_get_field_content(0, "Password", P_DATA[playerid][Pass], 1, 129); P_DATA[playerid][ID] = cache_get_field_content_int(0, "ID"); format(str, 256, "Welcome back %snPlease enter your password to balow to login", Name[playerid]); ShowPlayerDialog(playerid, D_Login, DIALOG_STYLE_PASSWORD, "WOG: Login", str, "Login", "Quit"); } else return ShowPlayerDialog(playerid, D_Register, DIALOG_STYLE_PASSWORD, "WOG: Register", "Welcome.nIn order to play, you need to register.", "Register", "Quit"); return 1; } Iar la OnPlayerConnect: mysql_format(sql, query, sizeof(query),"SELECT `Password`, `ID` FROM `Users` WHERE `Name`='%e' LIMIT 1", Name[playerid]); mysql_tquery(sql, query, "OnAccountCheck", "i", playerid);

change line : if(dialogid == 1) { if(response == 1) { Limba[playerid] = 0; } else if(response == 0) { Limba[playerid] = 1; } } with #define limba_sw 1000 // place after #include <your functions> if(dialogid == limba_sw) { if(response) { Limba[playerid] = 0; } else { Limba[playerid] = 0; } }

Problema e ca nu da erori :| Codurile: #define MAX_CARS 100 enum cInfo { cID, cOwner, cModel, cPrice, Float:cPosx, Float:cPosy, Float:cPosz, Float:cPosa, cPaint, c3DText, cCol1, cCol2, cTPart, cRTime, cKM } new VehicleInfo[MAX_CARS][cInfo]; Forward: forward OnLoadVehicle(); forward OnGetVehicle(vehid); forward OnLoadCVehicle(vehid); stock LoadVehicles() { new query[255], id; mysql_format(1, query, sizeof(query), "SELECT `ID`, `Owner`, `Model`, `Price`, `PosX`, `PosY`, `PosZ`, `PosA`, `3DText`, `Color1`, `Color2`, `PaintJob`, `RespawnTime`, `KM`, `TPart` FROM `vehicles` WHERE `ID`='%d' LIMIT 1", id); mysql_tquery(1, query, "OnGetVehicle", "i", id); } OnGameModeInit: LoadVehicles(); Public Functions: public OnGetVehicle(vehid) { cache_get_data(rows, fields, sql); if(rows) { LoadedInfo[vehid] = MAX_CARS; CreateVehicle(VehicleInfo[vehid][cModel], VehicleInfo[vehid][cPosx], VehicleInfo[vehid][cPosy], VehicleInfo[vehid][cPosz], VehicleInfo[vehid][cPosa], VehicleInfo[vehid][cCol1], VehicleInfo[vehid][cCol2], VehicleInfo[vehid][cRTime]); printf("Import of databse %d vehicle", LoadedInfo[vehid]); } return 1; } public OnLoadCVehicle(vehid) { VehicleInfo[vehid][cID] = cache_get_field_content_int(0, "ID", sql); VehicleInfo[vehid][cOwner] = cache_get_field_content_int(0, "Owner", sql); VehicleInfo[vehid][cModel] = cache_get_field_content_int(0, "Model", sql); VehicleInfo[vehid][cPrice] = cache_get_field_content_int(0, "Price", sql); VehicleInfo[vehid][cPosx] = cache_get_field_content_float(0, "PosX", sql); VehicleInfo[vehid][cPosy] = cache_get_field_content_float(0, "PosY", sql); VehicleInfo[vehid][cPosz] = cache_get_field_content_float(0, "PosZ", sql); VehicleInfo[vehid][cPosa] = cache_get_field_content_float(0, "PosA", sql); VehicleInfo[vehid][c3DText]= cache_get_field_content_int(0, "3DText", sql); VehicleInfo[vehid][cCol1] = cache_get_field_content_int(0, "Color1", sql); VehicleInfo[vehid][cCol2] = cache_get_field_content_int(0, "Color2", sql); VehicleInfo[vehid][cPaint] = cache_get_field_content_int(0, "PaintJob", sql); VehicleInfo[vehid][cRTime] = cache_get_field_content_int(0, "RespawnTime", sql); VehicleInfo[vehid][cKM] = cache_get_field_content_int(0, "KM", sql); VehicleInfo[vehid][cTPart] = cache_get_field_content_int(0, "TPart", sql); return 1; }

Problemă întâlnită (descriere): Vreau sa stiu cum pot face un import la masini ? Ero(area / rile) / warning-(ul / urile): Nici una Liniile de cod / sursa / script-ul: N/A Imagini / Video (optional): N/A Aţi încercat să rezolvaţi singur?: Da, dar nu inteleg dece nu da import.

Ok, multumesc Gireada !

@WopsS stiu ce este mysql_format dar eu am nevoie sa stiu cum pot face mai multe variabile ntr-o singura query .. deci daca in tabelul `users` am 45 coloane cand le introduc la insert intro imi da eroare pawn ca e prea lung. intelegi ?

Problemă întâlnită (descriere): Vreau sa stiu cum pot face sa inserez mai multe valori in mysql_format Ero(area / rile) / warning-(ul / urile): Prea lunga valuare introdusa. Liniile de cod / sursa / script-ul: mysql_format(sql, query, sizeof(query), "INSERT INTO valuare.", content{}); Imagini / Video (optional): - Aţi încercat să rezolvaţi singur?: Da, dar nu le am asa bine cu mysql.

if(strcmp("/admins", cmdtext, true, 10) == 0) { new adm = PlayerInfo[playerid][pAdmin]; new str[128], msg[128]; new admName[MAX_PLAYER_NAME]; GetPlayerName(playerid, admName, 32); switch(adm || PlayerInfo[playerid][pAdmin]) { case 0: format(str, sizeof(str), "Level 0"); case 1: format(str, sizeof(str), "Level 1"); case 2: format(str, sizeof(str), "Level 2"); case 3: format(str, sizeof(str), "Level 3"); case 4: format(str, sizeof(str), "Level 4"); case 5: format(str, sizeof(str), "Level 5"); case 6: format(str, sizeof(str), "Level 6"); case 7: format(str, sizeof(str), "Level 7"); case 8: format(str, sizeof(str), "Level 8"); } for(new i = 0; i < MAX_PLAYERS; i++) { if(IsPlayerConnected(i)) { SendClientMessage(i, -1, "{9CC56C}|____________ {FFFFFF}Administration Online Admin {9CC56C}____________|"); if(adm >= 1 || PlayerInfo[playerid][pAdmin] >= 1) { format(msg, sizeof(msg), "%s - %s", str, admName); SendClientMessage(i, -1, msg); } // For Admin logged with rcon if(IsPlayerAdmin(i)) { format(msg, sizeof(msg), "Rcon Admin - %s", admName); SendClientMessage(i, 0x7FB0D8FF, msg); } // On duty admins if(PlayerInfo[pAdminDuty] == 1) { format(msg, sizeof(msg), "%s - %s (On Duty)", str, admName); SendClientMessage(i, 0xFFE73CFF, msg); } } } return 1; } vezi asa :-? ar trebuie sa functioneze !

Hmm.. nu le am asa bine in ale sriptingului sa:mp dar poti face si asa daca doresti

T/C

if(strcmp("/admins", cmdtext, true, 10) == 0) { new adm = PlayerInfo[playerid][pAdmin]; new str[128], msg[128]; new admName[MAX_PLAYER_NAME]; GetPlayerName(playerid, admName, 32); switch(adm) { case 0: format(str, sizeof(str), "Level 0"); case 1: format(str, sizeof(str), "Level 1"); case 2: format(str, sizeof(str), "Level 2"); case 3: format(str, sizeof(str), "Level 3"); case 4: format(str, sizeof(str), "Level 4"); case 5: format(str, sizeof(str), "Level 5"); case 6: format(str, sizeof(str), "Level 6"); case 7: format(str, sizeof(str), "Level 7"); case 8: format(str, sizeof(str), "Level 8"); } for(new i = 0; i < MAX_PLAYERS; i++) { if(IsPlayerConnected(i)) { SendClientMessage(i, -1, "{9CC56C}|____________ {FFFFFF}Administration Online Admin {9CC56C}____________|"); if(adm > 1 || adm < 1338) { format(msg, sizeof(msg), "%s - %s", str, admName); SendClientMessage(i, -1, msg); } // For Admin logged with rcon if(IsPlayerAdmin(i)) { format(msg, sizeof(msg), "Rcon Admin - %s", admName); SendClientMessage(i, 0x7FB0D8FF, msg); } // On duty admins if(PlayerInfo[pAdminDuty] == 1) { format(msg, sizeof(msg), "%s - %s (On Duty)", str, admName); SendClientMessage(i, 0xFFE73CFF, msg); } } } return 1; } vezi acest cod

Problemă întâlnită (descriere): Eroare scriere query in baza de date. Ero(area / rile) / warning-(ul / urile): (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`='4'' at line 1 Liniile de cod / sursa / script-ul: [pawn]CMD:setgang(playerid, params[]) { if(GangData[playerid][gAdmi] >= 1 || IsPlayerAdmin(playerid)) { new id, gid, rs[32]; if(sscanf(params, "uds[32]", id, gid, rs)) return SendClientMessage(playerid, -1, "Usage: /setgang "); CheckFactionUpdate(id); new tName[MAX_PLAYER_NAME];GetPlayerName(id, tName, 32); new string[260]; GangData[id][gGang] = gid, GangData[id][gLead] = 1, GangData[id][gRank] = 6; Gangs[gid][iMemb] += 1; SendClientMessage(id, -1, "{0097FF}|_____________Promoted_____________|"); mysql_format(sql, string, sizeof(string), "UPDATE `gangs` SET `Leader`='%s',`Member`='%d', WHERE `ID`='%d'", tName, Gangs[gid][iMemb], gid); mysql_tquery(sql, string, "OnGangsCheck", "i", gid); SendClientMessage(id, -1, " {0097FF}Felicitari ai fost promovat. "); new adminact[1500], res[1280], date[48], a,l,z,o,m,s; gettime(o,m,s), getdate(a,l,z); format(res, sizeof(res), "%s a fost promovat ca lider al mafiei %d cu rank %d. Motiv: %s", tName, gid, 1, 6, rs); format(date, sizeof(date), "%d/%d/%d - %d:%d:%d", a,l,z,o,m,s); mysql_format(sql, adminact, sizeof(adminact), "INSERT INTO `admin_action`(`ID`, `Admin-Name`, `IP`, `Action`, `Date`) VALUES (1,'%e','%s','%s','%s');", Name[playerid], IP[playerid], res, date); mysql_tquery(sql, adminact, "", ""); } return 1; }[/pawn] Imagini / Video (optional): http://i39.servimg.com/u/f39/17/39/93/85/snapsh10.png Aţi încercat să rezolvaţi singur?: Da, dar nu stiu dece nu mai merge :|

Poblema ar putea fi de la sursa /setadmin /makeadmin, poate nu face update in profil sau nu se salveaza.

Folosesti zcmd ? Try code CMD:admins(playerid, params[]) { new str[129], pName[MAX_PLAYER_NAME]; GetPlayerName(playerid, pName, 32); SendClientMessage(playerid, -1, "{B4E3DB}-------------------[ Online Admins ]-------------------"); for(new i = 0; i < MAX_PLAYERS; i++) { if(IsPlayerConnected(i)) { if(PlayerInfo[pAdmin] == 1) { format(str, 128, "Trial Admin - %s", pName); } else if(PlayerInfo[pAdmin] == 2) { format(str, 128, "Administrator - %s", pName); } else if(PlayerInfo[pAdmin] == 3) { format(str, 128, "Moderators - %s", pName); } else if(PlayerInfo[pAdmin] == 4) { format(str, 128, "Scripter - %s", pName); } else if(IsPlayerAdmin(i)) { format(str, 128, "RCON Admin - %s", pName); } SendClientMessage(i, -1, str); } else { SendClientMessage(i, -1, "No admins online."); } } SendClientMessage(playerid, -1, "{B4E3DB}-------------------[ Online Admins ]-------------------"); SendClientMessage(playerid, -1, "{B4E3DB}Pentru probleme folositi /report sau /helpme"); return 1; }

@Adrian_Petre nici eu nu stiu dece ), ms de raspuns .

Nu intelegi ca problema provine de la acest .inc ?

Problemă întâlnită (descriere): Am facut un include pentru conectiunea cu baza de date mysql si cand il adaug imi da Run time error 19. Ero(area / rile) / warning-(ul / urile): Run time error 19 Liniile de cod / sursa / script-ul: [pawn]/* * SA-MP MySQL Connect client for pawn * * © Copyright 2014, sRk7 * */ #include // Define host connections. #define s_host "127.0.0.1" // or localhost #define s_user "root" #define s_pass "" // No pass resquest #define s_db "sdb" // Create a options of login and reconect of db // new handle; // new rows, fields; // new temp[256]; // Create public function of pawn stock MySQLConnect() { mysql_connect(s_host, s_user, s_db, s_pass); if(mysql_errno(1) == 0) { printf("MySQL: Connections to database (%s) was established !", s_db); } else { printf("MySQL: Connections to database (%s) failed !", s_db); } return 1; } // How to use native MySQLConnect();[/pawn] Imagini / Video (optional): - Aţi încercat să rezolvaţi singur?: Da, cand il scot imi merge :-?

da, dar cand execut sendadminmessage(color, "str"); zice ca are eroare :-? dece?

if(strcmp(cmd, "/addfnews", true) == 0) { if(IsPlayerConnected(playerid)) { new length = strlen(cmdtext); while ((idx < length) && (cmdtext[idx] <= ' ')) { idx++; } new offset = idx; new result[200]; while ((idx < length) && ((idx - offset) < (sizeof(result) - 1))) { result[idx - offset] = cmdtext[idx]; idx++; } result[idx - offset] = EOS; if(!strlen(result)) { SendClientMessage(playerid, COLOR_LIGHTRED, "Syntax: {FFFFFF}/addfnews [text]"); return 1; } else { new leader = PlayerInfo[playerid][pLeader]; if(leader == 1) { fnews1 = result; } else if(leader == 2) { fnews2 = result; } else if(leader == 3) { fnews3 = result; } else if(leader == 4) { fnews4 = result; } else if(leader == 5) { fnews5 = result; } else if(leader == 6) { fnews6 = result; } else if(leader == 7) { fnews7 = result; } else if(leader == 8) { fnews8 = result; } else if(leader == 9) { fnews9 = result; } else if(leader == 10) { fnews10 = result; } else if(leader == 11) { fnews11 = result; } else if(leader == 12) { fnews12 = result; } else if(leader == 13) { fnews13 = result; } else if(leader == 14) { fnews14 = result; } else if(leader == 15) { fnews15 = result; } else if(leader == 16) { fnews16 = result; } else if(leader == 0) { SCM(playerid, COLOR_RED, "Nu esti liderul unei factiuni !"); } } return 1; } } return 1; } if(strcmp(cmd, "/fnews", true) == 0) { if(IsPlayerConnected(playerid)) { if(PlayerInfo[playerid][pMember] == 1 || PlayerInfo[playerid][pLeader] == 1) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews1); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 2 || PlayerInfo[playerid][pLeader] == 2) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews2); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 3 || PlayerInfo[playerid][pLeader] == 3) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews3); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 4 || PlayerInfo[playerid][pLeader] == 4) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews4); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 5 || PlayerInfo[playerid][pLeader] == 5) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews5); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 6 || PlayerInfo[playerid][pLeader] == 6) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews6); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 7 || PlayerInfo[playerid][pLeader] == 7) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews7); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 8 || PlayerInfo[playerid][pLeader] == 8) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews8); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 9 || PlayerInfo[playerid][pLeader] == 9) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews9); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 10 || PlayerInfo[playerid][pLeader] == 10) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews10); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 11 || PlayerInfo[playerid][pLeader] == 11) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews11); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 12 || PlayerInfo[playerid][pLeader] == 12) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews12); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 13 || PlayerInfo[playerid][pLeader] == 13) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews13); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 14 || PlayerInfo[playerid][pLeader] == 14) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews14); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 15 || PlayerInfo[playerid][pLeader] == 15) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews15); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 16 || PlayerInfo[playerid][pLeader] == 16) { SendClientMessage(playerid, COLOR_WHITE, "_____Faction News_____"); format(string, sizeof(string), "%s", fnews16); SendClientMessage(playerid, COLOR_LIGHTRED, string); } else if(PlayerInfo[playerid][pMember] == 0) { SendClientMessage(playerid, COLOR_RED, "Tu nu esti membru/lider al unei factiuni !"); } } return 1; }

else if(CP[playerid] == 98) // trucker 2 { new vehicleid = GetPlayerVehicleID(playerid); if(IsPlayerInVehicle(playerid, vehicleid)) { AttachTrailerToVehicle(trailerid, vehicleid); CP[playerid] = 82; SetPlayerCheckpoint(playerid, 1087.6589,1235.6068,11.8269, 4.0); } }

Descriere tutorial: Salut, am si eu o mica intrebare. Cum pot crea o noua functie .inc ? Un mic exemplu. Deci am codul asta [pawn]stock SendMessageToAdmin(color, text[]) { for(new i = 0; i { if(IsPlayerAdmin(i) || AccInfo[pAdmin] >= 1) { SendClientMessage(i, color, text); } } return 1; } [/pawn] si as dori sa il fac in format .inc, este posibil ? iar cand dau #include <nume functie> sa pot folosi functia asta SendMessageToAdmin(); "de exemplu".;>