vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Honorable Member (https://vborg.vbsupport.ru/showthread.php?t=106188)

Zachariah 01-25-2006 05:20 PM

Quote:

Originally Posted by TamCaVBoy3
installed it on a fresh 3.5.3 and cobaltx skin

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT dateline, userid FROM customavatar WHERE userid =;

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 '' at line 1
Error Number : 1064

This is on install or your homepage after install ?
- If on thr home page and not an Install error in the XML.

1)
Admincp => vBulletin Options => Honorable Member
Change setting
Save

2)
Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member
[RUN NOW]

The value is set to change your member every 23 hours.
If this is ok.



Notes:
- You can change the time in the Scheduled Task Manager
Admincp => vBulletin Options => Honorable Member

- You can change the settings a member is selected in
Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member

TamCaVBoy3 01-25-2006 05:31 PM

Quote:

Originally Posted by Zachariah
This is on install or your homepage after install ?
- If on thr home page and not an Install error in the XML.

1)
Admincp => vBulletin Options => Honorable Member
Change setting
Save

2)
Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member
[RUN NOW]

The value is set to change your member every 23 hours.
If this is ok.



Notes:
- You can change the time in the Scheduled Task Manager
Admincp => vBulletin Options => Honorable Member

- You can change the settings a member is selected in
Admincp => Scheduled Tasks => Scheduled Task Manager => Honorable Member

this is after i installed it and set up schedule and everything, then i go to the forum and i recieved that error

Zachariah 01-25-2006 05:33 PM

Quote:

Originally Posted by TamCaVBoy3
this is after i installed it and set up schedule and everything, then i go to the forum and i recieved that error

Step 2
[RUN NOW]

The script has not run yet. (in 23 hours it will run)
The 1st member has not been selected so there is no data for the hack to show.

TamCaVBoy3 01-25-2006 05:49 PM

awsome !, thank you !

TamCaVBoy3 01-25-2006 08:46 PM

nevermind, when i run the schedule, error:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT user.*,userfield.*,usertextfield.*

FROM unique_user AS user
LEFT JOIN unique_honorable AS honorable on (user.userid=honorable.userid)
LEFT JOIN unique_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN unique_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

WHERE
usergroupid NOT in ()
AND user.posts >= 0
AND lastactivity >= 1138229114
AND lastpost >= 1138229114
AND user.reputation >= 0
AND (honorable.dateline < 1137624314 OR honorable.dateline IS NULL)
ORDER BY RAND()
LIMIT 1;

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 ')
AND user.posts >= 0
AND lastactivity >= 1138229114

Error Number : 1064

Zachariah 01-25-2006 09:36 PM

I ran into a few problems if values were blank in AdminCP vs. "0" Zerro.
- Things i'll iron out. "if blank skip ect ..."

Take a look if you would and give me a heads up.

Zachariah 01-25-2006 10:50 PM

Install readme were fixed up a bit.
- No code changes yet.

sinaluna 01-25-2006 11:07 PM

Thank you for the help Zachariah! :)

TamCaVBoy3 01-25-2006 11:34 PM

thanks for the fix, i will try to install for the last time :)

Boofo 01-25-2006 11:43 PM

Can this be made to not use the avatar as a setting?


All times are GMT. The time now is 11:17 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.01123 seconds
  • Memory Usage 1,740KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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