Sphere - Mysql Komutları

Nemesis[Berk]
Nemesis[Berk]
2007-07-25 14:32
2 Yorumlar
6128 Görüntüleme

Sunucumuzda ilk basta sphere.iniden mysqlle ilgili bilgilerimizi girmemiz gereklidir.

Sphere.ini

MYSQL=1 // Database baglantisi için bu gereklidir..
MySqlHost=localhost // Mysql databaseninzin bulundugu sunucu ( kendi makinanızdaysa localhost )
MySqlUser=root // Mysqlde yetkiye sahip bir username ( en yetkilisi root orjinal olarak gelir )
MySqlPassword=password // Mysql sifreniz kurarken girmenizi ister
MySqlDatabase=sphere // Mysql databasenizde sphere icin kullanmak istediginiz tablo

Sunucu acıldıgında databaseye baglanıp baglanmadıgınızı sorgulamalıyız ilk başda..

f_onserver_start

default olarak sphere_serv_triggers.scp de bulunması gerekir


[function f_onserver_start]
if (<DB.CONNECTED>)
serv.log MySQL Bilgisi : MySQL baglantisi sorunsuz tamamlandi..
else
serv.log MySQL Bilgisi . MySQL baglantisinda sorun , baglanti tamamlanamadi..
endif

Kullanabileceginiz komutlar..

CONNECTED = Eger database baglantisi tamamlandiysa degeri 1 olur baglanmadiysa 0

kullanımı :

db.connected

örnek :


[function f_onserver_start]
if (<DB.CONNECTED>)
serv.log MySQL Bilgisi : MySQL baglantisi sorunsuz tamamlandi..
else
serv.log MySQL Bilgisi . MySQL baglantisinda sorun , baglanti tamamlanamadi..
endif

ROW.NUMROWS - Son yaptıgınız sorgudaki satır sorgusu yapar

kullanımı = db.row.satirsayisi

örnek =
db.query Select * from clients where accname = '<account.name>'
if if strmatch('<db.row.3> ','<src.account.name>')
src.sysmessage @39 olumlu
endif

ROW.NUMCOLS - Son yaptıgınız sorgudaki kolon sorgusu yapar

kullanımı = db.col.kolonsayisi

örnek =
db.query Select * from clients where accname = '<account.name>'
if if strmatch('<db.col.3> ','<src.account.name>')
src.sysmessage @39 olumlu
endif

CLOSE - Mysql baglantisini keser

db.close

CONNECT - Mysql baglantisi yapar ( sphere.ini bilgisi girilmis olmalidir.)

db.connect

EXECUTE - Mysqle gonderilecek komutları calistirir

DB.EXECUTE "INSERT INTO karakterler (isim) VALUES('<src.name>')"

QUERY - Mysqle gonderilecek sorguları calıstırır

DB.QUERY select * from karakterler where isim='<src.name>'

ornek bir sistem :

Test sayfasi >

https://www.carnageuo.net/wordpress/online.php

[function dbloginyaz]
if (<kills> > 7)
tag.align Player Killer
else
tag.align Mavi
endif
DB.QUERY Select * from clients where accname = '<account.name>'
if !(strmatch('<account.name>','<db.row.3>'))
if (<guild> = 0)
DB.EXECUTE "INSERT INTO clients (name, kills, fame, accname, region, karma, durum, guild) VALUES('<name>',<kills>,<fame>,'<account.name>','<region.name>','<karma>','<tag.align>','Yok')"
return 1
else
DB.EXECUTE "INSERT INTO clients (name, kills, fame, accname, region, karma, durum, guild) VALUES('<name>',<kills>,<fame>,'<account.name>','<region.name>','<karma>','<tag.align>','<guild.name>')"
return 1
endif
else
if (<guild> = 0)
db.execute "Update clients set name = '<name>', kills = '<kills>', fame = '<fame>', region='<region.name>', karma='<karma>', durum='<tag.align>', guild='Yok' where accname = '<account.name>'"
return 1
else
db.execute "Update clients set name = '<name>', kills = '<kills>', fame = '<fame>', region='<region.name>', karma='<karma>', durum='<tag.align>', guild='<guild.name>' where accname = '<account.name>'"
endif

Php kodu :

<?
$host = "localhost";
$kullaniciadi = "kullaniciadiniz";
$sifre = "sifreniz";
$db = "sphere";
$tablo = "clients";
$baglanti = @mysql_connect($host,$kullaniciadi,$sifre) or die("Server a baglanilamadi");
mysql_select_db($db, $baglanti);
$adim1 = mysql_query("select * from clients");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="https://www.w3.org/1999/xhtml" dir="ltr" lang="tr-TR">

<head profile="https://gmpg.org/xfn/11">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>  </title>

<meta name="generator" content="WordPress 2.2.1" /> <!-- leave this for stats -->

<link rel="stylesheet" href="https://80.93.221.8/wordpress/wp-content/themes/web126/style.css" type="text/css" media="screen" />
<link rel="alternate" type="application/rss+xml" title=" RSS Feed" href="https://80.93.221.8/wordpress/?feed=rss2" />
<link rel="pingback" href="https://80.93.221.8/wordpress/xmlrpc.php" />

<style type="text/css" media="screen">

#page { background: url("https://80.93.221.8/wordpress/wp-content/themes/web126/images/kubrickbg.jpg") repeat-y top; border: none; }


</style>

