MODS.DB9.DK

[johnpg82]

It was getting an error in mysql syntax. Some wierd lookin o thing in the code so I manually inserted my code with the folllowing and it allowed me to edit it later.

INSERT INTO phpbb_banner (banner_id, banner_name, banner_active, banner_spot, banner_description, banner_url, banner_click, banner_view, banner_owner, banner_level, banner_level_type, banner_timetype, time_begin, time_end, date_begin, date_end, banner_comment, banner_type, banner_width, banner_height, banner_filter, banner_filter_time, banner_weigth) VALUES ('1','http://affiliate.casinorewards.com/members/affiliate/banner_site/images/sil/sil_68_120x90_20free2.gif', '1', '0', 'Earn Free Points', 'http://www.strikeitluckycasino.com/referral.asp?aff_id=aff38749', '0', '0', '2', '-1', '2', '0', '0', '0', '0', '0', '','0','0''122','55','0','600','50');

Note you have to change the first character up for every ad you want.

[duvelske]

After i've updated the mod i've got a simular error

Code: Select all

Couldn't update/insert into banners table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''122','55','0','600','50')' at line 2

INSERT INTO phpbb_banner (banner_id, banner_name, banner_active, banner_spot, banner_description, banner_url, banner_click, banner_view, banner_owner, banner_level, banner_level_type, banner_timetype, time_begin, time_end, date_begin, date_end, banner_comment, banner_type, banner_width, banner_height, banner_filter, banner_filter_time,banner_weigth) VALUES ('1','test', '1', '0', 'tset', 'http://www.test.nl', '0', '0', '4', '-1', '2', '0', '0', '0', '0', '0', 'test','2',ø'122','55','0','600','50')

Line : 616
File : /home/vitrax/public_html/admin/admin_banner.php

think it has to do with this section ,ø'122' but how i hells name do i remove that one?

[johnpg82]

i never figured out how to change it besides copying the code and changing that symbol to a 0 and manually inserting it into phpMyAdmin. Then you can edit it in the admin section later

[duvelske]

I've fixed it

search for:
in admin_banner.php

Code: Select all

banner_id, banner_name, banner_active, banner_spot, banner_description, banner_url

Then the line below. REplace with this:

Code: Select all

VALUES ('$banner_id','" . str_replace("\'", "''", $banner_name) . "', '$banner_active', '$banner_spot', '" . str_replace("\'", "''", $banner_description) . "', '" . str_replace("\'", "''", $banner_url) . "', '$banner_click', '$banner_view', '".$owner['user_id']."', '$banner_level', '$banner_level_type', '$time_type', '$time_begin', '$time_end', '$date_begin', '$date_end', '" . str_replace("\'", "''", $banner_comment) . "','$banner_type','" . str_replace("\'", "''", $banner_width) . "','" . str_replace("\'", "''",
$banner_height) . "','$banner_filter','$banner_filter_time','$banner_weigth')";