Delete Null Clan

[Lolled]

Hello guy,
I have this script by Wizkid

<?php
//Written by Wizkid
//Copyright 2008 - 2009

//Let us connect the databases.
//Yeah yeah, ODBC this time.
$host = "HOST\SQLEXPRESS"; //The host.
$user = "sa"; //The username.
$pass = "*****"; //The password. I hope it's unique for you.
$dbname = "NameDB"; //The dbname. Most likely GunzDB.

$connect = odbc_connect("Driver={SQL Server};Server={$host}; Database={$dbname}", $user, $pass) or die("Can't connect the MSSQL server.");

//The num_rows() function for ODBC since the default one always returns -1.
function num_rows(&$rid) {

//We can try it at least, right?
$num= odbc_num_rows($rid);
if ($num >= 0) {
return $num;
}

if (!odbc_fetch_row($rid, 1)) {
odbc_fetch_row($rid, 0);
return 0;
}

if (!odbc_fetch_row($rid, 2)) {
odbc_fetch_row($rid, 0);
return 1;
}

$lo= 2;
$hi= 8192000;

while ($lo < ($hi - 1)) {
$mid= (int)(($hi + $lo) / 2);
if (odbc_fetch_row($rid, $mid)) {
$lo= $mid;
} else {
$hi= $mid;
}
}
$num= $lo;
odbc_fetch_row($rid, 0);
return $num;
}

//Query time.
$query = odbc_exec($connect,"SELECT CID FROM Character WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
    $cid = odbc_result($query, 1);
    
    odbc_exec($connect,"DELETE FROM CharacterItem WHERE CID = '" . $cid . "'");
    odbc_exec($connect,"DELETE FROM Character WHERE CID = '" . $cid . "'");
    
    echo "Removed the character with CID " . $cid . ". <br />";
}

echo $count . " characters have been totally removed out of the database.";
?>

This server to remove the strings of char that have created as "null".

Now to me the same script that would do the same thing but for the clan.

Thanks for any replies.

[MentaL]

[Lolled]

upp........

[Lifeles5]

If you have it then whats the problem?

[stealhtfire]

If you have it then whats the problem?

if you look propperly you will see he has the script for deleting chars
he is asking for a script just alike to delete clans

[wtfhacker]

CID to CLID, Character to Clan, and others can be ClanHonourRanking or delete..

[alfredao]

DELETE FROM Clan WHERE Name = ''
DELETE FROM ClanMember WHERE CLID NOT IN (SELECT CLID FROM Clan)

[Lolled]

Thanks guys, but I did not understand some things.
You could not rewrite the script for clans?

[Lolled]

Upp....please.

[stealhtfire]

i believe its bump not upp...please lol
anyways
if u make the changes provided, in the script you provided
its a new script for clans

so there is no need to re-write it

[alfredao]

change this

//Query time.
$query = odbc_exec($connect,"SELECT CID FROM Character WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
    $cid = odbc_result($query, 1);
    
    odbc_exec($connect,"DELETE FROM CharacterItem WHERE CID = '" . $cid . "'");
    odbc_exec($connect,"DELETE FROM Character WHERE CID = '" . $cid . "'");
    
    echo "Removed the character with CID " . $cid . ". <br />";
} 

to this

//Query time.
$query = odbc_exec($connect,"SELECT CLID FROM Clan WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
    $cid = odbc_result($query, 1);
    
    odbc_exec($connect,"DELETE FROM Clanmember WHERE CLID = '" . $cid . "'");
    odbc_exec($connect,"DELETE FROM Clan WHERE CLID = '" . $cid . "'");
    
    echo "Removed the clan with CLID " . $cid . ". <br />";
} 

[Lolled]

change this

//Query time.
$query = odbc_exec($connect,"SELECT CID FROM Character WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
    $cid = odbc_result($query, 1);
    
    odbc_exec($connect,"DELETE FROM CharacterItem WHERE CID = '" . $cid . "'");
    odbc_exec($connect,"DELETE FROM Character WHERE CID = '" . $cid . "'");
    
    echo "Removed the character with CID " . $cid . ". <br />";
} 

to this

//Query time.
$query = odbc_exec($connect,"SELECT CLID FROM Clan WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
    $cid = odbc_result($query, 1);
    
    odbc_exec($connect,"DELETE FROM Clanmember WHERE CLID = '" . $cid . "'");
    odbc_exec($connect,"DELETE FROM Clan WHERE CLID = '" . $cid . "'");
    
    echo "Removed the clan with CLID " . $cid . ". <br />";
} 

Thanks very much Alfredao,but don't work <_<.
Any idea?

[Lolled]

Bump....

[Linear88]

I think alfredao forgot to change cid to clid.

@Lolled: Change this is in the original character script:

//Query time.
$query = odbc_exec($connect,"SELECT CLID FROM Clan WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
    $cid = odbc_result($query, 1);
    
    odbc_exec($connect,"DELETE FROM Clanmember WHERE CLID = '" . $clid . "'");
    odbc_exec($connect,"DELETE FROM Clan WHERE CLID = '" . $clid . "'");
    
    echo "Removed the clan with CLID " . $clid . ". <br />";
}

It's alfredao's change with a mistake edited.

You can assign a variable with any name.

Your snippet broke the function of the entire script.

*added.

[gatsu]

You can assign a variable with any name.

Your snippet broke the function of the entire script.

*added.

It's same with $clid.
Don't work!

[daniel131605]

omg lol! this took a lot of trail and error but i finally got it to work :)! This works 100% here you go:

<?php
//Written by Wizkid Edited by daniel131605
//Copyright 2008 - 2009

//Let us connect the databases.
//Yeah yeah, ODBC this time.
$host = "host"; //The host.
$user = "sa"; //The username.
$pass = "******"; //The password. I hope it's unique for you.
$dbname = "GunzDB"; //The dbname. Most likely GunzDB.

$connect = odbc_connect("Driver={SQL Server};Server={$host}; Database={$dbname}", $user, $pass) or die("Can't connect the MSSQL server.");

//The num_rows() function for ODBC since the default one always returns -1.
function num_rows(&$rid) {

//We can try it at least, right?
$num= odbc_num_rows($rid);
if ($num >= 0) {
return $num;
}

if (!odbc_fetch_row($rid, 1)) {
odbc_fetch_row($rid, 0);
return 0;
}

if (!odbc_fetch_row($rid, 2)) {
odbc_fetch_row($rid, 0);
return 1;
}

$lo= 2;
$hi= 8192000;

while ($lo < ($hi - 1)) {
$mid= (int)(($hi + $lo) / 2);
if (odbc_fetch_row($rid, $mid)) {
$lo= $mid;
} else {
$hi= $mid;
}
}
$num= $lo;
odbc_fetch_row($rid, 0);
return $num;
}

//Query time.
$query = odbc_exec($connect,"SELECT CLID FROM Clan WHERE Name = ''");
$count = num_rows($query);

while(odbc_fetch_row($query))
{
$clid = odbc_result($query, 1);

odbc_exec($connect,"DELETE FROM Clanmember WHERE CLID = '" . $clid . "'");
odbc_exec($connect,"DELETE FROM Clan WHERE CLID = '" . $clid . "'");


echo "Removed the clan with CLID " . $clid . ". <br />";
}

echo $count . " clans have been totally removed out of the database.";
?>

---------- Post added at 07:37 PM ---------- Previous post was at 06:00 PM ----------

/bump, thank me please for fixing the code

[Lolled]

It's same:

[daniel131605]

go into your database and click on the clan names you want to get rid of and hit space then enter so the name is blank then go to the next one, its very easy... if i knew what the *null* term was i would tell you, but if you figure out what it is just replace

SELECT CLID FROM Clan WHERE Name = 'null/null code'");

[ploke012]

you need to get serial key for photoshp for this

---------- Post added at 02:45 PM ---------- Previous post was at 02:39 PM ----------

fake code above , super fake

[daniel131605]

you need to get serial key for photoshp for this

---------- Post added at 02:45 PM ---------- Previous post was at 02:39 PM ----------

fake code above , super fake

fail? this isn't about photoshop xD