Chumpy's simple regpage and cash shop v1.5 beta

done everything in guide but for some reason in game both links show
admin im on gm but when i click the admin link in game i get hack attempt error even though its set up properly

Quote:

---

Originally Posted by nolifelover

now i add new table to integrate with chumpywumpy cash shop beta to fix bug when buying alz nor deduce. i poor php programing i will copy code from member in board and modify a little source to use new table and add file convert.php to convert alz in warehouse to cash alz. if an other one who want to test my script i attachment below.

http://www.mediafire.com/?2dtmwcjyxbd

Thanks for Chumpy's and Andrejchik.

---

Code:

---

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'UserNum'. (severity 16) in C:\xampp\htdocs\webshop.php on line 41

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\webshop.php on line 41

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\webshop.php on line 42
Could not get CashShop Alz

---

only new table u have added was

Quote:

---

CREATE TABLE [ShopAlz] (
[Id] [int] NOT NULL ,
[Alz] [varchar] (20)
)

---

oh so sorry

CREATE TABLE [ShopAlz] (
[UserNum] [int] NOT NULL ,
[Alz] [varchar] (20)
)

it linux do i need to create this please help You will also need to create c:\freetds.conf

[global]
host = 127.0.0.1
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

Quote:

---

Originally Posted by Dinh

cyber and Chumpy,

Thanks a lot for the quick replies. I think I found those .ini files :). I am editing them now as we speak.

Update:

Got the cashshop button to work. When I log in with a GM account, I was able to add and edit items. but after clicking "Done", I can't do anything else. Anything else I click will get me this error:

"Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.

If you think this is a server error, please contact the webmaster.

Error 404
XX.XX.XX.XX <----my Wan IP
11/05/08 11:14:13
Apache/2.2.9 (Win32) DAV/2 mod_ssl/2.2.9 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.6"

Could this be because I changed the "cashshop" to "somethingmuchlongercashshop" to get 60 char so I can run cabalmain.exe?? Or I simply didn't enter the image link for the item correctly??

Also, when I log in with a normal account "with lots of Alz" for testing the cashshop, I can't seem to buy anything. I kept getting this error:

An error has occurred in the script on this page!

Line: 1
Char: 1
Error: Object Expected
Code: 0
URL: "The url I hexed in the cabalmain.exe"


Is there a way to get back to the game after using the cashshop without closing/restarting the game?

---

I guess you hexed something incorrectly if it can't find the pages, either that or you renamed one or more of the php files which will also stop it finding itself. You don't have to pad the address out to 60 chars just put your address in and make sure is has hex 00 at the end of the address.

You can exit the cash shop (or an error page) using the Esc key.

Quote:

---

Originally Posted by Lazy

Well, opened Port 8080 and added in my no-ip port 80 redirection still no succes
tryed the following things then;

Error: I could not see your service on 78.22.xxx.xx on port (8080)
Reason: Connection refused

when i put it at port 38181

Success: I can see your service on 78.22.xxx.xx on port (38181)
Your ISP is not blocking port 38181(same for 1433)

then it just like port 8080 time out (whit no-ip redirection)

and when he just put ip and port that is open,he get blank page

i dont know what to do anymore :s cant let a rented host connect to my db
and cant put the website online wtf pff:?::mad:

Thanks in Advance, lazy

---

Have you set the webserver to listen on port 8080 as well? If you change the port you are forwarding you also have to configure the webserver to listen n the new port. For apache/xampp this is in the httpd.conf file.

Quote:

---

Originally Posted by DWBaHu0

okay Dinh, thank u so much :)
i fix the problem :thumbup1:

I have other question..
Anyone know how to make a verification image on registraton?
example:
User: .....
Pass: ....
Confim pass: .....
Code verify: ......
[Registration]

---

This would need a fair amount of code being written as the regpage itself is horribly simple right now. A verification image is all but useless though as it won't stop anyone who wants to use a bot to create accounts as all captcha methods can be bypassed. A better methos is to require a unique email address but that isn't perfect either because people can just create new hotmail accounts to register with.

Quote:

---

