I'm looking for:
- Accounts Made Script
- Characters Made Script
- Total Banned Accounts Script
- Total Clans Made Script
Hold em simple please, I can't find em at RaGEZONE.
Already searched google and RZ but nothing goods found...
So if you have plz reply with script...
PHP Code:<?php
//Accounts Created
$query = "SELECT COUNT(*) FROM Account";
$result = mssql_query($query);
$row = mssql_fetch_row($result);
echo 'Accounts Created : <font color="#CC0000">'.$row[0].'</font><br />';
//Characters Created
$query1 = "SELECT COUNT(*) FROM Character";
$result1 = mssql_query($query1);
$row1 = mssql_fetch_row($result1);
echo 'Characters Created : <font color="#CC0000">'.$row1[0].'</font><br />';
//Clans Created
$query2 = "SELECT COUNT(*) FROM Clan";
$result2 = mssql_query($query2);
$row2 = mssql_fetch_row($result2);
echo 'Clans Created : <font color="#CC0000">'.$row2[0].'</font><br />';
//Banned Users
$query3 = "SELECT COUNT(*) FROM Account WHERE UGradeID='253'";
$result3 = mssql_query($query3);
while($row3 = mssql_fetch_row($result3)){
echo 'Banned Accounts : <font color="#CC0000">'.$row3[0].'</font><br />';
}
?>
Fatal error on line 4 = $result = mssql_query($query);
Err maybe it have to connect to my MSSQL Server?
Now I got line 11 because I tried:
PHP Code:<?php
$dns="GunzDB";
$user="sa";
$pass="password";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry..."); odbc_exec($connect,"use GunzDB");
?>
<?php
//Accounts Created
$query = "SELECT COUNT(*) FROM Account";
$result = mssql_query($query);
$row = mssql_fetch_row($result);
echo 'Accounts Created : <font color="#CC0000">'.$row[0].'</font><br />';
//Characters Created
$query1 = "SELECT COUNT(*) FROM Character";
$result1 = mssql_query($query1);
$row1 = mssql_fetch_row($result1);
echo 'Characters Created : <font color="#CC0000">'.$row1[0].'</font><br />';
//Clans Created
$query2 = "SELECT COUNT(*) FROM Clan";
$result2 = mssql_query($query2);
$row2 = mssql_fetch_row($result2);
echo 'Clans Created : <font color="#CC0000">'.$row2[0].'</font><br />';
//Banned Users
$query3 = "SELECT COUNT(*) FROM Account WHERE UGradeID='253'";
$result3 = mssql_query($query3);
while($row3 = mssql_fetch_row($result3)){
echo 'Banned Accounts : <font color="#CC0000">'.$row3[0].'</font><br />';
}
?>
Yes it needs mssql connect...
PHP Code://Connect Database
$_MSSQL['Host'] = "\SQLEXPRESS"; //Host
$_MSSQL['User'] = "sa"; //Username
$_MSSQL['Pass'] = "password"; //Password
$_MSSQL['DB'] = "GunzDB"; //Database
$con = mssql_connect($_MSSQL['Host'],$_MSSQL['User'],$_MSSQL['Pass']) or die("Cant Connect!");
mssql_select_db($_MSSQL['DB']) or die("Cant Find Database!");
Look for some ODBC scripts released by iCreamPie.
Lol, that is you. And, didn't Jurien release some scripts las week?Originally Posted by Military
I feel you are suffering from some blindness , I said that isn't me + I gave Rodi the account when he released the scripts.
Look for Threads in Gunz Releases section. Around Pages 5-7.
@Ravin : jur13n released almost exactly the same as iCreamPie.
Sorry dude, cause you were recruiting for SG and I asked and you said that you were Military. Idk so sorry.
I was recruiting on the account but it wasn't mine.Sorry dude, cause you were recruiting for SG and I asked and you said that you were Military. Idk so sorry.
There's only one that Military Released about the ODBC. If i'm not wrong, some Ranking or what.. Unsure.
Well, since you dont know how to use the SEARCH button,
you'll see the bunch of them here : http://forum.ragezone.com/f245/index7.html
Last edited by razi46; 11-12-10 at 02:26 AM.
I got that scripts already but I´m looking for
ACCOUNTS MADE, CLANS MADE, BANS MADE SCRIPTS
Not for that scripts ... learn 2 read?
Such as:
ACcounts Made: 300
Characters Made: 530
Bans Made: 37
Then I'm so sorry can't help you..
Just edit the scripts.
I tried but failed xDJust edit the scripts.
It has something to do with like, Num or rows.
Reply With Quote