Muda Vocações No Site

[Rayan 2]

Então vou direto ao ponto eu troquei la no config as vocações e as cidades, veja abaixo:

// CHARACTER config, format: ID_of_vocation => 'Name of Character to copy', load vocation name from $vocation_name[0] (below)
$config['site']['newchar_vocations'][0] = array(1 => 'Exemplo1', 2 => 'Exemplo2');
$config['site']['newchar_vocations'][1] = array(1 => 'Exemplo1', 2 => 'Exemplo2');
// sample, if rook only:             $config['site']['newchar_vocations'][0] = array(0 => 'Rook Sample');
$config['site']['newchar_towns'][0] = array(2);
$config['site']['newchar_towns'][1] = array(1,2);
// sample, if all players should spawn in one city (city with ID 4):    uncoment!!
//$config['site']['newchar_towns'] = array(4);

// list of vocations on ots (world 0)
$vocation_name[0][0] = array(0 => 'None', 1 => 'Exemplo1', 2 => 'Exemplo2'); // id => 'name' , $vocation_name[0] - promotion level 0, $vocation_name[0] - for world ID 0
$vocation_name[0][1] = array(1 => 'nao tem', 2 => 'nao tem'); // id => 'name' , $vocation_name[1] - promotion level 1, $vocation_name[0] - for world ID 0
// list of vocations on ots (world 1)
$vocation_name[1][0] = array(0 => 'None', 1 => 'Exemplo1', 2 => 'Exemplo2'); // id =>  'name' , $vocation_name[0] - promotion level 0, $vocation_name[1] - for world ID 1
$vocation_name[1][1] = array(1 => 'nao tem', 2 => 'nao tem'); // id => 'name' , $vocation_name[1] - promotion level 1, $vocation_name[1] - for world ID 1

// list of towns on ots
$towns_list[0] = array(0 => 'Cidade1'); // list of towns, id => 'name', $towns_list[0] - for world id 0
$towns_list[1] = array(0 => 'Cidade1'); // list of towns, id => 'name', $towns_list[1] - for world id 1

 

Ae aparece la no site certinho as vocações que eu quero, porém da esse erro, quando escolho a vocação "Exemplo1" e também com a "Exemplo2" (...copyExemplo2 doesn't...):

The Following Errors Have Occurred:
Wrong characters configuration. Try again or contact with admin. ADMIN: Edit file config/config.php and set valid characters to copy names. Character to copyExemplo1 doesn't exist.

 

Se alguem souber o que eu posso fazer para que o site crie o character eu agradeço de coração.

[guixap 60]

é porque não existe a vocação ou o sample da vocação na DB.

[Rayan 2]

Entendi vou ver se arrumo qualquer coisa edito essa msg, obrigado por me ajudar.

 

Não sei se era isso mas fui coloca no SQL as duas vocações e deu nisso na primeira tentativa:

 

Erro
consulta SQL:

INSERT INTO  `players` (  `id` ,  `name` ,  `world_id` ,  `group_id` ,  `account_id` ,  `level` ,  `vocation` ,  `health` ,  `healthmax` ,  `experience` ,  `lookbody` ,  `lookfeet` ,  `lookhead` ,  `looklegs` ,  `looktype` ,  `lookaddons` ,  `maglevel` ,  `mana` ,  `manamax` ,  `manaspent` ,  `soul` ,  `town_id` ,  `posx` ,  `posy` ,  `posz` ,  `conditions` ,  `cap` ,  `sex` ,  `lastlogin` ,  `lastip` ,  `save` , `skull` ,  `skulltime` ,  `rank_id` ,  `guildnick` ,  `lastlogout` ,  `blessings` ,  `balance` ,  `stamina` ,  `direction` ,  `loss_experience` ,  `loss_mana` ,  `loss_skills` ,  `loss_containers` ,  `loss_items` ,  `premend` ,  `online` ,  `marriage` ,  `promotion` ,  `deleted` ,  `description` ,  `created` ,  `nick_verify` ,  `old_name` ,  `hide_char` ,  `worldtransfer` ,  `comment` ,  `show_outfit` , `show_eq` ,  `show_bars` ,  `show_skills` ,  `show_quests` ,  `exphist_lastexp` ,  `exphist1` ,  `exphist2` ,  `exphist3` ,  `exphist4` ,  `exphist5` ,  `exphist6` ,  `exphist7` ,  `onlinetimetoday` ,  `onlinetime1` ,  `onlinetime2` ,  `onlinetime3` ,  `onlinetime4` ,  `onlinetime5` ,  `onlinetime6` ,  `onlinetime7` ,  `onlinetimeall` ,  `auction_balance` ) 
VALUES ( 1,  'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7,  '', 400, 0, 0, 0, 0, 0, 0, 0,  '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0,  '', 0, 0,  '', 1, 0,  '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) , ( 2,  'Exemplo1', 0, 1, 1, 1, 0, 500, 500, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7,  '', 400, 0, 0, 0, 0, 0, 0, 0,  '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0,  '', 0, 0,  '', 1, 0,  '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) , ( 3,  'Exemplo2', 0, 1, 1, 8, 1, 500, 500, 0, 0, 0, 0, 0, 128, 0, 0, 50, 50, 0, 0, 2, 0, 0, 0,  '', 600, 0, 0, 0, 0, 0, 0, 0,  '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0,  '', 0, 0,  '', 1, 0,  '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )

Mensagens do MySQL : 

#1054 - Unknown column 'auction_balance' in 'field list' 

 

 

 

Ae vi que tinha erro na coluna então tirei ali onde estava escito "auction_balance" para ver se dava, e deu nisso:

Erro
consulta SQL:

INSERT INTO  `players` (  `id` ,  `name` ,  `world_id` ,  `group_id` ,  `account_id` ,  `level` ,  `vocation` ,  `health` ,  `healthmax` ,  `experience` ,  `lookbody` ,  `lookfeet` ,  `lookhead` ,  `looklegs` ,  `looktype` ,  `lookaddons` ,  `maglevel` ,  `mana` ,  `manamax` ,  `manaspent` ,  `soul` ,  `town_id` ,  `posx` ,  `posy` ,  `posz` ,  `conditions` ,  `cap` ,  `sex` ,  `lastlogin` ,  `lastip` ,  `save` , `skull` ,  `skulltime` ,  `rank_id` ,  `guildnick` ,  `lastlogout` ,  `blessings` ,  `balance` ,  `stamina` ,  `direction` ,  `loss_experience` ,  `loss_mana` ,  `loss_skills` ,  `loss_containers` ,  `loss_items` ,  `premend` ,  `online` ,  `marriage` ,  `promotion` ,  `deleted` ,  `description` ,  `created` ,  `nick_verify` ,  `old_name` ,  `hide_char` ,  `worldtransfer` ,  `comment` ,  `show_outfit` , `show_eq` ,  `show_bars` ,  `show_skills` ,  `show_quests` ,  `exphist_lastexp` ,  `exphist1` ,  `exphist2` ,  `exphist3` ,  `exphist4` ,  `exphist5` ,  `exphist6` ,  `exphist7` ,  `onlinetimetoday` ,  `onlinetime1` ,  `onlinetime2` ,  `onlinetime3` ,  `onlinetime4` ,  `onlinetime5` ,  `onlinetime6` ,  `onlinetime7` ,  `onlinetimeall` ) 
VALUES ( 1,  'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7,  '', 400, 0, 0, 0, 0, 0, 0, 0,  '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0,  '', 0, 0,  '', 1, 0,  '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) , ( 2,  'Renegado', 0, 1, 1, 1, 0, 500, 500, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7,  '', 400, 0, 0, 0, 0, 0, 0, 0,  '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0,  '', 0, 0,  '', 1, 0,  '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) , ( 3,  'Justiceiro', 0, 1, 1, 8, 1, 500, 500, 0, 0, 0, 0, 0, 128, 0, 0, 50, 50, 0, 0, 2, 0, 0, 0,  '', 600, 0, 0, 0, 0, 0, 0, 0,  '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0,  '', 0, 0,  '', 1, 0,  '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )

Mensagens do MySQL : 

#1136 - Column count doesn't match value count at row 1 

Editado Junho 20, 2011 por Rayan