Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null' in C:\xampp\htdocs\shopguild.php:488 Stack trace: #0 C:\xampp\htdocs\shopguild.php(488): PDO->query('INSERT INTO `z_...') #1 C:\xampp\htdocs\index.php(124): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopguild.php on line 488

linha 488

$SQL->query($sql);

   elseif($buy_offer['type'] == 'item') {
                                                                                        $sql = 'INSERT INTO '.$SQL->tableName('z_ots_guildcomunication').' (id, name, type, action, param1, param2, param3, param4, param5, param6, param7, delete_it) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', \'login\', \'give_item\', '.$SQL->quote($buy_offer['item_id']).', '.$SQL->quote($buy_offer['item_count']).', \'\', \'\', \'item\', '.$SQL->quote($buy_offer['name']).', \'\', \'1\');';
                                                                                        $SQL->query($sql);
                                                                                        $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shopguild_history_item').' (id, to_name, to_account, from_nick, from_account, price, offer_id, trans_state, trans_start, trans_real) VALUES ('.$SQL->lastInsertId().', '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['item_id']).', \'wait\', '.$SQL->quote(time()).', \'0\');';
                                                                                        $SQL->query($save_transaction);
                                                                                        $account_logged->setCustomField('guild_points', $user_guild_points-$buy_offer['points']);
                                                                                        $user_guild_points = $user_guild_points - $buy_offer['points'];
                                                                                        $main_content .= '<center><h2>Item added!</h2><b>'.$buy_offer['name'].'</b> added to player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' guild points</b> from your account.<br>Now you have <b>'.$user_guild_points.' guild points</b>.<br><br><a href="index.php?subtopic=shopguild">GO TO MAIN SHOP SITE</a><br>';

                                                                                }

 

 

REP + PRA QUEM AJUDA.

Editado Maio 19, 2015 10 anos por macalo (veja o histórico de edições)

qual versao do xampp?

qual versao do xampp?

cara n importa xamp n é o script msm q ta faltando algumas query na data base.

http://www.tibiaking.com/forum/topic/24445-pedido-guildshopsystem/

http://www.tibiaking.com/forum/topic/24445-pedido-guildshopsystem/

CARA NÃO É ISSO AI , MAIS VLW PELAA AJUDA ..