Initial D World - Discussion Board / Forums
   
Welcome Guest ( Log In | Register )Resend Validation Email

DJ Panel ( Server Stats )   Song History   Initial D World Chat Room (Discord)   Broadband Stream
RADIO BROADCAST » streaming at 96kbps with 5 unique listeners, playing m.o.v.e - Free ZION

       

 

Views: 4,108  ·  Replies: 19 
> IDW Lottery, Y u no online?!
Saint
  Posted: Apr 25 2013, 06:58 AM


The 6th Blameless Shift
**********

Group: Advanced Members
Posts: 2,720
Member No.: 2,067
Joined: Jun 21st 2004
Location: The Other Side





user posted image

https://idforums.net/index.php?act=lottery

Never once played that in nein years of my stay in IDW. Would be nice to play even just once. sad.gif
Tessou
Posted: Apr 25 2013, 09:20 AM


More NEGATIVE than a black hole
Group Icon

Group: ADMINISTRATOR
Posts: 19,345
Member No.: 12,263
Joined: Sep 12th 2005
Location: Update Profile





We could set one up, but we'd have to make DPs actually worth something in order to make it worthwhile. Right now the item store is all you can spend them on, and everything in there is relatively inexpensive. The lottery would only mean your virtual bank account gets bigger... to spend on basically nothing of value.
Proud Contributor of IDW Forums and the Music Section Revival Project
Saint
  Posted: Apr 25 2013, 10:05 AM


The 6th Blameless Shift
**********

Group: Advanced Members
Posts: 2,720
Member No.: 2,067
Joined: Jun 21st 2004
Location: The Other Side





The DPs don't really matter. Just curious on how it plays. :3

I'm still DP poor though... ( ._.) Would be nice to play once anyway.
Tessou
Posted: Apr 25 2013, 10:18 AM


More NEGATIVE than a black hole
Group Icon

Group: ADMINISTRATOR
Posts: 19,345
Member No.: 12,263
Joined: Sep 12th 2005
Location: Update Profile





Let me drum something up later today and we'll see.

I'm curious about this as well, as I've never seen it operate either.
Proud Contributor of IDW Forums and the Music Section Revival Project
Rudy
Posted: Apr 25 2013, 01:45 PM


Unregistered












(THIS POST WAS REMOVED BY REQUEST)
Tessou
Posted: Apr 25 2013, 06:27 PM


More NEGATIVE than a black hole
Group Icon

Group: ADMINISTRATOR
Posts: 19,345
Member No.: 12,263
Joined: Sep 12th 2005
Location: Update Profile





So far I'm getting a ton of SQL errors when I attempt to create a lottery. I can describe what it would be like if it worked, though.

The actual lottery "game" is set up much like a Powerball drawing. An admin sets the parameters, such as how many numbers are to be drawn and how high each number can be.

Example: I set it so that the drawing is for five numbers, with the highest number possible being 9. Members could thus enter five numbers, none of which can be higher than 9...

# # # # #

Now, we could set it so that you can win via getting the exact numbers that the system drums up, and a separate prize if you manage to get the right numbers, albeit not in the exact sequence.

So, if you drew 1 2 3 4 5, and the winning numbers were 5 4 3 2 1, you'd win the second prize.

We can set the prizes as well. The typical jackpot is an amount of DPs that we set when creating the lotto. We can also make it so that winners get a bonus prize, which would be an item from the IPB Store.

For those geeks that want the error code, here it is.

CODE
mySQL query error: INSERT INTO ibf_lottery_lotterys & #40;i_id,lotteryname,lotterydesc,status,balls,tickectprice,prize,itemprize,corre
ct_balls,sell_tickets,max_tickets,min_posts,start_time,run_for,continue,max_numb
er,sell_back,type) VALUES (NULL,'Tessou's Sexy Test Lotto','You might win, or not. I don't even know, but try anyway!','open','5','10','1=1000000,2=10000','1=12,2=0',NULL,'50','5','0','1366942898','172800','1','9','1','exact')

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 'continue,max_number,sell_back,type) VALUES (NULL,'Tessou's Sexy Test Lotto',' at line 1
mySQL error code:
Date: Thursday 25th 2013f April 2013 07:21:38 PM
Proud Contributor of IDW Forums and the Music Section Revival Project
Nomake Wan
Posted: Apr 25 2013, 07:27 PM


ShiMACHaze
**********

Group: Advanced Members
Posts: 19,542
Member No.: 5,394
Joined: Feb 5th 2005
Location: Drydock





Disclaimer: I don't know anything about SQL, literally. I know nothing. I've never read anything about it nor have I ever worked with an SQL database.

That all being said, as someone coming from AVISynth scripts and their errors, it looks like it just doesn't like the name. And I don't mean the parser thinks your name for the Lotto is stupid but it seems as if you put the name into the wrong part of the field. At least from the error here:

