Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 242 online users. » 0 Member(s) | 240 Guest(s) Bing, Google
|
Latest Threads |
Liberty City map
Forum: Pawn Scripting
Last Post: ziyadprogamer
2025-06-28, 04:55 PM
» Replies: 2
» Views: 2,126
|
GameText styles in open.m...
Forum: Pawn Scripting
Last Post: Miki
2025-06-28, 01:25 PM
» Replies: 1
» Views: 40
|
Very Basic SAMP UCP
Forum: Videos and Screenshots
Last Post: bullyalina
2025-06-28, 12:43 PM
» Replies: 49
» Views: 12,846
|
Script[gamemodes/gamemode...
Forum: Pawn Scripting
Last Post: Miki
2025-06-27, 05:08 PM
» Replies: 1
» Views: 425
|
Want to edit my profile n...
Forum: Chat
Last Post: Hera.
2025-06-26, 08:41 PM
» Replies: 1
» Views: 544
|
Farsi
Forum: Other
Last Post: acc.gangbeni
2025-06-25, 08:21 AM
» Replies: 2
» Views: 3,060
|
Las Venturas Gang Wars - ...
Forum: Advertisements
Last Post: lvgwgta
2025-06-22, 06:47 PM
» Replies: 0
» Views: 51
|
[Request] Linko Gaming Ro...
Forum: General Discussions
Last Post: JamesC
2025-06-20, 07:34 PM
» Replies: 0
» Views: 65
|
RevolutionX DM/Stunt/Race...
Forum: Advertisements
Last Post: DerekZ905
2025-06-18, 03:12 PM
» Replies: 0
» Views: 87
|
samp-cef
Forum: Questions and Suggestions
Last Post: jamespssamp
2025-06-18, 11:36 AM
» Replies: 0
» Views: 70
|
|
|
cache_insert_id always return 0 |
Posted by: Axitz - 2022-03-30, 07:41 AM - Forum: Pawn Scripting
- Replies (5)
|
 |
Hi, sorry how bad this was.
I've created a team and the table is also is AI mode. There are multiples team in the query but whenever server restart or player quit, then create team, it always started at 0 again.
PHP Code: forward TeamCreated(b); public TeamCreated(b) {
? ? TeamInfo[b][TeamID] = cache_insert_id(); ? ? teamidd; ? ? printf("New Group is created: [%d]", teamidd ); }
PHP Code: if(strcmp(usage, "create", false) == 0) { ? ? if(!strlen(usage1)) return SCP(playerid, "create <teamname>"); ? ? if(strlen(usage1) < 5 || strlen(usage1) > 30) return SendClientError(playerid, "Your team name is too short or too long! (Min 5, Max 30 chars)"); ? ? new tmID = teamidd; ? ? if(PlayerInfo[playerid][tplayerteam] != -1) return SendClientError(playerid, "You are already in a team. /team leave"); ? ? TeamInfo[tmID][TeamID] = tmID; ? ? PlayerInfo[playerid][tplayerteam] = tmID; ? ? PlayerInfo[playerid][tranklvl] = 0; ? ? myStrcpy(PlayerInfo[playerid][TPTeamName],usage1); ? ? myStrcpy(PlayerInfo[playerid][trankname],"Children"); ? ? TeamInfo[tmID][TActive]=true; new sQuery[528]; mysql_format(sqldb, sQuery, sizeof sQuery, "INSERT INTO `TeamInfo` (`TeamID`, `TeamName`, `StartRank`) VALUES (%d,'%e', 'Children')",tmID,usage1); mysql_tquery(sqldb, sQuery, "TeamCreated", "i",tmID); } else { SCP(playerid, "<create> <input>"); } return 1; }
|
|
|
Which one is better? |
Posted by: Zow - 2022-01-26, 09:29 PM - Forum: Pawn Scripting
- Replies (2)
|
 |
PHP Code: #define SendErrorMessage(%0, %1) SendClientMessage(%0, COLOR_RED, "[*]{FFFFFF} "%1)
PHP Code: SendErrorMessage(playerid, const msg[]) {
? ? new
? ? ? ? string[145];
? ? format(string, sizeof(string), "[*]"C_WHITE" %s", msg);
? ? return SendClientMessage(playerid, COLOR_RED, string);
}
I just want to know how different
|
|
|
MySQL Query |
Posted by: Slade - 2022-01-24, 04:55 PM - Forum: Pawn Scripting
- Replies (1)
|
 |
So basically i've done so many scripts using MySQL, but never had this problem and simply not finding way to solve it because i don't even understand why it happens.
I will explain here, I don't really need to post code since my other scripts with literally same code works great, I also tried to google it, but no luck.
So this is case: I've switched House system on old gamemode from Dini to MySQL. I've switched data by loading with Dini, saving with MySQL. Then i created loading. First I have used TQuery with callback, and got this errors:
Code: [01/24/22 17:50:46] [plugins/mysql] cache_get_value_name_float: no active cache (C:\Users\llc\Documents\GM\gamemodes\YUBGM.pwn:24580)
[01/24/22 17:50:46] [plugins/mysql] cache_get_value_name_float: no active cache (C:\Users\llc\Documents\GM\gamemodes\YUBGM.pwn:24581)
[01/24/22 17:50:46] [plugins/mysql] cache_get_value_name_float: no active cache (C:\Users\llc\Documents\GM\gamemodes\YUBGM.pwn:24582)
This happens for every row in every iteration of cache num rows, table has around 1100 houses.
I've done it also with mysql_query and cache variable, same error appears.
Updated MySQL to latest version.
Changed variable names from?cache_get_value_name_float to?cache_get_value_float but still the same.
Important thing is: I printed second row after every iteration and cache function, and first 2 rows are getting loaded, and all others are not.
So yes i got 2 first selected rows loaded, others are literally ignored in loop.
Any possible solutions ?
|
|
|
Desolation Roleplay |
Posted by: Awide - 2022-01-21, 05:11 PM - Forum: Gamemodes
- Replies (1)
|
 |
Written 99.5% by me entirely from scratch. Put countless days and?nights into this gamemode.
Featuring NPC zombies, bandits, looting, factions, cities, inventory, item system, housing and businesses. I made it work on both Linux and Windows servers.
I am not willing to provide support nor answer questions. If you need the database (otherwise you cannot use the inventory and looting) PM me (DC: Awide#0896) and I will?consider your offer.
Otherwise, enjoy!
https://github.com/Awide/Desolation-SAMP
|
|
|
Problem with plugin development |
Posted by: Davee52 - 2022-01-18, 11:41 AM - Forum: Programming
- No Replies
|
 |
Hy everybody! I followed the instructions in the Plugin Development topic on the site, and I get errors as I include the invoke.hxx . I downloaded it on the link, added the file to the project, and included it in the code, but it gives me these errors:
https://imgur.com/a/Yamr46K
Thank you if you could lead me to success.
|
|
|
|