[Release] MFS Team Web 0.6

I hope this one will help you:

Code:

---

@NAME VARCHAR(10)
AS

delete from ExtChrData where [name]=@NAME
delete from guildmember where [name]=@NAME
delete from guildmember where ([g_name] in (select g_name from guild where [g_master]=@NAME))
delete from guild where [g_master]=@NAME
delete from Life where [character]=@NAME
delete from lifelog where ChrName=@NAME
delete from optiondata where [name]=@NAME
delete from event_info where charactername=@NAME

UPDATE ACCOUNTCHARACTER SET GAMEID1=NULL WHERE GAMEID1=@NAME
UPDATE ACCOUNTCHARACTER SET GAMEID2=NULL WHERE GAMEID2=@NAME
UPDATE ACCOUNTCHARACTER SET GAMEID3=NULL WHERE GAMEID3=@NAME
UPDATE ACCOUNTCHARACTER SET GAMEID4=NULL WHERE GAMEID4=@NAME
UPDATE ACCOUNTCHARACTER SET GAMEID5=NULL WHERE GAMEID5=@NAME
UPDATE ACCOUNTCHARACTER SET GAMEIDC=NULL WHERE GAMEIDC=@NAME

delete [Character] where [name]=@NAME
GO

---

yes it will be helpful, but i will not be online some days when i get back will fix it ;)

test delete hero now

Code:

---

// Delete Hero
function delete_hero()
{
$character = secure($_POST['character']);
$account = secure($_SESSION['user']);


check_inject();


$queryonline = mssql_query("select * from MEMB_STAT where memb___id='$account' and connectstat='1'");
$onlinecheck = mssql_num_rows($queryonline);


$queryaccount = mssql_query("Select * from MEMB_INFO where memb___id='$account'");
$accountcheck = mssql_num_rows($queryaccount);


$querychar = mssql_query("Select * from Character where Name='$character'");
$charcheck = mssql_num_rows($querychar);


$querychar2 = mssql_query("Select * from AccountCharacter where GAMEIDC='$character' and GameID1='$character' and GameID2='$character' GameID3='$character' and GameID4='$character' and GameID5='$character' and Summoner='$character'");
$acccheck = mssql_num_rows($querychar2);


if($onlinecheck  >= 1) { echo"<font color='red'>Account $account is online!Please LogOff First!</font><br>"; $error=1;}


if($error != 1) {


echo"<font color='green'>Character $character has been succesfully deleted.</font><br>";


$a = mssql_query("DELETE From Character where Name='$character'");
$a = mssql_query("DELETE from ExtChrData where name='$character'");
$a = mssql_query("DELETE from guildmember where name='$character'");
$a = mssql_query("DELETE from guildmember where (g_name in (select g_name from guild where g_master='$character'))");
$a = mssql_query("DELETE from guild where g_master='$character'");
$a = mssql_query("DELETE from Life where character='$character'");
$a = mssql_query("DELETE from lifelog where ChrName='$character'");
$a = mssql_query("DELETE from optiondata where name='$character'");
$a = mssql_query("DELETE from event_info where charactername='$character'");


$a = mssql_query("UPDATE AccountCharacter SET GAMEID1=NULL WHERE GAMEID1='$character'");
$a = mssql_query("UPDATE AccountCharacter SET GAMEID2=NULL WHERE GAMEID2='$character'");
$a = mssql_query("UPDATE AccountCharacter SET GAMEID3=NULL WHERE GAMEID3='$character'");
$a = mssql_query("UPDATE AccountCharacter SET GAMEID4=NULL WHERE GAMEID4='$character'");
$a = mssql_query("UPDATE AccountCharacter SET GAMEID5=NULL WHERE GAMEID5='$character'");
$a = mssql_query("UPDATE AccountCharacter SET GAMEIDC=NULL WHERE GAMEIDC='$character'");
}
}

---

delete hero works!

do we have any other templates available?

i havent work on other templates, everyone can put any index template what they like it's easy config simply website :)
something else to be fixed?

It would be very nice, if someone could make or post here template of this website! :)

other ideas for modules?

make a few templates diablo, so we can use different versions of same web :D.

Hmmm i think that it will be a good idea to add different connections to web like in Mucore. So users can choose MSSQL connection or ODBC connection. Some of users having problems with connection to DB, or slow page load, using SQL2008R2, thats why an alternative type of connection will be good strike.

Quote:

---

Originally Posted by diablo71

other ideas for modules?

---

Master Skill Tree Reset Module . Thanks

Quote:

---

Originally Posted by _Shotlandetsa_

Hmmm i think that it will be a good idea to add different connections to web like in Mucore. So users can choose MSSQL connection or ODBC connection. Some of users having problems with connection to DB, or slow page load, using SQL2008R2, thats why an alternative type of connection will be good strike.

---

I think i was one of the few here that had issues regarding this website and SQL 2008.....easy as hell to solve....
just placed my "PC-NAME" as "$host" and it's connected....

Basically, People using SQL 2k8R2, have connection problems, or cant connect, because they dont really know what's host name....as it's probably not "localhost" as in sql 2000....
Slow Pages Load, comes for the same reason, if you specify a CORRECT host name, BUT, not the original one set on SQL...data will have to "resolve the host", making loading a longer process.
I had this issue as well, but fixed when changed hostname to "PC-NAME."
ODBC connections are more vulnerable, and cant be used if not in local pc.....so it's kinda useless nowadays. (at least for me :P)

Quote:

---

Originally Posted by orionet

Master Skill Tree Reset Module . Thanks

---

This would be nice too =).


Module Idea:
On-Site "Quests" with In-Game rewards....i know I've seen it somewhere....would be nice to have it =).
And again, i would love some new templates :P.

give me tables for Master Skill Tree, what read what edits and update and what you want, 3rd Quest evolve or clear something?

Whether to support S6EP3

it already support 3rd evolve classes, if something is missing write me here or in skype i will fix it fast

Quote:

---

Originally Posted by kksky

Whether to support S6EP3

---

It's already supported by this web....you would only need to add some modules, and it's no obligation....only if you want to :P
(gens module, Castle Siege module, and i've got one or two more, like "bot pet rank" :P [if using tt this can be used, slow servers only...no botpets on fast servers])
I'll post my remake of those modules to fit this site later (no time now, sorry)

Quote:

---

Originally Posted by diablo71

it already support 3rd evolve classes, if something is missing write me here or in skype i will fix it fast

---

Nothing missing...you could just add a few more templates (insisting will make me triumph :P)
Oh and i found the online-quests module, and im working to adapt it....when i get it working, i will share all my add-ons =).