vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - Limited Guest Viewing -- Motivate Guests to Register (https://vborg.vbsupport.ru/showthread.php?t=178720)

flup 01-19-2009 04:48 PM

Perfect hack :)

titodj 01-24-2009 06:55 PM

Is there a way to control for how long the cookie is set?
For example, after 24 hrs guest can view the threads again...

Ted S 01-25-2009 09:19 PM

Quote:

Originally Posted by titodj (Post 1723575)
Is there a way to control for how long the cookie is set?
For example, after 24 hrs guest can view the threads again...

There is not a way to control the cookie timing at this point.

titodj 01-26-2009 11:14 AM

Thanks for your answer....
Another question, then... As it is right now, how long does the cookie lasts?

otix_ 01-27-2009 10:40 AM

nice Mod, thx!

tony adams 01-28-2009 09:06 PM

installed on 3.8 and agree with the comment above

Quote:

Well... the only thing that dosen?t works is the Register Take-Over Message Count, but the Register Block Page Count It?s OK
anybody got round this - it is something i would want - the warning is needed i think before locking anybody out

Adeawan 01-28-2009 09:18 PM

thanks for that

Ted S 01-28-2009 09:27 PM

Quote:

Originally Posted by tony adams (Post 1727556)
installed on 3.8 and agree with the comment above



anybody got round this - it is something i would want - the warning is needed i think before locking anybody out

Have you added the appropriate variable to show the message?

tony adams 01-28-2009 09:35 PM

hi - yes everything is set correctly i believe - first message should be called at 5 and then lockout message at 10 - i made different messages just to be sure i was not doing something stupid

i never see the first message and can post 10 posts - i am then locked out

all settings are set to yes apart from database setting

its a board i am setting up - i got another admin to check as a guest and he reported the same - he only saw the lock out message

EDIT

hang on - i may be lying - i had entered the variable but have done a fair bit of over writing and it may have got deleted - i will report back

EDIT 2 - my apologies - i had deleted the line that was needed - i had never tested it when i first installed it so had never seen the message

it works fine - thanks again

Ted S 01-28-2009 11:52 PM

Perfect.

troppodel 01-31-2009 06:46 AM

hi friend nice mod
can you update your mod and add the possibility to limited other usergroups and for specified forum?

thanks

Ted S 01-31-2009 03:30 PM

Neither of those functions is on my current to do list but you could easily modify the code yourself to add them until such time as I do a major upgrade.

troppodel 02-02-2009 11:09 AM

ok thanks please let me know when you update your mod and add these features
Ivan

Ted S 02-02-2009 03:15 PM

Quote:

Originally Posted by troppodel (Post 1731764)
ok thanks please let me know when you update your mod and add these features
Ivan

There is no plans for a major upgrade at this time. I expect to do a feature overhaul mid to late year depending on interest.

titodj 02-03-2009 03:50 PM

I've used this mod for a long time, and it works perfect.
But now I would like to be able to tell the users either to get registered or to come back in XX time.. but I cant figure out what is the current cookie expiration time?

Ted S 02-03-2009 04:02 PM

The system uses a default vbulletin cookie and honestly I'm not sure how long it lasts. If you want to check the cookie's expiration just view the site as a guest and open the cookie through your browser. Sorry I can't be of more help.

titodj 02-03-2009 04:09 PM

Woow, that helped, I was able to find the cookie from the website, but it was set to expire a year from today.
Could you point me as of how ti find that VB default cookie to see if the expiration can be modified?
Thanks...

Ted S 02-03-2009 04:34 PM

That's a simple enough task.
Inside the xml file for this plugin find the line:
Code:

vbsetcookie('userlgv', $lgv);
Change as follows:
Code:

vbsetcookie('userlgv', $lgv, time()+86400*5);
5 is the number of days and can be changed as you see fit.

I didn't test this so I suggest you manually check that the cookie worked right.

titodj 02-03-2009 04:39 PM

Thank you VERY much.. I will try and post the results.

Ted S 02-03-2009 04:58 PM

Please do as I'll be using your experience to make a little update so this is easier for others in the future.

mindhunter77 02-13-2009 09:38 PM

I love this man, thank you!

mariocaz 04-19-2009 04:12 AM

Hi Ted,

After update your awesome mod, I am receiving this error by email, please help me friend.

Code:

Database error in vBulletin 3.7.6:

Invalid SQL:

                        SELECT id,views
                        FROM vblgv AS lgv
                        WHERE lgv.ipaddress = '75.107.208.5';

MySQL Error  : Table 'allreef_inicio.vblgv' doesn't exist
Error Number  : 1146
Request Date  : Sunday, April 19th 2009 @ 12:41:49 AM
Error Date    : Sunday, April 19th 2009 @ 12:41:49 AM
Script        : http://www.all-reefs.com/inicio/showthread.php?t=6157
Referrer      : http://www.reefcentral.com/forums/showthread.php?s=&threadid=1622230
IP Address    : 75.107.208.5
Username      : No Registrado
Classname    : vB_Database
MySQL Version :

Thank you in advance!!

Ted S 04-19-2009 04:50 AM

Looks like the table requested isn't using your prefix properly. You'll need to remove the addon and manually create the table.

mariocaz 04-19-2009 05:01 AM

Mmmm sorry!!

But how could I do that dear Ted ?

mariocaz 04-19-2009 05:04 AM

So only to confirm...

I have to remove the mod, right ?? then install it again the mod and then manually creat the table ????

Is not an easy way to remove the actual table that is not working because the prefix and then add the other one with the correct prefix ??? to don´t uninstall the mod.

If yes only tell me the instruction to remove the actual SQL table and then to add the correct one (I will put the correct prefix).

Thanx!!

Ted S 04-19-2009 05:29 AM

The table you should have is prefix_lgv where prefix_ is your forum's prefix.

mariocaz 04-19-2009 05:34 AM

Ok but could you tell me Ted the SQL instructions ?? one exactly to manually remove the table that your mod installed and is not working for me and the other one to manually add the correct table. My prefix is this one "vb" without the "_", exaplame: vbaccess

Ted S 04-19-2009 02:23 PM

The install script will create the table. Just be sure the mysql user in vb has access and run it after uninstalling.

zorton 04-19-2009 02:42 PM

Great plugin!

Just one question. How can I change the box color that surrounds the text?

I would like to use a different color (like the Sitepoint Sponsors box @ forum index) but don't know how to do it.

Thanks

mariocaz 04-19-2009 03:11 PM

Mmmm ok I will uninstall it and add the table manually, could you help me giving me the SQL instruction to add the table in MyphpAdmin ?? my prefix is "vb" without the _ only is vb

So the correct table of your forum have to be vblgv I think so.

mariocaz 04-19-2009 03:15 PM

Arrggg so sorry if I am stupid, Maybe something easy is that I can give you access to my forum to fix all this quickly, just tell me ok.

Or tell me exactly waht I have to do and I will do it, but I don?t know SQL instructions :( , so you have to give me the exactly SQL instructions to do this.

Ted S 04-19-2009 11:54 PM

Quote:

Originally Posted by mariocaz (Post 1794464)
Arrggg so sorry if I am stupid, Maybe something easy is that I can give you access to my forum to fix all this quickly, just tell me ok.

Or tell me exactly waht I have to do and I will do it, but I don?t know SQL instructions :( , so you have to give me the exactly SQL instructions to do this.


Before I can help with your SQL queries I need to know if any tables with the name lgv exit in your database.

Ted S 04-20-2009 12:06 AM

Quote:

Originally Posted by zorton (Post 1794444)
Great plugin!

Just one question. How can I change the box color that surrounds the text?

I would like to use a different color (like the Sitepoint Sponsors box @ forum index) but don't know how to do it.

Thanks

The stop message is run through a template which you can modify. Just search your styles and change as desired.

mariocaz 04-20-2009 02:56 AM

Hi Ted,

No I don´t have any table with the name lgv in my DB.

So that is the problem, the mod didn´t install(create) the table in my DB, right ?

Ted S 04-20-2009 03:07 AM

That's correct. The installer was unable to create the table.

If you comment out the line $db->reporterror = 0; by adding a // before it and reinstall you will be told what the error is.

Alternatively you can opt not to use the database logging tool and all these issues with not be a factor.

mariocaz 04-20-2009 03:14 AM

Hi again Ted,

Tell me exactly what I have to do, I have to edit the product file ?? and then reinstall it ??

Is not more easy add the table manually ??

mariocaz 04-20-2009 03:17 AM

Or no problem tell me where and what I have to do and I will do it to see the problem and to have your mod working like a charm.

mariocaz 04-20-2009 03:49 AM

Ted,

I checked the prodict file, and the part that you told me to add a // alrady have it in the file that I downloaded here, check it:

Code:

                                // check if mod is already installed
                               
                                $db->reporterror = 0;
                                $lgvtbl = $db->query_first("SELECT COUNT(id) as lgv FROM ". TABLE_PREFIX ." lgv");
                               
                                if (!$lgvtbl['cnt']){
                                       
                                        // create the table                                                                               
                                        $db->query_write("CREATE TABLE ". TABLE_PREFIX ." lgv (
                                                  id smallint(5) unsigned NOT NULL auto_increment,
                                                  ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
                                                        firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
                                                        views INT(4) NOT NULL DEFAULT '0',
                                                        lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
                                                  PRIMARY KEY (id),
                                                  KEY indexs (ipaddress,views,lastactivity)
                                                ) TYPE=MyISAM
                                        ");
                                       
                                        // insert the first record
                                        $db->query_write("
                                                INSERT INTO " . TABLE_PREFIX . "lgv SET
                                                ipaddress =  '123.456.789.012',
                                                firstaccess  = ". TIMENOW .",
                                                views = 1,
                                                lastactivity = ". TIMENOW ."
                                        ");
                                                                       
                                        echo "<font size=\"1\">Added mySQL Tables</font><br /><br />";
                                       
                                } else {                                       
                                        echo "mySQL table already exists.";                                       
                                }

But maybe I am wrong, just tell me.

Ted S 04-20-2009 04:11 AM

That is not an error.

mariocaz 04-20-2009 03:22 PM

What error? this one?
Code:

Database error in vBulletin 3.7.6:

Invalid SQL:

                        SELECT id,views
                        FROM vblgv AS lgv
                        WHERE lgv.ipaddress = '75.107.208.5';

MySQL Error  : Table 'allreef_inicio.vblgv' doesn't exist
Error Number  : 1146
Request Date  : Sunday, April 19th 2009 @ 12:41:49 AM
Error Date    : Sunday, April 19th 2009 @ 12:41:49 AM
Script        : http://www.all-reefs.com/inicio/showthread.php?t=6157
Referrer      : http://www.reefcentral.com/forums/showthread.php?s=&threadid=1622230
IP Address    : 75.107.208.5
Username      : No Registrado
Classname    : vB_Database
MySQL Version :

Also did you check the product file of your Mod that already have the // that you told me to put ?
Code:

If you comment out the line $db->reporterror = 0; by adding a // before it and reinstall you will be told what the error is.
I don?t have the table lgv, check it here:

http://img178.imageshack.us/img178/4...ltables.th.jpg

Thanx Ted!!


All times are GMT. The time now is 01:09 AM.

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.01537 seconds
  • Memory Usage 1,833KB
  • 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
  • (6)bbcode_code_printable
  • (6)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