PsyMuWeb Free 1.0

If you have md5 enabled do not install this because all your password will gone (install will change memb_pwd varbinary(16) in varchar(10). )

Create tables for this website:

Quote:

---

CREATE TABLE [psyweb_server] (
[servername] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[serverip] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[serverport] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[serverxp] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[serverdrop] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[reset_level] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[serververs] [text] COLLATE Korean_Wansung_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [psyweb_website] (
[title] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[forum] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[char_show] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[guild_show] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[md5] [text] COLLATE Korean_Wansung_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [psyweb_news] (
[id] [int] NOT NULL ,
[title] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[content] [text] COLLATE Korean_Wansung_CI_AS NOT NULL ,
[data] [text] COLLATE Korean_Wansung_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [psyweb_downloads] (
[id] [int] NOT NULL ,
[name] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[description] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[link] [text] COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [psyweb_bans] (
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[banon] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[reason] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[bantime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

---

temple 10\10

Please add system of lost pasword <- all users and view passwords < - in his panel of adm u.u y post his release PLEASE!!!!!!!!!!!
i

SORRY FOR MY BAD ENGLISH

Based on denied previous statement I wonder if they will still release updates for this web. Im sharing you some addons I did.

addons:

1. password change
2. pkclear
3. warp to lorencia
4. updated add stat module with the following changes: input for dl class command stat, block negative value, block stat more then 32767, max char input is now 5.
5. display castle lord, after guild ranking.
6. info about castle siege(cs owner, cs schedule (change your actual cs time in csinfo.php) and registered guilds)
7. harcoded votebox (change the vote link inside index.php, search for this phrase: http://yourvotelink.here )
8. effective anti sql inject

Nice, phit666, still there are some errors.

Quote:

---

<script type="text/javascript" src="js/script.js"></script>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/jquery.pstrength-min.1.2.js"></script>

---

There is no script.js, jquery.js and jquery.pstrength-min.1.2.js
Instruction

Quote:

---

new Ajax.Updater('login', 'pages/login2.php', {method: 'post', asynchronous:true, parameters:Form.serialize(document.login)}); esperar_login('login');"

---

must be without esperar_login('login'); in all pages where esperar_login('login'); appear (this cause a fault in js - function esperar_login() isnt defined or maybe was defined in some .js files which are not included :P).
Tested in many browsers, Google Chrome and Safari dont display rankings ok.
Bad ajax implementation:
http://i297.photobucket.com/albums/m...crim/psy-3.jpg

add the visualization date for the news (i mean order day / month / year or month / day / year)

Quote:

---

Originally Posted by phit666

Based on denied previous statement I wonder if they will still release updates for this web. Im sharing you some addons I did.

addons:

1. password change
2. pkclear
3. warp to lorencia
4. updated add stat module with the following changes: input for dl class command stat, block negative value, block stat more then 32767, max char input is now 5.
5. display castle lord, after guild ranking.
6. info about castle siege(cs owner, cs schedule (change your actual cs time in csinfo.php) and registered guilds)
7. harcoded votebox (change the vote link inside index.php, search for this phrase: http://yourvotelink.here )
8. effective anti sql inject

---

Huh , great work phit666 , it's great to see you people work on this website , i guess PsychoJr will be really impressed when he will see this

To have a real order by date news change column id in psyweb_news table:

Quote:

---

Identity=Yes
Identity Seed=1
Identity Increment=1

---

Quote:

---

Originally Posted by aecrimch

To have a real order by date news change column id in psyweb_news table:
Identity=Yes
Identity Seed=1
Identity Increment=1

---

What psycho did (php controlled) is the same effect as putting identity even though its much easier to do the above (sql controlled) code.
The getnews function is fetching with order of 'ID DESC' so its in the right path but to have the real ordering by date then change the date column by type date and change news query filter from ID to DATE.

Code:

---

$id = mssql_num_rows($query)+1;
$data = date("m/d/Y");;
$query = mssql_query("INSERT INTO dbo.psyweb_news (id, title, content, data) values ('$id', '$title', '$content', '$data')");

---

Quote:

---

Originally Posted by aecrimch

Nice, phit666, still there are some errors.

There is no script.js, jquery.js and jquery.pstrength-min.1.2.js
Instruction

must be without esperar_login('login'); in all pages where esperar_login('login'); appear (this cause a fault in js - function esperar_login() isnt defined or maybe was defined in some .js files which are not included :P).
Tested in many browsers, Google Chrome and Safari dont display rankings ok.
Bad ajax implementation:

---

I havent noticed that missing function coz Im not getting error loading pages with this function. I also dont have those scripts above that you mentioned.

the guild script don't recognize all logo colors is only for me ?

Thanks
graciasss

Quote:

---

Originally Posted by vcorp

the guild script don't recognize all logo colors is only for me ?

---

What specific color?

try this:

Quote:

---

Originally Posted by phit666

What specific color?

try this:

---

green for example

Quote:

---

Originally Posted by Denied

Credits :

• Natchelf for his stupid 3rd wings .
  
  NOTE : Feel free to steal our work as long as you give credits .

---

what a double moral...

"stupid", my mg is the biggest work of this trash release at all...

you have made "nothing" on this template, every part here is stolen !
i didnt just make the wings, the MG how you see it there, sword included, is made be "me"

i had to inform you 3 times that you used MY stuff, in ANY of my releases iam noticing that i expect to get credits if people use my stuff.

is this so hard to understand ?