Originally Posted by nolifelover

now i add new table to integrate with chumpywumpy cash shop beta to fix bug when buying alz nor deduce. i poor php programing i will copy code from member in board and modify a little source to use new table and add file convert.php to convert alz in warehouse to cash alz. if an other one who want to test my script i attachment below.

http://www.mediafire.com/?2dtmwcjyxbd

Thanks for Chumpy's and Andrejchik.

---

The other method i tested didn't work either. The problem isn't my code it is actually the game itself. Whenever you go near your storage the game leaves transactions uncompleted on the server so you buy, alz gets removed, then the transactions from opening storage finish and put the old alz amount back again. I have even managed to get my in-game storage alz amount to show alz when there actually isn't any in the db tables. It's very annoying and using another table for cash is going to be the only way around it, that then leads to the problem where you can transfer cash to the new table whilst the char is online or the same hole exists. I now have to add the login functions to the regpage so you can log in whilst not online and transfer the cash.

Quote:

---

Originally Posted by Cath22

it linux do i need to create this please help You will also need to create c:\freetds.conf

[global]
host = 127.0.0.1
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520

---

You don't need to install freetds on a linux machine that runs the gameserver as it has it already. If you are installing on a machine that doesn't have the gameserver installed then check the linux install notes at http://www.freetds.org/userguide/install.htm

Quote:

---

Originally Posted by chumpywumpy

Have you set the webserver to listen on port 8080 as well? If you change the port you are forwarding you also have to configure the webserver to listen n the new port. For apache/xampp this is in the httpd.conf file.

---

Chumpy, Thanks again man - Fixed (i dident know about the conf, thought php.ini was the conf for all and port 80 was auto, i learned again :thumbup1:)

hi @chumpywumpy

