Looking for spin4plus sQL

[kiLLeR-eyEd_14]

If anyone have it..Pls share it here..Sql table for spin4plus..

[friend]

i have that sql but script not workin ... it make winner least card holders

[kei_ki7]

..may i see the sqL ??

[kiLLeR-eyEd_14]

i have that sql but script not workin ... it make winner least card holders

can u post d sql then if i made it working, i'll share the script for u?

[kazzin]

i can make sql table of spin4plus post script or PM me

[capofret]

i can make sql table of spin4plus post script or PM me

Why PM when u can post it here if u can do it? Anyway, the script is in the jack en poy chatroom script i posted here in the forum. Thanks if u can help us.

[kazzin]

4 spin

-- --------------------------------------------------------

--
-- 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ibwf_spincard`
--

in ibwf_user
add this rows

`spinned` varchar(10) NOT NULL,
`spintime` varchar(5) NOT NULL,

[capofret]

4 spin

-- --------------------------------------------------------

--
-- 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ibwf_spincard`
--

in ibwf_user
add this rows

`spinned` varchar(10) NOT NULL,
`spintime` varchar(5) NOT NULL,

this sql is not enough so it wont work.

[riderz]

Its not working

[metulj]

anyone care to post this script ?

[riderz]

 $spin=$_GET["spin"];

i think this is the whole spin code

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 "Chat system:&#187;*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))<10)
    {
        echo "You need 10 plusses in order to spin the wheel!";
    }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 "Chat system:&#187;*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&amp;who=1&amp;sid=$sid\">system</a>&#187;There are $cinfo[0] remaining cards. Click <a href=\"chat.php?spin=1&amp;sid=$sid&amp;rid=$rid\">spin the wheel</a> spin cards to get some 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 more info for game info.<br/>";
     }else{

$rema = $pmfl - $tm;
echo "Chat system:&#187;*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 $winner2 cards, 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&amp;who=$unreadinbox[0]&amp;sid=$sid&amp;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&amp;rid=$rid&amp;rpw=$rpw&amp;cancel=1&amp;idn=$unreadinbox[2]&amp;time=$time\">Cancel</a>";
   }

[kazzin]

ok il post valid sql as soon as possible n i make new code also password via email

[kazzin]

also add this row in ibwf_user hope it will work

`cards` text collate utf8_unicode_ci NOT NULL

[kabooms]

`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',

[kei_ki7]

Why PM when u can post it here if u can do it? Anyway, the script is in the jack en poy chatroom script i posted here in the forum. Thanks if u can help us.

..only script for chatroom ?? how about the core ??