[Share]Item Sending (PHP Script) and Item Shop Map (with item name)

SeraphiPod · Sep 17, 2008

Updates:
Updated the guide 09/18/08

Well, The RanShop.bak is from me, well, I haven't made that not because of sir strippher
the Item Sending using PHP Script is from Programmer27 and Shared by Reinfrooze of PDF.

NOTE: OFF your Server TO MAke the EXECUTION QUICK!
IT's NOT on the TIME But errors will come if your server is on
Okay Back to the Topic,
First Download These:

To view the content, you need to sign in or register

Second Put the Sending Items PHP Script
on your Web Server (Abyss is default)
Put it on ur cp let's say = C

rogram Files\Abyss Web Server\htdocs\ran\
Third Open the php 'open.php' and open2.php'
edit the "192.168.x.x(to mycomputer\sqlexpress)", "sa", "1234"
and open your 'glogic.rcc from your client'
extract it, decrypt it put it on your web server, edit the name to itemstrtable

Fourth Put this on ur Query.php

Code:

DEFINE("INSERT_SHOPITEMS",
"INSERT INTO ShopItemMap (ProductNum, ItemMain, ItemSub, ItemName,
ItemList) VALUES ('%d','%d','%d','%s','1')");

SAve it.

Fifth is to apply my RAnShop.bak on ur RanShop

Sixth is to Go to

To view the content, you need to sign in or register

Then Find the item you want, After Doing So, Open

To view the content, you need to sign in or register

then put on the Product Num the 'code' of your item desired. (Characters of the Account your Giving must be offline)

Then login-in-game.
good luck, I have edit the guide
Open Bank, Den Ta Da!

-Seraph

Credits:
Reinfrooze
Programmer27
Sir Strippher
Me? or no? Your Idea or choice,
if you wanna put me here, kindly post!

FAQZ

Programmer27 said:
Warning: mssql_query(): message: Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF. (severity 16) in C:\Program Files\Abyss Web Server X2 v 2.5\htdocs\itempass\mark.php on line 85

explicit identity error will only occur if you have used ur primary key in an explicit way.
to solve this problem you must remove the authority as primary key to the primary key field in your ShopPurchase table of ur database, JUST REMOVE. (dont delete the whole filed)

thus, removing the authority as primary key will make you use that field explicitly. just right click the field and remove primary key click ok or confirm

strippher said:
on the original mark.php and mar2.php if im not mistaken, the script is creating the unique purkey key, try editing the PurKey in ur sql to autoincrement and remove the

on ur mark.php or mark2.php
$Pname = rand(1, 99999999); <<< not to be use anymore
$queryinsert = sprintf('INSERT INTO ShopPurchase (UserUID, ProductNum, PurPrice) << b4 i think $pname is included here...
VALUES("%s", "%s","%s")', $User,$Product,$Harga); and here...

hope it helps...

bajong009 · Sep 20, 2008

Warning: mssql_query() [function.mssql-query]: message: Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF. (severity 16) in D:\xampp\htdocs\rancp\mark.php on line 50

Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\htdocs\rancp\mark.php on line 50
cant send the gift

got this error. Everything is working fine, I can buy at itemshop. but I can't send gifts. No error in mark2.

fadzly · Sep 20, 2008

bajong009 said:
Warning: mssql_query() [function.mssql-query]: message: Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF. (severity 16) in D:\xampp\htdocs\rancp\mark.php on line 50

Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\htdocs\rancp\mark.php on line 50
cant send the gift

got this error. Everything is working fine, I can buy at itemshop. but I can't send gifts. No error in mark2.

yeah...same here...

SeraphiPod · Sep 21, 2008

wait...
ki?
i'll be responding asap.

did u already putted the queries?

lemme see ur mark.php
here's my mark.php

Code:

<title>Item Sender</title>
<body bgcolor="lightblue">
<center>
<?php
// From Programmer27
// From Reinfrooze
// Edited by Sir Strippher -Php Scripting
// Edit by Seraph -Only those prints
require "function.php";

require "open.php";


 $query="SELECT * FROM UserInfo order by UserID ASC";

 if(!$result = mssql_query($query))
   print'cannot connect result';

   print"
    <p><font face=Kartika color=blue>Send Item to Users</font>
     <form method=POST action=mark.php>

       <table border=1 cellpadding=0><tr>
          <td>
            <font face=Kartika color=orange>Product Number</font> </td><td><input type= text name=Product> </input>
          </td>
          </tr>

        </table>
      <select name=users>  ";
	   while ($rows=mssql_fetch_array($result))
	   {
		  print"
			 <option>{$rows['UserID']}</option>
			";
		}

   print"</select>
         <input type=\"submit\" name=\"post1\" value=\"Send Item!\">
         <input type=\"submit\" name=\"post2\" value=\"Send Item to All\">
        </form>";


 if(isset($_POST['post1']))
 {
	 $User=$_POST['users'];
	 $Product=$_POST['Product'];
     $Harga=0;
     require "open2.php";
	 		$Pname = rand(1, 99999999);
     
     $queryinsert = sprintf('INSERT INTO ShopPurchase (UserUID, ProductNum, PurPrice)
       VALUES("%s", "%s","%s")', $User,$Product,$Harga);


	 if(!$result2=mssql_query($queryinsert))
	   die('Cannot Send the Gift');

	   print'Item Sending is Successful';
 }

 if(isset($_POST['post2']))
  {

 	 $Product=$_POST['Product'];
     if(!$result = mssql_query($query))
        print'cannot connect result';

     $Product=$_POST['Product'];
      $Harga=0;
      $i=0;
      while ($rows=mssql_fetch_array($result))
	   {
          $User=$rows['UserID'];
          $container[$i++]=$User;

	   }
	   $j=$i;
	   $j--;
	   $i=0;
       while($j>=$i)
       {

	          require "open2.php";
				$Pname = rand(1, 99999999);
	   		      $queryinsert = sprintf('INSERT INTO ShopPurchase (UserUID, ProductNum, PurPrice)
	   		        VALUES("%s","%s","%s")', $Pname,$container[$i],$Product,$Harga);


	   		 	 if(!$result2=mssql_query($queryinsert))
	   		 	   die('Cannot send the Item');

	   	  $i++;
	   	  print'Sending Sucess';

       }
  }



?>
<br />
<br />
<br />
<font face="Interstate" size="3">Just My Playlist:</font>
<br />
<br />
<br />
   <center><p style="visibility:visible;"><embed src="http://assets.myflashfetish.com/swf/mp3/mff-mpodmin.swf" quality="high" wmode="transparent" flashvars="myid=12979421&path=2008/09/17&mycolor=1F2623&mycolor2=4D82D1&mycolor3=FFFFFF&autoplay=true&rand=0&f=4&vol=100&pat=15&grad=false" width="158" height="208" name="myflashfetish" align="middle"type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" border="0" /><br></p></center><img style="visibility:hidden;width:0px;height:0px;" border=0 width=0 height=0 src="http://counters.gigya.com/wildfire/IMP/CXNID=2000002.4NXC/bT*xJmx*PTEyMjE2NjQxOTAyMTImcHQ9MTIyMTY2NDIwNDcwMyZwPTE4MDMxJmQ9Jm49Jmc9MSZ*PSZvPTkzN2ViZDQzM2VhMTQxODlhYTQxMzgwNDZhZmY*ZWZk.gif" />
</center>
</body>

bajong009 · Sep 21, 2008

Got this error:

Sending Sucess
Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value '3lvin17' to data type int. (severity 16) in D:\xampp\htdocs\rancp\mark.php on line 87

Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\htdocs\rancp\mark.php on line 87
Cannot send the Item

When I click "Sent item to all" this will come up.

clever · Sep 21, 2008

this really nice

if will works fine

let me try

SeiferXIII · Sep 21, 2008

heheh as i know... this is already shared at the past time..

SeraphiPod · Sep 22, 2008

but the items, i mean shop item map of sir strippher's...

the dbphp script is shared long time ago.
well the guide is already posted?

yo, i saw like this guide (sir ultimate) but not like dis

emokid13seifer · Sep 24, 2008

ekekekek help

Warning: mssql_query(): message: Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF. (severity 16) in C:\Program Files\Abyss Web Server X2 v 2.5\htdocs\itempass\mark.php on line 85

Warning: mssql_query(): Query failed in C:\Program Files\Abyss Web Server X2 v 2.5\htdocs\itempass\mark.php on line 85
cant send the gift

ChunG · Sep 24, 2008

i got and error
Error 404

Not Found

Powered by Abyss Web Server X1

SeraphiPod · Sep 25, 2008

ChunG,
it's common sense already!,

I mean, there's no file on ur folder.................. or wrong type?

austhistikated · Sep 25, 2008

@ChunG
Have you declared the indexes that you will be using and have you set the right root folder for your web pages?

@SeraphiPod
Try not to be so rude with other members...

ChunG · Sep 25, 2008

Sir
U can give the Guide how to declared the indexes.

@SeraphiPod
Sorry cause im moobs.!!!!

programmer27 · Sep 27, 2008

Warning: mssql_query(): message: Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF. (severity 16) in C:\Program Files\Abyss Web Server X2 v 2.5\htdocs\itempass\mark.php on line 85

explicit identity error will only occur if you have used ur primary key in an explicit way.
to solve this problem you must remove the authority as primary key to the primary key field in your ShopPurchase table of ur database, JUST REMOVE. (dont delete the whole filed)

thus, removing the authority as primary key will make you use that field explicitly. just right click the field and remove primary key click ok or confirm

austhistikated · Sep 27, 2008

@ChunG
Declaring indexes depends on what webserver you are using, might as well look for the documentation or for the help file of that webserver you are using.

ChunG · Sep 27, 2008

austhistikated said:
@ChunG
Declaring indexes depends on what webserver you are using, might as well look for the documentation or for the help file of that webserver you are using.

sir i use Abyss Web Server X1!!!!

austhistikated · Sep 27, 2008

If you are using that webserver then that's easy. You will have there help when you enter console. And look for adding php something. Then it will teach you how to add php and declare indexes...

SeraphiPod · Sep 27, 2008

...,
we;'re the same
make sure your abyss has php.

I mean know php *
follow the guide.

ChunG · Sep 27, 2008

i have sir i have CP but when i use the mark.php have error.

SeraphiPod · Sep 27, 2008

..
open "open.php"

make sure you already configured it.
if not, go back to the start line of the guide.

[Share]Item Sending (PHP Script) and Item Shop Map (with item name)

-sama

Newbie Spellweaver

Newbie Spellweaver

-sama

Newbie Spellweaver

Experienced Elementalist

Web3 is the Future

-sama

Newbie Spellweaver

Newbie Spellweaver

-sama

Divine Celestial

Newbie Spellweaver

Junior Spellweaver

Divine Celestial

Newbie Spellweaver

Divine Celestial

-sama

Newbie Spellweaver

-sama

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners