Joined: Aug 29, 2004 Posts: 324 Location: New Mexico
Posted:
Fri Sep 21, 2007 2:52 pm
I have rn2.10.01 and I have just started to try out the banners and seem that I can not add a new client (just doesn't save it) and I can add any banners. The link "Add a new banner" is not a link.
Joined: Aug 29, 2004 Posts: 9071 Location: Arizona
Posted:
Thu Oct 18, 2007 5:44 am
Mine was an upgrade and it is working fine too, plus I have the team's working copy local and it is also working.
I just wonder if there isn't a corrupt file somewhere, either in the distro or in the
Only registered users can see links on this board! Get registered or login to the forums!
Try downloading one of the other compressed versions (Raven is providing the same distro compressed with different tools) and replace your modules/Advertising files and let us see if that does the trick.
Joined: Aug 28, 2003 Posts: 6302 Location: Vsetin, Czech Republic
Posted:
Thu Oct 18, 2007 10:15 am
I cannot replicate this either. I know there sometimes can be problems with upgraded sites due to references to the old banner system being left behind but I'm not able to duplicate this problem on my test site.
I know that doesn't help much but if I can't reproduce I'm struggling to find the cause.
You mentioned the old banner system being left behind. I checked my error log and found these two errors. Could this be part of the problem?
[error] PHP Warning: themeheader() [<a href='function.include'>function.include</a>]: Failed opening 'banners.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /<path removed by admin>/themes/N4G-BF2Clan/theme.php on line 90
[error] PHP Warning: themeheader(banners.php) [<a href='function.themeheader'>function.themeheader</a>]: failed to open stream: No such file or directory in /<path removed by admin>/themes/N4G-BF2Clan/theme.php on line 90
Joined: Aug 28, 2003 Posts: 6302 Location: Vsetin, Czech Republic
Posted:
Thu Oct 18, 2007 1:53 pm
Could well be. Your theme is for a pre 7.8 nuke so you'll have to modify it.
You can check easily enough by switching to one of the themes that come with Raven Nuke
Joined: Aug 29, 2004 Posts: 9071 Location: Arizona
Posted:
Fri Oct 19, 2007 5:50 am
I removed your path details in your post above. No-one should ever need to see that and poses a slight security risk for you.
I am concerned that the original problem in this thread is related to the inability to save a new banner client. Don't believe that is related to the themeheader(). These are two separate problems.
Please post the structure of your nuke_banner_clients table.
I tried using a theme that came with RN and I'm still unable to create a banner client. I'm not sure how to post the structure of my nuke_banner_clients table. BTW, thanks for removing my path details.
I fixed this for Tizwit a few days ago. He was missing almost all of the advertising related tables. The only ones he had were banner and bannner_clients. The others were not there. Apparently something went wrong in his upgrade. I suspect this is a problem for Foggy as well.
you also need banner_plans,banner_positions, and banner_terms
if anyone is experiencing problems like this, it can also be due to certain words used in the advertising, like "u nion" and also other vulnerablities.
After checking my tables I found that all I have are banner and banner clients. I probably have the same problem that Tizwit had. 'Can you tell me how to add the other tables?
Joined: Aug 29, 2004 Posts: 9071 Location: Arizona
Posted:
Wed Oct 24, 2007 7:53 pm
Foggy,
If you don't mind starting fresh with these few tables, you could copy and paste the following into phpMyAdmin for you database and get back to a fresh install of RN for these tables:
Code:
DROP TABLE IF EXISTS $prefix.`_banner`;
CREATE TABLE $prefix.`_banner` (`bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `name` varchar(50) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `alttext` varchar(255) NOT NULL default '', `date` datetime default NULL, `dateend` datetime default NULL, `position` int(10) NOT NULL default '0', `active` tinyint(1) NOT NULL default '1', `ad_class` varchar(5) NOT NULL default '', `ad_code` text NOT NULL, `ad_width` int(4) default '0', `ad_height` int(4) default '0', PRIMARY KEY (`bid`), KEY `bid` (`bid`), KEY `cid` (`cid`)) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS $prefix.`_banner_clients`;
CREATE TABLE $prefix.`_banner_clients` (`cid` int(11) NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `contact` varchar(60) NOT NULL default '', `email` varchar(60) NOT NULL default '', `login` varchar(10) NOT NULL default '', `passwd` varchar(10) NOT NULL default '', `extrainfo` text NOT NULL, PRIMARY KEY (`cid`), KEY `cid` (`cid`)) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS $prefix.`_banner_plans`;
CREATE TABLE $prefix.`_banner_plans` (`pid` int(10) NOT NULL auto_increment, `active` tinyint(1) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `delivery` varchar(10) NOT NULL default '', `delivery_type` varchar(25) NOT NULL default '', `price` varchar(25) NOT NULL default '0', `buy_links` text NOT NULL, PRIMARY KEY (`pid`)) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS $prefix.`_banner_positions`;
CREATE TABLE $prefix.`_banner_positions` (`apid` int(10) NOT NULL auto_increment, `position_number` int(5) NOT NULL default '0', `position_name` varchar(255) NOT NULL default '', PRIMARY KEY (`apid`), KEY `position_number` (`position_number`)) TYPE=MyISAM AUTO_INCREMENT=3 ;
INSERT INTO $prefix.`_banner_positions` VALUES (1, 0, 'Page Top');
INSERT INTO $prefix.`_banner_positions` VALUES (2, 1, 'Left Block');
DROP TABLE IF EXISTS $prefix.`_banner_terms`;
CREATE TABLE $prefix.`_banner_terms` (`terms_body` text NOT NULL, `country` varchar(255) NOT NULL default '') TYPE=MyISAM;
INSERT INTO $prefix.`_banner_terms` VALUES ('<div align="justify"><strong>Introduction:</strong> This Agreement between you and [sitename] consists of these Terms and Conditions. "You" or "Advertiser" means the entity identified in this enrollment form, and/or any agency acting on its behalf, which shall also be bound by the terms of this Agreement. Please read very carefully these Terms and Conditions.<br /><strong><br />Uses:</strong> You agree that your ads may be placed on (i) [sitename] web site and (ii) Any ads may be modified without your consent to comply with any policy of [sitename]. [sitename] reserves the right to, and in its sole discretion may, at any time review, reject, modify, or remove any ad. No liability of [sitename] and/or its owner(s) shall result from any such decision.<br /><br /></div><div align="justify"><strong>Parties'' Responsibilities:</strong> You are responsible of your own site and/or service advertised in [sitename] web site. You are solely responsible for the advertising image creation, advertising text and for the content of your ads, including URL links. [sitename] is not responsible for anything regarding your Web site(s) including, but not limited to, maintenance of your Web site(s), order entry, customer service, payment processing, shipping, cancellations or returns.<br /><br /></div><div align="justify"><strong>Impressions Count:</strong> Any hit to [sitename] web site is counted as an impression. Due to our advertising price we don''t discriminate from users or automated robots. Even if you access to [sitename] web site and see your own banner ad it will be counted as a valid impression. Only in the case of [sitename] web site administrator, the impressions will not be counted.<br /><br /></div><div align="justify"><strong>Termination, Cancellation:</strong> [sitename] may at any time, in its sole discretion, terminate the Campaign, terminate this Agreement, or cancel any ad(s) or your use of any Target. [sitename] will notify you via email of any such termination or cancellation, which shall be effective immediately. No refund will be made for any reason. Remaining impressions will be stored in a database and you''ll be able to request another campaign to complete your inventory. You may cancel any ad and/or terminate this Agreement with or without cause at any time. Termination of your account shall be effective when [sitename] receives your notice via email. No refund will be made for any reason. Remaining impressions will be stored in a database for future uses by you and/or your company.<br /><br /></div><div align="justify"><strong>Content:</strong> [sitename] web site doesn''t accepts advertising that contains: (i) pornography, (ii) explicit adult content, (iii) moral questionable content, (iv) illegal content of any kind, (v) illegal drugs promotion, (vi) racism, (vii) politics content, (viii) religious content, and/or (ix) fraudulent suspicious content. If your advertising and/or target web site has any of this content and you purchased an advertising package, you''ll not receive refund of any kind but your banners ads impressions will be stored for future use.<br /><br /></div><div align="justify"><strong>Confidentiality:</strong> Each party agrees not to disclose Confidential Information of the other party without prior written consent except as provided herein. "Confidential Information" includes (i) ads, prior to publication, (ii) submissions or modifications relating to any advertising campaign, (iii) clickthrough rates or other statistics (except in an aggregated form that includes no identifiable information about you), and (iv) any other information designated in writing as "Confidential." It does not include information that has become publicly known through no breach by a party, or has been (i) independently developed without access to the other party''s Confidential Information; (ii) rightfully received from a third party; or (iii) required to be disclosed by law or by a governmental authority.<br /><br /></div><div align="justify"><strong>No Guarantee:</strong> [sitename] makes no guarantee regarding the levels of clicks for any ad on its site. [sitename] may offer the same Target to more than one advertiser. You may not receive exclusivity unless special private contract between [sitename] and you.<br /><br /></div><div align="justify"><strong>No Warranty:</strong> [sitename] MAKES NO WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION WITH RESPECT TO ADVERTISING AND OTHER SERVICES, AND EXPRESSLY DISCLAIMS THE WARRANTIES OR CONDITIONS OF NONINFRINGEMENT, MERCHANTABILITY AND FITNESS FOR ANY PARTICULAR PURPOSE.<br /><br /></div><div align="justify"><strong>Limitations of Liability:</strong> In no event shall [sitename] be liable for any act or omission, or any event directly or indirectly resulting from any act or omission of Advertiser, Partner, or any third parties (if any). EXCEPT FOR THE PARTIES'' INDEMNIFICATION AND CONFIDENTIALITY OBLIGATIONS HEREUNDER, (i) IN NO EVENT SHALL EITHER PARTY BE LIABLE UNDER THIS AGREEMENT FOR ANY CONSEQUENTIAL, SPECIAL, INDIRECT, EXEMPLARY, PUNITIVE, OR OTHER DAMAGES WHETHER IN CONTRACT, TORT OR ANY OTHER LEGAL THEORY, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES AND NOTWITHSTANDING ANY FAILURE OF ESSENTIAL PURPOSE OF ANY LIMITED REMEDY AND (ii) [sitename] AGGREGATE LIABILITY TO ADVERTISER UNDER THIS AGREEMENT FOR ANY CLAIM IS LIMITED TO THE AMOUNT PAID TO [sitename] BY ADVERTISER FOR THE AD GIVING RISE TO THE CLAIM. Each party acknowledges that the other party has entered into this Agreement relying on the limitations of liability stated herein and that those limitations are an essential basis of the bargain between the parties. Without limiting the foregoing and except for payment obligations, neither party shall have any liability for any failure or delay resulting from any condition beyond the reasonable control of such party, including but not limited to governmental action or acts of terrorism, earthquake or other acts of God, labor conditions, and power failures.<br /><br /></div><div align="justify"><strong>Payment:</strong> You agree to pay in advance the cost of the advertising. [sitename] will not setup any banner ads campaign(s) unless the payment process is complete. [sitename] may change its pricing at any time without prior notice. If you have an advertising campaign running and/or impressions stored for future use for any mentioned cause and [sitename] changes its pricing, you''ll not need to pay any difference. Your purchased banners fee will remain the same. Charges shall be calculated solely based on records maintained by [sitename]. No other measurements or statistics of any kind shall be accepted by [sitename] or have any effect under this Agreement.<br /><br /></div><div align="justify"><strong>Representations and Warranties:</strong> You represent and warrant that (a) all of the information provided by you to [sitename] to enroll in the Advertising Campaign is correct and current; (b) you hold all rights to permit [sitename] and any Partner(s) to use, reproduce, display, transmit and distribute your ad(s); and (c) [sitename] and any Partner(s) Use, your Target(s), and any site(s) linked to, and products or services to which users are directed, will not, in any state or country where the ad is displayed (i) violate any criminal laws or third party rights giving rise to civil liability, including but not limited to trademark rights or rights relating to the performance of music; or (ii) encourage conduct that would violate any criminal or civil law. You further represent and warrant that any Web site linked to your ad(s) (i) complies with all laws and regulations in any state or country where the ad is displayed; (ii) does not breach and has not breached any duty toward or rights of any person or entity including, without limitation, rights of publicity or privacy, or rights or duties under consumer protection, product liability, tort, or contract theories; and (iii) is not false, misleading, defamatory, libelous, slanderous or threatening.<br /><br /></div><div align="justify"><strong>Your Obligation to Indemnify:</strong> You agree to indemnify, defend and hold [sitename], its agents, affiliates, subsidiaries, directors, officers, employees, and applicable third parties (e.g., all relevant Partner(s), licensors, licensees, consultants and contractors) ("Indemnified Person(s)") harmless from and against any and all third party claims, liability, loss, and expense (including damage awards, settlement amounts, and reasonable legal fees), brought against any Indemnified Person(s), arising out of, related to or which may arise from your use of the Advertising Program, your Web site, and/or your breach of any term of this Agreement. Customer understands and agrees that each Partner, as defined herein, has the right to assert and enforce its rights under this Section directly on its own behalf as a third party beneficiary.<br /><br /></div><div align="justify"><strong>Information Rights:</strong> [sitename] may retain and use for its own purposes all information you provide, including but not limited to Targets, URLs, the content of ads, and contact and billing information. [sitename] may share this information about you with business partners and/or sponsors. [sitename] will not sell your information. Your name, web site''s URL and related graphics shall be used by [sitename] in its own web site at any time as a sample to the public, even if your Advertising Campaign has been finished.<br /><br /></div><div align="justify"><strong>Miscellaneous:</strong> Any decision made by [sitename] under this Agreement shall be final. [sitename] shall have no liability for any such decision. You will be responsible for all reasonable expenses (including attorneys'' fees) incurred by [sitename] in collecting unpaid amounts under this Agreement. This Agreement shall be governed by the laws of [country]. Any dispute or claim arising out of or in connection with this Agreement shall be adjudicated in [country]. This constitutes the entire agreement between the parties with respect to the subject matter hereof. Advertiser may not resell, assign, or transfer any of its rights hereunder. Any such attempt may result in termination of this Agreement, without liability to [sitename] and without any refund. The relationship(s) between [sitename] and the "Partners" is not one of a legal partnership relationship, but is one of independent contractors. This Agreement shall be construed as if both parties jointly wrote it.</div>', '');
That fix did the trick and all seems to be working just fine now! Is there a way I can compare my tables to the tables that should have been installed with the rn 2.10.01 update incase I'm missing any others?
Joined: Aug 29, 2004 Posts: 9071 Location: Arizona
Posted:
Sat Oct 27, 2007 6:54 am
Yes there is. Here is one such approach:
1. Download and install XAMPP
2. Export your site's database tables
3. Create a data in mySQL (your local XAMPP) using the provided phpMyAdmin
4. Import your site's database tables into it
5. Download and install RavenNuke as a separate databases in your XAMPP mySQL
6. Get yourself mySQLDiff and use it to compare the two database structures
Now, if you are allowed multiple databases on your hosted site, you could do this instead:
1. Create a subdomain for RavenNuke
2. Create a new database and install RN into it following the instructions
3. Get yourself mySQLDiff and use it to compare the two database structures (you can install it in the RN subdomain if you wanted to. Just needs to have PHP and browser accessible.
I'm trying to setup Advertising in my Site. Everything is working fine. I'm looking for a better understanding on how the clients purchasing process is done.
Heres what I do understand:
You setup a plan using Paypal or what ever options out there to make a buy now button.
What I don't understand is:
When a client has made a purchase; do you the webmaster have to set up their client login and post their banner information?
While i made a test client and went through the buying process there was no return page for the client to insert there banner information.
So with this being said the mod seems to be a lot of steps on waiting for the sell. Then contacting the client to get the information they what as a client login and banner information.
Joined: Aug 30, 2005 Posts: 3137 Location: near Albany NY
Posted:
Wed Feb 25, 2009 9:17 am
Just to resurrect this thread. I have been experimenting with the advertising module on a test site. I basically knew nothing about it and have been learning by doing. I'm finding a lot of old *nuke type glitches. For instance if you add a plan and don't fill out one of the fields (say, buy link) you get an error message and you get told to go back but when you do all your data is lost. Sounds like pure Burzi. Also the wyiswyg editor is not incorporated as far as I can tell.
To Rickleigh's point, it doesn't appear to me that Paypal is integrated nor is purchasing more generically. Basically it appears that what you do is set up a banner (image or html or jabascript) with a link to an advertiser's site (if they want that). There is also a client login but it is looking to me that the admin of the site really has to maintain all the advertising content ... I thought the client would be able to login and do that but it appears that you'd have to make them a site admin for at least advertising before they could maintain the content.
If anyone knows of any documentation for this module please post a link here. I wonder about strategies: what type of plans do you set up? how does the impressions count work? what are typical rates that you set? what kind of revenue can you generate (knowing that this will vary). I guess I'm getting at what the best practices for using this module are and if anyone has some experience and can share it, it would be very helpful to the rest of us.
View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