i have a problem..
why my table ShopAlz dont work?
sorry for my bad english but.. when i am in game i get alz and when i check the ShopAlz -> open table -> return all rows -> there dont have a columns..why?
how to fix ? :( :?:

when i put
in ShopAlz:

UserNum | Alz
1 | 200

and when i go to game in webshop.. i have 200 alz but dont change automatically :(:

please help..

in game anyone know why i get hack attempt when i click the admin link to set shop up?

Quote:

---

Originally Posted by DWBaHu0

hi @chumpywumpy

i have a problem..
why my table ShopAlz dont work?
sorry for my bad english but.. when i am in game i get alz and when i check the ShopAlz -> open table -> return all rows -> there dont have a columns..why?
how to fix ? :( :?:

when i put
in ShopAlz:

UserNum | Alz
1 | 200

and when i go to game in webshop.. i have 200 alz but dont change automatically :(:

please help..

---

user convert.php to convert alz from warehouse to shop alz table.

Quote:

---

Originally Posted by chumpywumpy

The other method i tested didn't work either. The problem isn't my code it is actually the game itself. Whenever you go near your storage the game leaves transactions uncompleted on the server so you buy, alz gets removed, then the transactions from opening storage finish and put the old alz amount back again. I have even managed to get my in-game storage alz amount to show alz when there actually isn't any in the db tables. It's very annoying and using another table for cash is going to be the only way around it, that then leads to the problem where you can transfer cash to the new table whilst the char is online or the same hole exists. I now have to add the login functions to the regpage so you can log in whilst not online and transfer the cash.http://www.freetds.org/userguide/install.htm

---

thanks for comment and i will wait for new version cash shop.

Help me plz. Install shop by your gide. And have this error:
http://smages.com/t/41/c0/41c0305bbf...6dbfcdb148.jpg Ps: may be i had this errors coz today i install your repack v2 and my Datbase from your old pack (serv ind 24 now =1 (mercury))
tnx

find whay 0 alz but still have errors =(

Quote:

---

Originally Posted by Advocate

in game anyone know why i get hack attempt when i click the admin link to set shop up?

---

Set IP validation to false in config.php. Using it is more secure but i have found that one some configs the server sees the player's ip address differently to the one the webserver sees, on my network the game thinks i am my gateway but the webserver sees the correct address for example. If the two see a different address then it will fire off a hack attempt.

Quote:

---

Originally Posted by Twiddle

Help me plz. Install shop by your gide. And have this error:
Ps: may be i had this errors coz today i install your repack v2 and my Datbase from your old pack (serv ind 24 now =1 (mercury))
tnx

find whay 0 alz but still have errors =(

---

Did you create the CashShop db and the ShopItems table? The error is saying that it can't find it.

yes. but now i delete it and make again and all work fine. tnx chumpywumpy ur greate! ;)

Quote:

---

Originally Posted by chumpywumpy

Set IP validation to false in config.php. Using it is more secure but i have found that one some configs the server sees the player's ip address differently to the one the webserver sees, on my network the game thinks i am my gateway but the webserver sees the correct address for example. If the two see a different address then it will fire off a hack attempt.



Did you create the CashShop db and the ShopItems table? The error is saying that it can't find it.

---

err tried both ways and still get hack attempt mate.

Quote:

---

Originally Posted by Advocate

err tried both ways and still get hack attempt mate.

---

@Avocate

About your Hack attempt, I might have the solution for you. Cause I just experinced it today.

The problem might caused by your hexing cabalmain.exe.

Before today, I'm using a cabalmain.exe hexing and replacing the address with the exact same
60 characters in the original webshop address.

Today I tried to hex it with a shorter address and it work.
When i login game, i can see and browse the Cash Shop.

But when I click on the shop admin, I get hack attempt. @@
All the cashshop files setting are same as before, nothing change, just the cabalmain.exe.

I've tried to restart the game, the server but still the same.
Then I replace back the old cablmain.exe with the exact 60charaters address in it.

When I login game, browse the Cash shop and click the Shop Admin. Everything goes fine.
No more Hack Attempt. @@

You can try to re-hex the cabalmain.exe and replace it with exact 60 characters address to give it a try.
And start the game with it. The whole process wont take much of your time.
Maybe it will solve your problem. Who knows....?

This might be a solution for you in the mean time. I'm not for sure, but this way help me slove
my problem. Hope it helps you too.

It sounds like you didn't correctly zero terminate your cash shop address cyber37, the string must end in a zero hex byte.

If turning off ip validation doesn't work then enable test mode and see what appears in the top left of the cash shop pages. Compare the v1 (UserNum) and v2 (AuthKey) values to the ones your account has in cabal_auth_table. Unless v1 and v2 match you won't get in and if ip validation is enables the IP address must match the LastIp in the db too.

Code:

---

User data=v1=%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2012&v2=C22A484EB902481EB3E808FE11FD5AA5
v1= 12
v2=C22A484EB902481EB3E808FE11FD5AA5
IP address: 192.168.10.11
Found user ok
Name=******
Found Alz ok
Alz=89000000000

---

so im guess its exe issue but problem is there is two shop links in exe how am i to change them correct with out having the link compromised %20%20
btw are you guys aware that the exe sends data to several links whiles your playing the game open the exe in hex and see what im talking.. multiple links in exe for one thing or another we need to find way to change link direction .

Quote:

---

Originally Posted by Advocate

Code:

---

User data=v1=%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2012&v2=C22A484EB902481EB3E808FE11FD5AA5
v1= 12
v2=C22A484EB902481EB3E808FE11FD5AA5
IP address: 192.168.10.11
Found user ok
Name=******
Found Alz ok
Alz=89000000000

---

so im guess its exe issue but problem is there is two shop links in exe how am i to change them correct with out having the link compromised %20%20
btw are you guys aware that the exe sends data to several links whiles your playing the game open the exe in hex and see what im talking.. multiple links in exe for one thing or another we need to find way to change link direction .

---

@Advocate

You only need to replace one address, the very 1st one. The address is like this :-

http://shop.cabal.ogplanet.com/cabal...fault.aspx?v1=

The 2nd address you just ignore it.

i got it working but i feel little objective about this script. simple fact of it is that any gm can add anything to the shop even tho us developers try to keep our server secured by adding trust worthy gm but no matter how trust worthy a person may seem there are always will be corruptible gm that will
a.give items out to firends
b.sell items in game for real cash trying to make side profit off server. this script needs to be revamped to only allowed the administrator to add and remove items from shop.

Quote:

---

Originally Posted by Advocate

[CODE]btw are you guys aware that the exe sends data to several links whiles your playing the game open the exe in hex and see what im talking.. multiple links in exe for one thing or another we need to find way to change link direction .

---

Yes the exe has a few links in it for features we don't have, it doesn't use the addresses but you can blank them if you want to be sure it can't use them. There are 2 addresses for the cash shop too, one for the "live" cash shop and one for a LAN address which i assume they use for testing.

Quote:

---

Originally Posted by Advocate

i got it working but i feel little objective about this script. simple fact of it is that any gm can add anything to the shop even tho us developers try to keep our server secured by adding trust worthy gm but no matter how trust worthy a person may seem there are always will be corruptible gm that will
a.give items out to firends
b.sell items in game for real cash trying to make side profit off server. this script needs to be revamped to only allowed the administrator to add and remove items from shop.

---

Yes i am aware of this. This is only the initial beta and it was designed to be as simple as possible rather than padding it out with whole chunks of code that weren't really necessary and could lead to further bugs until the most important bits are fully tested. A simple "are you a GM" check was far quicker than writing a true authentication method to just allow specific people in, but if you know any php at all it is very very simple to mod it.

webshop.php and admin.php:

Code:

---

$r=mssql_query('select * from '.DB_GAM.'.dbo.cabal_character_table where CharacterIdx between '.$v1.' * 8 and '.$v1.' * 8 + 5 and nation=3');

---

What this does is check the connecting person's UserNum (v1) and checks if any of their chars are GMs, if so then they are allowed.

Those queries control whether the admin button shows up and whether you can access the admin panel. To let just 1 account in you could just check the v1 manually instead of using mssql

Code:

---

$r=mssql_query('select * from '.DB_GAM.'.dbo.cabal_character_table where CharacterIdx between '.$v1.' * 8 and '.$v1.' * 8 + 5 and nation=3');
if (mssql_num_rows($r)>0) $is_gm=true;

---

Just remove both lines and replace with this (assuming your UserNum is 4):

Code:

---

if ($v1==4) $is_gm=true;

---

If you wanted more people to access you just need to find something they have in common for the query, or cheat...

Code:

---

$r=mssql_query('select * from '.DB_ACC.'.dbo.cabal_auth_table where UserNum='.$v1.' and Gender=1');

---

Normally the gender field in our account db auth table isn't used (maybe use the country table if you do) so i can set it to 1 for all of my trustworthy GMs and now it will only let them in.

I am adding more controls so this can be more easily done, but hey this is beta 1 and i don't expect it to be perfect yet as i'm far from done with this.

The real question is why anyone would have a GM they couldn't trust :ott1:

Quote:

---

The real question is why anyone would have a GM they couldn't trust

---

well thats true but the main question is a developer you have known for years all of sudden, decides to connect your dedicated server delete everything on the server including removing database server, then on top of that adds shutdown.bat to c:drive so everytime you start dedicated back up the bat will force the dedi to shut back down.. it has happen sadly . and never can tell who you really can trust with anything any more i have come to learn development of any type can be a cutthroat business .

@Sir chumpy

how to solve this?

Code:

---

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 127.0.0.1 in C:\xampp\htdocs\underworld\ugn\index.php on line 18
Could not connect to MSSQL database.

---

Updated:

*Problem Solved Thanks*

@Sir chumpy help me

i have Problem



:?::?::?::?::?::?:

Quote:

---

Originally Posted by khamgames

@Sir chumpy help me

i have Problem



:?::?::?::?::?::?:

---

It is connecting to the shop ok and it is able to find your user but it can't find your warehouse alz table. Have you actually been to the warehouse and put something in there? New chars don't automatically get a warehouse table and you have to do the intro quests and speak to the warehouse npc to get a warehouse account.

Thanks a lot for the quick replies

New beta posted. Check the readme for upgrade instructions :P