Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CMD:addmoderation(playerid, params[])
- {
- if(PTEMP[playerid][pLogin] == 0) return true;
- if(PTEMP[playerid][pAdmin] < 7 || dostup[playerid] == 0) return true;
- new name[32], params, nickname_adm[32];
- if(sscanf(params, "s[32]is[32]", name, params, nickname_adm)) return SendClientMessage(playerid, COLOR_WHITE, "Введите: /addmoderation [NickName] [Admin Level] [Admin-Name]");
- if((params[1] > 6 || params[1] < 0) && PTEMP[playerid][pAdmin] < 10) return SendClientMessage(playerid, COLOR_GREY, "Au aiionoeee ieoaeo");
- if(strlen(nickname_adm) == 0 || strlen(nickname_adm) > 30) return SendClientMessage(playerid, COLOR_GREY, "Длина админ ника до 30 символов");
- mysql_format(DATABASE,QUERY, 128, "SELECT * FROM "TABLE_ADMIN" WHERE `name` = '%s'", name);
- mysql_function_query(DATABASE,QUERY,true,"GiveAdmPlayerMySQL","iss", params, name, nickname_adm);
- return true;
- }
- publics:GiveAdmPlayerMySQL(lvl, name, nickname)
- {
- new r, f, x;
- cache_get_data(r, f);
- if(r)
- {
- if(lvl == 0)
- {
- mysql_format(DATABASE,QUERY, 128, "DELETE FROM "TABLE_ADMIN" WHERE `Name`= '%s'", name);
- mysql_function_query(DATABASE,QUERY,false,"","");
- if(IsPlayerConnected(GetPlayerID(str))) PTEMP[GetPlayerID(str)][pAdmin] = 0;
- }
- else
- {
- mysql_format(DATABASE,QUERY,256, "UPDATE "TABLE_ADMIN" SET level = '%i' WHERE Name = '%s' LIMIT 1",lvl,name);
- mysql_function_query(DATABASE,QUERY,false,"","");
- }
- }
- else
- {
- new year, month,day;
- getdate(year, month, day);
- mysql_format(DATABASE,QUERY, 512, "\
- INSERT INTO "TABLE_ADMIN" (Name, level, LastCon, AdmName) VALUES ('%s', %i, '%02i.%02i.%04i', '%s')",
- name, lvl, day, month, year, nickname);
- mysql_function_query(DATABASE,QUERY,false,"","");
- }
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement