vb.org Archive
Page 23 of 23 « First 132122 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Vbjokes (https://vborg.vbsupport.ru/showthread.php?t=98248)

micheal332001 07-31-2006 10:40 AM
Quote:
Originally Posted by xspazx
Still messed up severely.

http://chewonthat.net/vbjokes.php?do=category

i give up
I will be sorting this out today and will post the templat edit here.
Sorry for the wait been very buzy.

Hiro 07-31-2006 11:41 AM
Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

MySQL Error : Unknown column 'numberOfVotes' in 'order clause'
Error Number : 1054
Date : Monday, July 31st 2006 @ 10:40:05 PM
Script : http://www.eliteneo.com/vbjokes.php
Referrer : http://www.eliteneo.com/
IP Address :
Username : Zeus
Classname : vb_database

Hiro 07-31-2006 11:55 PM
and yes I did install the xml file.

micheal332001 08-01-2006 04:40 AM
Quote:
Originally Posted by Hiro
Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

MySQL Error : Unknown column 'numberOfVotes' in 'order clause'
Error Number : 1054
Date : Monday, July 31st 2006 @ 10:40:05 PM
Script : http://www.eliteneo.com/vbjokes.php
Referrer : http://www.eliteneo.com/
IP Address :
Username : Zeus
Classname : vb_database
But did you do this last bit


6. login to admincp
goto Plugin System
Manage Products
[Add/Import Product]
EITHER upload the XML file from your computer product-vbjokes-upgrade.xml
Allow Overwrite yes
click inport


As this installs them sql tables

micheal332001 08-06-2006 09:55 AM
I have not tested this on 3.6 yet but i will be very soon.
If there is a problem with this being installed on 3.6 i will make a fix and re-release it in the 3.6 add-ons

Harley D 10-16-2006 10:44 PM
Quote:
Originally Posted by micheal332001
But did you do this last bit


6. login to admincp
goto Plugin System
Manage Products
[Add/Import Product]
EITHER upload the XML file from your computer product-vbjokes-upgrade.xml
Allow Overwrite yes
click inport


As this installs them sql tables
Same database error as the others on 3.54, and yes l followed the instructions to the "T" I would really like to use this, if you need to see my database, Admincp or anything else to figure out the problem, Please just let me know.

010081 01-04-2007 07:17 AM
Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;

MySQL Error : Unknown column 'rating' in 'order clause'
Error Number : 1054
Date : Thursday, January 4th 2007 @ 03:15:30 AM
Script : http://www.zonemedicine.com/forums/vbjokes.php
Username : zonemedicine
Classname : vb_database

anything i can do to getr working for 6.4

Logician 02-09-2007 08:03 AM
I'm sorry to say this but you should really stop using $_GET variables in the SQL queries without properly cleaning them up in the code.

In your code, you have many SQL queries like:

PHP Code:
SELECT COUNT(*) AS jokecatid
  FROM " . TABLE_PREFIX . "vbjokes_jokes AS vbjokes_jokes
  WHERE jokecatid='{$_GET['cid']}' 
and I couldn't find any attempt to clean incoming $_GET['cid'] variable before directly using in the query. I don't want to mention the problems it can cause, I'm sure you are well aware of them.

Please clean them up like
PHP Code:
 $vbulletin->input->clean_array_gpc('r', array(
  'cid' =>TYPE_INT
 ));
 
SELECT COUNT(*) AS jokecatid
  FROM " . TABLE_PREFIX . "vbjokes_jokes AS vbjokes_jokes
  WHERE jokecatid='$vbulletin->GPC[cid]' 
in your to avoid some unwanted results..

Marco van Herwaarden 02-09-2007 08:21 AM
Serious vulnerabilities have been found in this modification. Files have been removed according to Official Policy: When Security Vulnerabilities in Hacks are Found

Author will be contacted to address these vulnerabilities. Thread closed until update provided by author.


All times are GMT. The time now is 01:29 AM.
Page 23 of 23 « First 132122 23
Show 40 post(s) from this thread on one page

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.01325 seconds
  • Memory Usage 1,745KB
  • 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
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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