VALUES (NULL,'Tessou's Sexy Test Lotto',' at line 1

It seems that the values it specifically lists are incorrect for the type of code you're writing, i.e. they're in the wrong place.
Proud Contributor of IDW Forums and the Music Section Revival Project
bROCKoLEE
Posted: Apr 25 2013, 09:08 PM


whut?
**********

Group: Advanced Members
Posts: 4,416
Member No.: 6,453
Joined: Apr 2nd 2005
Location: ¯\(º_o)/¯





The more I lose the lottery, the better my chances of winning right?!

This post has been edited by bROCKoLEE on Apr 25 2013, 09:08 PM
razorsuKe
Posted: Apr 25 2013, 09:39 PM


IDW Goldmember
**********

Group: Advanced Members
Posts: 1,406
Member No.: 12,243
Joined: Sep 12th 2005
Location: Calgary Canada





You don't play the lottery, the lottery plays you.
Proud Contributor of Initial D World Forums
Kurara
Posted: Apr 26 2013, 12:10 AM


IDW Expert Member
******

Group: Members
Posts: 104
Member No.: 41,171
Joined: Apr 18th 2013
Location: Australia





Ohhhhh~~~ An item that changes other peoples title.. yummy.
Saint
  Posted: Apr 26 2013, 12:23 AM


The 6th Blameless Shift
**********

Group: Advanced Members
Posts: 2,720
Member No.: 2,067
Joined: Jun 21st 2004
Location: The Other Side





Yay, now it's starting to roll~ happy.gif
Kurara
Posted: Apr 26 2013, 02:09 AM


IDW Expert Member
******

Group: Members
Posts: 104
Member No.: 41,171
Joined: Apr 18th 2013
Location: Australia





Oh my~ The poker on this site is very lenient. //won 800DPs already
Perry
Posted: Apr 26 2013, 02:19 AM


Like an eagle!
Group Icon

Group: SITE OWNER
Posts: 8,014
Member No.: 1
Joined: Sep 15th 2002
Location: San Leandro, California





QUOTE (Kurara @ 10 minutes, 1 seconds ago)
Oh my~ The poker on this site is very lenient. //won 800DPs already

Maybe you just had the luck... I just played a few Max Bet rounds. Dumped 200,000 in it.. facepalm.gif You can tell from how big the BONUS is now. Every time you bet, the house match 1/20 of it and put it into the BONUS regardless that you win or not.
Proud Contributor of the Music Section Revival Project
Kurara
Posted: Apr 26 2013, 03:10 AM


IDW Expert Member
******

Group: Members
Posts: 104
Member No.: 41,171
Joined: Apr 18th 2013
Location: Australia





I won bonus ohmy.gif !!
@ 28 points TT^TT

This post has been edited by Kurara on Apr 26 2013, 03:28 AM
Tessou
Posted: Apr 26 2013, 10:23 AM


More NEGATIVE than a black hole
Group Icon

Group: ADMINISTRATOR
Posts: 19,345
Member No.: 12,263
Joined: Sep 12th 2005
Location: Update Profile





QUOTE (Nomake Wan @ Yesterday, 11:27 PM)
Disclaimer: I don't know anything about SQL, literally. I know nothing. I've never read anything about it nor have I ever worked with an SQL database.

That all being said, as someone coming from AVISynth scripts and their errors, it looks like it just doesn't like the name. And I don't mean the parser thinks your name for the Lotto is stupid but it seems as if you put the name into the wrong part of the field. At least from the error here:

VALUES (NULL,'Tessou's Sexy Test Lotto',' at line 1

It seems that the values it specifically lists are incorrect for the type of code you're writing, i.e. they're in the wrong place.

The system just doesn't like the prospect of having sexy time with me, I guess. tongue.gif
Proud Contributor of IDW Forums and the Music Section Revival Project
Perry
Posted: Apr 26 2013, 11:34 AM


Like an eagle!
Group Icon

Group: SITE OWNER
Posts: 8,014
Member No.: 1
Joined: Sep 15th 2002
Location: San Leandro, California





I think the Lottery was disabled long time ago for a reason... I took a look at it but it looks like Greek since it's been so long... The Lottery worked when it was still PHP 4.x and MySQL 3.x. That means the syntax error can be from anywhere in its code. wacko.gif
Proud Contributor of the Music Section Revival Project
Tessou
Posted: Apr 26 2013, 11:48 AM


More NEGATIVE than a black hole
Group Icon

Group: ADMINISTRATOR
Posts: 19,345
Member No.: 12,263
Joined: Sep 12th 2005
Location: Update Profile





I think it's honestly a waste of time. We can create a lotto outside of the IBStore, and award DPs from the admin panel without a problem, considering admins can just create DPs and hand them out. biggrin.gif
Proud Contributor of IDW Forums and the Music Section Revival Project
kyonpalm
Posted: Apr 26 2013, 01:11 PM


Professional Amateur
Group Icon

Group: ADMINISTRATOR
Posts: 10,568
Member No.: 30,882
Joined: Oct 16th 2008
Location: Laniakea





QUOTE (Tessou @ 1 hour, 22 minutes ago)
award DPs from the admin panel without a problem, considering admins can just create DPs and hand them out. biggrin.gif

Just like in real life!
Proud Contributor of the Music Section Revival Project
Tessou
Posted: Apr 26 2013, 01:18 PM


More NEGATIVE than a black hole
Group Icon

Group: ADMINISTRATOR
Posts: 19,345
Member No.: 12,263
Joined: Sep 12th 2005
Location: Update Profile





Like the government can just print/mint more money? That'd be a bad thing... if DPs were worth anything in the first place. On IDW, hyperinflation is nonexistent. biggrin.gif
Proud Contributor of IDW Forums and the Music Section Revival Project
Saint
  Posted: Apr 26 2013, 07:17 PM


The 6th Blameless Shift
**********

Group: Advanced Members
Posts: 2,720
Member No.: 2,067
Joined: Jun 21st 2004
Location: The Other Side





user posted image

How nice if someone sends me a billion DPs... rolleyes.gif Lol.