Advertisement
Guest User

Untitled

a guest
May 7th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // zapsani do DB
  2.     if <f_sql_spojeni> //spojeno s db
  3.     DB.QUERY "SELECT nazev FROM guildy WHERE nazev='<ARGTXT[1]>'"
  4.         if <db.row.nazev>!=<ARGTXT[1]>
  5.     // zalozim guildu a dam do db
  6.         local.guilda_id_db = <db.row.id> + 1
  7.         local.guilda_jmeno = <ARGTXT[1]>
  8.         local.guilda_zkratka = <ARGTXT[2]>
  9.         local.guilda_gm    = <src.uid>
  10.         local.guilda_zalozeno = <SERV.RTIME.FORMAT %Y-%m-%d %H:%M:%S>
  11.         DB.EXECUTE "INSERT INTO guildy ( id, nazev, zamereni, guildstone, historie, www, email, guildmaster, zalozena, zaznam, heslo, zapsal, zkratka ) VALUES ( '<eval <local.guilda_id_db>>', '<local.guilda_jmeno>', NULL, NULL, NULL, NULL, NULL, '<local.guilda_gm>', '<local.guilda_zalozeno>', NULL, NULL, NULL, '<local.guilda_zkratka>');"
  12.         else
  13.     return 1
  14.     src.sysmessage Jmeno guildy jiz existuje!
  15.         endif
  16.     DB.CLOSE
  17.     endif
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement