[RELASE]Our Players System

[IGotPower]

Hello epvp !

Our Members System Is Here !

our_members.lua

PHP Code:

quest our_members begin
        state start begin
                when 20468.chat."Write On Out Web" with game.get_event_flag(""..pc.get_name().."yazdi") == 0 begin
                say_title("Our Players")
                say("")
                say("Hello "..pc.get_name()..", do you want to write something out web page ?")
                say("But be carreful. You have got one Luck !")
                local a = select("Yes I want", "Never mind")
                if a == 1 then
                say ( "Message:" )
                a = input ( )
                chat("Saved !")
                yazdi() 
                mysql_query("insert into account.oyun values ('"..pc.get_account_id().."','"..pc.get_name().."','"..pc.get_level().."','"..a.."') ")
                elseif a == 2 then
                say_title("Gezgin:")
                say("")
                say("This is your prefer. Im always here.")
            end
        end
    end
end 


questlib.lua

PHP Code:

function yazdi() 
    game . set_event_flag ( ""..pc.get_name().."yazdi" , 1 ) 
end 


our_members.php

PHP Code:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<div id="highscore" class="box clearfix">
    <h2 class="item"><img class="headicon" alt="" src="img/alpha.gif" />Our Players</h2>
        <div class="time-table-container">
<table class="time-table hide">
<caption>
<h3 class="highscore-headline"><span>Our Players and their letters</span></h3>
</caption>
                <colgroup><col /><col /><col /><col /><col /></colgroup>
                <tr>
                <th>Character Name</th>
                <th>Level</th>
                <th>Letter</th>
                </tr>
  <?PHP
  
    if(isset($_POST['submit']) AND $_POST['submit']=="Ara") 
    {
      $sqlCmd = "SELECT adi,leveli,aciklamasi FROM account.oyun";
    }
    else 
    {
      $sqlCmd = "SELECT adi,leveli,aciklamasi FROM account.oyun";
    }
    
    $sqlQry = mysql_query($sqlCmd,$sqlServ);
    $x=0;
    while($getAccs=mysql_fetch_object($sqlQry)) 
    {
      if(($x%2)==0) 
      { 
        $zF="tdunkel"; 
      }
      else 
      { 
        $zF="thell"; 
      }
      
      if($getAccs->status=='OK') { $accZustand="#026113"; }
      elseif($getAccs->status=='BLOCK') { $accZustand="#AA0319"; }
      
      echo"<tr>
      <td class=\"tip $zF\" title=\"Adı : $getAccs->adi\">".$getAccs->adi."</td>\n
      <td class=\"tip $zF\" >".$getAccs->leveli."</td>\n
      <td class=\"tip $zF\" title=\"Adı : $getAccs->aciklamasi\">".$getAccs->aciklamasi."</td>\n
      </tr>\n";
      $x++;
    }
  ?>
</table>
</div>
    <div class="inner-block-footer"></div>
    <div id="pager">    </div>
    <div class="resourceBlock">    </div>
    <div class="footer"></div></div>

account/site.sql

PHP Code:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `oyun`
-- ----------------------------
DROP TABLE IF EXISTS `oyun`;
CREATE TABLE `oyun` (
  `id` varchar(50) NOT NULL,
  `adi` varchar(50) NOT NULL,
  `leveli` varchar(50) NOT NULL,
  `aciklamasi` varchar(255) character set utf8 collate utf8_turkish_ci NOT NULL,
  PRIMARY KEY  (`adi`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oyun
-- ---------------------------- 


Sorry for my bad english...

[SKINMARKETPLACE]

Looks cool,
thank you!

[IGotPower]

You're welcome. If you like it i thank you

[MrLibya]

Nice System,


But I Think You Can Use It For 1 Time,
What About This

PHP Code:

quest our_members begin
        state start begin
                when 20468.chat."Write On Out Web" with game.get_event_flag(""..pc.get_name().."yazdi") == 0 begin
                say_title("Our Players")
                say("")
                say("Hello "..pc.get_name()..", do you want to write something out web page ?")
                say("But be carreful. You have got one Luck !")
                local a = select("Yes I want", "Never mind")
                if a == 1 then
                say ( "Message:" )
                a = input ( )
                chat("Saved !")
                yazdi() 
                wait()
                say_title("Our Players")
                say(" You Can Write Agien After 24H ")
                say(" Good Luck ")
                timer("next_write", 86400)
                mysql_query("insert into account.oyun values ('"..pc.get_account_id().."','"..pc.get_name().."','"..pc.get_level().."','"..a.."') ")
                elseif a == 2 then
                say_title("Gezgin:")
                say("")
                say("This is your prefer. Im always here.")
            end
        end
            when next_write.timer begin 
            game . set_event_flag ( ""..pc.get_name().."yazdi" , 0 )
        end 
    end
end 


[IGotPower]

Yes it is better than my quest thank you MrLibya

[.Inya]

Just read the shout_log and output it in the homepage^^

DasKuchen did one of these Plugins for the Shock-Industries CMS

[.Boa Hancock]

Very nice
Thanks ^^