vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Geek Advertising Banner system RC1 (https://vborg.vbsupport.ru/showthread.php?t=79791)

Davez 05-03-2005 04:07 PM

Hi anyone !

I just installed this hack , and i got some problems.
If i click on Packages in acp i get this error :

PHP Code:

Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-AbfrageSELECT FROM GAB_packages ORDER BY ordinal,title,id asc
mysql error
Table 'sdtforum.GAB_packages' doesn't exist

mysql error number: 1146

Datum: 03.05.2005 19:04:11
Skript: http://www.xxx.com/admincp/GAB_admin.php?do=displaypackages
Referer: http://www.xxx.com/admincp/index.php?do=nav 

if i wanna add a Package , i get :

PHP Code:

Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-AbfrageINSERT INTO GAB_packages
            
(title,description,price,currency,duration,frequency,scripts,forumids,ordinal,hits,viewsVALUES (
            
'test',
            
'test2',
            
2,
            
'EUR',
            
0,
            
0,
            
'forumhome,',
            
'9,36,',
            
0
            0
,
            
0
            
)
mysql errorYou have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '0,
            0
            )' 
at line 12

mysql error number
1064

Datum
03.05.2005 19:06:18
Skript
http://www.xxx.com/admincp/GAB_admin.php
Refererhttp://www.xxx.com/admincp/GAB_admin.php?do=addpackage 

Someone got an idea to help me ?

Many thanks.

The Geek 05-03-2005 04:09 PM

Quote:

Originally Posted by Davez
Hi anyone !

I just installed this hack , and i got some problems.
If i click on Packages in acp i get this error :

PHP Code:

Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-AbfrageSELECT FROM GAB_packages ORDER BY ordinal,title,id asc
mysql error
Table 'sdtforum.GAB_packages' doesn't exist

mysql error number: 1146

Datum: 03.05.2005 19:04:11
Skript: http://www.xxx.com/admincp/GAB_admin.php?do=displaypackages
Referer: http://www.xxx.com/admincp/index.php?do=nav 

if i wanna add a Package , i get :

PHP Code:

Datenbankfehler in vBulletin 3.0.0:

Ungueltige SQL-AbfrageINSERT INTO GAB_packages
            
(title,description,price,currency,duration,frequency,scripts,forumids,ordinal,hits,viewsVALUES (
            
'test',
            
'test2',
            
2,
            
'EUR',
            
0,
            
0,
            
'forumhome,',
            
'9,36,',
            
0
            0
,
            
0
            
)
mysql errorYou have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '0,
            0
            )' 
at line 12

mysql error number
1064

Datum
03.05.2005 19:06:18
Skript
http://www.xxx.com/admincp/GAB_admin.php
Refererhttp://www.xxx.com/admincp/GAB_admin.php?do=addpackage 

Someone got an idea to help me ?

Many thanks.

packages are not implimented yet - just ignore for now :)

fogua 05-04-2005 01:14 PM

Can you look at the stats of each banner?
Can I add more banner zones? like at the bottom?

CosmicBlend 05-04-2005 02:23 PM

Quote:

Originally Posted by fogua
Can you look at the stats of each banner?
Can I add more banner zones? like at the bottom?

you should be able to add the banner varible in your footer template also

fogua 05-04-2005 02:57 PM

Quote:

Originally Posted by CosmicBlend
you should be able to add the banner varible in your footer template also

And the zone will appear on the ADM I assume



and do youn now If I will be able to llok at stats something like this
https://vborg.vbsupport.ru/attachmen...chmentid=25583

fogua 05-05-2005 01:12 PM

I have a Problem
I upload the files at their location and

I allready install it and shows :

File Changes complete.
All files I changed are in /Beta 2.0. You will need to copy those over to their forum locations once you are satisfied they are changed correctly.
Completed Install!

When I go look up those files I couldnt find them
And on the admin cpanel can find the option

The Geek 05-05-2005 01:29 PM

Quote:

Originally Posted by fogua
I have a Problem
I upload the files at their location and

I allready install it and shows :

File Changes complete.
All files I changed are in /Beta 2.0. You will need to copy those over to their forum locations once you are satisfied they are changed correctly.
Completed Install!


