[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 =).

Quote:

---

Originally Posted by ianvalls90

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)

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 =).

---

Do you really think diablo will waste hours to make customs templates? learn basics of css / html & go go :D

about quest module, just install it & will works (nothing to do here).

you can take all modules from the old update web and convert it to the new one very easy..for ranking displays..
something else need to be done or modified? .. I will update it with 1 more template soon

it's look like another web named MyMuWeb. Same structure, same sessions.

Anyway, keep going diablo, I am still waiting your season iv files.

Quote:

---

Originally Posted by 4FUNer

Do you really think diablo will waste hours to make customs templates? learn basics of css / html & go go :D

about quest module, just install it & will works (nothing to do here).

---

You know, actually, this module took me a lot of time to find it, and couldn't find it for it's own, so i had to download a full site based on avantasia, and started ripping parts from it, & still cant get it to work 100%...but i'm getting closer....

If you have a link to the module by it's own, it would be lovely...as im ripping an entire site apart, and it's a big mess XD.
As for the templates, i dont do css, just dont like doing it....But it's basically a matter of time, maybe he has some, wich i really don't right now.

All links i found to the module by its own, are from old megaupload (rip).....if someone has one, throw it to me =)..
And btw, by adapting it i meant to make it look like a part of the site, besides working 100%,...so it doesnt look like a stolen module :|.

Quote:

---

Originally Posted by ianvalls90

You know, actually, this module took me a lot of time to find it, and couldn't find it for it's own, so i had to download a full site based on avantasia, and started ripping parts from it, & still cant get it to work 100%...but i'm getting closer....

If you have a link to the module by it's own, it would be lovely...as im ripping an entire site apart, and it's a big mess XD.
As for the templates, i dont do css, just dont like doing it....But it's basically a matter of time, maybe he has some, wich i really don't right now.

All links i found to the module by its own, are from old megaupload (rip).....if someone has one, throw it to me =)..
And btw, by adapting it i meant to make it look like a part of the site, besides working 100%,...so it doesnt look like a stolen module :|.

---

yea found my old website on hdd, with that webquests of s-y, i'll upload 1 sec

Download
Download WebQuests.rar from Sendspace.com - send big files the easy way

ReadMu.txt for install :]

Credits ofc only Savoy (S-y)


(f... repackers!) :D

how can i change all these infomations?? thanks!

http://oi40.tinypic.com/9huwj7.jpg

modules/news.php <--- Here

@4FUNer: Thanks for the module by its own, im working on it now, and trying to fix a "staff" module i had to make it fit too :).


EDIT:
@4FUNer: do you have any idea on WHY this module keeps telling me "account/password is incorrect" even when trying to login with correct server-accounts, and/or with module admin account? :| it's a big pain...wont let me login -.-".

Edit2:
still cant login to this module, and cant find error anywhere :|.
Uploaded it into "localhost/quest" and when accessing it, everything seems OK, except for the fact that i cant login -.-".....SQL is OK (changed it and got an error, so it's configured fine).....i have no clue :|

____________
As for the Staff module i added, its working 100% now, with Ranks for admins (mod, gm, adm, founder), and country-listing too. (added country drop-down box upon registration, with correct database saving, and over 200 countries added 1 by 1 by me.)
As soon as i Get quests module working (still trying to find the error -.-") i'll share.

market and shop dont work :@

I have a request you can register to send mail to activate acc