Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

#1 2010-10-19 14:43:49

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

[FIXED] CSV import -> No sponsor

Hi,

If i select a sponsor in admin->add video->csv import
The Sponsor is not written into the database and because of that not shown below the video.

I tried to fix it by myself by adding

adv = '".$this->db->escape($sponsor)."',

But that seems to be the wrong sponsor. I see below the video the same banner as on the right side of the video smile


sgt-halfsize-banner.jpg

Offline

#2 2010-10-19 16:04:47

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] CSV import -> No sponsor

Fixed.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2010-10-19 17:46:11

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

Re: [FIXED] CSV import -> No sponsor

Yes works now.

But i wondered, why there is no Sponsor added in Adminpanel->Video

There is no Sponsor shown.

I looked into the database and mentioned that there are two columns: "sponsor" and " adv"

Does the manage video page pull the "adv" column?

To clarify: The first 1000 videos where added by "hand" in Adminpanel without massimport. After the conversion was done, we added a sponsor for the video in Adminpanel->Manage with that really awesome button on the right smile Those Sponsors where added to the "adv" column.

Is that intended or is it just a small "bug". Also i don't like to call it a bug, but what for ist the "adv" ?


sgt-halfsize-banner.jpg

Offline

#4 2010-10-20 08:36:27

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] CSV import -> No sponsor

In Admin->Video->Manage the Coins Icon (with + and -) is for Advertising (the per video advertising feature). It does not represent the sponsor, its for the adv column in the database.

From what i understand you added a sponsor in admin, then with the coins icon you added that sponsor to the videos? (one by one, and you actually selected the advertising from the list that popups after you click the coins icon)? If this is correct, then its how its supossed to work.

Should I add the posibility to assign a sponsor directly from Video -> Manage or Video -> Edit?


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#5 2010-10-20 14:47:34

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

Re: [FIXED] CSV import -> No sponsor

Yes,thats correct.

We did it like that. Added a video in AdminPanel via URL Upload. Then we went to the manage page and added a sponsor to that Video. One by one.

What i would like to see:

When someone in Admin Panel adds a Video via single upload function, let them select a sponsor from the Sponsors list. Like in the csv upload. But it should be possible to have no Sponsor.

MY Reason for that: My wife uploads videos one by one, she selects videos from a csv/txt sponsor file and uploads them via Admin Panel . It's simply because she wants more control. Don't get me wrong, csv upload is a great function and i use it, but she does not. Women....... you know smile HAHAHAHA


sgt-halfsize-banner.jpg

Offline

#6 2010-10-20 16:57:32

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] CSV import -> No sponsor

It works this way right now...the only difference is that you assign a advertising banner (which can be part of a sponsor) and not a sponsor directly. This is better also for speed, the per video advertising part loads adv, sponsor, user, category so it has to do 4 database queries (none with cache, but still). How about if i add a field where you can select the sponsor in the video edit page?


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#7 2010-10-20 18:05:48

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

Re: [FIXED] CSV import -> No sponsor

No, leave it like it is. Selecting the sponsor via this ajax button is better than a dropdown in edit video. It's one ( two? ) click more if i have to go into the edit video smile


sgt-halfsize-banner.jpg

Offline

#8 2010-10-20 19:29:44

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] CSV import -> No sponsor

Ok, but you dont select a sponsor now. You assign a advertising banner to the video, not a sponsor. I will keep this in my mind and add a feature to actually change the sponsor if needed, later.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#9 2010-10-26 15:17:54

mfeat50
Member
Registered: 2010-10-25
Posts: 114
Website

Re: [FIXED] CSV import -> No sponsor

For some reason the banners are not showing up under the videos when i select the sponsor on the mass csv import page.

I added the sponsor on the add sponsor page. I checked the view banner and it shows up.

What am i doing wrong?

recap:

I go to adv-add sponsor
I list the name of the sponsor
I list the name and description
I create a new adv banner
click create
sponsor was created

I then go to the mass csv import page and I select the sponsor in the sponsor properties and input all other required info then import videos
the videos get put on the site but there is no sponsor banner under them.

Last edited by mfeat50 (2010-10-26 17:42:07)

Offline

#10 2010-10-26 19:34:36

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] CSV import -> No sponsor

Hmm...seems like a bug. I thaught i already fixed this bug. I will fix it tomorrow morning again and upload the fixes to your server.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#11 2010-12-25 01:33:49

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [FIXED] CSV import -> No sponsor

Is this still happening in BETA3 for you? (works on my testing box).


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#12 2010-12-25 03:32:08

mfeat50
Member
Registered: 2010-10-25
Posts: 114
Website

Re: [FIXED] CSV import -> No sponsor

I do not have this issue with beta 3. The banners show up just fine.

Thank you!!

Offline

Board footer

Powered by FluxBB