When I go look up those files I couldnt find them
And on the admin cpanel can find the option

look in your gish folder :)

fogua 05-05-2005 04:17 PM

Ok I fond them So I put the index.php in the admincp folder and de global.php on the buletin root.
When I try to get inside de admin y pops this error

Parse error: parse error, unexpected '=' in /homepages/44/d125171713/htdocs/forum/admincp/index.php on line 581

fogua 05-05-2005 05:04 PM

I think I found the problem
On the ADMINCP folder
The Index.php file

On the line 581

...........

= false;
// === GAB ===

................

I just tipe
$printhr = false;

............

And it works Does this change was right

Ok now when I save on the configure option happen this.

The Geek 05-05-2005 06:03 PM

Quote:

Originally Posted by fogua
I think I found the problem
On the ADMINCP folder
The Index.php file

On the line 581

...........


= false;
// === GAB ===

................


I just tipe
$printhr = false;

............

And it works Does this change was right


Ok now when I save on the configure option happen this.

yea - no ads are getting pulled because you have no ads yet ;)

venomx 05-05-2005 06:08 PM

Maybe this needs a default ad for each ad type so when the ads run out something is shown? ;)

fogua 05-05-2005 06:10 PM

Quote:

Originally Posted by The Geek
yea - no ads are getting pulled because you have no ads yet ;)


in what folder should I put the adds?

The Geek 05-05-2005 07:18 PM

Quote:

Originally Posted by fogua
in what folder should I put the adds?

the gab folder... then you need to add them via the admincp

fogua 05-05-2005 08:14 PM

I have a problem
The install didnt creat the vb_GAB_packages table at the database

vb_GAB_packages' doesn't exist

I want to creat but dont know the values for

Ordinal
Title
Id
Asc

The Geek 05-05-2005 08:26 PM

known issue - that side of things isnt implemented yet. In fact - Its being removed from this hack all together.
I am working to make the GAB hack stand alone then a seperate system to pull GAB and GAL togehter in a user module.

The Geek 05-05-2005 08:32 PM

Now that GAL 4 is ending RC, Im picking GAB back up to finish its development.


As you are area aware (if you have been following the thread), I am going to decouple the user management side of GAB from the core system in order to make a stand alone banner system. Once that goes gold, I will then release a new hack that will allow users to purchase and manage their own GAL entries and/or GAB entries.

Anyhoo.... Saying that... I was hoping to include adsense support. Can anyone give me some details of what is required to spit out google adsense? Is it just a couple of settings? Are they static? Would a template sufice?

Thanks all.

SEO Report 05-07-2005 03:02 AM

Quote:

I was hoping to include adsense support. Can anyone give me some details of what is required to spit out google adsense? Is it just a couple of settings? Are they static? Would a template sufice?
Adsense is basically a "set and forget" system that consists of some html code dynamically served by google. If you allow text based banners, then you already support Adsense.

But tracking clicks and impressions is a different story though, you might well be able to track impressions, but sometimes the ad is just a PSA, which makes impressions inaccurate IMO.

Having said that, not being able to track adsense is not a big deal IMO, since google already offer such feature in Adsense CP.

-k

venomx 05-07-2005 03:12 AM

I dont think you can track the clicks for adsense or any other HTML ad...
I have a banner exchange I run and if I put an HTML ad in I can only track the impressions. I have had no problem with this.

I run phpAdsnew on a few sites and it says it can edit the HTML ads code to track clciks, not sure if it works because i am scared to test it hehe

LEAD_WEIGHT 05-07-2005 04:33 AM

Quote:

Originally Posted by venomx
I dont think you can track the clicks for adsense or any other HTML ad...
I have a banner exchange I run and if I put an HTML ad in I can only track the impressions. I have had no problem with this.

I run phpAdsnew on a few sites and it says it can edit the HTML ads code to track clciks, not sure if it works because i am scared to test it hehe

Just goto your adsense login page and look, even this pricey one does not have it.
Code:

http://www.keyconcept.org/vbulletin-adsense-revenue-sharing-hack-mod/

uReside.com 05-07-2005 04:51 AM

anxiously awaiting :D

KAC 05-07-2005 11:43 PM

I keep getting "GAS_settings_saved" phrase missing when I try to edit settings. I am also getting DB errors when trying to add packages. I used the installer included even though the topic says there is not one. So what gives

The Geek 05-08-2005 06:45 AM

read the thread - the packages are not implimented yet - thats why you are getting the package error and the GAS_settings_saved phrase missing is a known issue - all be it a mionor one.

Thanks

KAC 05-08-2005 01:53 PM

So what should I do to make it work? I would like to use both your hacks as they are exactly what I am looking for.

The Geek 05-08-2005 06:57 PM

Quote:

Originally Posted by KAC
So what should I do to make it work? I would like to use both your hacks as they are exactly what I am looking for.

It will work fine - just dont use the packages - thats a user interface option not needed for the banners to work.

Visions 05-08-2005 07:01 PM

I still cant get it to work. I try to upload banners but i still see nothing on the entire site.

FD929 05-08-2005 09:02 PM

Geek - love your work. I admin 2 sites and have some of your hacks on both.

Anyways, found a bug and it's been mentioned in the thread, but not exactly addressed. Here's the code.

Code:

Step by step

step 200
--------------------------------------------------------------------------------

in admincp/index.php, replace:

--------------------------------------------------------------------------------

$printhr = false;
        if (can_administer('canadminstyles'))
        {

--------------------------------------------------------------------------------

with:

--------------------------------------------------------------------------------

        = false;
        // === GAB  ===
        construct_nav_option($vbphrase['GAB_settings'], 'GAB_admin.php?do=settings');
        construct_nav_option($vbphrase['GAB_display_ads'], 'GAB_admin.php');
        construct_nav_option($vbphrase['GAB_add_ad'], 'GAB_admin.php?do=add');
    construct_nav_option($vbphrase['GAB_display_packages'], 'GAB_admin.php?do=displaypackages');
    construct_nav_option($vbphrase['GAB_add_package'], 'GAB_admin.php?do=addpackage');
        construct_nav_option($vbphrase['GAB_display_frequency'], 'GAB_admin.php?do=displayfrequency');
        construct_nav_option($vbphrase['GAB_add_frequency'], 'GAB_admin.php?do=addfrequency');
        construct_nav_option($vbphrase['GAB_test'], 'GAB_admin.php?do=test');
        construct_nav_group($vbphrase['GAB_CP']);
        $printhr = true;
        $printhr = false;
        // === GAB ===
    $printhr = false;
        if (can_administer('canadminstyles'))
        {

Seems that the initial '$printhr = false' is not being completely deleted or it's just a typo in the manual instructions.

FD929 05-08-2005 10:01 PM

Quote:

Originally Posted by FD929
Geek - love your work. I admin 2 sites and have some of your hacks on both.

Anyways, found a bug and it's been mentioned in the thread, but not exactly addressed. Here's the code.

Code:

Step by step

step 200
--------------------------------------------------------------------------------

in admincp/index.php, replace:

--------------------------------------------------------------------------------

$printhr = false;
        if (can_administer('canadminstyles'))
        {

--------------------------------------------------------------------------------

with:

--------------------------------------------------------------------------------

        = false;
        // === GAB  ===
        construct_nav_option($vbphrase['GAB_settings'], 'GAB_admin.php?do=settings');
        construct_nav_option($vbphrase['GAB_display_ads'], 'GAB_admin.php');
        construct_nav_option($vbphrase['GAB_add_ad'], 'GAB_admin.php?do=add');
    construct_nav_option($vbphrase['GAB_display_packages'], 'GAB_admin.php?do=displaypackages');
    construct_nav_option($vbphrase['GAB_add_package'], 'GAB_admin.php?do=addpackage');
        construct_nav_option($vbphrase['GAB_display_frequency'], 'GAB_admin.php?do=displayfrequency');
        construct_nav_option($vbphrase['GAB_add_frequency'], 'GAB_admin.php?do=addfrequency');
        construct_nav_option($vbphrase['GAB_test'], 'GAB_admin.php?do=test');
        construct_nav_group($vbphrase['GAB_CP']);
        $printhr = true;
        $printhr = false;
        // === GAB ===
    $printhr = false;
        if (can_administer('canadminstyles'))
        {

Seems that the initial '$printhr = false' is not being completely deleted or it's just a typo in the manual instructions.

Well I've read most of the thread now. Disregard my previous post, although I still don't see that it was mentioned that it was written that way in the manual install instructions.

Anxiously awaiting the new release!

fogua 05-09-2005 05:47 PM

On the admin shows de banner with no problem
On the forum wont show it.

When I run the test shows this

fogua 05-10-2005 02:00 PM

Any one??????

The Geek 05-10-2005 03:01 PM

Quote:

Originally Posted by fogua
Any one??????

That test is saying that
You dont have a valid script to test (ie there is no banner specified for that script)

Make sure you have valid scripts ticked in the settings and a banner that is also ticked for those scripts

fogua 05-10-2005 03:32 PM

Quote:

Originally Posted by The Geek
That test is saying that
You dont have a valid script to test (ie there is no banner specified for that script)

Make sure you have valid scripts ticked in the settings and a banner that is also ticked for those scripts


Please Geek Sorry
But Im desperate couse is the only thing missing before going online. Can you go to my admin and check its ok
I allready check and re ckeck and dont seem to find the problem

Thanks 100000 :)

The Geek 05-10-2005 03:48 PM

Quote:

Originally Posted by fogua
Please Geek Sorry
But Im desperate couse is the only thing missing before going online. Can you go to my admin and check its ok
I allready check and re ckeck and dont seem to find the problem

Thanks 100000 :)

There were a few problems.
1- Admin usergroup had the option of turning off ads if the bio was blank.
2- No $GAB_ad1 appeared in your templates (so no ad would appear)
3- Only forumhome was ticked - I did forumdisplay for you.

fogua 05-10-2005 04:36 PM

Quote:

Originally Posted by The Geek
There were a few problems.
1- Admin usergroup had the option of turning off ads if the bio was blank.
2- No $GAB_ad1 appeared in your templates (so no ad would appear)
3- Only forumhome was ticked - I did forumdisplay for you.


Ok thanks
so the 2 point is the one missing
How do I add $GAB_ad1 and on what file?

The Geek 05-10-2005 04:45 PM

Quote:

Originally Posted by fogua
Ok thanks
so the 2 point is the one missing
How do I add $GAB_ad1 and on what file?

you ad it to whatever template you want ads to appear in (i.e. navbar). Read the README as it explains all.

zell_11 05-10-2005 05:15 PM

ok when i go into packages i get

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT * FROM GAB_packages ORDER BY ordinal,title,id asc
mysql error: Table 'zenoga.GAB_packages' doesn't exist

mysql error number: 1146

Date: Tuesday 10th of May 2005 07:13:46 PM
Script: http://www.zenogaming.com/forums/adm...isplaypackages
Referer: http://www.zenogaming.com/forums/adm...dex.php?do=nav
Username: Cid
IP Address: 81.158.97.160


and when i try and add one i get

Invalid SQL: INSERT INTO GAB_packages
(title,description,price,currency,duration,frequen cy,scripts,forumids,ordinal,hits,views) VALUES (
'',
'',
,
'GBP',
0,
0,
'',
'101,113,114,115,116,98,106,105,104,103,102,100,11 0,111,112,99,107,108,109,22,29,30,31,32,33,34,35,5 7,23,24,25,26,27,28,80,87,88,81,82,92,117,95,40,85 ,41,42,43,55,86,',
0
0,
0
)
mysql error: 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 '
'GBP',
0,
0,
'

mysql error number: 1064

Date: Tuesday 10th of May 2005 07:15:18 PM
Script: http://www.zenogaming.com/forums/admincp/GAB_admin.php
Referer: http://www.zenogaming.com/forums/adm...?do=addpackage
Username: Cid
IP Address: 81.158.97.160


i have tried reinstalling the database but still no luck, anyone able to give me a manual run of the sql or somthing

The Geek 05-10-2005 05:19 PM

packages are not implimented yet. You dont need them for the ads.

kafi 05-10-2005 07:19 PM

Hi, thank you for your system. I am keen to work with it.

I found mistake during my installation. I had to change index in admincp and global.php myself.
I got message to do it so it is ok up to now.

But then i was directed to do as follow:
step 200
--------------------------------------------------------------------------------

in admincp/index.php, replace:

--------------------------------------------------------------------------------

$printhr = false;
if (can_administer('canadminstyles'))
{
--------------------------------------------------------------------------------

with:

--------------------------------------------------------------------------------

= false;
// === GAB ===
construct_nav_option($vbphrase['GAB_settings'], 'GAB_admin.php?do=settings');
construct_nav_option($vbphrase['GAB_display_ads'], 'GAB_admin.php');
construct_nav_option($vbphrase['GAB_add_ad'], 'GAB_admin.php?do=add');
construct_nav_option($vbphrase['GAB_display_packages'], 'GAB_admin.php?do=displaypackages');
construct_nav_option($vbphrase['GAB_add_package'], 'GAB_admin.php?do=addpackage');
construct_nav_option($vbphrase['GAB_display_frequency'], 'GAB_admin.php?do=displayfrequency');
construct_nav_option($vbphrase['GAB_add_frequency'], 'GAB_admin.php?do=addfrequency');
construct_nav_option($vbphrase['GAB_test'], 'GAB_admin.php?do=test');
construct_nav_group($vbphrase['GAB_CP']);
$printhr = true;
$printhr = false;
// === GAB ===
$printhr = false;
if (can_administer('canadminstyles'))
{


I got error in admincp, so I tried to figure out what is wrong /i am not coder/.
I have instead of your "replace with" but everything in "// === GAB ===" between "$printhr = false;" and "if (can_administer('canadminstyles'))
{"

Hope it is ok, because it works.

kafi 05-10-2005 08:22 PM

I am trying to add banner, but do not now how. I copied the image to gab folder. What is next. Trying to add banner i am getting this message:

Warning: copy(./gab/toto.gif): failed to open stream: No such file or directory in /home/www/xxxxxxxx/www/admincp/GAB_admin.php on line 716

The Geek 05-10-2005 08:23 PM

Quote:

Originally Posted by kafi
I am trying to add banner, but do not now how. I copied the image to gab folder. What is next. Trying to add banner i am getting this message:

Warning: copy(./gab/toto.gif): failed to open stream: No such file or directory in /home/www/xxxxxxxx/www/admincp/GAB_admin.php on line 716

you sure you have a folder in your forum directory called gab and its chmod to 0777?

kafi 05-10-2005 08:38 PM

somhow i mannaged to add banner but i am getting same error message as fogua with test:

Variables passed varibales: Usergroup: Administrators (6), script=index (0), forum=blablablabla(10)
Problem No script was passed therefore no ad can be pulled.
Usergroup Passed usergroup. This usergroup is set to view an ad.
Toggle Passed usergroup toggle test. This usergroup could toggle ads on or off.
Script Passed script test. We are in a script that is set to view an ad.
Results: Um. err... No ads matched the criteria:
SELECT DISTINCT ad.id,ad.img,ad.track_shown, ad.max_views, ad.views FROM GAB_ads ad INNER JOIN GAB_listing lst on ad.id=lst.adid WHERE (lst.script = 'forumdisplay') AND ((startdate<1) or (startdate<1115761084)) and ((enddate<1) or (enddate>1115761084)) AND isactive=1 AND (lst.forumid = 10) ORDER BY RAND() LIMIT 2

.....after 5 min.

I have change dates, so it works now and I am getting this:
Variables passed varibales: Usergroup: Administrators (6), script=index (0), forum=Mzdové účtovníctvo, personalistika, odvody(10)
Problem No script was passed therefore no ad can be pulled.
Usergroup Passed usergroup. This usergroup is set to view an ad.
Toggle Passed usergroup toggle test. This usergroup could toggle ads on or off.
Script Passed script test. We are in a script that is set to view an ad.
Results: $GAB_ad1


All times are GMT. The time now is 06:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02840 seconds
  • Memory Usage 1,888KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (4)bbcode_php_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete