[Request]Pimping page for no GM/Admin

[DennisDee]

Right now i test Curiums webpage again & i just added lvl5 admin (low lvl GM) in site as normal user with some more commands - aka VIP. Now when me as VIP log on page I see link VIPcp.

The request is,if some1 can make me script for pimping his items (armor & weapons). Atm i copied scripts from admin pages & tried to re-edit them,but no luck. If I get in vipcp i can see all users & their characters + i can pimp their stuff (all,even money) :S. So pls be kind & help me around that

 

[martyNL2]

euhm...
Make a connection to your database

  mssql_connect('localhost');
  mssql_select_db('kal_db');

make a form where you put in the itemID of the weapon

query: SELECT * FROM Item where IID = <the itemid u just gave up>

again make a form: where the you put in the Xattack (so u can see how much it is atm)
then you can edit it.. and press submit.

Update Item Set Xattack = <your Attack> Where IID = <the itemid u just gave up>

this is just an idea how to do it.. (plz no flame xD) to make it work you have to know a bit php Its not hard to write
Here is a nice page where you can learn php

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

- when I am more then 100% bored I write the script for you xD

 

[DennisDee]

Hehe,ty Marty. I`lltry to make script like u added quotes for it. Well, i know just a little bit of php . If this gonna work i will write credits on u .

But im missing 1 part here... How to write the code to pimp only stuff on my chars from my UID?Anyway ill try with playing with DB+php,maybe i will learn some more php ^^

 

[martyNL2]

Done,
I made this script in a rush when I was bored

Hope you like it.

 

[DennisDee]

Yea i like it . Allmost finished with re-editing ^^. Its allrdy woroks with login only . Just need to fix the items shows only from UID and not all users

 

[Xerxes008]

Done,
I made this script in a rush when I was bored

Hope you like it.

Can you explain me how i can add this System on my homepage ?
I just know that i have to change the DB Password and the username like "sa"
and servername to "localhost".

I hope you can explain me how it works.

Thanks

 

[avihai1]

First you select your database 'kal_db' then you choose your field = 'Items'.
then you make some parameters like, select all items where the item id is lets say 1 , g1 sword^^ and you tell it to show you all this item's parameter xattack gem etc.
then you make a textbox which will ocntain the XAttack you want to change, you tell it to take the variable X(X=the number you entered in the textbox) and replace it with the excisting number in XAttack with the simple query of SQL----(UPDATE 'Items' SET XAttack='" . $X . "' WHERE PID AND IID = 10)--- it suppose to be something like this, i dont remember the db structture so it might be not the right valuse etc lol
hope you understand it.

 

[Stup]

gm abuse page, nice