Printable View
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...
:thumbup:
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?Quote:
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.Quote:
Originally Posted by Ravin
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.:thumbup:Quote:
Originally Posted by Military
I was recruiting on the account but it wasn't mine.Quote:
Originally Posted by Ravin
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
I got that scripts already but I´m looking forQuote:
Originally Posted by razi46
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..Quote:
Originally Posted by BGRick
Just edit the scripts.:thumbdown:Quote:
Originally Posted by BGRick
I tried but failed xDQuote:
Originally Posted by Military
It has something to do with like, Num or rows.