mates help me to arrange this spin d wheel script and please fix some error and the missing part also include what part of chat.php file this script to be inserted or pasted.I try this one but my chat.Php page turns into a blank white page.
-
-
if($rid==2)
{
$tries2 = mysql_fetch_array(mysql_query("SELECT cards FROM ibwf_spincard"));
$mama2= $tries2[0]; if($mama2>0)
{
if($spin==2) { $tm = time();
$lastpm = mysql_fetch_array(mysql_query("SELECT MAX (spintime) FROM ibwf_users WHERE id='".$uid."'"));
$pmfl = $lastpm[0]+15; if($pmfl<$tm)
{
}else{
$rema = $pmfl - $tm;
echo "PinoyGsmº"*you can spin cards again after <b>$rema</b> seconds.*<br/>";
}
if(!spinned($uid))
{
$rpgd = mysql_query("SELECT id, no FROM ibwf_getcards ORDER by RAND() LIMIT 1");
while($rpgds=mysql_fetch_array($rpgd))
{
$cards =$rpgds[1];
}
if(getplusses(getuid_sid($sid))<100)
{
echo "You need 100+s in order to spin the gulong!";
}else{
mysql_query("UPDATE ibwf_users SET cards=cards+'$cards' WHERE id='".$uid."'");
mysql_query("UPDATE ibwf_spincard SET cards=cards-'$cards'");
mysql_query("UPDATE ibwf_users SET plusses=plusses-'1' WHERE id='".$uid."'");
mysql_query("UPDATE ibwf_users SET spintime='".time ()."' WHERE id='".$uid."'");
mysql_query("UPDATE ibwf_users SET spinned='1' WHERE id='".$uid."'");
$mycards = mysql_fetch_array(mysql_query("SELECT cards FROM ibwf_users WHERE id='".$uid."'"));
echo "PinoyGsmº"*you got $cards card(s) for that spin wait after 20 sec to spin cards again. You have $ mycards[0] total of cards.*<br/>";
}
}
}else{
$tm = time(); $lastpm = mysql_fetch_array(mysql_query("SELECT MAX (spintime) FROM ibwf_users WHERE id='".$uid."'"));
$pmfl = $lastpm[0]+20; if($pmfl<$tm)
{
mysql_query("UPDATE ibwf_users SET spinned='0' WHERE id='".$uid."'");
$cinfo = mysql_fetch_array(mysql_query("SELECT cards from ibwf_spincard"));
echo "<a href=\"index.php?action=viewuser&who=3&sid =$sid\">Pinoygsm</a>"There are $cinfo[0] remaining cards. Click <a href=\"chat.php?spin=1&sid=$sid&rid=$rid\" >Spin The Gulong</a> to get cards. Each spin will cost 1 plusses, if you got the highest number of cards after the remaining cards goes to zero, you will get the 1000 plusses prize.<br/>";
}else{
$rema = $pmfl - $tm;
echo "PinoyGsmº"*you can spin cards again after <b>$rema</b> seconds.*<br/>";
}
}
}else{
$rpgd = mysql_query("SELECT id, cards FROM ibwf_users ORDER by cards DESC LIMIT 1");
while($rpgds=mysql_fetch_array($rpgd))
{
$winner =$rpgds[0]; $winner2 =$rpgds[1];
}
$unick2 = getnick_uid($winner);
mysql_query("UPDATE ibwf_spincard SET cards='500'");
mysql_query("INSERT INTO ibwf_chat SET chatter='133', timesent='".time()."', msgtext='$unick2 got $winner2cards, and the 1000 plusses prize', perm='".$perm [0]."', rid='".$rid."';");
mysql_query("UPDATE ibwf_users SET plusses=plusses+'1000' WHERE id='".$winner."'");
mysql_query("UPDATE ibwf_users SET cards='0'"); mysql_query("UPDATE ibwf_users SET spintime='0'");
}
}
if($cancel==1)
{
mysql_query("UPDATE ibwf_private SET unread='0' WHERE id='".$idn."'");
}
$unreadinbox=mysql_fetch_array(mysql_query("SELECT byuid, text, id FROM ibwf_private WHERE unread='1' AND touid='".$uid."'"));
$pmtotl=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."'"));
$unrd="(".$unreadinbox[0]."/".$pmtotl[0].")"; if ($unreadinbox[0]>0)
{
$text = parsepm($unreadinbox[1], $sid); $by = getnick_uid($unreadinbox[0]);
echo "<b>$by: </b>$text<br/>";
echo "Reply:<br/>";
echo "<form action=\"chat.php?action=sendpm&who=$unreadinb ox[0]&sid=$sid&rid=$rid\" method=\"post\">";
echo "<input name=\"pmtext\" maxlength=\"500\"/><br/>";
echo "<input type=\"submit\" value=\"Send\"/>";
echo "</form>";
echo "<br/><a href=\"chat.php?sid=$sid&rid=$rid&rpw=$rpw &cancel=1&idn=$unreadinbox [2]&time=$time\">Cancel</a>";
} -
do u have the sql post it hereComment
-
Spin D Wheel Script
i only gathered a sql information and i dont know how to form this sql into a right pattern,heres the sql i got from the forum..
*also add this row in ibwf_user hope it will work
Code:
`cards` text collate utf8_unicode_ci NOT NULL
`spinned` varchar(10) NOT; `spintime` varchar(5) NOT NULL, to chage in `spinned` int(100) NOT NULL NULL default '0', `spintime` int(100) NOT NULL NULL default '0',
-- -------------------------------------------------------- -- -- Table structure for table `ibwf_spincard` -- CREATE TABLE IF NOT EXISTS `ibwf_spincard` ( `cards` text collate utf8_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8COLLATE=utf8_unicode_ci; -- -- Dumping data for table `ibwf_spincard` --
*in ibwf_user
add this rows
Code:
`spinned` varchar(10) NOT NULL, `spintime` varchar(5) NOT NULL,
-- --------------------------------------------------------
--
-- Table structure for table `cards`
--
CREATE TABLE IF NOT EXISTS `cards` (
`id` int(10) NOT NULL auto_increment,
`number` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `number` (`number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cards`
--Last edited by l0rdrayven; 18.07.09, 08:05.Comment
-
@riderz please fix this misc my friend.Comment
-
bro sql for spin
add row in ibwf_chatCode:CREATE TABLE `ibwf_spincard` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `cards` INT(4) NOT NULL DEFAULT'0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 CREATE TABLE ibwf_getcards ( `id` INT(10) NOT NULL AUTO_INCREMENT, `no` INT(4) NOT NULL DEFAULT'0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
`perm` char(1) NOT NULL DEFAULT'0',
hope it will work :PComment
-
Where can i add this script? chat.php? or create a new file?Originally posted by l0rdrayven View PostComment
-
in chat.php ma friend.but i d0nt kn0w if what part of chat.php and im n0t sure if this is the complete script.im still waiting riderz for the updates.Comment
-
Iba tlga ang Filipino hehehe.. Thanks Rayven..Comment
-
search for inet's posts here. he made this script so the sql he gave might work.
i tried it myself but i cant also make it work. maybe need to edit something.LDSWAPWORLD sigpic
site closed.
im busy with other things in life like facebook , send me PM so i can add you
www.pinoySG.com
don't ask for help if you're not even helping yourself!
i am tired of seeing the line "best site", i want to see something NEW and UNIQUE. maybe if i find one, ill go back to my wap life again.
Comment
-
skn nmn gmgna kso palpak..toinx..Originally posted by capofret View Post
My Blog: http://jhommark.blogspot.com
My Facebook: http://www.facebook.com/jhommark
My Official Site: http://www.undergroundweb.tk
My Community Site: http://undergroundwap.xtreemhost.comComment
-
Pano kya dapat gwin d2? Hmm..
my LUCKY 9 nb kayo?Comment
-
Lol then its also not working for uOriginally posted by kiLLeR-eyEd_14 View Postskn nmn gmgna kso palpak..toinx..LDSWAPWORLD sigpic
site closed.
im busy with other things in life like facebook , send me PM so i can add you
www.pinoySG.com
don't ask for help if you're not even helping yourself!
i am tired of seeing the line "best site", i want to see something NEW and UNIQUE. maybe if i find one, ill go back to my wap life again.
Comment
-
cnu kaya mabait na magp0post ng working sql for spin...Comment
-
yah search inet and thanatos post the spin the wheel sql here.Comment
Comment