Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- player varijabla, ja nju koristio da ne cackam enum, ti kako os - new PNotes[MAX_PLAYERS];
- sql_AccountCheck:
- cache_get_value_name_int(0, "PNotes", PNotes[playerid]);
- dialog enum:
- D_NOTE,
- D_NOTE_LIST,
- D_NOTE_DELETE,
- D_NOTE_PREVIEW,
- OnDialogResponse:
- else if(dialogid == D_NOTE && response)
- {
- new DB_query_note[128];
- switch(listitem)
- {
- //case 0: SPD(playerid, D_INSERT_TITLE, DSI, "Note - ubacivanje", "Unesite naslov beleske\n\n", "OK", "X");
- case 0:
- {
- mysql_format(SQL, DB_query_note, sizeof DB_query_note, "SELECT Title, Text , ID FROM `notes` WHERE Player = '%s' ORDER BY `ID` DESC LIMIT 20", GetName(playerid));
- mysql_tquery( SQL, DB_query_note, "DialogNotes", "ii", playerid, 1);
- }
- case 1:
- {
- mysql_format(SQL, DB_query_note, sizeof DB_query_note, "SELECT Title, Text , ID FROM `notes` WHERE Player = '%s' ORDER BY `ID` DESC LIMIT 20", GetName(playerid));
- mysql_tquery( SQL, DB_query_note, "DialogNotes", "ii", playerid, 2);
- }
- }
- }
- else if(dialogid == D_NOTE_DELETE)
- {
- new DB_query_note[128];
- mysql_format(SQL, DB_query_note, sizeof DB_query_note, "SELECT Title, Text , ID FROM `notes` WHERE Player = '%s' ORDER BY `ID` DESC LIMIT 20", GetName(playerid));
- mysql_tquery( SQL, DB_query_note, "DeleteNotes", "ii", playerid, listitem-1);
- }
- funkcije:
- forward DeleteNotes(playerid, row);
- public DeleteNotes(playerid, row)
- {
- new str[128];
- mysql_format(SQL, str, sizeof str, "DELETE FROM notes WHERE ID = '%d'", row);
- mysql_tquery(SQL, str);
- PNotes[playerid]--;
- SacuvajIgracaInt(playerid, "PNotes", PNotes[playerid]);
- return 1;
- }
- forward DialogNotes(playerid, type);
- public DialogNotes(playerid, type)
- {
- new tajtl[24], beleska[128], dialog_str[1024];
- for(new id=0;id<cache_num_rows();id++)
- {
- cache_get_value(id, "Title", tajtl, 24);
- cache_get_value(id, "Text", beleska, 128);
- if(type == 1)
- format(dialog_str, sizeof dialog_str, "%s{FFFFFF}ID %d: {FFFF00}%s | {FFFFFF}%s\n",dialog_str, id+1, tajtl, beleska);
- else if(type == 2)
- format(dialog_str, sizeof dialog_str, "%s%s\n", dialog_str, tajtl);
- }
- if(type == 1)
- SPD(playerid, D_NOTE_PREVIEW, DSM, "Beleske", dialog_str, "OK", "");
- else if(type == 2)
- SPD(playerid, D_NOTE_DELETE, DSL, "Beleske", dialog_str, "OK", "");
- return 1;
- }
- stock Add_Note(playerid, title[], text[])
- {
- new note_str[512];
- mysql_format(SQL, note_str, sizeof note_str, "INSERT INTO `notes` (Player, Title, Text) VALUES ('%s', '%s', '%s')", GetName(playerid), title, text);
- mysql_tquery(SQL, note_str);
- return 1;
- }
- komande:
- CMD:notes(playerid, params[])
- {
- SPD(playerid, D_NOTE, DSL, "Note", "Pregledaj\nIzbrisi", "OK", "");
- SendClientMessage(playerid, -1, "- Da ubacite nesto u vasu belesku koristite /addnote.");
- return 1;
- }
- CMD:addnote(playerid, params[])
- {
- if(PNotes[playerid] > MAX_P_NOTES) return SendClientMessage(playerid, -1, "Imate previse belezaka");
- new naslv[20], tekt[128];
- if(sscanf(params, "s[20]s[128]", naslv, tekt)) return SendClientMessage(playerid, -1, "Koristite: /addnote [naslov (SAMO 1 REC)] [text]");
- Add_Note(playerid, naslv, tekt);
- PNotes[playerid]++;
- SacuvajIgracaInt(playerid, "PNotes", PNotes[playerid]);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement