vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   uCash & uShop (https://vborg.vbsupport.ru/forumdisplay.php?f=100)
-   -   uCash & uShop old support and thank you thread (https://vborg.vbsupport.ru/showthread.php?t=73736)

GinjiAmano 09-29-2004 06:58 AM

Ok, after i've edited my post counts via the admin cp i've got 2 errors:
when i try to see the forum home page i get this error:


Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.ca lendarid,calendar.title, displayorder
FROM vb3_calendar AS calendar
LEFT JOIN vb3_calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(, 6))
ORDER BY displayorder ASC

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 ' 6))
ORDER BY displayorder ASC' at line 3
mysql error number: 1064
Date: Tuesday 28th of September 2004 11:36:12 AM
Script: http://www.otakuforum.it/index.php?
Referer:
Username: Dante
IP Address: XX.XXX.XXX.XXX

Also, when i try to edit my profile from the admin cp the page loads only for half, leaving this message:

Quote:
Database error in vBulletin 3.0.3:
Invalid SQL: SELECT title, usergroupid FROM vb3_usergroup WHERE usergroupid IN (6,,,,,,,,,) ORDER BY title
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 ',,,,,,,) ORDER BY title' at line 1
mysql error number: 1064
Date: Tuesday 28th of September 2004 11:51:19 AM
Script: http://www.otakuforum.it/admincp/us...o=edit&userid=1
Referer:
Username: Dante
IP Address: XX.XXX.XXX.XXX

Please, help.

Zachery 09-29-2004 11:25 AM

I replied to you at geekydesigns forums.

GinjiAmano 09-29-2004 12:06 PM

Thank you very much Zachery.

newb1e_ 09-29-2004 08:42 PM

Hi all, my first post here

I'm not sure if the orignal author is still supporting the hack but I have a problem, when I first installed the mod, it had a few problems so I ended up reinstalling/uploading it from scratch,

second time I installed it I don't have so many options, this is how it looked the first time round

http://img81.exs.cx/img81/8937/ushop.jpg

(The arrow was added to help explain the system on my forum so you can ignore it)

Now no one can see any options below the Actions tab, also the 4 links that do show are dead links, they lead nowhere, maybe I missed something, they worked the first time, I don't really want to start from scratch again since I'm pretty sure everything else is perfect and don't want to riisk running into anymore errors, what .php should I look into to find the problem?

If anyone could help I would be eternally greatful, sorry if I was a bit vague or if this problem has been explained a few pages back

thank you

Zachery 09-29-2004 09:03 PM

We are still supporting this mod, and we always have been. when you go to ushop.php do you get any errors? did you make sure you did all your file edits? :)

venomx 09-29-2004 09:04 PM

Do you have it in the regular navbar or did you use the navbar2 hack? I had it in the bavbar2 and it wouldnt work. It has to be in the regular navbar.

newb1e_ 09-29-2004 09:16 PM

Quote:

We are still supporting this mod, and we always have been. when you go to ushop.php do you get any errors? did you make sure you did all your file edits?
I'm pretty sure I edited all .php files, normally if I wasn't sure I'd be happy to re-do it all, but seems I solve and pick up a new problem each time round

Quote:

Do you have it in the regular navbar or did you use the navbar2 hack? I had it in the bavbar2 and it wouldnt work. It has to be in the regular navbar.
I must have used the regular navbar since I don't have the navbar 2 hack installed (or any other mods, this is pretty much one of my first)

SnowBot 09-29-2004 09:52 PM

Is there a way to not allow Admins, s/mods and mods not to have there user titles changed? I have just had a very upset Mod ?

JBMoney 09-29-2004 09:56 PM

You know, the issue with the thief action not working has been brought up 4-5 times on this thread, but I don't see anywhere that it's been answered. At a minimum, can you just tell me what I could do to hardcode the rep points to taken off for a successfull thief. Then I can move on...

This is the code section that's not pulling anything up for subtracted rep points.

PHP Code:

$DB_site->query("UPDATE ".TABLE_PREFIX $vboptions['uttpoints_pointtable']." SET ".$vboptions['uttpoints_pointsfield']."=".$vboptions['uttpoints_pointsfield']."+".$_FIELDS['points'].", reputation=reputation-".$action['replosts']." WHERE userid='$bbuserinfo[userid]'"); 

I tried slapping a 0 in there once, but for some reason it created some goofiness.

Zachery 09-29-2004 10:01 PM

Quote:

Originally Posted by SnowBot
Is there a way to not allow Admins, s/mods and mods not to have there user titles changed? I have just had a very upset Mod ?

Hmm i thought we put a check in for this in the latest version?


All times are GMT. The time now is 11:12 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.02385 seconds
  • Memory Usage 1,747KB
  • 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
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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