//#############################\\
		  //	  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: 320

Değerlendirmeler

0

Total votes: 0