<link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://80.93.221.8/wordpress/xmlrpc.php?rsd" />
</head>
<body>
<div id="page">
<div id="header">
<div id="headerimg">
<h1 align="left"><a href="https://80.93.221.8/wordpress/"></a></h1>
<div class="description"></div>
</div>
</div>

<hr align="left" />
<div id="content" class="narrowcolumn">
  <div class="post" id="post-10">
    <div align="left"> <a href="index.php" class="caps">Ana sayfaya git </a>
      <table width="726" border="0" align="center" cellpadding="1" cellspacing="2">
            <tr>
              <td width="181" nowrap="NOWRAP"><div align="center"> - Oyuncu Ismi - </div></td>
      <td width="107" nowrap="NOWRAP"><div align="center"> - Kill - </div></td>
      <td width="107" nowrap="NOWRAP"><div align="center"> - Fame - </div></td>
      <td width="109" nowrap="NOWRAP"><div align="center"> - Karma -</div></td>
      <td width="200" nowrap="NOWRAP"><div align="center">  - Bulundugu Alan - </div></td>
      <td width="116" nowrap="NOWRAP"><div align="center"> - Guild - </div></td>
      <td width="85" nowrap="NOWRAP"><div align="center"> - Durum - </div></td>
    </tr>
  <? while ($bilgi = mysql_fetch_array($adim1)) { ?>
            <tr>
              <td bgcolor="<? echo $renk ?>" nowrap="NOWRAP"><div align="left">  * <? echo $bilgi['name']."<br>"; ?></div></td>
      <td nowrap="NOWRAP" bgcolor="<? echo $renk ?>" ><div align="center"><? echo $bilgi['kills']."<br>"; ?></div></td>
      <td nowrap="NOWRAP" bgcolor="<? echo $renk ?>" ><div align="center"><? echo $bilgi['fame']; ?></div></td>
      <td nowrap="NOWRAP" bgcolor="<? echo $renk ?>" ><div align="center"><? echo $bilgi['karma']; ?></div></td>
      <td bgcolor="<? echo $renk ?>"  nowrap="NOWRAP"><div align="center"><? echo $bilgi['region']; ?></div></td>
      <td nowrap="NOWRAP" bgcolor="<? echo $renk ?>" ><div align="center"><? echo $bilgi['guild']; ?></div></td>
      <td bgcolor="<? echo $renk ?>"  nowrap="NOWRAP"><div align="center"><? echo $bilgi['durum']; ?></div></td>
    </tr>
<?
}
mysql_close($baglanti);
?>
            </table>
        </div>
  </div>
<div class="navigation">
  <div class="alignright"></div>
  </div>
</div>

    <hr align="left" />

<div id="footer">
    <div align="left">
      <!-- If you'd like to support WordPress, having the "powered by" link someone on your blog is the best way, it's our only promotion or advertising. -->
    </div>
    <p align="left">Php kodlari Pelevet tarafindan ve Sphere kodlari Nemesis tarafindan kodlanmistir <br />
<a href="https://80.93.221.8/wordpress/?feed=rss2"></a><!-- 21 queries. 0.449 seconds. -->
</p>
</div>
<div align="left">
  <!-- We request you retain the full web design copyright notice below including the link to https://www.sarkis-webdesign.com . This not only gives respect to the large amount of time given freely by the designer but also helps build interest, traffic and use of template. If you cannot (for good reason) retain the full design copyright we request you at least leave in place the link Web design by Sarkis, with linked to https://www.sarkis-webdesign.com . Good luck! Web designer Sarkis -->
</div>
<div class="design_copyright">
  <div align="left"><a href="https://www.sarkis-webdesign.com/" title="Web Design" class="web_design">Web design</a> by <a href="https://www.sarkis-webdesign.com/" title="Website Designer" class="website_designer">website designer</a> Sarkis. <a href="https://freelancewebmarket.com/" title="Web Designers" class="web_designers">Web designers</a> by FreelanceWebmarket.
  </div>
</div>
</div>

</body>

</html>

Mysql sorgusu :


CREATE TABLE `clients` (
  `name` varchar(255) default NULL,
  `kills` varchar(255) default NULL,
  `fame` varchar(255) default NULL,
  `accname` varchar(255) default NULL,
  `region` varchar(255) default NULL,
  `karma` varchar(255) default NULL,
  `guild` varchar(255) default NULL,
  `durum` varchar(255) default NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Yada :

Bir tablo oluşturun tablo adı clients olsun ( database adı sphere ) ve içerisinde
name [ varchar(255) ]
kills [ varchar(255) ]
fame [ varchar(255) ]
accname [ varchar(255) ]
region [ varchar(255) ]
karma [ varchar(255) ]
guild [ varchar(255) ]
durum [ varchar(255) ]

adlı kolonlar oluşturuyoruz yapmamız gereken son birşey kaldı

on=@login //altına
src.serv.allclients dbloginyaz
src.dbloginyaz

on=@logout //altına
src.dbloginsil

[function f_onserver_timer]
serv.allclients dbloginyaz

Bu sistem Nemesis ve Pelevet tarafindan ortaklasa yazilmistir kullanim hakki COPYRIGHT yazısı silinmedikce ucretsizdir..

Değerlendirmeler

(7)

5 Kullanıcı

Tymaron 2010-10-30 03:44

Sphere.ini dosyandan bağlantılarını kontrol edersen sorun olmaz. Mysql bağlantısını yanlış yapmışsınız. Baya geç bi yardım oldu ama başka takılan arkadaşlaraynı hatayı alırsa yardımcı olmuş oluruz :)