i have isntalled this on my server and made all new user to be premium for 1 month.
In the bank alz everybofy haz 999999999999.How do y change this?
i have isntalled this on my server and made all new user to be premium for 1 month.
In the bank alz everybofy haz 999999999999.How do y change this?
It's a glitch in chumpywumpys shop. Basically you can get any amount of Alz you want (both ingame and in the shop).Originally Posted by Popa Andrei
I fixed it a while ago, but I can't find the post.
What do you intend to do with the Alz? Delete all Alz from every user? Easy:
Just replace /*Your database*/ with the name of database where the Bank table is located.Code:USE /*Your database*/ UPDATE [dbo].[Bank] SET Alz = 0
Edit:
Yarr, I guess my modified page is gone >_< Anyway, I made a quick patch for the account.php, here's the difflogg:
http://pastebin.com/diff.php?i=331nJKQp
And here's the copypasta version:
http://pastebin.com/331nJKQp
Cheers
Last edited by Alphakilo23; 21-04-11 at 07:29 PM.
1/is this page being developed anymore?
---------- Post added at 03:44 AM ---------- Previous post was at 03:05 AM ----------
2.chumpy can you give more details about the items field whe adding an item?
3.I am ussing xampp with mssql extension activated.I can create items in the shop,i can transfer alz to bank and i can byu but in the game when i want to recive the item i bought i recive "item implementation failed" error.The logs show this
anyone please help me.I am strugeling over 20 hours to solve thisCode:[Thu Apr 28 2011 23:45:17.118312 4128598928]: Database Connect success! [Thu Apr 28 2011 23:49:47.180692 4076149648]: Database Connect success! [Thu Apr 28 2011 23:53:06.894136 4097129360]: Database Connect success! [Thu Apr 28 2011 23:54:47.180364 4107619216]: Database Connect success! [Thu Apr 28 2011 23:55:17.215563 4065659792]: Database Connect success! [Fri Apr 29 2011 00:30:17.444961 4160068496]: Database Connect success! [Fri Apr 29 2011 21:37:13.639901 4160071376]: accept success 22(178.162.192.176:4280) [Fri Apr 29 2011 21:37:13.640562 4160071376]: 4.open user 22 [9E63B78] (178.162.192.176) [Fri Apr 29 2011 21:37:13.640686 4160071376]: 4.close user 22 [9E63B78] (178.162.192.176) [Sat Apr 30 2011 00:48:11.316973 4128598928]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:48:11.317103 4128598928]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:48:11.317118 4128598928]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:48:11.317129 4128598928]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:48:11.317140 4128598928]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:48:11.317150 4128598928]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:48:11.325387 4128598928]: Database Connect success! [Sat Apr 30 2011 00:48:37.868593 4160068496]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:48:37.868621 4160068496]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:48:37.868633 4160068496]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:48:37.868644 4160068496]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:48:37.868654 4160068496]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:48:37.868665 4160068496]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:48:37.878678 4160068496]: Database Connect success! [Sat Apr 30 2011 00:56:09.263631 4128598928]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:56:09.263667 4128598928]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:56:09.263679 4128598928]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:56:09.263690 4128598928]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:56:09.263701 4128598928]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:56:09.263712 4128598928]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:56:09.269822 4128598928]: Database Connect success! [Sat Apr 30 2011 00:56:18.167390 4107619216]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:56:18.167429 4107619216]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:56:18.167441 4107619216]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:56:18.167452 4107619216]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:56:18.167463 4107619216]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:56:18.167494 4107619216]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:56:18.173164 4107619216]: Database Connect success! [Sat Apr 30 2011 00:56:19.171230 4097129360]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:56:19.171257 4097129360]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:56:19.171269 4097129360]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:56:19.171280 4097129360]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:56:19.171291 4097129360]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:56:19.171302 4097129360]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:56:19.177128 4097129360]: Database Connect success! [Sat Apr 30 2011 00:56:58.869315 4160068496]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:56:58.869343 4160068496]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:56:58.869355 4160068496]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:56:58.869366 4160068496]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:56:58.869377 4160068496]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:56:58.869387 4160068496]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:56:58.875035 4160068496]: Database Connect success! [Sat Apr 30 2011 00:57:04.870620 4160068496]: [##ERROR##] OnIPCRecoverUseCashItem fail [Sat Apr 30 2011 00:57:04.870646 4160068496]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state [Sat Apr 30 2011 00:57:04.870658 4160068496]: [##ERROR##] DB ERROR(CODE) : 0 [Sat Apr 30 2011 00:57:04.870669 4160068496]: [##ERROR##] DB ERROR(VAR_INFO) : [Sat Apr 30 2011 00:57:04.870680 4160068496]: [##ERROR##] DB ERROR(SQLSTATE) : 24000 [Sat Apr 30 2011 00:57:04.870691 4160068496]: [##ERROR##] DB ERROR(STM_TEXT) : {call up_RecoverUseMyCashItem( ? , ? )} [Sat Apr 30 2011 00:57:04.877523 4160068496]: Database Connect success!
Last edited by xXxAxXx; 01-05-11 at 06:18 AM.
What item duration you used. We had a few problems with permanent duration types you could try searching for an answer on the forums.
i tried default and 31 but the same thing.
[SOLVED]http://forum.ragezone.com/f451/solved-cant-recive-item-chumpy-747184/
Last edited by xXxAxXx; 01-05-11 at 03:05 PM.
Hi!
I can not take out the item.
What's wrong?
Thank you in advance for your help!
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\index.php on line 26
include('config.php');
$link = mssql_connect(DB_ADDR, DB_USER, DB_PASS);
if (!$link) die('Could not connect to MSSQL database.');
if ($uid<>'' && $pwd<>'') {
$r=mssql_query('select ID,UserNum,AuthKey from '.DB_ACC.'.dbo.cabal_auth_table where id="'.$uid.'" and password="'.$pwd.'"');
if (mssql_num_rows($r)==0) {
header('Refresh: 4; URL='.PAGE_INDEX);
html_header('Login failed...');
echo 'Login Failed...';
exit;
} else {
$row = mssql_fetch_row($r);
$_SESSION['player']=$row[0];
$_SESSION['v1']=$row[1];
$_SESSION['v2']=$row[2];
header('Refresh: 1; URL='.PAGE_INDEX);
html_header('Logging in...');
echo 'Logging in...';
exit;
where is error...
Make sure your php.ini includes mssql extension.
run the scrips in the database that are with the site and it will work :)
and if you use number 2 in world let the config file read world number 2 to
Last edited by wesley2811; 29-07-11 at 11:03 PM.
Fatal error: Call to undefined function mssql_connect() in C:\XXXXX\XXXXXX\index.php on line 30
what is the main problem on that .
100% sure my db username and password correctly
Thank yours for help
you webhost doesent support mssql connection.
If you host the site on windows with xampp or other webhost server be shure that you have mssql extension activated in php.ini(google for how to do it if you dont know how)
Sorry, but I do not understand this step, can you explain me with more details, like "which is the hex editor that should I use, how to save, etc"?5. Open cabalmain.exe in a hex editor and look around 0x3dee8c. The actual address
will be different for different cabalmain.exes but the string you are looking
for (assiming it hans't been changed already) is:
http://shop.cabal.ogplanet.com/cabal...fault.aspx?v1=
Once you have found the string is being used for the cash shop address and replace:
http://www.myserver.com/webshop.php?v1=
The string must be properly zero terminated and cannot be longer than 63 chars
unless you know how to relocate the string in the exe.
To see exactly what address the client is using hit the cash shop button in
game. Right-click and select Properties. That will help you find it in the exe
using a search ;)
Thanks anyways!
"a hex editor" = any hex editor...
Hey Yamachi!
I used "neo hex editor" but whem I hit save, I cant open the .exe, returns an error saying that "It's not a valid windows executable program" or something like.
Can you help me becouse the web app shop is working, server is configured to run with the shop but, I still can't look the items becouse I can't change the URL for the shop on the client.
Thanks man.
-----------------------------------------------------------------------------------------------------------------
Oh, nevermind guys!!
I got it
Thank you!
Last edited by dezon; 27-09-11 at 02:33 AM.
Yooh... mrChump... I wanna use the transfer function but instead of warehouse alz to cashbank I want CabalCash cash credit to CashBank... Is that possible? cuz I see CabalCash use UserID while CashShop use UserNum for authentication...
That what happened after this: "Unable to load dynamic library php_mssql.dll, specified module could not be found."
So i added php_mssql.dll after that apache didn't start anymore, sad.
In newer versions u need to use php_dblib.dll give a search to that.
had anyone ever tried to add another bank system instead of alz?
If yes pleas post and tell me what had you manage to do.I want to make the site have the option of alz and cash.
This stuff is easy but to do it well you need a good PHP dev who knows payment systems. If you have one he won't need help at all.
Easymode is paypal buy buttons and manual editing to do the bank.
https://www.paypal.com/cgi-bin/websc...chview_outside
I will never make the cash shop work with real money as it goes against my basic principle of "free"
download links broken
You have any idea how to make each player to choosing thT-Te nation from user panel ?? please help me :(
Last edited by Yamachi; 05-12-11 at 10:11 AM.
Hello and thanks for the input, but I have a question, it happens to me all the page works fine, I made the shipping and all, but the problem happens when I receive the item, I get the failed item the reception of some help ?
check in cashshop the table dbo.ShopItems column "ID" to be in order 1,2,3,4,5....etc,not 12341234 thats why you receive different item
I dont understand how to fix that config.php always getting
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\index.php on line 26
edited the config file?
because there is something wrong. Db password or user name or IP
Reply With Quote