-
skn nmn gmgna kso palpak..toinx..Originally posted by capofret View Post
Leave a 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.Leave a comment:
-
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.Leave a 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 :PLeave a comment:
-
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.Leave a comment:
-
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>";
}Leave a comment:
Leave a comment: