Mysql Stone + Php

• Memba Co.
• 2009-05-24 14:06
• 0 Yorumlar
• 1396 Görüntüleme

//#############################\\

		  //	  Memba Co. Uo Shard  	   \\ 

		 //___________23.05.2009____________\\

		 \\    -*-   VERSION=0.56b   -*-    //

 	          \\   Scripted by Owner Memba Co. // 

 		   \\#############################//





/////////////////////   Açıklama //////////////////////

//// Önce i_mysql_stone cıkart sabit bir yere ekle

//// Sonra Tabloyu Olusturmek için .tablo_yap komutunu gir

//// Mysql Stone'ye info Cek uid'ini 04433 nun yerine yaz

//// Ve Son olarak sphere_serv_triggers scriptinin icinde server_exit in altına src.verikapa yazman yetrli...

/////////////////////////////////////////////////////////



VERSION=0.56b









[itemdef i_mysql_stone]

defname i_mysql

id=i_grave_stone

name Mysql Baglanti Tasi

type t_script



on=@create

attr=attr_move_never

timer 60

return 1



on=@timer

src.veriyolla

timer 60

return 1



on=@click

message @07a1 Guncellemeye : <timer>

message @07ed <name>

return 1



on=@dclick

src.sysmessage @07ed Mysql Aktarimi 60snde bir Yollanir

src.sysmessage @07ed Manuel Calismaz ...

return 1



[function veriyolla]

db.connect

db.execute "update sphere_bilgi set uptimesaats='<eval (<serv.timeup> / 3600)>', uptimedakika='<eval ((<serv.timeup> / 60) - ((<serv.timeup> / 3600) * 60))>', page='<uid.<var.pg_box>.rescount>', items='<serv.items>',  clients='<serv.clients>',  accounts='<serv.accounts>',  guilds='<serv.guilds>',  chars='<serv.chars> ' where uid='04433'"



return 1



[function verikapa]  // (sphere_serv_triggers) server exit e ekle

db.connect

db.execute "update sphere_bilgi set uptimesaats='0', uptimedakika='0', page='0', items='0',  clients='0',  accounts='0',  guilds='0',  chars='0' where uid='04433'"



return 1





[function tablo_yap] // ilk Komutu Gir....

db.execute "create table if not exists sphere_bilgi (uid text,uptimesaats int,uptimedakika int,page int,items int,clients int,accounts int,guilds int,chars int);"



db.execute "insert into `sphere_bilgi` (`uid`,`uptimesaats`,`uptimedakika`,`page`,`items`,`clients`,`accounts`,`guilds`,`chars`) values ('<uid>','<eval (<serv.timeup> / 3600)>','<eval ((<serv.timeup> / 60) - ((<serv.timeup> / 3600) * 60))>','<uid.<var.pg_box>.rescount>','<serv.items>','<serv.clients>','<serv.accounts>','<serv.guilds>','<serv.chars>');"





src.sms Simdilik OK :D

return 1





Php Kodu



<?php

$con = mysql_connect("localhost","kullanici_adi","sifre");

if (!$con)

{

die('Bağlantı sağlanamadı: ' . mysql_error());

}



mysql_select_db("db_adi", $con);



$result = mysql_query("SELECT * FROM sphere_bilgi");



echo "<table border='1'>

<tr>



<th>Saat</th>

<th>Dakika</th>

<th>Bekleyen Page</th>

<th>Item</th>

<th>Online</th>

<th>Accounts</th>

<th>Guild</th>

<th>Chars</th>



</tr>"; while($row = mysql_fetch_array($result))

{

echo "<tr>";

echo "<td>" . $row['uptimesaats'] . "</td>";

echo "<td>" . $row['uptimedakika'] . "</td>";

echo "<td>" . $row['page'] . "</td>";

echo "<td>" . $row['items'] . "</td>";

echo "<td>" . $row['clients'] . "</td>";

echo "<td>" . $row['accounts'] . "</td>";

echo "<td>" . $row['guilds'] . "</td>";

echo "<td>" . $row['chars'] . "</td>";

echo "</tr>";

}

echo "</table>"; mysql_close($con);



echo "<b>NOT:</b> Bilgiler 1 dk Ara Ile Güncellenmektedir...";



?>

Mysql Stone + Php

• Dosya Boyutu: 0KB
• İndirildi: 325

Değerlendirmeler

Total votes: 0