IF NOT EXIST abfrage mit MySQL

[milos]

Ich möchte das dieser code ausgeführt wird:

SQL-Code:

INSERT INTO ´username´ = $botname `users` (`id`, 

`username`, `password`, `banned`, `villages`, `points`, `ennobled_by`, `ally`, 

`ally_titel`, `ally_found`, `ally_lead`, `ally_invite`, `ally_diplomacy`, 

`ally_mass_mail`, `rang`, `villages_mode`, `attacks`, `new_report`, `new_mail`, 

`market_sell`, `market_buy`, `market_ratio_max`, `killed_units_att`, 

`killed_units_att_rank`, `killed_units_def`, `killed_units_def_rank`, 

`killed_units_altogether`, `killed_units_altogether_rank`, `do_action`, 

`last_activity`, `birthday`, `vacation_id`, `vacation_name`, `vacation_accept`, 

`b_day`, `b_month`, `b_year`, `sex`, `home`, `image`, `personal_text`, `window_width`, 

`show_toolbar`, `dyn_menu`, `confirm_queue`, `map_size`, `memo`, `map_reload`, 

`graphical_overwiev`, `overview`, `stufen`, `winter`) VALUES (NULL, '$botname', 

'e10adc3949ba59abbe56e057f20f883e', 'N', '', '', '', '-1', '', '0', '0', '0', '0', 

'0', '', 'prod', '0', '0', '0', 'all', 'all', '3', '', '', '', '', '', '', '', '', '', 

'-1', '', '0', '', '', '', 'x', '', '', '', '840', '1', '1', '1', '9', '', '', '1', 

'new', 'yes', '');'1', '1', '1', '9', '', '', '1', 'new', 'yes', '');

Falls $botname nicht existiert. $Botname ist die variable in der config wo man auswählen muss welchen spieler er steuert