[ModuleWeb]Buy Color Name
Hi all, I will published a script adapted for the web: MPOG
But it is easily adaptable to other websites
Instructions:
- Download MPOG WEB and apply some fixes released on Ragezone
- Edit title.php search line:
PHP Code:
(case "login"; $pagetitle = "User Login"; break; )
and add this below:
PHP Code:
case "buycolorname";
$pagetitle = "Buy Color Name";
break;
- Add yours grades and colors:
E.G. :
PHP Code:
switch($grade){
case 10;
$grade = 10;
break;
case 11;
$grade = 11;
break;
case 12;
$grade = 12;
break;
If change it :
PHP Code:
switch($grade){
case CUSTOMGRADE;
$grade = CUSTOMGRADE;
break;
case CUSTROMGRADE2;
$grade = CUSTROMGRADE2;
break;
case CUSTROMGRADE3;
$grade = CUSTOMGRADE3;
break;
- If you edit the grades, also you need edit the colors in the FORM HTML.
Code:
<option class="red" value="10">RED</option>
<option class="white" value="11">WHITE</option>
<option class="blue" value="12">BLUE</option>
If change it:
Code:
<option class="colorcss" value="CUSTOGRADE">COLOR</option>..etc
- And add the css styles for the colors and.. edit
the two variables $price = intval(50);/<?=$infoacc->EventCoins( or euCoins)-50?> change "50" for a your price
mod_buycolorname.php(For MPOG )
PHP Code:
<?php
// Is logged?
if ($_SESSION['AID'] == "") {
re_dir("index.php?do=login");
}
$query00 = mssql_query("SELECT CID FROM Character(nolock) WHERE AID = '{$_SESSION['AID']}' AND CharNum != '-1' AND Name != '' ");
// Have characters?
if (mssql_num_rows($query00) < 1) {
msgbox("You dont have characters!", "index.php?do=buycolorname");
}
?>
<?php
if (isset($_POST['submit'])) {
$aid = antisql($_SESSION['AID']);
$grade = antisql($_POST['color']);
$price = intval(50);
// Color is valid?
switch($grade){
case 10;
$grade = 10;
break;
case 11;
$grade = 11;
break;
case 12;
$grade = 12;
break;
default:
msgbox("Invalid color name!", "index.php?do=buycolorname");
}
// Color is numeric?
if (!is_numeric($grade)) {
msgbox("Invalid color name!", "index.php?do=buycolorname");
}
// Color empty? useless
elseif (empty($grade)) {
msgbox("Invalid color name: Color is empty!", "index.php?do=buycolorname");
} else {
// Suficients coins ?
$query = mssql_query("SELECT euCoins FROM Login WHERE AID = '$aid'");
$info = mssql_fetch_assoc($query);
$updatecoins = $info['euCoins'] - $price;
if ($updatecoins < 0) {
msgbox("Insufficent coins!", "index.php?do=buycolorname");
} else {
// Update
$addcolor = mssql_query("UPDATE Account SET ugradeid = '$grade' WHERE AID = '$aid'");
$payingcoins = mssql_query("UPDATE Login SET euCoins = '$updatecoins' WHERE AID = '$aid'");
/*
OPTIONAL: Log the actions in DB
1. Run the query in sql server without the "////////"
2.Then add this line after $payingcoins: $logs = mssql_query("INSERT INTO Logbuycolor (AID,ColorBuy,RegDate) values ('$aid','$grade',GETDATE())");
3.Create a admin panel with the function to see logs actions: See buy color names, etc o Add the function to see buy color names
E.G: IfIsAdmin(){
// query select the logs... etc
}
Finish.
/////////////////////////////////////// table ////////////////////////////////////
USE [GunzDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Logbuycolor](
[AID] [int] NOT NULL,
[ColorBuy] [int] NOT NULL,
[RegDate] [datetime] NOT NULL,
CONSTRAINT [PK_Logbuycolor] PRIMARY KEY CLUSTERED
(
[AID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
/////////////////////////////////////////// end table ///////////////////////////////////////////////////
*/
if ($addcolor && $payingcoins) {
msgbox("Successfully purchased color name!", "index.php?do=buycolorname");
} else {
msgbox("There were problems with the server, try later", "index.php?do=buycolorname");
}
}
}
} else {
// Get some info
$query01 = mssql_query("SELECT euCoins,UserID FROM Login(nolock) WHERE AID = '{$_SESSION[AID]}'");
$infoacc = mssql_fetch_object($query01);
}
?>
<!-- Credits to mutter -->
<head>
<meta http-equiv="Content-Language" content="en">
<link rel="stylesheet" type="text/css" href="http://forum.ragezone.com/images/style.css">
<style type="text/css">
OPTION {
background-color:#666;
}
OPTION.red {
color:#F00;
font-weight:bold;
}
OPTION.white {
color:#FFF;
font-weight:bold;
}
OPTION.blue {
color:#00F;
font-weight: bold;
}
</style>
</head>
<form name="bcn" method="POST" action="index.php?do=buycolorname">
<body bgcolor="#323232">
<div align="center">
<table border="0" width="456" style="border-collapse: collapse">
<tr>
<td background="http://forum.ragezone.com/images/cont_up.jpg">
</td>
</tr>
<tr>
<td background="http://forum.ragezone.com/images/cont_bg.jpg">
<div align="center">
<table border="0" style="border-collapse: collapse" width="100%" height="100%">
<tr>
<td width="10" rowspan="10">
</td>
<td colspan="2" align="center">
<font color="#FFFFFF">Buy color name</font>
</td>
<td width="10" rowspan="10">
</td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<tr>
<td valign="middle" align="right">
<font color="#FFFFFF">Color</font>
</td>
<td width="204" valign="middle" align="left">
<select name="color">
<option selected value="">Select color</option>
<option class="red" value="10">RED</option>
<option class="white" value="11">WHITE</option>
<option class="blue" value="12">BLUE</option>
</select>
</td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<tr>
<td valign="middle" align="right">
<font color="#FFFFFF">Price:</font>
</td>
<td width="204" valign="middle" align="left">
<font color="#FFFFFF">50 Coins</font>
</td>
</tr>
<tr>
<td valign="middle" align="right">
<font color="#FFFFFF">Actual coins:</font>
</td>
<td width="204" valign="middle" align="left">
<?=$infoacc->euCoins?>
</td>
</tr>
<tr>
<tr>
<td valign="middle" align="right">
<font color="#FFFFFF">Coins remaining:</font>
</td>
<td width="204" valign="middle" align="left">
<?=$infoacc->euCoins-50?>
</td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<tr>
<td colspan="4" align="center">
<input type="submit" value="Buy Color Name" name="submit">
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td background="http://forum.ragezone.com/images/cont_top.jpg" height="27">
</td>
</tr>
</table>
</div>
</form>
<!-- Credits to mutter -->
module_buycolorname.php(for EuroGunz web)
PHP Code:
<?
if( $_SESSION['AID'] == "" )
{
SetURL("index.php?do=buycolorname");
SetMessage("Message from System", array("You must be logged in to buy Color name"));
header("Location: index.php?do=login");
die();
}
$query00 = mssql_query("SELECT CID FROM Character(nolock) WHERE AID = '{$_SESSION['AID']}' AND CharNum != '-1' AND Name != '' ");
// Have characters?
if (mssql_num_rows($query00) < 1) {
SetMessage("Message from System", array("You don't have any character!"));
header("Location: index.php");
die();
}
SetTitle("EuroGunz - Buy Color Name");
if (isset($_POST['submit'])) {
$aid = clean($_SESSION['AID']);
$grade = clean($_POST['color']);
$price = intval(50);
// Color is valid?
switch($grade){
case 10;
$grade = 10;
break;
case 11;
$grade = 11;
break;
case 12;
$grade = 12;
break;
default:
SetMessage("Message from System", array("The color id is invalid!"));
header("Location: index.php?do=shopitem");
die();
}
if (!is_numeric($grade)) {
SetMessage("Message from System", array("Invalid Color name!"));
header("Location: index.php?do=buycolorname");
die();
}
// Color empty? useless
elseif (empty($grade)) {
SetMessage("Message from System", array("You don't select a Color name!"));
header("Location: index.php?do=buycolorname");
die();
} else {
// Suficients coins ?
$query = mssql_query("SELECT EventCoins FROM Account(nolock) WHERE AID = '$aid'");
$info = mssql_fetch_assoc($query);
$updatecoins = $info['EventCoins'] - $price;
if ($updatecoins < 0) {
SetMessage("Message from System", array("You don't have suficient Event Coins"));
header("Location: index.php");
die();
} else {
// Update
$addcolor = mssql_query_logged("UPDATE Account SET ugradeid = '$grade', EventCoins = '$updatecoins' WHERE AID = '$aid'");
if ($addcolor) {
SetMessage("Message from System", array("Succesfully purchased color name!"));
header("Location: index.php");
die();
} else {
SetMessage("Message from System", array("There were problems with the server, try later!"));
header("Location: index.php");
die();
}
}
}
} else {
// Get some info
$query01 = mssql_query("SELECT EventCoins FROM Account(nolock) WHERE AID = '{$_SESSION[AID]}'");
$infoacc = mssql_fetch_object($query01);
}
?>
<style type="text/css">
OPTION {
background-color:#666;
}
OPTION.red {
color:#F00;
font-weight:bold;
}
OPTION.white {
color:#FFF;
font-weight:bold;
}
OPTION.blue {
color:#00F;
font-weight: bold;
}
</style>
<table border="0" style="border-collapse: collapse" width="100%">
<tr>
<td width="183" valign="top">
<div align="center">
<? include "blocks/block_ranking.php" ?>
</div>
</td>
<td valign="top">
<div align="center">
<table border="1" style="border-collapse: collapse" width="100%" bordercolor="#000000">
<tr>
<td background="http://forum.ragezone.com/images/content_bar.jpg" height="24" style="background-image: url('images/content_bar.jpg'); background-repeat: no-repeat; background-position: center top">
<div align="center">
<b><font face="Tahoma" size="2">Buy Color Name</font></b></td>
</tr>
<tr>
<td bgcolor="#2C2A2A">
<div align="center"><form method="POST" action="index.php?do=buycolorname" name="buycolorname">
<table border="0" style="border-collapse: collapse" width="414" height="100%">
<tr>
<td width="10"> </td>
<td width="315" colspan="3"> </td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="315" colspan="3">You can buy a Color name for Gunz.<br />
The price is 50 Event coins.</td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="315" colspan="3"><br /></td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="181">
<p align="right">Select the color</td>
<td width="13"> </td>
<td width="190">
<select name="color" class="cero">
<option selected value="">Select color</option>
<option class="red" value="10">RED</option>
<option class="white" value="11">WHITE</option>
<option class="blue" value="12">BLUE</option>
</select></td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="315" colspan="3"> </td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="181">
<p align="right">Price:</td>
<td width="13"> </td>
<td width="190"><b>50 Events Coins</b></td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="181">
<p align="right">Actual Event coins:</td>
<td width="13"> </td>
<td width="190"><b><?=$infoacc->EventCoins?></b></td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="181">
<p align="right">Coins remaining::</td>
<td width="13"> </td>
<td width="190"><b><?=$infoacc->EventCoins-50?></b></td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td width="315" colspan="3"> </td>
<td width="11"> </td>
</tr>
<tr>
<td width="10"> </td>
<td colspan="3">
<p align="center">
<input type="submit" value="Buy Color Name" name="submit"></td>
<td width="11"> </td>
</tr>
</table></form>
</div>
</td>
</tr>
</table>
</div>
<p align="center"> </td>
<td width="171" valign="top">
<div align="center">
<? include "blocks/block_login.php" ?>
</div>
</td>
</tr>
</table>
If you have problems please write it here (I don't have the sql server or xampp, I dont can test it )
P.S. : Sorry for my english
Guide to add custom grades 2008 files: http://forum.ragezone.com/f245/july-...tomize-688781/
Code:
Update v1.1:
Fixed: Filter color id
Fixed: A fetch_assoc
ByeBye
Re: [ModuleWeb]Buy Color Name
This fuctions work on EuroGunZ web???:?:
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
Turunen
This fuctions work on EuroGunZ web???:?:
Read the second line of the post "But it is easily adaptable to other websites"
Change some lines of the code..
Re: [ModuleWeb]Buy Color Name
Re: [ModuleWeb]Buy Color Name
what is this for?
Code:
if ($grade != CUSTOMGRADE || $grade != CUSTOMGRADE2 || $grade != CUSTOMGRADE3 || $grade != CUSTOMGRADE4)..
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
adminjoker
what is this for?
Code:
if ($grade != CUSTOMGRADE || $grade != CUSTOMGRADE2 || $grade != CUSTOMGRADE3 || $grade != CUSTOMGRADE4)..
To add your custom grades( 150,25,75,etc )..
E.G. : if($grade != 150 || etc)
It is also to confirm that only the "custom grades" presented in the <select> are the chosen and not other
Re: [ModuleWeb]Buy Color Name
nc sir good job 1000/10 + like xD
ByeBye
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
mutter
To add your custom grades( 150,25,75,etc )..
E.G. : if($grade != 150 || etc)
It is also to confirm that only the "custom grades" presented in the <select> are the chosen and not other
ok but where i am going to add it or put it? i don't get it!
could you add me on msn or explain it with more and especific details please? thanks i appreaciate.
patricksterza@hotmail.com
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
adminjoker
ok but where i am going to add it or put it? i don't get it!
could you add me on msn or explain it with more and especific details please? thanks i appreaciate.
patricksterza@hotmail.com
First, you have Custom Grades?(Edits in ASM on theduel.exe)..
Re: [ModuleWeb]Buy Color Name
thanks men awesome release i love u, i have a question u no have the script for modules of Eurogunz web??? (change clan name, change character name). please??? i love this 999999999999999.../10 and like++ :blushing:
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
victordav
thanks men awesome release i love u, i have a question u no have the script for modules of Eurogunz web??? (change clan name, change character name). please??? i love this 999999999999999.../10 and like++ :blushing:
Later release: Change Clan Name, Change Char Name
Based on EuroGunz web
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
victordav
thanks men awesome release i love u, i have a question u no have the script for modules of Eurogunz web??? (change clan name, change character name). please??? i love this 999999999999999.../10 and like++ :blushing:
wondering the same thing victordav
Thank's mutter for the module of EG web awesome. LIKE!!!:thumbup:
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
mutter
Later release: Change Clan Name, Change Char Name
Based on EuroGunz web
ok mutter, I would greatly appreciate it :love:
ED: if you have EG database, if you can post?
Re: [ModuleWeb]Buy Color Name
Quote:
Originally Posted by
victordav
ok mutter, I would greatly appreciate it :love:
ED: if you have EG database, if you can post?
The DB for EuroGunz WEB(not server, WEB) its easy to make.. read the .php files and make manually the tables, stored procedure(for register) and others ..
Re: [ModuleWeb]Buy Color Name