Re-add, edit the templates...

Got this error when looking at bet statistics

"Database error in vBulletin 3.0.1:

Invalid SQL: SELECT u.username, (p.+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5
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 '+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid

mysql error number: 1064

Date: Thursday 01st of July 2004 09:12:28 PM
Script: http://www.********.com/forum/vbookie.php?do=stats"

And when I check yes,post a vbookie event with this post .. I get a blank page .. ??

Damn AliceBOT got me again. I gotta remove that hack someday.

Thanks for the help.

Anyway to set it so only certain users (instead of usergroup) can post an event? That is, other than putting that user into a new group and assigning permissions to the group.

Also, is there any way to allow event posting into certain forums only?

I would love it if my moderators could post events but only in the forums that they moderate.

ideas?

Doesn't appear to work on 3.0.1 .. perhaps that should be included in the installation file :disappointed:

Dude. I run this at my site at http://www.dungeonkeepersdomain.com and it is running v3.01. It is working just fine.

Dude .. I and 2 admins from my site have tried the install on 3.0.1 three times and had the same database error's on every installation .. installed arcade / petz with no problems on my main forum .. will not be trying this until the database errors are corrected .. any useful comments anyone .. !?

Useful comments might follow useful problem reports. What, for example, do the database errors say?

As listed above .. !?

Got this error when looking at bet statistics

"Database error in vBulletin 3.0.1:

Invalid SQL: SELECT u.username, (p.+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5
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 '+0) AS cash FROM AS p LEFT JOIN user AS u ON u.userid=p.userid

mysql error number: 1064

Date: Thursday 01st of July 2004 09:12:28 PM
Script: http://www.********.com/forum/vbookie.php?do=stats"

================================================== =======

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT FROM WHERE userid='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 'FROM WHERE userid='1'' at line 1

mysql error number: 1064

And when I check yes,post a vbookie event with this post .. I get a blank page .. ??

That's nothing to do with installation, sorry. Your phrasing in the last post mis-led me.

The problem here is the "(p.+0)" and "FROM AS p". Those should contain the uCash column and table, e.g. "(p.money+0)" and "FROM user AS p" -- $vboptions['uttpoints_pointsfield'] and $vboptions['uttpoints_pointtable']. Check what these are set to in the Admin control panel.

I can't really suggest what might be wrong as I haven't got 3.0.1, but I can't see that there would be any major changes between 3.0.0 and 3.0.1. If you want to give me FTP and Admin access to your forum, I can take a look for you, but it won't be until Sunday evening at the earliest because I'm away at a wedding this weekend.

Installed today on a heavily modded 3.0.1 forum. Works brilliantly, no problems on the install at all. Always a pleasure when the instructions are structured so clearly.

Thanks for an outstanding release! My users are ecstatic, fits right in on a college football (US) forum, even though we're testing it on Williams v. Sharapova.

The only hassle now is two of my users jumped in full bore and bet everything on Maria, before realizing that 500 is all they're getting. Can't decide whether to abandon the event, or let them learn a hard lesson. Lol.

Anyway, thanks again for an outstanding hack. Clicked install. ;)

--edit--
Is there any way (even a mysql query) to reset the system, clear all events, and start everyone from 500?

i haven't even installed it yet, but i clicked install, this is one cool hack.

thanks alot.

sorry one question.

i haven't installed yet, but i am wondering about something.

i wanna use it for football season.

so is each game an entirely separate event, like will they have to bet on each one individually,
or we i be able to set up one page with all the choices and maybe a default amount of points per game ?

because i would rather they have to pick in all games, not just the ones they feel like.

also one other thing, is there anyway to reset totals back to default when we want ?

Anybody have an answer to this?

I have a user ho has this monney :

bmf_bebecub has a total of 18446744073709341541

I don't know how he did it, but he really has that much monney !!!!

tjdrico

You really need to add this things :

Posibility to ban a user from vBooking
Posibility to change vCash that a user has

Nevermind. A moderator of my forum chance some odds from a bet, this gut bet...and...he get that monney :)

!!!!

Assuming you are using "vCash":

