uCash & uShop old support and thank you thread

/me Installs. I'm the first for the most aniticipated hack!!1

[GinjiAmano]

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]

I replied to you at geekydesigns forums.

[GinjiAmano]

Thank you very much Zachery.

[newb1e_]

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



(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]

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]

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_]

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

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]

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]

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]

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?