[sql]
UPDATE user SET vbookie_cash=500;

DELETE FROM vbookie_news;
DELETE FROM vbookie_bets_placed;
DELETE FROM vbookie_item_options;
DELETE FROM vbookie_items;
DELETE FROM vbookie_groups;
[/sql]

You'll need to add the table prefix if you're using that, of course.

Each event is separate from any other.

You can do the first by moving the user into a restricted usergroup. The second will come with the next release. As vBulletin is moving to 3.0.2 I will probably update my test forum and then get the next release ready to ensure that it retains compatibility with vBulletin.

Installed. I've been playing with this...... this is an awesome hack. :D You got my vote for HOTM.

And that translated into English means .. ? :ermm:

I'd love to get this great hack working on my board .. would the fact that I'm running the petz and arcade hack be causing the problem .. ?

Thank you! That will be a huge help.

It seems that it's still a bug. i don't know. My moderators are confusing me.

About banning from a usergroup. Can't you made something like an option in user admin ? Can bet to user CP - YES , NO ? It is much easy.

If it's an exploit, ask the user for details of how he exploited it, and I can look into plugging the hole.

I'll look into the user restrictions, but if it's as easy as you say please feel free to perform the hack yourself and post the details here so I can incorporate it into the next release.

I had a similar problem, one of my users had betted (found out by the timestamp) while I was uploading functions_vbookie.php upgrading from v1 to 1.1.

i have a user who cannot see the vBookie box at top of vBookie threads.

he is using I.E. 6.0 from comcast

is there a setting, like in usercp, that could be conflicting with this ?
or is it something on his end, pop-up blocker, firewall, etc ?


EDIT ***NVM his forum view style was one i hadn't modified. all good ***

Clicked install .. took some editing but the instructions are acurate and well explained.

Only problem I have is the vbookie icon for new events doesn't show.

Where / which template do I need to edit to correct this.

It looks like you've made the changes, but didn't upload the image to the correct place. You should have 'vbookie_posticon.gif' in images/misc.

:) .. I was just about to edit my post to say that I have placed the 'vbookie_posticon.gif' in images/misc .. your response was to fast .. :)

Sorted .. my skin uses a different path directory for images/misc https://vborg.vbsupport.ru/

Cool. \o/

I've just been notified of a problem on my board that I *think* might be attributed to this great mod...

It appears that you can't add a normal poll when starting a new thread. Adding a vbookie event works no problem but users can't add a poll anymore. The only way to add a poll is to use the thread tools after the thread is posted.

Can anyone else confirm this?

Cheers,

~Regs.

I can't confirm any such problem with my own forum (3.0.0) where my members can still post polls as normal.

It could be that you made a small error in the code modifications - perhaps you replaced a piece of poll code instead of adding something after it.

Vbookie should have an alternative to odds system: 1X2 betting system.

Thanks Tjdrico,

I'll have a look at it over the next couple of weeks, just thought it might be a shot since everything else was working :D

Cheers,

~Regs.

Is there any way that I could reinstall this hack (If possible, the template will do)? Just like what ushop provided, with a reinstall scrip.

Many thanks in advance.. :)

I dont want to think :)

But I can provide what this is missing very easily.

What I need to figure out is an easy way to do all this by cron.

Ok I wanted to seperate my thought - here is exactly in a perfect world what this would do. We get it here, and I will provide the missing half.

1. Everyday evening or morning, exact time a setting, the upcoming baseball games would be posted, automatically, same for basketball, hockey. Every Tuesday for NFL Football and NCAA Football.

For NFL for example, I guess it would have to be multiple threads, but it would autopost one for the over under, one for the money line, and one for the line. It would be really nice to have this be adjustable and keep track of adjustments, but that is probably to far of a leap for now.

When its autoposting the action it obviously sets the close time and all that jazz.

When the game is over and in the books, it autopays.

Would even be real slick to slide in halftime lines and such, but really that would be nothing if we could do the first part.

I can deliver the info (and it would be a delivery, not a five hundred forum slam me every ten seconds in hopes of something new grab). The scores, the lines, obviously the results, etc.